ORA-12545 : Connect failed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-12545 : Connect failed

Hybrid View

  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