Home » Server Options » RAC & Failsafe » ORA-12545: Connect failed because target host or object does not exist (Oracle 10g Enterprise Edition Release 10.2.0.1.0, Oracle Enterprise Linux 4)
ORA-12545: Connect failed because target host or object does not exist [message #407102] Mon, 08 June 2009 07:48 Go to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Dear friends
I am trying to connect my from rman database to target database in our rac enviroment it gives error like this.

RMAN> connect target bms/bms@orcl_taf

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12545: Connect failed because target host or object does not exist

but when try to connect through my sql prompt ( from rman database) it connects but not regularly
SQL> connect bms/bms@orcl_taf
Connected.
SQL>


Note - from sql prompmt it is also reguralry not connected it gives the same message

SQL> connect bms/bms@orcl_taf
ERROR:
ORA-12545: Connect failed because target host or object does not exist
if any thing not clear please tell me

Re: ORA-12545: Connect failed because target host or object does not exist [message #407121 is a reply to message #407102] Mon, 08 June 2009 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 23142
Registered: January 2009
Senior Member
12545, 00000, "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.
Re: ORA-12545: Connect failed because target host or object does not exist [message #407130 is a reply to message #407121] Mon, 08 June 2009 11:02 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

this is the config of tnsnames.ora


ORCL_TAF =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.201)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl_taf.indo.com)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)


rmandb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl_taf.indo.com)
)
)

Note - 192.168.1.200 and 201 is the vip and 192.168.1.101 is the node ip. i have tried both, but is gives same error

with regds
rajnish

[Updated on: Mon, 08 June 2009 11:04]

Report message to a moderator

Re: ORA-12545: Connect failed because target host or object does not exist [message #407131 is a reply to message #407102] Mon, 08 June 2009 11:12 Go to previous messageGo to next message
BlackSwan
Messages: 23142
Registered: January 2009
Senior Member
12545, 00000, "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.


EXACTLY what is being attempted when error occurs?
Re: ORA-12545: Connect failed because target host or object does not exist [message #407133 is a reply to message #407131] Mon, 08 June 2009 11:17 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

sorry for my poor understanding, but i am not getting "EXACTLY what is being attempted when error occurs?" this word.


Re: ORA-12545: Connect failed because target host or object does not exist [message #407134 is a reply to message #407102] Mon, 08 June 2009 11:26 Go to previous messageGo to next message
BlackSwan
Messages: 23142
Registered: January 2009
Senior Member
lsnrctl status
lsnrctl service

Post results from above commands

[Updated on: Mon, 08 June 2009 11:28]

Report message to a moderator

Re: ORA-12545: Connect failed because target host or object does not exist [message #407135 is a reply to message #407134] Mon, 08 June 2009 11:32 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

RMAN> connect target bms/bms@orcl_taf

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12545: Connect failed because target host or object does not exist


SQL> connect bms/bms@orcl_taf
ERROR:
ORA-12545: Connect failed because target host or object does not exist

SQL> connect bms/bms@rmandb
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Re: ORA-12545: Connect failed because target host or object does not exist [message #407140 is a reply to message #407135] Mon, 08 June 2009 11:51 Go to previous message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Because they are sometimes connected, sometimes fail, so it should not be tnsnames configuration issues, so i checked metalink, found oracle a small bug:

Note: 364855.1: RAC Connection Redirected To Wrong Host / IP ORA-12545

so i changed the local_listener on both nodes now it is connected perfectly

thank you for reply

with regds
rajnish
Previous Topic: Upgrade from 10.2.0.1.0 to 10.2.0.4.0
Next Topic: ORA-15028: error in ASM
Goto Forum:
  


Current Time: Thu Dec 18 13:39:14 CST 2014

Total time taken to generate the page: 0.10582 seconds