Basic operation of Oracle 11g RAC (i)------start-up and shutdown

• Start RAC

The manual start is initiated in the order of has, cluster, database, with the following specific commands:

• Start has (high availability Services), must be the root user

[Email protected] ~]# Crsctl start has
Crs-4124:oracle High Availability Services startup failed.
Crs-4000:command Start failed, or completed with errors.

The cause of the error is due to a bug in 11g, reopen a window to execute/BIN/DD if=/var/tmp/.oracle/npohasd f=/dev/null bs=1024 count=1
[Email protected] ~]# Crsctl start has
Crs-4640:oracle High Availability Services is already active
Crs-4000:command Start failed, or completed with errors.

The above has start command needs to be executed on each node separately

• Launch Cluster (cluster)

[[email protected] ~]# crsctl start Cluster-all-all nodes start at the same time
Crs-5702:resource ' ORA.EVMD ' is already running on ' orcl-1 '
Crs-5702:resource ' ORA.CRSD ' is already running on ' orcl-1 '

or only the specified node is started.
[[email protected] ~]#./crsctl start Cluster-n orcl1 Orcl2--Two nodes start at the same time

• Start the database (the database name is ORCL):

[[email protected] ~]# srvctl start database-d ORCL---Start an instance on all nodes
PRCC-1014:ORCL was already running

Or, each node logs on to the database and then executes

Sql>startup

[[email protected] ~]# SRVCTL status ASM---view ASM State
ASM is running on Orcl-1,orcl-2

[[email protected] ~]# CRS_STAT-T-V---View cluster resource status (OC4J, GSD default service is disabled)
Name Type r/ra f/ft Target State Host
----------------------------------------------------------------------
Ora. FRA.DG ora....up.type 0/5 0/online ONLINE orcl-1
Ora .... Er.lsnr ora....er.type 0/5 0/online ONLINE orcl-1
Ora .... N1.lsnr ora....er.type 0/5 0/0 Online online orcl-1
Ora. OCR.DG ora....up.type 0/5 0/online ONLINE orcl-1
Ora. RACDB.DG ora....up.type 0/5 0/online ONLINE orcl-1
Ora .... DISK.DG ora....up.type 0/5 0/online ONLINE orcl-1
Ora.asm ora.asm.type 0/5 0/online ONLINE orcl-1
Ora.eons ora.eons.type 0/3 0/online ONLINE orcl-1
ORA.GSD ora.gsd.type 0/5 0/offline OFFLINE
Ora....network ora....rk.type 0/5 0/online ONLINE orcl-1
ora.oc4j ora.oc4j.type 0/5 0/0 OFFLINE OFFLINE
Ora.ons ora.ons.type 0/3 0/online ONLINE orcl-1
Ora .... SM1.ASM application 0/5 0/0 online online orcl-1
Ora....-1.lsnr application 0/5 0/0 online online orcl-1
ORA.ORCL-1.GSD application 0/5 0/0 OFFLINE OFFLINE
Ora.orcl-1.ons application 0/3 0/0 online online orcl-1
ORA.ORCL-1.VIP ora....t1.type 0/0 0/0 Online online orcl-1
Ora .... SM2.ASM application 0/5 0/0 online online orcl-2
Ora....-2.lsnr application 0/5 0/0 online online orcl-2
ORA.ORCL-2.GSD application 0/5 0/0 OFFLINE OFFLINE
Ora.orcl-2.ons application 0/3 0/0 online online orcl-2
ORA.ORCL-2.VIP ora....t1.type 0/0 0/0 Online online orcl-2
Ora.orcl.db ora....se.type 0/2 0/1 Online online orcl-1
ORA.SCAN1.VIP ora....ip.type 0/0 0/0 Online online orcl-1

[[email protected] ~]# srvctl status database-d ORCL---Check database status
Instance ORCL1 is running on node orcl-1
Instance Orcl2 is running on node Orcl-2

[[email protected] ~]# srvctl status Nodeapps---check node status
VIP ORCL-1-VIP is enabled
VIP Orcl-1-vip is running on NODE:ORCL-1
VIP ORCL-2-VIP is enabled
VIP Orcl-2-vip is running on Node:orcl-2
Network is enabled
Network is running on NODE:ORCL-1
Network is running on Node:orcl-2
GSD is disabled
GSD isn't running on node:orcl-1
GSD isn't running on Node:orcl-2
ONS is enabled
ONS Daemon is running on NODE:ORCL-1
ONS Daemon is running on Node:orcl-2
EONS is enabled
EONS Daemon is running on NODE:ORCL-1
EONS Daemon is running on Node:orcl-2

Votedisk Check (grid user)

[Email protected] ~]# crsctl query CSS Votedisk
# # state file Universal Id file Name Disk Group
--  -----    -----------------                --------- ---------
1. ONLINE 786F6BDA41FF4FB8BF2B3E17FD7302C9 (/DEV/ASM-DISK-MPATHG) [OCR]
2. ONLINE 8b5315974e484f30bff0eb3f2dfaa443 (/DEV/ASM-DISK-MPATHH) [OCR]
3. ONLINE 394cd132329b4f39bf57dc8322e359c2 (/dev/asm-disk-mpathi) [OCR]
4. ONLINE 561d06ffcb3e4fe5bf2b896422a8b5cc (/DEV/ASM-DISK-MPATHJ) [OCR]
Located 4 voting disk (s).

[Email protected] ~]$ Ocrcheck
Status of Oracle Cluster Registry is as follows:
Version:3
Total Space (Kbytes): 262120
Used Space (Kbytes): 2588
Available Space (Kbytes): 259532
id:2021652580
Device/file Name: +OCR
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

Turn off RAC

Shut down the database (Oracle user)

[[email protected] ~]$ srvctl stop database-d ORCL---Stopping instances on all nodes
[[email protected] ~]$ srvctl status database-d ORCL---View db instance status
Instance ORCL1 is not running on node orcl-1
Instance Orcl2 is not running on node Orcl-2

Or, after each node logs on to the database, executes sql>shutdown immediate

To stop the Cluster service, the root user must be

[Email protected] ~]# Crsctl stop Cluster-all
Crs-2673:attempting to stop ' ora.crsd ' on ' orcl-2 '
crs-2790:starting shutdown of Cluster ready services-managed resources on ' Orcl-2 '
crs-2673:attempting to stop ' Ora. Ocr.dg ' on ' orcl-2 '
crs-2673:attempting to stop ' Ora. Fra.dg ' on ' orcl-2 '
crs-2673:attempting to stop ' Ora. Racdb.dg ' on ' orcl-2 '
crs-2673:attempting to stop ' Ora. Listener.lsnr ' on ' orcl-2 '
Crs-2673:attempting to stop ' ora.crsd ' on ' orcl-1 '
Crs-2677:stop of ' Ora. Listener.lsnr ' on ' Orcl-2 ' succeeded
Crs-2673:attempting to stop ' ora.orcl-2.vip ' on ' orcl-2 '
Crs-2677:stop of ' ora.orcl-2.vip ' on ' Orcl-2 ' succeeded
crs-2790:starting shutdown of Cluster ready services-managed resources on ' orcl-1 '
crs-2673:attempting to stop ' Ora. Ocr.dg ' on ' orcl-1 '
crs-2673:attempting to stop ' Ora. Voting_disk.dg ' on ' orcl-1 '
crs-2673:attempting to stop ' Ora. Fra.dg ' on ' orcl-1 '
crs-2673:attempting to stop ' Ora. Racdb.dg ' on ' orcl-1 '
crs-2673:attempting to stop ' Ora. Listener.lsnr ' on ' orcl-1 '
crs-2673:attempting to stop ' Ora. Listener_scan1.lsnr ' on ' orcl-1 '
Crs-2677:stop of ' Ora. Listener.lsnr ' on ' orcl-1 ' succeeded
Crs-2673:attempting to stop ' ora.orcl-1.vip ' on ' orcl-1 '
Crs-2677:stop of ' Ora. Listener_scan1.lsnr ' on ' orcl-1 ' succeeded
Crs-2673:attempting to stop ' ora.scan1.vip ' on ' orcl-1 '
Crs-2677:stop of ' ora.orcl-1.vip ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' ora.scan1.vip ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' Ora. Ocr.dg ' on ' Orcl-2 ' succeeded
Crs-2677:stop of ' Ora. Fra.dg ' on ' Orcl-2 ' succeeded
Crs-2677:stop of ' Ora. Ocr.dg ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' Ora. Fra.dg ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' Ora. Racdb.dg ' on ' Orcl-2 ' succeeded
Crs-2673:attempting to stop ' ora.asm ' on ' orcl-2 '
Crs-2677:stop of ' Ora. Voting_disk.dg ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' ora.asm ' on ' Orcl-2 ' succeeded
Crs-2673:attempting to stop ' ora.ons ' on ' orcl-2 '
Crs-2673:attempting to stop ' ora.eons ' on ' orcl-2 '
Crs-2677:stop of ' Ora. Racdb.dg ' on ' orcl-1 ' succeeded
Crs-2673:attempting to stop ' ora.asm ' on ' orcl-1 '
Crs-2677:stop of ' ora.asm ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' ora.ons ' on ' Orcl-2 ' succeeded
Crs-2673:attempting to stop ' ora.net1.network ' on ' orcl-2 '
Crs-2677:stop of ' ora.net1.network ' on ' Orcl-2 ' succeeded
Crs-2677:stop of ' ora.eons ' on ' Orcl-2 ' succeeded
Crs-2792:shutdown of Cluster Ready services-managed resources on ' orcl-2 ' have completed
Crs-2673:attempting to stop ' ora.ons ' on ' orcl-1 '
Crs-2673:attempting to stop ' ora.eons ' on ' orcl-1 '
Crs-2677:stop of ' ora.crsd ' on ' Orcl-2 ' succeeded
Crs-2673:attempting to stop ' ora.cssdmonitor ' on ' orcl-2 '
Crs-2673:attempting to stop ' ora.ctssd ' on ' orcl-2 '
Crs-2673:attempting to stop ' ora.evmd ' on ' orcl-2 '
Crs-2673:attempting to stop ' ora.asm ' on ' orcl-2 '
Crs-2677:stop of ' ora.cssdmonitor ' on ' Orcl-2 ' succeeded
Crs-2677:stop of ' ora.ons ' on ' orcl-1 ' succeeded
Crs-2673:attempting to stop ' ora.net1.network ' on ' orcl-1 '
Crs-2677:stop of ' ora.net1.network ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' ora.evmd ' on ' Orcl-2 ' succeeded
Crs-2677:stop of ' ora.eons ' on ' orcl-1 ' succeeded
Crs-2792:shutdown of Cluster Ready services-managed resources on ' orcl-1 ' have completed
Crs-2677:stop of ' ora.crsd ' on ' orcl-1 ' succeeded
Crs-2673:attempting to stop ' ora.cssdmonitor ' on ' orcl-1 '
Crs-2673:attempting to stop ' ora.ctssd ' on ' orcl-1 '
Crs-2673:attempting to stop ' ora.evmd ' on ' orcl-1 '
Crs-2673:attempting to stop ' ora.asm ' on ' orcl-1 '
Crs-2677:stop of ' ora.cssdmonitor ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' ora.evmd ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' ora.asm ' on ' Orcl-2 ' succeeded
Crs-2677:stop of ' ora.ctssd ' on ' Orcl-2 ' succeeded
Crs-2673:attempting to stop ' ora.cssd ' on ' orcl-2 '
Crs-2677:stop of ' ora.ctssd ' on ' orcl-1 ' succeeded
Crs-2677:stop of ' ora.cssd ' on ' Orcl-2 ' succeeded
Crs-2673:attempting to stop ' Ora.diskmon ' on ' orcl-2 '
Crs-2677:stop of ' ora.asm ' on ' orcl-1 ' succeeded
Crs-2673:attempting to stop ' ora.cssd ' on ' orcl-1 '
Crs-2677:stop of ' ora.cssd ' on ' orcl-1 ' succeeded
Crs-2673:attempting to stop ' Ora.diskmon ' on ' orcl-1 '
Crs-2677:stop of ' Ora.diskmon ' on ' Orcl-2 ' succeeded
Crs-2677:stop of ' Ora.diskmon ' on ' orcl-1 ' succeeded

or each node executes separately

[[Email protected]]# crsctl Stop cluster----Stop this node Cluster service,

You can also specify a stop node:

[[email protected]]#./crsctl Stop Cluster-n ORCL1 Orcl2

[[email protected] ~]# CRSCTL config CRS
Crs-4622:oracle High Availability Services autostart is enabled. ---Check if CRS is configured to start automatically
[Email protected] ~]# crsctl Disable CRS
Crs-4621:oracle High Availability Services autostart is disabled. Automatic start of the CRS system restart---prohibited
[[email protected] ~]# Crsctl enable CRS
Crs-4622:oracle High Availability Services autostart is enabled. Automatic startup---Enable CRS system restart (each node executes separately)

Basic operation of Oracle 11g RAC (i)------start-up and shutdown