Apex Upgrade - Upgrade Apex from 5.1 to 19.1

Apex Upgrade - Upgrade Apex from 5.1 to 19.1

Upgrade Apex 5.1 to 19.1

Take full database backup before doing apex upgrade

1) Download latest Apex 19.1 in our case we are upgrading apex

2) Unzip it to the location where you wanted to keep it.

3) mv old apex directory as /u01/app/apex to /u01/app/apex_old

4) start upgrade process

cd /u01/app/apex

SQL> @apexins APEX APEX TEMP /i/

output something like below

. Application Express (APEX) Installation.
..........................................
.
...set_appun.sql
... Checking prerequisites (MANUAL)
.
. SYSDBA Privilege
.   pass - Connection with SYSDBA privilege.
. Database rolling upgrade
.   pass - No rolling upgrade.
. DB components
.   pass - APEX: version=5.1.4.00.08
.   pass - CATPROC: version=12.1.0.2.0
.   pass - XDB: version=12.1.0.2.0
. XDB
.   pass - is valid
. PL/SQL Web Toolkit
.   pass - version 10.1.2.1.9
. Tablespaces
.   pass - found APEX
.   pass - found APEX
.   pass - found TEMP
. PHASES (1,2,3)...

PL/SQL procedure successfully completed.




# Creating APEX_INSTANCE_ADMIN_USER
#
APEX_INSTANCE_ADMIN_USER already exists - do nothing.
#
# Actions in Phase 1:
#
    ok 1 - BEGIN                                                        |   0.00
    ok 2 - Creating FLOWS_FILES                                         |   0.00
    ok 3 - Creating APEX_PUBLIC_USER                                    |   0.00
    ok 4 - Creating APEX_GRANTS_FOR_NEW_USERS_ROLE                      |   0.02
    ok 5 - Creating SYS Objects                                         |   0.03
    ok 6 - Creating APEX Tables                                         |   0.37
    ok 7 - Installing Package Specs (Runtime)                           |   1.52
    ok 8 - Installing Package Bodies (Runtime)                          |   0.38
    ok 9 - Dev Grants                                                   |   0.05
    ok 10 - Installing Package Specs (Dev)                              |   0.27
    ok 11 - Installing Views (Dev)                                      |   0.05
    ok 12 - Installing Package Bodies (Dev)                             |   0.33
    ok 13 - Recompiling APEX_190100                                     |   1.57
    ok 14 - Creating APEX$ objects in APEX_190100                       |   0.10
    ok 15 - Creating Spatial Support                                    |   0.03
    ok 16 - Creating Instance Parameter Defaults                        |   0.00
    ok 17 - Inherit Privileges                                          |   0.02
    ok 18 - Creating APEX_INSTANCE_ADMIN_USER                           |   0.00
ok 1 - 18 actions passed, 0 actions failed                              |   4.73
timing for: Creating APEX_INSTANCE_ADMIN_USER
Elapsed: 00:00:00.24
timing for: Phase 1 (Installation)
Elapsed: 00:04:52.05
Phase 2 (Upgrade)

timing for: Enabling Phase 2
Elapsed: 00:00:00.03
#
# Upgrade Metadata (1)
#
...reset_state_and_show_invalid.sql

timing for: Upgrade Metadata (1)
Elapsed: 00:01:20.06
#
# Upgrade Metadata (2)
#
   -- Upgrading new schema. -------

timing for: Upgrade Metadata (2)
Elapsed: 00:00:00.46


Thank you for installing Oracle Application Express 19.1.0.00.15

Oracle Application Express is installed in the APEX_190100 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
http://host:port/apex/apex_admin     (Oracle REST Data Services)

The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
http://host:port/apex     (Oracle REST Data Services)

timing for: Phase 3 (Switch)
Elapsed: 00:01:19.64
timing for: Complete Installation
Elapsed: 00:12:31.76

PL/SQL procedure successfully completed.




SQL> @apex_epg_config.sql /u01/app/

PL/SQL procedure successfully completed.

timing for: Load Images
Elapsed: 00:04:00.66

PL/SQL procedure successfully completed.


Commit complete.


Launch apex url if you see any issues before digging more into issue clear cache from browser.