1 登录cdb
export ORACLE_SID=orclcdb
sqlplus / as sysdba
2 建pdb
#这里利用pdbseed建一个orclpdb5
CREATE PLUGGABLE DATABASE orclpdb5 ADMIN USER pdbadmin IDENTIFIED BY oracle file_name_convert=('pdbseed','orclpdb5')
--看到会自动创建orclpdb5目录(和pdbseed并列),并在该目录下创建数据文件
3 启动pdb
alter pluggable database orclpdb5 open;
4 配tnsnames.ora
新增如下内容:
orclpdb5 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclpdb5)
)
)
5 连接验证
[oracle@PC admin]$ sqlplus sys@orclpdb5 as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 15 13:11:22 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
5 ORCLPDB5 READ WRITE NO