docker安装oracle

1.下载镜像

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

2.创建快速搭建脚本build.sh

#!/bin/bash
#启动镜像
containId=`docker ps -a |grep -i oracle11g|awk '{print $1}'`
FDIR=$(dirname $(readlink -f "$0"))
if [[ ! $containId ]] ;then
        echo "target container not exist!"
else
        echo "target container exist , ID = "$containId
        docker stop $containId
        docker rm $containId
        echo "success delete container "$containId
fi

docker run -d -p 1521:1521  -v $FDIR/data/oracle:/data/oracle  --name oracle11g --restart always  registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
sleep 3
docker logs -f --tail 100 oracle11g

3.启动脚本并进入容器进行配置

sh build.sh
docker exec -it oracle11g bash

 root密码：helowin

su - root
vi /etc/profile
最后加上代码：

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

创建软连接：

ln -s $ORACLE_HOME/bin/sqlplus /usr/bin

 数据库配置：

su - oracle

sqlplus /nolog 

conn /as sysdba;

修改密码：
alter user system identified by system;
alter user sys identified by sys;
alter profile default limit password_life_time unlimited;

创建用户：
create user test identified by test;

并给用户赋予权限：
grant connect,resource,dba to test;

用户解锁：
alter user test account unlock;

自动增加表空间容量：
alter tablespace users add datafile '/home/oracle/app/oracle/oradata/helowin/users02.dbf' size 10240m autoextend on next 1024m maxsize unlimited;

扩大共享内存：
alter system set SHARED_POOL_SIZE='150M' SCOPE=spfile;

shutdown immediate;

startup;

原文地址：

https://blog.csdn.net/u012725623/article/details/122013707