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 maintence mode

jan dvorakSep 4 2024

kind of fighting how to properly set ords to something like maintence mode, without interupting current requests processing.

locking ords_public_user schema responsible for creating connection pool is not working, if the pool is already acquired by ords. locking it will only prevent the connection pool from being acquired if ords needs to create the pool again.

updating ORDS_METADATA.ORDS_SCHEMAS status column to DISABLED have also no impact.

what i want to achieve is, lock access to endpoints resources, but let the actuall processed requests to complete.

i will implement this function with predefined reverse proxy, but for now, i am looking for something easier. is there any way?

Comments
Post Details
Added on Sep 4 2024
3 comments
155 views