Oracle 12C RAC CDB数据库部署

Oracle 中的12C新特性-容器数据库

---12.1.0.2_GI_RAC_Create_CDB_Blog

一、 安装前的准备

安装两个节点的 12.1.0.2 GI/RAC ，创建 CDB 数据库。

1. 关闭 SELINUX

vim /etc/selinux/config* Change the SELINUX value to "SELINUX=disabled".另外，关闭OS iptable等服务service NetworkManager stopservice iptables stopchkconfig NetworkManager offchkconfig iptables off

2. 网络IP配置（HOSTS文件）

cat /etc/hosts# vastdata11192.168.56.11          vastdata11.us.oracle.com        vastdata11192.168.56.21          vastdata11-vip.us.oracle.com    vastdata11-vip10.0.0.2               vastdata11-priv1.us.oracle.com  vastdata11-priv110.0.0.3               vastdata11-priv2.us.oracle.com  vastdata11-priv2             # vastdata12 192.168.56.12          vastdata12.us.oracle.com        vastdata12192.168.56.22          vastdata12-vip.us.oracle.com    vastdata12-vip10.0.0.4               vastdata12-priv1.us.oracle.com  vastdata12-priv110.0.0.5               vastdata12-priv2.us.oracle.com  vastdata12-priv2             # rac-scan   192.168.56.33          vastdata-scan.us.oracle.com     vastdata-scan192.168.56.34          vastdata-scan.us.oracle.com     vastdata-scan192.168.56.35          vastdata-scan.us.oracle.com     vastdata-scan

3. 安装OS系统RPM包

Oracle Linux 6 and Red Hat Linux 6 需要安装下面系统RPM包， 其他OS版本请参考在线文档： http://docs.oracle.com/database/121/CWLIN/prelinux.htm#CEGCECCC

配置YUM源

cd /etc/yum.repos.d/cat yum.repo[oel6] name=OEL6.5 baseurl=file:///media/OL6.5\ x86_64\ Disc\ 1\ 20131125 gpgcheck=0 enabled=1

安装RPM包

yum install binutils compat-libcap1 compat-libstdc++-33 iptraf gcc gcc-c++ glibc-devel glibc elfutils-libelf-devel compat-libcap1 compat-libstdc++-33 libaio-devel ksh libgcc libstdc libstdc++ libstdc++-devel libaio libaio-devel make sysstat unixODBC unixODBC-devel -yyum install binutils-2.20.51.0.2-5.11.el6 compat-libcap1-1.10-1 compat-libstdc++-33-3.2.3-69.el6 compat-libstdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6 gcc-c++-4.4.4-13.el6 glibc-2.12-1.7.el6 glibc-2.12-1.7.el6 glibc-devel-2.12-1.7.el6 glibc-devel-2.12-1.7.el6.i686 ksh libgcc-4.4.4-13.el6 libgcc-4.4.4-13.el6 libstdc++-4.4.4-13.el6 libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6 libstdc++-devel-4.4.4-13.el6.i686 libaio-0.3.107-10.el6 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 libaio-devel-0.3.107-10.el6.i686 libXext-1.1 libXext-1.1 libXtst-1.0.99.2 libXtst-1.0.99.2 libX11-1.3 libX11-1.3 libXau-1.0.5 libXau-1.0.5 libxcb-1.5 libxcb-1.5 libXi-1.3 libXi-1.3 make-3.81-19.el6 sysstat-9.0.4-11.el6 nfs-utils-1.2.3-15.0.1 -y

4. Ulimit 资源设置

设置/etc/security/limits.conf，详细参考在线文档：

http://docs.oracle.com/database/121/LADBI/usr_grps.htm#LADBI7674

oracle    soft    nproc     2047 oracle    hard    nproc     16384 oracle    soft    nofile    1024 oracle    hard    nofile    65536 oracle    soft    stack     10240 oracle    hard    stack     10240grid      soft    nproc     2047 grid      hard    nproc     16384 grid      soft    nofile    1024 grid      hard    nofile    65536 grid      soft    stack     10240 grid      hard    stack     10240

5. 添加用户组

groupadd -g 54321 oinstallgroupadd -g 54322 dbagroupadd -g 54328 asmadmingroupadd -g 54325 asmdbauseradd -u 54322 -g oinstall -G asmadmin,asmdba griduseradd -u 54321 -g oinstall -G dba,asmdba oracleecho "oracle" | passwd --stdin oracleecho "grid" | passwd --stdin grid

6. 创建目录结构

--创建 GRID_BASEmkdir -p /u01/app/grid --创建 GRID_HOMEmkdir -p /u01/12.1.0/gridchown -R grid:oinstall /u01chmod -R 775 /u01/chmod -R 775 /u01/12.1.0/grid --创建 ORACLE_BASEmkdir -p /u01/app/oraclechown oracle:oinstall /u01/app/oraclechmod -R 775 /u01/

7. 配置oracle、grid用户环境变量

GRID环境变量 export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_HOSTNAME=vastdata11.us.oracle.comexport ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/12.1.0/gridexport NLS_DATE_FORMAT="yy-mm-dd hh34:mi:ss"export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKumask 022-------------------------------------------------------------------------------ORACLE环境变量 export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_HOSTNAME=vastdata11.us.oracle.comexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1export ORACLE_UNQNAME=PRODexport ORACLE_SID=PROD1export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"export NLS_LANG=AMERICAN_AMERICA.ZHS16GBKumask 022

8. private- 配置私网

vim /etc/sysconfig/network-scripts/ifcfg-eth3DEVICE=eth3IPADDR=10.0.0.2NETMASK=255.255.255.0TYPE=EthernetNM_CONTROLLED=yesUSERCTL=noBOOTPROTO=noneONBOOT=yes

9. 绑定网卡-Bond

1) 加载bond功能

modprobe --first-time bondinglsmod | grep bonding

2) 配置网卡文件

vim /etc/sysconfig/network-scripts/ifcfg-bond0DEVICE=bond0TYPE=BondIPADDR=192.168.56.11NETMASK=255.255.255.0USERCTL=noBOOTPROTO=noneONBOOT=yesBONDING_MASTER=yesBONDING_OPTS="mode=0 miimon=100" vim /etc/sysconfig/network-scripts/ifcfg-eth0DEVICE=eth0USERCTL=noONBOOT=yesMASTER=bond0SLAVE=yesBOOTPROTO=none vim /etc/sysconfig/network-scripts/ifcfg-eth2DEVICE=eth2USERCTL=noONBOOT=yesMASTER=bond0SLAVE=yesBOOTPROTO=none vim /etc/modprobe.d/dist.confalias bond0 bondingoptions bonding miimon=100 mode=0

3) 重启网卡服务

service network restartcat /proc/net/bonding/bond0ifconfig

10. 配置解析服务器

1) 主域名解析服务器

yum install bind bind-chroot -ycp -p /etc/named.conf /etc/named.conf.bakvim /etc/named.conf //// named.conf//// Provided by Red Hat bind package to configure the ISC BIND named(8) DNS// server as a caching only nameserver (as a localhost DNS resolver only).//// See /usr/share/doc/bind*/sample/ for example named configuration files.//options {    listen-on port 53 { any; };    directory   "/var/named";        allow-query     { any; };    allow-query-cache     { any; };    recursion no;};  zone "." IN {    type hint;    file "named.ca";};  zone "us.oracle.com" IN {        type master;        file "us.oracle.com.zone";};  zone "56.168.192.in-addr.arpa" IN {        type master;        file "192.168.56.local";}; cd /var/named/cp -p named.localhost us.oracle.com.zonecp -p us.oracle.com.zone 192.168.56.localvim /var/named/us.oracle.com.zone  $TTL 1D@   IN SOA  vastdata11.us.oracle.com.     root.us.oracle.com. (                       0   ; serial                       1D  ; refresh                       1H  ; retry                       1W  ; expire                       3H )    ; minimum               NS     dns.us.oracle.com.vastdata11             A     192.168.56.11vastdata12             A     192.168.56.12vastdata-scan          A     192.168.56.33vastdata-scan          A     192.168.56.34vastdata-scan          A     192.168.56.35dns                    A     192.168.56.44vastdata11-vip         A     192.168.56.21vastdata12-vip         A     192.168.56.22vastdata11-priv1       A     10.0.0.2vastdata11-priv2       A     10.0.0.3vastdata12-priv1       A     10.0.0.4vastdata12-priv2       A     10.0.0.5 vim /var/named/192.168.56.local $TTL 1D@   IN SOA  vastdata11.us.oracle.com.     root.us.oracle.com. (                       0   ; serial                       1D  ; refresh                       1H  ; retry                       1W  ; expire                       3H )    ; minimum           IN NS   dns.us.oracle.com.11         IN PTR  vastdata11.us.oracle.com.12         IN PTR  vastdata12.us.oracle.com.33         IN PTR  vastdata-scan.us.oracle.com.34         IN PTR  vastdata-scan.us.oracle.com.35         IN PTR  vastdata-scan.us.oracle.com.44         IN PTR  dns21         IN PTR  vastdata11-vip.us.oracle.com.22         IN PTR  vastdata12-vip.us.oracle.com. service network restartservice named restartchkconfig named onchkconfig named --list-----------------------------------------------nslookup vastdata-scan.us.oracle.com

2) 从域名解析服务器

cd /etc/vim named.conf  options {    directory   "/var/named";        allow-query     { any; };    recursion no;};zone "us.oracle.com" IN {        type slave;        file "slave/us.oracle.com.zone";        masters { 192.168.56.11; };        allow-transfer { none; };};zone "56.168.192.in-addr.arpa" IN {        type slave;        file "slave/192.168.56.rev";        masters { 192.168.56.11; };}; CLIENT DNS配置vim /etc/resolv.conf   nameserver 192.168.56.11 service named restartnslookup vastdata-scan.us.oracle.com

11. 配置 ASM Disk

第一种：使用 udev 第二种：使用 asmlib ---------------------------------------------------------------------------------首先OS层面配置disk fdisk /dev/sdb --配置后的disk信息：ls -l /dev/sd* --标记新加卷组vim 1.sh for i in b c d ; doecho "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules done chmod +x 1.sh./1.sh cat /etc/udev/rules.d/99-oracle-asmdevices.rulesstart_udevls -al /dev/asm-disk*

12. 配置互信

（root、grid、oracle，这三个用户都需要配置互信，以及与自己配置互信）

ssh-keygen -t rsacd /root/.ssh/cat id_rsa.pub >> authorized_keysservice sshd restart

13. 时间同步功能

在主DNS服务器重启后则变成active，否则就是观望者（observer）

关闭两台机器的时间同步功能：

rm -rf /etc/ntp.confrm -rf /etc/sysconfig/ntpd

14. CVU 检查

运行 CVU 检查系统配置是否满足条件，在运行 CVU 之前需要手动配置 SSH

./runcluvfy.sh stage -pre crsinst -n vastdata11,vastdata12 -fixup -verbose

二、 安装配置集群 GRID

1. 运行OUI

1) 运行 runInstaller

export DISPLAY=192.168.56.1:1.0xhost +

2) 选择安装集群

3) 配置标准集群

4) 高级安装

5) 选择语言

6) 配置集群名和 SCAN

7) 选择节点信息

8) 配置测试 SSH

9) 配置网卡

10) 选择标准 ASM 存储

11) 创建 diskgroup

12) ASM Password

13) 配置失败隔离

14) 配置 EM

15) 配置 OS group

16) 配置GI安装目录和数据目录，以及oraInventory目录

17) 选择 root 脚本自动运行，如果不选择，那么按照 12c 之前的方法手动运行 root.sh

18) 前提检查

执行修复脚本

再次检查

忽略可ignore的warning

19) 总结

20) 开始安装，提示自动运行 root.sh 脚本

21) 继续配置集群

2. 资源状态

[grid@vastdata11 ~]$ crsctl stat res -t--------------------------------------------------------------------------------Name           Target  State        Server                   State details       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.LISTENER.lsnr               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.asm               ONLINE  ONLINE       vastdata11               Started,STABLE               ONLINE  ONLINE       vastdata12               Started,STABLEora.net1.network               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.ons               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr      1        ONLINE  ONLINE       vastdata12               STABLEora.LISTENER_SCAN2.lsnr      1        ONLINE  ONLINE       vastdata11               STABLEora.LISTENER_SCAN3.lsnr      1        ONLINE  ONLINE       vastdata11               STABLEora.MGMTLSNR      1        ONLINE  ONLINE       vastdata11               169.254.62.144 10.0.                                                             0.2 10.0.0.2,STABLEora.cvu      1        ONLINE  ONLINE       vastdata11               STABLEora.mgmtdb      1        ONLINE  ONLINE       vastdata11               Open,STABLEora.oc4j      1        ONLINE  ONLINE       vastdata11               STABLEora.scan1.vip      1        ONLINE  ONLINE       vastdata12               STABLEora.scan2.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.scan3.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.vastdata11.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.vastdata12.vip      1        ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------[grid@vastdata11 ~]$ crsctl stat res -t -init--------------------------------------------------------------------------------Name           Target  State        Server                   State details       --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm      1        ONLINE  ONLINE       vastdata11               Started,STABLEora.cluster_interconnect.haip      1        ONLINE  ONLINE       vastdata11               STABLEora.crf      1        ONLINE  ONLINE       vastdata11               STABLEora.crsd      1        ONLINE  ONLINE       vastdata11               STABLEora.cssd      1        ONLINE  ONLINE       vastdata11               STABLEora.cssdmonitor      1        ONLINE  ONLINE       vastdata11               STABLEora.ctssd      1        ONLINE  ONLINE       vastdata11               ACTIVE:0,STABLEora.diskmon      1        OFFLINE OFFLINE                               STABLEora.drivers.acfs      1        ONLINE  ONLINE       vastdata11               STABLEora.evmd      1        ONLINE  ONLINE       vastdata11               STABLEora.gipcd      1        ONLINE  ONLINE       vastdata11               STABLEora.gpnpd      1        ONLINE  ONLINE       vastdata11               STABLEora.mdnsd      1        ONLINE  ONLINE       vastdata11               STABLEora.storage      1        ONLINE  ONLINE       vastdata11               STABLE--------------------------------------------------------------------------------[grid@vastdata12 ~]$ crsctl stat res -t--------------------------------------------------------------------------------Name           Target  State        Server                   State details       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.LISTENER.lsnr               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.asm               ONLINE  ONLINE       vastdata11               Started,STABLE               ONLINE  ONLINE       vastdata12               Started,STABLEora.net1.network               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.ons               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr      1        ONLINE  ONLINE       vastdata12               STABLEora.LISTENER_SCAN2.lsnr      1        ONLINE  ONLINE       vastdata11               STABLEora.LISTENER_SCAN3.lsnr      1        ONLINE  ONLINE       vastdata11               STABLEora.MGMTLSNR      1        ONLINE  ONLINE       vastdata11               169.254.62.144 10.0.                                                             0.2 10.0.0.2,STABLEora.cvu      1        ONLINE  ONLINE       vastdata11               STABLEora.mgmtdb      1        ONLINE  ONLINE       vastdata11               Open,STABLEora.oc4j      1        ONLINE  ONLINE       vastdata11               STABLEora.scan1.vip      1        ONLINE  ONLINE       vastdata12               STABLEora.scan2.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.scan3.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.vastdata11.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.vastdata12.vip      1        ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------[grid@vastdata12 ~]$ crsctl stat res -t -init--------------------------------------------------------------------------------Name           Target  State        Server                   State details       --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm      1        ONLINE  ONLINE       vastdata12               Started,STABLEora.cluster_interconnect.haip      1        ONLINE  ONLINE       vastdata12               STABLEora.crf      1        ONLINE  ONLINE       vastdata12               STABLEora.crsd      1        ONLINE  ONLINE       vastdata12               STABLEora.cssd      1        ONLINE  ONLINE       vastdata12               STABLEora.cssdmonitor      1        ONLINE  ONLINE       vastdata12               STABLEora.ctssd      1        ONLINE  ONLINE       vastdata12               ACTIVE:0,STABLEora.diskmon      1        OFFLINE OFFLINE                               STABLEora.drivers.acfs      1        ONLINE  ONLINE       vastdata12               STABLEora.evmd      1        ONLINE  ONLINE       vastdata12               STABLEora.gipcd      1        ONLINE  ONLINE       vastdata12               STABLEora.gpnpd      1        ONLINE  ONLINE       vastdata12               STABLEora.mdnsd      1        ONLINE  ONLINE       vastdata12               STABLEora.storage      1        ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------

三、 安装/创建 Database

1. 运行 OUI/runInstaller

1) 运行 runInstaller

2) 忽略 update 配置

3) 只安装软件

4) 选择安装 RAC 数据库

5) 选择 RAC 节点

6) 选择语言

7) 选择版本

8) 选择 ORACLE_HOME

9) 配置 OS 组

10) 前提检查

11) 总结

12) 开始安装，并执行root.sh脚本

2. ASMCA创建磁盘组

3. DBCA 建库(CDB)

1) 运行 dbca

2) 创建数据库

3) 高级安装

4) 选择数据库类型是 RAC 类型， 配置类型是 Admin-Managed

5) 设置数据库名，并且选择创建 Container database

6) 选择节点

7) OEM 和 CVU 配置

8) 密码设置

9) 选择 ASM 存储

10) 在 CDB 数据库类型中， 默认所有组件都选择

11) 其他配置选项

12) 内存和字符集配置

13) 创建选项

14) 前提检查

15) 总结

16) 开始安装

4. 资源检查

[grid@vastdata12 ~]$ crsctl stat res -t--------------------------------------------------------------------------------Name           Target  State        Server                   State details       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.FRA.dg               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.LISTENER.lsnr               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.asm               ONLINE  ONLINE       vastdata11               Started,STABLE               ONLINE  ONLINE       vastdata12               Started,STABLEora.net1.network               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLEora.ons               ONLINE  ONLINE       vastdata11               STABLE               ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr      1        ONLINE  ONLINE       vastdata12               STABLEora.LISTENER_SCAN2.lsnr      1        ONLINE  ONLINE       vastdata11               STABLEora.LISTENER_SCAN3.lsnr      1        ONLINE  ONLINE       vastdata11               STABLEora.MGMTLSNR      1        ONLINE  OFFLINE                               169.254.67.242 10.0.                                                             0.4,STABLEora.cdb.db      1        ONLINE  ONLINE       vastdata11               Open,STABLE      2        ONLINE  ONLINE       vastdata12               Open,STABLEora.cvu      1        ONLINE  ONLINE       vastdata11               STABLEora.mgmtdb      1        ONLINE  OFFLINE                               STABLEora.oc4j      1        ONLINE  ONLINE       vastdata11               STABLEora.scan1.vip      1        ONLINE  ONLINE       vastdata12               STABLEora.scan2.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.scan3.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.vastdata11.vip      1        ONLINE  ONLINE       vastdata11               STABLEora.vastdata12.vip      1        ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------[grid@vastdata12 ~]$  crsctl stat res -t -init--------------------------------------------------------------------------------Name           Target  State        Server                   State details       --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm      1        ONLINE  ONLINE       vastdata12               Started,STABLEora.cluster_interconnect.haip      1        ONLINE  ONLINE       vastdata12               STABLEora.crf      1        ONLINE  ONLINE       vastdata12               STABLEora.crsd      1        ONLINE  ONLINE       vastdata12               STABLEora.cssd      1        ONLINE  ONLINE       vastdata12               STABLEora.cssdmonitor      1        ONLINE  ONLINE       vastdata12               STABLEora.ctssd      1        ONLINE  ONLINE       vastdata12               ACTIVE:0,STABLEora.diskmon      1        OFFLINE OFFLINE                               STABLEora.drivers.acfs      1        ONLINE  ONLINE       vastdata12               STABLEora.evmd      1        ONLINE  ONLINE       vastdata12               STABLEora.gipcd      1        ONLINE  ONLINE       vastdata12               STABLEora.gpnpd      1        ONLINE  ONLINE       vastdata12               STABLEora.mdnsd      1        ONLINE  ONLINE       vastdata12               STABLEora.storage      1        ONLINE  ONLINE       vastdata12               STABLE--------------------------------------------------------------------------------

5. PDB 启动/连接

1) 连接到 CDB

[oracle@vastdata11 ~]$ export ORACLE_SID=cdb1[oracle@vastdata11 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Wed May 15 06:49:24 2019Copyright (c) 1982, 2014, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Advanced Analytics and Real Application Testing optionsSQL> SELECT NAME, CDB, CON_ID FROM V$DATABASE;NAME     CDB       CON_ID------------------ ------ ----------CDB     YES     0SQL> select name,cdb,con_id from v$database;NAME     CDB       CON_ID------------------ ------ ----------CDB     YES     0SQL> SELECT SYS_CONTEXT ('USERENV', 'CON_NAME') FROM DUAL;SYS_CONTEXT('USERENV','CON_NAME')--------------------------------------------------------------------------------CDB$ROOTSQL> select sys_context('userenv','con_name') from dual;SYS_CONTEXT('USERENV','CON_NAME')--------------------------------------------------------------------------------CDB$ROOT

2) 启动PDB，并从cdb switchover到pdb

SQL> alter pluggable database pdb open;alter pluggable database pdb open*ERROR at line 1:ORA-65019: pluggable database PDB already openSQL> alter session set container=pdb;Session altered.

3) 查看PDB信息

SQL> col name format a15SQL> set linesize 160SQL> col pdb_name format a15SQL> select con_id, dbid, guid, name , open_mode from v$pdbs;    CON_ID  DBID GUID          NAME        OPEN_MODE---------- ---------- -------------------------------- --------------- --------------------  3 3454107755 88EB774565FA4F12E0530B38A8C09990 PDB        READ WRITE

至此，本次12C-CDB容器数据库部署完成。