Home » Server Options » RAC & Failsafe » ORA-12505: TNS : Listener does not currently know of SID given in connect descripter (ORACLE Database server 10g on Windows 2003 R2 Ent. SP2 Cluster and Oracle Fail Safe)
icon9.gif  ORA-12505: TNS : Listener does not currently know of SID given in connect descripter [message #318258] Tue, 06 May 2008 04:45 Go to next message
edivuser
Messages: 2
Registered: May 2008
Junior Member
My requirement is to create a oracle database server cluster. This is a test environment created using VMware Server Software.

I have installed oracle 10g enterprise edition on a cluster. The cluster contains two server nodes with OS windows 2003 r2 ent. SP2 and updated with all security patches and service packs. Oracle has been installed separately on both nodes.

Steps Taken:-

1) Installed Windows Server on both servers
2) Installed MSCS and configured a cluster called oracle.
3) Installed Oracle database software on each node's local disks, using the same oracle home directory.
4) created an oracle database on one node using the shared disk for storage.
5) installed oracle fail safe on each node in the cluster.
6) configured the cluster using the fail safe manager.

after performing all this operations, the cluster was working fine.. failover test passed and everything was working fine.

Now when testing failover of oracle server, we disconnected the one of the oracle server node from the network...

When we open the Database Enterprise Manager: Database Instance:orcl
It says :

Agent Connection to instance
Status: Failed
Details: ORA-12505: TNS : Listener does not currently know of SID given in connect descripter (DBD ERROR: OCIServerAttach)


I am also attaching the screenshot of the same with this.

Please help ..

regards
Vijay

[Updated on: Tue, 06 May 2008 08:40]

Report message to a moderator

Re: ORA-12505: TNS : Listener does not currently know of SID given in connect descripter [message #318703 is a reply to message #318258] Wed, 07 May 2008 11:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/search/ORA-12505
Unwilling or incapable of using SEARCH function on this forum or GOOGLE?
Re: ORA-12505: TNS : Listener does not currently know of SID given in connect descripter [message #337413 is a reply to message #318703] Wed, 30 July 2008 17:30 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Did u set the ORACLE_SID? ...Very Happy Wink
Previous Topic: Patching in RAC
Next Topic: unable to start both intances on 11g RAC
Goto Forum:
  


Current Time: Thu Mar 28 14:09:48 CDT 2024