Unable to setup APEX and ORDS in an Application Container PDB on Oracle 19c.
How this is run:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production (Version 19.3.0.0.0)
APEX Flow Version 20.1.0.00.13
Oracle REST Data Services 20.2.1.r2270350
connect / as sysdba
CREATE PLUGGABLE DATABASE apexroot201
AS APPLICATION CONTAINER
admin user appcon_admin identified by "***"
FILE_NAME_CONVERT=('pdbseed','apexroot201');
ALTER PLUGGABLE DATABASE apexroot201 open;
ALTER SESSION SET CONTAINER = apexroot201;
set serveroutput on size unlimited format wrapped
execute DBMS_JAVA.SET_OUTPUT(1000000);
@apxappcon.sql SYSAUX SYSAUX TEMP /apex_20.1_images/ ***
@/opt/pdb_installs/ords-20.2_scripts/install/core/ords_app_con_install.sql ./ SYSAUX TEMP SYSAUX TEMP *** /opt/pdb_installs/ords-20.2_scripts
Error Message "from install/core/ords_app_con_install.sql":
(Modified "install/core/ords_schema_mapping.sql" by adding "DBMS_UTILITY.FORMAT_ERROR_STACK || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE" to exception handler)
Configuring APEX and ORDS schemas for url mapping
Failed to make APEX_PUBLIC_USER proxiable from ORDS_PUBLIC_USER
ORA-65317: cannot modify the user or role created by another application
ORA-06512: at line 44
From "install/core/ords_schema_mapping.sql":
procedure grant_proxy (p_user in varchar2)
is
begin
execute immediate 'alter user ' || p_user || ' grant connect through ORDS_PUBLIC_USER';
dbms_output.put_line('Made ' || p_user || ' proxiable from ORDS_PUBLIC_USER');
exception
when others then
dbms_output.put_line('Failed to make ' || p_user || ' proxiable from ORDS_PUBLIC_USER' ||
DBMS_UTILITY.FORMAT_ERROR_STACK || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
end grant_proxy;
NOTE: Line 44 is: "execute immediate 'alter user ' || p_user || ' grant connect through ORDS_PUBLIC_USER';" from "install/core/ords_schema_mapping.sql"