$ ords -h
2025-07-08T21:09:46Z INFO ORDS has not detected the option '--config' and this will be set up to the default directory.
ORDS: Release 25.2 Production on Tue Jul 08 21:09:48 2025
Copyright (c) 2010, 2025, Oracle.
Configuration:
/etc/ords/config
Usage:
ords [OPTIONS] [COMMAND]
Oracle REST Data Services command line interface
Options:
--config <folder> Path to Oracle REST Data Services
configuration folder
--debug Equivalent to --verbose
-h, --help Show usage information for the command
--java-options <options...>
To specify additional Java options that should
be passed to the Java Virtual Machine
-v, --verbose Configure Oracle REST Data Services to run in
verbose mode
--version Show version information
Commands:
config Configure application and database connection
pool settings
extract Extracts Oracle REST Data Services scripts.
install Configure database connection and
install/upgrade Oracle REST Data Services
schema, ORDS database user and related
database objects.
migrate Migrates Oracle REST Data Services
configuration files and parameter file from
release 21.4.x and earlier releases.
pool Monitor pools of a running Oracle REST Data
Services instance
serve Launch Oracle REST Data Services in standalone
mode
uninstall Uninstall Oracle REST Data Services schema,
ORDS database user and related database
objects.
war Create a web application from the the
distributed ords.war that can be deployed in a
supported servlet container.
Run ords <COMMAND> --help for more information on a command.
For example run: ords config --help
$ ords config list
$ ords config set jdbc.InitialLimit 20
Setting
Value
Source
Description
database.api.enabled
true
Global
Specifies whether the Database API is enabled.
db.connectionType
basic
Pool
db.hostname
db-host-name
Pool
db.password
*****
Pool Wallet
db.port
1521
Pool
db.servicename
FREEPDB1
Pool
db.username
ORDS_PUBLIC_USER
Pool
db.invalidPoolTimeout
2m
Pool
Specifies how long to wait before retrying an invalid pool. Default value: 15m
feature.sdw
true
Pool
Specifies to enable the Database Actions feature.
jdbc.InitialLimit
20
Pool
Specifies the initial size for the number of connections that will be created.
jdbc.MaxLimit
50
Pool
Specifies the maximum number of connections.
jdbc.MinLimit
20
Pool
Specifies the minimum number of connections.
plsql.gateway.mode
proxied
Pool
Indicates if the PL/SQL Gateway functionality should be available for a pool or not.
restEnabledSql.active
true
Pool
security.requestValidationFunction
ords_util.authorize_plsql_gateway
Pool
Specifies a validation function to determine if the requested procedure in the URL should be allowed or disallowed for processing.
standalone.doc.root
/etc/ords/config/global/doc_root
Global
Points to the location where static resources to be served under the / root server path are located.