We recently migrated a customer’s 10gR2 RAC on AIX6.1 from GPFS+HACMP to a “basic” Clusterware with datafiles over ASM.
After (many) problems related to various installation bugs (the list of requirements for AIX is very long, incomplete and requires many one-off patches to complete), we had a problem during an import of a new schema: the import hung with no apparent wait events. We found that the event it was waiting for was classified as ‘Idle’:
|
1 2 3 4 5 6 7 |
SQL> select sid, username, status, event, wait_class, program from gv$session; SID USERNAME STATUS EVENT WAIT_CLASS PROGRAM ---- ---------- -------- -------------------- ---------- ---------------------------------------- ... 135 SYS ACTIVE KSV master wait Idle imp@trndcsaixdb1 (TNS V1-V3) ... |
The on ASM instance:
|
1 2 3 4 5 |
SQL> @wait10g SID USERNAME MACHINE PROGRAM EVENT SEQ# P1 S_IN_WAIT STATE STATUS ---- ---------- --------------- -------------------- -------------------- ------ ------------ ---------- ------------------- -------- 201 SYS trndcsaixdb1 oracle@trndcsaixdb1 enq: FA - access file 6 1178664965 744 WAITING ACTIVE |
The problem was related to datafile resize (we use autoextend) and according to MOS, we were encountering a bug:
Bug 11712836: RESIZING DATAFILE HUNG WAITING FOR KSV MASTER WAIT IN RAC
Shutting down one instance solved the problem. Now we have to avoid autoextend……. We never encountered this bug in many 10.2.0.4 rac installations.