ORA-12545: Connect failed because target host or object does not exist
Hi,
I have an Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.
I activated the DRCP on the server and modified the tnsnames.ora, creating 3 new entries to manage the pooled connection type:
EVODB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EVODB)
)
)
EVODB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EVODB)
(INSTANCE_NAME = EVODB1)
)
)
EVODB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EVODB)
(INSTANCE_NAME = EVODB2)
)
)
EVODB_POOLED =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = EVODB)
)
)
EVODB1_POOLED =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = EVODB)
(INSTANCE_NAME = EVODB1)
)
)
EVODB2_POOLED =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
(CONNECT_DATA =
(SERVER = POOLED)
(SERVICE_NAME = EVODB)
(INSTANCE_NAME = EVODB2)
)
)
All entries are working fine but EVODB_POOLED.
When I used that one I got the ORA-12545.
But not always! After 3 or 4 tries I can connect to the database:
C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:24 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:26 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:28 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:30 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
With the Real Application Clusters option
SQL>
Do you have any idea about the problem?
Thanks in advance,
Samuel