Page 1 of 1

Upgrade APEX from 18.2 to 19.2?

Posted: Wed Dec 25, 2019 3:31 pm
by admin
1. Download
http://www.oracle.com/technetwork/devel ... index.html

2. Unzip and upload the apex folder in oracle home.

3. As sys user,

@apexins.sql SYSAUX SYSAUX TEMP /i/

4. Upload images in application server folder like in tomcat

/apache-tomcat-9.0.14/webapps/i

and if not application server then,
SQL> @apxldimg.sql $ORACLE_HOME

5. Change admin password @apxchpwd.sql
6. Restart tomcat server and clear browser cache.

if you received the following error then check the version of your uploaded images using http://hostname:portno/i/apex_version.txt it should be 19.2

There is a problem with your environment because the Application Express files are not up-to-date! The files for version 18.2.0.00.12 have been loaded, but 19.2.0.00.18 is expected. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide.

Admin Login
http://hostname:port/apex/apex_admin

https://docs.oracle.com/en/database/ora ... 20D6361596

https://docs.oracle.com/en/database/ora ... index.html

Apply Patch p30392181_1920_Generic

sqlplus "sys/ as sysdba" @catpatch.sql