Monday 31 August 2015

These OPM-related update scripts were *not* intended to be included in the 12.2 upgrade driver.   These OPM table modifications are included in OPM Post-Upgrade steps.
In the u_merged.drv patch driver file, delete all references to the following files, and restart the adpatch session.

 GMFG5ITM.sql 
 GMFG5MCP.sql 
 GMFG6MEL.sql 
 GMFG6P00.sql 
 GMFG6P01.sql
 GMFG6P02.sql 
 GMFG6P03.sql 
 GMFG6P04.sql 
 GMFG6P05.sql 
 GMFG6P06.sql 
 GMFG6P07.sql 
 GMFG6P08.sql 
 GMFG6P09.sql 
 GMFG6P10.sql 
 GMFG6P11.sql 
 GMFG6P12.sql 
 GMFG6P14.sql 
 GMFG6P15.sql 
 GMFG6P16.sql 
 GMFG6P17.sql 
 GMFG6P18.sql 
 GMFG6P19.sql

uHalt all worker processes
uupdate $ORACLE_BASE/fs1/EBSapps/appl/au/12.0.0/patch/115/driver/u_merged.drv
uConfirm all adworker sessions are gone at the DB level
uRestart adpatch process

uPermanent Solution for 12.2 OPM Customers , oracle support released the pre-install patch "18688087"
uBug 18688087 - POOR PERFORMANCE ON GMFG6P03.SQL TASKS DURING 12.2 UPGRADE DRIVER

No comments:

Post a Comment