ADZDMVREFRESHNEEDED.sql before kicking off Rel 12.2 Driver

To reduce the overall upgrade time, you can optionally run the ADZDMVREFRESHNEEDED.SQL script before starting with the Release 12.2.0 upgrade.

  1. Validated the version of all ADZDMVREFRESHNEEDED.sql present.

$ ls -ltr /dodiapps/rgp6/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ADZDMVREFRESHNEEDED.sql
-rwxr-xr-x 1 oracle dba 3007 Apr 28 18:01 /dodiapps/rgp6/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ADZDMVREFRESHNEEDED.sql
rgp6app(oracle):/dodiapps/rgp6/apps/apps_st/appl/ad/12.0.0/patch/115/sql

$ adident Header /mnt/install_images/oracle/EBS122Patches/ADTXK14/33600809/ad/patch/115/sql/ADZDMVREFRESHNEEDED.sql
/mnt/install_images/oracle/EBS122Patches/ADTXK14/33600809/ad/patch/115/sql/ADZDMVREFRESHNEEDED.sql:
$Header ADZDMVREFRESHNEEDED.sql 120.0.12020000.2 2016/06/30 08:38:31 mkumandu noship $
rgp6app(oracle):/mnt/install_images/oracle/EBS122Patches

$ adident Header /mnt/install_images/oracle/EBS122Patches/OnlineEnablement/OPERR/ADB/31026891/ad/patch/115/sql/ADZDMVREFRESHNEEDED.sql
/mnt/install_images/oracle/EBS122Patches/OnlineEnablement/OPERR/ADB/31026891/ad/patch/115/sql/ADZDMVREFRESHNEEDED.sql:
$Header ADZDMVREFRESHNEEDED.sql 120.0.12010000.3 2016/08/01 10:21:30 sstomar noship $
rgp6app(oracle):/mnt/install_images/oracle/EBS122Patches

$ adident Header /dodiapps/rgp6/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ADZDMVREFRESHNEEDED.sql
/dodiapps/rgp6/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ADZDMVREFRESHNEEDED.sql:
$Header ADZDMVREFRESHNEEDED.sql 120.0.12010000.3 2016/08/01 10:21:30 sstomar noship $
rgp6app(oracle):/mnt/install_images/oracle/EBS122Patches
$

$adident Header /mnt/install_images/oracle/EBS122Patches/OnlineEnablement/OPERR/ADC/33993716/ad/patch/115/sql/ADZDMVREFRESHNEEDED.sql
/mnt/install_images/oracle/EBS122Patches/OnlineEnablement/OPERR/ADC/33993716/ad/patch/115/sql/ADZDMVREFRESHNEEDED.sql:
$Header ADZDMVREFRESHNEEDED.sql 120.0.12020000.2 2016/06/30 08:38:31 mkumandu noship $
rgp6app(oracle):/mnt/install_images/oracle/EBS122Patches
$

  1. Execute the file under Online Enablement Readiness Report Patch 31026891 as suggested by Oracle SR analyst

sqlplus apps
@/mnt/install_images/oracle/EBS122Patches/OnlineEnablement/OPERR/ADB/31026891/ad/patch/115/sql/ADZDMVREFRESHNEEDED.sql
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
rgp6app(oracle):/mnt/install_images/oracle/EBS122Patches
$

Unknown's avatar

Published by heemasatapathy

Heema is an Oracle Ace Pro, IEEE Senior Member, and experienced speaker at both local and international IT conferences. With two decades of hands-on experience as a senior DBA and Solution Architect, Heema is adept at database administration and eager to embrace new technologies. Known for being customer-focused, organized, and self-motivated, Heema has a strong track record in managing technical projects and communicating solutions effectively. His global IT experience spans India, Japan, Malaysia, Singapore, Switzerland, and the USA. He holds a Bachelor of Engineering degree with Honors.

Leave a comment