<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Annoucements</TITLE>
<META NAME="GENERATOR" CONTENT="Microsoft FrontPage 5.0">
<META NAME="CREATED" CONTENT="20050125;9365700">
<META NAME="CHANGED" CONTENT="20050125;9513800">
<META NAME="ProgId" CONTENT="FrontPage.Editor.Document">
<META HTTP-EQUIV="Content-Language" CONTENT="en-us">
</HEAD>
<BODY LANG="en-US" DIR="LTR">
<P><FONT FACE="Times New Roman"><B>CDF Db Weekly Notes Sep 28,
2005 </B></FONT>
</P>
<P><FONT FACE="Times New Roman" size="5"><B>Announcements</B></FONT></P>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-<b>REQUESTING</b> <b>GOT A page from Bob
Wagner Sept 28 -- we can take a few hours this a.m. Wednesday to patch.
Bob will check with Maurine to confirm exact hours needed for o/s patch &
installation of disks. </b> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><b>Security Audit in November</b></p>
<p class="MsoNormal"><br>
1. we are having a doe audit starting nov. that is 1 month.<br>
2. all machines will be audited, there is no dispensation.<br>
3. a firewall is no protection or excuse, all machines will be audited and
probed. in fact, machines behind firewalls may be probed first (if <br>
i were the auditor that is what i would), as then tend to be 'neglected'.<br>
4. if anything is amiss fermi must follow their recommendations <br>
5. we have been ordered to get all machines up to date patch wise before
this audit. we will have to report to vicky any thing that prevents us
from doing so. <br>
6. worse case, machines not up to date could be taken off the network,
again a firewall is no excuse with this audit. </p>
<p class="MsoNormal">also any linux boxes must be upgraded to lts3.0.x <br>
<br>
</p>
<p class="MsoNormal">-<b>REQUESTING</b> <b>-fcdfora4 o/s patches scheduled for
oct 13 </b>
-<b>fcdfora1 o/s patches scheduled a week before </b></p>
<p class="MsoNormal"> </p>
<P><b>Pending</b></P>
<PRE><font face="Times New Roman" size="3"><b>-</b>Most likely during November
downtime. 8 hours needed. DISKS (7 dis
k)<i> 4 Raid = /cdf/dbs03 & 3 to be added to /backup </i></font></PRE>
<PRE><font face="Times New Roman" size="3"><i><a href="../all_other_documentation/break_up_disk_job.htm">LOOKING
AT BR
EAKING UP THIS TASK - </a></i></font></PRE>
<P><font face="Times New Roman" size="3">-Monitor CHARTS for CPU usage on
fcdfora4 regarding SAM farms ramp up &
amp; later cdf community. </font> </P>
<P><b><i>On Hold / In process </i> </b> </P>
<P>-<b> </b>ONHOLD -schedule patch 4398475 for b0dau36, bzora1(completed
fcdfora1
& pending scheduling fcdfora4) . will do bzora1 after b0dau36 revampled
</P>
<P> </P>
<P><FONT FACE="Times New Roman" size="5"><B>Operations </B></FONT>
</P>
<PRE><b><font size="4" face="Times New Roman">Projects</font></b></PRE>
<PRE><font face="Times New Roman" size="3">-b0dau36 <b> - </b> we met with
maurine on disks layout -- hope to proceed
soon </font></PRE>
<PRE><font face="Times New Roman" size="3">-CDFPCB going away per Jason -
Dennis confirmed - Dennis needs to test the
area on cdfofint to replace CDFVAL </font></PRE>
<PRE> </PRE>
<P><FONT FACE="Times New Roman" size="4"><B>Alerts: </B></FONT>
<FONT FACE="Times New Roman"> </FONT></P>
<ul>
<li> CDFONPRD~BZORA1 - The /cdf/backup disk has been alerting 95%
capacity. NEED TO GET DISKS IN! again looking at breakup plan
since we can't get a long downtime </li>
</ul>
<P><b>
ACTION</b> -
details in elog
<a onclick="jswindow()" href="http://www-cdfonline.fnal.gov/cgi-bin/det-system-elog.pl?nb=database&action=copyentry&pa
ge=720&time=06:39:11" target="xxx">
<font color="red">Mon Sep 26 06:39:11</font></a></P>
<P> </P>
<ul>
<li>CDFOFPRD~FCDFORA$ Sep 28 2005 05:12:30 AM The following errors are in the
ALERT file : ORA-01555 caused by SQL statement below (Query Duration=4337 sec,
SCN: 0x056e.daf80dd8):. <br>
<br>
<b>ACTION: </b>no action. undo set to 3600 watch for occurences
&
monitor </li>
</ul>
<P> </P>
<ul>
<li>CDFONPRD~BZORA1 Sep 21 2005 09:19:49 AM The following errors
are in the ALERT file : ORA-27037: unable to obtain file status ORA-27037:<br>
unable to obtain file status. <br>
<br>
<P><b>ACTION: </b>reran rman issue with space & enstore, due to
switching of crons </P>
<P> </P>
</li>
<li>CDFONPRD~BZORA1 Sep 22 2005 12:09:49 PM The following errors are in the
ALERT file : ORA-1632: max # extents 600 reached in index CALIB_PRD.PC_PK
ORA-1632: max # extents 600 reached in index CALIB_PRD.PC_PK <br>
</li>
</ul>
<P><b> ACTION: </b>increased
from 600 to 900 </P>
<ul>
<li>cdfonprd~bzora1 Sep 28 2005 07:06:23 AM User Defined SQL Test <br>
Current Value: cdf-cap-solenoid ICICLE 63 36415 icicle.exe FERMI\SOLENOID2
INSERT INTO<br>
SENSOR_HISTORIES (SENSH_ID, VALUE,SENS_ID,SENST_ID, HISTYP_ID) VALUES (:f1
,:f2 ,:f3 <br>
,:f4 ,:f5 )
5.91666666666666666666666666666666666624 <br>
</li>
</ul>
<P> <b>ACTION: </b>informed
margherita she was going to investigate the commits for this api <b><br>
</b><br>
<br>
<br>
</P>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE></PRE>
<PRE><b><font face="Times New Roman" size="3">Misc : </font></b></PRE>
<P><b>Downtimes on fcdfora4 needs to be smoothed out. </b>
Similarly, to cdfonline, we should be able to call x2080 and get the necessary
approvals. We are having an internal root cause to help smooth out some of
the process YET the problem getting the downtime approved was one of the hurdles
we hope to solve with CDF. </P>
<HR>
<P><FONT FACE="Times New Roman"><A HREF="mailto:css-dsg@fnal.gov">css-dsg@fnal.gov</A>
Sep 28, 2005
<A HREF="../2004/index_for_2004.htm"> 2004 Meetings </A></FONT>
</P>
<P> </P>
</BODY>
</HTML>
<fsui02>