Linux community (www.linuxidc.com) is a professional Linux System Portal website that publishes the latest Linux information in real time, including Linux, Ubuntu, Fedora, RedHat, Red Flag Linux, Linux tutorial, Linux certification, SUSE
Linux community (www.linuxidc.com) is a professional Linux System Portal website that publishes the latest Linux information in real time, including Linux, Ubuntu, Fedora, RedHat, Red Flag Linux, Linux tutorial, Linux certification, SUSE
Crs_stop-all
Crs_stop-all
When crs_stop-all is executed in RAC, the system prompts that some services cannot be stopped. When crs_stat-t is used to check the status, the state of the services that cannot be stopped is UNKNOWN,
The service cannot start with crs_start in the UNKNOWN state.
For example:
[Oracle @ rac1 ~] $ Crs_stop-all
Attempting to stop 'ora. rac1.gsd' on member 'rac1'
Attempting to stop 'ora. rac1.ons 'on member 'rac1'
Attempting to stop 'ora. rac2.gsd' on member 'rac2'
Attempting to stop 'ora. ora9i. db' on member 'rac1'
Attempting to stop 'ora. rac2.ons 'on member 'rac2'
Stop of 'ora. rac1.gsd' on member 'rac1' succeeded.
Stop of 'ora. rac2.gsd' on member 'rac2' succeeded.
Stop of 'ora. rac2.ons 'on member 'rac2' succeeded.
Stop of 'ora. rac1.ons 'on member 'rac1' succeeded.
Stop of 'ora. ora9i. db 'on member 'rac1' succeeded.
Attempting to stop 'ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1'
Attempting to stop 'ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2'
'Ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
'Ora. ora9i. ora9i1. inst 'is already OFFLINE.
'Ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
'Ora. ora9i. ora9i2. inst 'is already OFFLINE.
Attempting to stop 'ora. rac1.ASM1. asm 'on member 'rac1'
'Ora. rac1.ASM1. asm 'on member 'rac1' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Attempting to stop 'ora. rac2.ASM2. asm 'on member 'rac2'
Attempting to stop 'ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1'
'Ora. rac2.ASM2. asm 'on member 'rac2' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
'Ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Attempting to stop 'ora. rac1.ASM1. asm 'on member 'rac1'
'Ora. rac1.ASM1. asm 'on member 'rac1' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Attempting to stop 'ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2'
Attempting to stop 'ora. rac1.vip 'on member 'rac1'
'Ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Attempting to stop 'ora. rac2.ASM2. asm 'on member 'rac2'
'Ora. rac2.ASM2. asm 'on member 'rac2' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Attempting to stop 'ora. rac2.vip 'on member 'rac2'
Stop of 'ora. rac1.vip 'on member 'rac1' succeeded.
Stop of 'ora. rac2.vip 'on member 'rac2' succeeded.
CRS-0216: cocould not stop resource 'ora. ora9i. ora9i1. inst '.
CRS-0216: cocould not stop resource 'ora. ora9i. ora9i2. inst '.
CRS-0216: cocould not stop resource 'ora. rac1.ASM1. asm '.
CRS-0216: cocould not stop resource 'ora. rac1.LISTENER _ RAC1.lsnr '.
CRS-0216: cocould not stop resource 'ora. rac1.vip '.
CRS-0216: cocould not stop resource 'ora. rac2.ASM2. asm '.
CRS-0216: cocould not stop resource 'ora. rac2.LISTENER _ RAC2.lsnr '.
CRS-0216: cocould not stop resource 'ora. rac2.vip '.
In the UNKNOWN state, the crs_start-all command will not start RAC, and an error will be reported during startup.
[Oracle @ rac1 ~] $ Crs_start-all
Attempting to start 'ora. rac1.vip 'on member 'rac1'
Attempting to start 'ora. rac2.vip 'on member 'rac2'
Attempting to start 'ora. rac2.gsd' on member 'rac2'
Attempting to start 'ora. rac2.ons 'on member 'rac2'
Attempting to start 'ora. rac1.gsd' on member 'rac1'
Attempting to start 'ora. rac1.ons 'on member 'rac1'
'Ora. rac2.gsd' on member 'rac2' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
'Ora. rac2.ons 'on member 'rac2' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Attempting to start 'ora. ora9i. db' on member 'rac1'
'Ora. rac1.ons 'on member 'rac1' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
'Ora. rac1.gsd' on member 'rac1' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
'Ora. ora9i. db' on member 'rac1' has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Start of 'ora. rac1.vip 'on member 'rac1' succeeded.
CRS-1028: Dependency analysis failed because:
'Resource in UNKNOWN state: ora. rac1.ASM1. asm'
Start of 'ora. rac2.vip 'on member 'rac2' succeeded.
CRS-1028: Dependency analysis failed because:
'Resource in UNKNOWN state: ora. rac2.ASM2. asm'
CRS-0215: cocould not start resource 'ora. ora9i. db '.
CRS-0223: Resource 'ora. ora9i. ora9i1. inst 'has placement error.
CRS-0223: Resource 'ora. ora9i. ora9i2. inst 'has placement error.
CRS-0215: cocould not start resource 'ora. rac1.gsd '.
CRS-0215: cocould not start resource 'ora. rac1.ons '.
CRS-0215: cocould not start resource 'ora. rac2.gsd '.
CRS-0215: cocould not start resource 'ora. rac2.ons '.
At this time, crs_stat-t still has many UNKNOWN states.
(Annoying, annoying, and annoying. It's really strange in rac. when the service is shut down normally,
The status can only be online or offline (started or not started). In the result, an UNKNOWN is displayed in RAC ):
[Oracle @ rac1 ~] $ Crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora. ora9i. db application online unknown rac1
Ora... i1.inst application OFFLINE
Ora... i2.inst application OFFLINE
Ora... SM1.asm application offline unknown rac1
Ora... C1.lsnr application offline unknown rac1
Ora. rac1.gsd application online unknown rac1
Ora. rac1.ons application online unknown rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application offline unknown rac2
Ora... C2.lsnr application offline unknown rac2
Ora. rac2.gsd application online unknown rac2
Ora. rac2.ons application online unknown rac2
Ora. rac2.vip application ONLINE rac2
[Oracle @ rac1 ~] $ Sqlplus/nolog
SQL * Plus: Release 10.2.0.1.0-Production on Thu Aug 7 13:42:36 2008
Copyright (c) 1982,200 5, Oracle. All rights reserved.
SQL> conn/as sysdba
Connected to an idle instance.
It indicates that the database is no longer connected;
There are two solutions:
Method 1: Disable the crs service and then enable the crs service.
(Equivalent to restarting the system, because crs is automatically started with the system), it must be executed on both nodes;
Procedure:
Node 1:
1. [root @ rac1 ~] #/Etc/init. d/init. crs stop
Shutting down Oracle Cluster Ready Services (CRS ):
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons shoshould exit soon.
2. [root @ rac1 ~] # Su-oracle
[Oracle @ rac1 ~] $ Crs_stat-t
CRS-0184: Cannot communicate with the CRS daemon.
3. [oracle @ rac1 ~] $ Exit
Logout
[Root @ rac1 ~] #/Etc/init. d/init. crs start
Startup will be queued to init within 90 seconds.
4. [root @ rac1 ~] # Su-oracle
[Oracle @ rac1 ~] $ Crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora. ora9i. db application ONLINE rac1
Ora... i1.inst application ONLINE rac1
Ora... i2.inst application ONLINE rac2
Ora... SM1.asm application ONLINE rac1
Ora... C1.lsnr application ONLINE rac1
Ora. rac1.gsd application ONLINE rac1
Ora. rac1.ons application ONLINE rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application ONLINE rac2
Ora... C2.lsnr application ONLINE rac2
Ora. rac2.gsd application ONLINE rac2
Ora. rac2.ons application ONLINE rac2
Ora. rac2.vip application ONLINE rac2
[Oracle @ rac1 ~] $
Node 2:
1. [root @ rac2 ~] #/Etc/init. d/init. crs stop
Shutting down Oracle Cluster Ready Services (CRS ):
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons shoshould exit soon.
2. [root @ rac2 ~] # Su-oracle
[Oracle @ rac2 ~] $ Crs_stat-t
CRS-0184: Cannot communicate with the CRS daemon.
[Oracle @ rac2 ~] $ Exit
Logout
3. [root @ rac2 ~] #/Etc/init. d/init. crs start
Startup will be queued to init within 90 seconds.
4. [root @ rac2 ~] # Su-oracle
[Oracle @ rac2 ~] $ Crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora. ora9i. db application ONLINE rac1
Ora... i1.inst application ONLINE rac1
Ora... i2.inst application ONLINE rac2
Ora... SM1.asm application ONLINE rac1
Ora... C1.lsnr application ONLINE rac1
Ora. rac1.gsd application ONLINE rac1
Ora. rac1.ons application ONLINE rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application ONLINE rac2
Ora... C2.lsnr application ONLINE rac2
Ora. rac2.gsd application ONLINE rac2
Ora. rac2.ons application ONLINE rac2
Ora. rac2.vip application ONLINE rac2
[Oracle @ rac2 ~] $
Method 2: You can use crs_stop-f to forcibly stop the service and start the service (run on a node );
Procedure:
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac1.ons
Attempting to stop 'ora. rac1.ons 'on member 'rac1'
Stop of 'ora. rac1.ons 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac1.ons
Attempting to start 'ora. rac1.ons 'on member 'rac1'
Start of 'ora. rac1.ons 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac2.ons
Attempting to stop 'ora. rac2.ons 'on member 'rac2'
Stop of 'ora. rac2.ons 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac2.ons
Attempting to start 'ora. rac2.ons 'on member 'rac2'
Start of 'ora. rac2.ons 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac1.gsd
Attempting to stop 'ora. rac1.gsd' on member 'rac1'
Stop of 'ora. rac1.gsd' on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac1.gsd
Attempting to start 'ora. rac1.gsd' on member 'rac1'
Start of 'ora. rac1.gsd' on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac2.gsd
Attempting to stop 'ora. rac2.gsd' on member 'rac2'
Stop of 'ora. rac2.gsd' on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac2.gsd
Attempting to start 'ora. rac2.gsd' on member 'rac2'
Start of 'ora. rac2.gsd' on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac1.LISTENER _ RAC1.lsnr
Attempting to stop 'ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1'
Stop of 'ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac1.LISTENER _ RAC1.lsnr
Attempting to start 'ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1'
Start of 'ora. rac1.LISTENER _ RAC1.lsnr 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac2.LISTENER _ RAC2.lsnr
Attempting to stop 'ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2'
Stop of 'ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac2.LISTENER _ RAC2.lsnr
Attempting to start 'ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2'
Start of 'ora. rac2.LISTENER _ RAC2.lsnr 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac1.ASM1. asm
Attempting to stop 'ora. rac1.ASM1. asm 'on member 'rac1'
Stop of 'ora. rac1.ASM1. asm 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac1.ASM1. asm
Attempting to start 'ora. rac1.ASM1. asm 'on member 'rac1'
Start of 'ora. rac1.ASM1. asm 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. rac2.ASM2. asm
Attempting to stop 'ora. rac2.ASM2. asm 'on member 'rac2'
Stop of 'ora. rac2.ASM2. asm 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. rac2.ASM2. asm
Attempting to start 'ora. rac2.ASM2. asm 'on member 'rac2'
Start of 'ora. rac2.ASM2. asm 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. ora9i. ora9i1. inst
'Ora. ora9i. ora9i1. inst 'is already OFFLINE.
CRS-0216: cocould not stop resource 'ora. ora9i. ora9i1. inst '.
[Oracle @ rac2 ~] $ Crs_start-f ora. ora9i. ora9i1. inst
Attempting to start 'ora. ora9i. ora9i1. inst 'on member 'rac1'
Start of 'ora. ora9i. ora9i1. inst 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. ora9i. ora9i2. inst
'Ora. ora9i. ora9i2. inst 'is already OFFLINE.
CRS-0216: cocould not stop resource 'ora. ora9i. ora9i2. inst '.
[Oracle @ rac2 ~] $ Crs_start-f ora. ora9i. ora9i2. inst
Attempting to start 'ora. ora9i. ora9i2. inst 'on member 'rac2'
Start of 'ora. ora9i. ora9i2. inst 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_stop-f ora. ora9i. db
Attempting to stop 'ora. ora9i. db' on member 'rac2'
Stop of 'ora. ora9i. db 'on member 'rac2' succeeded.
[Oracle @ rac2 ~] $ Crs_start-f ora. ora9i. db
Attempting to start 'ora. ora9i. db' on member 'rac1'
Start of 'ora. ora9i. db 'on member 'rac1' succeeded.
[Oracle @ rac2 ~] $ Crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora. ora9i. db application ONLINE rac1
Ora... i1.inst application ONLINE rac1
Ora... i2.inst application ONLINE rac2
Ora... SM1.asm application ONLINE rac1
Ora... C1.lsnr application ONLINE rac1
Ora. rac1.gsd application ONLINE rac1
Ora. rac1.ons application ONLINE rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application ONLINE rac2
Ora... C2.lsnr application ONLINE rac2
Ora. rac2.gsd application ONLINE rac2
Ora. rac2.ons application ONLINE rac2
Ora. rac2.vip application ONLINE rac2
Conclusion: When crs_stop-all is used in the rac environment to stop the rac service, some services in the crs may be in the UNKNOWN status, in this case, we can restart the crs service in two ways:
1: convert to the root user using/etc/init. d/init. crs stop first disables crs and then uses/etc/init. d/init. crs start is used to enable crs. After crs is enabled, a series of services of crs are automatically started. Note that this method must be executed on both nodes;
2: Use the crs_stop-f parameter to turn off the services in the crs state of UNKNOWN, and then use crs_start-f (with A-f parameter) to start all services.
Run the following commands on two nodes:
It is best to check the crs, ASM, and database logs during the startup process:
Crs log:
[Oracle @ rac1 ~] $ Tail-f/u01/app/oracle/product/10.2.0/crs_1/log/rac1/alertrac1.log
[Oracle @ rac2 ~] $ Tail-f/u01/app/oracle/product/10.2.0/crs_1/log/rac2/alertrac2.log
ASM log:
[Oracle @ rac1 ~] $ Tail-f/u01/app/oracle/admin/+ ASM/bdump/alert _ + ASM1.log
[Oracle @ rac2 ~] $ Tail-f/u01/app/oracle/admin/+ ASM/bdump/alert _ + ASM2.log
Database Log:
[Oracle @ rac1 ~] $ Tail-f/u01/app/oracle/admin/ora9i/bdump/alert_ora9i1.log
[Oracle @ rac2 ~] $ Tail-f/u01/app/oracle/admin/ora9i/bdump/alert_ora9i2.log