My Oracle Support Banner

404 NOT FOUND - SYS shows NO for COMMON in dba_users in a non-cdb environment (Doc ID 2957040.1)

Last updated on JUNE 30, 2023

Applies to:

Oracle REST Data Services - Version 23.1 and later
Information in this document applies to any platform.


ORDS installation/upgrade fails with:


"The procedure named apex could not be accessed, it may not be declared, or the user executing this request may not have been granted execute privilege on the procedure, or a function specified by security.requestValidationFunction configuration property has prevented access. Check the spelling of the procedure, check that the execute privilege has been granted to the caller and check the configured security.requestValidationFunction function. If using the PL/SQL Gateway Procedure Allow List, check that the procedure has been allowed via ords_admin.add_plsql_gateway_procedure. "


> When running: select * from ords_metadata.plsql_gateway_allow_list , it comes up as empty

> Running a repair command successfully does not populate the list

> When running: select username, common from all_users
WHERE username in('SYS', 'ORDS_METADATA', 'ORDS_PUBLIC_USER', 'APEX_PUBLIC_USER') , user SYS shows NO for COMMON in dba_users


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.