Thinking Out Loud

April 1, 2017

Decipher EM Error Message for RAC

Filed under: RAC — mdinh @ 3:24 am

I am not sure if there is a way to have EM display the actual commands it uses to check and alert errors.

It would be nice to be able to verify using the same syntax.

Examples of errors I was paged for:

Message=ora.net2.network has 1 instances in OFFLINE State
Key Value=resource_ora.network.type_ora.net2.network
Message=ora.host01_2.vip has 1 instances in OFFLINE State
Key Value=resource_ora.cluster_vip_net2.type_ora.host01_2.vip

Of course, crsctl stat res -t can be used and the result is 170 lines output.

I finally figured out to to simplify the output.

Find resource type:

crsctl stat res|grep -i type|sort -u

TYPE=app.appvipx.type
TYPE=local_resource
TYPE=ora.asm.type
TYPE=ora.cluster_vip_net1.type
TYPE=ora.cluster_vip_net2.type
TYPE=ora.cvu.type
TYPE=ora.database.type
TYPE=ora.diskgroup.type
TYPE=ora.listener.type
TYPE=ora.mgmtdb.type
TYPE=ora.mgmtlsnr.type
TYPE=ora.network.type
TYPE=ora.oc4j.type
TYPE=ora.ons.type
TYPE=ora.scan_listener.type
TYPE=ora.scan_vip.type
TYPE=ora.service.type
TYPE=xag.goldengate.type

Check state for resource type:

crsctl stat res -w "TYPE = ora.network.type"

NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE               , ONLINE
STATE=ONLINE on host01, ONLINE on host02

NAME=ora.net2.network
TYPE=ora.network.type
TARGET=ONLINE               , ONLINE
STATE=ONLINE on host01, ONLINE on host02

crsctl stat res -w "TYPE = ora.cluster_vip_net1.type"

NAME=ora.host01.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on host01

NAME=ora.host02.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on host02

crsctl stat res -w "TYPE = ora.cluster_vip_net2.type"

NAME=ora.host01_2.vip
TYPE=ora.cluster_vip_net2.type
TARGET=ONLINE
STATE=ONLINE on host01

NAME=ora.host02_2.vip
TYPE=ora.cluster_vip_net2.type
TARGET=ONLINE
STATE=ONLINE on host02
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: