<!-- Title: 07:12:29  Thu Jul  8 2004 -->
<!-- Crewchief: New day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Thu Jul 8 07:17:52 2004 -->
<pre>Hi Folks, 
               I fired off the create indices script on cdfonprd at 
7:05am this morning. 
 
fcdflnx3:/cdf/home/msmartin/dbase_scripts/create_indices_jul7th/create_indices_prd.sql 
 
 
cheers 
 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:06 arch1_prd_298548.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:06 arch1_prd_298549.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:07 arch1_prd_298550.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:07 arch1_prd_298551.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:08 arch1_prd_298552.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:08 arch1_prd_298553.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:08 arch1_prd_298554.arc 
-rw-rw----   1 oracle   dba      20967936 Jul  8 07:08 arch1_prd_298555.arc 
-rw-rw----   1 oracle   dba      20969984 Jul  8 07:09 arch1_prd_298556.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:10 arch1_prd_298557.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:10 arch1_prd_298558.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:10 arch1_prd_298559.arc 
-rw-rw----   1 oracle   dba      20971008 Jul  8 07:11 arch1_prd_298560.arc 
 
 
ACTION:  I CLEANUP some earlier ARCHIVES--&gt;  REMINDER WHEN THE RMAN STARTS BACKING UP THE ARCHIVES WE CANNOT MIX & MATCH THE CLEANUP HAS TO BE DONE BY RMAN............  RIGHT NOW CDFONPRD's RMAN IS NOT YET BACKING UP THE ARCHIVES IF HE WAS I WOULD NOT GET AWAY WITH CLEANING UP THE RMAN JOB AS TO CLEANUP OR WE ARE OUT OF SYNC..   We can get back into sync in case we forget YET 
it's manual intervention.   
 
WE HAVE 40G available. 
 
</pre>
<!-- Author: nstanfield  -->
<!-- Comment: Thu Jul  8 11;49;53 comment by...ns  -->
<pre>completed replication --&gt;   estimate went way over   
beam_bunch_conditions & beam_bunch_conditions_full took over hour each to resync even ran them in parallel !    others tables were reasonable... </pre>
<!-- Comment: Thu Jul  8 15;26;48 comment by...Mat -->
<pre>Had to resubmit the index creation script because it only did the first 47 indices. This was because I was logged on from home and it logged me off half way through. I just observed the last 49 indices (ie all 97 including the first 47) being created successfully.</pre>
<!-- Comment: Thu Jul  8 15;42;55 comment by...ns  -->
Sun Microsystems Inc.   SunOS 5.7       Generic October 1998
> df -k /dbs8
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/vx/dsk/oradg/archlogvol
                     71303168 30126314 39891444    44%    /dbs8

<!-- Date: Thu Jul 8 07:30:04 2004 -->
<pre>start upgrade of oracle s/w to 9205 & analyze patch on fcdfora4  
estimated downtime 1.5 hours </pre>
<!-- Author: nstanfield  -->
<!-- Comment: Thu Jul  8 09;14;01 comment by...ns  -->
<pre>We have successfully completed our tasks regarding the Oracle Upgrade/Patch.

We will start the resync'g  of  the following tables, to cdfrep01 &
cdfofpr1.

There will be ~1.5 hour interruption.

All are RUNDB_PRD tables



csl_summary - New Columns
level3_conditions - New Columns
csl_conditions  - New Columns
downtime_history - New Columns
beam_conditions   - New Columns
beam_conditions_full - New Columns
beam_bunch_conditions - New Columns
beam_bunch_conditions_full    -   New Columns



runconfigurations - New Column (SELECTEDRUNSET)

runsections - New Columns ( BOILUM, BOTLUM, BOTLIV)



b) Drop/create indexes on cdfofpr1 and cdfrep01 for RUN_STATUS table of
RUNDB_PRD.



c) New Book called LUCCHESI to be replicated to cdfrep01


----- Original Message ----- 
From: "Dmitri Litvintsev" &lt;litvinse@fnal.gov&gt;
To: &lt;cdf_offline_operations@fnal.gov&gt;; &lt;cdf-farms@fnal.gov&gt;;
&lt;cdfdb-support@fnal.gov&gt;; &lt;CDFSAM-ADMIN@fnal.gov&gt;;
&lt;CDFSAM-SERVERS@fnal.gov&gt;; &lt;CDFSAM-USERS@fnal.gov&gt;; &lt;cdfdh_oper@fnal.gov&gt;;
&lt;cdf_csl@fnal.gov&gt;
Sent: Wednesday, July 07, 2004 1:01 PM
Subject: offline production downtime for Oracle patch tomorrow, 07/08/04
7:30 am


&gt; Dear Colleagues,
&gt;
&gt;         The offline production DB instance will be brought down
&gt; tomorrow 07/08/04 7:30 am for Oracle patch application. The expected
&gt; duration of the downtime is 1.5 hours.
&gt;
&gt;         affected systems:
&gt;
&gt;                 - Production Farms
&gt;                 - fcdfsgi1 data logger
&gt;                 - users of SAM
&gt;
&gt; regards,
&gt; Dmitri Litvintsev
&gt;
&gt; /----------------------------------------------------------\
&gt; | Tel:       (630) 840 5005                                |
&gt; | FAX:       (630) 840 2968                                |
&gt; | Pager:      847  536 6450                                |
&gt; | office:    149-L CDF Trailers                            |
&gt; | E-mail:    litvinse@fnal.gov                             |
&gt; \----------------------------------------------------------/
&gt;
</pre>
<!-- Date: Thu Jul 8 07:50:56 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : NODE UNREACHABLE 

Node UpDown 
 VNI-4009 : Cannot contact agent on the node. Agent may be down or network communication to the node has failed.  
NODE UNREACHABLE 
Jul 08 2004 07:50:15 AM 
Database UpDown 
Event test "Database UpDown" is cleared 
CLEARED 
Jun 15 2004 03:34:59 PM 



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


<!-- Date: Thu Jul 8 07:51:46 2004 -->
<pre>
Target Name : fcdfora4.fnal.gov 
Target Type : Node 
Node Name : fcdfora4.fnal.gov 
Status : NODE UNREACHABLE 

Node UpDown 
 VNI-4009 : Cannot contact agent on the node. Agent may be down or network communication to the node has failed.  
NODE UNREACHABLE 
Jul 08 2004 07:50:15 AM 



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


<!-- Date: Thu Jul 8 08:44:47 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Node UpDown 
Event test "Node UpDown" is cleared 
CLEARED 
Jul 08 2004 08:44:26 AM 
Database UpDown 
Event test "Database UpDown" is cleared 
CLEARED 
Jun 15 2004 03:34:59 PM 



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


<!-- Date: Thu Jul 8 08:44:47 2004 -->
<pre>
Target Name : fcdfora4.fnal.gov 
Target Type : Node 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Node UpDown 
Event test "Node UpDown" is cleared 
CLEARED 
Jul 08 2004 08:44:26 AM 



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




<!-- Date: Thu Jul 8 11:59:36 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 599 ORA-12008: error in materialized view refresh path ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 08 2004 11:58:48 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Thu Jul  8 13;07;32 comment by...akumar -->
<pre>This was due to index being rebuilt for one of the tables for RUNDB 
( which was synced-up today). 

During next run all jobs successfully completed. 
Ended: 07/08/04 12:43:59
** Total transactions.............     5
**   - successful........     5
**   - failed............     0
** ***************************************** **
** All commands were processed successfully.
** ***************************************** **
^A
All jobs processed successfully completed
^A
******************************************
</pre>



<!-- Date: Fri Jul 9 00:03:36 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 09 2004 12:03:17 AM 



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


<!-- Date: Fri Jul 9 00:04:08 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 09 2004 12:03:48 AM 



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


<!-- Date: Fri Jul 9 00:18:33 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CRITICAL 

Multiple Extents 
Segment SYS.SOURCE$ in tablespace SYSTEM is comprised of 281 extents. Segment CALIB_PRD.MLOG$_PEMQIE in tablespace MLOG_DATA is comprised of 1128 extents. Segment CALIB_PRD.MLOG$_CEMQIE in tablespace MLOG_DATA is comprised of 2410 extents. Segment CDFTRIG_PRD.GENERATED_DOWNLOADS in tablespace CDFTRIG_DATA is comprised of 392 extents. Segment MCS_PRD.MLOG$_LIMIT_HISTORIES in tablespace MLOG_DATA is comprised of 909 extents. Segment MCS_PRD.MLOG$_SENSOR_LIMITS in tablespace MLOG_DATA is comprised of 897 extents. Segment CALIB_PRD.MLOG$_CHAQIE in tablespace MLOG_DATA is comprised of 1970 extents. Segment MCS_PRD.MLOG$_SENSOR_HISTORIES in tablespace MLOG_DATA is comprised of 5252 extents. Segment CALIB_PRD.MLOG$_PHAQIE in tablespace MLOG_DATA is comprised of 1332 extents. Segment MCS_PRD.MLOG$_SENSORS in tablespace MLOG_DATA is comprised of 4948 extents. Segment CALIB_PRD.MLOG$_WHAQIE in tablespace MLOG_DATA is comprised of 947 extents. Segment CDFTRIG_PRD.GDS_CAPTOS_FK_I in tablespace C
CRITICAL 
Jul 09 2004 12:18:08 AM 



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



<!-- Date: Fri Jul 9 13:55:56 2004 -->
<pre>SAMINT@cdfofint has been refreshed form SAMPRD@cdfofprd 
 
Pl. start the SAM server compatibale with v5_1_1 schema. 
</pre>
<!-- Author: akumar -->


<!-- Date: Fri Jul 9 14:21:01 2004 -->
<table border=0><td><tr><td bgcolor=#e0e030><pre>Computer room AC alarms - High Temperatura</pre></td></tr></td></table>
<!-- Author: Sergei -->

<!-- Date: Sat Jul 10 00:03:40 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 10 2004 12:03:17 AM 



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


<!-- Date: Sat Jul 10 00:03:55 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 10 2004 12:03:48 AM 



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


<!-- Date: Sat Jul 10 02:34:48 2004 -->
<pre>
Target Name : b0dau35.fnal.gov 
Target Type : Node 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

CPU Utilization 
The CPU utilization is high.  Current utilization: 89. 
WARNING 
Jul 10 2004 02:33:41 AM 



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


<!-- Date: Sat Jul 10 02:49:18 2004 -->
<pre>
Target Name : b0dau35.fnal.gov 
Target Type : Node 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

CPU Utilization 
Event test "CPU Utilization" is cleared 
CLEARED 
Jul 10 2004 02:48:40 AM 



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


<!-- Date: Sun Jul 11 00:03:46 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 11 2004 12:03:16 AM 



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


<!-- Date: Sun Jul 11 00:04:03 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 11 2004 12:03:48 AM 



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


<!-- Date: Sun Jul 11 11:34:08 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

Process Limit 
The process usage is reaching its limit.  Current value: 167, limit: 200. 
WARNING 
Jul 11 2004 11:33:09 AM 



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


<!-- Date: Sun Jul 11 13:03:56 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CRITICAL 

Process Limit 
The process usage is reaching its limit.  Current value: 181, limit: 200. 
CRITICAL 
Jul 11 2004 01:03:08 PM 



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


<!-- Date: Sun Jul 11 14:03:14 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Process Limit 
Event test "Process Limit" is cleared 
CLEARED 
Jul 11 2004 02:03:06 PM 



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


<!-- Date: Sun Jul 11 23:09:47 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 376 ORA-12008: error in materialized view refresh path ORA-04031: unable to allocate 2216 bytes of shared memory ("shared pool","SENSOR_HISTORIESMCS_PRD_REP","KGLS heap","KGLS MEM BLOCK") ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 11 2004 11:08:48 PM 



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


<!-- Date: Mon Jul 12 00:03:40 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 12 2004 12:03:16 AM 



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


<!-- Date: Mon Jul 12 00:03:57 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 12 2004 12:03:48 AM 



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


<!-- Date: Mon Jul 12 00:20:14 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_INTERNAL_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 12:18:48 AM 



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


<!-- Date: Mon Jul 12 00:25:06 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 480 has failed 1 times. 
CRITICAL 
Jul 12 2004 12:24:54 AM 



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


<!-- Date: Mon Jul 12 01:25:17 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Jul 12 2004 01:24:54 AM 



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


<!-- Date: Mon Jul 12 01:29:26 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_DEFER_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4072 bytes of shared memory ("shared pool","DBMS_DEFER_QUERY_UTLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 3992 bytes of 
WARNING 
Jul 12 2004 01:28:48 AM 



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


<!-- Date: Mon Jul 12 01:39:49 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_DEFER_SYS_PART1","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 01:38:48 AM 



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


<!-- Date: Mon Jul 12 01:55:27 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4072 bytes of shared memory ("shared pool","DBMS_DEFER_QUERY_UTLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 01:53:49 AM 



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


<!-- Date: Mon Jul 12 02:04:02 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4040 bytes of shared memory ("shared pool","DBMS_REPUTIL2SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 3992 bytes of shared memory ("shared pool","DBMS_ASYNCRPC_PUSH","PL
WARNING 
Jul 12 2004 02:03:48 AM 



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


<!-- Date: Mon Jul 12 02:20:17 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_QUERY_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 3992 bytes of sha
WARNING 
Jul 12 2004 02:18:48 AM 



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


<!-- Date: Mon Jul 12 02:26:30 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 2 times. Job 378 has failed 2 times. Job 506 has failed 2 times. Job 480 has failed 5 times. Job 599 has failed 2 times. 
CRITICAL 
Jul 12 2004 02:24:54 AM 



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


<!-- Date: Mon Jul 12 02:30:38 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IRE
WARNING 
Jul 12 2004 02:28:48 AM 



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


<!-- Date: Mon Jul 12 02:38:55 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_DEFER_SYS_PART1","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 4096 bytes of sha
WARNING 
Jul 12 2004 02:38:48 AM 



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


<!-- Date: Mon Jul 12 02:55:29 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 02:53:48 AM 



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


<!-- Date: Mon Jul 12 03:04:05 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_DEFER_SYS_PART1","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 03:03:48 AM 



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


<!-- Date: Mon Jul 12 03:09:59 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 599 ORA-04031: unable to allocate 3424 bytes of shared memory ("shared pool","begin   sys.dbms_snapshot_ut...","PL/SQL MPCODE","pl/sql DS pg") ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 03:08:48 AM 



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


<!-- Date: Mon Jul 12 03:20:20 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS_PART1","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 03:18:48 AM 



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


<!-- Date: Mon Jul 12 03:26:38 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 480 has failed 10 times. 
CRITICAL 
Jul 12 2004 03:24:55 AM 



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


<!-- Date: Mon Jul 12 03:29:02 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_DEFER_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_QUERY_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 3960 bytes of sha
WARNING 
Jul 12 2004 03:28:48 AM 



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


<!-- Date: Mon Jul 12 03:39:11 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNA
WARNING 
Jul 12 2004 03:38:48 AM 



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


<!-- Date: Mon Jul 12 03:54:06 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4072 bytes of shared memory ("shared pool","DBMS_DEFER_QUERY_UTLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 4040 bytes of shared memory ("shared pool","DBMS_REPUTIL2SYS
WARNING 
Jul 12 2004 03:53:49 AM 



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


<!-- Date: Mon Jul 12 04:04:06 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1. 
WARNING 
Jul 12 2004 04:03:48 AM 



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


<!-- Date: Mon Jul 12 04:18:57 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_QUERY_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 3992 bytes of shared memory ("shared pool","DBMS_ASYNCRPC_PUSH"
WARNING 
Jul 12 2004 04:18:48 AM 



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


<!-- Date: Mon Jul 12 04:25:10 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 378 has failed 1 times. Job 506 has failed 1 times. Job 480 has failed 15 times. 
CRITICAL 
Jul 12 2004 04:24:54 AM 



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


<!-- Date: Mon Jul 12 04:29:18 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_INTERNAL_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","begin   sys.dbms_snapshot_ut...","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 376 ORA-04031: unable to allocate 3992 bytes of shared memory ("shared pool","DBMS_ASYNCRPC
WARNING 
Jul 12 2004 04:28:49 AM 



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


<!-- Date: Mon Jul 12 04:39:18 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 3992 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFR
WARNING 
Jul 12 2004 04:38:48 AM 



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


<!-- Date: Mon Jul 12 04:54:09 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNA
WARNING 
Jul 12 2004 04:53:48 AM 



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


<!-- Date: Mon Jul 12 05:04:34 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS_PART1","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_DEFER_SYS_PART
WARNING 
Jul 12 2004 05:03:49 AM 



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


<!-- Date: Mon Jul 12 05:20:30 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPS
WARNING 
Jul 12 2004 05:18:48 AM 



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


<!-- Date: Mon Jul 12 05:25:26 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 5 times. Job 378 has failed 4 times. Job 506 has failed 6 times. Job 480 has failed 20 times. Job 599 has failed 4 times. 
CRITICAL 
Jul 12 2004 05:24:54 AM 



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


<!-- Date: Mon Jul 12 05:29:07 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3992 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPS
WARNING 
Jul 12 2004 05:28:48 AM 



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


<!-- Date: Mon Jul 12 05:39:33 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBM
WARNING 
Jul 12 2004 05:38:48 AM 



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


<!-- Date: Mon Jul 12 05:54:03 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 39
WARNING 
Jul 12 2004 05:53:48 AM 



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


<!-- Date: Mon Jul 12 06:04:26 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 3992 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS
WARNING 
Jul 12 2004 06:03:48 AM 



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


<!-- Date: Mon Jul 12 06:18:55 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPS
WARNING 
Jul 12 2004 06:18:48 AM 



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


<!-- Date: Mon Jul 12 06:25:08 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 10 times. Job 378 has failed 9 times. Job 506 has failed 11 times. Job 480 has failed 25 times. Job 599 has failed 9 times. 
CRITICAL 
Jul 12 2004 06:24:54 AM 



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


<!-- Date: Mon Jul 12 06:29:16 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPS
WARNING 
Jul 12 2004 06:28:48 AM 



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


<!-- Date: Mon Jul 12 06:39:07 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPS
WARNING 
Jul 12 2004 06:38:48 AM 



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


<!-- Date: Mon Jul 12 06:54:06 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocat
WARNING 
Jul 12 2004 06:53:48 AM 



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


<!-- Date: Mon Jul 12 07:04:27 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SYS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPS
WARNING 
Jul 12 2004 07:03:48 AM 



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


<!-- Date: Mon Jul 12 07:18:56 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4088 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allo
WARNING 
Jul 12 2004 07:18:48 AM 



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


<!-- Date: Mon Jul 12 07:25:09 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 15 times. Job 378 has failed 14 times. Job 506 has failed 16 times. Job 480 has failed 30 times. Job 599 has failed 14 times. 
CRITICAL 
Jul 12 2004 07:24:54 AM 



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


<!-- Date: Mon Jul 12 07:39:39 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to a
WARNING 
Jul 12 2004 07:38:48 AM 



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


<!-- Date: Mon Jul 12 07:54:09 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: B
WARNING 
Jul 12 2004 07:53:48 AM 



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


<!-- Date: Mon Jul 12 08:04:19 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4040 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buf
WARNING 
Jul 12 2004 08:03:48 AM 



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


<!-- Date: Mon Jul 12 08:19:01 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAP_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAP_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","DBMS_SNAPSHOT","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: 
WARNING 
Jul 12 2004 08:18:48 AM 



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


<!-- Date: Mon Jul 12 08:25:14 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 19 times. Job 378 has failed 18 times. Job 506 has failed 20 times. Job 480 has failed 34 times. Job 599 has failed 18 times. 
CRITICAL 
Jul 12 2004 08:24:54 AM 



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


<!-- Date: Mon Jul 12 08:29:22 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4088 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allo
WARNING 
Jul 12 2004 08:28:48 AM 



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


<!-- Date: Mon Jul 12 08:39:16 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared 
WARNING 
Jul 12 2004 08:38:48 AM 



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


<!-- Date: Mon Jul 12 08:53:56 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4088 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared poo
WARNING 
Jul 12 2004 08:53:48 AM 



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


<!-- Date: Mon Jul 12 08:53:56 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4088 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared poo
WARNING 
Jul 12 2004 08:53:48 AM 



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


<!-- Date: Mon Jul 12 08:53:56 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4088 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared poo
WARNING 
Jul 12 2004 08:53:48 AM 



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


<!-- Date: Mon Jul 12 08:53:56 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4088 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared poo
WARNING 
Jul 12 2004 08:53:48 AM 



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


<!-- Date: Mon Jul 12 09:04:32 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4032 bytes of shared memory ("s
WARNING 
Jul 12 2004 09:03:48 AM 



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


<!-- Date: Mon Jul 12 09:19:07 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 3984 bytes of shared memory ("shared 
WARNING 
Jul 12 2004 09:18:48 AM 



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


<!-- Date: Mon Jul 12 09:25:27 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 24 times. Job 378 has failed 23 times. Job 506 has failed 25 times. Job 480 has failed 39 times. Job 599 has failed 23 times. 
CRITICAL 
Jul 12 2004 09:24:54 AM 



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


<!-- Date: Mon Jul 12 09:28:58 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("s
WARNING 
Jul 12 2004 09:28:48 AM 



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


<!-- Date: Mon Jul 12 09:39:01 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4016 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4016 bytes of shared memory ("shar
WARNING 
Jul 12 2004 09:38:48 AM 



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


<!-- Date: Mon Jul 12 09:54:30 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_SNAP_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794 ORA-04031: unable to allocate 4048 bytes of shared mem
WARNING 
Jul 12 2004 09:53:48 AM 



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


<!-- Date: Mon Jul 12 10:03:53 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4024 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buf
WARNING 
Jul 12 2004 10:03:48 AM 



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


<!-- Date: Mon Jul 12 10:19:07 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SQL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4024 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","DBMS_SYS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SQL", line 14 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4008 bytes of shared memory ("shared pool","
WARNING 
Jul 12 2004 10:18:48 AM 



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


<!-- Date: Mon Jul 12 10:25:23 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 29 times. Job 378 has failed 28 times. Job 506 has failed 30 times. Job 480 has failed 44 times. Job 599 has failed 28 times. 
CRITICAL 
Jul 12 2004 10:24:54 AM 



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


<!-- Date: Mon Jul 12 10:29:12 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT_UTL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","DBMS_SQLSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 795 ORA-04031: unable to allocate 4064 bytes of shared memory ("shar
WARNING 
Jul 12 2004 10:28:48 AM 



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


<!-- Date: Mon Jul 12 10:39:15 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAP_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAP_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAP_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794 ORA-04031: unable to allocate 4096 bytes of share
WARNING 
Jul 12 2004 10:38:48 AM 



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


<!-- Date: Mon Jul 12 10:54:07 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_IREFRESH", line 683 
WARNING 
Jul 12 2004 10:53:48 AM 



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


<!-- Date: Mon Jul 12 11:04:00 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","declare ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAPSHOT","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_SNAP_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794 ORA-04031: unable to allocate 4096 bytes
WARNING 
Jul 12 2004 11:03:48 AM 



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


<!-- Date: Mon Jul 12 11:18:58 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-12012: error on auto execute of job 480 ORA-12008: error in materialized view refresh path ORA-01089: immediate shutdown in progress - no operations are permitted ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 378 ORA-06550: line 1, column 59: ORA-06550: line 0, column 0: ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 ORA-12012: error on auto execute of job 506 ORA-06550: line 1, column 59: ORA-06550: line 0, column 0: ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 .... 
WARNING 
Jul 12 2004 11:18:48 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Mon Jul 12 11;29;26 comment by...akumar -->
<pre>During the last reboot an incorrect size
of oracle SGA was entered into ora.init file.

Now sga is set to 2.1GB 
Parameter changed : 
shared_pool_size 1.5GB  
db_cache_size 500MB    
log_buffers = 1M 

Commented out the values for sort_area_size and sort_area_retained_size since automatic memory management is implemented. 

SQL&gt; show sga 

Total System Global Area 2149372968 bytes
Fixed Size                   734248 bytes
Variable Size            1610612736 bytes
Database Buffers          536870912 bytes
Redo Buffers                1155072 bytes



</pre>
<!-- Date: Mon Jul 12 11:25:11 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Failed Jobs 
Job 376 has failed 34 times. Job 378 has failed 33 times. Job 506 has failed 35 times. Job 480 has failed 49 times. Job 599 has failed 33 times. 
CRITICAL 
Jul 12 2004 11:24:55 AM 



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




<!-- Date: Mon Jul 12 11:45:15 2004 -->
<pre>Upped the undo retention on cdfonprd and cdfofpr1 to 4 hours vs 1 hour during replication catch-up during shared_pool issue on cdfofpr1 during 07/11/04 11:00PM  and 07/11/04 11:30AM 
 
undo_retention = 14400 on cdfonprd and cdfofpr1 
 
Once replication will catch-up , undo_retension will be set to 3600 secs on both the databases. </pre>
<!-- Author: akumar -->
<!-- Comment: Mon Jul 12 12;30;01 comment by...akumar -->
<pre>Undo_retension is back to its original value of 3600 secs on cdfonprd and cdfofpr1 since replication synced-up</pre>
<!-- Date: Mon Jul 12 12:25:52 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Failed Jobs 
Event test "Failed Jobs" is cleared 
CLEARED 
Jul 12 2004 12:24:54 PM 



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



<!-- Date: Mon Jul 12 16:29:10 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-07445: exception encountered: core dump [00000001028F16D0] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CD80000] [] []. 
WARNING 
Jul 12 2004 04:28:49 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Mon Jul 12 17;09;19 comment by...akumar -->
<pre>*** SESSION ID:(42.3547) 2004-07-12 16:26:44.852

Current SQL statement for this session:
SELECT UNIQUE DDS.DATASET_NAME FROM CDFPBOT.CDF2_DATASETS DDS WHERE LOWER(DATASET_NAME) LIKE '%pythia%'

SQL&gt; /

     LT_ID USERNAME                       OSUSER
---------- ------------------------------ ------------------------------
DB_NAME
------------------------------
MACHINE
----------------------------------------------------------------
TERMINAL                       PROGRAM
------------------------------ ------------------------------------------------
PROCESS   IP_ADDRESS
--------- ------------------------------
NETWORK_PROTOCOL
--------------------------------------------------------------------------------
LOGON_TIM        SID    SERIAL# LOGOFF_TI   CPU_USED
--------- ---------- ---------- --------- ----------
CLIENT_INFO
----------------------------------------------------------------
  44325101 CDF_DBBROWSER                  oracle
cdfofpr1
ndbb02.fnal.gov
unknown                        JDBC Thin Client
          131.225.240.40
tcp
12-JUL-04         42       3547


Executed the above query successfully. 
SQL&gt; SELECT UNIQUE DDS.DATASET_NAME FROM CDFPBOT.CDF2_DATASETS DDS WHERE LOWER(DATASET_NAME) LIKE '%pythia%';

DATASET_NAME
----------------------------------------------------------------
GENRC-PYTHIA-BB-ULA-QQ-REALSI-TRIGSIM-4.9.0-V1
MC_PYTHIA_UL_A_QQ_GENERIC_BB_TWO_TRACK_TRIGGER
Only ccbar full Pythia. HepgBanks only.
PYTHIA_MSEL_5_QQ_GENERIC_2OPP_Q_PT&gt;1.5GEV_8RUNS_PreShutdown
Pythia(all qq, filter bb,Pt(b)&gt;3GeV,abs(eta)&lt;1.5),HepgOnly
Pythia(all qq, filter cc,Pt(c)&gt;3GeV,abs(eta)&lt;1.5),HepgOnly
Pythia, EvtGen(B -&gt; mu+ D X),l+SVT trigger, 5.3.1
Pythia_msel1_JPSIX_forBCbgnd
bbar and ccbar ful l Pythia. HepgBanks only.

9 rows selected.


So above error is not reproducible. So no action.</pre>


<!-- Date: Mon Jul 12 20:00:15 2004 -->
<pre>Dear CDF DBers, 
 
Could you please replicate the view: 
 
  L2PULSAR_CONFIGURATIONS 
 
onto the offline instances?    Should be non-invasive, as this is a brand new view. 
 
Thanks, 
Bill 
 
</pre>
<!-- Author: W.Badgett -->
<!-- Comment: Tue Jul 13 12;57;57 comment by...akumar  -->
<pre>L2PULSAR_CONFIGURATIONS view created on cdfofprd and cdfrep01. </pre>
<!-- Date: Tue Jul 13 00:04:02 2004 -->
<pre>
Target Name : cdfonprd 
Target Type : Database 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 13 2004 12:03:16 AM 



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


<!-- Date: Tue Jul 13 00:04:02 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Jul 13 2004 12:03:49 AM 



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


<!-- Date: Tue Jul 13 02:34:15 2004 -->
<pre>
Target Name : b0dau35.fnal.gov 
Target Type : Node 
Node Name : b0dau35.fnal.gov 
Status : WARNING 

CPU Utilization 
The CPU utilization is high.  Current utilization: 86. 
WARNING 
Jul 13 2004 02:33:41 AM 



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


<!-- Date: Tue Jul 13 02:49:13 2004 -->
<pre>
Target Name : b0dau35.fnal.gov 
Target Type : Node 
Node Name : b0dau35.fnal.gov 
Status : CLEARED 

CPU Utilization 
Event test "CPU Utilization" is cleared 
CLEARED 
Jul 13 2004 02:48:40 AM 



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


<!-- Date: Tue Jul 13 09:19:20 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Maximum Extents 
Segment FILECATALOG.RLT_RS_FK_I in tablespace FILECATALOG2_INDEX can only allocate 2 additional extents. Segment MCS_PRD_REP.SENS_SENST_FK_I in tablespace MCS_PRD_REP_INDEX can only allocate 2 additional extents. Segment LITVINSE.RR_PK in tablespace USERINDEX_01 can only allocate 2 additional extents. 
WARNING 
Jul 13 2004 09:19:09 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Tue Jul 13 09;38;38 comment by...akumar -->
<pre>Upped the max extents for MCS_PRD_REP.SENS_SENST_FK_I from 5 to 10.

Dmitri,
Please take care of FILECATALOG and LITVINSE max extents alerts. 
</pre>
<!-- Date: Tue Jul 13 09:31:18 2004 -->
<pre>
Target Name : cdfofpr1.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Maximum Extents 
Segment FILECATALOG.RLT_RS_FK_I in tablespace FILECATALOG2_INDEX can only allocate 2 additional extents. Segment LITVINSE.RR_PK in tablespace USERINDEX_01 can only allocate 2 additional extents. 
WARNING 
Jul 13 2004 09:29:09 AM 



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