1、登陆cdb创建pdb
sqlplus / as sysdba create pluggable database pdb4 admin user pdb4 identified by pdb4 file_name_convert=('/u01/app/oracle/oradata/cdb/pdbseed','/u01/app/oracle/oradata/cdb/pdb4');
2、具体步骤
<roidb01:cdb:/home/oracle>$sqlplus / as sysdba sql*Plus: Release 12.1.0.2.0 Production on Sat Jan 20 12:07:32 2018 Copyright (c) 1982,2014,Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning,OLAP,Advanced Analytics and Real Application Testing options sql> show con_name CON_NAME ------------------------------ CDB$ROOT sql> create pluggable database pdb4 2 admin user pdb4 identified by pdb4 3 file_name_convert=('/u01/app/oracle/oradata/cdb/pdbseed','/u01/app/oracle/oradata/cdb/pdb4'); Pluggable database created. sql> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO 5 PDB3 READ WRITE NO 6 PDB4 MOUNTED sql> alter pluggable database all open; Pluggable database altered. <roidb01:cdb:/u01/app/oracle/oradata/cdb/pdb3>$sqlplus pdb4/pdb4@192.168.1.243:1521/pdb4 sql*Plus: Release 12.1.0.2.0 Production on Sat Jan 20 12:11:50 2018 Copyright (c) 1982,Advanced Analytics and Real Application Testing options sql> show con_name CON_NAME ------------------------------ PDB4 sql>原文链接:https://www.f2er.com/oracle/206552.html