Abnormal trace file generation in oracle 11gRAC

[aunshakeel]

I am facing this problem for some time now ….. i am having trouble with trace files on only one node ….

SYSTEM DETAILS
i have a 2 node production server …
IBM power 7 P750 servers
oracle version 11.2.0.3 RAC
RMAN not yet configured but logged in once to delete archiving logs

The issue is that on node 2 the trace files are generating on a huge level and i have to manually delete them every 2 hours other wise the space is filling up fast. And to add to my misery the trace files are generating in two separate locations

One location is the default oracle location folder which has a space of 200 gb and it is some how manageable by adrci

The main issue with me is that some files are getting created in the '/var' folder under '/tmp/oradiag_oracle/../../..' forlder also

and this /var folder is only 5 gb

if i ignore it for one hour the space reaches 100%

i am trying to find what traces are enabled on the system so i can disable any unwanted traces.

Can anyone help me by telling me how to check for enable tracing events and how to disable them manually

Thank you .

[Tim...]

Hi.

You've not said what the tracing is or what's generating it. You mentioned the "default oracle location folder". Do you mean "/home/oracle"? Nothing should be tracing there.

Cheers

Tim...

[aunshakeel]

hello Mr. Tim,
Well i refer to the files as trace files coz the file extensions are *.trc and *.trm.
i have not enabled any tracing that is why i am shocked how the files are generating on a large scale.
the files are generating in two separatae places
First is the oracle installation directory /u0/app/oracle
and the second is /var/tmp/oradiag_oracle/cdiag/rdbms/clients/user_oracle/host_xxxxxxxx

[Tim...]

Hi.

OK. So they are Oracle trace files then.

My next question would be, have you checked the alert log to see if it mentioned why these trace files are getting generated. If they are being caused by an error, it should be logged in the alert log.

At the same time I would consider raising an SR with Oracle support about the excessive tracing. This may be a known issue on your platform.

Cheers

Tim...

[aunshakeel]

i would like to add a couple of points here.
1. these trace files have no mention in my original alert log file. However there is log file in the trace folder in the /var filesystem where only this error is logged.

2. here is the complete trace file output.

Dump file /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1_i3877017.trc
Dump continued from file: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1.trc
ORA-07445: exception encountered: core dump [ksmpclrpga()+23296] [SIGSEGV] [ADDR:0x109A1BD28] [PC:0x101E2E540] [Invalid permissions for mapped object] []
========= Dump for incident 3877017 (ORA 7445) ========
----- Beginning of Customized Incident Dump(s) -----
----- End of Customized Incident Dump(s) -----
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
Executing ASYNC actions
----- START DDE Action: 'dumpFrameContext' (Sync) -----
----- START Frame Context DUMP -----
Status: 0
---------------------------------------------------------------------------
<Empty>
---------------------------------------------------------------------------
----- END Frame Context DUMP -----
----- END DDE Action: 'dumpFrameContext' (SUCCESS, 0 csec) -----
----- START DDE Action: 'dumpBuckets' (Sync) -----
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default trace bucket
TIME(*=approx):SEQ:COMPONENT:FILE@LINE: DATA
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Trace Bucket Dump End: default trace bucket
----- END DDE Action: 'dumpBuckets' (SUCCESS, 0 csec) -----
----- START DDE Action: 'dumpDiagCtx' (Sync) -----
------- Diag Context Dump -------
----- General DiagCtx Dump -----
Serial#: 3
Status: 3
Flags: 0x15
Usage type: 0
Diag Fixed SGA information:
Status: 2
Flags: 0x0
Incident Flag: UNSET
Heap: 0x1106c96f0
Flood Control information:
Initialized: NO
Enabled: NO
Diag init parameters:
Flags: 0x1
Base Flag: 0x1
Options: 0x86
ADR option: 1
ADR Base: '/var/tmp/oradiag_oracle'
Product Type: 4
Product ID: 'user_oracle'
Instance ID: 'host_1545611351_80'
Flood Control Gate: 0x0
Flood Control Ctx size: 0
ADR default lib ID: 0
UTS in mem trace enabled: TRUE
UTS default bucket size: 4294967295
UTS default bucket: 0x0
Incident ID cache cbf: 0x0
Incident ID cache pop init: FALSE
UTS default trace file attr:
Flags: 0x0
Prefix: ''
PIDStr: ''
Suffix: ''
Notify cbk: 0x0
Size limits: 0
Size cbk: 0x0
DDE alive update cbk: 0x0
DDE alive start cbk: 0x0
DDE alive clear cbk: 0x0
Custom Flood Control cbk: 0x0
----- END General DiagCtx Dump -----
----- DDE Diagnostic Information Dump -----
Depth: 1
DDE flags: 0x0
Heap: 0x1106e84b8
Incident Context pointer in diag: 0x11083ea98
Incident ID Cache: 0x1106f96d8 (PGA)
Invocation Context #: 0
----- Invocation Context Dump -----
Address: 0x1106f02f8
Phase: 3
flags: 0x10E0005
Incident ID: 3877017
Error Descriptor: ORA-7445 [ksmpclrpga()+23296] [SIGSEGV] [ADDR:0x109A1BD28] [PC:0x101E2E540] [Invalid permissions for mapped object] [] [] [] [] [] [] []
Error class: 0
Problem Key # of args: 0
Number of actions: 9
----- Incident Context Dump -----
Address: 0x11083ea98
Incident ID: 3877017
Problem Key: ORA 7445
Error: ORA-7445 [ksmpclrpga()+23296] [SIGSEGV] [ADDR:0x109A1BD28] [PC:0x101E2E540] [Invalid permissions for mapped object] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: dbgeEndDDEInvocation [diag_dde]
[03]: ssexhd []
[04]: 47f8 []<-- Signaling
[05]: opidcl []
[06]: opidrv []
[07]: sou2o []
[08]: opimai_real []
[09]: ssthrdmain []
[10]: main []
[11]: __start []
MD [00]: 'Client ProcId'='oracle@sihibmn2.24838300_1' (0x0)
Impact 0:
Impact 1:
Impact 2:
Impact 3:
Derived Impact:
----- END Incident Context Dump -----
----- END Invocation Context Dump -----
Invocation Context #: 1
----- Invocation Context Dump -----
Address: 0x1106f24b0
Phase: 0
flags: 0x0
Incident ID: 0
Error Descriptor:
Error class: 0
Problem Key # of args: 0
Number of actions: 0
----- END Invocation Context Dump -----
----- END DDE Diagnostic Information Dump -----
----- UTS Diagnostic Information Dump (addr=0x11087f670) -----
flags_dbgtc=0x44 seq_ptr_dbgtc=0x11068c248
def_bucket_dbgtc=0x1106d6858 gid_dbgtc=20
defTraceFile_dbgtc=0x1106e8f60 fstack_dbgtc=0x11087f600
lastEpochTsOutputted_dbgtc=412011185194127 lastRecWriteDumpMs_dbgtc=0
recWriteDepth_dbgtc=0 numRecWriteDumps_dbgtc=0
==== Dumping UTS file=0x1106e8f60 desc=default ====
Type=2 flags=0 err=0 cbk=0x11036c140 sctx=0x0
--- Dumping UTS file (ADR type) file=0x1106e8f60 ---
File name: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1.trc
flags=0x1106e8f60 needInit=515 nfyMasked=0 bytes=0
attrib: flags=0x0 pref=ora pid=24838300_1 suffix=
limit=18446744073709551615 nfy=0x0
--- Dumping file stack addr=0x11087f600 cnt=1 ---
Pos=0 fileP=0x1106f0ba8
==== Dumping UTS file=0x1106f0ba8 desc=stack ====
Type=2 flags=0 err=0 cbk=0x11036c140 sctx=0x0
--- Dumping UTS file (ADR type) file=0x1106f0ba8 ---
File name: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1_i3877017.trc
flags=0x1106f0ba8 needInit=555 nfyMasked=0 bytes=0
attrib: flags=0x0 pref=ora pid=24838300_1 suffix=i3877017
limit=18446744073709551615 nfy=0x0
----- END UTS Diagnostic Information Dump -----
----- Events Diagnostic Information Dump -----
Active Fast Chk Desc in DiagCtx is 0x0
Active Event group is Default Group
--- Dump of Event Group ---
Event Group desc : Default/Active Event Group
Located at Address 0x11087f5b0
Event group id 1
Event group version 1
Event group heap 0x1106c9470
Fast Check Descriptor is NULL

----- END Events Diagnostic Information Dump -----
----- ADR Diagnostic Information Dump -----
ADR Flags: 0x1e01
Retries: 1
ADR Home #0
ADR Id: 1688299656
Create Id: 3016083015
Base Flag: 0x1
Product Type: 4
Product Name: clients
Product Id: user_oracle
Instance Id: host_1545611351_80
Base Directory: /var/tmp/oradiag_oracle
Home Directory: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80
Relative Path: diag/clients/user_oracle/host_1545611351_80/
Home Loc #0: 0
Test Action: 0x0, 0
----- ADS Open Files Dump -----
################ Open Stream File: 0 ################
PathFile: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1.trc
OpFlag: 10, Status: 1, MagicBeg: 2153609765, MagicNum: 3593058129
Stream Access
----- ADS Stream Desc Dump -----
fd: 23
----- END ADS Stream Desc Dump -----
File Name Fragment: 51_80/trace/ora_24838300_1.trc
################ Open Stream File: 1 ################
PathFile: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1.trm
OpFlag: 136, Status: 1, MagicBeg: 2153609765, MagicNum: 3593058129
Stream Access
----- ADS Stream Desc Dump -----
fd: 27
----- END ADS Stream Desc Dump -----
File Name Fragment: 51_80/trace/ora_24838300_1.trm
################ Open Stream File: 2 ################
PathFile: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1_i3877017.trc
OpFlag: 10, Status: 1, MagicBeg: 2153609765, MagicNum: 3593058129
Stream Access
----- ADS Stream Desc Dump -----
fd: 28
----- END ADS Stream Desc Dump -----
File Name Fragment: ce/ora_24838300_1_i3877017.trc
################ Open Stream File: 3 ################
PathFile: /var/tmp/oradiag_oracle/diag/clients/user_oracle/host_1545611351_80/trace/ora_24838300_1_i3877017.trm
OpFlag: 136, Status: 1, MagicBeg: 2153609765, MagicNum: 3593058129
Stream Access
----- ADS Stream Desc Dump -----
fd: 29
----- END ADS Stream Desc Dump -----
File Name Fragment: ce/ora_24838300_1_i3877017.trm
----- END ADS Open Files Dump -----
----- END ADR Diagnostic Information Dump -----
----- ADL Diagnostic Information Dump -----
ADL Flags: 0x4
Timestamp: -1569355021
Host Name: sihibmn2
NW Address: 172.25.25.64
----- END ADL Diagnostic Information Dump -----
----- Diag Context Memory -----
1106C93A0 00000001 00000000 00000000 00000000 [................]
1106C93B0 00000003 00000001 03000000 00000000 [................]
1106C93C0 00000001 106DF1E0 00000001 10693A98 [.....m.......i:.]
1106C93D0 00000000 00000000 00000000 00000000 [................]
1106C93E0 00000001 106F4670 00000001 106F8830 [.....oFp.....o.0]
1106C93F0 00000001 106CB008 00000001 1087F360 [.....l.........`]
1106C9400 00000001 1087EB88 00000001 1087EC78 [...............x]
1106C9410 00000001 1087ED40 00000001 1087EE3F [.......@.......?]
1106C9420 00000001 106CB2A8 00000001 106CB3A7 [.....l.......l..]
1106C9430 00000001 106CBA60 00000001 106CBB5F [.....l.`.....l._]
1106C9440 00000001 106CA250 00000001 106CA34F [.....l.P.....l.O]
1106C9450 00000001 106CAA08 00000001 106CAB07 [.....l.......l..]
1106C9460 00000001 1087F670 00000001 1087DAE0 [.......p........]
1106C9470 00000001 106C9500 00001040 00000000 [.....l.....@....]
1106C9480 00000000 00000000 00000001 108522B0 [..............".]
1106C9490 00000001 106F8810 00000000 00000000 [.....o..........]
1106C94A0 00000000 00000000 00030103 00000000 [................]
1106C94B0 00000000 00000000 000008C0 64696167 [............diag]
1106C94C0 20706761 00000000 00000020 7FFF7FFF [ pga....... ....]
1106C94D0 7FFF7FFF 00000000 00000000 00000000 [................]
1106C94E0 00000000 00000000 00000001 1087EB48 [...............H]
1106C94F0 00000001 106F8F30 00000000 00000000 [.....o.0........]
1106C9500 00000000 00000000 000020C0 00000000 [.......... .....]
1106C9510 00000000 00000000 00000001 10854368 [..............Ch]
1106C9520 00000001 1087DA40 00000000 00000000 [.......@........]
1106C9530 00000000 00000000 00021002 00000000 [................]
1106C9540 00000000 00000000 000020C0 70676120 [.......... .pga ]
1106C9550 68656170 00000000 00000060 00007FFF [heap.......`....]
1106C9560 7FFF7FFF 00000000 00000000 00000000 [................]
1106C9570 00000000 00000118 00000001 1087DA20 [............... ]
1106C9580 00000001 106D67B8 00000000 00000218 [.....mg.........]
1106C9590 00000001 106C9590 00000001 106C9590 [.....l.......l..]
1106C95A0 00000000 00000418 00000001 106C95A8 [.............l..]
1106C95B0 00000001 106C95A8 00000000 00000818 [.....l..........]
1106C95C0 00000001 106C95C0 00000001 106C95C0 [.....l.......l..]
1106C95D0 00000000 00001018 00000001 106C95D8 [.............l..]
1106C95E0 00000001 106C95D8 00000000 00002018 [.....l........ .]
1106C95F0 00000001 106C95F0 00000001 106C95F0 [.....l.......l..]
1106C9600 00000000 00004018 00000001 106C9608 [......@......l..]
1106C9610 00000001 106C9608 00000000 00008018 [.....l..........]
1106C9620 00000001 106C9620 00000001 106C9620 [.....l. .....l. ]
1106C9630 00000000 00010018 00000001 106C9638 [.............l.8]
1106C9640 00000001 106C9638 00000000 00020018 [.....l.8........]
1106C9650 00000001 106C9650 00000001 106C9650 [.....l.P.....l.P]
1106C9660 00000000 00040018 00000001 106C9668 [.............l.h]
1106C9670 00000001 106C9668 00000000 00080018 [.....l.h........]
1106C9680 00000001 106C9680 00000001 106C9680 [.....l.......l..]
1106C9690 00000000 00100018 00000001 106C9698 [.............l..]
1106C96A0 00000001 106C9698 00000000 00200018 [.....l....... ..]
1106C96B0 00000001 106C96B0 00000001 106C96B0 [.....l.......l..]
1106C96C0 00000000 00400018 00000001 106C96C8 [.....@.......l..]
1106C96D0 00000001 106C96C8 00000000 00800018 [.....l..........]
1106C96E0 00000001 106C96E0 00000001 106C96E0 [.....l.......l..]
1106C96F0 00000000 00000000 000020C0 00000000 [.......... .....]
1106C9700 00000000 00000000 00000001 106EA3F8 [.............n..]
1106C9710 00000001 106EA458 00000001 106C98E0 [.....n.X.....l..]
1106C9720 00000000 00000000 00021002 00000000 [................]
1106C9730 00000000 00000000 00002058 73676120 [.......... Xsga ]
1106C9740 68656170 00000000 00000020 00107FFF [heap....... ....]
1106C9750 7FFF7FFF 00000000 00000000 00000000 [................]
1106C9760 00000000 00000118 00000001 106EA438 [.............n.8]
1106C9770 00000001 106EA438 00000000 00000218 [.....n.8........]
1106C9780 00000001 106C9780 00000001 106C9780 [.....l.......l..]
1106C9790 00000000 00000418 00000001 106C9798 [.............l..]
1106C97A0 00000001 106C9798 00000000 00000818 [.....l..........]
1106C97B0 00000001 106C97B0 00000001 106C97B0 [.....l.......l..]
1106C97C0 00000000 00001018 00000001 106C97C8 [.............l..]
1106C97D0 00000001 106C97C8 00000000 00002018 [.....l........ .]
1106C97E0 00000001 106C97E0 00000001 106C97E0 [.....l.......l..]
1106C97F0 00000000 00004018 00000001 106C97F8 [......@......l..]
1106C9800 00000001 106C97F8 00000000 00008018 [.....l..........]
1106C9810 00000001 106C9810 00000001 106C9810 [.....l.......l..]
1106C9820 00000000 00010018 00000001 106C9828 [.............l.(]
1106C9830 00000001 106C9828 00000000 00020018 [.....l.(........]
1106C9840 00000001 106C9840 00000001 106C9840 [.....l.@.....l.@]
1106C9850 00000000 00040018 00000001 106C9858 [.............l.X]
1106C9860 00000001 106C9858 00000000 00080018 [.....l.X........]
1106C9870 00000001 106C9870 00000001 106C9870 [.....l.p.....l.p]
1106C9880 00000000 00100018 00000001 106C9888 [.............l..]
1106C9890 00000001 106C9888 00000000 00200018 [.....l....... ..]
1106C98A0 00000001 106C98A0 00000001 106C98A0 [.....l.......l..]
1106C98B0 00000000 00400018 00000001 106C98B8 [.....@.......l..]
1106C98C0 00000001 106C98B8 00000000 00800018 [.....l..........]
1106C98D0 00000001 106C98D0 00000001 106C98D0 [.....l.......l..]
1106C98E0 00000001 106C98F0 00000001 106C98F0 [.....l.......l..]
1106C98F0 00000001 106C98E0 00000001 106C98E0 [.....l.......l..]
1106C9900 00000000 00000000 00000000 00000000 [................]
1106C9910 00000000 00000000 00000000 7FFFFFFF [................]
1106C9920 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
1106C9950 00000000 00000000 00000001 106C9958 [.............l.X]
1106C9960 00000001 106C9958 00000000 00000000 [.....l.X........]
1106C9970 00000000 00000000 00000000 00000000 [................]
Repeat 63 times
1106C9D70 00000000 00000000 00000001 106C9D78 [.............l.x]
1106C9D80 00000001 106C9D78 00000000 00000000 [.....l.x........]
1106C9D90 00000001 106C9D90 00000001 106C9D90 [.....l.......l..]
1106C9DA0 00000000 00000000 00000001 106C9DA8 [.............l..]
1106C9DB0 00000001 106C9DA8 00000000 00000000 [.....l..........]
1106C9DC0 00000001 106C9DC0 00000001 106C9DC0 [.....l.......l..]
1106C9DD0 00000000 00000000 00000001 106C9DD8 [.............l..]
1106C9DE0 00000001 106C9DD8 00000000 00000000 [.....l..........]
1106C9DF0 00000001 106C9DF0 00000001 106C9DF0 [.....l.......l..]
1106C9E00 00000000 00000000 00000001 106C9E08 [.............l..]
1106C9E10 00000001 106C9E08 00000000 00000000 [.....l..........]
1106C9E20 00000001 106C9E20 00000001 106C9E20 [.....l. .....l. ]
1106C9E30 00000000 00000000 00000001 106C9E38 [.............l.8]
1106C9E40 00000001 106C9E38 00000000 00000000 [.....l.8........]
1106C9E50 00000001 106C9E50 00000001 106C9E50 [.....l.P.....l.P]
1106C9E60 00000000 00000000 00000001 106C9E68 [.............l.h]
1106C9E70 00000001 106C9E68 00000000 00000000 [.....l.h........]
1106C9E80 00000001 106C9E80 00000001 106C9E80 [.....l.......l..]
1106C9E90 00000000 00000000 00000001 106C9E98 [.............l..]
1106C9EA0 00000001 106C9E98 00000000 00000000 [.....l..........]
1106C9EB0 00000001 106C9EB0 00000001 106C9EB0 [.....l.......l..]
1106C9EC0 00000000 00000000 00000001 106C9EC8 [.............l..]
1106C9ED0 00000001 106C9EC8 00000000 00000000 [.....l..........]
1106C9EE0 00000001 106C9EE0 00000001 106C9EE0 [.....l.......l..]
1106C9EF0 00000000 00000000 00000001 106C9EF8 [.............l..]
1106C9F00 00000001 106C9EF8 00000000 00000000 [.....l..........]
1106C9F10 00000000 00000000 00000000 00000000 [................]
1106C9F20 00000001 106C4D10 00000001 106EFF88 [.....lM......n..]
1106C9F30 00000001 106EA478 00000000 00000000 [.....n.x........]
1106C9F40 00000001 106E34E0 00000001 106C8F88 [.....n4......l..]
1106C9F50 00000001 106C8EE8 00000015 00000000 [.....l..........]
1106C9F60 00000001 106E8558 00000001 106F02F8 [.....n.X.....o..]
1106C9F70 00000001 106F24B0 00000001 00000000 [.....o$.........]
1106C9F80 00000001 1087F8E8 00000001 106E8640 [.............n.@]
1106C9F90 00000000 00000000 00000001 1083EA98 [................]
1106C9FA0 00000001 1087F5B0 00000001 1087F5B0 [................]
1106C9FB0 00000001 106C93A8 00000000 00000001 [.....l..........]
1106C9FC0 00000000 00000000 00000000 00000000 [................]
1106C9FD0 00000003 00000000 00000001 1036C230 [.............6.0]
1106C9FE0 00000001 1036C380 00000001 106EC538 [.....6.......n.8]
1106C9FF0 00000001 106DF1E0 00000000 00000000 [.....m..........]
1106CA000 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
----- Diag Context Init Params Memory -----
1106EFF80 00000001 00000001 [........]
1106EFF90 2F766172 2F746D70 2F6F7261 64696167 [/var/tmp/oradiag]
1106EFFA0 5F6F7261 636C6500 00000000 00000000 [_oracle.........]
1106EFFB0 00000000 00000000 00000000 00000000 [................]
Repeat 20 times
1106F0100 00000004 75736572 5F6F7261 636C6500 [....user_oracle.]
1106F0110 00000000 00000000 00000000 00000000 [................]
1106F0120 00000068 6F73745F 31353435 36313133 [...host_15456113]
1106F0130 35315F38 30000000 00000000 00000000 [51_80...........]
1106F0140 00000000 00000000 00000000 00000000 [................]
1106F0150 00000000 00000086 01000000 00000000 [................]
1106F0160 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
1106F0180 00000000 00000001 FFFFFFFF 00000000 [................]
1106F0190 00000000 00000000 00000000 00000000 [................]
Repeat 14 times
1106F0280 00000000 00000000 [........]
----- Diag Thread Local Root Dump -----
Sequence#: 4
Flags: 0x0
Diag Pointers by type:
[0]: 0x1106c93a0
[1]: 0x0
[2]: 0x0
Library References:
[00]: ID=0 (0x1106c8f08):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[01]: ID=0 (0x1106c8f18):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[02]: ID=2 (0x1106c8f28):
Precedence: 2
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[03]: ID=3 (0x1106c8f38):
Precedence: 3
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[04]: ID=0 (0x1106c8f48):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[05]: ID=0 (0x1106c8f58):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[06]: ID=0 (0x1106c8f68):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[07]: ID=0 (0x1106c8f78):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[08]: ID=8 (0x1106c8f88):
Precedence: 8
Reference Count: 1
Usage type: 0
Usage flags: 0x0
[09]: ID=0 (0x1106c8f98):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[10]: ID=0 (0x1106c8fa8):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[11]: ID=0 (0x1106c8fb8):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[12]: ID=0 (0x1106c8fc8):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[13]: ID=0 (0x1106c8fd8):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[14]: ID=0 (0x1106c8fe8):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[15]: ID=0 (0x1106c8ff8):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[16]: ID=0 (0x1106c9008):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[17]: ID=0 (0x1106c9018):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[18]: ID=0 (0x1106c9028):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[19]: ID=0 (0x1106c9038):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
[20]: ID=0 (0x1106c9048):
Precedence: 0
Reference Count: 0
Usage type: 0
Usage flags: 0x0
----- Diag Thread Local Root Memory -----
1106C8EE0 3B9EF5C8 00000000 [;.......]
1106C8EF0 00000001 106C93A0 00000000 00000000 [.....l..........]
1106C8F00 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
1106C8F30 00000002 02000000 00000000 00000000 [................]
1106C8F40 00000003 03000000 00000000 00000000 [................]
1106C8F50 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
1106C8F80 00000000 00000000 00000001 106EFF88 [.............n..]
1106C8F90 00000008 08010000 00000000 00000000 [................]
1106C8FA0 00000000 00000000 00000000 00000000 [................]
Repeat 10 times
1106C9050 00000000 00000000 00000004 00000000 [................]
----- END Diag Thread Local Root Dump -----
----- Diag Context Flood Control Memory -----
1106EA480 00000000 00000000 [........]
1106EA490 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
1106EA4F0 00000000 00000000 [........]
------- END Diag Context Dump -------
----- END DDE Action: 'dumpDiagCtx' (SUCCESS, 0 csec) -----
----- START DDE Action: 'dumpGenralConfiguration' (Sync) -----
========= General Configuration ========
--------- GC Source: [generic GC] --------
[0000]: item 0=ORACLE_HOME = /u0/app/oracle/product/11.2.0/dbhome_1
[0000]: item 1=System name: AIX
[0000]: item 2=Node name: sihibmn2
[0000]: item 3=Release: 1
[0000]: item 4=Version: 7
[0000]: item 5=Machine: 00F7694C4C00
--------- GC Source: [unittest_GC] --------
--------- GC Source: [kernel_GC] --------
[0003]: banner=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[0003]: product_str=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
[0003]: product_version=11.2.0.3.0
[0003]: installed_feature_1=Partitioning
[0003]: installed_feature_2=Real Application Clusters
[0003]: installed_feature_3=OLAP
[0003]: installed_feature_4=Data Mining
[0003]: installed_feature_5=Real Application Testing
[0003]: installed_features_num=5
[0003]: instance_name=SIH2
[0001]: os_name=AIX
[0001]: number_core_cpu=4
--------- GC Source: [Non_Default_Kernel_Parameters] --------
--------- GC Source: [Visible_Default_Kernel_Parameters] --------
========= End of General Configuration ========
----- END DDE Action: 'dumpGenralConfiguration' (SUCCESS, 0 csec) -----
----- START DDE Action: 'dumpKernelDiagState' (Sync) -----
------- Kernel Diag Dump -------
dbkcBSExt: 0
dbkedDefDump info:
Internal err count: 0
Error Flags: 0x0
Exception: FALSE
No Bootstrapping info (SGA is not mapped)
------- END Kernel Diag Dump -------
----- END DDE Action: 'dumpKernelDiagState' (SUCCESS, 0 csec) -----
----- START DDE Action: 'xdb_dump_buckets' (Sync) -----
----- END DDE Action: 'xdb_dump_buckets' (FAILURE, 0 csec) -----
----- START DDE Action: 'dumpKGERing' (Sync) -----
----- END DDE Action: 'dumpKGERing' (SUCCESS, 0 csec) -----
----- START DDE Action: 'dumpKGEState' (Sync) -----
kgepgtfr 0x11083b260
kgepgtba 0x110841a90
kgepgter 0
kgepgpar kgepgbpa 0x1106dfaa4
kgepgepa 0x1106e02a4
kgepgtfd 4
kgepgdmc 0
kgepgflg 0x0
kgepg_stkgfr 0x0
kgepgkgsmp 0x1106df1e0
kgepgspm 4
kgepg_ba_set_in_eh 0x0
kgepg_kgecatch_set_in_eh_ba 0x0
kge_ba_set_in_eh_funcloc 0x0
kge_ba_set_in_eh_fileloc 0x0
------------------- start error stack dump with barriers
<error barrier> at 0x110841a90

------------------- end error stack dump with barriers
----- END DDE Action: 'dumpKGEState' (SUCCESS, 0 csec) -----
----- START DDE Action: 'kpuActionDefault' (Sync) -----
Begin OCI Current State Dump
End OCI Current State Dump

Begin OCI Call Context Dump
End OCI Call Context Dump

Begin Process state dump.
ttcdrvdmplocation: msg-0 ln-0 reporting 0
HST is NULL or no two task connection
End Process state dump.
----- END DDE Action: 'kpuActionDefault' (SUCCESS, 0 csec) -----
----- END DDE Actions Dump (total 0 csec) -----
End of Incident Dump

[Tim...]

Hi.

OK. This is an ORA-07445. Like ORA-00600 it is an internal error, so something out of the ordinary is happening. The action associated with 7445 and 600 errors is to contact Oracle support. They will diagnose the problem.

There is a lookup forms on MOS you might want to use to see if your problem is a known bug.

https://support.oracle.com/epmos/faces/ ... d=153788.1

Cheers

Tim...

[aunshakeel]

thanks for t he reply Mr Tim,
Yes i have already searched at that tool and nothing significant came up.
the closest hit was something bout re-linking binaries to OS.
I have already created n SR to see if there is solution. it is severity 2 SR but in 3 days i have only seen different people posting that the SR is assigned to them and they are reviewing it

[Tim...]

Hi.

Well, if the lookup doesn't return anything, it is likely to be a new issue/bug. Not much anyone other than Oracle can do to help you with that.

If it is causing a problem you could always get the SR escalated to a higher priority.

Cheers

Tim...

[aunshakeel]

Hi Mr. Tim,
I would like to ask you a couple of questions here.
1) What is the use of the following parameters if i add them in the sqlnet.ora and listener.ora files
DIAG-ADR_ENABLED=off
diag_dde_enabled=off

2) Do i have to restart the database to make these changes have any impact???

[Tim...]

Hi.

You need to read these:

http://docs.oracle.com/cd/E11882_01/net ... m#NETRF399
http://docs.oracle.com/cd/E11882_01/app ... LNOCI16760

They are sqlnet.ora parameters, not initialization parameters, so they don't require a database restart.

Cheers

Tim...