Home » RDBMS Server » Server Administration » MMON: "KEWRAFC: Flush slave failed, return Code: 5."
MMON: "KEWRAFC: Flush slave failed, return Code: 5." [message #222243] Fri, 02 March 2007 08:00 Go to next message
seh@gedas.de
Messages: 2
Registered: March 2007
Junior Member
Hi,

I have a problem on an Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 on Windows Server 2003.
In *_mmon_*.trc I found many messages like
Quote:

*** KEWRAFC: Flush slave failed, return Code: 5.


and some hours later:
Quote:

*** KEWROCISTMTEXEC - encountered error: (ORA-00604: error occurred at recursive SQL level 3
ORA-04021: timeout occurred while waiting to lock object
)
*** SQLSTR: total-len=1293, dump-len=240,
STR={INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, service_hash, session_type, sql}
kewa_flusher: Exception handler 13509 - Will resignal!
kewa_eflush_cb: Exception handler 13509
kewa_eflush_cb: Cleared error 13509


After this message the database stands and I got every hour a tracefile *_m001_*.trc with this:
Quote:

*** ACTION NAME:(Auto-DBFUS Action) 2007-03-02 00:39:05.596
*** MODULE NAME:(MMON_SLAVE) 2007-03-02 00:39:05.596
*** SERVICE NAME:(SYS$BACKGROUND) 2007-03-02 00:39:05.596
*** SESSION ID:(146.136) 2007-03-02 00:39:05.596
*********START PLSQL RUNTIME DUMP************
***Got internal error Exception caught in pfrrun() while running PLSQL***
***Got ORA-604 while running PLSQL***
PACKAGE BODY SYS.DBMS_FEATURE_USAGE_INTERNAL:
...
...
...
***********END PLSQL RUNTIME DUMP************
*** KEWUXS - encountered error: (ORA-00604: error occurred at recursive SQL level 2
ORA-04021: timeout occurred while waiting to lock object
)
*** KEWFADS: Error=13515 encountered by Auto DBFUS slave.


and in *_mmon_*.trc this messages
Quote:

kwqicaclcur: Error 604
Error(2) 4021
Cursor Session Number : 153
Cursor Session Serial : 2
Cursor Pin Number : 13322


and an corresponding message in the alert.log:
Quote:

ORA-604 encountered when generating server alert SMG-3503


After restarting the database it seems to be OK.
Anybody know the reason for the problem?
Any help would be appreciated.

Greetings SEH.
Re: MMON: "KEWRAFC: Flush slave failed, return Code: 5." [message #222261 is a reply to message #222243] Fri, 02 March 2007 09:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Appears like bug#4215046
Re: MMON: "KEWRAFC: Flush slave failed, return Code: 5." [message #222567 is a reply to message #222261] Mon, 05 March 2007 07:40 Go to previous messageGo to next message
seh@gedas.de
Messages: 2
Registered: March 2007
Junior Member
Hi,

thanks for the answer. I found nothing about this bug ( bug#4215046), do you have a link for the description or something else?

greetings, SEH.
Re: MMON: "KEWRAFC: Flush slave failed, return Code: 5." [message #222587 is a reply to message #222567] Mon, 05 March 2007 09:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems the published DOC is internal.
Raise a TAR with OSS
Previous Topic: V$SGA size calculation
Next Topic: Database reorg
Goto Forum:
  


Current Time: Fri Dec 09 13:36:22 CST 2016

Total time taken to generate the page: 0.31329 seconds