一. 创建pdb
1. 查看主机存储情况(asm/文件系统/裸设备),确定pdb数据文件存放路径
查看存储情况:df -h
查看seed pdb:cdb下查询dba_data_files
查看pdb数据文件存放路径:可以切换到其他pdb结合存储情况确认新建的pdb存放路径
2. create pluggable database
SQL> create pluggable database pdb_test
2 admin user test identified by oracle
3 FILE_NAME_CONVERT =('/oradata/sys/pdbseed','/oradata/data01/pdb_test/')
4 default tablespace TBS_DATA datafile '/oradata/data01/pdb_test/TEST_DATA_01.dbf' size 30G autoextend off;
Pluggable database created.
二. 开启PDB
统计各节点的连接数,可以只开启部分节点(连接数较少的)的pdb
查看rac节点数:gv$instance
统计连接数:
a.
# 连接数使用率
select resource_name, trunc(current_utilization * 100 / limit_value) Result_Number
from v$resource_limit
where resource_name in ('processes');
b. ps -ef|grep LOCAL=NO wc=l #查看外部连接
--3号节点
SQL> select instance_number,instance_name from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
3 prod3
SQL> alter pluggable database pdb_test op