拉取oracle镜像
docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
运行oracle,生成相应容器
docker run -p 8200:1521 --name oracle11g -d registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
配置oracle
# 查看所有容器信息
docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
d18f5ad185d7 registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g "/bin/sh -c '/home/o…" 12 days ago Up 12 days 0.0.0.0:8200->1521/tcp, :::8200->1521/tcp oracle11g
# 进入oracle容器
docker exec -it d18f5ad185d7 bash
# 切换root用户,默认密码为helowin
[oracle@d18f5ad185d7 /]$ su
Password:
[root@d18f5ad185d7 /]#
# 编辑环境变量
vi /etc/profile
# 在末尾添加如下内容
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=lckj
export PATH=$ORACLE_HOME/bin:$PATH
# 配置生效
source /etc/profile
# 切换到oracle用户
[root@d18f5ad185d7 /]# su oracle
[oracle@d18f5ad185d7 /]$
# 刷新配置
[oracle@d18f5ad185d7 /]$ source ~/.bash_profile
# 连接oracle
[oracle@d18f5ad185d7 /]$ sqlplus /nolog
SQL> conn /as sysdba
Connected.
# 修改 system的密码
SQL> alter user system identified by lckj123456;
# 修改sys密码
SQL> alter user sys identified by lckj123456;
# 切换用户到system
SQL> conn system/lckj123456
Connected.
# 查看实例名
SQL> select instance from v$thread;
INSTANCE
--------------------------------------------------------------------------------
helowin