oracle12C以上版本创建pdb数据库实例实践

1.1 连接数据库

说明：本示例数据库为docker容器部署，实际物理机部署的数据库直接使用sqlplus / as sysdba 进入数据库即可

[admin@localhost ~]$ docker ps
CONTAINER ID   IMAGE           COMMAND       CREATED       STATUS       PORTS                                                                                  NAMES
857c9fee68c2   settle/ora:v1   "/bin/bash"   13 days ago   Up 13 days   0.0.0.0:1521->1521/tcp, :::1521->1521/tcp, 0.0.0.0:5500->5500/tcp, :::5500->5500/tcp   容器名
[admin@localhost ~]$ docker exec -it --user oracle 容器名/容器id /bin/bash
[oracle@ora184 /]$ sqlplus / as sysdba

1.2 查询该容器是CDB 还是非CDB

SQL> select name,cdb,open_mode,con_id from v$database;

NAME      CDB OPEN_MODE                CON_ID
--------- --- -------------------- ----------
ORCLCDB   YES READ WRITE                    0

查看所创建的PDB

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       READ WRITE NO

2.1创建一个新PDB

SQL> select  name from v$datafile;

NAME
--------------------------------------------------------------------------------
/opt