how to verify the cluster status

login as root

clustat -i 3

then it will give us the below output

Cluster Status for MSCB-DC-CLUSTER @ Mon Feb 28 11:03:57 2011
Member Status: Quorate

 Member Name                                                     ID   Status
 —— —-                                                     —- ——
 MSCB-DC-DB01                                                        1 Online, Local, rgmanager
 MSCB-DC-DB02                                                        2 Online, rgmanager

 Service Name                                                     Owner (Last)                                                     State
 ——- —-                                                     —– ——                                                     —–
 service:MSCB-DC-SERVICE1                                         MSCB-DC-DB01                                                     started

how to change the define IP in linux

At command prompt type –  setup

Go to  – Network configuration

edit  – device

go to  – etho (etho) – Realtek semiconductor Co., Ltd

then hit enter and it will go to Devernet Configuration

Static Ip 172.100.151.46(here put the ip)
Netmask 255.255.255.0
default gateway Ip 172.100.151.1

then after saving all at command prompt

service network restart

then reboot there server

Steps to bring up the database automatically once linux server reboot

When linux server will reboot it will run the file called dbora

 [oracle@MSCB-DC-TESTDB ~]$ cat /etc/init.d/dbora

 ### Database MSCBPROD ###

nohup sh /etc/init.d/testing.sh >> /etc/init.d/testtt.log 2>&1 &

export ORACLE_SID=MSCBPROD

export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH:.

cd $ORACLE_HOME/bin lsnrctl

 start sqlplus sys/oracle as sysdba <

spool /oracle/app/oracle/product/11.2.0/db_1/sqlplus_ms.log

startup

exit