<!-- Title: 12:42:05  Fri Jun 24 2005 -->
<!-- Crewchief: akumar -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>New Activity 
</pre>


<!-- Date: Fri Jun 24 12:43:01 2005 -->
<pre>Name : cdfstrm1_alert_log  
Target Name : cdfstrm1.fnal.gov  
Target Type : Database  
Node Name : fcdfora6.fnal.gov  
Status : WARNING  
 
Alert  
The following errors are in the ALERT file : ORA-12571: TNS:packet writer failure.  
WARNING  
Jun 24 2005 11:16:28 AM  
 
Details :  
This happens if old client version being used. 
 
*** 2005-06-24 11:13:05.041 
*** SESSION ID:(52.29939) 2005-06-24 11:13:05.040 
FATAL ERROR IN TWO-TASK SERVER: error = 12152 
*** 2005-06-24 11:13:05.041 
ksedmp: internal or fatal error 
ORA-12571: TNS:packet writer failure 
Current SQL statement for this session: 
SELECT chipKey,ped1,ped2,ped3,ped4,noise1,noise2,noise3,noise4,dnoise FROM  
SICHIPPED where CID = 148368 ORDER BY chipKey 
 
Detail from logintraces for SID 52 and serial# 29939 
SQL&gt; select * from logintraces where sid = 52 and serial# = 29939 
 
     LT_ID USERNAME                       OSUSER 
---------- ------------------------------ ------------------------------ 
DB_NAME 
------------------------------ 
MACHINE 
---------------------------------------------------------------- 
TERMINAL                       PROGRAM 
------------------------------ ------------------------------------------------ 
PROCESS   IP_ADDRESS 
--------- ------------------------------ 
NETWORK_PROTOCOL 
-------------------------------------------------------------------------------- 
LOGON_TIM        SID    SERIAL# LOGOFF_TI   CPU_USED 
--------- ---------- ---------- --------- ---------- 
CLIENT_INFO 
---------------------------------------------------------------- 
 182693961 CDF_READER                     cafuser2 
cdfstrm1 
node8 
                               ./cdfSim@node8 (TNS V1-V3) 
3986      128.6.27.135 
tcp 
24-JUN-05         52      29939 
 
</pre>
<!-- Author: akumar -->


<!-- Date: Fri Jun 24 12:48:13 2005 -->
<pre>Name : cdfstrm1_alert_log  
Target Name : cdfstrm1.fnal.gov  
Target Type : Database  
Node Name : fcdfora6.fnal.gov  
Status : WARNING  
 
Alert  
The following errors are in the ALERT file : ORA-12571: TNS:packet writer failure.  
WARNING  
Jun 24 2005 11:31:28 AM  
 
 
Details :  
This happens if old client version being used. 
 
*** 2005-06-24 11:29:13.818 
*** SESSION ID:(44.46116) 2005-06-24 11:29:13.818 
FATAL ERROR IN TWO-TASK SERVER: error = 12152 
*** 2005-06-24 11:29:13.818 
ksedmp: internal or fatal error 
ORA-12571: TNS:packet writer failure 
Current SQL statement for this session: 
SELECT runNumber,myronMode,l1Early,cardName,id0,id1,fibChannel,bitStream  
FROM   SVX_CONFIGURATIONS  WHERE BITSTREAM IS NOT NULL AND RUNNUMBER =  
151435 
----- Call Stack Trace ----- 
 
Details of session  SID 44 and serial # 46116 
 
SQL&gt; select * from logintraces where sid=44 and serial# = 46116; 
 
     LT_ID USERNAME                       OSUSER 
---------- ------------------------------ ------------------------------ 
DB_NAME 
------------------------------ 
MACHINE 
---------------------------------------------------------------- 
TERMINAL                       PROGRAM 
------------------------------ ------------------------------------------------ 
PROCESS   IP_ADDRESS 
--------- ------------------------------ 
NETWORK_PROTOCOL 
-------------------------------------------------------------------------------- 
LOGON_TIM        SID    SERIAL# LOGOFF_TI   CPU_USED 
--------- ---------- ---------- --------- ---------- 
CLIENT_INFO 
---------------------------------------------------------------- 
 182696059 CDF_READER                     cafuser2 
cdfstrm1 
node24.hexfarm.rutgers.edu 
                               ./cdfSim@node24.hexfarm.rutgers.edu (TNS  
V1-V3) 
21292     128.6.27.135 
tcp 
24-JUN-05         44      46116 
 
 
 
 
</pre>
<!-- Author: akumar -->

<!-- Date: Fri Jun 24 16:17:19 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 24 2005 04:16:20 PM 



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


<!-- Date: Fri Jun 24 16:20:27 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: cdfdaq RUN_USER 14 10520 rc.acnet.AcnetMonitor b0dap85a SELECT NVL(VALUE,'8.0')   FROM V$PARAMETER  WHERE NAME = 'compatible' 10.0166666666666666666666666666666666674 
CRITICAL 
Jun 24 2005 04:20:01 PM 



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


<!-- Date: Fri Jun 24 16:36:32 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 3 
CRITICAL 
Jun 24 2005 04:36:15 PM 



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


<!-- Date: Fri Jun 24 17:09:07 2005 -->
<pre>
Name : cdfonprd_capture_msg_spill_alert  
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 3720 
CRITICAL 
Jun 24 2005 05:08:51 PM 



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


<!-- Date: Fri Jun 24 18:02:56 2005 -->
<pre>
Name : cdfofpr2_apply_msg_spill_alert 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 13925 
CRITICAL 
Jun 24 2005 06:01:17 PM 



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


<!-- Date: Fri Jun 24 20:05:27 2005 -->
<pre>
Name : cdfofpr2_stream_heartbeat_alert  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 7485.999999999999999999999999999999999998 
WARNING 
Jun 24 2005 08:04:46 PM 



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


<!-- Date: Fri Jun 24 22:05:25 2005 -->
<pre>
Name : cdfofpr2_stream_heartbeat_alert  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 14686 
CRITICAL 
Jun 24 2005 10:04:46 PM 



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


<!-- Date: Sat Jun 25 00:03:45 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 25 2005 12:03:35 AM 



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


<!-- Date: Sat Jun 25 00:11:41 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 25 2005 12:09:49 AM 



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


<!-- Date: Sat Jun 25 00:16:50 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 25 2005 12:16:18 AM 



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


<!-- Date: Sat Jun 25 04:30:20 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: cdfdaq RUN_USER 14 10634 rc.acnet.AcnetMonitor b0dap85a SELECT NVL(VALUE,'8.0')   FROM V$PARAMETER  WHERE NAME = 'compatible' 6.0333333333333333333333333333333333336 
CRITICAL 
Jun 25 2005 04:29:59 AM 



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


<!-- Date: Sat Jun 25 04:32:09 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 25 2005 04:31:16 AM 



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


<!-- Date: Sat Jun 25 06:42:05 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 25 2005 06:41:16 AM 



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


<!-- Date: Sat Jun 25 22:25:16 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: cdfdaq RUN_USER 88 40198 rc.acnet.AcnetMonitor b0dap85a INSERT INTO BEAM_CONDITIONS_FULL (CREATETIME,FRONTENDTIME,OUTTMP,IBEAM_A,STCKRT,TEVSTORE,ERING,IBEAM,CLDRST,STRDUR,FWDEL,B0Q5,B0ILUM,B0LLUM,B0TLUM,B0TLIV,B0PLOS,B0ALOS,BQUAKE,LUMLIF,LOSTP,LOSTPB,LOSTPH,SVRAD0,SVRAD1,SVRAD2,SVRAD3,SVBLA1,SVBLA2,SVBLB1,SVBLB2,FBIPNG,FBIANG,FBIPWG,FBIAWG,TPOT1M,TPOT2M,TPOT3M,RFSUM,RFSUMA,CDFDN,B0XIP,B0YIP,B0SIGX,B0SIGY,B0DX,B0DY,B0XTD,B0YTD,B0SXTD,B0SYTD,B0DXTD,B0DYTD,B0PHSM,B0PHN,B0PHT,B0PHS,B0PHB,B0AHSM,B0AHN,B0AHT,B0AHS,B0AHB,B0RAT1,B0RAT2,B0RAT3,B0RAT4,B0RAT5,B0RAT6,B0RAT7,B0PBSM,B0PBN,B0PBT,B0PBS,B0PBB,B0ABSM,B0ABN,B0ABT,B0ABS,B0ABB,B0PAGC,B0AAGC,B0PLB,B0ALB,AGISUM,AGIGI1,AGIGI2,AGIGI3,SLPAG1,SLPAG2,SLPAG3,SLPAH,SBDMS,SBDPWS,SBDPIS,SBDPES,PLBRIS,SBDAWS,SBDAIS,SBDAES,E1TC3R,E1EVUH,E0LTOT,E0LABT,L1COLI,SVTDSX,SVTDSY,SVTDDX,SVTDDY,SVTGVL,SVTGX,SVTGXE,SVTGY,SVTGYE,SVTGWX,SVGWXE,SVTGWY,SVGWYE,SVTDX,SVTDXE,SVTDY,SVTDYE) VALUES (SYSDATE,1119755758,69.837746,47.749448,11.918575,4234,979
CRITICAL 
Jun 25 2005 10:24:52 PM 



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


<!-- Date: Sat Jun 25 22:27:20 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 25 2005 10:26:09 PM 



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


<!-- Date: Sun Jun 26 00:04:36 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 26 2005 12:03:35 AM 



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


<!-- Date: Sun Jun 26 00:10: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 26 2005 12:09:53 AM 



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


<!-- Date: Sun Jun 26 01:31:34 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 26 2005 01:31:13 AM 



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


<!-- Date: Sun Jun 26 02:15:01 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: cdfdaq RUN_USER 48 1498 rc.acnet.AcnetMonitor b0dap85a INSERT INTO BEAM_CONDITIONS_FULL (CREATETIME,FRONTENDTIME,OUTTMP,IBEAM_A,STCKRT,TEVSTORE,ERING,IBEAM,CLDRST,STRDUR,FWDEL,B0Q5,B0ILUM,B0LLUM,B0TLUM,B0TLIV,B0PLOS,B0ALOS,BQUAKE,LUMLIF,LOSTP,LOSTPB,LOSTPH,SVRAD0,SVRAD1,SVRAD2,SVRAD3,SVBLA1,SVBLA2,SVBLB1,SVBLB2,FBIPNG,FBIANG,FBIPWG,FBIAWG,TPOT1M,TPOT2M,TPOT3M,RFSUM,RFSUMA,CDFDN,B0XIP,B0YIP,B0SIGX,B0SIGY,B0DX,B0DY,B0XTD,B0YTD,B0SXTD,B0SYTD,B0DXTD,B0DYTD,B0PHSM,B0PHN,B0PHT,B0PHS,B0PHB,B0AHSM,B0AHN,B0AHT,B0AHS,B0AHB,B0RAT1,B0RAT2,B0RAT3,B0RAT4,B0RAT5,B0RAT6,B0RAT7,B0PBSM,B0PBN,B0PBT,B0PBS,B0PBB,B0ABSM,B0ABN,B0ABT,B0ABS,B0ABB,B0PAGC,B0AAGC,B0PLB,B0ALB,AGISUM,AGIGI1,AGIGI2,AGIGI3,SLPAG1,SLPAG2,SLPAG3,SLPAH,SBDMS,SBDPWS,SBDPIS,SBDPES,PLBRIS,SBDAWS,SBDAIS,SBDAES,E1TC3R,E1EVUH,E0LTOT,E0LABT,L1COLI,SVTDSX,SVTDSY,SVTDDX,SVTDDY,SVTGVL,SVTGX,SVTGXE,SVTGY,SVTGYE,SVTGWX,SVGWXE,SVTGWY,SVGWYE,SVTDX,SVTDXE,SVTDY,SVTDYE) VALUES (SYSDATE,1119769615,64.572196,25.429142,11.204105,4234,979.
CRITICAL 
Jun 26 2005 02:14:49 AM 



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


<!-- Date: Sun Jun 26 02:16:40 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 26 2005 02:16:07 AM 



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


<!-- Date: Sun Jun 26 02:48:03 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 26 2005 02:46:10 AM 



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


<!-- Date: Sun Jun 26 18:27:25 2005 -->
<pre>
Name : cdfonprd_max_extents 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Maximum Extents 
Segment CDFTRIG_PRD.TBS_PTS_FK_I in tablespace CDFTRIG_IDX can only allocate 1 additional extents. 
WARNING 
Jun 26 2005 06:26:12 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Mon Jun 27 07;48;34 comment by...ns  -->
<pre>contacted kirsten... went ahead and changed since it's prd & altered a while back..

ALTER INDEX "CDFTRIG_PRD"."TBS_PTS_FK_I" 
    STORAGE ( MAXEXTENTS 200)</pre>
<!-- Date: Mon Jun 27 00:03:54 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 27 2005 12:03:35 AM 



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


<!-- Date: Mon Jun 27 00:10:08 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 27 2005 12:09:54 AM 



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