docker-oracle-xe-11g-soa

Forked from https://github.com/wnameless/docker-oracle-xe-11g

Oracle Express Edition 11g Release 2 on Ubuntu 14.04.1 LTS

Installation

git clone https://github.com/plmwong/docker-oracle-xe-11g-soa.git
docker build -t paybyphone/soa docker-oracle-xe-11g-soa

Run container with 22 and 1521 ports opened:

docker run -d -p 49160:22 -p 49161:1521 paybyphone/soa

The following support roles will be created automatically

SUPPORT_SELECT_ROLE
SUPPORT_INSERT_ROLE
SUPPORT_DELETE_ROLE
SUPPORT_UPDATE_ROLE
SUPPORT_ALTER_ROLE

If running under boot2docker, stop the boot2docker-vm and forward some ports:

setup-port-forwarding.cmd
or
setup-port-forwarding.sh

Connect to database:

hostname: localhost
port: 49161
sid: xe
username: system
password: oracle

Example tnsnames.ora entry:

soa.local = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 49161)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xe)))

Password for SYS & SYSTEM

oracle

Login via SSH

ssh root@localhost -p 49160
password: admin