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!

AWS RDS and ORDS 23.1 setup (cannot set pdb.disable.lockdown)

user-w8pleMay 30 2023 — edited May 30 2023

Good afternoon,

I'm trying to get ORDS to work with Oracle 21c running as an AWS RDS (multitennant config) to get the MongoDB driver working.

I have been following the notes specified here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.Options.APEX.html however have noted that my installation is failing with the following error (--verbose):

Caused by: Error : 2097, Position : 0, Sql = ALTER SESSION SET PDB_LOCKDOWN = '', OriginalSql = ALTER SESSION SET PDB_LOCKDOWN = '', Error Msg = ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01031: insufficient privileges

From what I have read, this error can be resolved by specifying the following in ords_params.properties:

pdb.disable.lockdown=false

However it does not appear that the ords_params.properties is being read (or is supported) in ORDS 22+.

Does anyone know how to bypass the PDB lockdown in ORDS in ORDS version 23?

This post has been answered by thatJeffSmith-Oracle on Nov 14 2023

Jump to Answer

Added on May 30 2023

7 comments

2,048 views

1 mention