RAC 11gR2; Bug 11807012 really fixed with PSU3?

The Issue:

crsctl status res -t output shows ora.asm CHECK TIMED OUT on the node 1 (=srv979db01) of 7 nodes cluster.

We are running an 11.2.0.2.3 version (with Patch set Update 3 applied ; refer to my previous article how to apply PSU3 in RAC environment; ).

Here is the output of crsctl status res -t command;

  1. ora.asm  
  2. ONLINE INTERMEDIATE srv979db01 CHECK TIMED OUT  
  3. ONLINE ONLINE srv979db02 Started  
  4. ONLINE ONLINE srv979db03 Started  
  5. ONLINE ONLINE srv979db04 Started  
  6. ONLINE ONLINE srv979db05 Started  
  7. ONLINE ONLINE srv979db06 Started  
  8. ONLINE ONLINE srv979db07 Started  

When checking the oraagent_grid.log file under $GRID_HOME/log//agent/crsd/oraagent_grid/; I have seen the following errors:

  1. 2012-01-29 10:24:51.705: [ AGFW][1614473536] {1:20697:2} Created alert : (:CRSAGF00113:) : Aborting the command: check for resource: ora.asm srv979db01 1  
  2. 2012-01-29 10:24:51.705: [ora.asm][1614473536] {1:20697:2} [check] clsn_agent::abort {  
  3. 2012-01-29 10:24:51.705: [ora.asm][1614473536] {1:20697:2} [check] abort {  
  4. 2012-01-29 10:24:51.705: [ora.asm][1614473536] {1:20697:2} [check] abort command: check  
  5. 2012-01-29 10:24:51.705: [ora.asm][1614473536] {1:20697:2} [check] tryActionLock {  
  6. 2012-01-29 10:24:53.642: [ora.ons][1849448768] {2:15599:2} [check] OnsAgent::check {  
  7. ... 
Read the complete post here: www.oracle-class.com

Views: 422

Comment

You need to be a member of Oracle Community to add comments!

Join Oracle Community

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Database hang and Row Cache Lock concurrency troubleshooting

This post will help to analyze Oracle database instance slowdown that can happen due to considerable row cache lock (enqueue) wait events. It’s is based on a real case of a database hang that I worked on recently. I must admit this type of situation does not appear often but it’s very dangerous since it can considerably slow down a database instance or even freeze it for a short period of time. In most cases SQL against ASH view and Systemstate dumps can help to nail down the problem unless…

Continue

Posted by Kirill Loifman on April 15, 2014 at 12:53am

Creating standby database fast and easy

1.PURPOSE AND SCOPE

With 11gR2 rman duplication its really easy to create standby database.

2.PRACTICE

Information

Primary Database SID: PRIM

Primary Database Domain/IP: ABSO

Standby Database SID: PRIM_SBY

Standby Database Domain/IP: CROO…

Continue

Posted by Bugra Canbakal on April 3, 2014 at 10:30pm

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service