Difference between revisions of "Oracle errors"
From dbawiki
(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...") |
|||
| Line 1: | Line 1: | ||
===ORA-12547: TNS lost contact=== | ===ORA-12547: TNS lost contact=== | ||
| − | If sqlplus <user>/<pass> fails with above error | + | If |
| − | + | <pre> | |
| + | sqlplus <user>/<pass> | ||
| + | </pre> | ||
| + | fails with above error, try | ||
| + | <pre> | ||
sqlplus <user>/<pass>@<db connection> | sqlplus <user>/<pass>@<db connection> | ||
| + | </pre> | ||
If this works, it is most probably a permissions error.<br /> | If this works, it is most probably a permissions error.<br /> | ||
| − | 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. | + | Re-run the <pre>$ORACLE_HOME/root.sh</pre> script that was run as part of the original installation. This will reset the permissions on some important files. |
Revision as of 17:21, 27 January 2013
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.
$ORACLE_HOME/root.shscript that was run as part of the original installation. This will reset the permissions on some important files.
