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.
Upgrade to Oracle APEX to latest version?
Upgrade to Oracle APEX to latest version?
You do not have the required permissions to view the files attached to this post.
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 35 guests