Shulou(Shulou.com)05/31 Report--

In order to solve the problem of how Oracle 11gR2 RAC cluster service starts and shuts down, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Summary of startup and shutdown of Oracle 11gR2 RAC cluster service

Shutdown process (CRS cluster shutdown-> database shutdown)

1. Shut down the database:

Execute the srvctl command with the oracl user

Syntax: srvctl stop database-d dbname [- o immediate]

Purpose: all instances of dbname can be shut down at once

[oracle@rac1 ~] $srvctl stop database-d racdb-stop instances on all nodes

Then check the status:

[oracle@rac1] $srvctl status database-d racdb

Instance rac1 is not running on node rac1

Instance rac2 is not running on node race

two。 Stop HAS (High Availability Services), you must operate as root user

[root@rac1 oracle] # cd / u01/grid/11.2.0/grid/bin

[root@rac1 bin] #. / crsctl stop has-f

[root@rac1 bin] #. / crsctl stop crs-f

This command can only shut down the CRS service of the current node, so it needs to be executed on all nodes of the RAC, as does startup. Has is equivalent to crs.

3. To stop the node cluster service, you must use the root user:

[root@rac1 oracle] # cd / u01/grid/11.2.0/grid/bin

[root@rac1 bin] #. / crsctl stop cluster-stop the cluster service of this node

[root@rac1 bin] #. / crsctl stop cluster-all-stop all node services

You can also control the stopped nodes as follows:

[root@rac1 bin] # crsctl stop cluster-n rac1 rac2

CRS-2677: Stop of 'ora.cssd' on' rac1' succeeded

CRS-2677: Stop of 'ora.cssd' on' rac2' succeeded

Omit log output

You can use the above command if you want a command to stop all processes. If no parameter is specified, it is valid for the current node, and if you specify a parameter, it is valid for the relevant parameter node.

4. Check the status of the cluster process

[root@rac1 bin] # crsctl check cluster

Detailed output

[root@rac1 bin] # crs_stat-t-v

Only check the cluster status of this node

[root@rac1 bin] # crsctl check crs

Startup process (CRS Cluster Startup-> Startup Database)

1. Start HAS

Single node startup

[root@rac2 ~] # crsctl start has

[root@rac2 ~] # crsctl start crs

[root@rac2 ~] # 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

All nodes start up

[root@rac1 bin] # crsctl start cluster-n rac1 rac2

CRS-4123: Oracle High Availability Services has been started.

[root@rac1 bin] # crsctl start cluster-all

[root@rac2 ~] # crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

This command starts all RAC CRS-related processes in the background

[root@rac2] # crs_stat-t-v

CRS-0184: Cannot communicate with the CRS daemon.

Because start has starts more crs processes, it starts slowly. My machine waits for 5 minutes and will report the above error before fully starting successfully. You need to wait patiently for a period of time and execute the following command to see that all CRS-related process services have been started.

[root@rac2] # crs_stat-t-v

Name Type R/RA F/FT Target State Host

Ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1

Ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE rac1

Ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac2

Ora....N2.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac1

Ora....N3.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac1

Ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1

Ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE rac1

Ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE

Ora....network ora....rk.type 0/5 0/ ONLINE ONLINE rac1

Ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE rac1

Ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1

Ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1

Ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1

Ora.rac1.gsd application 0/5 0/0 OFFLINE OFFLINE

Ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1

Ora.rac1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac1

Ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2

Ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2

Ora.rac2.gsd application 0/5 0/0 OFFLINE OFFLINE

Ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2

Ora.rac2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac2

Ora....ry.acfs ora....fs.type 0/5 0/ ONLINE ONLINE rac1

Ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac2

Ora.scan2.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac1

Ora.scan3.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac1

Description:

English explanation

Ora.gsd is OFFLINE by default ifthere is no 9i database in the cluster.

Ora.oc4j is OFFLINE in 11.2.0.1 as DatabaseWorkload Management (DBWLM) is unavailable. These can be ignored in11gR2 RAC.

Chinese interpretation

Ora.gsd is a process used to communicate with 9i database in cluster service. In the current version, it is saved for backward compatibility. The status of OFFLINE does not affect the normal operation and performance of CRS. We can ignore it.

Ora.oc4j is a valid service process in version 11.2.0.2 and is used for resource management of DBWLM, so it is not used in versions below 11.2.0.1.

two。 Start the database:

The oracl user executes the srvctl command:

Syntax: srvctl start | stop | status database-d dbname [- o immediate]

Function: you can start all instances of dbname at once

[oracle@rac1 ~] $srvctl start database-d racdb-start instances on all nodes

Then check the status:

[oracle@rac1] $srvctl status database-d racdb

3. Output the full name of the resource in detail and check the status

Crsctl status resource-t

Crsctl status resource

4. Common srvctl commands

Specify an instance on dbname

Srvctl start | stop | status instance-d-I

5. Displays the configuration and status of all instances under RAC

Srvctl status | config database-d

6. Show application services (VIP,GSD,listener,ONS) for all nodes

Srvctl start | stop | status nodeapps-n

7.ASM process service management

Srvctl start | stop | status | config asm-n [- I] [- o]

Srvctl config asm-a

Srvctl status asm-a

6. You can get all the environmental information:

Srvctl getenv database-d [- I]

7. Set up the global environment and variables:

Srvctl setenv database-d-t LANG=en

8. Delete existing database information in OCR

Srvctl remove database-d

9. Add an instance of the database to OCR:

Srvctl add instance-d-I-n

Srvctl add instance-d-I-n

10. Check the status of the monitor

Srvctl status listener

Srvctl config listener-a

SCAN configuration Information

Srvctl config scan

SCAN listener status information

Srvctl status scan

Summary: the crsctl command is a cluster-level command, which can perform unified start, stop and other management operations on all cluster resources.

The srvctl command is a service-level command that can perform unified start, stop and other management operations on a single service resource.

Attached: detailed help on srvctl command start and stop

[root@rac2] # srvctl start-h

The SRVCTL start command starts, Oracle Clusterware enabled, non-running objects.

Usage: srvctl start database-d [- o] [- n]

Usage: srvctl start instance-d {- n [- I] |-I} [- o]

Usage: srvctl start service-d [- s "" [- n |-I]] [- o]

Usage: srvctl start nodeapps [- n] [- g] [- v]

Usage: srvctl start vip {- n |-I} [- v]

Usage: srvctl start asm [- n] [- o]

Usage: srvctl start listener [- l] [- n]

Usage: srvctl start scan [- I] [- n]

Usage: srvctl start scan_listener [- n] [- I]

Usage: srvctl start oc4j [- v]

Usage: srvctl start home-o-s-n

Usage: srvctl start filesystem-d [- n]

Usage: srvctl start diskgroup-g [- n ""]

Usage: srvctl start gns [- l] [- n] [- v]

Usage: srvctl start cvu [- n]

For detailed help on each command and object and its options use:

Srvctl-h

[root@rac2] # srvctl stop-h

The SRVCTL stop command stops, Oracle Clusterware enabled, starting or running objects.

Usage: srvctl stop database-d [- o] [- f]

Usage: srvctl stop instance-d {- n |-I} [- o] [- f]

Usage: srvctl stop service-d [- s "" [- n |-I]] [- f]

Usage: srvctl stop nodeapps [- n] [- g] [- f] [- r] [- v]

Usage: srvctl stop vip {- n |-I} [- f] [- r] [- v]

Usage: srvctl stop asm [- n] [- o] [- f]

Usage: srvctl stop listener [- l] [- n] [- f]

Usage: srvctl stop scan [- I] [- f]

Usage: srvctl stop scan_listener [- I] [- f]

Usage: srvctl stop oc4j [- f] [- v]

Usage: srvctl stop home-o-s-n [- t] [- f]

Usage: srvctl stop filesystem-d [- n] [- f]

Usage: srvctl stop diskgroup-g [- n ""] [- f]

Usage: srvctl stop gns [- n] [- f] [- v]

Usage: srvctl stop cvu [- f]

For detailed help on each command and object and its options use:

Srvctl-h

The answer to the question about how the Oracle 11gR2 RAC cluster service starts and shuts down is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.