Thursday 21 March 2013

FIX- ORA-12505




 FIX- ORA-12505


Solution:

 Had a service name “ORCL” ,When I tried connect to that service it always gave
ORA-12505, TNS:listener does not currently know of SID given in connect …
So I edited the listener.ora, added one more SID_DESC, restarted the listener. Now I can connect to the “ORCL” database. Below is the updated listener.ora

Before my listener file was

# listener.ora Network Configuration File:/oracle/data/product/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.11.50)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /opt/app/oracle

Solution

Now my listener file looks like :

SID_LIST_LISTENER =

(SID_LIST =

 (SID_DESC =

  (SID_NAME = PLSExtProc)

   (ORACLE_HOME = /oracle/data/product)

    (PROGRAM = extproc)

 )
 (SID_DESC =

  (GLOBAL_DBNAME = orcl)

    (ORACLE_HOME = /oracle/data/product)

     (SID_NAME = orcl)
    

  )
)
LISTENER =

 (DESCRIPTION_LIST =

 (DESCRIPTION =

 (ADDRESS_LIST = 

   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

  )

  (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.11.50)(PORT = 1521))

   )


 )

)
Restarted the listener & error got resolved.




refrence:
http://samadhandba.wordpress.com/2011/06/03/ora-12505-connection-refused-the-specified-sid/

No comments:

Post a Comment