虚拟内存需要8G以上
硬盘空间需要100G以上
参考教程:https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance
1、到Oracle官方的Github下载Dockerfile
https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles
2、下载Oracle安装包
Database Software Downloads | Oracle
并放到Dockerimages相应的版本目录下,例如是18.30文件夹下
3、运行buildDockerImages.sh
./buildDockerImage.sh -v 18.30 -e
大概要等很久
可以再开一个SSH窗口,查看Images列表的状态,它会自动生成好几个镜像,然后最终又只剩下一个
“oracle/database 18.3.0-ee 2f2da38d0d2d 5 hours ago 8.39GB”
4、更改文件夹权限chown 54321:root /softworkconfig/docker/oracle/data/oradata
5、创建createOracle.sh
#!/bin/bashdocker stop oracle1830docker rm oracle1830docker run --name oracle1830 \ -p 1521:1521 -p 5500:5500 \ -it \ -e ORACLE_SID=oraclesid \ -e ORACLE_PDB=oraclepdb \ -e ORACLE_PWD=qweQWEasdASD \ -e ORACLE_CHARACTERSET=AL32UTF8 \ -v /softworkconfig/docker/oracle/data/oradata:/opt/oracle/oradata \ -v /softworkconfig/docker/oracle/data/startup:/opt/oracle/scripts/startup \ -v /softworkconfig/docker/oracle/data/setup:/opt/oracle/scripts/setup \ -v /softworkconfig/docker/oracle/data/docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d \ oracle/database:18.3.0-ee
运行,等到出现
#########################DATABASE IS READY TO USE!########################
6、登录测试
sqlplus sys/<your password>@//localhost:1521/<your SID> as sysdbasqlplus system/<your password>@//localhost:1521/<your SID>sqlplus pdbadmin/<your password>@//localhost:1521/<Your PDB name>
7、创建用户
sqlplus sys/qweQWEasdASD@//localhost:1521/oraclesid as sysdba
alter session set container=oraclepdb;
create user syni identified by qweQWEasdASD;grant CONNECT to syni;
grant resource to syni;
指定表空间:
alter user syni default tablespace "syni_tablespace";
alter user syni temporary tablespace "syni_tmptablespace";
alter user syni quota unlimited on "syni_tablespace3";
双引号很重要
8、使用用户登录
sqlplus syni/qweQWEasdASD@oraclepdb;