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!

ORDS schema database objects contain INVALID status

I have the following error when installing ORDS 25.2 on oracle database 12.1 :

INFO The log file is defaulted to the current working directory located at /etc/ords/logs/
INFO Installing Oracle REST Data Services version 25.2.3.r2241517 in NON_CDB
INFO ... Verified database prerequisites
INFO ... Created Oracle REST Data Services proxy user
INFO ... Created Oracle REST Data Services schema
INFO ... Granted privileges to Oracle REST Data Services
INFO ... Created Oracle REST Data Services database objects
Error executing script: ords_verify_install.sql Error: ORA-20006: ERROR: Validating objects failed. ORA-20006: ERROR: ORDS schema database objects contains INVALID status.
ORA-06512: at "ORDS_METADATA.VALIDATE_ORDS", line 474
ORA-06512: at line 3

using NLS_LENGTH_SEMANTICS=BYTE

Comments
Post Details
Added on Sep 2 2025
2 comments
74 views