Hi Experts;
I'm trying to create a DB link, in the past, I created two of them, but in oracle 9i, now I got Oracle 10g, RAC (2 nodes).
I created this db link, but when I tried to connect I get this error.
Error: ORA-12170: TNS: Connect timeout occured.
I get this error after some 2 minutes trying to connect, however, I can connect without any problem thru Oracle SQL Developer, Toad, and SQLPLus.
This was my original script.
CREATE PUBLIC DATABASE DBSLE_MYDBCAS
CONNECT TO MYDBCAS
IDENTIFIED BY <PWD>
USING 'MYDBCAS';
After this error, I was looking for an idea in the forums, and I changed the script using the values in the tnsname, and now the script is this:
CREATE PUBLIC DATABASE LINK DBSLE_MYDBCAS
CONNECT TO MYDBCAS
IDENTIFIED BY <PWD>
USING '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.XXX.XX.8)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.XXX.XX.9)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MYDBCAS)))';
But still, when I executed it, I get the same error.
Error: ORA-12170: TNS: Connect timeout occured
Any idea in how to solve this situation, will be appreciated.
Best Regards
Al