DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-12547: TNS:lost contact (On production) Please help, urgent!!!

  1. #1
    Join Date
    Apr 2002
    Hi All,
    I'm running oracle 9.0.1 on Linux 7.1 . For the past one week , i'm getting a strange error when i'm trying to connect to oracle with SQLPLUS command.

    [oracle@cmsprod1 oracle]$ sqlplus

    SQL*Plus: Release - Production on Fri Aug 23 12:39:55 2002

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

    Enter user-name: devlcms
    Enter password:
    ORA-12547: TNS:lost contact

    Enter user-name:
    ORA-12547: TNS:lost contact

    Enter user-name:
    ORA-12547: TNS:lost contact

    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

    I looked for LD_LIBRARY_PATH first, it was not set, then i edited in my .bash_profile as
    LD_LIBRARY_PATH=$ORACLE_HOME/lib and ran my bash_profile from oracle user. and again when i say, 'env' , this parameter was set.

    But still, even after doing all these, i'm getting the same old error. Please suggest me .



  2. #2
    Join Date
    Dec 2001
    Keene, NH
    Have you checked this and does it send off any ideas?

    /oracle/admin/wmsd/ddl/tables> oerr ora 12547
    12547, 00000, "TNS:lost contact"
    // *Cause: Partner has unexpectedly gone away, usually during process
    // startup.
    // *Action: Investigate partner application for abnormal termination. On an
    // Interchange, this can happen if the machine is overloaded.

    Sorry to be of more help.

  3. #3
    Join Date
    Nov 2000
    Perform few tests and/or please answer these questions:

    Are you running SQL+ from the same machine where database resides?

    Is you listener running on database server?

    If connecting from client work station try to ping and tnsping to the database server.

    Were you connecting to this server earlier without problems?

    Did you re-built Oracle binaries recently?

    Hopefully your DB is up and running.

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