Select Menu

Ads

Random Posts

Powered By Blogger
Powered By Blogger

Blog Archive

Search This Blog

Thirupal Boreddy. Powered by Blogger.

My Blog List

Followers

Lorem 1

Technology

Circle Gallery

Shooting

Racing

News

Lorem 4

» » CRSCTL CheatSheet

CRSCTL CheatSheet:
You can find below various commands which can be used to administer Oracle Clusterware using crsctl. This is for purpose of easy reference.

1.Start Oracle Clusterware
#crsctl start crs

2.Stop Oracle Clusterware#crsctl stop crs

3.Enable Oracle Clusterware

#crsctl enable crs

It enables automatic startup of Clusterware daemons

4.Disable Oracle Clusterware

#crsctl disable crs

It disables automatic startup of Clusterware daemons. This is useful when you are performing some
operations like OS patching and does not want clusterware to start the daemons automatically.

5. Checking Voting disk Location

$crsctl query css votedisk
0. 0 /dev/sda3
1. 0 /dev/sda5
2. 0 /dev/sda6

Located 3 voting disk(s).
Note: -Any command which just needs to query information can be run using oracle user. But anything which alters Oracle Clusterware requires root privileges.

6.Add Voting disk

#crsctl add css votedisk path

7.Remove Voting disk

#crsctl delete css votedisk path

8.Check CRS Status

$crsctl check crs
Cluster Synchronization Services appears healthy
Cluster Ready Services appears healthy
Event Manager appears healthy

9.You can also see particular daemon status

$crsctl check cssd

10.Cluster Synchronization Services appears healthy

$crsctl check crsd

11.Cluster Ready Services appears healthy

$crsctl check evmd
Event Manager appears healthy

12.You can also check Clusterware status on both the nodes using

$crsctl check cluster
prod01 ONLINE
prod02 ONLINE

13.Checking Oracle Clusterware Version
To determine software version (binary version of the software on a particular cluster node) use

14.$crsctl query crs softwareversion

Oracle Clusterware version on node [prod01] is [11.1.0.6.0]

For checking active version on cluster, use

$ crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [11.1.0.6.0]

As per documentation, multiple versions are used while upgrading.
There are other options for CRSCTL too which can be seen using

$crsctl
Or

$crsctl help
crsctl query css votedisk

About Oracle DBA World

WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
«
Next
Newer Post
»
Previous
Older Post

No comments

Leave a Reply

QUERY FOR CPU USAGE

select  a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...