Sunday, 16 February 2014

Error in Starting the Database - ORA-12547: TNS:lost contact



sqlplus / as sysdba

SQL*Plus: Release X.X.X.X Production on Sun Feb 16 21:00:43 2014

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

ERROR:
ORA-12547: TNS:lost contact


Enter user-name:


On one fine day if you encounter above error suddenly (without messing up the Database much, :-) )
You would like to see the $ORACLE_HOME/bin/oracle binary permission and ownership

Permission to $ORACLE_HOME/bin/oracle binary should be 6751 and permission will be <oracle_user>:<oracle_group>, something like this

chmod 6751 $ORACLE_HOME/bin/oracle
chown oracle:dba  $ORACLE_HOME/bin/oracle

Above two commands should help start the database, just fine.