<!-- Title: 09:24:30  Fri Mar 25 2005 -->
<!-- Crewchief: New day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Fri Mar 25 12:25:18 2005 -->
<pre>RUNDB@cdfondev has been refreshed from RUNDB@cdfonprd  
 
Timings : Export 4 Hours  
          Import Data : 8 Hours  
          Indexes       2 Hours  
 
 
</pre>
<!-- Author: akumar -->


<!-- Date: Fri Mar 25 15:11:21 2005 -->
<pre>Refresh of CDFTRIG_DEV@cdfondev  done from CDFTRIG_PRD@cdfonprd  
 
Time taken : 20 Minutes </pre>
<!-- Author: akumar -->


<!-- Date: Fri Mar 25 16:04:42 2005 -->
<pre>Hi, 
The torch is being passed, please give write priv for the 
five tables: SIALIGNx where x is FRAME, BARREL, LADDER, WAFER and 
WARP to Aart Heijboer, username aart, in cdfonprd.  There is probably an 
ALIGNMENT_WRITE or similar role appropriate for this.  I believe I 
was always externally authenticated since I never used a password, 
so he should probably be set up the same way.  Thank you. 
 
Ray 
 
 Ray Culbertson  CDF/FNAL  rlc@fnal.gov  630-840-6744  Trailers 170F (MS318 
 
 
&gt;Created the user aart with ALIGNMENT_WRITE role . And this account is externally authenticated.   And has been subscribed to cdfdb-users mailing list </pre>
<!-- Author: akumar -->

<!-- Date: Fri Mar 25 17:34:33 2005 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-02050: transaction 10.36.1347062 rolled back, some remote DBs may be in-doubt ORA-02068: following severe error from CDFOFPR1 ORA-03113: end-of-file on communication channel. 
WARNING 
Mar 25 2005 05:34:06 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Fri Mar 25 20;43;08 comment by...ns  -->
<pre>no action taken  transaction rolled back

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL&gt; select * from dba_2pc_pending;

no rows selected
</pre>

<!-- Date: Sat Mar 26 00:04:47 2005 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Mar 26 2005 12:03:48 AM 



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


<!-- Date: Sat Mar 26 00:04:47 2005 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Mar 26 2005 12:04:00 AM 



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


<!-- Date: Sat Mar 26 17:34:23 2005 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-02050: transaction 11.23.191708 rolled back, some remote DBs may be in-doubt ORA-02068: following severe error from CDFOFPR1 ORA-03113: end-of-file on communication channel. 
WARNING 
Mar 26 2005 05:34:00 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Sat Mar 26 20;56;31 comment by...ns  -->
<pre>no action - transaction rolled back

SQL&gt; select * from dba_2pc_pending;

no rows selected</pre>

<!-- Date: Sun Mar 27 00:04:38 2005 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Mar 27 2005 12:03:48 AM 



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


<!-- Date: Sun Mar 27 00:04:38 2005 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Mar 27 2005 12:04:03 AM 



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


<!-- Date: Mon Mar 28 00:05:32 2005 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Mar 28 2005 12:03:48 AM 



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


<!-- Date: Mon Mar 28 00:05:32 2005 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Mar 28 2005 12:04:00 AM 



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


<!-- Date: Mon Mar 28 06:34:15 2005 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-02050: transaction 4.35.2232048 rolled back, some remote DBs may be in-doubt ORA-02068: following severe error from CDFOFPR1 ORA-03113: end-of-file on communication channel. 
WARNING 
Mar 28 2005 06:34:00 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Mon Mar 28 07;32;44 comment by...ns -->
<pre>no action transaction rolled back </pre>