In oracle database 11gR2 there is new feature has - High Availability Services . I am writing this article to describe how do we use it to check status/stop/start of has - high availability service.
crsctl binary will exists in your 11.2.0.x Grid Infra home bin dir. So make sure you have set correct $ORACLE_HOME and $PATH env. variable.
To check whether has configured to be started when the server restarts:
To Stop has (High Availability Service) service:
To Start (High Availability Service) service:
To check status of resources:
Happy reading :)
crsctl binary will exists in your 11.2.0.x Grid Infra home bin dir. So make sure you have set correct $ORACLE_HOME and $PATH env. variable.
To check whether has configured to be started when the server restarts:
bash-3.00$ crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.
To Stop has (High Availability Service) service:
bash-3.00$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resourc es on 'nodedb'
CRS-2673: Attempting to stop 'ora.evmd' on 'nodedb'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'nodedb'
CRS-2673: Attempting to stop 'ora.ASMDATA1.dg' on 'nodedb'
CRS-2677: Stop of 'ora.ASMDATA1.dg' on 'nodedb' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'nodedb'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'nodedb' succeeded
CRS-2677: Stop of 'ora.evmd' on 'nodedb' succeeded
CRS-2677: Stop of 'ora.asm' on 'nodedb' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'nodedb'
CRS-2677: Stop of 'ora.cssd' on 'nodedb' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'nodedb'
CRS-2677: Stop of 'ora.diskmon' on 'nodedb' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'na decerp' has completed
CRS-4133: Oracle High Availability Services has been stopped.
To Start (High Availability Service) service:
bash-3.00$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
To check status of resources:
bash-3.00$ crsctl status resource
NAME=ora.ASMDATA1.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on nodedb
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on nodedb
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on nodedb
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on nodedb
NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on nodedb
NAME=ora.emdb.db
TYPE=ora.database.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on nodedb
NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE
Happy reading :)
Comments
Now I want to disable the autostartup of only 1 database, how I can achieve that.?
"crsctl disable has" will disable restart of both the database instance on server.
please suggest.