DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-12545 Pls. help.. unable to connect to server

  1. #1
    Join Date
    Jan 2001
    Posts
    23
    Hi all,

    I am unable to connect to the Oracle server from a client. I am able to use SQL Plus in the server. But unable to connect from a client machine.

    I get an error ORA-12545: Connect failed because target host or object does not exist


    Can any of you help? I tried restarting the server. I thought there would be some network problem and so the host couldn't be found. But when I stop the listener I get the error No listener.. so the server is being addressed properly. The port is also right... I couldn't figure out any reason...

    Help of any level would be greatly appreciated....

    Thanks in advance...

    Nandu

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check the tnsnames.ora file on your client machine to see whether it had been configured correctly.

    Then try

    tnsping servicename

    then

    sqlplus username/password@servicename

    Sam

    Thanx
    Sam



    Life is a journey, not a destination!


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