<!-- Title: 13:31:55  Mon Apr 21 2003 -->
<!-- Crewchief: New Day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Mon Apr 21 14:02:49 2003 -->
<pre>ISSUE: Richard Jetton ran a Suse cron job that looked for 
security issues.  It found several exectuble files in the 
ORACLE_HOME area that were writable by the WORLD. 
We opened a tar with oracle Tar 2919183.996 to 
understand what permission these files need. 
 
SOLUTION:   Remove the writable by world on the following files: 
and use --&gt; chmod 755  
 
$ORACLE_HOME/jre/1.1.8/bin or $ORACLE_HOME/jre/1.3.1/bin 
-rwxr-xrwx 1 oracle dba 3323 2002-05-13 19:46 .java_wrapper 
 
/cdf/ora1/oracle/v9_2_0/jre/1.3.1/bin/i386/native_threads 
-rwxr-xrwx 1 oracle dba 27090 2002-05-13 19:46 java 
 
/cdf/ora1/oracle/v9_2_0/jre/1.3.1/bin/i386/green_threads 
-rwxr-xrwx 1 oracle dba 27058 2002-05-13 19:46 java 
 
I have taken this action on cdfpcb (validation machine), 
fcdfdata012 (test bed) *this machine will soon go to 
Suse 8(will reinstall s/w), and fcdfora3  ... and will  
schedule fcdflnx1 on Thursday a.m. 
 
Investigating the Sun machines we found:  
 
FOR SUN fcdfora1 Oracle 8.1.7.4 - Issue, No action yet  
will schedule. 
 
/cdf/ora1/jre/1.1.8/bin 
-rwxrwxrwx   1 oracle   dba         2787 Jan 31  2001 jre 
 
FOR SUN on fcdfora2 Oracle 8.1.7.4 -- Would like to CHANGE 
this but will wait a day to see affects of today's changes. 
 
-rwxrwxrwx   1 oracle   dba         2787 Jan 30  2001 jre 
 
FOR SUN b0dau36  Oracle 9.2.0.3  No Issue No Action Needed 
 
For Sun b0dau35  Oracle 9.2.0.2   No issue -&gt; Need to schedule upgrade to 9.2.0.3 
</pre>
<!-- Author: nstanfield  -->
<!-- Comment: Tue Apr 22 09;44;38 comment by...ns -->
<pre>Took action on development...
Will schedule FCDFLNX1 and FCDFORA1 for Thursday a.m.

FOR SUN on fcdfora2 Oracle 8.1.7.4 
Chmod 775   
-rwxrwxrwx   1 oracle   dba         2787 Jan 30  2001 jre CHANGED*
-rwxrwxr-x   1 oracle   dba        17592 Jan 30  2001 jre
</pre>
<!-- Date: Tue Apr 22 00:04:05 2003 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Apr 22 2003 12:02:45 AM 



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



<!-- Date: Tue Apr 22 10:31:59 2003 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 
Status : STARTED 



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


<!-- Date: Tue Apr 22 10:31:59 2003 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 
Status : COMPLETED 



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


<!-- Date: Wed Apr 23 00:04:35 2003 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Apr 23 2003 12:02:44 AM 



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


<!-- Date: Wed Apr 23 10:31:25 2003 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 
Status : STARTED 



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


<!-- Date: Wed Apr 23 10:31:25 2003 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 
Status : COMPLETED 



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


<!-- Date: Thu Apr 24 00:05:45 2003 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Apr 24 2003 12:02:44 AM 



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