如何做团购网站中的美食地处地图功能,如何能进腾讯做游戏视频网站,套餐网站,嘉鱼网站建设上面左边是我的个人微信#xff0c;如需进一步沟通#xff0c;请加微信。 右边是我的公众号“Openstack私有云”#xff0c;如有兴趣#xff0c;请关注。继上次在PVE环境上搭建了oracle12C RAC环境(请参考博文“ProxmoxVE 之 安装oracle12C rac集群”)并且安装使用CDB和PD…上面左边是我的个人微信如需进一步沟通请加微信。 右边是我的公众号“Openstack私有云”如有兴趣请关注。继上次在PVE环境上搭建了oracle12C RAC环境(请参考博文“ProxmoxVE 之 安装oracle12C rac集群”)并且安装使用CDB和PDB(请参考博文“ProxmoxVE 之 安装oracle12C 数据库(CDB和PDB)”)之后继续往下深入在这个RAC环境中安装第二个CDB验证一个RAC环境下面使用多个CDB和PDB的复杂应用情况。使用oracle账号登录系统然后执行dbca进行安装这里选择中文字符集登录grid账号运行 crsctl stat res -t 检查rac状态看看新建的cdb2 数据库是否成功启动并opengridoraclenode2 ~]$ crsctl stat res -t--------------------------------------------------------------------------------Name Target State Server State details--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnrONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.DATA.dgONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.GRID.dgONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.LISTENER.lsnrONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.RECOVERY.dgONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.SYSTEM.dgONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.chadONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.net1.networkONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLEora.onsONLINE ONLINE oraclenode1 STABLEONLINE ONLINE oraclenode2 STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE oraclenode2 STABLEora.MGMTLSNR1 ONLINE ONLINE oraclenode2 169.254.210.79 192.168.170.33,STABLEora.asm1 ONLINE ONLINE oraclenode2 Started,STABLE2 ONLINE OFFLINE STABLE3 ONLINE ONLINE oraclenode1 Started,STABLEora.cdb2.db1 ONLINE ONLINE oraclenode1 Open,HOME/data/oracle/app/oracle/product/12.2.0.1/db_1,STABLE2 ONLINE ONLINE oraclenode2 Open,HOME/data/oracle/app/oracle/product/12.2.0.1/db_1,STABLEora.cvu1 ONLINE ONLINE oraclenode2 STABLEora.mgmtdb1 ONLINE ONLINE oraclenode2 Open,STABLEora.oraclenode1.vip1 ONLINE ONLINE oraclenode1 STABLEora.oraclenode2.vip1 ONLINE ONLINE oraclenode2 STABLEora.orcl.db1 ONLINE ONLINE oraclenode1 Open,HOME/data/oracle/app/oracle/product/12.2.0.1/db_1,STABLE2 ONLINE ONLINE oraclenode2 Open,HOME/data/oracle/app/oracle/product/12.2.0.1/db_1,STABLEora.qosmserver1 ONLINE ONLINE oraclenode2 STABLEora.scan1.vip1 ONLINE ONLINE oraclenode2 STABLE--------------------------------------------------------------------------------上面可以看到cdb2数据库也已经起来了。也就是说这个RAC集群上面同时运行了2个CDB数据库一个是orcl数据库一个是cdb2数据库实现了同时运行多个CDB数据库每个CDB内又可以运行多个PDB数据库这样可以实现比较复杂的业务场景。多个CDB数据库切换有了多个CDB如何在多个CDB中进行切换是通过切换环境变量ORACLE_UNQNAME和ORACLE_SID来实现#现在环境变量指向是orcl数据库CDB[oracleoraclenode1 ~]$[oracleoraclenode1 ~]$ env|grep ORAORACLE_UNQNAMEorclORACLE_SIDorcldb11ORACLE_BASE/data/oracle/app/oracleORACLE_HOSTNAMEoraclenode1ORACLE_TERMxtermORACLE_HOME/data/oracle/app/oracle/product/12.2.0.1/db_1[oracleoraclenode1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 17 09:48:24 2019Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL show con_name;CON_NAME------------------------------CDB$ROOTSQL quitDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production[oracleoraclenode1 ~]$#现在改变环境变量ORACLE_UNQNAME和ORACLE_SID改为指向cdb2。#注意ORACLE_SID需要指向你所在的rac数据库实例我这里的SID有2个一个是CDB21一个是CDB22需要根据实际环境进行设定[oracleoraclenode1 ~]$ export ORACLE_UNQNAMEcdb2[oracleoraclenode1 ~]$ ORACLE_SIDcdb21[oracleoraclenode1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 17 09:49:17 2019Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL show con_name;CON_NAME------------------------------CDB$ROOTSQL select con_id, dbid, guid, name , open_mode from v$pdbs;CON_ID DBID GUID---------- ---------- --------------------------------NAME--------------------------------------------------------------------------------OPEN_MODE----------2 1189951802 7F93FC28620574A8E0532001A8C0A08APDB$SEEDREAD ONLY3 3521891460 7F9433F3F69A1333E0532101A8C089D8CDB2_PDB1READ WRITECON_ID DBID GUID---------- ---------- --------------------------------NAME--------------------------------------------------------------------------------OPEN_MODE----------SQL quitDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production[oracleoraclenode1 ~]$总结oracle12C数据库上可以创建多个CDB每个CDB内可以创建多个PDB管理多个CDB可以通过切换不同的SID环境变量进行切换。如果是RAC环境数据库实例会同时运行在所有RAC节点上。多个CDB可以灵活使用asm磁盘组多个CDB可以共用asm磁盘组也可以单独使用磁盘组非常灵活。
