Boa tarde a todos.
Cenário:
oracle@hostname:~> cat /etc/*release
LSB_VERSION="core-2.0-noarch:core-3.2-noarch:core-4.0-noarch:core-2.0-x86_64:core-3.2-x86_64:core-4.0-x86_64"
SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 1
oracle@hostname:~>
oracle@hostname:/u01/app/oracle/product/11gR2/db1/OPatch> ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle bancooration. All rights reserved.
Oracle Home : /u01/app/oracle/product/11gR2/db1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11gR2/db1/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location :
/u01/app/oracle/product/11gR2/db1/cfgtoollogs/opatch/opatch2012-12-12_15-54-30PM_1.log
Lsinventory Output file location :
/u01/app/oracle/product/11gR2/db1/cfgtoollogs/opatch/lsinv/lsinventory2012-12-12_15-54-30PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 13417321 : applied on Mon Nov 05 10:19:35 GMT-03:00 2012
Unique Patch ID: 14930814
Created on 11 Jun 2012, 14:32:38 hrs PST8PDT
Bugs fixed:
13417321
Patch 14275605 : applied on Sat Nov 03 14:18:30 GMT-03:00 2012
Unique Patch ID: 15367368
Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Created on 3 Oct 2012, 18:38:19 hrs PST8PDT
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
13657605, 13103913, 14063280
--------------------------------------------------------------------------------
OPatch succeeded.
Esse banco foi recentemente migrado (exp/imp) de 9i para 11g. Notei que a
geração de core dumps está altíssima. Segue:
oracle@hostname:/oraarchive1/tkt1059224> ls -ltrh |more
total 211M
drwxr-xr-x 2 oracle oinstall 108K 2012-12-04 09:15 cdmp_20121204091547
drwxr-xr-x 2 oracle oinstall 108K 2012-12-04 09:20 cdmp_20121204092010
drwxr-xr-x 2 oracle oinstall 108K 2012-12-04 09:35 cdmp_20121204093542
drwxr-xr-x 2 oracle oinstall 120K 2012-12-04 10:18 cdmp_20121204101813
drwxr-xr-x 2 oracle oinstall 108K 2012-12-04 11:24 cdmp_20121204112419
drwxr-xr-x 2 oracle oinstall 112K 2012-12-04 11:26 cdmp_20121204112639
drwxr-xr-x 2 oracle oinstall 116K 2012-12-04 13:53 cdmp_20121204135259
drwxr-xr-x 2 oracle oinstall 116K 2012-12-04 14:05 cdmp_20121204140519
drwxr-xr-x 2 oracle oinstall 124K 2012-12-04 14:06 cdmp_20121204140626
drwxr-xr-x 2 oracle oinstall 120K 2012-12-04 14:08 cdmp_20121204140802
drwxr-xr-x 2 oracle oinstall 112K 2012-12-04 14:37 cdmp_20121204143659
drwxr-xr-x 2 oracle oinstall 108K 2012-12-04 17:19 cdmp_20121204171858
drwxr-xr-x 2 oracle oinstall 104K 2012-12-04 17:45 cdmp_20121204174529
drwxr-xr-x 2 oracle oinstall 104K 2012-12-04 18:03 cdmp_20121204180301
drwxr-xr-x 2 oracle oinstall 100K 2012-12-04 18:05 cdmp_20121204180513
drwxr-xr-x 2 oracle oinstall 100K 2012-12-04 18:09 cdmp_20121204180911
drwxr-xr-x 2 oracle oinstall 108K 2012-12-05 09:24 cdmp_20121205092452
drwxr-xr-x 2 oracle oinstall 112K 2012-12-05 09:50 cdmp_20121205095049
drwxr-xr-x 2 oracle oinstall 108K 2012-12-05 11:54 cdmp_20121205115401
drwxr-xr-x 2 oracle oinstall 116K 2012-12-05 12:43 cdmp_20121205124324
drwxr-xr-x 2 oracle oinstall 112K 2012-12-05 13:59 cdmp_20121205135952
drwxr-xr-x 2 oracle oinstall 116K 2012-12-05 14:35 cdmp_20121205143529
drwxr-xr-x 2 oracle oinstall 108K 2012-12-05 15:03 cdmp_20121205150340
-rw-r----- 1 oracle oinstall 12M 2012-12-05 16:08 banco_ora_9481.trc
drwxr-xr-x 2 oracle oinstall 116K 2012-12-05 16:16 cdmp_20121205161648
drwxr-xr-x 2 oracle oinstall 104K 2012-12-05 16:26 cdmp_20121205162609
drwxr-xr-x 2 oracle oinstall 108K 2012-12-05 16:54 cdmp_20121205165430
drwxr-xr-x 2 oracle oinstall 112K 2012-12-05 16:56 cdmp_20121205165629
drwxr-xr-x 2 oracle oinstall 108K 2012-12-05 20:51 cdmp_20121205205116
drwxr-xr-x 2 oracle oinstall 108K 2012-12-06 07:10 cdmp_20121206071006
drwxr-xr-x 2 oracle oinstall 112K 2012-12-06 09:53 cdmp_20121206095301
drwxr-xr-x 2 oracle oinstall 120K 2012-12-06 09:54 cdmp_20121206095444
drwxr-xr-x 2 oracle oinstall 112K 2012-12-06 10:02 cdmp_20121206100218
drwxr-xr-x 2 oracle oinstall 116K 2012-12-06 10:05 cdmp_20121206100500
-rw-r----- 1 oracle oinstall 79M 2012-12-06 10:36 banco_ora_31420.trc
drwxr-xr-x 2 oracle oinstall 108K 2012-12-06 10:48 cdmp_20121206104821
oracle@hostname:/oraarchive1/tkt1059224>
Verifiquei dentro dos dirs, quase sempre a mesma estrutura de arquivos:
oracle@hostname:/oraarchive1/tkt1059224/cdmp_20121206104821> ls -ltrh |tail
-rw-r----- 1 oracle oinstall 8.1K 2012-12-06 10:48 banco_ora_10096_bucket.trm
-rw-r----- 1 oracle oinstall 68K 2012-12-06 10:48 banco_ora_10096_bucket.trc
-rw-r----- 1 oracle oinstall 7.6K 2012-12-06 10:48 banco_j002_6247_bucket.trm
-rw-r----- 1 oracle oinstall 54K 2012-12-06 10:48 banco_j002_6247_bucket.trc
-rw-r----- 1 oracle oinstall 7.1K 2012-12-06 10:48 banco_j002_17174_bucket.trm
-rw-r----- 1 oracle oinstall 54K 2012-12-06 10:48 banco_j002_17174_bucket.trc
-rw-r----- 1 oracle oinstall 6.6K 2012-12-06 10:48 banco_j001_3865_bucket.trm
-rw-r----- 1 oracle oinstall 68K 2012-12-06 10:48 banco_j001_3865_bucket.trc
-rw-r----- 1 oracle oinstall 8.2K 2012-12-06 10:48 banco_j001_17165_bucket.trm
-rw-r----- 1 oracle oinstall 44K 2012-12-06 10:48 banco_j001_17165_bucket.trc
oracle@hostname:/oraarchive1/tkt1059224/cdmp_20121206104821>
Analisando os arquivos, especialmente os que remetem a processos de job (J001):
oracle@hostname:/oraarchive1/tkt1059224/cdmp_20121206104821> more
banco_j001_17165_bucket.trc
Trace file
/u01/app/oracle/diag/rdbms/banco/banco/trace/cdmp_20121206104821/banco_j001_17165_bucket.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11gR2/db1
System name: Linux
Node name: hostname
Release: 2.6.32.59-0.7-default
Version: #1 SMP 2012-07-13 15:50:56 +0200
Machine: x86_64
Instance name: banco
Redo thread mounted by this instance: 1
Oracle process number: 956
Unix process pid: 17165, image: oracle@hostname (J001)
*** 2012-12-06 10:48:26.558
*** 2012-12-06 10:48:26.558
Process diagnostic dump for oracle@hostname (J001), OS id=17165,
pid: 956, proc_ser: 79, sid: <no session>
-------------------------------------------------------------------------------
Skipping session state dump because target process has no session.
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.000000 sec
(max dump time=30.000000 sec)
*** 2012-12-06 10:48:26.558
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default bucket for process 956 (osid: 17165, J001)
TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA
-------------------------------------------------------------------------------
2012-12-05
15:18:17.958486*:B68266BD:sql_mon_query:keswx.c@6216:keswxCurPushMonitoring():
monitoring already started for xsc=0x7ff072677fa0
2012-12-05
15:18:17.958486*:B68266BE:sql_mon_query:keswx.c@3076:keswxCurPushPlanMonitoring(begin):
xsc=0x7ff072677fa0 ctx=0x182a8c3260 li#=2 pe=0x17c74d9668
incarnation=22887
2012-12-05
15:18:17.958486*:B68266BF:sql_mon_query:keswx.c@3304:keswxCurPushPlanMonitoring(end):
xsc=0x7ff072677fa0 dis_mon=0
2012-12-05
15:18:17.958486*:B68266C0:sql_mon_query:keswx.c@6326:keswxCurPushMonitoring(end):
monitoring started for xsc=0x7ff072677fa0
2012-12-05
15:18:17.958486*:B68266C1:sql_mon_query:keswx.c@3338:keswxCurEndPlanMonitoringCb(begin):
xsc=0x7ff072677fa0 curCtx=0x7ff0726827d0 xsc->flg4=671767
04 flags=1
2012-12-05
15:18:17.958486*:B68266C2:sql_mon_query:keswx.c@3076:keswxCurPushPlanMonitoring(begin):
xsc=0x7ff072677fa0 ctx=0x182a8c3260 li#=2 pe=0x17c74d9668
incarnation=22887
2012-12-05
15:18:17.958486*:B68266C3:sql_mon_query:keswx.c@3304:keswxCurPushPlanMonitoring(end):
xsc=0x7ff072677fa0 dis_mon=0
2012-12-05
15:18:17.958486*:B68266C4:sql_mon_query:keswx.c@3540:keswxWriteEndInfoToStream(begin):
xsc=0x7ff072677fa0 curCtx=0x7ff0726827d0 endFlags=1 pxSlave
Cursor=0
2012-12-05
15:18:17.958486*:B68266C5:sql_mon_query:keswx.c@3737:keswxWriteEndInfoToStream(end):
done2012-12-05 15:18:17.958486*:B68266C6:sql_mon_query:keswx.
c@3432:keswxCurEndPlanMonitoringCb(): switching state for xsc=0x7ff072677fa0
pe=0x17c74d9668 endflag=1 flags=1 state=4
2012-12-05
15:18:17.958486*:B68266C7:sql_mon_query:keswx.c@3445:keswxCurEndPlanMonitoringCb(end):
monitoring has ended for xsc=0x7ff072677fa0
2012-12-05 15:34:40.847765 :B68E50D5:RAT_WCR:kecr.c@7131:kecrRecordRPC(): db is
not at RECORD mode
2012-12-05 15:34:40.849250 :B68E50D6:RAT_WCR:kecr.c@7131:kecrRecordRPC(): db is
not at RECORD mode
2012-12-05 15:34:41.130041 :B68E510C:RAT_WCR:kecr.c@7131:kecrRecordRPC(): db is
not at RECORD mode
2012-12-05 15:34:41.136494
:B68E510D:db_trace:ksl2.c@16009:ksl_update_post_stats(): [10005:956:1665] KSL
POST SENT postee=22 num=6 loc='ksa2.h LINE:285 ID:ks
asnd' id1=0 id2=0 name= type=0
2012-12-05 15:34:41.140940 :B68E5116:db_trace:ksl2.c@14563:ksliwat():
[10005:956:1665] KSL POST RCVD poster=22 num=13635895 loc='ksl2.h LINE:2362
ID:kslpsr'
id1=137 id2=0 name=EV type=0 fac#=3 posted=0x3 may_be_posted=1
2012-12-05 15:34:43.651904 :B68E5447:RAT_WCR:kecr.c@7131:kecrRecordRPC(): db is
not at RECORD mode
2012-12-05 15:34:43.750308
:B68E548C:db_trace:ksl2.c@16009:ksl_update_post_stats(): [10005:956:1665] KSL
POST SENT postee=22 num=7 loc='ksa2.h LINE:285 ID:ks
asnd' id1=0 id2=0 name= type=0
2012-12-05 15:34:43.751536 :B68E5491:db_trace:ksl2.c@14563:ksliwat():
[10005:956:1665] KSL POST RCVD poster=22 num=13635907 loc='ksl2.h LINE:2362
ID:kslpsr'
id1=137 id2=0 name=EV type=0 fac#=3 posted=0x3 may_be_posted=1
2012-12-05 15:34:43.755134 :B68E5496:db_trace:kss.c@1414:kssdch():
[10809:956:0] kssdch(0x18911c3d50 = process, 2) 2 0 exit
2012-12-05 15:34:43.755171 :B68E5497:db_trace:kst.c@700:kstpsodel():
[10280:956:0] kst: process state object about to be deleted
2012-12-05 15:37:30.146537 :B68F3651:db_trace:kst.c@675:kstipg(): [10280:956:0]
kst: process state object created on 12-05 15:37:30.146
2012-12-05 15:37:30.146537 :B68F3652:db_trace:kst.c@681:kstipg(): [10280:956:0]
kst: process info: ospid=15647 pso_num=956 pso_serial#=57
2012-12-05 15:37:30.146593 :B68F3653:db_trace:kso.c@4268:ksonfy():
[10420:956:0] kso: new process: pid=15647 (legacy spawn)
2012-12-05 15:37:30.155146 :B68F3654:db_trace:./ktdbas.h@994:ktddkgl():
[10300:956:1665] ktddkgl(0x185cd7c3f8, 1)
2012-12-05 15:37:30.155803 :B68F3655:db_trace:kss.c@1414:kssdch():
[10809:956:0] kssdch(0x18911c3d50 = process, 2) 2 0 exit
2012-12-05 15:37:30.155827 :B68F3656:db_trace:kst.c@700:kstpsodel():
[10280:956:0] kst: process state object about to be deleted
2012-12-05 15:37:30.360730 :B68F36A5:db_trace:kst.c@675:kstipg(): [10280:956:0]
kst: process state object created on 12-05 15:37:30.360
2012-12-05 15:37:30.360731 :B68F36A6:db_trace:kst.c@681:kstipg(): [10280:956:0]
kst: process info: ospid=15651 pso_num=956 pso_serial#=58
2012-12-05 15:37:30.360819 :B68F36A7:db_trace:kso.c@4268:ksonfy():
[10420:956:0] kso: new process: pid=15651 (legacy spawn)
2012-12-05 15:37:31.109418 :B68F37E0:KFNC:kfn.c@2622:kfnPrepareASM():
kfnPrepareASM CF ro=0 force=0 state_kfnsg=0x7
2012-12-05 15:37:31.208143 :B68F3814:db_trace:kcc.c@15070:kccwbp():
[10021:956:1665:1] 0115000000000000 0115000000000000 6e42020100000000
2012-12-05 15:37:31.221791 :B68F381A:KFNC:kfn.c@2622:kfnPrepareASM():
kfnPrepareASM CF ro=0 force=0 state_kfnsg=0x7
2012-12-05 15:37:31.498751 :B68F385A:db_trace:kcc.c@15070:kccwbp():
[10021:956:1665:1] 0115000000000000 0115000000000000 6f42020100000000
2012-12-05 15:37:36.255236 :B68F4061:KFNC:kfn.c@2622:kfnPrepareASM():
kfnPrepareASM CF ro=0 force=0 state_kfnsg=0x7
--More--(14%)
Não consegui identificar absolutamente NADA que possa estar causando isso...
rsrsrs
Alguém com algum histórico a respeito? Chiappa, alguma notícia de bug
relacionado a essa alta geração de dumps?
Att,/Regards,
Vitor Jr.
Infraestrutura / Infrastructure Team
Oracle 11g DBA Certified Professional - OCP
Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid
Infrastructure Administrator - OCE
Oracle Database 11g Performance Tuning Certified Expert - OCE
Oracle Exadata 11g Certified Implementation Specialist
Oracle Certified Associate, MySQL 5
mail, gtalk e msn: vitorj...@gmail.com
http://certificacaobd.com.br/
skype: vjunior1981
[As partes desta mensagem que não continham texto foram removidas]
