SLB Test

wget https://dvgrdslb.cns.com:1159/em/upload --no-check-certificate
wget http://dvgrdslb.cns.com:4889/em

srvctl command

To Stop racprod2 Instance DB
Go to ORACLE_HOME/bin
./srvctl stop instance -d prod360c -i prod360c2 -o immediate
Go to ASM_HOME/bin
./srvctl stop asm -n racprod2
Go to CRS_HOME/bin
./srvctl stop nodeapps -n racprod2


./crs_stat -t


To Start ravprod2 Instance DB

Go to CRS_HOME/bin
./srvctl start nodeapps -n racprod2
Go to ASM?HOME/bin
./srvctl start asm -n racprod2
go to ORACLE_HOME/bin
./srvctl start instance -d prod360c -i prod360c2
To Display Current Database configuration in Cluster
======================================
./srvctl config database -d dev360c -a
To add Database in cluster
====================
./srvctl add database -d prdsb -o oracle-home_path -s MOUNT
To Add Instance in Cluster
===================
./srvctl add instance -d prdsb -i prdsb1 -n crlap00001
./srvctl add instance -d prdsb -i prdsb2 -n crlap00002
To check cluster status for Database
==========================
./srvctl status database -d prdsb
To remove Databse from Cluster
=======================
./srvctl remove database -d qa360c
Modify Srvctl setting for registered Database
====================================
./srvctl modify database -d dev360c -s open
To display Registered Database in srvctl
===============================
srvctl config database

To Display Status of Database or Nodeapps
===============================
srvctl status database -d dev360c
srvctl status nodeapps -n racdev1
To get Help on srvctl command option
===========================
srvctl modify database -h
Start CRS on 10g R2
===================
As root
#$ORA_CRS_HOME/bin/crsctl start crs
Stop CRS on 10g R2
===================
As root
#$ORA_CRS_HOME/bin/crsctl stop crs
Check Status of CRS
===================
$ORA_CRS_HOME/bin/crsctl check crs
Disable CRS to start @Server Reboot
============================
As root
#$ORA_CRS_HOME/bin/crsctl disable crs
Enable CRS to start @Server Reboot
============================
As root
#$ORA_CRS_HOME/bin/crsctl enable crs
To check CRS Version
===================
./crsctl query crs softwareversion
./crsctl query crs activeversion
To check Nodes in CRS
=======================
./olsnodes -n
To Print Cluster Name
================
./cemutlo -n
To Check OCR health and statistics
===========================
./ocrcheck
To Check OCR backup Information
===========================
./ocrconfig -showbackup

To List Voting Disk being used
======================
./crsctl query css votedisk


To Create Service
================
srvctl add service -d RJQ -s JC36_HNAPQ00046 -r RJQ001 -a RJQ002
To Start Service
================
srvctl start service -d RJQ -s JC36_HNAPQ00046
To Display Configuration of Service
=========================
srvctl config service -d RJQ
Misc SQL for checking SERVICE properties
=================================
select name,service_id from dba_services where name = 'server_taf';
select name, failover_method, failover_type, failover_retries,goal, clb_goal,aq_ha_notifications
from dba_services where service_id = 6



./clscfg -concepts
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
clscfg -- concepts and terminology
Private Interconnect Name
On most clusters an interconnect will be supplied that is only
accessible within the cluster. It will generally have a non-routable
IP sequence such as 10.x.x.x, 172.16.x.x, or 192.168.x.x. (RFC1918)
Specifying that IP is sufficient for clscfg's purposes, however an
alternate practice is to specify a name in the hosts file or in the
nameserver which resolves to these IPs, configure the name, and then
if the need arises, change the mappings with all machines down or in
maintenance mode. Any such change must be performed while the
Oracle instances and Cluster Ready Service daemons are down on all
machines of the cluster. ifconfig (or ipconfig on Windows) can be
used to look up information about or configure interconnects.
Omitting the private interconnect and using the public network may
result in poor performance and instability of the cluster.
Host Names
The hostname will be used to refer to the machine in remote
management tools, a few logfiles, and some other places. It should
be the same name returned by /bin/hostname or on Windows by
"echo %COMPUTERNAME%" at the command prompt.
Node Names
If another vendor's clustering software is installed, the nodenames
should be obtained from their configuration. Otherwise, it is best to
use the hostnames.
Voting Disk
The voting disk specified should be a raw device or file on a
cluster filesystem. NFS is generally not acceptable because it may
cache reads and writes. It will be used by the CSS daemon to arbitrate
with peers that it cannot see over the private interconnect in the
event of an outage, allowing it to salvage the largest fully connected
subcluster for further operation.
OCSSD (Cluster Synchronization Service)
Monitors node health through any vendor clusterware, or in its
absence makes its own determination. Provides notifications to
Oracle instances about each other, and notifies CRSD and EVMD of
the health of the cluster.
EVMD (Cluster Event Manager)
Provides local and cluster-wide event notification systems for Oracle
applications.
CRSD (Cluster Ready Service)
Provides application and Oracle instance failover using OCSSD and
EVMD.
OCR (Oracle Cluster Repository)
Stores configuration information for CRS daemons and Oracle
managability applications.
BlackOuts
===========
To start an immediate blackout called "bk3" for all targets on the host:
$PROMPT> emctl start blackout bk3 -nodeLevel

To stop blackout "bk2" immediately:
$PROMPT> emctl stop blackout bk2