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

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 :: 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: 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

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: 26766
Registered: January 2009
Location: SoCal

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: 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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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: 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.

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: 26766
Registered: January 2009
Location: SoCal

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: 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

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: 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

Report message to a moderator

Re: ORA-12545: Connect failed because target host or object does not exist [message #679580 is a reply to message #407140]

Tue, 10 March 2020 07:39

syed owais
Messages: 1
Registered: March 2020

Junior Member

Dear Friends,

I am facing below error during 12c RMAN Table Point in time recover.

RMAN-00571: ===========================================================
RMAN-00569: =========

ERROR MESSAGE STACK FOLLOWS

=========
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/08/2020 14:44:32
RMAN-04006: error from auxiliary database: ORA-12545: Connect failed because target host or object does not exist

----- > scenario as below:

1) MY DB IS Oracle 12c Cluster.

NODE1 = PRODSYS1
NODE2 = PRODSYS2
DB NAME = PROD

2) trying to recover table from RMAN with NOTABLEIMPORT option.

3) I AM CONNECTING TO RMAN FROM ANOTHER SERVER(PRODTEST) AS BELOW

$) rman target sys/pwd@prod (alias of target server)

rman >

4) CONNECTING TO RMAN PROMPT WITHOUT ANY ERROR ALSO I CAN RUN LIST BACKUP;
and TNSPING ALSO FINE FROM SERVER(PRODTEST).
5) when I execute below recover command I am getting error

RMAN > run
{
Allocate channel t1 type 'SBT_TAPE'
PARMS='SBT_LIBRARY='LIBRARY PATH',ENV=(OB2BARTYPE=Oracle8,OB
2APPNAME=DBNAME,OB2BARLIST=JOB NAME)';
RECOVER TABLE TEST.'CUST'
UNTIL TIME "TO_DATE('24-DEC-2019 21:00', 'DD-MON-YYYY HH24:MI')"
AUXILIARY DESTINATION '/U04/aux'
DATAPUMP DESTINATION '/U04/export'
DUMP FILE 'TEST_CUST.dmp'
NOTABLEIMPORT;
release channel t1;
}

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =========

ERROR MESSAGE STACK FOLLOWS

Report message to a moderator

Re: ORA-12545: Connect failed because target host or object does not exist [message #679582 is a reply to message #679580]

Tue, 10 March 2020 08:12

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

It looks as though the creation of the auxiliary instance failed. Is there not more more information than you have shown? There will also be a n alert log for the auxiliary instance.

Report message to a moderator

Previous Topic:	CRS-4640: Oracle High Availability Services is already active
Next Topic:	DML statement fails

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 07:42:20 CST 2025