ORDS listener configuration issue

Hi All,

I am having issue installing ORDS ( latest version).

When running the install script, I get the errors below:

SQL> @ords_manual_install SYSAUX TEMP /u03/ords_config/scripts
******************************************************
* Oracle REST Data Services (ORDS) Installation.
******************************************************
@ Enter a password for the ORDS_PUBLIC_USER:
Enter an existing data tablespace for ORDS_PUBLIC_USER [USERS]:
Enter an existing temporary tablespace for ORDS_PUBLIC_USER [TEMP]:

INFO: Checking prerequisites for Oracle REST Data Services

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

INFO: Prerequisites verified.


PL/SQL procedure successfully completed.






Verifying tablespaces for CDB$ROOT
Completed verifying the tablespaces SYSAUX and TEMP for SYS
Completed verifying the tablespaces USERS and TEMP for SYS

PL/SQL procedure successfully completed.

Completed verifying PDB(s) default tablespace SYSAUX and temporary tablespace
TEMP for CDB$ROOT
Completed verifying PDB(s) default tablespace USERS and temporary tablespace
TEMP for CDB$ROOT

PL/SQL procedure successfully completed.


Verifying tablespaces for PDB$SEED


Session altered.

Completed verifying the tablespaces SYSAUX and TEMP for SYS
declare
*
ERROR at line 1:
ORA-20005: ERROR: The default tablespace USERS does not exist. An existing
tablespace is required for ORDS installation.
ORA-06512: at line 10
ORA-06512: at line 28

PDB Seed does not have the USERS tbs installed, so yes the error is expected.

Is there a work around to this?

  I also filed BUG: Bug 22192115 

************

I was also informed I had to run "CATCONS.SQL" , which is confusing. I do not understand why the ORDS script would look for a USERS tablespace in the PDB$SEED ?

and how does runnign CATCONS.sql resolve this issue?