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?