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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with error messages using ORDS 22.1 and multiple databases

user1292445Sep 20 2022

Hello!
I am writing, because I found no solution for my problem:
I installed ORDS 22.1 and Apex and connected it to the first database at the first host. This worked very well, I could send requests and get back responses with JSON fragments. No error messages appeared.
So now, after some weeks, my collegue also wishes to use REST, so I decided to install the system into a second database on a second host using the system
https://myhost.de/ords/db1 and https://myhost.de/ords/db2
Jetty is running as a service on a linux system using open-java jdk 11

After changing my pool.xml to
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Mon Sep 19 07:07:52 UTC 2022</comment>
<entry key="db.connectionType">basic</entry>
<entry key="db.hostname">myhost.mydomain.de</entry>
<entry key="db.port">myportNumber</entry>
<entry key="db.servicename">myservice.mydomain.de</entry>
<!-- <entry key="db.serviceNameSuffix">.mydomain.de</entry> -->
<entry key="db.username">ORDS_PUBLIC_USER</entry>
<entry key="db.credentialsSource">request</entry>
<entry key="feature.sdw">false</entry>
<entry key="jdbc.DriverType">thin</entry>
<entry key="jdbc.InitialLimit">5</entry>
<entry key="jdbc.MaxLimit">15</entry>
<!-- proxied, direct, disabled -->
<entry key="plsql.gateway.mode">disabled</entry>
<entry key="restEnabledSql.active">true</entry>
<entry key="security.requestValidationFunction"></entry>
</properties>

The requests ends in JSON-response for both databases, so all seems ok but there ist always two errors for each request into the logfile:

2022-09-19T11:59:22.873Z SEVERE Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=Mhxj0aq7TsupSgrh2MEDXQ==),|myPool|lo|/CONNECTING_ACCOUNT.mydomain.de-2022-09-19T11-59-22.853894Z,jdbc:oracle:thin:@//myhost.mydomain.de:myPortNumber/CONNECTING_ACCOUNT.mydomain.de
2022-09-19T11:59:22.893Z SEVERE Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
(CONNECTION_ID=6SCffQC0RHmwxaK5JTNhpA==),|myPool|lo|/EMP.mydomain.de-2022-09-19T11-59-22.885352Z,jdbc:oracle:thin:@//myhost.mydomain.de:myPortNumber/EMP.mydomain.de

Into the first error: it seems for me that the system tried to connect to the account behind the workspace via jdbc-connection and
the second tried to connect to the databasetable "EMP" via jdbc

How to solve that?
What configurations are missing?

Thanks in advance

Comments

Post Details

Added on Sep 20 2022
0 comments
296 views