Some Oracle RAC 10gR2 and 11gR2 commands -
/u01/11.2.0/grid/bin/crsctl status resource -t
/u01/11.2.0/grid/bin/crs_stat -t
/u01/11.2.0/grid/bin/ocrconfig -showbackup
/u01/11.2.0/grid/bin/olsnodes -n
/u01/11.2.0/grid/bin/olsnodes -c
/u01/11.2.0/grid/bin/ocrcheck
srvctl status database -d orakle
srvctl status instance -d orakle -i "orakle1,orakle2"
srvctl status nodeapps
[oracle@dblcys033 ~]$ srvctl status database -d orakle
Instance orakle1 is running on node dblcys033
Instance orakle2 is running on node dblcys034
[oracle@dblcys033 ~]$
[oracle@dblcys033 ~]$ srvctl status instance -d orakle -i "orakle1,orakle2"
Instance orakle1 is running on node dblcys033
Instance orakle2 is running on node dblcys034
[oracle@dblcys033 ~]$
[oracle@dblcys033 ~]$ srvctl status nodeapps
VIP dblcys033-vip is enabled
VIP dblcys033-vip is running on node: dblcys033
VIP dblcys034-vip is enabled
VIP dblcys034-vip is running on node: dblcys034
Network is enabled
Network is running on node: dblcys033
Network is running on node: dblcys034
GSD is disabled
GSD is not running on node: dblcys033
GSD is not running on node: dblcys034
ONS is enabled
ONS daemon is running on node: dblcys033
ONS daemon is running on node: dblcys034
eONS is enabled
eONS daemon is running on node: dblcys033
eONS daemon is running on node: dblcys034
[oracle@dblcys033 ~]$
[oracle@dblcys033 bin]$ pwd
/u01/11.2.0/grid/bin
[oracle@dblcys033 bin]$ crsctl status resource -t
-bash: crsctl: command not found
[oracle@dblcys033 bin]$ ./crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.FLASH.dg
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.LISTENER.lsnr
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.OCR.dg
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.OCR2.dg
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.asm
ONLINE ONLINE dblcys033 Started
ONLINE ONLINE dblcys034 Started
ora.eons
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.gsd
OFFLINE OFFLINE dblcys033
OFFLINE OFFLINE dblcys034
ora.net1.network
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.ons
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
ora.registry.acfs
ONLINE ONLINE dblcys033
ONLINE ONLINE dblcys034
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE dblcys033
ora.orakle.db
1 ONLINE ONLINE dblcys033 Open
2 ONLINE ONLINE dblcys034 Open
ora.oc4j
1 OFFLINE OFFLINE
ora.dblcys033.vip
1 ONLINE ONLINE dblcys033
ora.dblcys034.vip
1 ONLINE ONLINE dblcys034
ora.scan1.vip
1 ONLINE ONLINE dblcys033
ora.spwebuni.db
1 ONLINE ONLINE dblcys033 Open
2 ONLINE ONLINE dblcys034 Open
[oracle@dblcys033 bin]$
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE db...s033
ora.FLASH.dg ora....up.type ONLINE ONLINE db...s033
ora....ER.lsnr ora....er.type ONLINE ONLINE db...s033
ora....N1.lsnr ora....er.type ONLINE ONLINE db...s033
ora.OCR.dg ora....up.type ONLINE ONLINE db...s033
ora.OCR2.dg ora....up.type ONLINE ONLINE db...s033
ora.asm ora.asm.type ONLINE ONLINE db...s033
ora.eons ora.eons.type ONLINE ONLINE db...s033
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora.orakle.db ora....se.type ONLINE ONLINE db...s033
ora....network ora....rk.type ONLINE ONLINE db...s033
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE db...s033
ora....33.lsnr application ONLINE ONLINE db...s033
ora....033.gsd application OFFLINE OFFLINE
ora....033.ons application ONLINE ONLINE db...s033
ora....033.vip ora....t1.type ONLINE ONLINE db...s033
ora....SM2.asm application ONLINE ONLINE db...s034
ora....34.lsnr application ONLINE ONLINE db...s034
ora....034.gsd application OFFLINE OFFLINE
ora....034.ons application ONLINE ONLINE db...s034
ora....034.vip ora....t1.type ONLINE ONLINE db...s034
ora.ons ora.ons.type ONLINE ONLINE db...s033
ora....ry.acfs ora....fs.type ONLINE ONLINE db...s033
ora.scan1.vip ora....ip.type ONLINE ONLINE db...s033
ora....buni.db ora....se.type ONLINE ONLINE db...s033
[oracle@dblcys033 ~]$
/u01/11.2.0/grid/bin/crsctl query css votedisk
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 48dbb58e2c4b4f87bf64705b5f35c4d7 (/dev/mapper/mpath16p1) [OCR2]
2. ONLINE 61ddb0f2a7844fb4bf7714877dd7e467 (/dev/mapper/mpath17p1) [OCR2]
3. ONLINE 9e885b6812fe4fa0bfd49bd87dcbbd49 (/dev/mapper/mpath18p1) [OCR2]
Located 3 voting disk(s).
[oracle@dblcys033 ~]$
/u01/11.2.0/grid/bin/crsctl check crs
/u01/11.2.0/grid/bin/crsctl check cluster
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oracle@dblcys033 ~]$
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oracle@dblcys033 ~]$
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/ocrconfig -showbackup
dblcys033 2012/03/09 14:17:43 /u01/11.2.0/grid/cdata/dblc-cluster/backup00.ocr
dblcys033 2012/03/09 10:17:42 /u01/11.2.0/grid/cdata/dblc-cluster/backup01.ocr
dblcys033 2012/03/09 06:17:41 /u01/11.2.0/grid/cdata/dblc-cluster/backup02.ocr
dblcys033 2012/03/08 02:17:33 /u01/11.2.0/grid/cdata/dblc-cluster/day.ocr
dblcys033 2012/02/27 02:16:33 /u01/11.2.0/grid/cdata/dblc-cluster/week.ocr
dblcys033 2011/03/08 09:58:50 /u01/11.2.0/grid/cdata/dblc-cluster/backup_20110308_095850.ocr
[oracle@dblcys033 ~]$
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/olsnodes -n
dblcys033 1
dblcys034 2
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/olsnodes -c
dblc-cluster
[oracle@dblcys033 ~]$ /u01/11.2.0/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2808
Available space (kbytes) : 259312
ID : 1223731229
Device/File Name : +ocr2
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
[oracle@dblcys033 ~]$
[oracle@dblcys033 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
#
# DCL, 17/11/2010 - Remove hostname from loopback address
#127.0.0.1 dblcys033 localhost.localdomain localhost
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
# DCL, 17/11/2010 - eth0 - Public Interface
10.130.128.33 dblcys033
10.130.128.34 dblcys034
10.130.130.39 dbltols062
10.130.130.41 dbltols066
# DCL, 17/11/2010 - VIP
10.130.128.168 dblcys033-vip
10.130.128.169 dblcys034-vip
# DCL, 18/11/2010 - SCAN - required during installation
10.130.128.170 dblc-scan
# DCL, 17/11/2010 - eth1 - Private Interface
192.168.1.33 dblcys033-priv
192.168.1.34 dblcys034-priv
## Netbackup Servers - Added 10-03-2011 pfv
10.130.128.175 NBUdbLTCMAST
10.130.128.59 NBUdbLTCMED1
10.130.130.175 NBUdbTC3MAST
10.130.130.59 NBUdbTC3MED1
## Temporary SFTP server name - pfv
#10.130.239.13 db-ftp-01 db-ftp-01.intra.db.local
#10.130.198.13 db-ftp-01 db-ftp-01.intra.db.local
#10.130.238.41 db-ftp-01 db-ftp-01.intra.db.local
10.130.238.42 db-ftp-01 db-ftp-01.intra.db.local
[oracle@dblcys033 ~]$
-------------------------------------------------
[oracle@dblcys033 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora.dblcys033 Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora.dblcys033
# Generated by Oracle configuration tools.
# DCL 24/11/2010 - Alias for spwebuni REMOTE_LISTENER
# DCL 24/11/2010 - Aliases for spwebuni LOCAL_LISTENER
LISTENERS_SPWEBUNI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys033)(PORT = 1521))
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys034)(PORT = 1521))
)
)
orakle_ORG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dblc-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orakle.db)
)
)
LISTENER_SPWEBUNI2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys034)(PORT = 1521))
)
LISTENER_SPWEBUNI1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys033)(PORT = 1521))
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys033)(PORT = 1900))
)
LISTENERS_orakle =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys033)(PORT = 1521))
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys034)(PORT = 1521))
)
)
orakle_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.130.38)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orakle.db)
)
)
LISTENER_orakle2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys034)(PORT = 1521))
)
LISTENER_orakle1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = dblcys033)(PORT = 1521))
(ADDRESS = (PROTOCOL = tcp)(HOSt = dblcys033)(PORT = 1900))
)
SPWEBUNI_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.130.38)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = spwebuni.ls.de)
)
)
orakle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys033-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys034-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orakle.db)
)
)
orakle1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys033)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orakle.db)
(INSTANCE_NAME = orakle1)
)
)
orakle2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys034)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orakle.db)
(INSTANCE_NAME = orakle2)
)
)
spwebuni =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys033-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys034-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = spwebuni.ls.de)
)
)
LISTENERS_LOCAL=
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys033-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys033-vip)(PORT = 1900))
)
+ASM1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dblcys033)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
(INSTANCE_NAME = +ASM1)
)
)
[oracle@dblcys033 ~]$
