OraFAQ Forum: RAC & Failsafe » ORA-12545: Connect failed because target host or object does not exist

Members

Help

Home

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)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

ORA-12545: Connect failed because target host or object does not exist [message #407102]

Mon, 08 June 2009 07:48

kumarrajnishgupta
Messages: 27
Registered: October 2008
Location: noida

Junior 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

Report message to a moderator

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

BlackSwan
Messages: 3227
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.

Report message to a moderator

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

kumarrajnishgupta
Messages: 27
Registered: October 2008
Location: noida

Junior 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

BlackSwan
Messages: 3227
Registered: January 2009

Senior Member

Report message to a moderator

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

kumarrajnishgupta
Messages: 27
Registered: October 2008
Location: noida

Junior Member

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

Report message to a moderator

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

BlackSwan
Messages: 3227
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

kumarrajnishgupta
Messages: 27
Registered: October 2008
Location: noida

Junior 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

Report message to a moderator

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

kumarrajnishgupta
Messages: 27
Registered: October 2008
Location: noida

Junior 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

Report message to a moderator

Previous Topic:	Upgrade from 10.2.0.1.0 to 10.2.0.4.0
Next Topic:	ORA-15028: error in ASM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 8 16:53:18 CST 2009

Total time taken to generate the page: 0.17536 seconds

.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.