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"
Please advice,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) ) ) )




Reply With Quote