Upgrade of apex from 4.0.2 to 4.2.4

Step by step Upgrade of apex from 4.0.2 to 4.2.4 On Linux 5.4

This post will cover the  step by step of Upgrade of apex from 4.0.2 to 4.2.4

>>Before upgrade of apex

>>Download the apex_4.2.4 from OTN and copy it in oracle_home and unzip:

>>Start SQL*Plus and connect to the Oracle XE database:

>> SQL> SELECT COMP_NAME, VERSION FROM DBA_REGISTRY;

>>Upgrade from apex 4.0.2 to 4.2.4: 

Note:-This script apexins.sql take about 30 minutes to complete it.

>>Log back into SQL*Plus (as above) and load images:

apxldimg.sql $ORACLE_HOME

>>Upgrade the Oracle Application Express password by running apxchpwd.sql:

@apxchpwd.sql

 

SQL> SELECT COMP_NAME, VERSION FROM DBA_REGISTRY;

>>Unlock the Apex related accounts:

Select username,account_status from dba_users where username like 'APEX_%';

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

SQL> ALTER USER XDB ACCOUNT UNLOCK;

SQL> ALTER USER APEX_040200 ACCOUNT UNLOCK;

SQL> ALTER USER FLOWS_FILES ACCOUNT UNLOCK;

SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

SQL> SELECT COMP_NAME, VERSION FROM DBA_REGISTRY;

In a Web browser, navigate to the Oracle Application Express Administration Services application:

>>Login page of Oracle Apex:

http://hostname:8080/apex/apex_admin

Username and Password: ADMIN and @@@@@@@@

Its done