Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS listener configuration issue

Jcgo-OracleNov 17 2015 — edited Nov 17 2015

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?

Comments

843844
Your method signature is wrong. It should be public String userEvent() which returns null.
But you would be better off using an ActionListener instead, so change the method signature to
public void userEvent(ActionEvent e)
and in the page
<a4j:support event="onchange" actionListener="#{ticketBeanHandler.userEvent}" reRender="likearg" immediate="true" />
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 15 2015
Added on Nov 17 2015
0 comments
761 views