ORA-1205, TNS:listener does not currently know of SID... sqldeveloper
902358Jan 17 2012 — edited Feb 7 2012This topic has been posted before, but it did not solve my problem. I am trying to connect sqldeveloper to Oracle DB 11g. I am using Vista Enterprise sp1. I've connected before, but must have screwed something up because now it doesn't work. I get the error posted in the subject line.
When I installed the database, I created a database (connection name) orcl. I am trying to connect with user SYS as a sysdba role. These are my connection details: sys@//localhost:1521/orcl I am using a basic connection type. My tnsnames.ora file looks like this:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
Can anyone help me with this?