CRSCTL 11.2.0.2 to start/stop/check on Standalone node

-
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:



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

Anonymous said…
was looking around for some commands and stumbled upon your site. thank you for this :)
20 September 2011 at 08:24
Olie said…
Great post, very useful info.
19 December 2012 at 08:13
yaklibber924 said…
There are some fascinating deadlines in this article but I don’t know if I see all of them middle to heart. There's some validity however I will take hold opinion till I look into it further. Good article , thanks and we want extra! Added to FeedBurner as well best online casino
14 June 2018 at 11:25
Anonymous said…
I have 2 database instances running in GRID env(non RAC).
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.
22 December 2022 at 13:21
Post a Comment

Popular posts from this blog

Installation of Oracle Applications R12.1.1 on Linux and vmware

-
Image
The below article is step by step procedure to Install oracle E-Business suite R12.1.1 on Oracle Enterprise Linux 5.6 (32-bit) using vmware server 2 on windows 7 64 bit. This is a single node Installation. (All services will be hosting on same machine 0 db, conc, web, forms etc) I have Installed it on a virtual machine with 4gb ram, 120 GB of local disk space and 1 core cpu. - Requires 80 GB of free space for fresh installation (excluding stage area) - Requires 100+ GB of free space for vision installation (excl. stage) I will split this configuration in 5 steps: 1) create and configure virtual machine 2) Install linux operating system 3) create stage Area 4) Perform all operating system per-requisites 5) Install oracle E-business suite R12.1.1 create and configure virtual machine: >> Login to vmware Server console >> click on add virtual machine >> Here i have selected iso image for OS Installation, you can select local cd drive if u want. >> Now the virtual m...
Read more

Disable Firewall on Oracle Linux 8

-
Image
In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R
Read more

ntp service in Maintenance mode Solaris 10

-
Hi, On one of our newly configured solaris 10 server, successfully configured a ntp client. But when trying to start ntp service its getting failed and going into maintance mode. Due to this there a 5 minutes of time difference between this server and other servers. bash-3.00$ svcs ntp maintenance 16:12:09 svc:/network/ntp:default When we check in detail: bash-3.00$ svcs -x ntp svc:/network/ntp:default (Network Time Protocol (NTP)) State: maintenance since Sun Jan 08 08:12:07 2012 Reason: Start method failed repeatedly, last exited with status 1. See: http://sun.com/msg/SMF-8000-KS See: xntpd(1M) See: ntpdate(1M) See: ntpq(1M) See: /var/svc/log/network-ntp:default.log Impact: This service is not running. When we check logfile: [ Aug 11 13:11:15 Executing start method ("/lib/svc/method/xntp") ] /sbin/sh: /lib/svc/method/xntp: not found [ Aug 11 13:11:15 Method "start" exited with status 1 ] Stuck !!!!! Don't worry if you encounter same e...
Read more