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

Last updated on JULY 02, 2024

Applies to:

Symptoms

ORDS installation/upgrade fails with:

404 NOT FOUND

"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

Cause

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