Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

Unable to install ORDs 19.1 or 23.1 - Table ORDS_METADATA.apex_pool_config does not exist

edited Jul 14, 2023 5:30PM in Oracle Rest Data Services (ORDS) (MOSC) 3 commentsAnswered ✓

Oracle Database -19c - used DBUA to upgrade from 18c

APEX is 23.1 - Upgraded 5.1 on 19c to 23.1 - Verified install is "VALID"

Oracle Linux 7

Unable to install ORDs 19.1 or 23.1 getting the following errors:

SEVERE: Error executing script: ords_schema_mapping.sql Error: ORA-00942: table or view does not exist

ORA-06512: at line 161


 execute immediate 'grant select on ORDS_METADATA.apex_pool_config to ords_publ

ic_user';

end;

Error report -

ORA-00942: table or view does not exist

ORA-06512: at line 161

00942. 00000 - "table or view does not exist"


ACTIONS TAKEN:

  1. I ran java -jar ords.war validate - same errors as listed above
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center