Skip to Main Content
Forums

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 Configuration for 12c Oracle RAC environment

kamreddyNov 2 2017 — edited Nov 27 2017

Hi,

Hope this might be answered with ease based of the experiences the members have gone through. I am relatively a new ORDS user, trying to implement ORDS with in our dev env to make oracle database more of API interface for different apps . I ran into any issue during the config and installation of ORDS.  I did try to do the same using Sql Devleoper and command line interface.  I have attached the log of command line interface, check and let me know if you have noticed something i have missed.

C:\Users\userId\Downloads\ords.3.0.12.263.15.32>java -jar ords.war

This Oracle REST Data Services instance has not yet been configured.

Please complete the following prompts

Enter the location to store configuration data:C:\Users\reddyk\ORDS

Enter the name of the database server [localhost]:scan-domain.com

Enter the database listen port [1521]:1521

Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1

Enter the database service name:DEMORT

Enter the database password for ORDS_PUBLIC_USER:

Confirm password:

Please login with SYSDBA privileges to verify Oracle REST Data Services schema.

Enter the username with SYSDBA privileges to verify the installation [SYS]:SYS

Enter the database password for SYS:

Confirm password:

ORA-24964: ALTER SESSION SET CONTAINER error

Comments

I don't think this is a RAC specific error

ORA-24964: ALTER SESSION SET CONTAINER error

Cause: An attempt to switch to a PDB with different settings such as character set, time zone or time zone file version on an Oracle 12c Release 1 (12.1) or earlier client failed.

Action: Upgrade client to Oracle 12 Release 2 (or later) to support such operations.

ORDS v17.3 (BETA!!!) has the 12.2. driver in it, so you could try with that.

kamreddy

thank you. Will try that "thatjeff". trying ords based of your video and blog. Will update of my process once I try it.

kamreddy

Update: Was able to install ORDS v17.3 on Oracle 12.2 Database version  successfully.

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 25 2017
Added on Nov 2 2017
3 comments
510 views