Issue

Error while applying patch 18283295 using ADOP when upgrading from R12.2.0 to R12.2.4

Error thrown by the patch

AutoPatch error:

Please apply adgrants.sql file in database tier before applying this patch

You should check the file
u01/oracle/VIS/fs_ne/EBSapps/log/adop/2/apply_20140916_202603/VIS_ebs1224/18283295/log/u18283295.log for errors.

    [STATEMENT] [START 2014/09/16 20:27:16] Unlocking sessions table

    [STATEMENT] [END   2014/09/16 20:27:16] Unlocking sessions table

    [STATEMENT] Log file: /u01/oracle/VIS/fs_ne/EBSapps/log/adop/2/adop_20140916_174226.log

    [UNEXPECTED]Error occurred while running above command. Please check the log file.

Resolution

Step 1. Run the adgrants.sql provided under the patch's admin.sql directory in the database tier. For the first parameter provide 'apps' as user.

sqlplus '/as sysdba';

sql> @adgrants.sql

Step 2. Now retry applying the patch:

adop phase=apply patch=18283295 hotpatch=yes workers=4 restart=yes

Environment

• Upgrading from Release 12.2.0 to 12.2.4 of Oracle E-Business Suite
• Oracle Linux 5.7 (x86-64)