Getting Error ORA-44001: Invalid Schema While Enabling ORDS Schema (Doc ID 2882196.1)

Last updated on MAY 03, 2024

Applies to:

Symptoms

On : 20.2 version, All Issues

Getting error ORA-44001: invalid schema while enabling ORDS schema

When I tried to Enable ORDS schema through SQL developer, I am getting error as follows:

The query which I am trying to Run while getting above error :
DECLARE
  PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN

  ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
  p_schema => '<Schema Name>',
  p_url_mapping_type => 'BASE_PATH',
  p_url_mapping_pattern => '<Schema alias name>',
  p_auto_rest_auth => TRUE);

  commit;

END;


 

ERROR
-----------------------
Failed to process SQL command
- ORA-44001: invalid schema
ORA-06512: at "ORDS_METADATA.ORDS", line 183
ORA-06512: at "SYS.DBMS_ASSERT", line 410
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 424
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 436
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 436
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 800
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 690
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 829
ORA-06512: at "ORDS_METADATA.ORDS", line 167
ORA-06512: at line 5

Cause

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