docker pull registry.cn-hangzhou.aliyuncs.com/zhengqing/oracle18c
mkdir /oracle18c
chmod 777 -R /oracle18c
docker run -d -p 11521:1521 -p 5500:5500 \
--name oracle18c \
-e ORACLE_SID=ORCLCDB \
-e ORACLE_PDB=ORCLPDB1 \
-e ORACLE_PWD=123456 \
-v /oracle18c:/opt/oracle/oradata \
4db9974bbdc7
docker logs 容器ID
等待安装完成(几分钟时间)
docker exec -it 容器ID
设置密码
./setPassword.sh 123456
grep $ORACLE_HOME /etc/oratab | cut -d: -f1
export ORACLE_SID=ORCLCDB
sqlplus / as sysdba
host echo "export ORACLE_SID=ORCLCDB" >> ~/.bashrc --设置服务
host echo "export NLS_LANG=AMERICAN_AMERICA.AL32UTF8; export NLS_LANG" >> ~/.bashrc --设置环境语言(不设置导入导出中文乱码)
exit;
设置服务
echo USE_SID_AS_SERVICE_LISTENER = ON >> /opt/oracle/oradata/dbconfig/ORCLCDB/listener.ora
创建表空间以及授权给新建用户:
SELECT * FROM dba_tablespaces t, dba_data_files d WHERE t.tablespace_name = d.tablespace_name; --查看表空间位置
create tablespace aaa datafile '/u01/app/oracle/oradata/xe/aaa.dbf' size 1M autoextend on next 50M maxsize unlimited;
create user aaa identified by "123456" default tablespace aaa profile DEFAULT ACCOUNT UNLOCK;
grant dba to aaa ;
grant unlimited tablespace to aaa ;
exp aaa/123456@ORCLPDB1 owner=aaa file = /tmp/a.dmp
imp aaa/123456@ORCLPDB1 fromuser=aaa touser=aaa file=/tmp/a.dmp ignore=y
设置好后退出容器,重启服务
连接信息:
IP:192.168.31.99
服务:ORCLPDB1
用户名:aaa
密码:123456