Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection from oracle cliente 10g to RAC with 2 nodes

623286Oct 7 2009 — edited Oct 9 2009
hello, i need your help

I´m trying to configure a connection from my oracle client 10g in Windows XP with a Oracle Rac Database 10G R2. The cluster database have 2 nodes, when i put the connection string in the TNSnames.ora file in the side my oracle client, i achieve connect the first time, but, de second time not success because appears the error "ORA-12545: the connection failed because the host destiny or the object don´t exist". I'm triyig to fix this error and I'm reding articules about connections, bust i don´t resolve the problem.

The connection string in the TNSnamse. ora in the side client and the side servers nodes of cluster is it:

PR_TAF =
(DESCRIPTION =
(ENABLE = BROKEN)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = A.B.C.D)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = A.B.C.D)(PORT = 1521))
)
(LOAD_BALANCE = ON)
(FAILOVER = ON )
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pr_taf)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2009
Added on Oct 7 2009
3 comments
2,364 views