WRH Data Collection complains of invalid identifier 2005-11-18 - By David Barbour
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@(protected) (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 (See ORA-00904.ora-code.com): "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
<DIV><STRONG>RDBMS Version</STRONG>: 10.1.0.4.2<BR><B>Operating System and
Version</B>: RHEL 4.0 2.6.9-11.ELhugemem<BR><BR>Database is throwing the
tracefile below whenever it tries to update wrh. <BR><BR>Searched through the
bugs and forums. Found similar issues, but not this particular one. Would
appreciate any insight. <BR><BR>Node name: rhlv004.formfactor.com <BR>Release:
2.6.9-11.ELhugemem <BR>Version: #1 SMP Fri May 20 18:34:54 EDT 2005 <BR>Machine
: i686 <BR>Instance name: prod21 <BR>Redo thread mounted by this instance: 1 <BR
>Oracle process number: 45 <BR>Unix process pid: 7829, image: oracle@(protected)
.formfactor.com (m001) <BR><BR>*** ACTION NAME:(Remote-Flush Slave Action) 2005
-11-17 08:00:29.007 <BR>*** MODULE NAME:(MMON_SLAVE) 2005-11-17 08:00:29.007 <BR
>*** SERVICE NAME:(SYS$BACKGROUND) 2005-11-17 08:00:29.007 <BR>*** SESSION ID:
(185.52539) 2005-11-17 08:00:29.006 <BR>*** KEWROCISTMTEXEC - encountered error:
(ORA-00904 (See ORA-00904.ora-code.com): "BLOCKING_SESSION_SERIAL#": invalid identifier
<BR>)
<BR>*** SQLSTR: total-len=1411, dump-len=240, <BR>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} <BR>kewa_flusher:
Exception handler 13509 - Will resignal! <BR>*** KEWRAFM1: Error=13509
encountered by kewrfteh <BR></DIV>
|
|
