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 23.2 additional pool: HTTP Status Code: 404

InoLAug 18 2023

I'm running ORDS23.2 in standalone mode.

Maybe I misunderstood this part in the Installation Guide:

By default, additional databases are mapped using the database pool name specified while installing ORDS.

So, I have created a default pool and a second one called mslt5. Both are VALID after starting ORDS:

Mapped local pools from /etc/ords/config/databases:
 /ords/                              => default                        => VALID
 /ords/mslt5/                        => mslt5                          => VALID

The default link to APEX works:

https://xy.z.com:8443/ords/f?p=4550

However, I cannot connect to APEX in the other database

https://xy.z.com:8443/ords/mslt5/f?p=4550

The result is:

HTTP Status Code: 404

I'm sure that APEX and ORDS are properly installed and working, because connection pool now named mslt5 used to be the default connection. That was working.

Is there a step I missed? My understanding of “By default …” is that the URL should now be "…/ords/mslt5/

Comments
Post Details
Added on Aug 18 2023
15 comments
1,515 views