<!-- Title: 09:07:45  Tue Jan 24 2006 -->
<!-- Crewchief: New day  -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Tue Jan 24 12:52:25 2006 -->
<pre>**in additional to email sent regarding password complexity  
 
Additional specifics about implementation 
regarding specific 'group/batch/read' accounts will be shared a the next CDFDB meeting.   In summary, a  GROUPACCT profile has been defined until we understand the risk analysis of this change on all group/batch/read accounts. 
 
In addition, we are meeting with Oracle Jan 26 to further understand Kerberos deployment and fine grain access. 
+++++++++++++++++++++++++++++++++++++++++++++++++++++ 
 
 
CDFDB-Users  
  
We are implementing password complexity for all 
oracle databases in an effort to strengthen weak 
oracle passwords.  We are incorporating the following standards: 
http://www-css.fnal.gov/dsg/internal/ora_adm/managing_user_passwords_with_verification.htm. 
  
  
Deployment schedule: 
  
fcdfora1~cdfofdev & cdfofint instances   January 24, 2006 
  
fcdfora4~cdfofprd  to be scheduled 
  
b0dau36~cdfondev instance  January 26, 2006 
  
b0dau36~cdfonint instance   January 31, 2006  
  
bzora1~cdfonprd to be scheduled  
  
fcdfora6~cdfstrm1 to be schedule  
 
  
This does not effect current passwords, however, 
the next time you modify your password it will be held to  
these standards.   We encourage everyone to change/update your 
passwords.      
  
Additional future steps will be taken to lock out users that 
continue with weak passwords. 
  
  
-Nelly 
-CD/CSS/DSG group </pre>
<!-- Author: ns  -->

<!-- Date: Tue Jan 24 14:02:52 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-01555 caused by SQL statement below (Query Duration=10037 sec, SCN: 0x056f.6c091213): ORA-01555: snapshot too old: rollback segment number 9 with name "_SYSSMU9$" too small. 
WARNING 
Jan 24 2006 02:02:30 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Tue Jan 24 17;11;33 comment by...ns  -->
<pre>query to long for current sizing of undo retention 

SQL&gt; select username, osuser, LOGON_TIME from logintraces where sid = '122' and serial# = '3386';

USERNAME OSUSER LOGON_TIM
------------------------------ ------------------------------ ---------
SAMREAD wicklund 24-JAN-06

 

&lt;fcdfora4&gt; more /cdf/ora1/admin/cdfofpr2/udump/cdfofpr2_ora_25315.trc
Dump file /cdf/ora1/admin/cdfofpr2/udump/cdfofpr2_ora_25315.trc
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /cdf/ora1/oracle/v9_2_0
System name: SunOS
Node name: fcdfora4
Release: 5.9
Version: Generic_118558-13
Machine: sun4u
Instance name: cdfofpr2
Redo thread mounted by this instance: 1
Oracle process number: 57
Unix process pid: 25315, image: oracle@fcdfora4 (TNS V1-V3)

*** SESSION ID:(122.3386) 2006-01-24 14:01:22.675
FATAL ERROR IN TWO-TASK SERVER: error = 12152
*** 2006-01-24 14:01:22.686
ksedmp: internal or fatal error
ORA-01555: snapshot too old: rollback segment number 9 with name "_SYSSMU9$" too small
Current SQL statement for this session:
SELECT /*+ rule: */ SMDF.FILE_NAME, SMDSL.FULL_PATH, (SELECT MIN(PV.PARAM_VALUE) FROM DATA_FILES_PARAM_VALUES DFPV, 
PARAM_VALUES PV WHERE DFPV.FILE_ID=SMDF.FILE_ID AND DFPV.PARAM_VALUE_ID=PV.PARAM_VALUE_ID AND PV.PARAM_TYPE_ID IN (S
ELECT PARAM_TYPE_ID FROM PARAM_TYPES WHERE PARAM_TYPE = 'dataset' AND PARAM_CATEGORY_ID = (SELECT PARAM_CATEGORY_ID 
FROM PARAM_CATEGORIES WHERE PARAM_CATEGORY = 'cdf')) ) DATASETNAME, Oracle_To_Unix_Date(SMDF.END_TIME) ENDTIME, SMDF
.FILE_SIZE_IN_BYTES/1024./1024, SMDF.EVENT_COUNT, SMDF.FIRST_EVENT_NUMBER, (SELECT MIN(SMR.RUN_NUMBER) FROM DATA_FIL
ES_RUNS SMDFR, RUNS SMR WHERE SMDF.FILE_ID = SMDFR.FILE_ID AND SMDFR.RUN_ID = SMR.RUN_ID) FIRSTRUN, SMDF.LAST_EVENT_
NUMBER, (SELECT MAX(SMR.RUN_NUMBER) FROM DATA_FILES_RUNS SMDFR, RUNS SMR WHERE SMDF.FILE_ID = SMDFR.FILE_ID AND SMDF
R.RUN_ID = SMR.RUN_ID) LASTRUN, 0 LUM_SUM_ONLINE, 0 LUM_SUM_OFFLINE, Oracle_To_Unix_Date(SMDF.UPDATE_DATE) UPDATETIME, Oracle_To_Un
ix_Date(SMDF.CREATE_DATE) CREATEDATE, UPPER(SMV.VOLUME_NAME) FROM DATA_FILES SMDF, DATA_STORAGE_LOCATIONS SMDSL, DATA_FILE_LOCATION
S SMDFL, VOLUMES SMV WHERE SMDF.FILE_ID = SMDFL.FILE_ID AND SMDFL.VOLUME_ID = SMV.VOLUME_ID AND SMDFL.LOCATION_ID = SMDSL.LOCATION_
ID ORDER BY ENDTIME, UPDATETIME
----- Call Stack Trace -----
calling call entry argument values in hex 
location type point (? means dubious value) 

</pre>

<!-- Date: Tue Jan 24 19:04:49 2006 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace CALIB_MED_DATA is 70.23% full.  3753064.0 KBytes of free space remain. 
CRITICAL 
Jan 24 2006 07:03:36 PM 



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



<!-- Date: Tue Jan 24 19:17:43 2006 -->
<pre>the refresh of HDWDB_DEV with prd data is finished. 
</pre>
<!-- Author: dbonham -->

<!-- Date: Wed Jan 25 00:02:59 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 
Jan 25 2006 12:02:30 AM 



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


<!-- Date: Wed Jan 25 00:10:51 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 
Jan 25 2006 12:09:49 AM 



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


<!-- Date: Wed Jan 25 06:39: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 82.46% full.  2873752.0 KBytes of free space remain. Tablespace CALIB_MED_DATA is 70.23% full.  3753064.0 KBytes of free space remain. 
CRITICAL 
Jan 25 2006 06:38:27 AM 



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


<!-- Date: Wed Jan 25 06:48: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 
Jan 25 2006 06:47:30 AM 



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


<!-- Date: Wed Jan 25 06:48:58 2006 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace CALIB_MED_DATA is 70.23% full.  3753064.0 KBytes of free space remain. 
CRITICAL 
Jan 25 2006 06:48:27 AM 



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


<!-- Date: Wed Jan 25 07:15:19 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 84.86% full.  2480848.0 KBytes of free space remain. Tablespace CALIB_MED_DATA is 70.23% full.  3753064.0 KBytes of free space remain. 
CRITICAL 
Jan 25 2006 07:13:31 AM 



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


<!-- Date: Wed Jan 25 07:19:27 2006 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace CALIB_MED_DATA is 70.23% full.  3753064.0 KBytes of free space remain. 
CRITICAL 
Jan 25 2006 07:18:29 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Wed Jan 25 08;54;25 comment by...ns  -->
<pre>added 500M </pre>
<!-- Date: Wed Jan 25 07:22:38 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 
Jan 25 2006 07:22:30 AM 



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


<!-- Date: Wed Jan 25 08:54:12 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 
Jan 25 2006 08:53:29 AM 



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



<!-- Date: Wed Jan 25 13:19:04 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 85.55% full.  2367856.0 KBytes of free space remain. 
CRITICAL 
Jan 25 2006 01:18:36 PM 



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


<!-- Date: Wed Jan 25 13:29:25 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 
Jan 25 2006 01:27:30 PM 



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


<!-- Date: Wed Jan 25 13:29:25 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 
Jan 25 2006 01:28:28 PM 



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


<!-- Date: Thu Jan 26 00:04:09 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 
Jan 26 2006 12:02:30 AM 



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


<!-- Date: Thu Jan 26 00:11:36 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 
Jan 26 2006 12:09:49 AM 



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


<!-- Date: Thu Jan 26 06:38:59 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.66% full.  3169072.0 KBytes of free space remain. 
CRITICAL 
Jan 26 2006 06:38:36 AM 



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


<!-- Date: Thu Jan 26 06:48:41 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 
Jan 26 2006 06:47:30 AM 



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


<!-- Date: Thu Jan 26 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 
Jan 26 2006 06:48:37 AM 



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


<!-- Date: Thu Jan 26 07:14:26 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 84.15% full.  2596408.0 KBytes of free space remain. 
CRITICAL 
Jan 26 2006 07:13:39 AM 



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


<!-- Date: Thu Jan 26 07:19:54 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 
Jan 26 2006 07:18:39 AM 



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


<!-- Date: Thu Jan 26 07:22:45 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  ORA-1652: unable to extend temp segment by 321 in tablespace                 USERTEMP_01. 
WARNING 
Jan 26 2006 07:22:30 AM 



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



<!-- Date: Thu Jan 26 21:14:47 2006 -->
<pre>i will proceed with b0dau36 jan cpu oct match tomorrow a.m. - jan 26. expect an hour interruption starting at 7:30 or so  
 
and 
 
the fcdfora1 patch will proceed on monday, jan 30 a.m. another 1 hour interruption starting in the a.m. 
 
 
</pre>
<!-- Author: nstanfield -->
<!-- Comment: Thu Jan 26 21;25;50 comment by...nstanfield -->
<pre>jan 26 + 1   -- jan 27 friday</pre>

<!-- Comment: Thu Jan 26 21;28;49 comment by...ns -->
<pre>in addition reboot on b0dau36 per sun's action plan resulting from crash we experienced earlier this week

-----------------------------------------------
sun is recommending 3 patches be applied to b0dau36. i had just recently applied a cumulative patch set on b0dau36, but 2 of the patches are already out of date.

these patches need to be done in single user mode and rebooted. so i will need a time when i can do this. let me know what time will be ok.

maurine</pre>

<!-- Date: Fri Jan 27 00:03:11 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 
Jan 27 2006 12:02:31 AM 



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


<!-- Date: Fri Jan 27 00:10:51 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 
Jan 27 2006 12:09:49 AM 



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


<!-- Date: Fri Jan 27 06:39:17 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 81.47% full.  3035536.0 KBytes of free space remain. 
CRITICAL 
Jan 27 2006 06:38:42 AM 



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


<!-- Date: Fri Jan 27 06:48:33 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 
Jan 27 2006 06:47:30 AM 



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


<!-- Date: Fri Jan 27 06:50:37 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 
Jan 27 2006 06:48:43 AM 



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


<!-- Date: Fri Jan 27 07:14:24 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 83.42% full.  2717104.0 KBytes of free space remain. 
CRITICAL 
Jan 27 2006 07:13:44 AM 



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


<!-- Date: Fri Jan 27 07:22:41 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 
Jan 27 2006 07:22:30 AM 



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


<!-- Date: Fri Jan 27 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 
Jan 27 2006 07:23:41 AM 



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