ORA-12505 - TNS: listener does not know of SID Currently

[carlos_henrique]

Good morning,

I have the following error in Oracle:

Select all

ORA-12505, TNS:listener does not currently know of SID given in connect descript.

follow my listener files.ora and tnsnames.ora:
Listener:

Select all

SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_2) 
      (PROGRAM = extproc) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    ) 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) 
    ) 
  )

TNSNames:

Select all

ACX1 = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SID = ACX1) 
      (SERVER = DEDICATED) 
      (SERVICE_NAME ACX1 = ACX1.pctecnote) 
    ) 
  ) 
 
ACX = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
    ) 
  )

The SID of my database is ACX1 .

Thank you very much.
Carlos Henrique

[elidias7]

Good afternoon.

You need to reconfigure your listener and your TNS.

because in the listener by what I have verified the SID is different with the name of the instance that you created

Select all

 (SID_NAME = PLSExtProc) # (SID_NAME = ACX1) 

TNS You need to change the Service Name.

The best thing to be made is to re-create the two files, use the Net Assistent

Hugs,

[gilbertoca]

I have the following error in Oracle:
ORA-12505, TNS: Listener Does Not Currently Know of Sid Given in Connect Descript .

follow my listener.ora and tnsnames.ora:
Listener:

Select all

SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_2) 
      (PROGRAM = extproc) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    ) 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) 
    ) 
  )

[/quote]
]
Correct configuration, no problems here!
This means that you are using a dynamic listener, that is, the listener will be in charge of verifying existing instances and records them dynamically.

TNSNAMES:

Select all

ACX1 = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SID = ACX1) 
      (SERVER = DEDICATED) 
      (SERVICE_NAME ACX1 = ACX1.pctecnote) 
    ) 
  ) 
 
ACX = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.125.50)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
    ) 
  )

Here you will have to provide us with more data. Is this setting on the server itself where Oracle was installed or on a client?
Surely the name of the correct service. To be sure, run the Listener console and check the registered services. In Linux is like this:

Select all

 
lsnodes   lsnrctl   lsnrctl0   
oracle@oracleserver:~> lsnrctl status 
 
LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 10-JAN-2008 09:15:18 
 
Copyright (c) 1991, 2004, Oracle.  All rights reserved. 
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) 
STATUS of the LISTENER 
------------------------ 
Alias                     LISTENER 
Version                   TNSLSNR for Linux: Version 10.1.0.2.0 - Production 
Start Date                18-OUT-2007 16:36:38 
Uptime                    83 days 15 hr. 38 min. 40 sec 
Trace Level               off 
Security                  ON: Local OS Authentication 
SNMP                      OFF 
Listener Parameter File   /opt/oracle/product/10.1.0/db_1/network/admin/listener.ora 
Listener Log File         /opt/oracle/product/10.1.0/db_1/network/log/listener.log 
Listening Endpoints Summary... 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracleserver.DMZ)(PORT=1521))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracleserver.DMZ)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracleserver.DMZ)(PORT=2100))(Presentation=FTP)(Session=RAW)) 
Services Summary... 
Service "PLSExtProc" has 1 instance(s). 
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... 
Service "desenv" has 1 instance(s). 
  Instance "desenv", status READY, has 1 handler(s) for this service... 
Service "desenvXDB" has 1 instance(s). 
  Instance "desenv", status READY, has 1 handler(s) for this service... 
Service "folha" has 1 instance(s). 
  Instance "folha", status READY, has 1 handler(s) for this service... 
Service "folhaXDB" has 1 instance(s). 
  Instance "folha", status READY, has 1 handler(s) for this service... 
The command completed successfully 
oracle@oracleserver:~>  

Gilberto

[elidias7]

Good Morning.
The configuration is correct and has to clean the SID ???
This was legal !! rs


Hugs,

[gilbertoca]

Good morning.
The configuration is correct and has to clean the SID ???
This was legal !! rs

Hugs,

Our server working (24x6):

Select all

 
oracle@oracleserver:~> cat /opt/oracle/product/10.1.0/db_1/network/admin/listener.ora 
# listener.ora Network Configuration File: /opt/oracle/product/10.1.0/db_1/network/admin/listener.ora 
# Generated by Oracle configuration tools. 
 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = /opt/oracle/product/10.1.0/db_1) 
      (PROGRAM = extproc) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
      ) 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521)) 
      ) 
    ) 
  ) 
 
oracle@oracleserver:~>     

Can you explain to me how it works, how did you even mention, with the SID with the wrong name?

"Service Information Registration": http://download.oracle.com/docs/cd/B193 ... sthref1782

Gilberto