RAC node service lost [message #280412] |
Tue, 13 November 2007 08:07 |
mwansalovewell
Messages: 71 Registered: October 2007 Location: uk
|
Member |
|
|
im using 10gr2 rac and two nodes, on one node i can connect 1,2,3 or 4 time and then at some time i get
> ORA-12545: Connect failed because target host or object does not exist
This is happening everytime. I can connect and after sometime is get the above error.
Is there some configuration problems on my listener or tnsnames file on my client.
live1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.56.1.127)(PORT = 1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.56.1.128)(PORT = 1523))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = live1)
)
)
on the other node i dont get this problem.
|
|
|
Re: RAC node service lost [message #286681 is a reply to message #280412] |
Sun, 09 December 2007 17:06 |
philflorent
Messages: 3 Registered: December 2007 Location: Lille (France)
|
Junior Member |
|
|
You should check the parameters LOCAL_LISTENER of the instances. Clients have to be able to resolve the "host" part of the parameters LOCAL_LISTENER : use the VIPs.
|
|
|