How to Manually Upgrade APEX for 19c DB upgrade
Download latest apex version from link
https://www.oracle.com/tools/downloads/apex-downloads/
Steps:
1) Check the current APEX Version
SQL> Select Comp_name, status, Version
From Dba_Registry
where comp_id='APEX';
COMP_NAME STATUS VERSION
---------------------------------------- ------------ ------------------------------
Oracle Application Express VALID 3.2.1.00.12
2. From the directory which holds the APEX unzipped software, connect to sqlplus as SYS user and run apexins.sql
cd /u01/software/db-soft/apex
sqlplus /as sysdba
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/
3. check the upgraded APEX Version
SQL> Select Comp_name, status, Version
From Dba_Registry
where comp_id='APEX';
COMP_NAME STATUS VERSION
---------------------------------------- ------------ ------------------------------
Oracle Application Express VALID 20.2.0.00.20
APEX has been successfully upgraded to version 20.2.0.00.20…
Post a Comment
Post a Comment