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 20.3 catalina.log SEVERE

PaavoNov 8 2020

In catalina log files there is one row with SEVERE and I would like to understand why it comes and how to fix it.

07-Nov-2020 19:33:32.325 SEVERE [main] oracle.dbtools.common.logging.JDKLogSink.record Could not process url-mapping.xml mapping: mypdbx because pool: |mypdbx|| is not valid

And the old confs had the following mappings

[tomcat@93767315a501 conf]$ pwd
/u01/mypdbx/203/conf
[tomcat@93767315a501 conf]$ ls -aR
.:
. .. mypdbx

./mypdbx:
. .. conf defaults.xml url-mapping.xml

./mypdbx/conf:
. .. apex.xml apex_al.xml apex_pu.xml apex_rt.xml
[tomcat@93767315a501 conf]$ cat mypdbx/url-mapping.xml 
<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
 <pool name="mypdbx" base-path="mypdbx" updated="2020-02-11T18:54:55.020Z"/>
</pool-config>
[tomcat@93767315a501 conf]$ 

Upgrade from 19.4 was surprisingly easy, very fast and according to documentation. For the PDB "only" with non-sysdba user installation.

select ords.installed_version from dual
19.4.0.r3521226 -- prior upgrade
20.3.0.r3011819 -- required also [tomcat@9114086a44b8 203]$ java -jar mypdbx.war validate --parameterFile /u01/mypdbx/203/params/ords_params.properties --silent

rgrs Paavo

This post has been answered by jariola on Nov 9 2020
Jump to Answer
Comments
Post Details
Added on Nov 8 2020
7 comments
1,237 views