Docker中安装Oracle

搜索可用的Oracle镜像

docker search oracle

拉取Oracle镜像

docker pull truevoly/oracle-12c

创建Docker容器

-- 这里使用宿主机8090端口关联oracle控制台的8080端口，1521对应oracle服务的1521端口，使用本机共享目录/Users/zhangxin/oracle/data绑定容器重的/u01/app/oracle目录
docker run --name oracle -d -p 8090:8080 -p 1521:1521 -v /Users/zhangxin/oracle/data:/u01/app/oracle truevoly/oracle-12c

默认数据库信息

数据库环境初始化

create user OES511 identified by OES511;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO OES511;
create tablespace OES511 datafile '/u01/app/oracle/AHSL/OES51101.dmp' size 512M autoextend on next 500M maxsize unlimited;
alter user OES511 default tablespace OES511;
create or replace directory dir_oesahsl_dp as '/u01/app/oracle/AHSL';
Grant read,write on directory dir_oesahsl_dp to OES511;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51102.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51103.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51104.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51105.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51106.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;


-- 导入数据库
impdp OES511/OES511@ORCL DIRECTORY=dir_oesahsl_dp DUMPFILE=20220206230001.dmp REMAP_SCHEMA=OES511:OES511 REMAP_TABLESPACE=OES511:OES511 full=y transform=oiD:n

-- 导入数据库排除大容量表
impdp OES511/OES511@ORCL DIRECTORY=dir_oesahsl_dp DUMPFILE=OES511.dmp REMAP_SCHEMA=OES511:OES511 REMAP_TABLESPACE=OES511:OES511 full=y transform=oiD:n exclude=tablD:\"in(\'DEPT_INCOME_DAY\',\'ACCT_CHARGE_DETAIL_WJ_VIEW_HZ\')\"

-- 还原指定表
impdp OES511/OES511@ORCL DIRECTORY=dir_oesahsl_dp DUMPFILE=20220206230001.dmp REMAP_SCHEMA=OES511:OES511 REMAP_TABLESPACE=OES511:OES511 include=tablD:\"in(\'MATE_WHR_MAIN\',\'MATE_WHR_DETAIL\')\"



--删除用户，及级联关系也删除掉
drop user OES511 cascade;
--删除表空间，及对应的表空间文件也删除掉
drop tablespace OES511 including contents and datafiles cascade constraint;

-- 查询字符集
select userenv('language') from dual;

-- 更新用户密码

UPDATE UP_ORG_USER set password='xMpCOKC5I4INzFCab3WEmw=='