Oracle errors

From dbawiki
Revision as of 17:21, 27 January 2013 by Stuart (talk | contribs)
Jump to: navigation, search

ORA-12547: TNS lost contact

If 

sqlplus <user>/<pass>

fails with above error, try 

sqlplus <user>/<pass>@<db connection>

If this works, it is most probably a permissions error.

Re-run the 
$ORACLE_HOME/root.sh
script that was run as part of the original installation. This will reset the permissions on some important files.
Retrieved from "https://mailnest.com/dbawiki/index.php?title=Oracle_errors&oldid=362"