Oracle 12c 命令行创建PDB
发布时间:2020-12-12 14:07:08 所属栏目:百科 来源:网络整理
导读:1、登陆cdb创建pdb sqlplus / as sysdbacreate pluggable database pdb4admin user pdb4 identified by pdb4file_name_convert=('/u01/app/oracle/oradata/cdb/pdbseed','/u01/app/oracle/oradata/cdb/pdb4'); 2、具体步骤 roidb01:cdb:/home/oracle$sqlplus
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> (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |