2 Replies Latest reply on Oct 20, 2015 12:12 AM by Denny Wong-Oracle

    Problem when installing ORDS on PDB environment (no USERS tablespace on PDB$SEED)

    croHamster

      I'm trying to manually install the Oracle REST Data Services 3.0.1 after installing a fresh new 12g database in PDB mode.

       

      After starting the script with "@ords_manual_install SYSAUX TEMP c:\opt\log\scripts\" i get the following error:

      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

       

      Verifying tablespaces passes on CDB$ROOT, but fail on PDB$SEED with the same parameters because there is no USERS default tablespace in it. The script ords_install_cdb.sql calls the script ords_verify_tablespace.sql, and the parameters are: SYSAUX TEMP USERS TEMP (default values from the installation instructions).

       

      Btw, the default permanent tablespace in PDB$SEED is SYSTEM nad the scripts are not aware of it.

       

      How to solve this problem?

       

      TIA,

      Hrvoje

        • 1. Re: Problem when installing ORDS on PDB environment (no USERS tablespace on PDB$SEED)
          aehrlich

          The ords_create_rest_users.sql has a bug. It runs 'create user ORDS_PUBLIC_USER...' terminated by semicolon (it actually succeeds) but just after this statement goes a slash-line meaning effectively "run again" in this context.

          Just remove the slash after the 'create user ORDS_PUBLIC_USER...' line.

          Oracle is obviously half-way changing "direct" create/drop user statements to the "execute immediate" style ;-/.

          • 2. Re: Problem when installing ORDS on PDB environment (no USERS tablespace on PDB$SEED)
            Denny Wong-Oracle

            alter session set container=PDB$SEED;

            select tablespace_name from sys.dba_tablespaces;

             

            TABLESPACE_NAME             

            ------------------------------

            SYSTEM                       

            SYSAUX                       

            TEMP

             

            By default, there is no USERS tablespace created in the PDB$SEED in db installation.

             

            When I tried to run the manual install script @ords_manual_install.sql, it failed with the following error. As you can see, the USERS tablespace doesn't exist in the PDB$SEED, so the error is correct.  But how to resolve this problem?  Use the SYSAUX in place of the USERS tablespace?  How to create the USERS tablespace in the PDB$SEED?

             

            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