ORACE install by docker


ORACE install by docker

1. 安装阿里的docker源

cat /etc/docker/daemon.json
{
"registry-mirrors": ["https://pee6w651.mirror.aliyuncs.com"]
}

2. 重启docker服务

systemctl restart docker

3. 选者oracle版本

这里选择12c

sudo docker pull sath89/oracle-12c

4. 运行docker

sudo docker run -d --name oracle -p 8080:8080 -p 1521:1521 -v YOURPATH:/mnt -e TZ=Asia/Shanghai sath89/oracle-12c

5. 进入容器登陆

docker exec -it YOURCERTAIINID /bin/bash

find / -name “sqlplus"

/u01/app/oracle-product/12.1.0/xe/bin/sqlplus / as sysdba

create tablespace YOURNAMESPACENAME datafile '/u01/app/oracle/oradata/xe/bspdb.dbf' size 3000m;
create user USERNAME identified by USERPWD default tablespace YOURNAMESPACENAME;
grant dba, connect to USERNAME;

6. 客户端连接

命令行连接:/u01/app/oracle-product/12.1.0/xe/bin/sqlplus USERNAME@USERPWD