APEX: APEX upgrade to 19.1, ORDS upgrade to 19.1

Apex and Ords 19.1 are both available.

To upgrade these versions in place, for example on an OCI DBsystem, from respectively Apex 18.2 and Ords 18.3:

#1 Download and unzip apex 19.1 in the n/u01/app/oracle/product/apex/18.3

#2 Upgrade apex

cd /u01/app/oracle/product/apex/19.1
sqlplus / as sysdba <<EOF
ALTER SESSION SET CONTAINER=<mycontainer>
@apexins SYSAUX SYSAUX TEMP /i/
EOF

#3 Change the images symbolic links (quite convenient to handle periodic upgrades)

cd /u01/app/oracle/product/apex
rm latest
ln -s 19.1 latest

#4 Download and unzip the ORDS zip file in the newly created directory

 /u01/app/oracle/product/ords/19.1

#5 Upgrade the params files

cd /u01/app/oracle/product/ords/18.3/params
cp /u01/app/oracle/product/ords/19.1/params/* .

#6 Upgrade the config directory

cd /u01/app/oracle/product/ords/19.1
java -jar ords.war configdir /u01/app/oracle/product/ords/config

#7 Stop the current ords listener.

#8 Upgrade the ORDS schema

cd /u01/app/oracle/product/ords/19.1
java -jar ords.war

Specify the system username and password to connect to the ORDS schema in the PDB if applicable.

The end of the above process should start the ords server