Oracle’s OPatch utility is used for applying interim CPU patches to maintain the security of your RDBMS. In this article we will cover the error which would be received if the file permissions in your Oracle Home are not correctly set and a work-around to continue your patch installation.
1. Logon to your Oracle database server as the Oracle software owner.
2. Change directories to the location of your CPU patch and unzip the file.
unzip p9119226_10204_
3. Change directories into your unzipped patch directory which is named with the CPU number you are applying.
cd 9119226
OPatch napply -skip_subset -skip_duplicate
4. You receive the following error or similar error during installation.
Running prerequisite checks…
Prerequisite check “CheckApplicable” failed.
The details are:
Patch 8568398:
Copy Action: Desctination File “/app/oracle/product/10.2.0/lib/libjox10.so”
is not writeable.
‘oracle.rdbms, 10.2.0.4.0’: Cannot copy file from ‘libjox10.so’ to
‘/app/oracle/product/10.2.0/lib/libjox10.so’
UtilSession failed: Prerequisite check “CheckApplicable” failed.
OPatch failed with error code 73
$
5. The OPatch utility was unable to update one of the lib files for installation, due to a file permission error. To resolve this issue, change directories to your ORACLE_HOME/lib directory.
$ cd /app/oracle/product/10.2.0/lib/
6. Check the existence of the lib file in question with the command ls.
$ ls libjox10.so
-r-xr-xr-x 1 fpdfqt dba 20041728 Jan 07 2009 libjox10.so
7. Make a backup copy of this lib file with the command cp.
$ cp libjox10.so libjox10.so_bak
8. Change permission on the lib file in question.
$ chmod 777 libjox10.so
$
8. Attempt re-installation of your Oracle patch with the OPatch utility.
OPatch napply -skip_subset -skip_duplicate
Return Code = 0
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded.
$
As seen above the patch set is successfully installed.
Larry J Catt, OCP 9i, 10g
oracle@allcompute.com
www.allcompute.com