Oracle errors

From dbawiki
Revision as of 17:20, 27 January 2013 by Stuart (talk | contribs) (Created page with "===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 e...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.