- Install ORDS 22 on RHEL
Assumption -
1. ORDS Installation Directory : /u01/ords22
|
Unzip ORDS media to this folder
2. ORDS config directory : /u01/ords22/config
|
mkdir -p /u01/ords22/config
Install & Source JAVA Environment
export JAVA_HOME=/u01/ords22/java/jdk-17.0.4
export PATH=$JAVA_HOME/bin:$PATH
which java
/u01/ords22/java/jdk-17.0.4/bin/java
Invoke ORDS Installation
ords --config /u01/ords22/config install
ORDS: Release 22.2 Production on Mon Aug 01 22:16:41 2022
Copyright (c) 2010, 2022, Oracle.
Configuration: /u01/ords22/config
The configuration folder /u01/ords22/config does not contain any configuration files.
Oracle REST Data Services - Interactive Install
Enter a number to select the type of installation
[1] Install or upgrade ORDS in the database only
[2] Create or update a database pool and install/upgrade ORDS in the database
[3] Create or update a database pool only
Choose [2]: 2
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]: 172.xx.xxx.xx
Enter the database listen port [1521]: 1524
Enter the database service name [orcl]: DEV
Provide database user name with administrator privileges.
Enter the administrator username: sys as sysdba
Enter the database password for sys as sysdba: password
Connecting to database user: sys as sysdba url: jdbc:oracle:thin:@//172.xx.xxx.xx:1524/dev
Retrieving information.
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Connecting to database user: ORDS_PUBLIC_USER url:
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 use HTTP or HTTPS protocol
[1] HTTP
[2] HTTPS
Choose [1]: 2
Enter the HTTPS port [8443]:
Enter a number to select the certificate type
[1] Use self-signed certificate (generates automatically)
[2] Use my SSL certificate (requires SSL certificate and SSL certificate private key)
Choose [1]:
Enter the SSL hostname: xxxxx.test.com
The setting named: db.connectionType was set to: basic in configuration: default
The setting named: db.hostname was set to: 172.xx.xxx.xx in configuration: default
The setting named: db.port was set to: 1524 in configuration: default
The setting named: db.servicename was set to:dev in configuration: default
The setting named: plsql.gateway.mode was set to: proxied in configuration: default
The setting named: db.username was set to: ORDS_PUBLIC_USER in configuration: default
The setting named: db.password was set to: ****** 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: wwv_flow_epg_include_modules.authorize in configuration: default
The global setting named: standalone.https.port was set to: 8443
The global setting named: standalone.https.host was set to: xxxxxxxxxxxx
The global setting named: standalone.context.path was set to: /ords
The global setting named: standalone.doc.root was set to: /u01/ords22/config/global/doc_root
------------------------------------------------------------
Date : 07 Aug 2022 23:19:41
Release : Oracle REST Data Services 22.2.1.r2021302
Database : Oracle Database 19c Enterprise Edition
DB Version : 19.3.0.0.0
[*** script: ords_change_password.sql]
PL/SQL procedure successfully completed.
2022-08-01T22:19:43.863Z INFO Completed updating database password for ORDS_PUBLIC_USER. Elapsed time: 00:00:01.921
[*** Info: Completed updating database password for ORDS_PUBLIC_USER. Elapsed time: 00:00:01.921 ]
2022-08-01T22:19:46.123Z INFO HTTPS and HTTPS/2 listening on host: 0.0.0.0 port: 8443
2022-08-01T22:19:46.145Z INFO Disabling document root because the specified folder does not exist: /u01/ords22/config/global/doc_root
2022-08-01T22:19:50.151Z INFO Configuration properties for: |default|lo|
db.servicename=dev
standalone.context.path=/ords
db.hostname=172.xx.xxx.xx
db.password=******
standalone.https.host=xxxxxxx
conf.use.wallet=true
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
database.api.enabled=true
db.username=ORDS_PUBLIC_USER
restEnabledSql.active=true
resource.templates.enabled=false
plsql.gateway.mode=proxied
db.port=1524
feature.sdw=true
standalone.https.port=8443
config.required=true
db.connectionType=basic
standalone.doc.root=/u01/ords22/config/global/doc_root
2022-08-01T22:20:01.295Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 22.2.1.r2021302
Oracle REST Data Services server info: jetty/9.4.48.v20220622
Oracle REST Data Services java info: Java HotSpot(TM) 64-Bit Server VM 17.0.4+11-LTS-179
- Startup Standalone ORDS
export PATH=$JAVA_HOME/bin:$PATH
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
cd /u01/ords22/bin
ords --config /u01/ords22/config serve
- Startup ORDS using Apache Tomcat
export JAVA_HOME=/u01/ords22/java/jdk-17.0.4
export PATH=$JAVA_HOME/bin:$PATH
export JAVA_OPTS="-Dconfig.url=/u01/ords22/config -Xms1024M -Xmx1024M"
cd /u01/Apache/apache-tomcat-9.0.65/bin
./startup.sh
- Shutdown Apache Tomcat
cd /u01/Apache/apache-tomcat-9.0.65/bin
./shutdown.sh
No comments:
Post a Comment