<!-- Title: 07:15:27  Thu Aug 29 2002 -->
<!-- Crewchief: New Day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Thu Aug 29 07:19:34 2002 -->
<pre>Starting cdfofdev & cdfofint on fcdfora2 to upgrade to 8.1.7.4 
and install listener patch. 2 hour estimate</pre>
<!-- Author: nstanfield  -->
<!-- Comment: Thu Aug 29 09;11;46 comment by...ns -->
<pre>upgrade complete</pre>
<!-- Date: Thu Aug 29 07:29:26 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 

Tablespace Full 
Event test "Tablespace Full" is cleared 
CLEARED 
Aug 29 2002 07:27:50 AM 


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


<!-- Date: Thu Aug 29 07:49:50 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 

Maximum Extents 
Event test "Maximum Extents" is cleared 
CLEARED 
Aug 29 2002 07:48:16 AM 


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



<!-- Date: Thu Aug 29 10:31:37 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 


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


<!-- Date: Thu Aug 29 10:31:37 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 


From oem-admin@fnal.gov  Thu Aug 29 10:30:14 2002
Received: from heffalump.fnal.gov (heffalump.fnal.gov [131.225.9.20])
	by b0dau30.fnal.gov (SGI-8.9.3/8.9.3) with ESMTP id KAA36694
	for <cdf_elog@b0dau30.fnal.gov>; Thu, 29 Aug 2002 10:30:14 -0500 (CDT)
From: oem-admin@fnal.gov
Received: from VdmSMTPSession ([131.225.87.10])
 by smtp.fnal.gov (PMDF V6.0-24 #37519)
 with SMTP id <0H1M0012332C7C@smtp.fnal.gov> for cdf_elog@b0dau30.fnal.gov;
 Thu, 29 Aug 2002 10:30:12 -0500 (CDT)
Date: Thu, 29 Aug 2002 10:30:12 -0500 (CDT)
Date-warning: Date header was inserted by smtp.fnal.gov
Subject: JOB cdfofprd_ia_test COMPLETED
To: oem-admin@fnal.gov
Message-id: <0H1M0012432C7C@smtp.fnal.gov>

Name : cdfofprd_ia_test 
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 


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


<!-- Date: Thu Aug 29 11:17:38 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : b0dau35.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 26505 ORA-00001: unique constraint (HDWDB_PRD.CU_PK) violated ORA-06512: at "HDWDB_PRD.CARDUPDATES18", line 17 ORA-04088: error during execution of trigger 'HDWDB_PRD.CARDUPDATES18' ORA-06512: at "HDWDB_PRD.HDWDB", line 607 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 11:16:23 AM 


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


<!-- Date: Thu Aug 29 17:53:47 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1 ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REF... 
WARNING 
Aug 29 2002 05:52:13 PM 


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



<!-- Date: Thu Aug 29 17:54:33 2002 -->
<pre>CALIBRATION/SCHEMA/V_5_3 
 
Executed cut 4_5_3 with the following changes. 
Tables PEMLASER and PHALASER need to be dropped  
from replication and then added back in. 
 
---------------------------------------------------------------- 
RELEASE NOTES FOR CALIBDB VERSION V_5_3 
Author: Jack Cranshaw 
Date: 8/29/2002 
 
1) Add data tables 
CCRDeadChannels (precut) 
CPRDeadChannels (precut) 
CEMBadChannels   (precut) 
PEMBadChannels (precut) 
CESDeadChannels  (precut) 
CHABadChannels   (precut) 
PHABadChannels (precut) 
CLCfitCalib    (precut)   
CLCpedCalib    (precut)   
WHABadChannels (precut) 
CLCsppCalib (precut) 
 
2) Replaced data tables 
PEMLaser 
PHALaser 
 
3) Add STY, STZ, SALPHA_X columns to the SIALIGNWAFER table. (precut) 
 
4) Fix trigger PS_BEF_I because it was not  
allowing concurrent non-retired passnames for  
different process_name's.</pre>
<!-- Author: jcranshaw -->

<!-- Date: Thu Aug 29 18:09:01 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1 ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REF... 
WARNING 
Aug 29 2002 06:07:14 PM 


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


<!-- Date: Thu Aug 29 18:20:42 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 29 2002 06:18:43 PM 


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


<!-- Date: Thu Aug 29 18:23:57 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 06:22:15 PM 


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


<!-- Date: Thu Aug 29 18:39:20 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 06:37:16 PM 


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


<!-- Date: Thu Aug 29 18:53:50 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 06:52:17 PM 


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


<!-- Date: Thu Aug 29 19:09:26 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 07:07:18 PM 


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


<!-- Date: Thu Aug 29 19:20:46 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 29 2002 07:18:44 PM 


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


<!-- Date: Thu Aug 29 19:24:00 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 07:22:19 PM 


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


<!-- Date: Thu Aug 29 19:39:24 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 07:37:20 PM 


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


<!-- Date: Thu Aug 29 19:53:53 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 07:52:21 PM 


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


<!-- Date: Thu Aug 29 20:09:53 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 08:07:22 PM 


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


<!-- Date: Thu Aug 29 20:20:21 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 29 2002 08:18:44 PM 


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


<!-- Date: Thu Aug 29 20:24:34 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 08:22:23 PM 


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


<!-- Date: Thu Aug 29 20:39:08 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 08:37:24 PM 


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


<!-- Date: Thu Aug 29 20:55:50 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 08:52:25 PM 


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


<!-- Date: Thu Aug 29 21:08:53 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 09:07:26 PM 


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


<!-- Date: Thu Aug 29 21:20:39 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 29 2002 09:18:45 PM 


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


<!-- Date: Thu Aug 29 21:25:01 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 09:22:27 PM 


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


<!-- Date: Thu Aug 29 21:39:31 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 09:37:28 PM 


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


<!-- Date: Thu Aug 29 21:54:01 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 09:52:29 PM 


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


<!-- Date: Thu Aug 29 22:09:22 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 10:07:30 PM 


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


<!-- Date: Thu Aug 29 22:20:56 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 29 2002 10:18:46 PM 


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


<!-- Date: Thu Aug 29 22:23:56 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 10:22:31 PM 


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


<!-- Date: Thu Aug 29 22:39:35 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 10:37:32 PM 


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


<!-- Date: Thu Aug 29 22:54:06 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 10:52:34 PM 


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


<!-- Date: Thu Aug 29 23:10:41 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 11:07:35 PM 


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


<!-- Date: Thu Aug 29 23:20:26 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 29 2002 11:18:48 PM 


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


<!-- Date: Thu Aug 29 23:24:58 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 11:22:37 PM 


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


<!-- Date: Thu Aug 29 23:39:40 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 11:37:37 PM 


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


<!-- Date: Thu Aug 29 23:54:10 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 29 2002 11:52:38 PM 


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


<!-- Date: Fri Aug 30 00:09:12 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 12:07:39 AM 


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


<!-- Date: Fri Aug 30 00:21:06 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 12:18:49 AM 


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


<!-- Date: Fri Aug 30 00:21:06 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Process Limit 
The process usage is reaching its limit.  Current value: 103, limit: 200. 
WARNING 
Aug 30 2002 12:19:20 AM 


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


<!-- Date: Fri Aug 30 00:25:14 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 12:22:40 AM 


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


<!-- Date: Fri Aug 30 00:39:45 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 12:37:42 AM 


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


<!-- Date: Fri Aug 30 00:54:17 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 12:52:43 AM 


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


<!-- Date: Fri Aug 30 01:09:23 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 01:07:44 AM 


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


<!-- Date: Fri Aug 30 01:20:26 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 01:18:49 AM 


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


<!-- Date: Fri Aug 30 01:21:12 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Process Limit 
The process usage is reaching its limit.  Current value: 123, limit: 200. 
CRITICAL 
Aug 30 2002 01:19:22 AM 


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


<!-- Date: Fri Aug 30 01:24:36 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 01:22:45 AM 


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


<!-- Date: Fri Aug 30 01:39:50 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 01:37:46 AM 


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


<!-- Date: Fri Aug 30 01:54:20 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 01:52:47 AM 


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


<!-- Date: Fri Aug 30 02:09:28 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 02:07:48 AM 


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



<!-- Date: Fri Aug 30 02:12:02 2002 -->
<pre>Hi, 
 
Due to the problem discussed this evening on cdfdb-support with the 
present test version of the ProductionExe, we are running high on our 
total number of connections to the offline database.  I monitored it for 
an hour or two, and it slowly rose over that period from about 70 total 
connctions to over 120. 
 
Presumably this will not rise much further, since the production farm 
seems to be full right now.  However, if the total number continues to 
rise over the evening, we could be in trouble by the morning. 
 
I created a special version of the show_users script that Anil had written 
earlier to facilitate session killing by hand, this one altered to list 
only those users whose total time inactive exceeds 1000 seconds.  The name 
of this is show_users_gt1000.sql and it is in the oracle account directory 
on fcdfora1.  This could be used (just follow the built-in intsructions) 
to safely terminate the longest of the inactive sessions by the morning if 
needed without affecting the normal execution of the ProductionExe jobs, 
I believe.  If te ODS DBAs are paged or if the problem appears to be 
worse by the morning, I believe it would be OK for them to run this  
procedure for the cdfprod0 osuser sessions to try to free up connection 
slots. 
 
Of course this is just a manual version of sniping, which should be 
coming to an offline server in your neighborhood sometime soon... 
</pre>
<!-- Author: Alan Sill -->

<!-- Date: Fri Aug 30 02:20:16 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 02:18:50 AM 


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


<!-- Date: Fri Aug 30 02:24:26 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 02:22:49 AM 


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


<!-- Date: Fri Aug 30 02:39:54 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 02:37:50 AM 


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


<!-- Date: Fri Aug 30 02:54:23 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 02:52:51 AM 


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


<!-- Date: Fri Aug 30 03:10:14 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 03:07:53 AM 


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


<!-- Date: Fri Aug 30 03:20:39 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 03:18:51 AM 


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


<!-- Date: Fri Aug 30 03:24:49 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 03:22:53 AM 


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


<!-- Date: Fri Aug 30 03:39:22 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 03:37:54 AM 


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


<!-- Date: Fri Aug 30 03:54:29 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 03:52:55 AM 


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


<!-- Date: Fri Aug 30 04:10:35 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 04:07:56 AM 


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


<!-- Date: Fri Aug 30 04:20:59 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 04:18:53 AM 


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


<!-- Date: Fri Aug 30 04:25:09 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 04:22:57 AM 


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


<!-- Date: Fri Aug 30 04:39:46 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 04:37:58 AM 


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


<!-- Date: Fri Aug 30 04:56:25 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 04:52:59 AM 


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


<!-- Date: Fri Aug 30 05:10:59 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 05:08:00 AM 


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


<!-- Date: Fri Aug 30 05:21:08 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 05:18:53 AM 


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


<!-- Date: Fri Aug 30 05:25:17 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 05:23:01 AM 


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


<!-- Date: Fri Aug 30 05:40:08 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 05:38:02 AM 


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


<!-- Date: Fri Aug 30 05:54:39 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 05:53:03 AM 


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


<!-- Date: Fri Aug 30 06:10:18 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 06:08:04 AM 


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


<!-- Date: Fri Aug 30 06:20:40 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 06:18:54 AM 


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


<!-- Date: Fri Aug 30 06:24:49 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 06:23:05 AM 


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


<!-- Date: Fri Aug 30 06:40:13 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 06:38:06 AM 


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


<!-- Date: Fri Aug 30 06:54:43 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 06:53:07 AM 


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


<!-- Date: Fri Aug 30 07:21:39 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 07:18:57 AM 


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


<!-- Date: Fri Aug 30 07:54:45 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1. 
WARNING 
Aug 30 2002 07:53:12 AM 


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


<!-- Date: Fri Aug 30 08:20:26 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Aug 30 2002 08:18:58 AM 


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


<!-- Date: Fri Aug 30 08:40:25 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1 ORA-12012: error on auto execute of job 3442 ORA-12031: cannot use primary key columns from snapshot log on "CALIB_PRD"."PEMLASER" ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REF... 
WARNING 
Aug 30 2002 08:38:15 AM 


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