araczkowski / docker-oracle-apex-ords

Oracle Express Edition 11g Release 2 on Ubuntu 14.04.1 LTS with APEX 5.1.1 and ORDS 3.0.9 on Tomcat

docker-oracle-apex-ords

Oracle Express Edition 11g Release 2 on Ubuntu 14.04.1 LTS with APEX 5.1.1 and ORDS 3.0.9 on Tomcat

Option 1. Own docker image, with custom password

Get the image code from github:

git clone --depth=1 https://github.com/araczkowski/docker-oracle-apex-ords.git <own-image-name>
cd <own-image-name>

Building your own image, with custom password:

docker build -t <own-image-name> --build-arg PASSWORD=<custom-password> .

Run the container based on your own image with 8080, 1521, 22 ports opened:

docker run -d --name <own-container-name> -p 49160:22 -p 8080:8080 -p 1521:1521 <own-image-name>

Option 2. Get the prebuilt image from docker hub

Installation:

docker pull araczkowski/oracle-apex-ords

Run the container based on prebuilt image from docker with 8080, 1521, 22 ports opened:

docker run -d --name <own-container-name> -p 49160:22 -p 8080:8080 -p 1521:1521 araczkowski/oracle-apex-ords    

Password for SYS & SYSTEM & Tomcat ADMIN & APEX ADMIN:

    secret

Connect to server in container (Option 1. / Option 2.)

Connect via ssh to server with following setting:

ssh root@localhost -p 49160
password: <custom-password> / secret

Connect database with following setting:

hostname: localhost
port: 1521
sid: xe
username: system
password: <custom-password> / secret

Connect to Tomcat Manager with following settings:

http://localhost:8080/manager
user: ADMIN
password: <custom-password> / secret

Connect to Oracle Application Express web management console via ORDS with following settings:

http://localhost:8080/ords/apex
workspace: INTERNAL
user: ADMIN
password: <custom-password> / secret

docker-oracle-apex-ords's Issues

ORDS 404 Error

Have this error two times now after a specific time when the docker was running for about 7 days.
On http://IP:49161/ords/ it shows a 404 Error.

URLMappingNotFoundException [statusCode=404, reasons=[The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured]] at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:119) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:83) at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:94) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44) at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47) at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64) at oracle.dbtools.http.filters.Filters.filter(Filters.java:47) at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:82) at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:49) at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:116) at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:81) at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:534) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658) at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)

Serious performance issue - asynch descriptor resize

Hi,

When running long queries I'm getting "asynch descriptor resize" wait events (found out via SQL Developer - Monitor sessions).
Queries that completed in 5 seconds in "bare" Virtual machines now are taking more than 90 seconds with your docker (I tested on Digital Ocean all configurations) on top of those VM.

After some digging I used this configuration in the host machine, but to no avail.

Do you have any ideas?

Regards,

Luís

Apex_PU not properly configured

Hi,

If you look at /tomcat/logs/catalina.* you will see:
SEVERE [localhost-startStop-1] . The username or password for the connection pool named apex_pu, are invalid, expired, or the account is locked

This problem may be related to the fact that static workspace files (in an Apex application) can't be found by Tomcat and/or Ords (404 not found).

Best regards,

Luís Silva

Ords 3.0.9 doesn't accept NGINX reverse proxy

Hi Andrzej,

After some testing I found out that I can't use a NGINX reverse proxy in front of your docker image (strange error regarding CORS after the login page).

I know (because I tested on a different docker image) that ORDS 3.0.2 works just fine behind NGINX. Is it possible that you downgrade you image?

Best regards,

Luís

DB-APEX version mismatch

Please be carefull:
https://docs.oracle.com/database/apex-5.1/HTMIG/Oracle-AE-installation-requirements.htm#HTMIG377

"Oracle Application Express release 5.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE)."

Therefore one should not try to go to APEX 5.1 with 11.2.0.2 XE because there is no 11.2.0.4 XE anywhere.

So, document requires 11.2.0.4 which does not exist for XE. Though personally I note no issues using APEX 5.1 with 11.2.0.2 XE in your image

Upgrade to APEX 18

Need to Upgrade to APEX 18, how do I log in as tomcat user?

“There is a problem with your environment because the Application Express files are not up-to-date! The files for version 5.1.4.00.08 have been loaded, but 18.1.0.00.45 is expected. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide.”

Connection refused

After Successfully installing and starting this image I got this error

ssh root@localhost -p 49160
ssh: connect to host localhost port 49160: Connection refused
docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
d74ba2f4933b araczkowski/oracle-apex-ords "/entrypoint.sh" 52 minutes ago Up 52 minutes 0.0.0.0:1521->1521/tcp, 0.0.0.0:8080->8080/tcp, 0.0.0.0:49160->22/tcp oracleapex

Regards,

Page Designer is extremely slow

When I'm in the Page Designer view of any application, the Save button action takes to much to accomplish. Even if the change was minimum it takes 15 -20 seconds to process the Save action.

I already tried to improve tomcat and the database with no luck and at this time I'm not sure if the problem is related to the docker container or any specific configuration on the Application Express installation.

Binding data to host

How can i bind oracle,apex and tomcat or any other important data from this container to host !?