Home » RDBMS Server » Networking and Gateways » ORA-12545: Connect failed because target host or object does not exist (Oracle Database RAC 10.2.0.3, OS: IBM AIX)
icon5.gif  ORA-12545: Connect failed because target host or object does not exist [message #294931] Sun, 20 January 2008 23:06 Go to next message
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 #294942 is a reply to message #294931] Sun, 20 January 2008 23:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-12545: Connect failed because target host or object does not exist
Cause: The address specified is not valid, or the program being connected to does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.

Regards
Michel
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 Go to previous messageGo to next message
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
Re: ORA-12545: Connect failed because target host or object does not exist [message #294964 is a reply to message #294959] Mon, 21 January 2008 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for network or DNS problem.
Activate sqlnet trace.

Regards
Michel
Re: ORA-12545: Connect failed because target host or object does not exist [message #294968 is a reply to message #294931] Mon, 21 January 2008 01:01 Go to previous messageGo to next message
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
Junior Member
Hi Michel,

May I know how to enable sqlnet tracing.

Kiran
Re: ORA-12545: Connect failed because target host or object does not exist [message #294972 is a reply to message #294968] Mon, 21 January 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Net Services Administrator's Guide
Chapter 16 Troubleshooting Oracle Net Services
Section Tracing Error Information for Oracle Net Services

Regards
Michel
Re: ORA-12545: Connect failed because target host or object does not exist [message #295002 is a reply to message #294931] Mon, 21 January 2008 02:27 Go to previous messageGo to next message
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
Junior Member
Hi All,

It is working now.....

I created database link as follows...

create database link WEBDB_LIVE
connect to SEI
using '(DESCRIPTION =
(ADDRESS_LIST =
(LOADBALANCE = OFF)
(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)
)
)';

Regards,
Kiran
Re: ORA-12545: Connect failed because target host or object does not exist ----- worked [message #295009 is a reply to message #294931] Mon, 21 January 2008 02:36 Go to previous message
jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007
Junior Member
worked
Previous Topic: ORA-20000 while using FTP
Next Topic: Unable to understand
Goto Forum:
  


Current Time: Thu Dec 08 00:23:58 CST 2016

Total time taken to generate the page: 0.07690 seconds