Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Saturday, May 10, 2014

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!!!

1 comment:

Unknown said...

Superb... and Thank you sir.

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments