<!-- Title: 07:39:02  Wed Jun  1 2005 -->
<!-- Crewchief: New day  -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>

<!-- Date: Wed Jun 1 07:59:32 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 07:59:03 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 08:30:25 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 08:29:55 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Wed Jun  1 08;46;12 comment by...jtrumbo -->
<pre>fyi, same exact queries running as previous mail, with 1 additional 
query. this additional query has the same structure, differing only in 
the parameter values.

&gt; SELECT PS.RC_RUNNUMBER, PS.PHSICSTABLENAME, PS.LUMINOSITY, 
&gt; PS.CEM16ANDWENOJET, PS.WENOJET , RSO.RUNNUMBER, RC.RUNNUMBER FROM 
&gt; PHYSMON_SUMMARY PS, RUN_STATUS RSO, RUNCONFIGURATIONS RC WHERE 
&gt; PS.RC_RUNNUMBER=RSO.RUNNUMBER AND PS.DATATYPE=1 AND 
&gt; PS.RC_RUNNUMBER&gt;=140000 AND PSGOODRUN=1 AND PS.LUMINOSITY&gt;=100 ORDER 
&gt; BY PS.RC_RUNNUMBER DESC

</pre>

<!-- Date: Wed Jun 1 08:59:25 2005 -->
<pre>
Name : cdfofpr2_long_transaction 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: samSAMDBS22654python@cdfsam01.fnal.gov (TNS V1-V3)cdfsam01.fnal.govselect name from v$database05/27/05 06:16:057362.6333333333333333333333333333333333 
CRITICAL 
Jun 01 2005 08:59:01 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 08:59:35 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 08:59:30 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 10:04:46 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 10:04:17 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 10:24:24 2005 -->
<pre>
Name : cdfofpr2_long_transaction 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: sam SAMDBS 22 654 python@cdfsam01.fnal.gov (TNS V1-V3) 7447.7666666666666666666666666666666667 
CRITICAL 
Jun 01 2005 10:24:09 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 10:32:11 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01  ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01  ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 10:31:38 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 11:01:56 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 11:00:46 AM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Wed Jun 1 11:10:35 2005 -->
<pre>i just spoke to eric & he is working on getting users  
off cdfrep01  yet we have had 303168 connections to cdfrep01   Since Monday A.M.      
 
can we please make a general announcement to cdf so we can move towards decommissioning of this machine  -- how about an announcement for june 9 ?!   
</pre>
<!-- Author: nstanfield  -->

<!-- Date: Wed Jun 1 11:27:30 2005 -->
<pre>
Name : cdfofpr2_long_transaction_count 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Jun 01 2005 11:27:03 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 11:33:57 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 11:33:29 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Wed Jun  1 11;39;21 comment by...nstanfield  -->
<pre>still averaging 4 queries every 5 minutes adding up to MANY MANY
switched to cdf_reader vs run_user.....  

bzora1&gt; more temp_use.00_02
Wed Jun  1 00:02:02 CDT 2005
Information for: cdfonprd

DB User      OS Name         System                SID SERIAL# Tablespace         SEGTYPE   SQL
------------ --------------- ------------------ ------ ------- ------------------ --------- ------------------------------
CDF_READER   tomcat          b0web01                51   32193 USERTEMP_01        SORT      SELECT PS.RC_RUNNUMBER, PS.PHYSICSTABLENAME, PS.LUMINOSITY,PS.NWENU, PS.NWMUNU, RSO.RUNNUMBER, RC.RUNNUMBER FROM PHYSMON_SUMMARY PS, RUN_STATUS RSO, RUNCONFIGURATIONS RC WHERE PS.RC_RUNNUMBER=RSO.RUNNUMBER AND
PS.DATATYPE=1 AND PS.RC_RUNNUMBER&gt;=176000 AND PS.GOODRUN=1
AND PS.LUMINOSITY&gt;=100 ORDER BY PS.RC_RUNNUMBER DESC

CDF_READER   tomcat          b0web01                78   46837 USERTEMP_01        SORT      SELECT PS.RC_RUNNUMBER, PS.PHYSICSTABLENAME, PS.LUMINOSITY,
PS.ND, PS.ND_ERR, RSO.RUNNUMBER, RC.RUNNUMBER, RSO.SVX_STATUS FROM PHYSMON_SUMMARY PS, RUN_STATUS RSO, RUNCONFIGURATIONS RC WHERE PS.RC_RUNNUMBER=RSO.RUNNUMBER AND PS.DATATYPE=1 AND PS.RC_RUNNUMBER&gt;=176000 AND PS.GOODRUN=1 AND PS.LUMINOSITY
&gt;=400 ORDER BY PS.RC_RUNNUMBER DESC
</pre>

<!-- Date: Wed Jun 1 11:54:00 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01  ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 11:53:34 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 12:04:00 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jun 01 2005 12:03:19 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 12:41:18 2005 -->
<pre>
Name : cdfonprd_tablespaces 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace MCS_INDEX is 81.55% full.  18625176.0 KBytes of free space remain. 
CRITICAL 
Jun 01 2005 12:40:15 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Wed Jun  1 14;09;05 comment by...ns  -->
<pre>added 3G or so to mcs_data  --&gt; leaving mcs_index till next alert 

Tablespace MCS_DATA is 78.10% full.  4832984.0 KBytes of free space remain. 
CRITICAL 
</pre>

<!-- Date: Wed Jun 1 14:17:22 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Jun 01 2005 02:16:25 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 14:18:06 2005 -->
<pre>
Name : cdfonprd_long_transaction 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: oracleNELLY2110711sqlplus@bzora1 (TNS V1-V3)bzora1insert into junk values ('ns')06/01/05 14:10:136.8333333333333333333333333333333333328 
CRITICAL 
Jun 01 2005 02:17:55 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 14:31:52 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Jun 01 2005 02:31:23 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 14:40:35 2005 -->
<pre>
Name : cdfonprd_long_transaction 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: oracle NELLY 65 20415 sqlplus@bzora1 (TNS V1-V3) 7.94999999999999999999999999999999999952 
CRITICAL 
Jun 01 2005 02:40:05 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 14:42:13 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Jun 01 2005 02:41:22 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 14:46:48 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Jun 01 2005 02:46:29 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 14:58:46 2005 -->
<pre>
Name : cdfofpr2_long_transaction 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: sam SAMDBS 22 654 python@cdfsam01.fnal.gov (TNS V1-V3) 7722 
CRITICAL 
Jun 01 2005 02:58:23 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 14:59:15 2005 -->
<pre>
Name : cdfofpr2_long_transaction_count 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Jun 01 2005 02:58:48 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 15:06:06 2005 -->
<pre>
Name : cdfofpr2_long_transaction_count 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 2 
WARNING 
Jun 01 2005 03:05:56 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 15:10:50 2005 -->
<pre>
Name : cdfofpr2_long_transaction 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: sam SAMDBS 22 654 python@cdfsam01.fnal.gov (TNS V1-V3) 7734.23333333333333333333333333333333334 
CRITICAL 
Jun 01 2005 03:10:38 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 15:11:13 2005 -->
<pre>
Name : cdfofpr2_long_transaction_count 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 1 
CLEARED 
Jun 01 2005 03:10:57 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 15:34:00 2005 -->
<pre>
Name : cdfofpr2_long_transaction_count 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Jun 01 2005 03:32:54 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 15:35:39 2005 -->
<pre>
Name : cdfofpr2_long_transaction 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: oracle NELLY 111 16576 sqlplus@fcdfora4 (TNS V1-V3) 6.59999999999999999999999999999999999952 
CRITICAL 
Jun 01 2005 03:34:28 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 15:38:16 2005 -->
<pre>
Name : cdfofpr2_long_transaction_count 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Jun 01 2005 03:37:54 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 15:49:48 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Jun 01 2005 03:49:07 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 16:00:29 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Jun 01 2005 04:00:10 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 16:51:16 2005 -->
<pre>
Name : cdfofpr2_apply_abort 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 1 
CRITICAL 
Jun 01 2005 04:51:05 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 16:54:53 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Alert 
The following errors are in the ALERT file : ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7C2AAAB0] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7BC2AA60], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7C2AAAB0] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700788920] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7BC2AA60], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7C2AAAB0] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700788920] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped
CRITICAL 
Jun 01 2005 04:53:35 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 16:56:20 2005 -->
<pre>
Name : cdfofpr2_apply_abort 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Jun 01 2005 04:56:05 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 16:57:22 2005 -->
<pre>
Name : cdfofpr2_apply_latency_alert 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: .9999999999999999999999999999999999999996 
CLEARED 
Jun 01 2005 04:56:58 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Jun 1 23:33:57 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Alert 
The following errors are in the ALERT file : ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7C91EC38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078F090] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7C91EC38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078F090] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078F090] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7C91EC38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078F090] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078F090]
CRITICAL 
Jun 01 2005 11:33:35 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Jun 2 00:01:54 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 02 2005 12:01:31 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Jun 2 00:04:00 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 02 2005 12:03:35 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Jun 2 17:29:26 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Alert 
The following errors are in the ALERT file : ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7C3AAC38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700788AF8] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7C3AAC38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700788AF8] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700788AF8] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7C3AAC38], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700788AF8] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700788AF8]
CRITICAL 
Jun 02 2005 05:28:35 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Thu Jun 2 20:25:29 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Alert 
The following errors are in the ALERT file : ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7D5451A0] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7CD56300], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7D5451A0] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700786758] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7CD56300], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7D5451A0] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700786758] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped
CRITICAL 
Jun 02 2005 08:23:35 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Fri Jun 3 00:02:24 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 03 2005 12:01:31 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Fri Jun 3 00:04:28 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 03 2005 12:03:35 AM 



</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Fri Jun 3 07:50:43 2005 -->
<pre>cdfstrm1   old clients... 
 
Alert  
The following errors are in the ALERT file : ORA-12571: TNS:packet writer failure ORA-12571: TNS:packet writer failure.  
WARNING  
Jun 03 2005 05:06:28 AM  
 
USERNAME CDF_READER 
OSUSER   cdf021 
MACHINE wn-05-02-32-a.cr.cnaf.infn.it 
and 
CDF_READER  cafuser2 wn-05-02-32 a.cr.cnaf.infn.it                              </pre>
<!-- Author: ns  -->

<!-- Date: Sat Jun 4 00:02:13 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 04 2005 12:01:31 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sat Jun 4 00:03:43 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 04 2005 12:03:35 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sat Jun 4 11:00:01 2005 -->
<pre>
Name : cdfofpr2_multiple_extents 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Multiple Extents 
Segment SAMPRD.CONSUMED_FILES in tablespace CONSUMED_FILES_P01 is comprised of 1561 extents. Segment SAMPRD.DFLOC_FI_FK_I in tablespace PARTITIONED_IDX_01 is comprised of 1107 extents. Segment SAMPRD.CONF_C_FK_I in tablespace PARTITIONED_IDX_01 is comprised of 2241 extents. Segment SAMPRD.CONF_PF1_FK_I in tablespace PARTITIONED_IDX_01 is comprised of 2181 extents. Segment SAMPRD.CONF_CFS_FK_I in tablespace PARTITIONED_IDX_01 is comprised of 2832 extents. Segment SAMPRD.CONF_PK in tablespace PARTITIONED_IDX_01 is comprised of 1313 extents. Segment SAMPRD.CONF_APROC_FK_I in tablespace PARTITIONED_IDX_01 is comprised of 2249 extents. Segment HERBER.SYS_C0013711 in tablespace USERDATA_01 is comprised of 1078 extents. 
CRITICAL 
Jun 04 2005 10:47:26 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sat Jun 4 12:49:08 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Alert 
The following errors are in the ALERT file : ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7C1A77F8] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7BB277A8], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7C1A77F8] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700787C00] [] [] ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF7BB277A8], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7C1A77F8] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x76007700787C00] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped
CRITICAL 
Jun 04 2005 12:48:35 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Jun 5 00:01:53 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 05 2005 12:01:31 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Jun 5 00:03:59 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 05 2005 12:03:35 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Jun 5 09:28:05 2005 -->
<pre>
Name : cdfonprd_max_extents 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Maximum Extents 
Segment RUNDB_PRD.BNC_RC_FK_I in tablespace RUNDB_INDEX can only allocate 1 additional extents. 
WARNING 
Jun 05 2005 09:26:43 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Sun Jun  5 14;46;34 comment by...ns  -->
<pre>2o to 40 
  1* alter index rundb_prd.bnc_rc_fk_i storage (maxextents 40)</pre>

<!-- Date: Sun Jun 5 14:57:19 2005 -->
<pre>
Name : cdfonprd_max_extents 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Maximum Extents 
Event test "Maximum Extents" is cleared 
CLEARED 
Jun 05 2005 02:56:19 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Sun Jun 5 17:22:09 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

Alert 
The following errors are in the ALERT file : ORA-04030: out of process memory when trying to allocate  bytes (,) ORA-02063: preceding line from CDFOFPR2 ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], []. 
CRITICAL 
Jun 05 2005 05:21:32 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Jun 6 00:01:49 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 06 2005 12:01:31 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Jun 6 00:04:33 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 06 2005 12:03:35 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Jun 6 10:18:40 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-07445: exception encountered: core dump [0000000101DAC2D4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CE38910] [] [] ORA-12805: parallel query server died unexpectedly. 
WARNING 
Jun 06 2005 10:18:35 AM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Jun 6 23:01:53 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-07445: exception encountered: core dump [kolcpinxt()+524] [SIGSEGV] [Address not mapped to object] [0x0] [] [] ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kod objects) ORA-04030: out of process memory when trying to alloca
WARNING 
Jun 06 2005 11:01:37 PM 



</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Jun 7 00:04:57 2005 -->
<pre>
 Tue, 07 Jun 2005 00:01:34 -0500 (CDT)
Received: from mailgw2.fnal.gov ([131.225.111.12])
 by mailav2.fnal.gov (SAVSMTP 3.1.7.47) with SMTP id M2005060700013427681 for
 <cdf_elog@b0dau30.fnal.gov>; Tue, 07 Jun 2005 00:01:34 -0500
Received: from conversion-daemon.mailgw2.fnal.gov by mailgw2.fnal.gov
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 id <0IHP00201700DY@mailgw2.fnal.gov> (original mail from oem-admin@fnal.gov)
 for cdf_elog@b0dau30.fnal.gov; Tue, 07 Jun 2005 00:01:34 -0500 (CDT)
Received: from VdmSMTPSession (odsoem.fnal.gov [131.225.111.58])
 by mailgw2.fnal.gov
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 with SMTP id <0IHP00F6R7AM3L@mailgw2.fnal.gov> for cdf_elog@b0dau30.fnal.gov;
 Tue, 07 Jun 2005 00:01:34 -0500 (CDT)
Date: Tue, 07 Jun 2005 00:01:34 -0500 (CDT)
Date-warning: Date header was inserted by mailgw2.fnal.gov
Subject: EVENT cdfonprd_alert_log CLEARED
To: CDFONLINEMGR <oem-admin@fnal.gov>, CDFONLINEMGR <cdfonoem@fnal.gov>,
        CDFONLINEMGR <cdf_elog@b0dau30.fnal.gov>
Message-id: <0IHP00F6S7AM3L@mailgw2.fnal.gov>
Content-type: text/plain; charset=ISO-8859-1

Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 07 2005 12:01:31 AM 





From oem-admin@fnal.gov  Tue Jun  7 00:04:23 2005
Received: from mailgw1.fnal.gov (mailgw1.fnal.gov [131.225.111.11])
	by b0dau30.fnal.gov (SGI-8.9.3/8.9.3) with ESMTP id AAA30687
	for <cdf_elog@b0dau30.fnal.gov>; Tue, 7 Jun 2005 00:04:23 -0500 (CDT)
From: oem-admin@fnal.gov
Received: from mailav1.fnal.gov (mailav1.fnal.gov [131.225.111.18])
 by mailgw1.fnal.gov
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 with SMTP id <0IHP00E717DT1A@mailgw1.fnal.gov> for cdf_elog@b0dau30.fnal.gov;
 Tue, 07 Jun 2005 00:03:38 -0500 (CDT)
Received: from mailgw2.fnal.gov ([131.225.111.12])
 by mailav1.fnal.gov (SAVSMTP 3.1.7.47) with SMTP id M2005060700033832556 for
 <cdf_elog@b0dau30.fnal.gov>; Tue, 07 Jun 2005 00:03:38 -0500
Received: from conversion-daemon.mailgw2.fnal.gov by mailgw2.fnal.gov
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 id <0IHP00201700DY@mailgw2.fnal.gov> (original mail from oem-admin@fnal.gov)
 for cdf_elog@b0dau30.fnal.gov; Tue, 07 Jun 2005 00:03:38 -0500 (CDT)
Received: from VdmSMTPSession (odsoem.fnal.gov [131.225.111.58])
 by mailgw2.fnal.gov
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 with SMTP id <0IHP00HYH7E2A7@mailgw2.fnal.gov> for cdf_elog@b0dau30.fnal.gov;
 Tue, 07 Jun 2005 00:03:38 -0500 (CDT)
Date: Tue, 07 Jun 2005 00:03:38 -0500 (CDT)
Date-warning: Date header was inserted by mailgw2.fnal.gov
Subject: EVENT cdfofpr2_alert_log CLEARED
To: CDFOFLINEMGR <cdfofoem@fnal.gov>, CDFOFLINEMGR <oem-admin@fnal.gov>,
        CDFOFLINEMGR <cdf_elog@b0dau30.fnal.gov>
Message-id: <0IHP00HYI7E2A7@mailgw2.fnal.gov>
Content-type: text/plain; charset=ISO-8859-1

Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jun 07 2005 12:03:35 AM 



</pre>
<!-- Author: oem-admin (email) -->