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


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: 26756
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 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 messageGo to next 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
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 Go to previous messageGo to next message
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
=========
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



REGARDS,
SYED






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 Go to previous message
John Watson
Messages: 8426
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.
Previous Topic: CRS-4640: Oracle High Availability Services is already active
Next Topic: DML statement fails
Goto Forum:
  


Current Time: Fri Nov 27 11:17:18 CST 2020