Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Saturday, 26 March 2011

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

5 comments:

Anonymous said...

was looking around for some commands and stumbled upon your site. thank you for this :)

Olie said...

Great post, very useful info.

Syed Zaheer said...

Thanks Olie.

Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,
Getting your applications talking is the key to better business processes,
Rapid web services solutions for real business problems,
Web-based Corporate Document Management System,
Outsourcing Solution,
Financial and Operations Business Intelligence Solution,

Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp

Blogger said...

BlueHost is the best hosting company with plans for any hosting needs.