1,参考下面链接制作Oracle Database镜像 =》Oracle Database on Docker
例如,
git clone https://github.com/oracle/docker-images.git
cd OracleDatabase/SingleInstance/dockerfiles
./buildDockerImage.sh -v 19.3.0 -s
Note:请先下载Oracle Database相应版本的安装文件
2,Docker容器运行Oracle Database
例如,
docker run -d --name ordb-19c --restart=always \
-e ORACLE_SID=CDB1 -e ORACLE_PDB=PDB1 -e ORACLE_PWD=<YOUR_PREFERRED_PASSWORD> \
-v /u01/ordb-data/oradata:/opt/oracle/oradata \
-p 1521:1521 -p 5500:5500 \
oracle/database:19.3.0-ee
3,登录到Oracle Database容器中设置pdbadmin用户权限以及修改密码
docker exec -it ordb-19c bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
conn / as sysdba;
ALTER SESSION SET container = pdb1;
GRANT
SYSOPER, DBA, PDB_DBA, RESOURCE, CONNECT,
CREATE SESSION,
CREATE PLUGGABLE DATABASE,
CREATE TABLE,
UNLIMITED TABLESPACE
TO pdbadmin;
alter user pdbadmin identified by <YOUR_PREFERRED_PASSWORD>;
4,使用Oracle Sql Developer连接
结尾!