Monday, October 3, 2011

ORA-12547: TNS:lost contact

When I tried to login into oracle I have received below error
sapec4:ec4adm 61> sqlplus /nolog

SQL*Plus: Release Production on Thu Sep 29 14:00:17 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> connect / as sysdba
ORA-12547: TNS:lost contact

Here is the simple solution for that

1.Check “oracle:dba” should have ownership on $ORACLE_HOME/bin/sqlplus
$chown oracle:dba $ORACLE_HOME/bin/sqlplus
2.$ORACLE_HOME/bin/sqlplus should have 6751 permission
$chmod 6751 $ORACLE_HOME/bin/sqlplus

If you still have the problems try solution 2.

You may receive this error if oracle binaries are not linked correctly, stop databases and relink the binaries.

$ ORACLE_HOME/bin/ relink all

If you find below errors in listener.log then problem related to limit of PROCESSES value.

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact

Solution:- Increase the PROCESSES parameter in the init.ora to a higher value
SQL> Alter system set processes= “

After fixing TNS issue you may see below error

ORA-27140: attach to post/wait facility failed

$ cd $ORACLE_HOME/bin
$ chmod 6751 oracle

Satishbabu Gunukula