Database Tuning (MOSC)

MOSC Banner

RAC database on NFS hanging

edited May 12, 2017 12:01PM in Database Tuning (MOSC) 14 commentsAnswered

Hello,

We have a database on NetApp NFS storage with a two nodes RAC environment and Active Data Guard on stand-alone database.

Yesterday, the database was hung for approximately 30min (starting approx at 14:55 and resumed at 15:25), having gaps in the alert log, whereas redo log switches are forced every 5min:

block from 2nd instance alert log:

Thu Apr 20 14:59:33 2017

Process RSM0, PID = 12605, will be killed

Thu Apr 20 15:07:13 2017

ORA-00240: control file enqueue held for more than 120 seconds

Thu Apr 20 15:16:11 2017

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

Fatal NI connect error 12537, connecting to:

.

.

.

Thu Apr 20 15:20:07 2017

Killing enqueue blocker (pid=12198) on resource CF-00000000-00000000 by (pid=11915)

by killing session 4002.3

Attempt to get Control File Enqueue by LGWR pid=11915 (mode=X, type=0, timeout=900) is being blocked by inst=2, pid=12198

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center