<!-- Title: 08:17:51  Mon Jun 17 2002 -->
<!-- Crewchief: New Day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Mon Jun 17 08:18:23 2002 -->
<pre>1.   reran rmans on cdfondev & cdfonint they failed 
they were pointing to /backup0  changed rman's to point 
to backup 
 
2.  turned back on all of toolman's cron jobs</pre>
<!-- Author: nstanfield -->
<!-- Comment: Mon Jun 17 09;17;50 comment by...ns -->
<pre>Issues: 

1) rman has a snapshot control file that still knows about the catalog.. need to unregister the db from the catalog..
(diana will handle)

2) toolman's failing with 
*needs further investigation

. bin/bootstrap_toolman_cron; every5min

produced the following output:

INFORMATIONAL: Product 'oracle_db_config' (with qualifiers 'cdfondev'), has no current chain (or may not exist)
</pre>


<!-- Date: Mon Jun 17 11:07:38 2002 -->
<pre>Still our infamous  open cursors error. 
Data does get loaded, just not this round, next round. 
Oracle recommended 1) up open_cursors 2) go to 8.1.7.4 
We are starting to put the 8.1.7.4 patch on 
machines --&gt; to see how it goes... 
 
 
 
 
Name : cdfonprd_dg_alert_log 
Target Name : listener_b0dau35 
Target Type : Listener 
Node Name : b0dau35.fnal.gov 
 
Data Gatherer Alert 
The following errors are in the Data Gatherer alert file:DBA-01229: Error: DBA_get_sample failed in call to update runtime tables ODG-05014: Error: call to collection cartridge failed ODG-05560: Error: failed calling collection cartridge ODG-05789: Error: data gathering failed in CP thread 
CRITICAL 
Jun 17 2002 10:22:53 AM 
</pre>
<!-- Author: ns -->

<!-- Date: Mon Jun 17 14:56:35 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: 128, limit: 200. 
CRITICAL 
Jun 17 2002 02:55:14 PM 


</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Mon Jun 17 19;12;47 comment by...ns -->
<pre>&gt; more users.15_00
Mon Jun 17 15:02:46 CDT 2002
Information for: cdfofprd

PID            SID Serial# Username     OS Username  Machine              Program
---------- ------- ------- ------------ ------------ -------------------- ----------------------------------------
20876           67      73 ACE          ace          b0dau32              DFC_logger@b0dau32 (TNS V1-V3)
14369          119     120 CDFPBOT      giolo        fcdfsgi2             AC++Dump@fcdfsgi2 (TNS V1-V3)
16049           58     -23 CDF_FETCH    oracle       jdbcclient           JDBC-1.0-Client
16168          150      88 CDF_FETCH    oracle       jdbcclient           JDBC-1.0-Client
16468          156      27 CDF_READER   cafuser      fcdfcaf002.fnal.gov  ./BtoJpsiKFind@fcdfcaf002.fnal.gov (TNS
                                                                          V1-V3)

16339          185      51 CDF_READER   cafuser      fcdfcaf003.fnal.gov  ./BtoJpsiKFind@fcdfcaf003.fnal.gov (TNS
                                                                          V1-V3)

15893           71      30 CDF_READER   cafuser      fcdfcaf003.fnal.gov  ./BtoJpsiKFind@fcdfcaf003.fnal.gov (TNS
                                                                          V1-V3)

16613            7      80 CDF_READER   cafuser      fcdfcaf004.fnal.gov  ./BtoJpsiKFind@fcdfcaf004.fnal.gov (TNS
                                                                          V1-V3)

16516           55     -22 CDF_READER   cafuser      fcdfcaf005.fnal.gov  ./BtoJpsiKFind@fcdfcaf005.fnal.gov (TNS
                                                                          V1-V3)

16481           22     -61 CDF_READER   cafuser      fcdfcaf006.fnal.gov  ./BtoJpsiKFind@fcdfcaf006.fnal.gov (TNS
                                                                          V1-V3)

16640           68      38 CDF_READER   cafuser      fcdfcaf006.fnal.gov  ./BtoJpsiKFind@fcdfcaf006.fnal.gov (TNS
                                                                          V1-V3)

16508           99      73 CDF_READER   cafuser      fcdfcaf007.fnal.gov  ./BtoJpsiKFind@fcdfcaf007.fnal.gov (TNS
                                                                          V1-V3)

16397           97    -107 CDF_READER   cafuser      fcdfcaf008.fnal.gov  ./BtoJpsiKFind@fcdfcaf008.fnal.gov (TNS
                                                                          V1-V3)

16107          193       9 CDF_READER   cafuser      fcdfcaf008.fnal.gov  ./BtoJpsiKFind@fcdfcaf008.fnal.gov (TNS
                                                                          V1-V3)

16221           41      48 CDF_READER   cafuser      fcdfcaf010.fnal.gov  ./BtoJpsiKFind@fcdfcaf010.fnal.gov (TNS
                                                                          V1-V3)

16109          118     -68 CDF_READER   cafuser      fcdfcaf012.fnal.gov  ./BtoJpsiKFind@fcdfcaf012.fnal.gov (TNS
                                                                          V1-V3)

15859           69      71 CDF_READER   cafuser      fcdfcaf013.fnal.gov  ./BtoJpsiKFind@fcdfcaf013.fnal.gov (TNS
                                                                          V1-V3)

16317          192      60 CDF_READER   cafuser      fcdfcaf014.fnal.gov  ./BtoJpsiKFind@fcdfcaf014.fnal.gov (TNS
                                                                          V1-V3)

16301          153     -49 CDF_READER   cafuser      fcdfcaf015.fnal.gov  ./BtoJpsiKFind@fcdfcaf015.fnal.gov (TNS
                                                                          V1-V3)

16439          117      96 CDF_READER   cafuser      fcdfcaf018.fnal.gov  ./BtoJpsiKFind@fcdfcaf018.fnal.gov (TNS
                                                                          V1-V3)

16452          180      88 CDF_READER   cafuser      fcdfcaf018.fnal.gov  ./BtoJpsiKFind@fcdfcaf018.fnal.gov (TNS
                                                                          V1-V3)

16374          126      34 CDF_READER   cafuser      fcdfcaf020.fnal.gov  ./BtoJpsiKFind@fcdfcaf020.fnal.gov (TNS
                                                                          V1-V3)

16550          165     -55 CDF_READER   cafuser      fcdfcaf020.fnal.gov  ./BtoJpsiKFind@fcdfcaf020.fnal.gov (TNS
                                                                          V1-V3)

16305          123      52 CDF_READER   cafuser      fcdfcaf022.fnal.gov  ./BtoJpsiKFind@fcdfcaf022.fnal.gov (TNS
                                                                          V1-V3)

16606          163     -96 CDF_READER   cafuser      fcdfcaf022.fnal.gov  ./BtoJpsiKFind@fcdfcaf022.fnal.gov (TNS
                                                                          V1-V3)

16139          141     -51 CDF_READER   cafuser      fcdfcaf023.fnal.gov  ./BtoJpsiKFind@fcdfcaf023.fnal.gov (TNS
                                                                          V1-V3)

16642          113      32 CDF_READER   cafuser      fcdfcaf023.fnal.gov  ./BtoJpsiKFind@fcdfcaf023.fnal.gov (TNS
                                                                          V1-V3)

16270           12      -8 CDF_READER   cafuser      fcdfcaf024.fnal.gov  ./BtoJpsiKFind@fcdfcaf024.fnal.gov (TNS
                                                                          V1-V3)

16356           94      81 CDF_READER   cafuser      fcdfcaf025.fnal.gov  ./BtoJpsiKFind@fcdfcaf025.fnal.gov (TNS
                                                                          V1-V3)

16632          172    -121 CDF_READER   cafuser      fcdfcaf026.fnal.gov  ./BtoJpsiKFind@fcdfcaf026.fnal.gov (TNS
                                                                          V1-V3)

16194           28    -114 CDF_READER   cafuser      fcdfcaf027.fnal.gov  ./BtoJpsiKFind@fcdfcaf027.fnal.gov (TNS
                                                                          V1-V3)

16058          197      47 CDF_READER   cafuser      fcdfcaf028.fnal.gov  ./BtoJpsiKFind@fcdfcaf028.fnal.gov (TNS
                                                                          V1-V3)

16483           78      20 CDF_READER   cafuser      fcdfcaf030.fnal.gov  ./BtoJpsiKFind@fcdfcaf030.fnal.gov (TNS
                                                                          V1-V3)

15819          130    -103 CDF_READER   cafuser      fcdfcaf034.fnal.gov  ./BtoJpsiKFind@fcdfcaf034.fnal.gov (TNS
                                                                          V1-V3)

16538           30     -38 CDF_READER   cafuser      fcdfcaf034.fnal.gov  ./BtoJpsiKFind@fcdfcaf034.fnal.gov (TNS
                                                                          V1-V3)

16223          170    -102 CDF_READER   cafuser      fcdfcaf036.fnal.gov  ./BtoJpsiKFind@fcdfcaf036.fnal.gov (TNS
                                                                          V1-V3)

15870           32     -51 CDF_READER   cafuser      fcdfcaf036.fnal.gov  ./BtoJpsiKFind@fcdfcaf036.fnal.gov (TNS
                                                                          V1-V3)

15754           29     118 CDF_READER   cafuser      fcdfcaf037.fnal.gov  ./BtoJpsiKFind@fcdfcaf037.fnal.gov (TNS
                                                                          V1-V3)

16426          124     -87 CDF_READER   cafuser      fcdfcaf037.fnal.gov  ./BtoJpsiKFind@fcdfcaf037.fnal.gov (TNS
                                                                          V1-V3)

16383          179     -40 CDF_READER   cafuser      fcdfcaf038.fnal.gov  ./BtoJpsiKFind@fcdfcaf038.fnal.gov (TNS
                                                                          V1-V3)

15635           89      25 CDF_READER   cafuser      fcdfcaf039.fnal.gov  ./BtoJpsiKFind@fcdfcaf039.fnal.gov (TNS
                                                                          V1-V3)

16527          182    -119 CDF_READER   cafuser      fcdfcaf039.fnal.gov  ./BtoJpsiKFind@fcdfcaf039.fnal.gov (TNS
                                                                          V1-V3)

16065          138     127 CDF_READER   cafuser      fcdfcaf040.fnal.gov  ./BtoJpsiKFind@fcdfcaf040.fnal.gov (TNS
                                                                          V1-V3)

16126          196    -101 CDF_READER   cafuser      fcdfcaf042.fnal.gov  ./BtoJpsiKFind@fcdfcaf042.fnal.gov (TNS
                                                                          V1-V3)

16231           36     117 CDF_READER   cafuser      fcdfcaf042.fnal.gov  ./BtoJpsiKFind@fcdfcaf042.fnal.gov (TNS
                                                                          V1-V3)

16117          184    -126 CDF_READER   cafuser      fcdfcaf043.fnal.gov  ./BtoJpsiKFind@fcdfcaf043.fnal.gov (TNS
                                                                          V1-V3)

16240          178     114 CDF_READER   cafuser      fcdfcaf044.fnal.gov  ./BtoJpsiKFind@fcdfcaf044.fnal.gov (TNS
                                                                          V1-V3)

16380          103      61 CDF_READER   cafuser      fcdfcaf046.fnal.gov  ./BtoJpsiKFind@fcdfcaf046.fnal.gov (TNS
                                                                          V1-V3)

16124          200     -46 CDF_READER   cafuser      fcdfcaf047.fnal.gov  ./BtoJpsiKFind@fcdfcaf047.fnal.gov (TNS
                                                                          V1-V3)

15998           77     113 CDF_READER   cafuser      fcdfcaf048.fnal.gov  ./BtoJpsiKFind@fcdfcaf048.fnal.gov (TNS
                                                                          V1-V3)

16102           15     -73 CDF_READER   cafuser      fcdfcaf048.fnal.gov  ./BtoJpsiKFind@fcdfcaf048.fnal.gov (TNS
                                                                          V1-V3)

16433          183      83 CDF_READER   cafuser      fcdfcaf049.fnal.gov  ./BtoJpsiKFind@fcdfcaf049.fnal.gov (TNS
                                                                          V1-V3)

16100           88       6 CDF_READER   cafuser      fcdfcaf051.fnal.gov  ./BtoJpsiKFind@fcdfcaf051.fnal.gov (TNS
                                                                          V1-V3)

16505          198     -34 CDF_READER   cafuser      fcdfcaf052.fnal.gov  ./BtoJpsiKFind@fcdfcaf052.fnal.gov (TNS
                                                                          V1-V3)

16591          154    -126 CDF_READER   cafuser      fcdfcaf053.fnal.gov  ./BtoJpsiKFind@fcdfcaf053.fnal.gov (TNS
                                                                          V1-V3)

16119          148      96 CDF_READER   cafuser      fcdfcaf053.fnal.gov  ./BtoJpsiKFind@fcdfcaf053.fnal.gov (TNS
                                                                          V1-V3)

16556           25      -3 CDF_READER   cafuser      fcdfcaf054.fnal.gov  ./BtoJpsiKFind@fcdfcaf054.fnal.gov (TNS
                                                                          V1-V3)

16491          134     104 CDF_READER   cafuser      fcdfcaf055.fnal.gov  ./BtoJpsiKFind@fcdfcaf055.fnal.gov (TNS
                                                                          V1-V3)

16293          190     -33 CDF_READER   cafuser      fcdfcaf056.fnal.gov  ./BtoJpsiKFind@fcdfcaf056.fnal.gov (TNS
                                                                          V1-V3)

16250          111     -43 CDF_READER   cafuser      fcdfcaf057.fnal.gov  ./BtoJpsiKFind@fcdfcaf057.fnal.gov (TNS
                                                                          V1-V3)

16569           48       4 CDF_READER   cafuser      fcdfcaf057.fnal.gov  ./BtoJpsiKFind@fcdfcaf057.fnal.gov (TNS
                                                                          V1-V3)

16188           64    -108 CDF_READER   cafuser      fcdfcaf058.fnal.gov  ./BtoJpsiKFind@fcdfcaf058.fnal.gov (TNS
                                                                          V1-V3)

16280           43    -126 CDF_READER   cafuser      fcdfcaf059.fnal.gov  ./BtoJpsiKFind@fcdfcaf059.fnal.gov (TNS
                                                                          V1-V3)

16297          133     -80 CDF_READER   cafuser      fcdfcaf062.fnal.gov  ./BtoJpsiKFind@fcdfcaf062.fnal.gov (TNS
                                                                          V1-V3)

16343           21      41 CDF_READER   cafuser      fcdfcaf063.fnal.gov  ./BtoJpsiKFind@fcdfcaf063.fnal.gov (TNS
                                                                          V1-V3)

16353           39     105 CDF_READER   cafuser      fcdfcaf064.fnal.gov  ./BtoJpsiKFind@fcdfcaf064.fnal.gov (TNS
                                                                          V1-V3)

16260           49     -17 CDF_READER   cafuser      fcdfcaf066.fnal.gov  ./BtoJpsiKFind@fcdfcaf066.fnal.gov (TNS
                                                                          V1-V3)

15905           66      -1 CDF_READER   cafuser      fcdfcaf066.fnal.gov  ./BtoJpsiKFind@fcdfcaf066.fnal.gov (TNS
                                                                          V1-V3)

14361           95      20 CDF_READER   msmartin     lap4gospel.dhcp.fnal ./bin/Linux2-KCC_4_0/AssocTest@lap4gospe
                                                     .gov                 l.dhcp.f

16547          160     -72 CDF_READER   cafuser      fcdfcaf005.fnal.gov  ./bjf.exe@fcdfcaf005.fnal.gov (TNS V1-V3
                                                                          )

16392          151    -118 CDF_READER   cafuser      fcdfcaf051.fnal.gov  ./bjf.exe@fcdfcaf051.fnal.gov (TNS V1-V3
                                                                          )

16567           35      31 CDF_READER   cafuser      fcdfcaf060.fnal.gov  ./bjf.exe@fcdfcaf060.fnal.gov (TNS V1-V3
                                                                          )

16327           20     -44 CDF_READER   cluster      farm13               /home/cdfsoft/dist/releases/4.5.0int7/bi
                                                                          n/Linux2

15502          158     -40 CDF_READER   cluster      farm5                /home/cdfsoft/dist/releases/4.5.0int7/bi
                                                                          n/Linux2

15852          168     -73 CDF_READER   cluster      farm5                /home/cdfsoft/dist/releases/4.5.0int7/bi
                                                                          n/Linux2

16578          174      83 CDF_READER   cluster      farm13               /home/cdfsoft/dist/releases/4.5.0int7/bi
                                                                          n/Linux2

15622           44     -18 CDF_READER   cluster      farm5                /home/cdfsoft/dist/releases/4.5.0int7/bi
                                                                          n/Linux2

15739          157     -16 CDF_READER   tmiao        ncdf118.fnal.gov     /home/tmiao/Jpsi/bin/Linux2-KCC_4_0/Jpsi
                                                                          Find@ncd

16565          137       3 CDF_READER   schmittm     fcdfsgi2             ChkGeom_test@fcdfsgi2 (TNS V1-V3)
23171          114    -107 CDF_READER   maxi         fcdfsgi2             DBANA@fcdfsgi2 (TNS V1-V3)
6792            62      95 CDF_READER   mmp          fcdfsgi2             Myana3@fcdfsgi2 (TNS V1-V3)
8458            80     -28 CDF_READER   mmp          fcdfsgi2             Myana3@fcdfsgi2 (TNS V1-V3)
7210           191     -32 CDF_READER   mmp          fcdfsgi2             Myana3@fcdfsgi2 (TNS V1-V3)
14571          104       6 CDF_READER   mmp          fcdfsgi2             Myana3@fcdfsgi2 (TNS V1-V3)
7829            34      -9 CDF_READER   mmp          fcdfsgi2             Myana3@fcdfsgi2 (TNS V1-V3)
7220            50     -76 CDF_READER   mmp          fcdfsgi2             Myana3@fcdfsgi2 (TNS V1-V3)
14855          203     -98 CDF_READER   baumgart     fcdfsgi2             StripBModule@fcdfsgi2 (TNS V1-V3)
24147          106     -13 CDF_READER   eikoyu       npenn01              bin/Linux2-KCC_4_0/construct_D0@npenn01
                                                                          (TNS V1-

24222          127      90 CDF_READER   eikoyu       npenn01              bin/Linux2-KCC_4_0/construct_D0@npenn01
                                                                          (TNS V1-

16319          186      51 CDF_READER   isamun       fcdfsgi2             main.exe@fcdfsgi2 (TNS V1-V3)
16352          164      35 CDF_READER   murat        murat01              root.exe@murat01 (TNS V1-V3)
16600           38     -55 CDF_READER   tara         fcdfsgi2             stnmaker.exe@fcdfsgi2 (TNS V1-V3)
16589           87     -74 CDF_READER   dwjang       fcdfsgi2             stnmaker.exe@fcdfsgi2 (TNS V1-V3)
16086          140     -79 CDF_READER   dwjang       fcdfsgi2             stnmaker.exe@fcdfsgi2 (TNS V1-V3)
16545           61      82 CDF_READER   tara         fcdfsgi2             stnmaker.exe@fcdfsgi2 (TNS V1-V3)
16199           59     -19 CDF_READER   dwjang       fcdfsgi2             stnmaker.exe@fcdfsgi2 (TNS V1-V3)
12234          195     -61 DATA_HISTORY oracle       fcdfora1             vppdc@fcdfora1 (TNS V1-V3)
12236          146     -40 DATA_HISTORY oracle       fcdfora1             vppdc@fcdfora1 (TNS V1-V3)
19203           14       1 DBREADER     oracle       fcdfora1             dbsnmp@fcdfora1 (TNS V1-V3)
16620          112     -82 DBREADER     toolman      fcdfora1             sqlplus@fcdfora1 (TNS V1-V3)
5603            10       4 DBSNMP       oracle       fcdfora1             dbsnmp@fcdfora1 (TNS V1-V3)
19201           13       1 DBSNMP       oracle       fcdfora1             dbsnmp@fcdfora1 (TNS V1-V3)
16602          166     -40 FILECATALOG_ mmp          fcdfsgi2             Myana3@fcdfsgi2 (TNS V1-V3)
                           READUSER

6246           108      88 FILECATALOG_ cdfdaq       b0dap67.fnal.gov     LumMon@b0dap67.fnal.gov (TNS V1-V3)
                           WRITEUSER

16244          169    -108 HERBER       oracle       jdbcclient           JDBC-1.0-Client
16309           65      40 REPADMIN_PRD oracle       fcdfora1
7333            33     -47 RUN_USER     cdf_cat      b0dap61              org.apache.tomcat.startup.Tomcat
2873            17      10 RUN_USER     cdf_cat      b0dap61              org.apache.tomcat.startup.Tomcat
16014          204     -98 RUN_USER     cdf_cat      b0dap61              org.apache.tomcat.startup.Tomcat
4700            86      -2 SAMDBS       sam          fndaut1
4707            40    -127 SAMDBS       sam          fndaut1
4702            46     -54 SAMDBS       sam          fndaut1
4705           161     111 SAMDBS       sam          fndaut1
19189            8       1              oracle       fcdfora1             oracle@fcdfora1 (ARC0)
19181            4       1              oracle       fcdfora1             oracle@fcdfora1 (CKPT)
19177            2       1              oracle       fcdfora1             oracle@fcdfora1 (DBW0)
19179            3       1              oracle       fcdfora1             oracle@fcdfora1 (LGWR)
19175            1       1              oracle       fcdfora1             oracle@fcdfora1 (PMON)
19185            6       1              oracle       fcdfora1             oracle@fcdfora1 (RECO)
19183            5       1              oracle       fcdfora1             oracle@fcdfora1 (SMON)
19187          162       1
&gt;  </pre>
<!-- Date: Mon Jun 17 15:25:48 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov 
Target Type : Database 
Node Name : fcdfora1.fnal.gov 

Process Limit 
Event test "Process Limit" is cleared 
CLEARED 
Jun 17 2002 03:25:14 PM 


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