Sign inSign up

araczkowski/xe

By araczkowski

Updated over 10 years ago

araczkowski/xe is a docker based image for easily running Oracle APEX database server.

Image
0

1.0K

araczkowski/xe repository overview

araczkowski/xe is a docker based image for easily running Oracle Database with Oracle APEX Oracle database server.

Usage

Install Docker

Run the container

$ docker run -d --name xe -p 49160:22 -p 49161:1521 -p 49162:8080 araczkowski/xe

login to the APEX

url: http://localhost:49162/apex/f?p=4000
workspace: internal
user: admin
pass: *******

linking with BIP (container name bip, see https://registry.hub.docker.com/u/araczkowski/bip/)

$ docker run -d --name xe -p 49160:22 -p 49161:1521 -p 49162:8080 --link bip araczkowski/xe
  1. check the BIP IP and PORT to set as APEX admin
$ docker exec xe env
  1. Login by SSH ssh root@localhost -p 49160

  2. run ORDS java -Duser.timezone=Europe/Warsaw -jar ords.war standalone

  3. ACL

  DBMS_NETWORK_ACL_ADMIN.create_acl(acl         => 'bip_apex_all_ip.xml'
                                   ,description => 'An ACL for the bip'
                                   ,principal   => 'APEX_050000'
                                   ,is_grant    => TRUE
                                   ,privilege   => 'connect'
                                   ,start_date  => SYSTIMESTAMP
                                   ,end_date    => NULL);

  DBMS_NETWORK_ACL_ADMIN.assign_acl(acl        => 'bip_apex_all_ip.xml'
                                   ,host       => '*'
                                   ,lower_port => 7001
                                   ,upper_port => 7001);

  COMMIT;
END;```

Tag summary

Content type

Image

Digest

sha256:f75f99cbc

Size

1.7 GB

Last updated

over 10 years ago

docker pull araczkowski/xe