Docker 安装Oracle

下载镜像

docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

创建映射路径

docker run -d --name oracle -p 1521:1521 registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
mkdir -p /mnt/oracle/
mkdir -p /mnt/oracle/flash_recovery_area/
docker cp oracle:/home/oracle/app/oracle/oradata /mnt/oracle/oradata
docker cp oracle:/home/oracle/app/oracle/flash_recovery_area/helowin /mnt/oracle/flash_recovery_area/helowin
chmod -R 777 /mnt/oracle/
docker stop oracle
docker rm oracle

启动容器

docker run -d --name oracle -p 1521:1521 --privileged=true -v /mnt/oracle/oradata:/mnt/oracle/app/oracle/oradata -v /mnt/oracle/flash_recovery_area/helowin:/mnt/oracle/app/oracle/flash_recovery_area/helowin registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

基础配置

docker exec -it oracle /bin/bash
source /home/oracle/.bash_profile
su root 
# 密码:helowin
vi /etc/profile
# Oracle
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=helowin
export PATH=$ORACLE_HOME/bin:$PATH
source /etc/profile
su oracle

登录

sqlplus /nolog
connect /as sysdba
# 修改密码
alter user system identified by "woai996";
alter user sys identified by "woai996";
# 设置密码永不过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

修改SID

sqlplus /nolog
connect /as sysdba
# 关闭数据库
shutdown immediate

# 修改配置文件
vi /home/oracle/.bash_profile
ORACLE_SID=orcl;export ORACLE_SID
# root下的/etc/profile同样需要改。
vi /etc/oratab
orcl:/home/oracle/app/oracle/product/11.2.0/dbhome_2:Y

# 重命名文件
cd $ORACLE_HOME/dbs
mv hc_helowin.dat hc_orcl.dat
mv orapwhelowin orapworcl
mv spfilehelowin.ora spfileorcl.ora
mv lkHELOWIN lkORCL

# 重启容器
docker restart oracle
消息盒子

# 暂无消息 #

只显示最新10条未读和已读信息