configure Apex Listener 2.0.10 (ORDS) for using TNS failed with error 503

Hi Robert Ferro,

Robert Ferro wrote:

 

Hello I configure ORDS 2.0.10 using "java -jar ords.war setup", it works without problem.

Now I need to use a TNS Alias instead of the basic connexion, therefore I configure

"db.connectionType"

"db.tnsDirectory"

"db.tnsAliasName"

using Oracle Support  Doc 1646276.1

     Is the server machine on which ORDS is installed and on which Oracle DB is installed same/different?

     If same, then check the tnsDirectory location and tnsAliasName. Also try testing tns connection to your Oracle DB.

     If different, better use the "db.connectionType" = "customurl" and specify appropriate "db.customURL".

     Check the documentation for the parameters : https://docs.oracle.com/cd/E37099_01/doc.20/e25066/config_file.htm#AELIG7204

Now I got the error page 503 "Service Unavailable"

with the debug message

oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not correctly configured, error: IO Error: could not resolve the connect identifier

could someone help me to configure this correctely

     No doubt that the error is due to : ORDS is not able to connect to Oracle DB specified with specifed connection parameters (while configuring ORDS), but here are some tips for "503 - Service Unavailable".

     Refer : 503-service unavailable error after deploying apex listener on glassfish

Regards,

Kiran