 ORA-12545: Connect failed because target host or object does not exist [message #294931] |
Sun, 20 January 2008 23:06  |
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
|
Junior Member |
|
|
Hi All,
I created a database link as follows
create database link WEBDB_LIVE
connect to SEI
using '(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.201)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WHPROD)
)
)';
I am getting this error, but finally it getting succedded after sevaral attempts.
how to avoid this error.. My database are in RAC environment.
ORA-12012: error on auto execute of job 142
ORA-12545: Connect failed because target host or object does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
My database version is : 10.2.0.3
OS : IBM AIX 5.3 ML 05
even i am getting this error from my client machine. I am sending the tns entries .
WHPROD =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.201)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.200)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME =WHPROD)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic)
(RETRIES=20)
(DELAY=15)
)
)
)
Any body can help me....
Regards,
Kiran
|
|
|
|
|
|
| Re: ORA-12545: Connect failed because target host or object does not exist [message #294959 is a reply to message #294931] |
Mon, 21 January 2008 00:49  |
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
|
Junior Member |
|
|
Hi Michel,
I am able to connect some times. The connection establishment is intermittent.
C:\>sqlplus sei/XXXXXX@whprod
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 21 14:50:35 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64
bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
C:\>sqlplus sei/XXXXXX@whprod
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 21 14:50:46 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
help me...
Kiran
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
