TNS-12545: Connect failed because target host or object does not
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: TNS-12545: Connect failed because target host or object does not

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    I am unable to connect Forms 6.0 with Oracle 8.1.7 (On windows 2000) from Client machine. Listner is started on Server. In sqlnet following error observed :

    Tns error struct:
    nr err code: 12206
    TNS-12206: TNS:received a TNS error during navigation
    ns main err code: 12545
    TNS-12545: Connect failed because target host or object does not exist
    ns secondary err code: 12560
    nt main err code: 515
    TNS-00515: Connect failed because target host or object does not exist
    nt secondary err code: 1004
    nt OS err code: 0



  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Is the instance started?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    yes instance is started

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    try pinging the machine...
    ping machine_name/or ip address..
    This way you can see if the machine is on....
    then do tnsping < service name > .....
    if these 2 steps are ok you must connect..........
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    This error (TNS-12545) generally refers to the host name being incorrect. check your listener.ora and tnsnames.ora to make sure they entries are correct.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Jim's right.
    And in the tnsping command you'll get the error/with address on your tnsnames.ora file compare it with the listener.ora on the server.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Jun 2002
    Posts
    73

    Talking

    Start the database and listener from control panel>services.

    The home directories of both should be differenet. First configure oracle server listener.ora and tnsnames according to your host machine and addreses. After that copy the folder "network" from Oracle server directory and paste it (overwrite) on the contents of network folder of developer 6.It will work fine. I myself soved that problem like this.

    chees:>
    You cannot succeed if you fear to face challenges.
    MAS
    BE(CS) , OCP 8/8i.



  8. #8
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    from client machine tnsping( and IP address) is ok. I have also use ping and IP address, it also ok

  9. #9
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    It might be an idea to do a sqlnet trace, the attached link may help

    http://support.oracle.co.uk/metalink...T&p_id=12101.1

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width