ORA-12545: Connect failed because target host or object does not exist

    Probably there's something wrong with the host (server) name or ip address you are connecting to.



    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.


Adverteren bij Daisycon
Forum Messages
: ->  13-MAR-2008 01:01:33oracle error (ora28547,ora12545)Abhijit Patil Reply
If I connect oracle service from server machine, but its not
connected from client machine.

Through net manager connection it gives above two errors alternate.

Please try to resolve this error.
13-MAR-2008 04:44:52Full qualifiedDbMotive Reply
Are you using fully qualified domain names for the host part?
Add your message for ORA-12545
Name:email:
Validation Code:4dc7i4yj37bnn03bu
Enter Code above:
Title:
State your problem: