Sunday, June 27, 2021

Why and How to manage Sun Cluster resources running for Oracle Database

  Why ?

To do activity for Oracle database like patching , upgrade or switchover/failover ..etc and this sever is running on Sun cluster HA services , you have to do disable/enable and monitor/unmonitored for certain services configured in your cluster resources and group.

How ?

Below are most important commands you may need to use in Sun Cluster management  :

1- Checking Cluster group status:

clrg status

=== Cluster Resource Groups ===

Group Name      Node Name        Suspended      Status

----------      ---------        ---------      ------

Group_res       Server1         No             Online

                Server2         No             Offline

 

2- Check Cluster resources details of the group :

clrs status

=== Cluster Resources ===

Resource Name      Node Name        State       Status Message

-------------      ---------        -----       --------------

DB-srv            Server1           Online      Online

                   Server2           Offline     Offline

 

DB-lsnr            Server1           Online      Online

                   Server2           Offline     Offline

 

Ip_HA             server1            Online      Online - LogicalHostname online.

                  server2            Offline     Offline

 

DB_zfs-rs        server1            Online      Online

3- Stop/shutdown certain recourse

clrs disable DB-srv

clrs enable DB-srv

4- Disable the cluster management for certain resource

clrs unmonitor DB-srv

clrs monitor DB-srv

5- Show configured things in resource :

clrs show -v DB-srv

6- Switchover to server2

clrg switch -n server2 Group_res


A good reference you may refer to is :

No comments:

Post a Comment

Why and How to install Grid 19c on RHEL 8?

  Why ? Simply we will be requested to install Oracle Grid RAC DB on Redhat RHEL 8, below is my note for this installation . How ? 1-  OS in...