DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    May 2001


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

    I have install Oracle server on a PC. I have configure the Tnsnames, the listener and the SQLnet.ora.

    On the server itself, I could do a tnsping and I can connect with SQLPLUS. But when I try to connect to the database via another pc (And I have configure the tnsnames.ora of this pc) I could do a tnsping successfully but when I try to connect via SQLPLUS I received this error message ORA-12545.

    Want I'm doing wrong ?

    Thank you for your help.


  2. #2
    Join Date
    Oct 2000
    Check the status of the listener.

    In DOS or at the Unix prompt:

    >lsnrctl status;

    Start the listener if it is not running:

    >lsnrctl start;

    If you are running MTS, check that you have allocated a number of dispatchers.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    May 2001
    Thank you,

    But I find the error. In the Listener.ora, I have forgot to put the line COMMUNITY = TCP.WORLD.

    Now it's working fine.

    Thank's again.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.