Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013

    Unanswered: TNS:lost contact while login as sysdba

    ORA-12547: TNS:lost contact

    Identify the issue
    truss -aefo sqlplus.trc sqlplus /nolog
    connect / as sysdba

    Cause I
    shared memory or semaphores leftover from previous instances (abnormal termination)
    ipcs -a
    remove problematic shared memory segments & semaphores
    ipcrm -m & ipcrm -s
    delete $ORACLE_HOME/dbs/lk<SID> file

    Cause II
    The /proc file system is not mounted.

    Cause III
    ulimit settings for 'open files' and 'pipe size' is very low.

    $ulimit -n 4096
    $ulimit -p 30

    Cause IV
    The stack limit is set too low.

    ulimit -s 32768

    Cause V

    Set proper LD_LIBRARY_PATH path

    Cause VI
    dbs folder missing from oracle home
    mkdir dbs and then create password & init files

    Cause VII
    Invalid env variables

    echo $ORACLE_HOME
    echo $ORACLE_SID
    echo $PATH

    Cause VIII
    Wrong file permissions

    cd $ORACLE_HOME/bin
    ls -l oracle

    chmod 6751 oracle

    or relink all

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    are these solutions in search of a problem?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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