File Permission Changed After applying a Patch on Oracle Home

Asset ID:	1-72-1495123.1
Update Date:	2016-11-16
Keywords:

Solution Type Problem Resolution Sure

Solution 1495123.1 : File Permission Changed After applying a Patch on Oracle Home

Applies to:

Oracle Universal Installer - Version 1.0.0.0.62 and later
Exadata Database Machine X2-2 Hardware
Information in this document applies to any platform.

Symptoms

When a patch is applied, the permission of certain files under Oracle Home may change for example :

While applying patch PSU112031 p13343438_112030_Linux-x86-64.zip the file permissions change for /oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1

Before patch:
-rwxr-xr-x 1 oracle dba 52690050 Sep 17 13:38 /oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1

After patch:
-rwxr-x--- 1 oracle dba 52690082 Sep 17 13:58 /oracle/product/11.2.0/dbhome_2/lib/libclntsh.so.11.1

This is the shared library for sqlplus and after the patch is installed all users in the "others" group get the following error when trying to use sqlplus:

: sqlplus

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

Changes

Applied a Patch

Cause

1. Not logged in as the owner of the ORACLE_HOME prior to applying the patch

2. The umask setting was not properly set to 022

Solution

1. Make sure that the account being used to apply the patch is the owner of the ORACLE_HOME before applying the patch.

2. Prior to applying the patch and logged in as the owner of the ORACLE_HOME confirm the umask is set to 022

: umask

022

References

<BUG:10393664> - UMASK FOR ROOT SHOULD BE SET 022 BEFORE APPLYING A PSU
<NOTE:1351428.1> - Information Center: Patching and Maintaining Oracle Database Server/Client Installations

Attachments

This solution has no attachment