docker安装oracle11g

docker run -di --name test --restart unless-stopped
-p 1521:1521 registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

创建文件夹

mkdir -p /home/docker/config/oracle
#复制文件出来 docker cp 容器名字：目录地址 /本地地址
docker cp test:/home/oracle/app/ /home/docker/config/oracle
cd /home/docker/config/oracle

500 500 是容器内 oracle 组和用户的 id

chown -R 500.500 app

删除容器

docker rm -f test

docker run -d --name oracle --restart unless-stopped -v /home/docker/config/oracle/app:/home/oracle/app -p 1521:1521 registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

docker exec -it oracle /bin/bash
cd /home/oracle/
source .bash_profile

删除老的oracle control

rm -rf /home/oracle/app/oracle/flash_recovery_area/helowin/control02.ctl
cp /home/oracle/app/oracle/oradata/helowin/control01.ctl /home/oracle/app/oracle/flash_recovery_area/helowin/control02.ctl
sqlplus / as sysdba # 以 dba 身份连接 oracle 数据库
shutdown immediate # 关闭数据库实例（这里会报错，不用管）
startup
alter user system identified by 123456;
alter user sys identified by 123456;
alter profile default limit password_life_time unlimited;

导入
@/home/oracle/app/1.sql