Error while applying 17502060

During the Upgrade of EBS 12.2.0 to 12.2.3, as a pre-requisite, we need to apply database patches before applying the RUP.

While applying 17502060, we would encounter this error in Linux X86-64 Bit

Applying interim patch '17502060' to OH '/oracle/VER1223/db/tech_st/11.2.0'
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckApplicable" failed.
The details are:

Patch 17502060:
Copy Action: Destination File "/oracle/VER1223/db/tech_st/11.2.0/rdbms/admin/dbmsxdbschmig.sql" is not writeable.
'oracle.rdbms.dbscripts, 11.2.0.3.0': Cannot copy file from 'dbmsxdbschmig.sql' to '/oracle/VER1223/db/tech_st/11.2.0/rdbms/admin/dbmsxdbschmig.sql'

Log file location: /oracle/VER1223/db/tech_st/11.2.0/cfgtoollogs/opatch/17502060_May_09_2014_15_11_59/apply2014-05-09_15-11-59PM_1.log

Recommended actions: This patch requires some components to be installed in the home. Either the Oracle Home doesn't have the components or this patch is not suitable for this Oracle Home.

OPatch failed with error code 39

FIX:

Locate the file mentioned in the $ORACLE_HOMD/rdbms/admin

 ls -lrt dbmsxdbschmig.sql
-r-xr-xr-x 1 oracle dba 1505 Feb 23  2013 dbmsxdbschmig.sql


2. Change the file permission like

chmod 755 dbmsxdbschmig.sql

Now, retry the patching process. it should end successful.

Cheers!!!