<!-- Title: 12:10:25  Mon Feb  6 2006 -->
<!-- Crewchief: New day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Mon Feb 6 12:11:33 2006 -->
<pre>b0dau36 rebuild continues altho' we are troubleshooting some performance issues.     
 
effort continues & there will be an interruption to the cdfondev & cdfonint instances this p.m.   </pre>
<!-- Author: nstanfield  -->

<!-- Date: Mon Feb 6 12:34:13 2006 -->
<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 71.32% full.  4699600.0 KBytes of free space remain. 
CRITICAL 
Feb 06 2006 12:33:28 PM 



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


<!-- Date: Mon Feb 6 12:43:13 2006 -->
<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 
Feb 06 2006 12:42:30 PM 



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


<!-- Date: Mon Feb 6 12:44:24 2006 -->
<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 
Feb 06 2006 12:43:27 PM 



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


<!-- Date: Mon Feb 6 13:09:14 2006 -->
<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 76.94% full.  3777688.0 KBytes of free space remain. 
CRITICAL 
Feb 06 2006 01:08:28 PM 



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


<!-- Date: Mon Feb 6 13:17:39 2006 -->
<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 
Feb 06 2006 01:17:30 PM 



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


<!-- Date: Mon Feb 6 13:18:42 2006 -->
<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 
Feb 06 2006 01:18:27 PM 



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



<!-- Date: Mon Feb 6 13:35:58 2006 -->
<pre>bonnie tests done, /etc/system copy made, /etc/system file changed to  
put in parameters from nelly. 
 
going to reboot b0dau36 now. 
 
</pre>
<!-- Author: maurine -->

<!-- Date: Mon Feb 6 17:09:30 2006 -->
<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.41% full.  2881456.0 KBytes of free space remain. 
CRITICAL 
Feb 06 2006 05:08:29 PM 



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


<!-- Date: Mon Feb 6 17:17:55 2006 -->
<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 
Feb 06 2006 05:17:30 PM 



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


<!-- Date: Mon Feb 6 17:18:44 2006 -->
<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 
Feb 06 2006 05:18:28 PM 



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


<!-- Date: Mon Feb 6 17:38:55 2006 -->
<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 74.53% full.  4173160.0 KBytes of free space remain. 
CRITICAL 
Feb 06 2006 05:38:27 PM 



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


<!-- Date: Mon Feb 6 17:47:42 2006 -->
<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 
Feb 06 2006 05:47:30 PM 



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


<!-- Date: Mon Feb 6 17:49:46 2006 -->
<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 
Feb 06 2006 05:48:27 PM 



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


<!-- Date: Tue Feb 7 00:03:20 2006 -->
<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 
Feb 07 2006 12:02:30 AM 



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


<!-- Date: Tue Feb 7 00:10:52 2006 -->
<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 
Feb 07 2006 12:09:49 AM 



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


<!-- Date: Tue Feb 7 06:38:45 2006 -->
<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 77.66% full.  3659560.0 KBytes of free space remain. 
CRITICAL 
Feb 07 2006 06:38:32 AM 



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


<!-- Date: Tue Feb 7 06:49:06 2006 -->
<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 
Feb 07 2006 06:47:30 AM 



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


<!-- Date: Tue Feb 7 06:49:06 2006 -->
<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 
Feb 07 2006 06:48:30 AM 



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


<!-- Date: Tue Feb 7 07:14:10 2006 -->
<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 79.83% full.  3305176.0 KBytes of free space remain. 
CRITICAL 
Feb 07 2006 07:13:35 AM 



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


<!-- Date: Tue Feb 7 07:23:02 2006 -->
<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 
Feb 07 2006 07:22:30 AM 



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


<!-- Date: Tue Feb 7 07:23:45 2006 -->
<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 
Feb 07 2006 07:23:35 AM 



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



<!-- Date: Tue Feb 7 08:39:21 2006 -->
<pre>cdfondev and cdfonint databases will be going down within the next 30 minutes. they will be down till ~noon. we will be performing some tests on the disks on b0dau36 to see if we can improve access times. </pre>
<!-- Author: jtrumbo -->

<!-- Date: Tue Feb 7 09:46:50 2006 -->
<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 
Feb 07 2006 09:46:32 AM 



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


<!-- Date: Tue Feb 7 09:47:22 2006 -->
<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: hmon CDF_READER 99 28619 sqlplus@b0gateway.fnal.gov (TNS V1-V3) b0gateway.fnal.gov  select     cr.nodevmeproc HNode,     cr.rk_rackname || '-' ||     cr.rk_position HRackPosition,     c.slot HSlot,     ch.card_cardname HCardname,     nvl (ltrim (c.serialnumber,'0'), '-') HSerialNo,     ch.subaddress HOrder,     nvl (ltrim (ch.serialnumber,'0'), '-') HCafeCardSerialNo,     nvl (ltrim (lpad(a1.serial_number,15,'0'),'0'), '-') || '*' CSerialNo,     pv1.name CName,     sysdate from cards c, crates cr, channels ch,    provision_classes@misprod1 pv, positions@misprod1 p, assets@misprod1 a,    assets@misprod1 a1, component_items@misprod1 ci,    provision_classes@misprod1 pv1,    component_classes@misprod1 cc where  a.prov_cl_id = pv.id and p.asset_id = a.id  /* and c.slot = to_number(substr(p.slot_name,8))*/  and decode(cr.rk_position,'T','1','B','2','W','1','W','2','W','3','W','4',  'E','1','E','2','E','3','E','4', cr.rk_position) = SUBSTR(crate_name,7)  and (cr.nodevmeproc<
CRITICAL 
Feb 07 2006 09:46:21 AM 



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


<!-- Date: Tue Feb 7 09:57:24 2006 -->
<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 
Feb 07 2006 09:56:19 AM 



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


<!-- Date: Tue Feb 7 10:47:26 2006 -->
<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 
Feb 07 2006 10:46:21 AM 



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


<!-- Date: Tue Feb 7 10:47:26 2006 -->
<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: hmon CDF_READER 125 21722 sqlplus@b0gateway.fnal.gov (TNS V1-V3) b0gateway.fnal.gov  select     cr.nodevmeproc HNode,     cr.rk_rackname || '-' ||     cr.rk_position HRackPosition,     c.slot HSlot,     ch.card_cardname HCardname,     nvl (ltrim (c.serialnumber,'0'), '-') HSerialNo,     ch.subaddress HOrder,     nvl (ltrim (ch.serialnumber,'0'), '-') HCafeCardSerialNo,     nvl (ltrim (lpad(a1.serial_number,15,'0'),'0'), '-') || '*' CSerialNo,     pv1.name CName,     sysdate from cards c, crates cr, channels ch,    provision_classes@misprod1 pv, positions@misprod1 p, assets@misprod1 a,    assets@misprod1 a1, component_items@misprod1 ci,    provision_classes@misprod1 pv1,    component_classes@misprod1 cc where  a.prov_cl_id = pv.id and p.asset_id = a.id  /* and c.slot = to_number(substr(p.slot_name,8))*/  and decode(cr.rk_position,'T','1','B','2','W','1','W','2','W','3','W','4',  'E','1','E','2','E','3','E','4', cr.rk_position) = SUBSTR(crate_name,7)  and (cr.nodevmeproc
CRITICAL 
Feb 07 2006 10:46:15 AM 



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


<!-- Date: Tue Feb 7 10:56:46 2006 -->
<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 
Feb 07 2006 10:56:28 AM 



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



<!-- Date: Tue Feb 7 15:01:46 2006 -->
<pre>we will continue with creation of b0dau36~cdfonint after we complete a rebuild of /cdf/dbs03 & /cdf/dbs04 ..  estimate restart for reimports will be feb 8 p.m. or feb 9 a.m. 
 
these mt pt were originally built with 64K & 80K stripe size --&gt; these are being rebuilt to 256K.   we found this with some testing regarding our /b0dau36/backup01 that we gain performance with the larger stripe size. 
 
there has been an effort the last few days since dba's have been complaining about performance  
</pre>
<!-- Author: nstanfield  -->


<!-- Date: Tue Feb 7 16:26:46 2006 -->
<pre>I would like to have two specific purpose roles: 
 
  FILECATALOG_DATASET_INSERT 
    INSERT    FILECATALOG.CDF2_DATASET_REGISTRIES 
    SELECT    FILECATALOG.CDF2_DATASET_REGISTRIES 
    SELECT    FILECATALOG.CDF2_DATA_TYPES 
    SELECT    FILECATALOG.CDF2_FILE_FAMILIES 
 
     
  SAM_DATASET_INSERT 
    INSERT    SAMPRD.PROJECT_DEFINITIONS 
    SELECT    SAMPRD.PROJECT_DEFINITIONS 
    SELECT    SAMPRD.PERSONS 
    SELECT    SAMPRD.WORKING_GROUPS 
 
 
  These roles will be assigned, together, to persons permitted to 
  add CDF datasets. 
 
  If the SELECT table privileges are assigned already standardly, 
  then these roles do not require them. 
 
 
Created the roles FILECATALOG_DATASET_INSERT and SAM_DATASET_INSERT 
Granted the privs to SAM_DATASET_INSERT 
 
FILECATALOG app owner should grant privs to FILECATALOG_DATASET_INSERT role. 
 
Thee roles have been granted to HERBER_TEST@cdfofdev for testing as per phone conversation with Randy 
 
 
</pre>
<!-- Author: akumar -->

<!-- Date: Wed Feb 8 00:03:50 2006 -->
<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 
Feb 08 2006 12:02:30 AM 



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


<!-- Date: Wed Feb 8 00:10:50 2006 -->
<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 
Feb 08 2006 12:09:49 AM 



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


<!-- Date: Wed Feb 8 06:39:44 2006 -->
<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 77.85% full.  3628744.0 KBytes of free space remain. 
CRITICAL 
Feb 08 2006 06:38:28 AM 



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


<!-- Date: Wed Feb 8 06:48:00 2006 -->
<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 
Feb 08 2006 06:47:30 AM 



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


<!-- Date: Wed Feb 8 06:48:41 2006 -->
<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 
Feb 08 2006 06:48:29 AM 



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


<!-- Date: Wed Feb 8 07:14:54 2006 -->
<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.27% full.  3233272.0 KBytes of free space remain. 
CRITICAL 
Feb 08 2006 07:13:33 AM 



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


<!-- Date: Wed Feb 8 07:23:15 2006 -->
<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 
Feb 08 2006 07:22:30 AM 



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


<!-- Date: Wed Feb 8 07:23:52 2006 -->
<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 
Feb 08 2006 07:23:33 AM 



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


<!-- Date: Wed Feb 8 09:58:20 2006 -->
<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 47 10808 sqlplus@fcdflnx6.fnal.gov (TNS V1-V3) fcdflnx6.fnal.gov DELETE FROM PLAN_TABLE WHERE STATEMENT_ID=:1 
CRITICAL 
Feb 08 2006 09:58:14 AM 



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


<!-- Date: Wed Feb 8 09:59:14 2006 -->
<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 
Feb 08 2006 09:58:26 AM 



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



<!-- Date: Wed Feb 8 10:41:02 2006 -->
<pre>Started creation of tablespaces for CALIB, RUN, CDFTRIG and RUN 
applications on cdfofint in prepartion for instantiation of streams replication between cdfonint and cdfofint. </pre>
<!-- Author: akumar -->

<!-- Date: Wed Feb 8 10:49:24 2006 -->
<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 
Feb 08 2006 10:48:24 AM 



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


<!-- Date: Thu Feb 9 00:02:51 2006 -->
<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 
Feb 09 2006 12:02:30 AM 



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


<!-- Date: Thu Feb 9 00:10:05 2006 -->
<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 
Feb 09 2006 12:09:49 AM 



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