<!-- Title: 07:10:06  Wed Jul 11 2001 -->
<!-- Crewchief: nstanfield -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Wed Jul 11 08:17:34 2001 -->
<pre>New users defined they are externally authenicated so 
there is no password. (script in oracle user's  bin directory) 
 
&gt;   exotic -&gt; cdfpexo      , Real name: CDF Exotic Group 
&gt;   top    -&gt; cdfptop      , Real name: CDF Top Group 
&gt;   bottom -&gt; cdfpbot      , Real name: CDF Bottom Group 
&gt;   qcd    -&gt; cdfpqcd      , Real name: CDF QCD Group 
 
Can I delete the old accounts: 
 
&gt; EXOTIC 
&gt; TOP 
&gt; BOTTOM 
&gt; QCD 
 
already removed EWK 
 
</pre>
<!-- Author: nstanfield  -->


<!-- Date: Wed Jul 11 09:47:07 2001 -->
<pre>Space used on on-line and off-line for indexes are different because 
on the replicated site initial extent is assigned as the total of actual used on on-site 
in the begining. It is same as Export/Import in compress mode. 
So space used on replicated  site for index is less than space used on master site. 
 
 
Information for: cdfonprd 
------------------- 
 
Tablespace Name       Tablespace Size  Used (in bytes)  Free (in bytes) Pct. Used 
-------------------- ---------------- ---------------- ---------------- --------- 
CALIB_INDEX                        156,057,600       48,005,120      108,052,480        31 
 
CALIB_LRG_INDEX        13,946,060,800    7,742,545,920    6,203,514,880    56 
CALIB_MED_INDEX          3,984,588,800      876,560,384    3,108,028,416     22 
CALIB_SML_INDEX          1,992,294,400      122,232,832    1,870,061,568         7 
CDFTRIG_IDX                           82,411,520       18,997,248 
63,414,272          24 
HARDWARE_INDEX            943,718,400      119,431,168      824,287,232       13 
RUNDB_INDEX                       943,718,400      365,936,640      577,781,760        39 
 
 
Information for: cdfofprd 
------------------- 
 
Tablespace Name       Tablespace Size  Used (in bytes)  Free (in bytes) Pct. Used 
-------------------- ---------------- ---------------- ---------------- --------- 
CALIB_PRD_REP_INDEX     11,324,620,800    6,194,274,304    5,130,346,496    55 
CDFTRIG_PRD_REP_INDEX       87,031,808       12,886,016       74,145,792        15 
HDWDB_PRD_REP_INDEX       990,904,320       66,011,136      924,893,184         7 
RUNDB_PRD_REP_INDEX       964,689,920      110,329,856      854,360,064       12</pre>
<!-- Author: akumar  -->


<!-- Date: Wed Jul 11 14:39:36 2001 -->
<pre>Upgrading cdfondev cdfonint cdfofdev and cdfofint to 8.1.7.1 
and installing security patch  
 
Security bulletin from Oracle: 
   Overview 
 
   A vulnerability in Oracle 8i allows remote intruders to assume control 
   of database servers running on victim machines. If the Oracle server 
   is running on a Windows system, an intruder may also be able to gain 
   contol of the underlying operating system. 
 
I. Description 
 
   The COVERT labs at PGP Security have discovered a buffer overflow 
   vulnerability in Oracle 8i that allows intruders to execute arbitrary 
   code with the privileges of the TNS listener process. The 
   vulnerability occurs in a section of code that is executed prior to 
   authentication, so an intruder does not require a username or 
   password. 
 
   For more information, see the COVERT Labs Security Advisory, available 
   at 
 
          http://www.pgp.com/research/covert/advisories/050.asp 
 
II. Impact 
 
   An intruder who exploits the vulnerability can remotely execute 
   arbitrary code. On UNIX systems, this code runs as the 'oracle' user. 
   If running on Windows systems, the intruder's code will run in the 
   Local System security context. 
 
   In either case, the attacker can gain control of the database server 
   on the victim machine. On Windows systems, the intruder can also gain 
   administrative control of the operating system. 
 
III. Solutions 
 
   Install a patch from Oracle.  
 
</pre>
<!-- Author: nstanfield  -->


<!-- Date: Wed Jul 11 15:05:08 2001 -->
<pre>Upgrade complete sent mail to users 3:00 pm  
 
CDFDB-Users 
 
The ONLINE and OFFLINE development and integration databases  
are available. 
 
We have upgraded to 8.1.7.1 and installed the necessary 
security patch. 
 
Please send email to cdfdb-support if you encounter 
any problems. 
 
If the operation managers approve downtime for tomorrow 
morning, we will be upgrading  the *Production* cdfofprd & cdfonprd 
instances.   This will require a downtime of ~ 2 hours.   
 
Nelly/Diana  
 
 
</pre>
<!-- Author: nstanfield  -->

<!-- Date: Thu Jul 12 08:20:04 2001 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Node UpDown
 VNI-4044 : Cannot contact agent. Node may be down, or the network may be down or slow.
NODE UNREACHABLE
Jul 12 2001 07:19:37 AM
Database UpDown
Event test "Database UpDown" is cleared
CLEARED
May 22 2001 09:06:18 AM
</pre>
<!-- Author: oem-admin (email) -->