Complete newbie to ORDS and fairly new to APEX
I have an Free Tier ADB-S (shared autonomous database) running APEX - all ok.
Version database = 23ai, Apex = 23.2
Ultimately I want to have a custom URL so believe one (of many) pre-requisites is to have Custom Managed ORDS
Hence following this doc : https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/24.1/ordig/installing-and-configuring-customer-managed-ords-autonomous-database.html#GUID-DE69D4CB-A2EF-49BD-B283-76CB255489C0
Problem: cannot connect to http://{public IPv4 address}:8080/ords/apex (from remote PC). Not sure if Linux server has browser.
Theories: VNIC ?, incompatible versions (ords/apex), privileges (opc vs oracle), certificate (lack of), static images (lack of)
I can confirm that database user ORDS_PUBLIC_USER2 has last_login value.
( I did not capture how I copied Wallet etc )
I have captured most output - except how I copied Wallet etc
Note some installations run as opc, some as oracle - documentation did not specify.
Installations :
[opc@instance-20240518-c ~]$ sudo yum install ords
Last metadata expiration check: 0:03:35 ago on Sat 18 May 2024 03:40:17 AM GMT.
Dependencies resolved.
=============================================================================================================================================================================================================================================
Package Architecture Version Repository Size
=============================================================================================================================================================================================================================================
Installing:
ords noarch 24.1.1-4.el8 ol8_oci_included 115 M
Transaction Summary
=============================================================================================================================================================================================================================================
Install 1 Package
Total download size: 115 M
Installed size: 119 M
Is this ok \[y/N\]: y
Downloading Packages:
ords-24.1.1-4.el8.noarch.rpm 29 MB/s | 115 MB 00:03
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 29 MB/s | 115 MB 00:03
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: ords-24.1.1-4.el8.noarch 1/1
Installing : ords-24.1.1-4.el8.noarch 1/1
Running scriptlet: ords-24.1.1-4.el8.noarch 1/1
WARN: ORDS requires Java 11 or 17.
You can install Oracle Java at https://www.oracle.com/java/technologies/downloads/#java11.
INFO: Before starting ORDS service, run the below command as user oracle:
ords --config /etc/ords/config install
INFO: To enable the ORDS service during startup, run the below command:
sudo systemctl enable ords
Verifying : ords-24.1.1-4.el8.noarch 1/1
Installed:
ords-24.1.1-4.el8.noarch
Complete!
\[opc@instance-20240518-c ~\]$ sudo dnf install -y jdk-22-headful
Last metadata expiration check: 0:25:57 ago on Sat 18 May 2024 03:40:17 AM GMT.
Dependencies resolved.
=============================================================================================================================================================================================================================================
Package Architecture Version Repository Size
=============================================================================================================================================================================================================================================
Installing:
jdk-22-headful x86\_64 2000:22.0.1-8.el8 ol8\_oci\_included 123 M
Installing dependencies:
alsa-lib x86\_64 1.2.9-1.el8 ol8\_appstream 497 k
jdk-22-headless x86\_64 2000:22.0.1-8.el8 ol8\_oci\_included 64 M
libXi x86\_64 1.7.10-1.el8 ol8\_appstream 49 k
libXtst x86\_64 1.2.3-7.el8 ol8\_appstream 22 k
Transaction Summary
=============================================================================================================================================================================================================================================
Install 5 Packages
Total download size: 187 M
Installed size: 328 M
Downloading Packages:
(1/5): alsa-lib-1.2.9-1.el8.x86\_64.rpm 4.0 MB/s | 497 kB 00:00
(2/5): libXi-1.7.10-1.el8.x86\_64.rpm 3.1 MB/s | 49 kB 00:00
(3/5): libXtst-1.2.3-7.el8.x86\_64.rpm 1.2 MB/s | 22 kB 00:00
(4/5): jdk-22-headless-22.0.1-8.el8.x86\_64.rpm 21 MB/s | 64 MB 00:03
(5/5): jdk-22-headful-22.0.1-8.el8.x86\_64.rpm 23 MB/s | 123 MB 00:05
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 35 MB/s | 187 MB 00:05
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : libXi-1.7.10-1.el8.x86\_64 1/5
Installing : libXtst-1.2.3-7.el8.x86\_64 2/5
Installing : alsa-lib-1.2.9-1.el8.x86\_64 3/5
Running scriptlet: alsa-lib-1.2.9-1.el8.x86\_64 3/5
Installing : jdk-22-headless-2000:22.0.1-8.el8.x86\_64 4/5
Running scriptlet: jdk-22-headless-2000:22.0.1-8.el8.x86\_64 4/5
Installing : jdk-22-headful-2000:22.0.1-8.el8.x86\_64 5/5
Running scriptlet: jdk-22-headful-2000:22.0.1-8.el8.x86\_64 5/5
Verifying : jdk-22-headful-2000:22.0.1-8.el8.x86\_64 1/5
Verifying : jdk-22-headless-2000:22.0.1-8.el8.x86\_64 2/5
Verifying : alsa-lib-1.2.9-1.el8.x86\_64 3/5
Verifying : libXi-1.7.10-1.el8.x86\_64 4/5
Verifying : libXtst-1.2.3-7.el8.x86\_64 5/5
Installed:
alsa-lib-1.2.9-1.el8.x86\_64 jdk-22-headful-2000:22.0.1-8.el8.x86\_64 jdk-22-headless-2000:22.0.1-8.el8.x86\_64 libXi-1.7.10-1.el8.x86\_64 libXtst-1.2.3-7.el8.x86\_64
Complete!
\[oracle@instance-20240518-c ~\]$ ords install adb --interactive --prompt-password --log-folder /home/oracle/ords\_logs
ords install adb --interactive --prompt-password --log-folder /home/oracle/ords\_logs
2024-05-18T04:20:11Z INFO ORDS has not detected the option '--config' and this will be set up to the default directory.
ORDS: Release 24.1 Production on Sat May 18 04:20:19 2024
Copyright (c) 2010, 2024, Oracle.
Configuration:
/etc/ords/config
The configuration folder /etc/ords/config does not contain any configuration files.
Oracle REST Data Services - Interactive Customer Managed ORDS for Autonomous Database
Enter the Autonomous Database Wallet path: /home/oracle/Wallet\_KT01.zip
Enter a number to select the TNS Network alias to use
\[1\] KT01\_LOW SERVICE\_NAME=gce05ccf72274fb\_kt01\_low.adb.oraclecloud.com
\[2\] KT01\_MEDIUM SERVICE\_NAME=gce05ccf72274fb\_kt01\_medium.adb.oraclecloud.com
\[3\] KT01\_HIGH SERVICE\_NAME=gce05ccf72274fb\_kt01\_high.adb.oraclecloud.com
Choose \[1\]: 2
Provide database user name with administrator privileges.
Enter the administrator username \[ADMIN\]:
Enter the database password for ADMIN:
Connecting to Autonomous database user: ADMIN TNS Service: KT01\_MEDIUM
Enter the ORDS runtime database username \[ORDS\_PUBLIC\_USER2\]:
Enter the database password for ORDS\_PUBLIC\_USER2:
Confirm password:
Enter the PL/SQL Gateway database username: ORDS\_PLSQL\_GATEWAY2
Enter the database password for ORDS\_PLSQL\_GATEWAY2:
Confirm password:
Retrieving information
Enter a number to select additional feature(s) to enable:
\[1\] Database Actions (Enables all features)
\[2\] REST Enabled SQL and Database API
\[3\] REST Enabled SQL
\[4\] Database API
\[5\] None
Choose \[1\]: 1
Enter a number to configure and start ORDS in standalone mode
\[1\] Configure and start ORDS in standalone mode
\[2\] Skip
Choose \[1\]:
Enter a number to select the protocol
\[1\] HTTP
\[2\] HTTPS
Choose \[1\]:
Enter the HTTP port \[8080\]:
Enter the APEX static resources location:
The setting named: db.wallet.zip.path was set to: /home/oracle/Wallet\_KT01.zip in configuration: default
The setting named: db.wallet.zip.service was set to: KT01\_MEDIUM in configuration: default
The setting named: db.username was set to: ORDS\_PUBLIC\_USER2 in configuration: default
The setting named: db.password was set to: \*\*\*\*\*\* in configuration: default
The setting named: plsql.gateway.mode was set to: proxied in configuration: default
The setting named: feature.sdw was set to: true in configuration: default
The global setting named: database.api.enabled was set to: true
The setting named: restEnabledSql.active was set to: true in configuration: default
The setting named: security.requestValidationFunction was set to: ords\_util.authorize\_plsql\_gateway in configuration: default
The global setting named: standalone.http.port was set to: 8080
The global setting named: standalone.context.path was set to: /ords
The global setting named: standalone.doc.root was set to: /etc/ords/config/global/doc\_root
2024-05-18T04:26:49.229Z INFO Connecting to Autonomous database user: ADMIN TNS Service: KT01\_MEDIUM
2024-05-18T04:26:57.258Z INFO ... Verifying Autonomous Database runtime user
2024-05-18T04:26:59.732Z INFO ... Verifying Autonomous Database gateway user
2024-05-18T04:26:59.747Z INFO Completed configuring for Customer Managed Oracle REST Data Services version 24.1.1.r1201228. Elapsed time: 00:00:10.497
2024-05-18T04:26:59.749Z INFO Log file written to /home/oracle/ords\_logs/ords\_adb\_2024-05-18\_042648\_64571.log
2024-05-18T04:27:00.652Z INFO HTTP and HTTP/2 cleartext listening on host: 0.0.0.0 port: 8080
2024-05-18T04:27:00.754Z INFO Disabling document root because the specified folder does not exist: /etc/ords/config/global/doc\_root
2024-05-18T04:27:00.755Z INFO Default forwarding from / to contextRoot configured.
2024-05-18T04:27:26.563Z INFO Configuration properties for: |default|lo|
standalone.context.path=/ords
db.password=\*\*\*\*\*\*
conf.use.wallet=true
security.requestValidationFunction=ords\_util.authorize\_plsql\_gateway
db.wallet.zip.service=KT01\_MEDIUM
database.api.enabled=true
db.username=ORDS\_PUBLIC\_USER2
standalone.http.port=8080
restEnabledSql.active=true
resource.templates.enabled=false
plsql.gateway.mode=proxied
db.wallet.zip.path=/home/oracle/Wallet\_KT01.zip
feature.sdw=true
config.required=true
standalone.doc.root=/etc/ords/config/global/doc\_root
2024-05-18T04:27:26.747Z WARNING \*\*\* jdbc.MaxLimit in configuration |default|lo| is using a value of 10, this setting may not be sized adequately for a production environment \*\*\*
2024-05-18T04:27:26.748Z WARNING \*\*\* jdbc.InitialLimit in configuration |default|lo| is using a value of 10, this setting may not be sized adequately for a production environment \*\*\*
2024-05-18T04:27:39.032Z INFO
Mapped local pools from /etc/ords/config/databases:
/ords/ => default => VALID
2024-05-18T04:27:39.561Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 24.1.1.r1201228
Oracle REST Data Services server info: jetty/10.0.20
Oracle REST Data Services java info: Java HotSpot(TM) 64-Bit Server VM 22.0.1+8-16
\< not sure if hung but connection to linux host eventually dropped >
Tests - not sure what else to try (documentation is not helpful )
Rebooted server
On remote PC, using Chrome http://{public IPv4 address}:8080/ords/apex (timeout)
As opc
\[opc@instance-20240518-c ~\]$ sudo systemctl status ords
● ords.service - Oracle REST Data Services
Loaded: loaded (/etc/systemd/system/ords.service; disabled; vendor preset: disabled)
Active: activating (start) since Sat 2024-05-18 07:28:54 GMT; 24s ago
Cntrl PID: 8096 (ords)
Tasks: 5 (limit: 5483)
Memory: 42.2M
CGroup: /system.slice/ords.service
├─8096 /bin/bash /etc/init.d/ords start
├─8270 /bin/bash /etc/init.d/ords start
├─8271 timeout -s SIGKILL 20 bash -c exit\_code=0 # Escape the variable contents current\_ords\_pid=8245 while true; do if ps -p "$current\_ords\_pid" &> /dev/null; then ords\_bound\_ports="$( get\_ords\_bound\_ports )" if \[\[ -n "$>
├─8272 bash -c exit\_code=0 # Escape the variable contents current\_ords\_pid=8245 while true; do if ps -p "$current\_ords\_pid" &> /dev/null; then ords\_bound\_ports="$( get\_ords\_bound\_ports )" if \[\[ -n "$ords\_bound\_ports" \]\]; >
└─8363 sleep 1
May 18 07:28:54 instance-20240518-c systemd\[1\]: Starting Oracle REST Data Services...
May 18 07:29:05 instance-20240518-c bash\[8096\]: INFO: Starting Oracle REST Data Services...
May 18 07:29:05 instance-20240518-c sudo\[8164\]: root : PWD=/home/oracle ; USER=oracle ; COMMAND=/bin/bash
May 18 07:29:07 instance-20240518-c bash\[8096\]: INFO: Oracle REST Data Services started with PID 8245
May 18 07:29:07 instance-20240518-c bash\[8096\]: INFO: Obtaining the port binding information...
\[opc@instance-20240518-c ~\]$ sudo firewall-cmd --zone=public --add-port 8080/tcp
Warning: ALREADY\_ENABLED: '8080:tcp' already in 'public'
success