<!-- Title: 08:27:14  Mon Nov  7 2005 -->
<!-- Crewchief: New day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity </pre>


<!-- Date: Mon Nov 7 09:40:53 2005 -->
<pre>Dehong, 
 
Group book account has been created on cdf offline prd 
database. Please call anil at X 6098 for the password. 
 
Once , schemas will be created by the user for these accounts, these books  
will be scheduled for instantiating the replication from cdf offline prd to  
cdf replica. 
 
Thanks, 
 
Anil. 
 
 
Hi All,  
 
Kzysztof tells me that these are the three last books to be created 
(this has been decided at the offline spl meeting today).  So, please 
create them. 
 
Thanks, and have a good weekend! 
 
      Petar 
 
 
 
Anil Kumar wrote: 
&gt;  
&gt; Petar, 
&gt;  
&gt; There is request by Dehong to create 3 DFC Private Book accounts. 
&gt; We need direction since from earlier discussion, we were at a  point that 
&gt; there will be no DFC BOOK account since 
&gt; SAM is going production for CDF and DFC & BOOKS will be deprecated in near 
&gt; future. 
&gt;  
&gt; Please let's know . 
&gt;  
&gt; Dehong, 
&gt; Question : If this request got approved, does these books need to be 
&gt; replicated to cdf replica ? 
&gt;  
&gt; Thanks, 
&gt;  
&gt; Anil. 
&gt;  
&gt; ----- Original Message ----- 
&gt; From: "Dehong_Zhang" &lt;dhzhang@fnal.gov&gt; 
&gt; To: &lt;nelly@fnal.gov&gt;; &lt;akumar@fnal.gov&gt; 
&gt; Cc: &lt;litvinse@fnal.gov&gt; 
&gt; Sent: Friday, November 04, 2005 2:49 PM 
&gt; Subject: Re: group accounts for "stntuple" and "tnt" 
&gt;  
&gt; &gt; Hi Anil and Nelly, 
&gt; &gt; 
&gt; &gt; Here is more info -- please create 3 group accounts: 
&gt; &gt; 
&gt; &gt; cdfpstn -- write access to rlc, harper, ahamil, ccuenca, murat, dhzhang 
&gt; &gt; cdfptnt -- write access to danielw, dhzhang 
&gt; &gt; cdfpbnt -- write access to paus, dhzhang 
&gt; &gt; 
&gt; &gt; Sorry for the confusion. 
&gt; &gt; 
&gt; &gt; Thanks and best regards, 
&gt; &gt; Dehong 
&gt; &gt; 
&gt; &gt; 
&gt; &gt; 
&gt; &gt; 
&gt; &gt; 
&gt; &gt; On Fri, 4 Nov 2005, Dehong_Zhang wrote: 
&gt; &gt; 
&gt; &gt;&gt; Hi Anil and Nelly, 
&gt; &gt;&gt; 
&gt; &gt;&gt; Could you please help to create these 2 group accounts for the CDF 
&gt; &gt;&gt; prd database?  I will use them once to create their new DFC books, 
&gt; &gt;&gt; then they should maintain for themselves. 
&gt; &gt;&gt; 
&gt; &gt;&gt; Best regards, 
&gt; &gt;&gt; Dehong 
</pre>
<!-- Author: akumar -->


<!-- Date: Mon Nov 7 12:47:54 2005 -->
<pre>machine:  fcdfora6     instance:   cdfstrm1 
 
we've lost a whole disk on fcdfora6   seems to be /cdf/dbs08 
 
error in alert log altho' we didn't get an event?? so investigating this!    
 
but steve is working with sun to try to resolve! 
 
Mon Nov  7 12:29:13 2005 
KCF: write/open error block=0x6b0b9 online=1 
     file=34 /cdf/dbs08/oradata/cdfstrm1/rundb_index_02.dbf 
     error=27072 txt: 'Linux Error: 5: Input/output error 
Additional information: 438456' 
Automatic datafile offline due to write error on 
file 34: /cdf/dbs08/oradata/cdfstrm1/rundb_index_02.dbf 
KCF: write/open error block=0x6888d online=1 
     file=32 /cdf/dbs08/oradata/cdfstrm1/rundb_index_01.dbf 
     error=27072 txt: 'Linux Error: 5: Input/output error 
</pre>
<!-- Author: nstanfield/skovich -->
<!-- Comment: Mon Nov  7 19;24;08 comment by...nstanfield/akumar  -->
<pre>fcdfora6~cdfstrm1 will remain down for the evening and connections are being failed over to the cdf offline production database 

we just looked at the sar data for ~fcdfora4 & its 65% idle 
so it is supporting the additional load 

we found additional corruption in the online redo log on /cdf/dbs02 which is required to open the database

we will attempt to get the mirror copy tomorrow a.m.
and recover, otherwise we will attempt an incomplete recovery, deploying a streams workaround to save current stream'g, and if none of these scenarious work we will have to reinstantiate replication onto cdfstrm1 

</pre>
<!-- Date: Mon Nov 7 13:03:31 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-12152: TNS:unable to send break message ORA-02063: preceding line from CDFSTRM1 ORA-02068: following severe error from CDFSTRM1 ORA-12570: TNS:packet reader failure. 
WARNING 
Nov 07 2005 01:02:30 PM 



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


<!-- Date: Mon Nov 7 13:04:20 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 
Nov 07 2005 01:03:31 PM 



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


<!-- Date: Mon Nov 7 13:08:25 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-12535: TNS:operation timed out. 
WARNING 
Nov 07 2005 01:07:30 PM 



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


<!-- Date: Mon Nov 7 13:16:43 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-12535: TNS:operation timed out. 
WARNING 
Nov 07 2005 01:12:30 PM 



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


<!-- Date: Mon Nov 7 13:16:43 2005 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace USERTEMP_01 is 82.30% full.  2899432.0 KBytes of free space remain. 
CRITICAL 
Nov 07 2005 01:13:36 PM 



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


<!-- Date: Mon Nov 7 13:18:00 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-12535: TNS:operation timed out. 
WARNING 
Nov 07 2005 01:17:30 PM 



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


<!-- Date: Mon Nov 7 13:22:56 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-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01  ORA-02068: following severe error from CDFSTRM1 ORA-01033: ORACLE initialization or shutdown in progress. 
WARNING 
Nov 07 2005 01:22:30 PM 



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


<!-- Date: Mon Nov 7 13:24:08 2005 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Tablespace Full 
Event test "Tablespace Full" is cleared 
CLEARED 
Nov 07 2005 01:23:36 PM 



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


<!-- Date: Mon Nov 7 13:32:55 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-01033: ORACLE initialization or shutdown in progress. 
WARNING 
Nov 07 2005 01:32:30 PM 



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


<!-- Date: Mon Nov 7 13:47:52 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-01033: ORACLE initialization or shutdown in progress. 
WARNING 
Nov 07 2005 01:47:30 PM 



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


<!-- Date: Mon Nov 7 14:18:01 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-01033: ORACLE initialization or shutdown in progress. 
WARNING 
Nov 07 2005 02:17:30 PM 



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


<!-- Date: Mon Nov 7 15:28:28 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-12535: TNS:operation timed out. 
WARNING 
Nov 07 2005 03:27:30 PM 



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


<!-- Date: Mon Nov 7 17:33:03 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-12541: TNS:no listener. 
WARNING 
Nov 07 2005 05:32:30 PM 



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


<!-- Date: Mon Nov 7 19:15:10 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: 20488 
CRITICAL 
Nov 07 2005 07:12:44 PM 



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



<!-- Date: Mon Nov 7 19:29:04 2005 -->
<pre>
Name : cdfofpr2_apply_msg_spill_alert 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 16 
CLEARED 
Nov 07 2005 07:27:44 PM 



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


<!-- Date: Mon Nov 7 21:52:45 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-12541: TNS:no listener. 
WARNING 
Nov 07 2005 09:52:30 PM 



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


<!-- Date: Tue Nov 8 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 
Nov 08 2005 12:02:30 AM 



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


<!-- Date: Tue Nov 8 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 
Nov 08 2005 12:09:49 AM 



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


<!-- Date: Tue Nov 8 05:17:57 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-01555 caused by SQL statement below (Query Duration=4552 sec, SCN: 0x056e.e418ee37):. 
WARNING 
Nov 08 2005 05:17:30 AM 



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


<!-- Date: Tue Nov 8 06:23:03 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-12541: TNS:no listener. 
WARNING 
Nov 08 2005 06:22:30 AM 



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


<!-- Date: Tue Nov 8 07:20:38 2005 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace USERTEMP_01 is 80.08% full.  3264088.0 KBytes of free space remain. 
CRITICAL 
Nov 08 2005 07:18:43 AM 



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


<!-- Date: Tue Nov 8 07:28:55 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-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Nov 08 2005 07:27:30 AM 



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


<!-- Date: Tue Nov 8 07:28:55 2005 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Tablespace Full 
Event test "Tablespace Full" is cleared 
CLEARED 
Nov 08 2005 07:28:42 AM 



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