Upgrade to Oracle APEX to latest version?

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Upgrade to Oracle APEX to latest version?

Post by admin »

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.png
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.
You do not have the required permissions to view the files attached to this post.
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest