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