Getting ORA-20013 When Calling Ords.enable_schema (Doc ID 2785918.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Symptoms

 In one Database, we try to call ords.enable_schema(...) on the ORDS_PUBLIC_USER schema as below and we get an error :

BEGIN
ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
p_schema => 'ORDS_PUBLIC_USER',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'ORDS_PUBLIC',
p_auto_rest_auth => FALSE);
COMMIT;
END;
/

ORA-20013: Shcema or user is blacklisted: ORDS_PUBLIC_USER

Cause

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