WRH Data Collection complains of invalid identifier

From: David Barbour <david.barbour_at_sbcglobal.net>
Date: Thu, 17 Nov 2005 23:53:36 -0800 (PST)
Message-ID: <20051118075337.76945.qmail@web81704.mail.mud.yahoo.com>

RDBMS Version: 10.1.0.4.2
Operating System and Version: RHEL 4.0 2.6.9-11.ELhugemem

Database is throwing the tracefile below whenever it tries to update wrh.

Searched through the bugs and forums. Found similar issues, but not this particular one. Would appreciate any insight.

Node name: rhlv004.formfactor.com

Release: 2.6.9-11.ELhugemem 
Version: #1 SMP Fri May 20 18:34:54 EDT 2005 
Machine: i686 

Instance name: prod21
Redo thread mounted by this instance: 1 Oracle process number: 45
Unix process pid: 7829, image: oracle_at_rhlv004.formfactor.com (m001)

• ACTION NAME:(Remote-Flush Slave Action) 2005-11-17 08:00:29.007
• MODULE NAME:(MMON_SLAVE) 2005-11-17 08:00:29.007
• SERVICE NAME:(SYS$BACKGROUND) 2005-11-17 08:00:29.007
• SESSION ID:(185.52539) 2005-11-17 08:00:29.006
• KEWROCISTMTEXEC - encountered error: (ORA-00904: "BLOCKING_SESSION_SERIAL#": invalid identifier )
• SQLSTR: total-len=1411, 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!
• KEWRAFM1: Error=13509 encountered by kewrfteh

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 18 2005 - 02:56:49 CST