Copied-RAC Get Full Name of crs_stat resource
#!/usr/bin/ksh## Sample 10g CRS resource status query script## Description:# - Returns formatted version of crs_stat -t, in tabular# format, with the complete rsc...
RAC use Service to Separate Business Connection
1 DB ENV---------------------------------------OS: Linux 5DB: 10.2.0.5SID: gtsjk1,gtsjk2-----------------------10.148.63.114 gtdb-r110.148.63.115 gtdb-r1-vip172.148.19.114 ...
How to Change RAC Public IP and VIP
1 DB env---------------------------------------------------OS: Linux 5DB: 10G----------------Old IP  ...
TS - ASM Storage Migration Cause APP Performance issue Handle
<style.v\:* {behavior.:url(#default#VML);}o\:* {behavior.:url(#default#VML);}w\:* {behavior.:url(#default#VML);}.shape {behavior.:url(#default#VML);}</style.一、概述故障简述:应...
Add a Node to an Existing Oracle RAC 10g R2 Cluster on Linux - (RHEL 5.4)
Contents Overview Hardware and Costs Install the Linux Operating System Install Required Linux Packages for Oracle RAC Network Configuration Configure Network Securi...
Linux 10gR2 Change Public IP and VIP
Change Public IP and VIP================Env=============old IP New IP192.168.181.11&nb...
Linux 10gR2 Delete Nodes
Linux oracle 10gR2 deleting nodes completely+++++++++++++++++Env+++++++++++++++++Host: node1 192.168.24.11 node2 192.168.24.12DB name: racInstance: rac1/rac2&...
Oracle RAC Useful Command and Tools
Oracle 的管理可以通过OEM或者命令行接口。 Oracle Clusterware的命令集可以分为以下4种:节点层:osnodes网络层:oifcfg集群层:crsctl, ocrcheck,ocrdump,ocrconfig应用层:srvctl,onsctl...
Script for full display RAC Name Column of crs_stat -Copied
crs_stat 命令在显示上比srvctl 直观。 先查询一下: [oracle@rac1 u01]$ crs_stat -t Name Type  ...
Oracle RAC Start and Stop -Copied
一. 检查共享设备一般情况下, 存放OCR 和 Voting Disk 的OCFS2 或者raw 都是自动启动的。 如果他们没有启动,RAC 肯定是启动不了的。 1.1 ...
Function of 4 script during RAC installation-Copied
RAC安装时需要执行4个脚本1) $ORACLE_BASE/oraInventory/orainstRoot.sh (clusterware 结束时执行)2) $CRS_HOME/root.sh (clusterware 结束时执行)3) $CRS_HOME/bin/vipca.sh...
Oracle 10g RAC basic maintenance command
所有实例和服务的状态$ srvctl status database -d orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2单个实例的状态$ srvctl status instance -d orcl -i orcl2Instance o...