I try to create connection in SQL Developer. The following error occurs: ORA-12505: TNS: listener

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\app\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )

ADR_BASE_LISTENER = C: \ app

tnsnames.ora

 ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) SYSDBA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sysdba) ) ) LISTENER_SYSDBA = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  • write what is in listener.ora on the server and tnsnames.ora on the client. The problem in SID is clear - MajorMeow
  • The forum has already had such a question . I hope he will help. - MajorMeow
  • Unfortunately it did not help. - Julia
  • And in the developer, what server name do you drive in? Here is a certain serive_name in SYSDBA. instead, write the SID. The last lines are generally strange. what LISTENER_SYSDBA - Mike
  • In the server name do not write anything. Changed to SID, did not help. - Julia

0