Home » RDBMS Server » Server Administration » ORA-12547: TNS:lost contact while login as sysdba
ORA-12547: TNS:lost contact while login as sysdba [message #582500] Thu, 18 April 2013 21:00 Go to previous message
vishwas_samant
Messages: 1
Registered: April 2013
Junior Member
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
Invalid LD_LIBRARY_PATH

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 $LD_LIBRARY_PATH
echo $PATH

Cause VIII
Wrong file permissions

cd $ORACLE_HOME/bin
ls -l oracle

chmod 6751 oracle

or relink all
 
Read Message
Read Message
Read Message
Previous Topic: DBname changed from pfile
Next Topic: ORA-00554 initialization of internal recovery manager package failed
Goto Forum:
  


Current Time: Sat Dec 14 10:51:21 CST 2019