ORA-20001: Can not grant select on APEX (Doc ID 2988449.1)

Last updated on DECEMBER 11, 2023

Applies to:

Symptoms

Unable to install ORDS after dropping old APEX Schema. Dropped old APEX Schema APEX_040200 at CDB&PDB Level, and tried to install new version of APEX_220100.
 

java -jar ords.war install advanced
Using existing ORDS configuration files located at <config folder path>

Verify ORDS schema in Database Configuration apex using connection url jdbc:oracle:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.

Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:
APEX_040200.WWV_FLOW_POOL_CONFIG to ORDS_METADATA with grant option : ORA-00942: table or view does not exist
ORA-06512: at line 370

 Refer to log file ords_install_core_xxxxxxx.log for details

java.io.IOException: Error executing script: ords_schema_mapping.sql Error: ORA-20001: Can not grant select on APEX_040200.WWV_FLOW_POOL_CONFIG to ORDS_METADATA with grant option : ORA-00942: table or view does not exist

Retrieving information.
Enter the default tablespace for ORDS_METADATA [SYSAUX]:SYSAUX
Enter the temporary tablespace for ORDS_METADATA [TEMP]:TEMP
Enter the default tablespace for ORDS_PUBLIC_USER [SYSAUX]:SYSAUX
Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:TEMP
Installing Oracle REST Data Services version 21.4.3.r1170405
... Log file written to ords_install_core_xxxxxxx.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
SEVERE Error executing script: ords_schema_mapping.sql Error: ORA-20001: Can not grant select on APEX_040200.

Error Codes
---------------------------------------------------
SEVERE Error executing script: ords_schema_mapping.sql Error: ORA-20001: Can not grant select on APEX_040200.

Cause

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