![]() (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) The entries as created using Oracle's Database Configuration Assistant were originally: MYDATABASE = Showed that the names didn't match exactly. Next, running the command from Brad Rippe's answer: select value from v$parameter where name='service_names' Set ORACLE_HOME=C:\Oracle\product\11.2.0\dbhome_1Īnd then connecting using sqlplus / as sysdba First, I was able to connect to the database by setting the environment variables (Windows): set ORACLE_SID=mydatabase In my case, the installation and configuration of the databases put entries in the tnsnames.ora file for the databases I was running. This really should be a comment to 's answer, but alas, not enough rep. And to make it recognize a service name of orcl, you might change it to: # listener.ora Network Configuration File: C:\app\oracle_user\product\12.1.0\dbhome_1\network\admin\listener.ora (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) # Generated by Oracle configuration tools. Now all is well.įor example, your listener.ora file might initially look like: # listener.ora Network Configuration File: C:\app\oracle_user\product\12.1.0\dbhome_1\network\admin\listener.ora I added the problem Service Name, then in Windows "Services" control panel, I did a "Restart" on the Oracle listener service. The "SID_LIST" is just that, a list of SIDs and service names paired up in a format you can copy or lookup. But where does it keep service names? In %ORACLE_HOME%\NETWORK\ADMIN\listener.ora ![]() The error, if looked at directly, indicates that the listener does not recognize the service name. It took me a day of research, but I found the simplest solution, at least in my case (Oracle 11.2 on Windows 2008 R2) and wanted to share. I know this is an old question, but still unanswered.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |