Docker

2018/11/10

Docker中使用Oracle XE 11g

docker pull alexeiled/docker-oracle-xe-11g

docker run -d --shm-size=2g -p 1521:1521 -p 8080:8080 alexeiled/docker-oracle-xe-11g

Start Oracle XE and execute SQL on startup

Put your *.sql files for database init into some local folder and mount this folder during container startup to /etc/entrypoint-initdb.d volume.

docker run -d --shm-size=1g -p 8080:8080 -p 1521:1521 -v /local-initdb:/etc/entrypoint-initdb.d alexeiled/docker-oracle-xe-11g

Connect

Connect database with following setting:

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

Password for SYS user

oracle

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

url: http://localhost:8080/apex
workspace: internal
user: admin
password: oracle

在docker容器内执行如下命令：

sqlplus

conn

输入用户名：sys as sysdba

输入用户密码：oracle

连接数据库成功后

alter user hr account unlock;

alter user hr identified by hr;

commit;