04-18-13, 23:02 #1Registered User
- 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
shared memory or semaphores leftover from previous instances (abnormal termination)
remove problematic shared memory segments & semaphores
ipcrm -m & ipcrm -s
delete $ORACLE_HOME/dbs/lk<SID> file
The /proc file system is not mounted.
ulimit settings for 'open files' and 'pipe size' is very low.
$ulimit -n 4096
$ulimit -p 30
The stack limit is set too low.
ulimit -s 32768
Set proper LD_LIBRARY_PATH path
dbs folder missing from oracle home
mkdir dbs and then create password & init files
Invalid env variables
Wrong file permissions
ls -l oracle
chmod 6751 oracle
or relink all
04-19-13, 00:09 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
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.