SQL*Plus Permission Denied

After installing Oracle 11g Client on RHEL 5.4, I encountered a “permission denied” error while attempting to invoke SQL*Plus.  This occurred on two separate installations one 11gR1 and the other 11gR2.

First, the 11gR1 installation with the following symptoms:

Non-oracle user is trying to login to database via SQL*Plus, but attempts to access sqlplus result in a permission denied error.  Execution of sqlplus as oracle user works fine.

This is explained in Oracle Support Doc ID 1223449.1.

Cause
There is a lack of ‘read “r”‘ and ‘execute “x”‘ permissions on an upper directory which was not allowing access to sqlplus file.

Without execute permission on a directory, a user cannot access files in that directory even if they own them and have all permissions on them.

Solution
Add “r-x” permissions to “others” on upper directory (ex. /u01/app).

Following the recommendation above, I executed the commands below to successfully remediate the problem.

% cd /u01/app
% chmod 755 oracle

For the 11gR2 installation, I changed the permission as suggested, however the error below arises:

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

An explanation is provided in Oracle Support Doc ID 1206898.1.

Cause
The environment variable LD_LIBRARY_PATH was not set to include the 11g Client directory or the environment variable was set incorrectly.

Solution
Set the environment variable LD_LIBRARY_PATH to include the 11g Client directory.

Following the instructions mentioned above resolved my problems and all is functioning well.

Advertisements

3 Responses to SQL*Plus Permission Denied

  1. isgo says:

    Very interesting

  2. […] pm and is filed under Installations, Oracle. You can follow any responses to this entry through the RSS 2.0 […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: