Thursday, December 10, 2020

Cluster status check command

 

12.1.0.2 Grid status check command

=====================================



[root@node1 ~]# crsctl check cluster -all

**************************************************************

node1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

node2:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

[root@node1 ~]#

[root@node1 ~]#

[root@node1 ~]# date

Thu Dec 10 04:10:04 IST 2020


[root@node1 ~]#



[root@node1 ~]# crsctl stat resource -t

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

Name           Target  State        Server                   State details

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

Local Resources

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

ora.DATA1.dg

               ONLINE  ONLINE       node1                    STABLE

               ONLINE  ONLINE       node2                    STABLE

ora.LISTENER.lsnr

               ONLINE  ONLINE       node1                    STABLE

               ONLINE  ONLINE       node2                    STABLE

ora.asm

               ONLINE  ONLINE       node1                    Started,STABLE

               ONLINE  ONLINE       node2                    Started,STABLE

ora.net1.network

               ONLINE  ONLINE       node1                    STABLE

               ONLINE  ONLINE       node2                    STABLE

ora.ons

               ONLINE  ONLINE       node1                    STABLE

               ONLINE  ONLINE       node2                    STABLE

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       node2                    STABLE

ora.LISTENER_SCAN2.lsnr

      1        ONLINE  ONLINE       node1                    STABLE

ora.LISTENER_SCAN3.lsnr

      1        ONLINE  ONLINE       node1                    STABLE

ora.MGMTLSNR

      1        ONLINE  ONLINE       node1                    169.254.18.158 10.0.

                                                             0.1,STABLE

ora.cvu

      1        ONLINE  ONLINE       node1                    STABLE

ora.mgmtdb

      1        ONLINE  ONLINE       node1                    Open,STABLE

ora.node1.vip

      1        ONLINE  ONLINE       node1                    STABLE

ora.node2.vip

      1        ONLINE  ONLINE       node2                    STABLE

ora.oc4j

      1        ONLINE  ONLINE       node1                    STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       node2                    STABLE

ora.scan2.vip

      1        ONLINE  ONLINE       node1                    STABLE

ora.scan3.vip

      1        ONLINE  ONLINE       node1                    STABLE

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

[root@node1 ~]#




[root@node1 ~]# crsctl status resource ora.LISTENER_SCAN2.lsnr -v

NAME=ora.LISTENER_SCAN2.lsnr

TYPE=ora.scan_listener.type

LAST_SERVER=node1

STATE=ONLINE on node1

TARGET=ONLINE

CARDINALITY_ID=1

RESTART_COUNT=0

FAILURE_COUNT=0

FAILURE_HISTORY=

ID=ora.LISTENER_SCAN2.lsnr 1 1

INCARNATION=1

LAST_RESTART=12/10/2020 02:17:20

LAST_STATE_CHANGE=12/10/2020 02:17:19

STATE_DETAILS=

INTERNAL_STATE=STABLE

INSTANCE_COUNT=1



No comments:

Post a Comment

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Oracle 19c to PostgreSQL 15 Migration: Step-by-Step Production Guide (Ora2Pg + DMS)

Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...