OraFAQ Forum: Networking and Gateways » ORA-12545: Connect failed because target host or object does not exist

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Report message to a moderator

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Search for network or DNS problem.
Activate sqlnet trace.

Regards
Michel

Report message to a moderator

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

jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007

Junior Member

Hi Michel,

May I know how to enable sqlnet tracing.

Kiran

Report message to a moderator

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007

Junior Member

worked

Report message to a moderator

Previous Topic:	ORA-20000 while using FTP
Next Topic:	Unable to understand

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 05:57:45 CDT 2025