Installing ORDS "Error invalid ORDS install, user ORDS_PUBLIC_USER common value is NO, user ORDS_METADATA common value is YES"
(Doc ID 2880678.1)
Last updated on JULY 10, 2022
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle REST Data Services - Version 20.4.1 and later
Information in this document applies to any platform.
Multiple Database Systems of 12c were upgraded/migrated to 19c PDB's.
Installing ORDS or setting update new database on the PDB's individully shows below error
Running below SQL and the ORDS_METADATA for COMMON is shown as 'YES", which is invalid for ORDS, it must be "NO" so the schema will be LOCAL.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document