APEX and ORDS 24.1 configuration in OracleLinux

Oracle APEX 24.1 Installation and configuration in Oracle Linux 8.6

• Oracle APEX 24.1
• ORDS 24.2
• Oracle Database 19c Enterprise Edition
• Oracle Linux 8.6
• Apache Tomcat deployment
• APEX installation guide
• ORDS configuration
• Oracle database optimization
• Enterprise database solutions
• Step-by-step Oracle APEX guide

1. Install OS and Oracle database

2. Startup the database

3. Check listener status

• lsnrctl status

4. Check tnsping status

• /u01/app/oracle/product/19.0.0.1/dbhome/network/admin
• Check the availability of tnsnames.ora,listener.ora and sqlnet.ora and amend the files as required then
• tnsping ords24

5. rename old apex folder to old_apex

• /u01/app/oracle/product/19.0.0.1/dbhome

• mv apex/ old_apex

6. copy apex latest version to (/u01/app/oracle/product/19.0.0.1/dbhome)

• unzip apex24
• rename the unzipped folder
• mv apex_24.1_en/ apex

7. Check datafile location

🡪 /u01/app/oracle/oradata/ORDS24/datafile

8. create apex tablespace

• create tablespace apex datafile ‘/u01/app/oracle/oradata/ORDS24/apex01.dbf’

size 5G autoextend on next 100m

9. go to apex folder path then

• sqlplus / as sysdba
• /u01/app/oracle/product/19.0.0.1/dbhome/apex/apex

10. run the following scripts

@apexins.sql apex apex temp /i/

11. Change the password

@apxchpwd

…set_appun.sql

Enter the administrator’s username [ADMIN] ADMIN

User “ADMIN” does not yet exist and will be created.

Enter ADMIN’s email [ADMIN] ords@gmail.com

Enter ADMIN’s password [****]

Created instance administrator ADMIN.

12. Configure apex_rest

@apex_rest_config.sql

Enter a password for the APEX_LISTENER user [*****]

Enter a password for the APEX_REST_PUBLIC_USER user []*****

…set_appun.sql

…setting session environment

…create APEX_LISTENER and APEX_REST_PUBLIC_USER users

…grants for APEX_LISTENER and ORDS_METADATA user

13. Exit form the terminal

14. Check the apex validity status

select comp_name, version, status from dba_registry where comp_id=’APEX’;

COMP_NAME VERSION STATUS

—————————— ————— ——————–

Oracle APEX 24.1.0 VALID

15. Check the apex and ords user status

col USERNAME format a20

col account_status format a20

select username, account_status from dba_users where account_status like ‘%EXPIRED%LOCKED%’;

USERNAME ACCOUNT_STATUS

——————– ——————–

ANONYMOUS EXPIRED & LOCKED

16. unlock the EXPIRED & LOCKED schema

alter user ANONYMOUS identified by Apex$123 account unlock;

LOG IN INTO ROOT USER THEN FOLLOW BELOW SOP

Edit the .bash_profile parameters

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORDS_HOME=/u01/ords/ords24

export ORDS_CONFIG=/u01/ords/ords24/config

#export JAVA_HOME=/u01/java/java17

export JAVA_HOME=/u01/java/java11

export CATALINA_HOME=/u01/tomcat/tomcat9

export PATH=$JAVA_HOME/bin:$PATH

export JAVA_OPTS=”-Dconfig.url=${ORDS_CONFIG} -Xms512M -Xmx1024M”

export JAVA_OPTS=”$JAVA_OPTS -Djava.awt.headless=true”

18. JAVA INSTALLATION

1. mkdir -p /u01/java/java17
2. mv jdk-17_linux-x64_bin.tar.gz java/
3. tar -xvf jdk-17_linux-x64_bin.tar.gz
4. After extract copy all the content in the 🡪 /u01/java/java17/
5. java –version

java version “17.0.12” 2024-07-16 LTS

Java(TM) SE Runtime Environment (build 17.0.12+8-LTS-286)

Java HotSpot(TM) 64-Bit Server VM (build 17.0.12+8-LTS-286, mixed mode, sharing)

19. ORDS Configuration

1. mkdir –p /u01/ords
2. unzip the software
3. After unzip copy all the content in the 🡪 /u01/ords/ords24/
4. Cd $ORDS_HOME/bin

Chmod 777 ords

1. $ORDS_HOME/bin/ords –config ${ORDS_CONFIG} install

Enter the database host name [localhost]: apex24.cao.local

Enter the database listen port [1521]: 1521

Enter the database service name [apex24]: apex24

Provide database user name with administrator privileges.

Enter the administrator username: sys

Enter the database password for SYS AS SYSDBA: ******

Retrieving information.

ORDS is not installed in the database. ORDS installation is required.

Enter a number to update the value or select option A to Accept and Continue

[1] Connection Type: Basic

[2] Basic Connection: HOST=apex24.cao.local PORT=1521 SERVICE_NAME=apex24.cao.local

Administrator User: SYS AS SYSDBA

[3] Database password for ORDS runtime user (ORDS_PUBLIC_USER): <generate>

[4] ORDS runtime user and schema tablespaces: Default: SYSAUX Temporary TEMP

[5] Additional Feature: Database Actions

[6] Configure and start ORDS in Standalone Mode: Yes

[7] Protocol: HTTP

[8] HTTP Port: 8080

[9] APEX static resources location:

[A] Accept and Continue – Create configuration and Install ORDS in the database

[Q] Quit – Do not proceed. No changes

Choose [A]: A

f) Go to /u01/ords/ords24 🡪 Copy the ords.war to the /u01/tomcat/tomcat9/webapps/

g) create i named folder in /u01/tomcat/tomcat9/webapps

mkdir –p /u01/tomcat/tomcat9/webapps/i

h) Copy the images available in apex folder into /u01/tomcat/tomcat9/webapps/i

cd /u01/app/oracle/product/19.0.0.1/dbhome/apex/apex/images

scp –r * /u01/tomcat/tomcat9/webapps/i/

j) Add the ords24 into oracle enterprise manager

k) check the account status of APEX and ORDS schema

If status is locked unlock the same

20. Tomact configuration

a. mkdir -p /u01/tomcat/tomcat9

b. mv apache-tomcat-9.0.93.tar.gz tomcat/tomcat9/

c. tar -xvf apache-tomcat-9.0.93.tar.gz

After extract copy all the content in the 🡪 /u01/tomcat/tomcat9/

d. /u01/tomcat/tomcat9/bin

e. sh startup.sh

Check the apache tomcat service using

192.168.2.87:8080/

21. Check the apex server through browser

192.168.2.87:8080/ords/

• Click on Oracle Apex create workspace as per your requirement.

22. JASPER SERVER CONFIGURATION

a. Download software

b. make a beleow entry in .bash_profile

export JAVA_OPTS=”$JAVA_OPTS -Djava.awt.headless=true”

c. copy the software in /u01/jasper (jri-2.7.1-jasper-6.16.0.zip)

d. unzip the software

e. echo $JAVA_OPTS

-Dconfig.url=/u01/ords/ords24/config -Xms512M -Xmx1024M -Djava.awt.headless=true

f. go to /u01/jasper/webapp AND rename jri.war to jasper.war

mv jri.war jasper.war

g. Shutdown tomcat

go to cd /u01/tomcat/tomcat9/bin

sh shutdown.sh

h. copy jasper.war to /u01/tomcat/tomcat9/webapp/

cd /u01/jasper/webapp/

cp jasper.war /u01/tomcat/tomcat9/webapps/

j. cd /u01/jasper/bin/

./setConfigDir.sh /u01/tomcat/tomcat9/webapps/jasper.war /u01/jasper/

process web.xml

replace config.home with directory: /u01/jasper/

k. edit application.properties file

cd /u01/jasper/conf/

vi application.properties

Change the below parameters as per requirement

amended

[datasource:default]

type=jdbc

name=default

url=jdbc:oracle:thin:@192.168.2.87:1521:ords24.cao.local

username=hr

password=hr123

default

[datasource:default]

type=jdbc

name=default

url=jdbc:oracle:thin:@127.0.0.1:1521:XE

username=my_oracle_user

password=my_oracle_user_pwd

l. encrypt the passwords

cd /u01/jasper/bin

./encryptPasswords.sh /u01/jasper/conf/application.properties

m. verify the encryption

after encryption

[datasource:default]

type=jdbc

name=default

url=jdbc:oracle:thin:@192.168.2.87:1521:ords24.cao.local

username=hr

password=1:/Tx9z251UP2i3R5WDWH3fw==

Without encryption

[datasource:default]

type=jdbc

name=default

url=jdbc:oracle:thin:@192.168.2.87:1521:ords24.cao.local

username=hr

password=hr123

n. restart tomcat server.

o. access through the browser and verify

p. Click on test report and check the connectivity status

q. adding ne schema to ords

go to /u01/jasper/conf/ and edit application.properties file

[datasource:jas_test]

type=jdbc

name=default

url=jdbc:oracle:thin:@192.168.2.87:1521/ords24.cao.local

username=jas_test

password=1:2JysWL/GxfBtmNOkU3nrvA==

restart tomcat