Thursday, May 7, 2009

sqlplus does not connect as a non Oracle user

Users different than the owner of the installation (Oracle user is usually the owner) are not able to run SQL*Plus. The following error is thrown.

"SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0Unable to proceed"

the reason is that sqlplus is unable to access required files. The error message is indicating following file is missing from install or inadequate permissions to access to the folder "oracore" under the $ORACLE_HOME.

To implement the work around, follow these steps:

1. Manually change the privileges for the $ORACLE_HOME/oracore directory and files.

cd to $ORACLE_HOME and type :

chmod -R 755 oracore


sqlplus will connect now.

No comments: