Skip to Main Content

ORDS with TNS - error when trying to connect DB for APEX

alacourbOct 28 2021

Oracle with APEX 21.1
ORDS 21.3 on Tomcat 9.0.54 - Windows Server 2019
I'm getting following error when starting Tomcat which prevents ORDS from connecting to the DB: Extended settings parsing failed. java.lang.RuntimeException: Invalid character at 24 : \
oracle.dbtools.common.logging.JDKLogSink.record IO Error: Invalid connection string format, a valid format is: "host:port:sid" (CONNECTION_ID=X8ADepYuRpK1p8FSAKp41Q==),|apex||-2021-10-26T20-46-37.212127400Z,jdbc:oracle:thin:@myDB?TNS_ADMIN=D:\App\Oracle\tns
oracle.dbtools.common.logging.JDKLogSink.record The pool named: |apex|| 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|| had the following error(s): IO Error: Invalid connection string format, a valid format is: "host:port:sid" (CONNECTION_ID=X8ADepYuRpK1p8FSAKp41Q==)
When I'm using Basic connection instead of TNS it works perfectly. The TNS file format is fine since it works with ORDS 21.1.
I have also tried ORDS 21.2: same issue as with 21.3.
ORDS seems to have an issue with tns connection starting from version 21.2.
Any idea?

This post has been answered by Gerardo Gomez-Oracle on Jan 12 2022
Jump to Answer
Post Details
Added on Oct 28 2021