Forum Stats

  • 3,851,413 Users
  • 2,263,973 Discussions
  • 7,904,701 Comments

Discussions

Problem with error messages using ORDS 22.1 and multiple databases

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