ORA-12514 with Real Application Cluster

Hi All,
I have RAC with 2 nodes which are Oracle 10.2.0.3 on Linux Servers.

As soon as I reboot one of the instances, I am not able to connect to the database any more and getting error message:

"ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

Code:

---

RACTEST =
        (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.7)(PORT = 1521))
                (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.9)(PORT = 1521))
                (LOAD_BALANCE = yes)
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = orcltest)
                (FAILOVER_MODE =
                        (TYPE = SELECT)
                        (METHOD = BASIC)
                        (RETRIES = 180)
                        (DELAY = 5)
                )
        )
)

---

Please advice,

http://ora-12514.ora-code.com/

Thank you for your reply. I treid to restart listener as well, but it did no make any change - only Linux Cluster restart helps to solve the problem - but this can't be a solution. I think that after a instance reboot something start to go wrong ... but in the same time after reboot instance get registered in the listener.

Hi

You need to check your listener.ora file on both the nodes.

Also check with

lsnrctl serv

both nodes should know of the services that are running on each other.

when the instance comes up they should register itself with the listener this is by default if you use the port 1521 or you should use the local_listener and remote_listener parameter in spfile.

check this
http://tardate.blogspot.com/2007/06/...u-run-rac.html

the ip adresses on the client side 192.168.40.7 should be vip

regards
Hrishy

did u check the networks.The servers are pinging or not ?

Thank you for your reply. Please see attached output.
I am not sure, but I think, SERVICE_NAME = orcltest did not get registered after instance reboot.

Quote:

---

Originally Posted by hrishy

Hi

................

check this
http://tardate.blogspot.com/2007/06/...u-run-rac.html

the ip adresses on the client side 192.168.40.7 should be vip

regards
Hrishy

---

Yes, it is VIP, I'll check the article ...

Hi

How did you create the service.
Whats the status of the service as reported by the clusterware

Code:

---

srvctl status service -d ORCL -s orcltst

---

if the service is not started start it

Code:

---

srvctl start service -d orcl -s RAC

---

regards
Hrishy

Thank you Hrishy!
It did the trick.