Docker安装Oracle创建表空间并导入数据库完整步骤

docker version

docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

docker run -d -p 30026:1521 -p 8081:8080 --name oracle_11g -e oracle_home=/home/oracle/app/oracle/product/11.2.0/dbhome_2 -e oracle_sid=helowin registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

# 1. 切换至root用户(默认是oracle用户)，密码为helowin
su root

# 2. 创建软链接
ln -s $oracle_home/bin/sqlplus /usr/bin

# 3.切换回oracle用户
su oracle

# 4. 登录sql plus
sqlplus /nolog
conn /as sysdba
## 4.1 修改system用户密码为system
alter user system identified by system;
## 4.2 修改sys用户密码为system
alter user sys identified by system;
## 4.3 新增一个测试用户（用户名：test，密码：test123）;
create user test identified by test123;
## 4.4 将dba权限给内部管理员账号和密码
grant connect,resource,dba to sys_orm;
## 4.5 修改密码策略规则为：密码永不过期
alter profile default limit password_life_time unlimited;
## 4.6 修改数据库最大连接数；
alter system set processes=1000 scope=spfile;
## 4.7 最后重启数据库；
shutdown immediate;
startup;

# 5.退出
exit

 select t1.name,t2.name  from v$tablespace t1,v$datafile t2  where t1.ts# = t2.ts#;

create tablespace orm
datafile '/home/oracle/app/oracle/oradata/helowin/orm.dbf' size 800m  	   --存储地址 初始大小800m
	autoextend on next 50m maxsize unlimited                   --每次扩展10m，无限制扩展
         extent management local autoallocate segment space management auto; 

create user orm identified by orm default tablespace orm;  

grant connect,resource,create type,create view,recovery_catalog_owner to orm;

docker cp  /home/imp e5w3hr4rrre3:/home/ormexp

# 切换oracle用户：
su - oracle
# 管理员登录
sqlplus sys/system@orcl as sysdba

create directory ormexp as '/home/ormexp';   
grant read,write on directory ormexp to orm;

expdp orm/orm@orcl directory=ormexp dumpfile=data.dmp

# 切换oracle用户：
su - oracle
# 管理员登录
sqlplus sys/system@orcl as sysdba

create directory ormimp as '/home/ormimp';   
grant read,write on directory ormimp to orm;

impdp orm/orm@orcl directory=impdata remap_tablespace=bluesys20240715:orm dumpfile=bluesys.dmp remap_schema=bluesys:orm transform=oid:n

impdp orm/orm directory=impdata remap_tablespace=bluesys20240715:orm dumpfile=bluesys.dmp remap_schema=bluesys:orm transform=oid:n