Oracle 10gr2 Permissions On Oracle Home

I installed Oracle Client on an HP-UX 11.11 server. Logged in as the Oracle software owner (e.g. oracle Unix account), I can access all the usual Oracle utilities such as SQL*Plus. However, one of our developers was getting the error below when invoking SQL*Plus.

$ sqlplus
ksh: sqlplus: not found

Their Unix account does not belong to the Unix dba group, which explains why I don’t see the problem when I login to my Unix account which is a member of the dba group.

In Metalink I had a bookmark to Note 335063.1. The note references Bug 4516865 for which there is a patch. I tried to install the patch which essentially replaces $ORACLE_HOME/install/ with an updated version. The file in the patch is for, but I am running so the patch apply fails.

% opatch apply
Invoking OPatch


ApplySession applying interim patch ‘4516865’ to
OH ‘/disk01/app/oracle/product/10.2.0/client_1’
ApplySession failed: ApplySession failed to

prepare the system.
ApplySession: Required component(s)
[ oracle.rdbms.rsf,, higher version found. ] not present in the Oracle
Home or a higher version found.
System intact, OPatch will not attempt to restore the system

OPatch failed with error code 73

Since the existing version was newer (September 2006), I just executed the script in $ORACLE_HOME/install.

% cd $ORACLE_HOME/install
% ./

Disclaimer: The purpose of this script is to relax permissions on some of the files in the database Oracle Home so that all clients can access them. Please note that Oracle Corporation recommends using the most restrictive file permissions as possible for your given implementation. Running this script should be done only after considering all security ramifications.

-n Do you wish to continue (y/n) [n]:
Finished running the script successfully
Please see /tmp/changePerm_err.log for errors and /tmp/changePerm.log for the log of events

That modified the permissions and solved the problem. The developer is now able to execute SQL*Plus.

Update (10-Jan-2008)
While installing Oracle on another database server and closely reading the Patch Set Notes, Post-Installation Tasks Section 7.3 explains the possible need to run the script. I seemed to have missed that in a previous install.

One Response to Oracle 10gr2 Permissions On Oracle Home

  1. ahmmed says:

    i run the and it was successful but i cant start oracle with another different account than oracle user

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: