ORA-12545: Connect failed because target host or object does not exist
First of all, open dos box or Unix shell script and do:
tnsping yourdatabasename
to determine the host.This is the output that will be returned (Oracle 9.2 style)
Used parameter files:
c:\oracle\ora92\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = unknown)(PORT =
1521))) (CONNECT_DATA = (SERVICE_NAME = ORA920.WORLD) (SERVER = DEDICATED)))
TNS-12545: Connect failed because target host or object does not exist
Now, try to ping the hostname or ip address that was returned by the tnsping command:
ping hostname
If the ping command doesn't succeed, there's something wrong with the network or DNS setup.
Possibile causes are ip address conflicts, DNS outages, ...
Consult your network team to resolve the unkown host by either adding it to a DNS server, add it to the /etc/hosts or %windows home%\system32\drivers\etc\hosts file or other server name resolving technologies.
Welcome to our forum for Oracle error: ORA-12545 Add your own message
connected from client machine.
Through net manager connection it gives above two errors alternate.
Please try to resolve this error.
ORA-12545: Connect failed because target host or object does not exist
*************************************************************************
Error found in alert log of the primary database :
=================================================
*** 2009-01-07 12:03:17.061
Error 12545 connecting to destination LOG_ARCHIVE_DEST_2 standby host '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=owp
dblive.unix.banksys.be)(PORT=1522)))(CONNECT_DATA=(SID=ECPRD1)(SERVER=DEDICATED)))'
Error 12545 attaching to destination LOG_ARCHIVE_DEST_2 standby host '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=owpd
blive.unix.banksys.be)(PORT=1522)))(CONNECT_DATA=(SID=ECPRD1)(SERVER=DEDICATED)))'
Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=owpdblive.unix.banksys.be)(PORT=15
22)))(CONNECT_DATA=(SID=ECPRD1)(SERVER=DEDICATED)))'. Error is 12545.
*** 2009-01-07 12:03:17.068
kcrrfail: dest:2 err:12545 force:0
ORA-12545: Connect failed because target host or object does not exist
Test with tnsping from the primary database node :
==============================================================
bash-2.05$ tnsping ecprd1
TNS Ping Utility for Compaq Tru64 UNIX: Version 9.2.0.5.0 - Production on 07-JAN-2009 12:57:35
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/oraapp01/app/oracle/product/rdbms/920/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = owpdblive.unix.banksys.be)(PORT = 1522))) (CONNECT_DATA=(SID = ECPRD1)))
OK (10 msec)
bash-2.05$ tnsping '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=owpdblive.unix.banksys.be)(PORT=1522)))(CONNECT_DATA=(SID=ECPRD1)(SERVER=DEDICATED)))'
TNS Ping Utility for Compaq Tru64 UNIX: Version 9.2.0.5.0 - Production on 07-JAN-2009 12:57:47
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Attempting to contact (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=owpdblive.unix.banksys.be)(PORT=1522)))(CONNECT_DATA=(SID=ECPRD1)(SERVER=DEDICATED)))
OK (10 msec)
Question:
========
Any advise to resolve the log transport issue between the standby and the primary database ?
Rgds
Faustin
Either the failover server was rebooted (check the uptime of host owpdblive.unix.banksys.be), or there were some (brief) network problems between the primary and failover server.
Because you can do a successful tnsping now, it seems that all is ok again and you can reship the archived redologs again to the standby database
ERROR:
ORA-12545: Connect failed because target host or object does not exist
I have also found that the oracle executable is missing. How can I resolve the issue?
relink all
This will make sure your oracle executable is available again.
My env are Oracle 10.2.0.1.0 ,jdk 1.5,unix server.Many times i got the connect to the oracle database and many times i am getting this error.
********************************
java.sql.SQLException: ORA-12545: Connect failed because target host or object d oes not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :125)
at oracle.jdbc.driver.GetCharSetError.processError(T2CConnection.java:30 88)
at oracle.jdbc.driver.T2CConnection.getCharSetIds(T2CConnection.java:281 1)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:300)
at oracle.jdbc.driver.PhysicalConnection.
at oracle.jdbc.driver.T2CConnection.
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtensio n.java:79)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.nafa.commons.DBConnection.getConnection(DBConnection.java:43)
at com.nafa.core.CallJava.doProcessing(CallJava.java:132)
at com.nafa.core.CallJava.main(CallJava.java:81)
*****************************************************
I don't know ..why this is happening with me ..pls help me out
Thanks,
Manoj
When this happens, see if you can ping the server.
Also, if you do not have fully qualified names in place, this can be a cause of some problems as well.
I have checked the pinging server as u suggested ,it's ping me correctly. no doubt it's not a newtwork conn problem.may be some so file or oracle driver problem ?
Thanks,
Manoj
On Windows:
ping -n 100 your_fully_qualified_database_server
On Linux:
ping -c 100 your_fully_qualified_database_server
This is ping me fine as sent=100 ,recieved = 100 , lost =0 .
Thanks,
Manoj
If that works consistently, there is a problem with dns resolution.
i checked by giving ping host name it is not giving any error, but when ever i am trying to connect through TOAD it is giving above error, please provide me possible reasons to solve the issue.
Do you have more than 1 Oracle home, which does have different information?
Did you check via another tool, such as sqlplus
What happens if you try to make a connection using EZConnect?
sqlplus user/pass@//hostname:port/SERVICENAME
tnsping works
ping does not work (wide - ip used)
sqlplus user/pass@db
connects sometimes and does not connect other times to the database .. Fails with the below error
ORA-12545: Connect failed because target host or object does not exist
tnsping works
ping does not work (wide - ip used)
sqlplus user/pass@db
connects sometimes and does not connect other times to the database .. Fails with the below error
ORA-12545: Connect failed because target host or object does not exist
I am trying to install informatica 8.6.0, while configuring domain test connection is failng. the reason for this is oracle listener services is not running. when i start it , it starts and stops immediately. when start it using lsnrctl it is running but the status shows nothing.as per on of the responses in this site, i did tnsping oracle then i got a host number or ip which is different form my actual ip.
my ques is when i do tnsping the host which i get should be as my acutal host or will it be a diffrent host.
also please help to keep my listener keep running.
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.