zhude/oracle repository overview

Linux系统信息：Red Hat 4.8.5-36，系统用户密码：root(无密码), oracle

oracle版本：Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production。

下载：docker push zhude/oracle:12c

运行 docker run -d -p 8080:8080 -p 1521:1521 -v /root/oracleFlie:/file zhude/oracle:12c

其中端口8080用于 Oracle Enterprise Management console ， 1521用于远程连接数据库端口

Connect database with following setting:

hostname: localhost(IP)

port: 1521

sid: xe

service name: xe

username: system

password: oracle

进入容器 并执行sql方法： （1）docker -exec -it <容器id> /bin/sh

（2）su oracle

（3） cd $ORACLE_HOME

   /u01/app/oracle/product/12.2.0/SE/bin/sqlplus  as sysdba   system/oracle@//localhost:1521/xe

Connect to Oracle Enterprise Management console with following settings:

http://localhost:8080/em⁠

user: sys

password: oracle

connect as sysdba: true

Web管理控制台已启用

docker run -d -e WEB_CONSOLE=false -p 1521:1521 -v /my/oracle/data:/u01/app/oracle zhude/oracle:12c #You can Enable/Disable it on any time

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

http://localhost:8080/apex⁠

workspace: INTERNAL

user: ADMIN

password: 0Racle$

Start with additional init scripts or dumps:

docker run -d -p 1521:1521 -v /my/oracle/data:/u01/app/oracle -v /my/oracle/init/SCRIPTSorSQL:/docker-entrypoint-initdb.d zhude/oracle:12c

默认 docker-entrypoint-initdb.d 只有第一次启作用

To customize dump import use ‘IMPDP_OPTIONS’ env variable like -e IMPDP_OPTIONS="REMAP_TABLESPACE=FOO:BAR" To run import at any case add -e IMPORT_FROM_VOLUME=true

In case of using DMP imports dump file should be named like ${IMPORT_SCHEME_NAME}.dmp

User credentials for imports are ${IMPORT_SCHEME_NAME}/${IMPORT_SCHEME_NAME}