Skip to content

Instantly share code, notes, and snippets.

@fatih-keles
Created April 13, 2023 09:20
Show Gist options
  • Save fatih-keles/3da36010e17ed922a2b0f4ed55284878 to your computer and use it in GitHub Desktop.
Save fatih-keles/3da36010e17ed922a2b0f4ed55284878 to your computer and use it in GitHub Desktop.
[root@ords-2 ~]# ords install adb --interactive --prompt-password --log-folder /u01/ords/log
2023-04-13T09:14:50Z INFO ORDS has not detected the option '--config' and this will be set up to the default directory.
ORDS: Release 23.1 Production on Thu Apr 13 09:14:52 2023
Copyright (c) 2010, 2023, 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: /u01/ords/config/Wallet_ML3DOZ8P2WLCQEKW.zip
Enter a number to select the TNS Network alias to use
[1] ML3DOZ8P2WLCQEKW_LOW ...service_name=gf5f9ffc50769d0_ml3doz8p2wlcqekw_low.adb....
[2] ML3DOZ8P2WLCQEKW_MEDIUM ...service_name=gf5f9ffc50769d0_ml3doz8p2wlcqekw_medium.a...
[3] ML3DOZ8P2WLCQEKW_HIGH ...service_name=gf5f9ffc50769d0_ml3doz8p2wlcqekw_high.adb...
[4] ML3DOZ8P2WLCQEKW_TP ...service_name=gf5f9ffc50769d0_ml3doz8p2wlcqekw_tp.adb.o...
[5] ML3DOZ8P2WLCQEKW_TPURGENT ...service_name=gf5f9ffc50769d0_ml3doz8p2wlcqekw_tpurgent...
Choose [1]: 4
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: ML3DOZ8P2WLCQEKW_TP
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
Checking Autonomous database user: ORDS_PUBLIC_USER2 TNS Service: ML3DOZ8P2WLCQEKW_TP
Checking Autonomous database user: ORDS_PLSQL_GATEWAY2 TNS Service: ML3DOZ8P2WLCQEKW_TP
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]: 1
Enter a number to select the protocol
[1] HTTP
[2] HTTPS
Choose [1]: 1
Enter the HTTP port [8080]:
The setting named: db.wallet.zip.path was set to: /u01/ords/config/Wallet_ML3DOZ8P2WLCQEKW.zip in configuration: default
The setting named: db.wallet.zip.service was set to: ML3DOZ8P2WLCQEKW_TP 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
2023-04-13T09:17:28.497Z INFO HTTP and HTTP/2 cleartext listening on host: 0.0.0.0 port: 8080
2023-04-13T09:17:28.535Z INFO Disabling document root because the specified folder does not exist: /etc/ords/config/global/doc_root
2023-04-13T09:17:33.308Z 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=ML3DOZ8P2WLCQEKW_TP
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=/u01/ords/config/Wallet_ML3DOZ8P2WLCQEKW.zip
feature.sdw=true
config.required=true
standalone.doc.root=/etc/ords/config/global/doc_root
2023-04-13T09:17:33.406Z WARNING *** jdbc.MaxLimit in configuration |default|lo| is using a value of 20, this setting may not be sized adequately for a production environment ***
2023-04-13T09:17:33.406Z WARNING *** jdbc.InitialLimit in configuration |default|lo| is using a value of 3, this setting may not be sized adequately for a production environment ***
2023-04-13T09:17:38.680Z INFO
Mapped local pools from /etc/ords/config/databases:
/ords/ => default => VALID
2023-04-13T09:17:38.793Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 23.1.0.r0861423
Oracle REST Data Services server info: jetty/10.0.12
Oracle REST Data Services java info: Java HotSpot(TM) 64-Bit Server VM 19.0.2+7-44
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment