和狗狗做电影网站,企业网站开发的目的,做花茶网站解说,企业培训考试系统题库RAC监听日志#xff1a;tnsname.oraCRS日志#xff1a;位置#xff1a;Oracle集群涉及的日志主要位于“$ORA_CRS_HOME/log”和“$ORACLE_HOME/log”目录中目录结构#xff1a;tree -d $ORA_CRS_HOME/logtree -d $ORACLE_HOME/log禁止Clusterware在系统重启后自动启动#…RAC监听日志tnsname.oraCRS日志位置Oracle集群涉及的日志主要位于“$ORA_CRS_HOME/log”和“$ORACLE_HOME/log”目录中目录结构tree -d $ORA_CRS_HOME/logtree -d $ORACLE_HOME/log禁止Clusterware在系统重启后自动启动/etc/init.d/init.crs disable让Clusterware在系统重启后自动启动: /etc/init.d/init.crs enable启动CRS;crsctl start crs关闭CRScrsctl stop crs检查CRS状态RAC1 AND RAC2: crsctl check crs启动数据库$srvctl start nodeapps -n rac1$srvctl start nodeapps -n rac2$srvctl start asm -n rac1$srvctl start asm -n rac2$srvctl start instance -d racdb -i racdb1$srvctl start instance -d racdb -i racdb2oracle rac crs格式ora.hostname.ASM2.asm节点1格式ora.hostname.ASM1.asm)Attempting to stop ora.node2.ASM2.asm on member node2Stop of ora.node2.ASM2.asm on member node2 succeeded.node2- crs_start ora.node2.ASM2.asmAttempting to start ora.node2.ASM2.asm on member node2Start of ora.node2.ASM2.asm on member node2 succeeded.2、--单独启动和关闭节点node2的gsdcrs_stop ora.node2.gsd (格式ora.hostname.gsd)crs_start ora.node2.gsd3、--单独启动和关闭节点node2的onscrs_stop ora.node2.ons (格式:ora.hostname.ons)crs_start ora.node2.ons4.单独启动vipcrs_stop ora.node2.vip(格式ora.hostname.vip)crs_start ora.node2.vip5.单独启动实例(inst)crs_stop ora.racdb.racdb2.inst (格式ora.db_name.instance_name.inst)crs_start ora.racdb.racdb2.inst6.单独启动监听(lsnr)crs_stop ora.node1.LISTENER_NODE1.lsnr (格式ora.hostname.listener_name.lsnr)crs_start ora.node1.LISTENER_NODE1.lsnr#查看crs的资源是否起来node1- crs_stat -tName Type Target State Host------------------------------------------------------------ora....SM1.asm application ONLINE ONLINE node1ora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application ONLINE ONLINE node2ora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2ora.racdb.db application ONLINE ONLINE node1ora....b1.inst application ONLINE ONLINE node1ora....b2.inst application ONLINE ONLINE node2*********显示resource信息*******node2- srvctl config databaseracdbnode2- srvctl config database -d racdb -tnode2- srvctl config nodeapps -n node2node2 racdb2 /opt/ora10g/product/10.2.0/db_1# display VIP configurationnode2- srvctl config nodeapps -n node2 -aVIP exists.: /node2-vip/192.168.0.202/255.255.255.0/eth0# display GSD configurationnode2- srvctl config nodeapps -n node2 -gGSD exists.# display OSD configurationnode2- srvctl config nodeapps -n node2 -sONS daemon exists.# display Listener configurationnode2- srvctl config nodeapps -n node2 -lListener exists.#display database statusnode2- srvctl status database -d racdbInstance racdb1 is running on node node1Instance racdb2 is running on node node2node2-#查看Voting Disk位置node2- crsctl query css votedisk0. 0 /dev/raw/raw1located 1 votedisk(s).查看OCR存放路径cat /etc/oracle/ocr.loc#显示节点2application状态node2- srvctl status nodeapps -n node2VIP is running on node: node2GSD is running on node: node2Listener is running on node: node2ONS daemon is running on node: node2#显示节点2asm状态node2- srvctl status asm -n node1ASM instance ASM1 is running on node node1.node2- srvctl status asm -n node2ASM instance ASM2 is running on node node2.node2- srvctl status nodeapps -n node1VIP is running on node: node1GSD is running on node: node1Listener is running on node: node1ONS daemon is running on node: node1OCR的状态验证node2- ocrcheckStatus of Oracle Cluster Registry is as follows :Version : 2Total space (kbytes) : 524184Used space (kbytes) : 3796Available space (kbytes) : 520388ID : 1474691778Device/File Name : /dev/raw/raw2Device/File integrity check succeededDevice/File not configuredCluster registry integrity check succeeded#查看crs是否启动$ crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy关闭crs资源# cd $ORA_CRS_HOME/bin# ./crsctl stop crs启动crs资源# cd $ORA_CRS_HOME/bin# ./crsctl start crs#查看/启动/关闭数据库实例srvctl status|stop|start instance -d [db_name] -i [inst_name]srvctl status|stop|start database -d [db_name]egnode2- srvctl status database -d racdbInstance racdb1 is running on node node1Instance racdb2 is running on node node2#启动/查看/关闭asm实例srvctl status|stop|start asm -n [node_name]eg:node2- srvctl status asm -n node1ASM instance ASM1 is running on node node1.node2- srvctl status asm -n node2ASM instance ASM2 is running on node node2.#启动/查看/关闭nodeapps资源node2- srvctl status nodeapps -n node2VIP is running on node: node2GSD is running on node: node2Listener is running on node: node2ONS daemon is running on node: node2
