I am using Oracle DB 19.6.0.0.0 on OCDB System
I tried accessing APEX after installing it on my DB System. Using the link http://<VM node public IP>:8080/apex fails.
That was before installing ORDS. So i tried installing it but getting this error:
SEVERE Could not start Standalone Mode because an error occurred: Failed to bind to 0.0.0.0/0.0.0.0:8080
oracle.dbtools.standalone.StandaloneException: Could not start Standalone Mode because an error occurred: Failed to bind to 0.0.0.0/0.0.0.0:8080
at oracle.dbtools.standalone.StandaloneConfiguration.couldNotStartServer(StandaloneConfiguration.java:478)
at oracle.dbtools.standalone.StandaloneConfiguration.start(StandaloneConfiguration.java:309)
at oracle.dbtools.standalone.Standalone.execute(Standalone.java:503)
at oracle.dbtools.cmdline.Commands.execute(Commands.java:208)
at oracle.dbtools.cmdline.Commands.main(Commands.java:190)
at oracle.dbtools.cmdline.Commands.main(Commands.java:370)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at oracle.dbtools.jarcl.Entrypoint.invoke(Entrypoint.java:66)
at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:77)
Caused by: java.io.IOException: Failed to bind to 0.0.0.0/0.0.0.0:8080
at org.eclipse.jetty.server.ServerConnector.openAcceptChannel(ServerConnector.java:346)
at org.eclipse.jetty.server.ServerConnector.open(ServerConnector.java:307)
at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:80)
at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:231)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
at org.eclipse.jetty.server.Server.doStart(Server.java:385)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
at oracle.dbtools.standalone.StandaloneConfiguration.start(StandaloneConfiguration.java:283)
... 10 more
Caused by: java.net.BindException: Address already in use
at sun.nio.ch.Net.bind0(Native Method)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)
at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)
at org.eclipse.jetty.server.ServerConnector.openAcceptChannel(ServerConnector.java:342)
... 17 more
Installation steps:
1) sqlplus sys/****@PDB1 as sysdba @apexins sysaux sysaux temp /i/
2)@apxchpwd.sql
3) alter user apex_public_user identified by ****** account unlock;
4) @apex_rest_config.sql
5) @apex_epg_config.sql /home/oracle/apex
6) EXEC DBMS_XDB.SETHTTPPORT(8080);
At this point accessing APEX using http://<ip>:8080/apex fails. So I thought to continue with ORDS
7) vim ords_params.properties
b.hostname=localhost
db.port=1521
# CUSTOMIZE db.servicename
db.servicename=PDB1
db.username=APEX_PUBLIC_USER
db.password= *********
migrate.apex.rest=false
plsql.gateway.add=true
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=SYSAUX
schema.tablespace.temp=TEMP
standalone.mode=TRUE
standalone.http.port=8080
standalone.use.https=false
# CUSTOMIZE standalone.static.images to point to the directory
# containing the images directory of your APEX distribution
standalone.static.images=/home/oracle/apex/ords/images
user.apex.listener.password= *********
user.apex.restpublic.password= *********
user.public.password= *********
user.tablespace.default=SYSAUX
user.tablespace.temp=TEMP
8)
$ java -jar ords.war standalone --apex-images images/
Enter the location to store configuration data: /home/oracle/apex/ords/
Enter 1 if using HTTP or 2 if using HTTPS [1]:1
Enter the HTTP port [8080]:
2020-05-19 22:45:18.593:INFO::main: Logging initialized @210821ms to org.eclipse.jetty.util.log.StdErrLog
2020-05-19 22:45:18.686:INFO:oeju.TypeUtil:main: JVM Runtime does not support Modules
2020-05-19T22:45:18.808Z INFO HTTP and HTTP/2 cleartext listening on host: localhost port: 8080
2020-05-19T22:45:18.879Z INFO Disabling document root because the specified folder does not exist: /home/oracle/apex/ords/ords/standalone/doc_root
2020-05-19 22:45:20.035:INFO:oejs.Server:main: jetty-9.4.24.v20191120; built: 2019-11-22T11:09:44.612Z; git: 8b8c80157294e38f81ef8ea2358a0c49bf5db918; jvm 1.8.0_231-b11
2020-05-19 22:45:20.840:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2020-05-19 22:45:20.842:INFO:oejs.session:main: No SessionScavenger set, using defaults
2020-05-19 22:45:20.845:INFO:oejs.session:main: node0 Scavenging every 660000ms
2020-05-19T22:45:22.469Z INFO No pools configured yet
2020-05-19T22:45:22.880Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 19.4.0.r3521226
Oracle REST Data Services server info: jetty/9.4.24.v20191120
2020-05-19 22:45:24.204:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@6ed3ccb2{/ords,null,AVAILABLE}
2020-05-19 22:45:24.206:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@7bedc48a{/i,null,AVAILABLE}
2020-05-19T22:45:24.240Z SEVERE Could not start Standalone Mode because an error occurred: Failed to bind to 0.0.0.0/0.0.0.0:8080
oracle.dbtools.standalone.StandaloneException: Could not start Standalone Mode because an error occurred: Failed to bind to 0.0.0.0/0.0.0.0:8080
at oracle.dbtools.standalone.StandaloneConfiguration.couldNotStartServer(StandaloneConfiguration.java:478)
at oracle.dbtools.standalone.StandaloneConfiguration.start(StandaloneConfiguration.java:309)
at oracle.dbtools.standalone.Standalone.execute(Standalone.java:503)
at oracle.dbtools.cmdline.Commands.execute(Commands.java:208)
at oracle.dbtools.cmdline.Commands.main(Commands.java:190)
at oracle.dbtools.cmdline.Commands.main(Commands.java:370)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at oracle.dbtools.jarcl.Entrypoint.invoke(Entrypoint.java:66)
at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:89)
Caused by: java.io.IOException: Failed to bind to 0.0.0.0/0.0.0.0:8080
at org.eclipse.jetty.server.ServerConnector.openAcceptChannel(ServerConnector.java:346)
at org.eclipse.jetty.server.ServerConnector.open(ServerConnector.java:307)
at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:80)
at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:231)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
at org.eclipse.jetty.server.Server.doStart(Server.java:385)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
at oracle.dbtools.standalone.StandaloneConfiguration.start(StandaloneConfiguration.java:283)
... 10 more
Caused by: java.net.BindException: Address already in use
at sun.nio.ch.Net.bind0(Native Method)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)
at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)
at org.eclipse.jetty.server.ServerConnector.openAcceptChannel(ServerConnector.java:342)
... 17 more
Shouldn't APEX be running by now, I mean even if ORDS is not installed yet?
And What does "java.io.IOException: Failed to bind to 0.0.0.0/0.0.0.0:8080" mean? looks like a network issue.
Thank you,
Gado