OraFAQ Forum: Server Administration » ORA-12547: TNS:lost contact while login as sysdba

Home » RDBMS Server » Server Administration » ORA-12547: TNS:lost contact while login as sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12547: TNS:lost contact while login as sysdba [message #582500]

Thu, 18 April 2013 21:00

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

Report message to a moderator

Re: ORA-12547: TNS:lost contact while login as sysdba [message #582503 is a reply to message #582500]

Thu, 18 April 2013 21:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

And your question is what exactly?

Report message to a moderator

Re: ORA-12547: TNS:lost contact while login as sysdba [message #582510 is a reply to message #582500]

Fri, 19 April 2013 00:26

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12547: 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.

Regards
Michel

[Updated on: Fri, 19 April 2013 00:26]

Report message to a moderator

Previous Topic:	DBname changed from pfile
Next Topic:	ORA-00554 initialization of internal recovery manager package failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 27 09:35:31 CDT 2026