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