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.war file difficulty - OAUTH marshaling failure

Ed HeatonDec 8 2016 — edited Dec 10 2016

Hi,

I originally posted this in the wrongforum.

Whilst trying to configure ORDS for an APEX 5.0.4 installation, I am hitting the following issue when configuring the ords.war file.

My database back end is running on Oracle 12.1.0.2 and the OS is Red Hat 6.7.  The middle tier is running Windows 2008R2 and JAVA 7 with Apache Tomcat 8.5.4.  All I am trying to do is configure the war file but I am getting the following:

java -jar ords.war

..

..

Dec 08, 2016 1:39:18 PM oracle.dbtools.rt.config.setup.SchemaSetup verifyDBAUser

Connection

WARNING: Failed to connect to user SYS AS SYSDBA jdbc:oracle:thin:@xxxx-xxxxxx.

xxxx.xxxxx:1521:MYDB

OAUTH marshaling failure

I do not have this problem if the back end database is running on Windows 2008R2 (same version 12.1.0.2).  The Windows host name does not contain a hyphen (if that makes any difference).

I have tried using the following parameter '-Doracle.jdbc.thinLogonCapability=o3' which gets around the error but then the SYS password does not work.

Can anyone point me in the right direction?

Any advice would be greatly appreciated!

Cheers

Ed

This post has been answered by Ed Heaton on Dec 10 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2017
Added on Dec 8 2016
1 comment
1,089 views