My Oracle Support Banner

ORDS Connection Pool Fails to Start with IO Error When Using TNS Connection Type. (Doc ID 2691358.1)

Last updated on JULY 22, 2020

Applies to:

Oracle REST Data Services - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

ORDS fails to start with IO Error if db.connectionType=tns is configured.


ERROR (*)
-------


<timestamp> SEVERE IO Error: Unknown host specified ,|apex|pu|-<timestamp>,jdbc:oracle:thin:@<tnsAliasName>
<timestamp> WARNING The pool named: |apex|pu| is invalid and will be ignored: ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|pu| had the following error(s): IO Error: Unknown host specified


Changes

 Changed DB Connection type to TNS as follows:

<entry key="db.connectionType">tns</entry>
<entry key="db.tnsAliasName"><TNS alias name in tnsnames.ora></entry>
<entry key="db.tnsDirectory"><The directory location of tnsnames.ora file></entry>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.