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 18.3 and multiple connections

Yvan PoulinOct 12 2018 — edited Oct 15 2018

Dear all,

I couldn't find any similar issues on internet, therefore I ask my question to you.

I am using ORDS to replace mod_PLSQL connections with DAD files and I am facing a problem after having upgraded ORDS from 18.1.1 to 18.3..

When I installed ORDS 18.1.1, I was able to create multiple connections with different URL mapping. This was creating multiple xml files on the ords/conf/ folder (schemaname-xml, schemaname_rt.xml etc...)

I tried following the upgrade documentation, and the update failed. Then I manually copied the 18.1.1 files into the new 18.3 folder and restart the installation specifying the files location, and it worked. I was able to access APEX and all my previously defined accesses. BUT, when I tried to add a new schema, the new files were not created, the URL mapping was added but it was impossible to connect to the website.

403 when triying to connect to http://servername.xxxx.xx:8080/ords/finapps.intranet.home (where finapps is the name of one schema)

  • Access to the procedure named: finapps.intranet.home is denied.

500  when trying with http://servername.xxxxx.xx:8080/ords/finapps/intranet.home

  • An unexpected error with the following message occurred: null

Needless to say that on the DB server the grants execute on package to APEX_PUBLIC_USER and the ORDS-enable were already done longtime ago.

After several desperate tentatives to fix the issue, I decided to install ORDS from scratch.   I have a worse result. APEX works, all other  connections fail and I cant find where are stored the configuration files of multiple connections.

So my questions are :

  • Is it still possible to create multiple connections with 18.3 ?
  • How ?
  • where are the configuration files ?

Thanks for your help

Comments

Post Details

Added on Oct 12 2018
8 comments
3,824 views