Unable to install ORDs 19.1 or 23.1 - Table ORDS_METADATA.apex_pool_config does not exist
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:
- I ran java -jar ords.war validate - same errors as listed above
