<!-- Title: 13:03:47  Tue May 17 2005 -->
<!-- Crewchief: New day  -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity </pre>


<!-- Date: Tue May 17 13:04:23 2005 -->
<pre>boucing cdfondev to set per earlier request from bill badgett 
 
alter session set time_zone = 'US/Central' ;  
 
 
</pre>
<!-- Author: nstanfield  -->
<!-- Comment: Tue May 17 14;15;31 comment by...nstanfield  -->
<pre>on cdfondev  database  --&gt;  we investigated and set dbtimezone to US/Central vs 'cdt -0.500' or 'cst -0.600'     

SQL&gt; alter database set time_zone = 'US/Central' ;

SQL&gt; select dbtimezone from dual;

DBTIMEZONE
-----------
US/Central


Applications(Bill requestor) should test & if all is well I will change this parameter on cdfonint as well.

Currently on cdfonprd & cdfofprd it's 

DBTIME 
------ 
-05:00 


Altho' on cdfofdev & cdfofint

DBTIME
------
+00:00

Setting it to US/Central (requires a bounce of the db) and
takes into consideration CDT & CST time.  </pre>

<!-- Comment: Tue May 17 16;20;41 comment by...ns  -->
<pre>cdfonint also set to US/Central </pre>

<!-- Date: Tue May 17 19:11:58 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-00600: internal error code, arguments: [kohfrm505], [], [], [], [], [], [], [] ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kolcpcon datatds) ORA-00600: internal error code, arguments: [koiofre970], [], [], [], [], [], [], [] ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,koicnfadt adt attr) ORA-00600: internal error code, arguments: [kohfrm505], [], [], [], [], [], [], [] ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,kolcpcon datatds) ORA-07445: exception encountered: core dump [kohatd()+1296] [SIGSEGV] [Address not mapped to object] [0xFFFFFFF0] [] [] ORA-00600: internal error code, arguments: [koiofre970], [], [], [], [], [], [], [] ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,koicnfadt adt attr) ORA-00600: internal error code, arguments: [kohfrm505], [], [], [], [], [], [], [] 
CRITICAL 
May 17 2005 07:11:31 PM 



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


<!-- Date: Wed May 18 00:02:40 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 
May 18 2005 12:01:31 AM 





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


<!-- Date: Wed May 18 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 
May 18 2005 12:03:35 AM 



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


<!-- Date: Wed May 18 10:45:23 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: [kghGetHpSz1], [0xFFFFFFFF7C96B958], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078AEF8] [] [] ORA-00600: internal error code, arguments: [kghGetHpSz1], [0xFFFFFFFF7C96B958], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078AEF8] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078AEF8] [] [] ORA-00600: internal error code, arguments: [kghGetHpSz1], [0xFFFFFFFF7C96B958], [], [], [], [], [], [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078AEF8] [] [] ORA-07445: exception encountered: core dump [0000000101DB136C] [SIGSEGV] [Address not mapped to object] [0x7600770078AEF8] [] []
CRITICAL 
May 18 2005 10:43:35 AM 



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


<!-- Date: Wed May 18 10:55:34 2005 -->
<pre>
Name : cdfofpr2_capture_errors  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 0 
CRITICAL 
May 18 2005 10:55:08 AM 



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


<!-- Date: Wed May 18 10:56:31 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 
May 18 2005 10:56:05 AM 



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


<!-- Date: Wed May 18 10:59:42 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] [0xFFFFFFFF7D278060] [] [] ORA-12805: parallel query server died unexpectedly. 
WARNING 
May 18 2005 10:58:35 AM 



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


<!-- Date: Wed May 18 11:01:46 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 
May 18 2005 11:01:05 AM 



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


<!-- Date: Wed May 18 11:03:51 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 
May 18 2005 11:01:58 AM 



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


<!-- Date: Wed May 18 12:25:37 2005 -->
<pre>
Name : cdfofpr2_capture_errors  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 1 
CLEARED 
May 18 2005 12:25:08 PM 



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


<!-- Date: Wed May 18 12:29:29 2005 -->
<pre>
Name : cdfofpr2_capture_msg_spill_alert 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 5312 
CRITICAL 
May 18 2005 12:29:10 PM 



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


<!-- Date: Wed May 18 12:31:34 2005 -->
<pre>
Name : cdfofpr2_capture_latency_alert  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 5683.999999999999999999999999999999999997 
CRITICAL 
May 18 2005 12:31:01 PM 



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


<!-- Date: Wed May 18 12:40:45 2005 -->
<pre>
Name : cdfofpr2_capture_errors  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 0 
CRITICAL 
May 18 2005 12:40:08 PM 



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


<!-- Date: Wed May 18 12:50:26 2005 -->
<pre>
Name : cdfofpr2_capture_errors  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 1 
CLEARED 
May 18 2005 12:50:08 PM 



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


<!-- Date: Wed May 18 12:51:30 2005 -->
<pre>
Name : cdfofpr2_capture_latency_alert  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 3250.999999999999999999999999999999999999 
CRITICAL 
May 18 2005 12:51:01 PM 



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


<!-- Date: Wed May 18 13:06:10 2005 -->
<pre>
Name : cdfofpr2_capture_latency_alert  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 3180.999999999999999999999999999999999997 
CRITICAL 
May 18 2005 01:06:01 PM 



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


<!-- Date: Wed May 18 13:11:08 2005 -->
<pre>
Name : cdfofpr2_capture_latency_alert  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value:  
CLEARED 
May 18 2005 01:11:01 PM 



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


<!-- Date: Wed May 18 13:30:32 2005 -->
<pre>
Name : cdfofpr2_capture_msg_spill_alert 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 15 
CLEARED 
May 18 2005 01:29:10 PM 



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


<!-- Date: Wed May 18 13:32:36 2005 -->
<pre>
Name : cdfofpr2_capture_latency_alert  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 1462 
CRITICAL 
May 18 2005 01:31:01 PM 



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


<!-- Date: Wed May 18 13:41:10 2005 -->
<pre>
Name : cdfofpr2_capture_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 
May 18 2005 01:41:01 PM 



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



<!-- Date: Wed May 18 20:07:11 2005 -->
Cut ddls on cdfonprd for trigger db changes.  The cut was to  
modify the precision on 11 columns in the trigger database in tables TRIGGER_NAMES, TRIGGER_PATHS, DEPENDENCIES and CUTS_AND_PARAMETERS.  
<!-- Author: Kirsten -->
<!-- Comment: Wed May 18 20;26;51 comment by...ns  -->
<pre>i checked the status of stream'g to cdfofpr2 & cdfstrm1 and i 
also checked the cdftrig tables columns which kirsten changed,  columns match & data is up-to-date...</pre>

<!-- Date: Thu May 19 00:01:59 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 
May 19 2005 12:01:31 AM 



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


<!-- Date: Thu May 19 00:04:13 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 
May 19 2005 12:03:35 AM 



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