WRH Data Collection complains of invalid identifier
- From: David Barbour <david.barbour@xxxxxxxxxxxxx>
- To: Oracle_L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Nov 2005 23:53:36 -0800 (PST)
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@xxxxxxxxxxxxxxxxxxxxxx (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
Other related posts:
- » WRH Data Collection complains of invalid identifier