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!

Error executing ords_runtime_user.sql ORA-01031 insufficient privileges trying to connect Customer Managed ORDS to 23ai ADB

Ollie HJul 25 2024 — edited Jul 26 2024

Hi, I'm following these instructions https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/24.2/ordig/installing-and-configuring-customer-managed-ords-autonomous-database.html and receiving the following output. Any guidance would be greatly appreciated. Using ORDS 24.2 on an OCI Linux VM.

2024-07-25T11:26:48.119Z INFO Connecting to Autonomous database user: ADMIN TNS Service: TEST23AI_MEDIUM
2024-07-25T11:27:00.907Z SEVERE Error occurred configuring database users for Autonomous Database.
2024-07-25T11:27:00.914Z SEVERE Error executing script: ords_runtime_user.sql Error: ORA-01031: insufficient privileges
ORA-06512: at "ORDS_METADATA.ORDS_ADMIN", line 1148
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 512
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 602
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 602
ORA-06512: at "ORDS_METADATA.ORDS_ADMIN", line 1137
ORA-06512: at line 43
ORA-06512: at line 86

Comments
Post Details
Added on Jul 25 2024
3 comments
337 views