<!-- Title: 08:41:41  Mon Jan 30 2006 -->
<!-- Crewchief: New day  -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Mon Jan 30 08:43:54 2006 -->
<pre>fcdfora1~cdofdev & cdfofint JAN CPU Patch. 1 hour downtime.  
 
 
Per oracle they want me to proceed with Jan CPU patch on a 64 bit machine to see if the same conflict exists that existed while applying to the 32 bit machine.   They state it is not true that just because the machines are patched the same that the conflict would be the same.    So I will proceed with this patch NOW.  </pre>
<!-- Author: nstanfield  -->
<!-- Comment: Mon Jan 30 09;21;47 comment by...nstanfield  -->
<pre>per oracle's action plan i have now proved to them that the 64 bit & the 32 bit  jan cpu patches both have a conflict with an existing patch  3763395  --&gt;  

they will put in the request for the merge patch:

current timescale  - needs discussion -- more later.

Note 343391.1 Oracle Critical Patch Update January 2006 FAQ
2. Conflict reported while applying the CPUJan2006 patch. What should I do?

Oracle tries to foresee any potential conflicts between the CPUJan2006 patches and one-off patches and include the conflicting one-off patches in the CP
U. In the event that a conflict is reported during installation of a CPU patch,
please file a Service Request with Oracle Global Support to request a merge pat
ch. The following are the guidelines for post-CPUJan2006 merge request:

* All merge requests submitted within 4 weeks of the CPUJan2006 release date (15-F
eb-2006) will be included in the post-CPUJan2006 merge patch and the Critical Pa
tch Update April 2006 (CPUApr2006). Post-CPUJan2006 will be released at the end 
of February 2006. 
* Any merge request submitted after 4 weeks of the CPUJan2006 release date will be handled individually and will not be included in CPUA
pr2006.
* Where there are CPU patches available on multiple versions, Oracle encourages all customers to be on the latest patch set version of a product as 
the conflict may not occur with the latest patch set. This is also to ensure th
e highest level of service.
</pre>


<!-- Date: Mon Jan 30 12:17:44 2006 -->
<pre>We want to proceed with the o/s patch on Feb 9. 
Per the security team we are required to move 
quickly and we cannot post-pone this patch to March. 
 
The machine has been up for 118 days and the last 
patched applied was pulled from the Sun site 
Sept 26 and applied Nov 16. 
 
We did not use our maintenance window in December 
nor January and it is important for us to proceed 
with the February 9 maintenance window. 
 
Below is the list of the o/s patches that will 
be applied and Steve has stated that he finds 
these patches to be critical. 
 
Unfortunately, Oracle's quarterly patch has 
a conflict & we are not hopeful that the merge 
patch will be available by this date.  Regardless, 
of the Oracle quarterly patch schedule we have to 
proceed with the February slot to get the o/s patched. 
 
Please approve a 2 hour slot on Feb 9 allowing 
Steve to proceed with the o/s patched as listed below. 
 
-Nelly 
 
 
 
Here's the OS patch list: 
 
 
117067-01  SunOS 5.9: awk nawk oawk Patch 
112964-14  SunOS 5.9: /usr/bin/ksh Patch 
113713-21  SunOS 5.9: pkginstall Patch 
112951-12  SunOS 5.9: patchadd and patchrm Patch 
114008-01  SunOS 5.9: cachefsd Patch 
112998-03  SunOS 5.9: patch /usr/sbin/syslogd 
112875-01  SunOS 5.9: patch /usr/lib/netsvc/rwall/rpc.rwalld 
113146-06  SunOS 5.9: Apache Security Patch 
112233-12  SunOS 5.9: Kernel Patch 
113068-06  SunOS 5.9: hpc3130 patch 
113273-10  SunOS 5.9: /usr/lib/ssh/sshd Patch 
113279-01  SunOS 5.9: klmmod Patch 
113023-01  SunOS 5.9: Broken preremove scripts in S9 ALC packages 
113033-05  SunOS 5.9: patch /kernel/drv/isp and /kernel/drv/sparcv9/isp 
112601-09  SunOS 5.9: PGX32 Graphics 
113923-02  X11 6.6.1: security font server patch 
113718-02  SunOS 5.9: usr/lib/utmp_update Patch 
114135-03  SunOS 5.9: at utility Patch 
114133-02  SunOS 5.9: mail Patch 
114153-01  SunOS 5.9: Japanese SunOS 4.x Binary Compatibility(BCP) patch 
113575-05  SunOS 5.9: sendmail Patch 
114636-03  SunOS 5.9: KCMS security fix 
114713-02  SunOS 5.9: newtask Patch 
113240-11  CDE 1.5: dtsession patch 
114684-03  SunOS 5.9: samba Patch 
114861-01  SunOS 5.9: /usr/sbin/wall 
114729-01  SunOS 5.9: usr/sbin/in.telnetd Patch 
114482-04  SunOS 5.9: Product Registry CLI Revision 
114571-02  SunOS 5.9: libc.so.*.9/bcp Patch 
114569-02  SunOS 5.9: libdbm.so.1 Patch 
112907-06  SunOS 5.9: libgss Patch 
112908-23  SunOS 5.9: krb5 shared object Patch 
112922-02  SunOS 5.9: krb5 lib Patch 
114129-02  SunOS 5.9: multi-terabyte disk support -libuuid patch 
114127-03  SunOS 5.9: abi_libefi.so.1 and fmthard Patch 
115754-02  SunOS 5.9: zlib security Patch 
114495-01  CDE 1.5: dtprintinfo patch 
113073-14  SunOS 5.9: ufs and fsck patch 
115172-01  SunOS 5.9: kernel/drv/le Patch 
114971-02  SunOS 5.9: usr/kernel/fs/namefs Patch 
112923-03  SunOS 5.9: krb5 usr/lib Patch 
112617-02  CDE 1.5: rpc.cmsd patch 
114016-01  tomcat security patch 
114049-12  SunOS 5.9: NSPR 4.1.6 / NSS 3.3.4.5 
114125-01  SunOS 5.9: IKE config.sample patch 
114361-01  SunOS 5.9: /kernel/drv/lofi Patch 
114875-01  SunOS 5.9: XML library source patch 
116237-01  SunOS 5.9: pfexec Patch 
116247-01  SunOS 5.9: audit_warn Patch 
116308-01  CDE 1.5: libDtHelp patch 
116245-01  SunOS 5.9: uncompress Patch 
113226-05  SunOS 5.9: hme Driver Patch 
113482-02  SunOS 5.9: sbin/sulogin Patch 
117071-01  SunOS 5.9: memory leak in llc1_ioctl() 
117171-17  SunOS 5.9: Kernel Patch 
117114-02  CDE 1.5: sdtwebclient patch 
115683-03  SunOS 5.9: Header files Patch 
116453-02  SunOS 5.9: sadmind patch 
112810-06  CDE 1.5: dtmail patch 
116538-03  SunOS 5.9: SUNW_disk_link.so Patch 
112926-06  SunOS 5.9: smartcard Patch 
116774-03  SunOS 5.9: ping patch 
117455-01  SunOS 5.9: in.rwhod Patch 
113096-03  X11 6.6.1: OWconfig patch 
112834-06  SunOS 5.9: patch scsi 
116105-04  X11 6.6.1: Freetype patch 
117203-05  X11 6.6.1: fontconfig patch 
112912-01  SunOS 5.9: libinetcfg Patch 
116532-03  SunOS 5.9: mpt Patch 
112963-25  SunOS 5.9: linker Patch 
112785-52  X11 6.6.1: Xsun patch 
112874-32  SunOS 5.9: lgroup API libc Patch 
117201-09  X11 6.6.1: st patch 
113319-22  SunOS 5.9: libnsl nispasswdd Patch 
117459-01  SunOS 5.9: routing socket module Patch 
112661-08  SunOS 5.9: IIIM and X Input & Output Method patch 
112954-13  SunOS 5.9: uata Driver Patch 
114332-23  SunOS 5.9: c2audit & *libbsm.so.1 Patch 
113579-08  SunOS 5.9: ypserv/ypxfrd patch 
118300-02  X11 6.6.1: libXpm patch 
118335-04  SunOS 5.9: sockfs Patch 
112811-02  OpenWindows 3.7.0: Xview Patch 
117445-01  SunOS 5.9: newgrp patch 
119433-01  SunOS 5.9: telnet 
117485-01  SunOS 5.9: fn_ctx_x500.so.1 Patch 
112965-05  SunOS 5.9: patch /kernel/drv/sparcv9/eri 
112921-07  SunOS 5.9: libkadm5 Patch 
112817-25  SunOS 5.9: Sun GigaSwift Ethernet 1.0 driver patch 
112925-06  SunOS 5.9: ktutil kdb5_util kadmin kadmin.local kadmind Patch 
114219-11  CDE 1.5: sdtimage patch 
113329-15  SunOS 5.9: lp Patch 
114014-10  SunOS 5.9: libxml, libxslt and Freeware man pages Patch 
114363-03  SunOS 5.9: sort Patch 
113280-06  SunOS 5.9: patch /usr/bin/cpio 
113798-02  CDE 1.5: libDtSvc patch 
113277-36  SunOS 5.9: sd and ssd Patch 
116489-01  SunOS 5.9: ttymux Patch 
116494-01  SunOS 5.9: libdevice Patch 
116559-01  SunOS 5.9: powerd pmconfig patch 
117162-01  SunOS 5.9: patch usr/src/uts/common/sys/cpc_impl.h 
117477-01  SunOS 5.9: vol Patch 
114128-02  SunOS 5.9: sd_lun patch 
117418-01  SunOS 5.9: consms patch 
114356-06  SunOS 5.9: /usr/bin/ssh Patch 
119449-01  SunOS 5.9: Perl Patch 
111711-15  SunOS 5.9: 32-bit Shared library patch for C++ 
114503-14  SunOS 5.9: usr/sadm/lib/usermgr/VUserMgr.jar Patch 
113318-22  SunOS 5.9: NFS Patch 
116807-02  SunOS 5.9: /usr/sadm/lib/smc/lib/preload/jsdk21.jar patch 
113077-15  SunOS 5.9: /platform/sun4u/kernel/drv/su Patch 
119211-05  SunOS 5.9: NSPR 4.5.2 / NSS 3.10.1 / JSS 4.1 
111712-15  SunOS 5.9: 64-Bit Shared library patch for C++ 
114564-08  SunOS 5.9: /usr/sbin/in.ftpd Patch 
112808-08  CDE1.5: Tooltalk patch 
112970-09  SunOS 5.9: patch libresolv 
118558-20  SunOS 5.9: Kernel Patch 
114555-29  SunOS 5.9: Sun XVR-1200 and Sun XVR-600 Graphics Accelerator 
Patch 
112764-08  SunOS 5.9: Sun Quad FastEthernet qfe driver 
115158-10  X11 6.6.1: xscreensaver patch 
112540-26  SunOS 5.9: Expert3D IFB Graphics Patch 
113278-12  SunOS 5.9: NFS Daemon, rpcmod Patch 
112945-40  SunOS 5.9: wbem Patch 
112960-33  SunOS 5.9: libldap and pam patch 
120464-03  SunOS 5.9: ifconfig, in.routed, ipmp patch 
112807-17  CDE 1.5: dtlogin patch 
116669-12  SunOS 5.9: md Patch 
116548-05  SunOS 5.9: ufsboot Patch 
114344-16  SunOS 5.9: arp, dlcosmk, ip, and ipgpc Patch 
118305-06  SunOS 5.9: tcp Patch 
116561-12  SunOS 5.9: platmod Patch 
113451-10  SunOS 5.9: IKE Patch 
115553-20  SunOS 5.9: USB Drivers and Framework Patch 
113322-03  SunOS 5.9: uucp patch 
 
 
 
Steven Kovich 
 
 
 
----- Original Message -----  
From: "Petar Maksimovic" &lt;petar@jhu.edu&gt; 
To: "Nelly Stanfield" &lt;nelly@fnal.gov&gt;; "Anil Kumar" &lt;akumar@fnal.gov&gt; 
Cc: "Krzysztof Genser" &lt;genser@fnal.gov&gt;; "Doug Benjamin"  
&lt;dbenjamin@fnal.gov&gt; 
Sent: Monday, January 30, 2006 9:15 AM 
Subject: Downtime for ora4 
 
 
&gt; Hi Nelly and Anil, 
&gt; 
&gt; could you please remind me when you wanted to do the 
&gt; required security updates on ora4?  How long it would 
&gt; take and how long can you postpone it for? 
&gt; 
&gt; I'm cc-ing Krzysztof and Doug since it would be nice 
&gt; to know how long a downtime can be absorbed by the 
&gt; SAM servers. 
&gt; 
&gt; Once we know the facts, we could put the issue to the 
&gt; CDF offline SPL council for debate and executive decision. 
&gt; 
&gt; (As a disclaimer, I'm not advocating either option since 
&gt; as a user I will suffer from SAM downtime as much as 
&gt; everybody else...) 
&gt; 
&gt; Thanks, 
&gt; 
&gt;           Petar 
&gt; 
&gt; 
&gt; 
&gt;  
</pre>
<!-- Author: ns  -->

<!-- Date: Mon Jan 30 12:34:09 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 73.24% full.  4383736.0 KBytes of free space remain. 
CRITICAL 
Jan 30 2006 12:33:44 PM 



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


<!-- Date: Mon Jan 30 12:43:04 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 30 2006 12:42:30 PM 



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


<!-- Date: Mon Jan 30 12:44:21 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 30 2006 12:43:44 PM 



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


<!-- Date: Mon Jan 30 13:09: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 78.54% full.  3515752.0 KBytes of free space remain. 
CRITICAL 
Jan 30 2006 01:08:43 PM 



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


<!-- Date: Mon Jan 30 13:18:29 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 30 2006 01:17:30 PM 



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


<!-- Date: Mon Jan 30 13:19:40 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 30 2006 01:18:42 PM 



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


<!-- Date: Tue Jan 31 00:02:40 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 31 2006 12:02:30 AM 



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


<!-- Date: Tue Jan 31 00:10:17 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 31 2006 12:09:49 AM 



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


<!-- Date: Tue Jan 31 06:39:01 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 78.31% full.  3554272.0 KBytes of free space remain. 
CRITICAL 
Jan 31 2006 06:38:51 AM 



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


<!-- Date: Tue Jan 31 06:48:23 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 31 2006 06:47:30 AM 



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


<!-- Date: Tue Jan 31 06:49:22 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 31 2006 06:48:48 AM 



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


<!-- Date: Tue Jan 31 07:14:12 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.13% full.  2927680.0 KBytes of free space remain. 
CRITICAL 
Jan 31 2006 07:13:42 AM 



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


<!-- Date: Tue Jan 31 07:23:17 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 31 2006 07:22:30 AM 



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


<!-- Date: Tue Jan 31 07:24:33 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 31 2006 07:23:38 AM 



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


<!-- Date: Tue Jan 31 16:50:11 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138747744 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 04:49:49 PM 



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


<!-- Date: Tue Jan 31 17:00:18 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138748324 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 04:59:49 PM 



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


<!-- Date: Tue Jan 31 17:21:00 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138749202 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138749332 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138749335 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138749455 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138749461 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 05:19:49 PM 



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


<!-- Date: Tue Jan 31 17:40:37 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138750629 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 05:39:49 PM 



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


<!-- Date: Tue Jan 31 17:49:58 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138750860 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138750863 sec, SCN: 0x056f.7079ab7c): ORA-00600: internal error code, arguments: [12333], [7], [6], [99], [], [], [], [] ORA-01555 caused by SQL statement below (Query Duration=1138751070 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138751084 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138751085 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138751220 sec, SCN: 0x056f.7079ab7c):. 
CRITICAL 
Jan 31 2006 05:49:49 PM 



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


<!-- Date: Tue Jan 31 18:00:19 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138751581 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138751583 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 05:59:49 PM 



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


<!-- Date: Tue Jan 31 18:10:39 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138752188 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138752208 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 06:09:49 PM 



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


<!-- Date: Tue Jan 31 18:30:47 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138753348 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138753374 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138753400 sec, SCN: 0x056f.7079ab7c): ORA-01555 caused by SQL statement below (Query Duration=1138753426 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 06:29:49 PM 



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


<!-- Date: Tue Jan 31 18:50:28 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138754800 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 06:49:49 PM 



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


<!-- Date: Tue Jan 31 19:00:49 2006 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=1138755287 sec, SCN: 0x056f.7079ab7c):. 
WARNING 
Jan 31 2006 06:59:49 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Tue Jan 31 19;48;38 comment by...nstanfield  -->
<pre>This was caused by export of RUNDB_PRD for refresh of RUNDB_INT. 

Increased the undo_retention to 21600 Vs 3600 to take export of RUNDB_PRD 
</pre>

<!-- Comment: Wed Feb  1 06;27;22 comment by...ns  -->
<pre>reset to 3600 vs 21600 rundb_prd export completed in 3.5 hours
rman size ~21G 

SQL&gt; show parameter undo%

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     21600
undo_suppress_errors                 boolean     TRUE
undo_tablespace                      string      undo_01
SQL&gt; alter system set undo_retention=3600;

System altered.

SQL&gt;</pre>
<!-- Date: Wed Feb 1 00:02:54 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 01 2006 12:02:30 AM 



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


<!-- Date: Wed Feb 1 00:10:27 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 01 2006 12:09:49 AM 



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