Description:
This document explains how we upgraded Oracle APEX, ORDS, and Java on the DBNAME database. It covers the checks and backups done before starting, the steps for installation and configuration, and how we fixed common issues during the process. The aim was to move from older versions to APEX 24.1, ORDS 24.1, and Java 11 smoothly, without affecting service availability.
| Componets | Current versions
|
Upgrade version |
| Apex | 22.2 | 24.1 |
| Ords | 21.2 | 24.1 |
| Java | Jdk-1.8 | 11.1 |
Pre checks and backups.
Apex Workspace backups.
Steps:
Login to admin responsibility and take the workspace level backup.
Using APEX port utility to take workspace and application backups in backend.
Tomcat and Ords backup
Taking current tomcat and ords backup using tar.
Validate workspace schema backup should be taken in DBA team.
Installation of apex in DB level.
Step 1:- Download Apex 24.1, ORDS 24.1 & Java 11 for Solaris OS.
Move to path mentioned in step2 in <Hostname> server.
Steps2 –
- create directory and move required software
mkdir –p /export/home/oraent/DBNAME_APEX_24/apex_24
mkdir –p /export/home/oraent/APEX_24/
- unzip apex software
cd /export/home/oraent/TESTDB_APEX_24/apex_24
unzip apex_24.1_en.zip
Step 3:- Check for table space to install apex (we use sysaux tablespace for this)
Step 4:- install apex
Set env for TESDB db
cd /export/home/oraent/TESTDB_APEX_24/apex_24/apex/
connect as sysdba
sql> @apexins.sql SYSAUX SYSAUX TEMP /i/
configure db restful services
sql> @apex_rest_config.sql
Note:- Make sure there is no errors on while upgrading Apex 24.
Step 5:- . Login db as sysdba unlock user account
alter user APEX_LISTENER identified by welcome_689 account unlock;
alter user APEX_PUBLIC_USER identified by welcome_689 account unlock;
alter user APEX_REST_PUBLIC_USER identified by welcome_689 account unlock;
Step 6:- Upgrade java to jdk_11.1 version
Unzip the java software file from below mentioned path
oraent@Hostname 20:38:10 ]$ ls
jdk-11.0.25.solaris-sparcv9_bin.tar.gz tomcat_10 java_11/
cd /export/home/oraent/APEX_24/java_11
oraent@Hostname 20:38:41 ]$ tar -xvf jdk-11.0.25.solaris-sparcv9_bin.tar.gz
Step 7:- ORDS configuration:
Unzip the ords software file in below mentioned path,
/export/home/oraent/APEX_24/config
oraent@Hostname 21:00:08 ]$ unzip ords-24.1.0.108.0942.zip
Note:- Before to initiate the ords configuration, need to set the java with new one JDK-11.0.25
export JAVA_HOME=/export/home/oraent/APEX_24/java_11/ jdk-11.0.25
export PATH=$JAVA_HOME/bin:$PATH
create the config directory outside of $ORDS_HOME (/export/home/oraent/APEX_24/)
cd /export/home/oraent/APEX_24/bin/
./ords –config /export/home/oraent/APEX_24/config install
The configuration folder /export/home/oraent/APEX_24/config does not contain any configuration files.
Oracle REST Data Services – Interactive Install
Enter a number to select the database connection type to use
[1] Basic (host name, port, service name)
[2] TNS (TNS alias, TNS directory)
[3] Custom database URL
Choose [1]: 1
Enter the database host name [localhost]: <Hostname>
Enter the database listen port [1521]: <db_port>
Enter the database service name [orcl]: <db_name>
Provide database user name with administrator privileges.
Enter the administrator username: SYS
Enter the database password for SYS AS SYSDBA:
[1] Connection Type: Basic
[2] Basic Connection: HOST=Hostname PORT=<db_port> SERVICE_NAME=<db_service_name>
Administrator User: SYS AS SYSDBA
[3] Database password for ORDS runtime user (ORDS_PUBLIC_USER): <specified password>
[4] Additional Feature: Database Actions
[5] Configure and start ORDS in Standalone Mode: Yes
[6] Protocol: HTTP
[7] HTTP Port: 8080
[8] APEX static resources location:
[A] Accept and Continue – Update configuration
[Q] Quit – Do not proceed. No changes
Choose [A]: 7
Enter the HTTP port [8080]: <APEX_PORT>
Enter a number to update the value or select option A to Accept and Continue
[1] Connection Type: Basic
[2] Basic Connection: HOST=<Hostname> PORT=<db_port> SERVICE_NAME=<db_name>
Administrator User: SYS AS SYSDBA
[3] Database password for ORDS runtime user (ORDS_PUBLIC_USER): <specified password>
[4] Additional Feature: Database Actions
[5] Configure and start ORDS in Standalone Mode: Yes
[6] Protocol: HTTP
[7] HTTP Port: <APEX_PORT>
[8] APEX static resources location:
[A] Accept and Continue – Update configuration
[Q] Quit – Do not proceed. No changes
Choose [A]:A
This will initiate the ORDS installation with 24.1, while installation is in process make sure there is no errors and completed with valid state.
Step 8:- Once completed the upgrade, will start the ORDS with standalone mode:
cd /export/home/oraent/APEX_24/bin/
./ords –config /export/home/oraent/APEX_24/config serve
Conclusion:
We successfully upgraded APEX, ORDS, and Java on the DBNAME environment by following the planned steps. The process included careful preparation, taking backups, installing the new versions, and fixing permission issues during ORDS setup. After the upgrade, we checked all components and confirmed they were working properly. The environment is now up to date and ready for future application work.
