创建多容器、多实例、多租户、可插拔数据库（CDB、PDB）

1.通过DBCA图形化界面

$ dbca

打开DBCA图形化界面

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 此选项卡全部默认即可

 

 

 

 

 

 

 

 

 

 等待安装完成即可

 

 2.SQL*PLUS

 $ mkdir /u01/app/oracle/oradata/CBD3/seed -p

 $ mkdir /u01/app/oracle/fast_recovery_area/CDB3

 $ cd /u01/app/oracle/admin ;mkdir cdb3 ;cd cdb3

 $ mkdir adump bdump cdump pfile udump

 $ cd /u01/app/oracle/product/18c/dbs ;cp initorcl.ora initcdb3.ora

 $ vi initcdb3.ora

cdb2.__data_transfer_cache_size=0
cdb2.__db_cache_size=603979776
cdb2.__inmemory_ext_roarea=0
cdb2.__inmemory_ext_rwarea=0
cdb2.__java_pool_size=16777216
cdb2.__large_pool_size=33554432
cdb2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
cdb2.__pga_aggregate_target=637534208
cdb2.__sga_target=956301312
cdb2.__shared_io_pool_size=33554432
cdb2.__shared_pool_size=251658240
cdb2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/cdb3/adump'
*.audit_trail='db'
*.compatible='18.0.0'
*.control_files='/u01/app/oracle/oradata/CDB3/control01.ctl','/u01/ap
p/oracle/fast_recovery_area/CDB3/control02.ctl'
*.db_block_size=8192
*.db_name='cdb3'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area/CDB3'
*.db_recovery_file_dest_size=12918m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=cdb2XDB)'
*.enable_pluggable_database=true
*.local_listener='LISTENER_CDB2'
*.memory_target=1507m
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

 使用文本替换功能替换文中的orcl为cdb3

 首先切换到命令模式，然后输入

:%s/orcl/cdb3/g

 $ . oraenv
ORACLE_SID = [orcl] ? cdb3
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/18c
The Oracle base remains unchanged with value /u01/app/oracle

 $ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Oct 13 11:46:04 2020
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Connected to an idle instance.

 

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1593835440 bytes
Fixed Size                  8896432 bytes
Variable Size            1023410176 bytes
Database Buffers          553648128 bytes
Redo Buffers                7880704 bytes
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

$ $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwcdb3 password=Zbbll-123 force=y

$ sqlplus / as sysdba

SQL> CREATE DATABASE cdb3  
     USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle
     LOGFILE GROUP 1 ('/u01/app/oracle/oradata/CDB3/redo1.log') SIZE 100M,
             GROUP 2 ('/u01/app/oracle/oradata/CDB3/redo2.log') SIZE 100M 
     CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16  
    EXTENT MANAGEMENT LOCAL DATAFILE    
                      '/u01/app/oracle/oradata/CDB3/system01.dbf' SIZE 325M 
    SYSAUX DATAFILE  '/u01/app/oracle/oradata/CDB3/sysaux01.dbf' SIZE 325M 
    DEFAULT TEMPORARY TABLESPACE tempts1 
           TEMPFILE '/u01/app/oracle/oradata/CDB3/temp01.dbf' SIZE 20M 
    UNDO TABLESPACE undotbs1
            DATAFILE '/u01/app/oracle/oradata/CDB3/undotbs01.dbf' SIZE 200M
   ENABLE PLUGGABLE DATABASE 
   SEED   FILE_NAME_CONVERT =
        ('/u01/app/oracle/oradata/CDB3',
         '/u01/app/oracle/oradata/CDB3/seed');  2    3    4    5    6    7    8    9   10   11   12   13   14   15   16 

Database created.