This is what we have in PROD running HTTP: and its been running fine. The developers want to add security. I dont have a test system so I created a test system with the exact same versions and want to implement security there without causing users impact.
We have a signed CA certificate and when I use it either the ORDS standalone starts and the URL points to LOCALHOST or I get this error:
Enter 1 if using HTTP or 2 if using HTTPS [1]:Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at oracle.dbtools.jarcl.Entrypoint.invoke(Entrypoint.java:66)
at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:77)
Caused by: java.io.IOError: java.io.EOFException
at oracle.dbtools.common.util.Console$1.readLine(Console.java:97)
at oracle.dbtools.standalone.Prompt.prompt(Prompt.java:37)
at oracle.dbtools.standalone.Standalone.legacyStart(Standalone.java:598)
at oracle.dbtools.standalone.Standalone.execute(Standalone.java:139)
at oracle.dbtools.cmdline.Commands.execute(Commands.java:226)
at oracle.dbtools.cmdline.Commands.main(Commands.java:209)
at oracle.dbtools.cmdline.Commands.main(Commands.java:411)
... 6 more
Caused by: java.io.EOFException
at oracle.dbtools.common.util.Console$1.readLine(Console.java:130)
at oracle.dbtools.common.util.Console$1.readLine(Console.java:95)
... 12 more
I have tried all kinds of methods from various documents from Oracle but I cannot find a way to troubleshoot. I have an open SR with Oracle but this is not going anywhere too fast.
My thinking is that when I get security working in TEST, I implement in PROD then upgrade TEST to all the latest versions but PROD is very stable now just unsecure.
Please give me some ideas to troubleshoot this issue. Thanks very much.
This is what is in standalone.properties
#wed Aug 13 16:33:18 CDT 2025
database.api.enabled=true
db.connectionType=tns
db.password=@xxxxxxxxC
db.tnsAliasName=test
db.tnsDirectory=/usr/lpp/oracle/product/19c/network/admin
db.username=APEX_PUBLIC_USER
feature.sdw=true
plsql.gateway.add=true
rest.services.apex.add=true
rest.services.ords.add=false
restEnabledSql.active=true
standalone.ssl.host=axv-xxxxxx.xxx.org
standalone.use.https=true
standalone.use.ssl.cert=true
standalone.jetty.secure.port=8443
standalone.ssl.cert=/usr/lpp/oracle/product/19c/ords/config/ords/standalone/example.cer
standalone.ssl.cert.key=/usr/lpp/oracle/product/19c/ords/config/ords/standalone/example.key
standalone.context.path=/ords
standalone.doc.root=/usr/lpp/oracle/product/19c/ords/config/ords/standalone/doc_root
standalone.scheme.do.not.prompt=true
standalone.static.context.path=/i
standalone.static.path=/usr/lpp/oracle/product/19c/apex22/apex/images
user.apex.listener.password=@xxxxxxxxxxxC
user.apex.restpublic.password=@xxxxxxxxx