Oracle Update BSP 11.2.0.3.0 to 11.2.0.3.7

[Former Member]

Dear Experts,

Due to a GoLive Check recommendation, we have been tasked with the update of our Oracle patch from 11.2.0.3.0 to 11.2.0.3.7. Sadly, the installation of this patch has not gone as expected.

I have installed the patch as per this link following all the recommendations such as making sure everything is stopped when needed, usage of command fuser for stale sessions, updated both OPatch and MOPatch to the latest available version, and so on.

However, during the installation, out of the 61 patches that were supposed to be installed, only 30 were installed successfully. The remaining 31 patches either were not installed because of missing prerequisites, or conflicts. Except for 3 patches of the BSP that failed during the installation (9584028, 9458152, 14488478).

This 3 patches all failed with the same error. It seems it is trying to copy from a folder to another folder and it is giving a "file doesn't exist" error.

Note: A lot of people in the Internet / forums have issues throughout the installation because of authorization issues, this is NOT the case.

All with the similar error: Copy Action: Source file /oracle/S11/112_64/.patch_storage/9584028_Jun_22_2012_11_39_40/files/sap/ora_upgrade/post_upgrade/post_upgrade_checks.sql" does not exist. 'oracle.rdbms, 11.2.0.3.0': Cannot copy file from 'post_upgrade_checks.sql

The odd thing is that the patch was compiled in May 15 2013, but it is somehow generating a folder from folder Jun 22 2012....

I am unable to restore any longer to the backup that was taking before the update as it has been several days since the update and I cannot restore and make the consultants lose a 7 day work load. So, I wonder:

1.- How can I fix this issue? I mean, has anyone encountered the same problem with this patches.

2.- If it is not fixed, are this patches critical? I mean, SAP said that this patches are NOT modifying Oracle binaries so I don't think they are so critical... but are they a must?

Thank you for your time,

Kind regards,

PIU

[Former Member · Accepted solution]

The issue was that the patch it was trying to install already had been installed, so the installation was trying to rollback (trying to find the rollback files in .patch_storage).

Somehow, those files were removed, and since it couldn't rollback the old patch version, it couldn't install the new version, therefore it failed.

The solution was to copy the .patch_storage missing folder from another server and retry the installation... which worked.

[Reagan]

Hello

Check this log file

$ORACLE_HOME/cfgtoollogs/mopatch/mopatch-2013_09_03-17-36-58.log

Regards

RB

[Former Member]

Please attach relevant opatch and mopatch log files. During installation you need to use IHRDBMS (installation home not runtime home). Please sure that you use IHRDBMS not OHRDBMS (link to IHRDBMS).

[Former Member]

Hello,

Yes, I did set all the environment variables as per the link in my first post (IHRDBMS, OHRDBMS).

I have attached mopatch log and one of the logs of the error, there is one for each patch one of the 3 patches that failed, but they are very similar.

Thank you,

Kind regards,

Pablo Iradier

apply2013-09-03_15-39-39PM_1.txt.zip

Oracle_MOPatch_Log_03092013.txt.zip

[Former Member]

In log files you provided ORACLE_HOME=/oracle/S11/112_64 but it must be /oracle/S11/11203. Please check this.

[Former Member]

Hello,

no such folder exists in the /Oracle/s11/ route. see attached pic.

kind regards,

PIU

[Former Member]

You need to install oracle software in /oracle/S11/11203 directory and after that create symlink 112_64 -> 11203. Please read carefully oracle upgrade guide and SAP notes about this.