0 Replies Latest reply on Nov 17, 2015 6:14 AM by Jcgo-Oracle

    ORDS listener configuration issue

    Jcgo-Oracle

      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?