ORA-12545: Connect failed because target host or object does not exist
Dears;
kindly I have a stange problem , I have database 9i version 9.2.0.7.0
I created database link to RAC database as below :
CREATE DATABASE LINK "TRC_TO_RTX.US.ORACLE.COM" CONNECT TO
"IVR"
IDENTIFIED BY "********"
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
10.1.111.190)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.111.191)(PORT = 1521))
(LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = RTXPROD)))'
when trying to query data by this db link I got ORA-12545: Connect failed because target host or object does not exist , but this error some times occured and sometime not. although these IP addresses is reachable
I made a test as follow :
I created db link to single database not RAC as
CREATE DATABASE LINK "TRC_TO_RTX.US.ORACLE.COM4" CONNECT TO
"IVR"
IDENTIFIED BY "********"
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
10.1.111.191)(PORT = 1521))
(LOAD_BALANCE = NO) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = RTXPROD))
)'
the same thing happened! sometimes worked and sometimes not (I got ORA-12545 ).
if you have any Idea what happining with this please help me.
regards.