Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Ords.war install error

user8880818May 18 2021 — edited May 19 2021

at the end of the ords.war install, when selecting 1, error saying doc_root not found and pool account locked?

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
2021-05-19T20:20:56.683Z INFO Disabling document root because the specified folder does not exist: /home/oracle/ords/config/ords/standalone/doc_root
2021-05-19T20:20:58.049Z WARNING The pool named: |apex|| is invalid and will be ignored: ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|| had the following error(s): ORA-28000: the account is locked
2021-05-19T20:20:58.140Z INFO Configuration properties for: |apex|pu|
cache.caching=false
cache.directory=/tmp/apex/cache
cache.duration=days
cache.expiration=7
cache.maxEntries=500
cache.monitorInterval=60
cache.procedureNameList=
cache.type=lru
database.api.enabled=true
db.connectionType=basic
db.hostname=<<DBHOSTNAME>>
db.port=1521
db.servicename=<<DBSERVICENAME>>
debug.debugger=false
debug.printDebugToScreen=false
error.keepErrorMessages=true
error.maxEntries=50
jdbc.DriverType=thin
jdbc.InactivityTimeout=1800
jdbc.InitialLimit=3
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=10
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=apex
restEnabledSql.active=true
security.disableDefaultExclusionList=false
security.maxEntries=2000
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
db.password=******
db.username=ORDS_PUBLIC_USER
resource.templates.enabled=true

2021-05-19T20:20:58.141Z WARNING *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***
2021-05-19T20:20:58.141Z WARNING *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***
2021-05-19T20:21:03.140Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 21.1.1.r1162032
Oracle REST Data Services server info: jetty/9.4.40.v20210413

Comments

Post Details

Added on May 18 2021
3 comments
1,626 views