Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Unanswered: Listener connection problem

    Hi there,

    We're having some problems while connecting to a remote Oracle database. There's a particular issue: the client is behind a firewall, but all ports are open and we can successfuly create ftp/telnet/etc. connections.

    First, we tried a JDBC connection: didn't work and failed with:
    Io exception: The Network Adapter could not establish the connection

    Next, we inserted a new line in tnsnames.ora, to the desired instance, and tried tnsping: all ok, tnsping contacted the remote listener successfuly.

    So, we tried to sqlplus the database: failed with:
    ORA-12545: Connect failed because target host or object does not exist

    Has anyone experienced this before? What can we do to solve the problem? "oerr ora 12545" and Google didn't help...

    Thanks in advance,
    Arménio Pinto

  2. #2
    Join Date
    Jan 2004
    Posts
    99
    check the global_names parameter, I had the same error message when creating remote dba links.

  3. #3
    Join Date
    Jan 2004
    Posts
    14
    Originally posted by zaki_mtk
    check the global_names parameter, I had the same error message when creating remote dba links.
    Thanks zaki_mtk. GLOBAL_NAMES wasn't defined in the client tnsnames.ora. I inserted it, with the same value as the SID, and the same error occurred.

    Arménio Pinto

  4. #4
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Didi you update the listener.ora on the remote m/c to serve for the client request.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  5. #5
    Join Date
    Jan 2004
    Posts
    14
    Originally posted by Hings
    Didi you update the listener.ora on the remote m/c to serve for the client request.
    Is it necessary to insert a line in the remote listener.ora for each allowed client? I'll try it...

    Arménio Pinto

  6. #6
    Join Date
    Jan 2003
    Posts
    2
    Try to change hostname from DNS to IP address in tnsnames.ora file on the client machine.

    for eg: if hostname=abc.rrr.xx to 149.134.%%.%%

    That should work

    VR

  7. #7
    Join Date
    Feb 2004
    Location
    Viet Nam
    Posts
    6

    Re: Listener connection problem

    - come http://tahiti.oracle.com
    - choose oracle version you install
    - Search for ORA-12545

    I hope it will be helpful

Posting Permissions

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