<!-- Title: 06:50:55  Wed Jul  6 2005 -->
<!-- Crewchief: New day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Wed Jul 6 07:08:46 2005 -->
<pre>added user lucchesi to cdfofdev and cdfofint. please call 630.840.3637 for pwd. 
user lucchesi already existed on cdfofprd with sam shifter roles, no change on that instance.</pre>
<!-- Author: jtrumbo -->


<!-- Date: Wed Jul 6 10:04:09 2005 -->
<pre>fcdfora6 cdfstrm1  patch 4398475   to resolve 
exception encountered  core dump [kgh_heap_sizes()+194]  
 
successfully applied to fcdfora3 & fcdfora5   
</pre>
<!-- Author: ns  -->
<!-- Comment: Wed Jul  6 10;30;33 comment by...ns  -->
<pre>patch completed 

before
        load averages: 1.68, 2.85, 2.88 10:14:32
        127 processes: 126 sleeping, 1 on cpu

after
        load averages: 2.51, 2.70, 2.75 10:25:11
        128 processes: 125 sleeping, 3 on cpu

</pre>
<!-- Date: Wed Jul 6 10:20:14 2005 -->
<pre>
Name : cdfofpr2_propagation_hung  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: 1 
CRITICAL 
Jul 06 2005 10:19:17 AM 



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


<!-- Date: Wed Jul 6 10:23:49 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-02068: following severe error from CDFSTRM1 ORA-03114: not connected to ORACLE ORA-02068: following severe error from CDFSTRM1 ORA-03113: end-of-file on communication channel ORA-02068: following severe error from CDFSTRM1 ORA-03113: end-of-file on communication channel ORA-12541: TNS:no listener ORA-12541: TNS:no listener ORA-12541: TNS:no listener. 
WARNING 
Jul 06 2005 10:23:35 AM 



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


<!-- Date: Wed Jul 6 10:29:46 2005 -->
<pre>
Name : cdfofpr2_propagation_hung  
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Jul 06 2005 10:29:17 AM 



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



<!-- Date: Wed Jul 6 14:16: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: herber CDF_READER 136 62015 sqlplus@fcdflnx6.fnal.gov (TNS V1-V3) fcdflnx6.fnal.gov select count(*)  from data_files where (data_files.file_id) in ( select data_files.file_id  from data_files,       param_values param_values##141,       param_types param_types##141,       param_categories param_categories##141,       RUNS,       data_files_param_values data_files_param_values##141,       data_files_runs where param_values##141.param_type_id = param_types##141.param_type_id   and param_values##141.param_value_id =       data_files_param_values##141.param_value_id   and data_files.file_id = data_files_param_values##141.file_id   and param_types##141.param_category_id =       param_categories##141.param_category_id   and runs.run_id = data_files_runs.run_id   and data_files.file_id = data_files_runs.file_id   and ((param_values##141.param_value  = 'aphysr')   and (param_types##141.param_type  = 'dataset')   and (param_categories##141.param_category  = 'cdf')   and RUNS.RU
CRITICAL 
Jul 06 2005 02:16:10 PM 



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


<!-- Date: Wed Jul 6 14:18:49 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 
Jul 06 2005 02:18:09 PM 



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


<!-- Date: Wed Jul 6 14:38:38 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 
Jul 06 2005 02:38:13 PM 



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


<!-- Date: Wed Jul 6 15:09:10 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] [0xFFFFFFFF7B1A5E70] [] [] ORA-12805: parallel query server died unexpectedly. 
WARNING 
Jul 06 2005 03:08:35 PM 



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


<!-- Date: Thu Jul 7 00:03:55 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 
Jul 07 2005 12:03:35 AM 



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


<!-- Date: Thu Jul 7 00:14:14 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 
Jul 07 2005 12:09:49 AM 



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


<!-- Date: Thu Jul 7 02:20:48 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()+520] [SIGSEGV] [Address not mapped to object] [0xFFFFFFDC] [] [] 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
WARNING 
Jul 07 2005 02:19:49 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Thu Jul  7 06;45;18 comment by...ns  -->
<pre>for now we  simply tracking these errors ... we did open a Tar 4460230.993  & it seems they have a INTERNAL bug & a fix for this in oracle 10 ...  we agreed to track these since we are not aware of any impact & update tar later if we need to proceed with an action </pre>