Home » RDBMS Server » Server Administration » ora 12505 (oracle 10g)
ora 12505 [message #406956] Mon, 08 June 2009 00:16 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi i have created new undo tablespace and updated that to old one and now i have dropped old unto tablespace as it occupied more than 5 gb.after doing so i am not able to connect to my oracle instance with orcl.

now i am getting exception as

ora 12505:

TNS:listener does not currently know of SID given in connect descriptor

can anyone tell me why it happend like this.
what i can do to work with my oracle?
Re: ora 12505 [message #406959 is a reply to message #406956] Mon, 08 June 2009 00:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL*NET & TNS is NOT required to connect to the database.
Re: ora 12505 [message #406963 is a reply to message #406959] Mon, 08 June 2009 00:30 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
conn system/manager@orcl

ora 12505:

TNS:listener does not currently know of SID given in connect descriptor

conn system/manager@orcl1

ora 12505:

TNS:listener does not currently know of SID given in connect descriptor

where i am having two instances in my pc.
Re: ora 12505 [message #406964 is a reply to message #406956] Mon, 08 June 2009 00:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL*NET & TNS is NOT required to connect to the database.

what is OS name & version?
Re: ora 12505 [message #406966 is a reply to message #406956] Mon, 08 June 2009 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And there is no relation between UNDO tablespace and your error.

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a SID for an instance (usually a database instance) that either
 has not yet dynamically registered with the listener or has not been
 statically configured for the listener. This may be a temporary condition
 such as after the listener has started, but before the database instance
 has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.


Regards
Michel
Re: ora 12505 [message #407055 is a reply to message #406966] Mon, 08 June 2009 05:33 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi this is what my entire ora files available in network\admin foleder



# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Raja)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl1)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Raja)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = Raja)(PORT = 1521))
    )
  )
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

iam facing with orcl instance only not with orcl1
those are the details available on.




[Updated on: Mon, 08 June 2009 05:34]

Report message to a moderator

Re: ora 12505 [message #407056 is a reply to message #407055] Mon, 08 June 2009 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As you can see your listener is not listening for orcl.

Regards
Michel
Re: ora 12505 [message #407058 is a reply to message #407056] Mon, 08 June 2009 05:38 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
D:\>lsnrctl services

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-JUN-2009 15:43:37

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "orcl1" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:8 refused:0 state:ready
         LOCAL SERVER
Service "orcl1XDB" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1002 state:ready
         (ADDRESS=(PROTOCOL=tcp)(HOST=Raja)(PORT=1708))
Service "orcl1_XPT" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:8 refused:0 state:ready
         LOCAL SERVER
The command completed successfully
Re: ora 12505 [message #407070 is a reply to message #407058] Mon, 08 June 2009 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 08 June 2009 12:35
As you can see your listener is not listening for orcl.

Regards
Michel


Re: ora 12505 [message #407262 is a reply to message #407070] Tue, 09 June 2009 06:23 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
That there is no explicit entry in the listener shouldn't matter - the database should dynamically register itself in 10g.

Check the database alert log - is the database definitely up, or did something (such as your change to the Undo tablespace) prevent it from starting up?

Previous Topic: How to modify Freelist Groups while moving from Non-RAC to RAC database in 10g (merged 4)
Next Topic: How can change SYS password and back if we have Windows Admin account
Goto Forum:
  


Current Time: Fri Nov 29 13:44:47 CST 2024