Oracle 11g RAC + DG安装详解–02

节点1[root@TRAC1 rpm]# rpm -ivh tigervnc-server1.1.0-24.el6.x86_64.rpmwarning: tigervnc-server-1.1.0-24.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEYPreparing… ########################################### [100%] 1:tigervnc-server ########################################### [100%][root@TRAC1 rpm]#
节点1[root@TRAC1 software]# unzip p13390677_112040_Linux-x86-64_3of7.zip
修改cvu_config[root@TRAC1 grid]# sed -i ‘s/CV_ASSUME_DISTID=OEL4/CV_ASSUME_DISTID=OEL6/’ /home/software/grid/stage/cvu/cv/admin/cvu_config
节点2[root@TRAC2 software]# unzip p13390677_112040_Linux-x86-64_3of7.zip
修改cvu_config[root@TRAC2 grid]# sed -i ‘s/CV_ASSUME_DISTID=OEL4/CV_ASSUME_DISTID=OEL6/’ /home/software/grid/stage/cvu/cv/admin/cvu_configcd /home/software/grid/rpm/rpm -ivh cvuqdisk-1.0.9-1.rpm
节点1
启动vncserver[root@TRAC1 grid]# su – grid[grid@TRAC1 ~]$ vncserverYou will require a password to access your desktops.Password:Verify:xauth: file /home/grid/.Xauthority does not existNew ‘TRAC1:1 (grid)’ desktop is TRAC1:1Creating default startup script /home/grid/.vnc/xstartupStarting applications specified in /home/grid/.vnc/xst免费云主机域名artupLog file is /home/grid/.vnc/TRAC1:1.log[grid@TRAC1 ~]$[grid@TRAC1 grid]$ cd /home/software/grid/[grid@TRAC1 grid]$ lsinstall readme.html response rpm runcluvfy.sh runInstaller sshsetup stage welcome.html[grid@TRAC1 grid]$ ./runInstaller

节点1[root@TRAC1 /]# /home/app/grid/oraInventory/orainstRoot.shChanging permissions of /home/app/grid/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /home/app/grid/oraInventory to oinstall.The execution of the script is complete.
节点2[root@TRAC2 ~]# /home/app/grid/oraInventory/orainstRoot.shChanging permissions of /home/app/grid/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /home/app/grid/oraInventory to oinstall.The execution of the script is complete.
节点1[root@TRAC1 /]# /home/app/grid/crs/root.shPerforming root user operation for Oracle 11gThe following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /home/app/grid/crsEnter the full pathname of the local bin directory: [/usr/local/bin]:The contents of “dbhome” have not changed. No need to overwrite.The contents of “oraenv” have not changed. No need to overwrite.The contents of “coraenv” have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /home/app/grid/crs/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerOLR initialization – successful root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert TP profile reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa cert TP profile reader peer cert TP peer user cert pa user certAdding Clusterware entries to upstartCRS-2672: Attempting to start ‘ora.mdnsd’ on ‘TRAC1’CRS-2676: Start of ‘ora.mdnsd’ on ‘TRAC1’ succeededCRS-2672: Attempting to start ‘ora.gpnpd’ on ‘TRAC1’CRS-2676: Start of ‘ora.gpnpd’ on ‘TRAC1’ succeededCRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘TRAC1’CRS-2672: Attempting to start ‘ora.gipcd’ on ‘TRAC1’CRS-2676: Start of ‘ora.cssdmonitor’ on ‘TRAC1’ succeededCRS-2676: Start of ‘ora.gipcd’ on ‘TRAC1’ succeededCRS-2672: Attempting to start ‘ora.cssd’ on ‘TRAC1’CRS-2672: Attempting to start ‘ora.diskmon’ on ‘TRAC1’CRS-2676: Start of ‘ora.diskmon’ on ‘TRAC1’ succeededCRS-2676: Start of ‘ora.cssd’ on ‘TRAC1’ succeededASM created and started successfully.Disk Group VOT created successfully.clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user ‘root’, privgrp ‘root’..Operation successful.CRS-4256: Updating the profileSuccessful addition of voting disk 2458bdc83f4e4f5cbfc3a4942a2096c3.Successful addition of voting disk 72d50e2a50994f64bfbab3bfcfec8c08.Successful addition of voting disk 04df90281c1f4f38bfd6a234f8d17244.Successfully replaced voting disk group with +VOT.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced## STATE File Universal Id File Name Disk group– —– —————– ——— ———1. ONLINE 2458bdc83f4e4f5cbfc3a4942a2096c3 (/data/oradata/votdisk6) [VOT]2. ONLINE 72d50e2a50994f64bfbab3bfcfec8c08 (/data/oradata/votdisk5) [VOT]3. ONLINE 04df90281c1f4f38bfd6a234f8d17244 (/data/oradata/votdisk4) [VOT]Located 3 voting disk(s).CRS-2672: Attempting to start ‘ora.asm’ on ‘TRAC1’CRS-2676: Start of ‘ora.asm’ on ‘TRAC1’ succeededCRS-2672: Attempting to start ‘ora.VOT.dg’ on ‘TRAC1’CRS-2676: Start of ‘ora.VOT.dg’ on ‘TRAC1’ succeededConfigure Oracle Grid Infrastructure for a Cluster … succeeded
节点2[root@TRAC2 ~]# /home/app/grid/crs/root.shPerforming root user operation for Oracle 11gThe following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /home/app/grid/crsEnter the full pathname of the local bin directory: [/usr/local/bin]:The contents of “dbhome” have not changed. No need to overwrite.The contents of “oraenv” have not changed. No need to overwrite.The contents of “coraenv” have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /home/app/grid/crs/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationInstalling Trace File AnalyzerOLR initialization – successfulAdding Clusterware entries to upstartCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node TRAC1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clusterConfigure Oracle Grid Infrastructure for a Cluster … succeeded

节点1[grid@TRAC1 ~]$ crs_stat -tName Type Target State Host————————————————————ora….ER.lsnr ora….er.type ONLINE ONLINE TRAC1ora….N1.lsnr ora….er.type ONLINE ONLINE TRAC1ora.VOT.dg ora….up.type ONLINE ONLINE TRAC1ora.asm ora.asm.type ONLINE ONLINE TRAC1ora.cvu ora.cvu.type ONLINE ONLINE TRAC1ora.gsd ora.gsd.type OFFLINE OFFLINE ora….network ora….rk.type ONLINE ONLINE TRAC1ora.oc4j ora.oc4j.type ONLINE ONLINE TRAC1ora.ons ora.ons.type ONLINE ONLINE TRAC1ora.scan1.vip ora….ip.type ONLINE ONLINE TRAC1ora….SM1.asm application ONLINE ONLINE TRAC1ora….C1.lsnr application ONLINE ONLINE TRAC1ora….ac1.gsd application OFFLINE OFFLINEora….ac1.ons application ONLINE ONLINE TRAC1ora….ac1.vip ora….t1.type ONLINE ONLINE TRAC1ora….SM2.asm application ONLINE ONLINE TRAC2ora….C2.lsnr application ONLINE ONLINE TRAC2ora….ac2.gsd application OFFLINE OFFLINEora….ac2.ons application ONLINE ONLINE TRAC2ora….ac2.vip ora….t1.type ONLINE ONLINE TRAC2
节点2[grid@TRAC2 ~]$ crs_stat -tName Type Target State Host————————————————————ora….ER.lsnr ora….er.type ONLINE ONLINE TRAC1ora….N1.lsnr ora….er.type ONLINE ONLINE TRAC1ora.VOT.dg ora….up.type ONLINE ONLINE TRAC1ora.asm ora.asm.type ONLINE ONLINE TRAC1ora.cvu ora.cvu.type ONLINE ONLINE TRAC1ora.gsd ora.gsd.type OFFLINE OFFLINEora….network ora….rk.type ONLINE ONLINE TRAC1ora.oc4j ora.oc4j.type ONLINE ONLINE TRAC1ora.ons ora.ons.type ONLINE ONLINE TRAC1ora.scan1.vip ora….ip.type ONLINE ONLINE TRAC1ora….SM1.asm application ONLINE ONLINE TRAC1ora….C1.lsnr application ONLINE ONLINE TRAC1ora….ac1.gsd application OFFLINE OFFLINE ora….ac1.ons application ONLINE ONLINE TRAC1ora….ac1.vip ora….t1.type ONLINE ONLINE TRAC1ora….SM2.asm application ONLINE ONLINE TRAC2ora….C2.lsnr application ONLINE ONLINE TRAC2ora….ac2.gsd application OFFLINE OFFLINEora….ac2.ons application ONLINE ONLINE TRAC2ora….ac2.vip ora….t1.type ONLINE ONLINE TRAC2[grid@TRAC1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 19 12:09:47 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> select ksppinm as “hidden parameter”, ksppstvl as “value” from x$ksppi join x$ksppcv using (indx) where ksppinm like ‘_%’ escape ” and ksppinm like ‘%asm_hb%’ order by ksppinm;hidden parameter——————————————————————————–value——————————————————————————–_asm_hbeatiowait15_asm_hbeatwaitquantum2SQL> alter system set “_asm_hbeatiowait”=120 sid=’*’ scope=spfile;
重启asm
和数据库

相关推荐: SQLServer的检查点、redo和undo

SQLServer的检查点、redo和undo 检查点与恢复效率的关系 检查点将脏数据页从当前数据库的缓冲区高速缓存刷新到磁盘上。 这最大限度地减少了恢复时必须重做（Redo）的修改量。 为什么在日志文件中设置了检查点之后，基于日志的恢复机制就可以提高效率了呢…