This article provides an overview of using Oracle REST Data Services (ORDS) version 22.1 onward in standalone mode.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532
export JAVA_HOME=/u01/java/latest
export ORDS_HOME=/u01/ords
export ORDS_CONFIG=/u01/config/ords
export PATH=${ORDS_HOME}/bin:${PATH}
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve
http://localhost:8080/ords/
#!/bin/bash
export PATH=/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:$PATH
export JAVA_HOME=/u01/java/latest
export ORDS_HOME=/u01/ords
export ORDS_CONFIG=/u01/config/ords
LOGFILE=/home/oracle/scripts/logs/ords-`date +"%Y""%m""%d"`.log
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
nohup ${ORDS_HOME}/bin/ords --config ${ORDS_CONFIG} serve >> $LOGFILE 2>&1 &
echo "View log file with : tail -f $LOGFILE"
#!/bin/bash
export PATH=/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:$PATH
kill `ps -ef | grep [o]rds.war | awk '{print $2}'`
mkdir -p ~/scripts/logs
chmod u+x ~/scripts/*.sh
~/scripts/stop_ords.sh
~/scripts/start_ords.sh
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve --secure --port 8443
https://localhost:8443/ords/
ords --config ${ORDS_CONFIG} config set standalone.https.port 8443
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve
mkdir ~/keystore
cd ~/keystore
# Create a self-signed certificate in a JKS keystore.
$JAVA_HOME/bin/keytool -genkey -keyalg RSA -alias selfsigned -keystore keystore.jks \
-dname "CN=`hostname`, OU=Example Department, O=Example Company, L=Birmingham, ST=West Midlands, C=GB" \
-storepass password1 -validity 3600 -keysize 2048 -keypass password1
# Create a PKCS12 keystore from the JKS keystore.
$JAVA_HOME/bin/keytool -importkeystore -srckeystore keystore.jks -srcalias selfsigned -srcstorepass password1 \
-destkeystore keystore.p12 -deststoretype PKCS12 -deststorepass password1 -destkeypass password1
# Extract the key and certificate in PEM format.
openssl pkcs12 -in keystore.p12 -nodes -nocerts -out `hostname`-key.pem
openssl pkcs12 -in keystore.p12 -nokeys -out `hostname`.pem
# Convert them to DER format.
openssl pkcs8 -topk8 -inform PEM -outform DER -in `hostname`-key.pem -out `hostname`-key.der -nocrypt
openssl x509 -inform PEM -outform DER -in `hostname`.pem -out `hostname`.der
$ ls *.der
localhost.localdomain.der localhost.localdomain-key.der
$
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve --certificate ~/keystore/localhost.localdomain.der --key ~/keystore/localhost.localdomain-key.der
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve --secure --port 8443 --certificate ~/keystore/localhost.localdomain.der --key ~/keystore/localhost.localdomain-key.der
https://localhost:8443/ords/
ords --config ${ORDS_CONFIG} config set standalone.https.port 8443
ords --config ${ORDS_CONFIG} config set standalone.https.cert ~/keystore/localhost.localdomain.der
ords --config ${ORDS_CONFIG} config set standalone.https.cert.key ~/keystore/localhost.localdomain-key.der
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve
export APEX_IMAGES=/u01/software/apex/images
ords --config ${ORDS_CONFIG} config set standalone.static.path ${APEX_IMAGES}
~/scripts/stop_ords.sh
~/scripts/start_ords.sh
mkdir -p ${ORDS_CONFIG}/global/doc_root
ords --config ${ORDS_CONFIG} config set standalone.doc.root ${ORDS_CONFIG}/global/doc_root
~/scripts/stop_ords.sh
~/scripts/start_ords.sh
ords --config ${ORDS_CONFIG} config set error.externalPath ~/error-pages
mkdir -p ~/error-pages
echo "404 Error: Whoops" > ~/error-pages/404.html
echo "500 Error: Whoops" > ~/error-pages/500.html
~/scripts/stop_ords.sh
~/scripts/start_ords.sh
ords --config ${ORDS_CONFIG} config set standalone.access.log ${ORDS_CONFIG}/logs
~/scripts/stop_ords.sh
~/scripts/start_ords.sh
$
ords config info
ORDS: Release 22.1 Production on Fri Apr 22 10:16:02 2022
Copyright (c) 2010, 2022, Oracle.
Configuration:
/u01/config/ords/
Settings:
apex.security.administrator.rolesComma de-limited list of
additional roles to assign
authenticated APEX
administrator type users.
apex.security.developer.roles Comma de-limited list of
additional roles to assign
authenticated APEX developer
type users.
apex.security.user.roles Comma de-limited list of
additional roles to assign
authenticated regular APEX
users.
autoupgrade.api.aulocation A configuration setting for
AutoUpgrade.jar location.
autoupgrade.api.enabled A configuration setting to
enable AutoUpgrade REST API
features.
autoupgrade.api.jvmlocation A configuration setting for
AutoUpgrade REST API JVM
location.
autoupgrade.api.loglocation A configuration setting for
AutoUpgrade REST API log
location.
cache.metadata.enabled Specifies the setting to
enable or disable metadata
caching.
cache.metadata.timeout Specifies the setting to
determine for how long a
metadata record remains in
the cache. Longer duration
means, it takes longer to
view the applied changes. The
formats accepted are based on
the ISO-8601 duration format.
database.api.enabled Enable Database API feature.
database.api.management.services.disabledDisable the Database API
administration related
services. Only applicable
when Database API is enabled.
db.adminUser The username for the database
account that ORDS will use
for administration operations
in the database.
db.adminUser.password The password for the database
account that ORDS will use
for administration operations
in the database.
db.cdb.adminUser The username for the database
account that ORDS will use
for Pluggable Database
Lifecycle Management.
db.cdb.adminUser.password The password for the database
account that ORDS will use
for Pluggable Database
Lifecycle Management.
db.connectionType The database connection type.
Specify one of the values:
basic, tns, customurl.
db.credentialsSource Specifies the source for
database credentials when
creating a direct connection
for running SQL statements.
Value can be one of: pool or
request. If pool is used, the
credentials defined in this
pool will be used to create a
JDBC connection. If request
is used, the credentials in
the request will be used to
create a JDBC connection and
if successful grant the
requestor SQL Developer role.
The default value is pool.
db.customURL The JDBC URL connection to
connect to the database.
db.hostname The host name of the database
server.
db.invalidPoolTimeout Specifies how long to wait
before retrying an invalid
pool.
db.password The database password.
db.poolDestroyTimeout Indicates how long to wait to
gracefully destroy a pool,
before moving to forcefully
destroy all connections
including borrowed ones.
db.port The port of the database
server listener.
db.serviceNameSuffix The service name suffix for
PDBs connected to the CDB.
db.servicename The database service name.
db.tnsAliasName The TNS alias name that
matches the name in the
tnsnames.ora file.
db.tnsDirectory The directory location of
your tnsnames.ora file.
db.username The database user name.
db.wallet.zip The wallet archive (provided
in BASE64 encoding)
containing connection details
for the pool.
db.wallet.zip.path The path to a wallet archive
containing connection details
for the pool.
db.wallet.zip.service Specifies the service name in
the wallet archive for the
pool.
debug.printDebugToScreen Specifies whether to display
error messages in the browser.
debug.trackResources Enable tracking of JDBC
resources that if not
released will cause resource
leaks/exhaustion in the
database. Tracking imposes a
performance overhead.
error.externalPath The path to the external
error pages.
error.responseFormat Specifies in what format
error responses should be
rendered. Possible values:
HTTP, JSON, AUTO. Defaults to
AUTO.
feature.openservicebroker.excludeTo disable the Open Service
Broker services available for
the pool.
feature.sdw Enable Database Actions
feature.
http.cookie.filter A comma separated list of
HTTP Cookies to exclude when
initializing an Oracle Web
Agent environment.
icap.port Specifies the Internet
Content Adaptation Protocol
(ICAP) port to virus scan
files. Either icap.port or
icap.secure.port are required
to have a value when
icap.server is set.
icap.secure.port Specifies the Internet
Content Adaptation Protocol
(ICAP) secure port to virus
scan files. Either icap.port
or icap.secure.port are
required to have a value when
icap.server is set.
icap.server Specifies the Internet
Content Adaptation Protocol
(ICAP) server name or IP
address to virus scan files.
jdbc.DriverType The Oracle JDBC URL subtype
that can have one of the
values: thin, oci8. Defaults
to thin.
jdbc.InactivityTimeout Specify how long an available
connection can remain idle
before it is closed. The
inactivity connection timeout
is in seconds. Defaults to
1800.
jdbc.InitialLimit The initial size for the
number of connections that
will be created. Defaults to
10.
jdbc.MaxConnectionReuseCount Specify the maximum number of
times to reuse a connection
before it is discarded and
replaced with a new
connection.
jdbc.MaxLimit The maximum number of
connections. Defaults to 10.
jdbc.MaxStatementsLimit The maximum number of
statements to cache for each
connection. Defaults to 10.
jdbc.MinLimit The minimum number of
connections. Defaults to 2.
jdbc.auth.admin.role Identifies the database role
that signifies the database
user should get the SQL
Administrator role.
jdbc.auth.enabled Specifies if the PL/SQL
Gateway calls can be
authenticated using database
users. Defaults to false. Set
to true to enable feature.
Oracle recommends not to use
this feature. This feature
used only to facilitate
customers migrating from
mod_plsql.
jdbc.cleanup.mode Specifies how a pooled JDBC
connection, and corresponding
database session, is released
when a request has been
processed.
jdbc.driverName The name of the JDBC driver
to use.
jdbc.statementTimeout Specify how long a borrowed
(in use) connection can
remain unused before it is
considered as abandoned and
reclaimed. The abandoned
connection timeout is in
seconds.
json.sdo.geometry.output.geojson Specify that SDO Geometry
data should be returned in
GeoJSON format.
misc.defaultPage Default page (PL/SQL
procedure) to invoke if the
URL points to the context
root of a database pool.
Default value is apex.
misc.pagination.maxRows Specifies the maximum number
of rows that will be returned
from a query when processing
a RESTful service and that
will be returned from a
nested cursor in a result
set. Affects all RESTful
services generated through a
SQL query, regardless of
whether the resource is
paginated. Defaults to 10000.
owa.trace.sql Boolean property that if true
causes a trace of the SQL
statements performed by
Oracle Web Agent to be echoed
to the log.
plsql.gateway.mode Indicates if the PL/SQL
Gateway functionality should
be available for a pool or
not. Value can be one of:
disabled, direct or proxied.
If direct is used, the pool
will serve PL/SQL Gateway
requests directly. If proxied
is used, PLSQL_GATEWAY_CONFIG
view is used to determine the
user to proxy to.
procedure.rest.preHook Name of a stored PL/SQL
function that should be
invoked prior to dispatching
any REST request.
request.traceHeaderName Denotes the name of the HTTP
request header that uniquely
identifies the request end to
end as it passes through the
various layers of the
application stack. In Oracle
this header is commonly
referred to as the ECID
(Entity Context ID).
resource.templates.enabled Deprecated. Configuration
property indicating if the
legacy resource templates
(APEX based REST) should be
enabled or not. False by
default. The
resource-templates code base
is not compatible with the
single pool
(ORDS_PUBLIC_USER)
architecture so must be
disabled.
restEnabledSql.active Enable REST-Enabled SQL
feature.
security.credentials.attempts The maximum number of
unsuccessful password
attempts allowed. Enabled by
setting a positive integer
value. Defaults to -1.
security.credentials.file The file where credentials
are stored.
security.credentials.lock.time The period to lock account
that has exceeded maximum
attempts. Defaults to 10
minutes.
security.requestValidationFunctionSpecifies a validation
function to determine if the
requested procedure in the
URL should be allowed or
disallowed for processing.
The function should return
true if the procedure is
allowed; otherwise, return
false.
security.validationFunctionType Indicate what type the
security.requestValidationFunc
ion is: javascript or plsql.
Defaults to plsql.
security.verifySSL Indicate whether HTTPS is
available in your environment.
standalone.access.log Path to the folder to store
HTTP request access logs. If
not specified then no access
log will be generated.
standalone.binds Comma separated list of host
names or IP addresses to
identify a specific network
interface on which to listen,
default 0.0.0.0.
standalone.context.path The context path where {0} is
located, defaults to /ords
standalone.doc.root Points to the location where
static resources, to be
served under the / root
server path are located.
standalone.http.port HTTP listen port, default 8080
standalone.https.cert SSL certificate path. If you
are providing the SSL
certificate, you must specify
the certificate location.
standalone.https.cert.key SSL certificate key path. If
you are providing the SSL
certificate, you must specify
the certificate key location.
standalone.https.host SSL certificate hostname
standalone.https.port HTTPS listen port, default
8443
standalone.static.context.path The Context path where
Application Express static
resources are located,
defaults to /i
standalone.static.path Path to the folder containing
static resources required by
APEX
standalone.stop.timeout The period for Standalone
Mode to wait to gracefully
shutdown.
$12345678910111213141516171819202122232425
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve
http://localhost:8080/ords/
#!/bin/bash
export PATH=/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:$PATH
export JAVA_HOME=/u01/java/latest
export ORDS_HOME=/u01/ords
export ORDS_CONFIG=/u01/config/ords
LOGFILE=/home/oracle/scripts/logs/ords-`date +"%Y""%m""%d"`.log
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
nohup ${ORDS_HOME}/bin/ords --config ${ORDS_CONFIG} serve >> $LOGFILE 2>&1 &
echo "View log file with : tail -f $LOGFILE"
#!/bin/bash
export PATH=/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:$PATH
kill `ps -ef | grep [o]rds.war | awk '{print $2}'`
mkdir -p ~/scripts/logs
chmod u+x ~/scripts/*.sh
~/scripts/stop_ords.sh
~/scripts/start_ords.sh1234567891011
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve --secure --port 8443
https://localhost:8443/ords/
ords --config ${ORDS_CONFIG} config set standalone.https.port 8443
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve1234567891011121314151617181920212223242526272829303132333435363738394041
mkdir ~/keystore
cd ~/keystore
# Create a self-signed certificate in a JKS keystore.
$JAVA_HOME/bin/keytool -genkey -keyalg RSA -alias selfsigned -keystore keystore.jks \
-dname "CN=`hostname`, OU=Example Department, O=Example Company, L=Birmingham, ST=West Midlands, C=GB" \
-storepass password1 -validity 3600 -keysize 2048 -keypass password1
# Create a PKCS12 keystore from the JKS keystore.
$JAVA_HOME/bin/keytool -importkeystore -srckeystore keystore.jks -srcalias selfsigned -srcstorepass password1 \
-destkeystore keystore.p12 -deststoretype PKCS12 -deststorepass password1 -destkeypass password1
# Extract the key and certificate in PEM format.
openssl pkcs12 -in keystore.p12 -nodes -nocerts -out `hostname`-key.pem
openssl pkcs12 -in keystore.p12 -nokeys -out `hostname`.pem
# Convert them to DER format.
openssl pkcs8 -topk8 -inform PEM -outform DER -in `hostname`-key.pem -out `hostname`-key.der -nocrypt
openssl x509 -inform PEM -outform DER -in `hostname`.pem -out `hostname`.der
$ ls *.der
localhost.localdomain.der localhost.localdomain-key.der
$
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve --certificate ~/keystore/localhost.localdomain.der --key ~/keystore/localhost.localdomain-key.der
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve --secure --port 8443 --certificate ~/keystore/localhost.localdomain.der --key ~/keystore/localhost.localdomain-key.der
https://localhost:8443/ords/
ords --config ${ORDS_CONFIG} config set standalone.https.port 8443
ords --config ${ORDS_CONFIG} config set standalone.https.cert ~/keystore/localhost.localdomain.der
ords --config ${ORDS_CONFIG} config set standalone.https.cert.key ~/keystore/localhost.localdomain-key.der
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
ords --config ${ORDS_CONFIG} serve123456
export APEX_IMAGES=/u01/software/apex/images
ords --config ${ORDS_CONFIG} config set standalone.static.path ${APEX_IMAGES}
~/scripts/stop_ords.sh
~/scripts/start_ords.sh123456
mkdir -p ${ORDS_CONFIG}/global/doc_root
ords --config ${ORDS_CONFIG} config set standalone.doc.root ${ORDS_CONFIG}/global/doc_root
~/scripts/stop_ords.sh
~/scripts/start_ords.sh12345678
ords --config ${ORDS_CONFIG} config set error.externalPath ~/error-pages
mkdir -p ~/error-pages
echo "404 Error: Whoops" > ~/error-pages/404.html
echo "500 Error: Whoops" > ~/error-pages/500.html
~/scripts/stop_ords.sh
~/scripts/start_ords.sh1234
ords --config ${ORDS_CONFIG} config set standalone.access.log ${ORDS_CONFIG}/logs
~/scripts/stop_ords.sh
~/scripts/start_ords.sh123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419
$
ords config info
ORDS: Release 22.1 Production on Fri Apr 22 10:16:02 2022
Copyright (c) 2010, 2022, Oracle.
Configuration:
/u01/config/ords/
Settings:
apex.security.administrator.rolesComma de-limited list of
additional roles to assign
authenticated APEX
administrator type users.
apex.security.developer.roles Comma de-limited list of
additional roles to assign
authenticated APEX developer
type users.
apex.security.user.roles Comma de-limited list of
additional roles to assign
authenticated regular APEX
users.
autoupgrade.api.aulocation A configuration setting for
AutoUpgrade.jar location.
autoupgrade.api.enabled A configuration setting to
enable AutoUpgrade REST API
features.
autoupgrade.api.jvmlocation A configuration setting for
AutoUpgrade REST API JVM
location.
autoupgrade.api.loglocation A configuration setting for
AutoUpgrade REST API log
location.
cache.metadata.enabled Specifies the setting to
enable or disable metadata
caching.
cache.metadata.timeout Specifies the setting to
determine for how long a
metadata record remains in
the cache. Longer duration
means, it takes longer to
view the applied changes. The
formats accepted are based on
the ISO-8601 duration format.
database.api.enabled Enable Database API feature.
database.api.management.services.disabledDisable the Database API
administration related
services. Only applicable
when Database API is enabled.
db.adminUser The username for the database
account that ORDS will use
for administration operations
in the database.
db.adminUser.password The password for the database
account that ORDS will use
for administration operations
in the database.
db.cdb.adminUser The username for the database
account that ORDS will use
for Pluggable Database
Lifecycle Management.
db.cdb.adminUser.password The password for the database
account that ORDS will use
for Pluggable Database
Lifecycle Management.
db.connectionType The database connection type.
Specify one of the values:
basic, tns, customurl.
db.credentialsSource Specifies the source for
database credentials when
creating a direct connection
for running SQL statements.
Value can be one of: pool or
request. If pool is used, the
credentials defined in this
pool will be used to create a
JDBC connection. If request
is used, the credentials in
the request will be used to
create a JDBC connection and
if successful grant the
requestor SQL Developer role.
The default value is pool.
db.customURL The JDBC URL connection to
connect to the database.
db.hostname The host name of the database
server.
db.invalidPoolTimeout Specifies how long to wait
before retrying an invalid
pool.
db.password The database password.
db.poolDestroyTimeout Indicates how long to wait to
gracefully destroy a pool,
before moving to forcefully
destroy all connections
including borrowed ones.
db.port The port of the database
server listener.
db.serviceNameSuffix The service name suffix for
PDBs connected to the CDB.
db.servicename The database service name.
db.tnsAliasName The TNS alias name that
matches the name in the
tnsnames.ora file.
db.tnsDirectory The directory location of
your tnsnames.ora file.
db.username The database user name.
db.wallet.zip The wallet archive (provided
in BASE64 encoding)
containing connection details
for the pool.
db.wallet.zip.path The path to a wallet archive
containing connection details
for the pool.
db.wallet.zip.service Specifies the service name in
the wallet archive for the
pool.
debug.printDebugToScreen Specifies whether to display
error messages in the browser.
debug.trackResources Enable tracking of JDBC
resources that if not
released will cause resource
leaks/exhaustion in the
database. Tracking imposes a
performance overhead.
error.externalPath The path to the external
error pages.
error.responseFormat Specifies in what format
error responses should be
rendered. Possible values:
HTTP, JSON, AUTO. Defaults to
AUTO.
feature.openservicebroker.excludeTo disable the Open Service
Broker services available for
the pool.
feature.sdw Enable Database Actions
feature.
http.cookie.filter A comma separated list of
HTTP Cookies to exclude when
initializing an Oracle Web
Agent environment.
icap.port Specifies the Internet
Content Adaptation Protocol
(ICAP) port to virus scan
files. Either icap.port or
icap.secure.port are required
to have a value when
icap.server is set.
icap.secure.port Specifies the Internet
Content Adaptation Protocol
(ICAP) secure port to virus
scan files. Either icap.port
or icap.secure.port are
required to have a value when
icap.server is set.
icap.server Specifies the Internet
Content Adaptation Protocol
(ICAP) server name or IP
address to virus scan files.
jdbc.DriverType The Oracle JDBC URL subtype
that can have one of the
values: thin, oci8. Defaults
to thin.
jdbc.InactivityTimeout Specify how long an available
connection can remain idle
before it is closed. The
inactivity connection timeout
is in seconds. Defaults to
1800.
jdbc.InitialLimit The initial size for the
number of connections that
will be created. Defaults to
10.
jdbc.MaxConnectionReuseCount Specify the maximum number of
times to reuse a connection
before it is discarded and
replaced with a new
connection.
jdbc.MaxLimit The maximum number of
connections. Defaults to 10.
jdbc.MaxStatementsLimit The maximum number of
statements to cache for each
connection. Defaults to 10.
jdbc.MinLimit The minimum number of
connections. Defaults to 2.
jdbc.auth.admin.role Identifies the database role
that signifies the database
user should get the SQL
Administrator role.
jdbc.auth.enabled Specifies if the PL/SQL
Gateway calls can be
authenticated using database
users. Defaults to false. Set
to true to enable feature.
Oracle recommends not to use
this feature. This feature
used only to facilitate
customers migrating from
mod_plsql.
jdbc.cleanup.mode Specifies how a pooled JDBC
connection, and corresponding
database session, is released
when a request has been
processed.
jdbc.driverName The name of the JDBC driver
to use.
jdbc.statementTimeout Specify how long a borrowed
(in use) connection can
remain unused before it is
considered as abandoned and
reclaimed. The abandoned
connection timeout is in
seconds.
json.sdo.geometry.output.geojson Specify that SDO Geometry
data should be returned in
GeoJSON format.
misc.defaultPage Default page (PL/SQL
procedure) to invoke if the
URL points to the context
root of a database pool.
Default value is apex.
misc.pagination.maxRows Specifies the maximum number
of rows that will be returned
from a query when processing
a RESTful service and that
will be returned from a
nested cursor in a result
set. Affects all RESTful
services generated through a
SQL query, regardless of
whether the resource is
paginated. Defaults to 10000.
owa.trace.sql Boolean property that if true
causes a trace of the SQL
statements performed by
Oracle Web Agent to be echoed
to the log.
plsql.gateway.mode Indicates if the PL/SQL
Gateway functionality should
be available for a pool or
not. Value can be one of:
disabled, direct or proxied.
If direct is used, the pool
will serve PL/SQL Gateway
requests directly. If proxied
is used, PLSQL_GATEWAY_CONFIG
view is used to determine the
user to proxy to.
procedure.rest.preHook Name of a stored PL/SQL
function that should be
invoked prior to dispatching
any REST request.
request.traceHeaderName Denotes the name of the HTTP
request header that uniquely
identifies the request end to
end as it passes through the
various layers of the
application stack. In Oracle
this header is commonly
referred to as the ECID
(Entity Context ID).
resource.templates.enabled Deprecated. Configuration
property indicating if the
legacy resource templates
(APEX based REST) should be
enabled or not. False by
default. The
resource-templates code base
is not compatible with the
single pool
(ORDS_PUBLIC_USER)
architecture so must be
disabled.
restEnabledSql.active Enable REST-Enabled SQL
feature.
security.credentials.attempts The maximum number of
unsuccessful password
attempts allowed. Enabled by
setting a positive integer
value. Defaults to -1.
security.credentials.file The file where credentials
are stored.
security.credentials.lock.time The period to lock account
that has exceeded maximum
attempts. Defaults to 10
minutes.
security.requestValidationFunctionSpecifies a validation
function to determine if the
requested procedure in the
URL should be allowed or
disallowed for processing.
The function should return
true if the procedure is
allowed; otherwise, return
false.
security.validationFunctionType Indicate what type the
security.requestValidationFunc
ion is: javascript or plsql.
Defaults to plsql.
security.verifySSL Indicate whether HTTPS is
available in your environment.
standalone.access.log Path to the folder to store
HTTP request access logs. If
not specified then no access
log will be generated.
standalone.binds Comma separated list of host
names or IP addresses to
identify a specific network
interface on which to listen,
default 0.0.0.0.
standalone.context.path The context path where {0} is
located, defaults to /ords
standalone.doc.root Points to the location where
static resources, to be
served under the / root
server path are located.
standalone.http.port HTTP listen port, default 8080
standalone.https.cert SSL certificate path. If you
are providing the SSL
certificate, you must specify
the certificate location.
standalone.https.cert.key SSL certificate key path. If
you are providing the SSL
certificate, you must specify
the certificate key location.
standalone.https.host SSL certificate hostname
standalone.https.port HTTPS listen port, default
8443
standalone.static.context.path The Context path where
Application Express static
resources are located,
defaults to /i
standalone.static.path Path to the folder containing
static resources required by
APEX
standalone.stop.timeout The period for Standalone
Mode to wait to gracefully
shutdown.
$Please to add comments
No comments yet. Be the first to comment!