Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    64

    Question Unanswered: tns lost contact error on SQL PLus

    I have an Oracle 9.2 instance on solaris, running on a box which cannot be accessed directly from my workstation.

    I would like to run the SQL Plus gui or TOAD from here, but am not 100% how to get it working.

    Till now I've had to SSH to the CMS server, and from there SSH onto the Oracle server and use the CLI. I've installed the client tools on my work station, and set up an SSH tunnel using PuTTY so that opening an SSH session to the CMS box, is trying to tunnel to the Oracle box.

    On opening SQL PLus, and entering localhost connection strings, I get a "Error: ORA-12547: TNS:lost contact"

    I've set up the tnsnames.ora entry for this as if it's connecting to localhost.

    Am I going about this the right way?

    tia

    a

  2. #2
    Join Date
    Feb 2005
    Location
    Leesburg, VA
    Posts
    42
    Can I see your contents of the listener.ora on the server and the tnsnames.ora for the client? If they're on the same machine, both from that machine will do. If you have no listener.ora, just say so. sqlnet.ora would be good too if you have it.
    Steven Karam
    Oracle 10g Certified Master
    Web: OrclDBA.com
    Email: steve@orcldba.com

  3. #3
    Join Date
    Sep 2004
    Posts
    64

    *.ora files

    Both taken from the server.
    I have to ssh into TC0 then from there ssh onto or0, or0 being the Oracle server. I'd like to be able to connect to or0 using sqlplus or toad from my workstation, which can only access tc0 directly.

    ------------------------------------------------------
    tnsnames.ora:
    ################
    # Filename......: tnsnames.ora
    # Name..........: LOCAL_REGION.world
    # Date..........: 19-JAN-99 17:47:25
    ################
    sid1 =
    (DESCRIPTION =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = OR0)
    (Port = 1521)
    )
    (CONNECT_DATA =
    (SID = sid1)
    (GLOBAL_NAME = sid1)
    )
    )
    live1 =
    (DESCRIPTION =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = TC0)
    (Port = 1521)
    )
    (CONNECT_DATA =
    (SID = live1)
    (GLOBAL_NAME = live1)
    )
    )
    extproc_connection_data =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY=EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )


    ------------------------------------------------------
    listener.ora:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL=IPC)(KEY = EXTPROC0))
    (ADDRESS= (PROTOCOL=TCP)(Host=OR0)(Port=1521))
    )
    )
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME=PLSExtProc)
    (ORACLE_HOME=/usr/local/oracle/product/9.2)
    (PROGRAM=extproc)
    )
    (SID_DESC =
    (ORACLE_HOME=/usr/local/oracle/product/9.2)
    (SID_NAME=sid1)
    )

    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    Last edited by arpoodle; 03-04-05 at 10:44.

Posting Permissions

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