Tnsping OK but SQLPLUS connection fails
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Tnsping OK but SQLPLUS connection fails

  1. #1
    Join Date
    Jul 2003
    Posts
    135

    Exclamation Tnsping OK but SQLPLUS connection fails

    Client Machine: Windows 2000 Oracle 8.1.5
    Server : Windows 2000 Oracle 8.17

    Tnsping from client to Server is fine but SQLPLUS connection fails.
    Please help/suggest a solution.

    The only port open is 1521
    ------------
    TNSNAMES.ora entry on client:

    DB =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP_ADDRESS)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DB.DOMAIN)
    )
    )

    --------
    TNS Ping Utility for 32-bit Windows: Version 8.1.5.0.0 - Production on 07-DEC-05 09:48:21

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=IP_ADDRESS)(PORT=1521))
    OK (10 msec)
    ----------

    SQL*Plus: Release 8.1.5.0.0 - Production on Wed Dec 7 10:07:08 2005

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    SQL> conn user/pwd@aspfizer
    ERROR:
    ORA-12535: TNSperation timed out

    Thanks
    -D

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you cant have just port 1521 open, only the initial communication is done over port 1521, a random port is subsequently used.

    You need connection manager or shared sockets or something like that to make this work

  3. #3
    Join Date
    Jul 2003
    Posts
    135
    Thanks
    So is there a range of ports that need to be open, if yes what can they be OR where can I find that info.

    -D

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    sort out connection manager and you define your ports (same with shared sockets)

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    When you do a tnsping, it just pings your listener to see whether the listener can be reached using the parameter that you have povided on the service name on the tnsnames.ora file. Since this error seems to point us in the direction of timing out, check the listener.ora file for the CONNECT_TIMEOUT. IF that was set in there, then your network is failing to establish your connection within that time frame.
    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