Upgrade to Oracle APEX to latest version?
Posted: Fri May 15, 2020 9:24 pm
Prior to APEX 20.1 single script @apexins.sql APEX APEX temp /i/ was responsible to execute 3 steps/scripts which in 20.1 now can be executed separately to minimize downtime. While running 1 and 2 still users can work but while executing the 3rd script it will not be available.
Download latest version
https://www.oracle.com/tools/downloads/ ... loads.html
Upgrade steps
Phase: 1
Upload latest unzipped files on server and login as sys using SQLPLUS while in the apex folder.
@apexins1.sql APEX APEX temp /i/
timing for: Phase 1 (Installation)
Elapsed: 00:03:16.31
Phase: 2
@apexins2.sql APEX APEX temp /i/
timing for: Phase 2 (Upgrade)
Elapsed: 00:06:18.65
Phase: 3
During this APEX will not be available.
@apexins3.sql APEX APEX temp /i/
timing for: Phase 3 (Switch)
Elapsed: 00:01:00.72
Upload/Replace images from the latest apex/images folder to the images i folder in the application server ORDS folder.
Download if any path is there and apply,
SQL> @catpatch
replace images on the ORDS folder.
ACL Setting
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_220100',
principal_type => xs_acl.ptype_db));
END;
/
If still the following error then in the browser press CTRL+F5 while opening your URL,
There is a problem with your environment because the Application Express files are not up-to-date! The files for version 19.2.0.00.18 have been loaded, but 20.1.0.00.13 is expected.
Download latest version
https://www.oracle.com/tools/downloads/ ... loads.html
Upgrade steps
Phase: 1
Upload latest unzipped files on server and login as sys using SQLPLUS while in the apex folder.
@apexins1.sql APEX APEX temp /i/
timing for: Phase 1 (Installation)
Elapsed: 00:03:16.31
Phase: 2
@apexins2.sql APEX APEX temp /i/
timing for: Phase 2 (Upgrade)
Elapsed: 00:06:18.65
Phase: 3
During this APEX will not be available.
@apexins3.sql APEX APEX temp /i/
timing for: Phase 3 (Switch)
Elapsed: 00:01:00.72
Upload/Replace images from the latest apex/images folder to the images i folder in the application server ORDS folder.
Download if any path is there and apply,
SQL> @catpatch
replace images on the ORDS folder.
ACL Setting
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_220100',
principal_type => xs_acl.ptype_db));
END;
/
If still the following error then in the browser press CTRL+F5 while opening your URL,
There is a problem with your environment because the Application Express files are not up-to-date! The files for version 19.2.0.00.18 have been loaded, but 20.1.0.00.13 is expected.