Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: ORA-00600: internal error code, arguments: [kglget-baddep-byd], [0xC0000000BE6E3398], [1] when applying a merged patch
Symptoms:
ORA-600 [kglget-baddep-byd] creating or replacing a package
o Bug 10034396 - ORA-600 [KGLLOCK-BAD-BYD] REPORTED WHILE APPLYING EBS PATCH 9344987, Suspended, Req'd Info not Avail
o (not published yet) Note 988473.1 - ORA-00600: [kglget-baddep-byd] when compilying a package body
o Bug 8393217 - ORA-600 OCCURS WHEN APPLYING APPLICATIONS SHIPPING ROLLUP PATCH 1 FOR 11.5.10
Log files:
Alert log file:
Sun Jan 23 14:44:49 2011
Archived Log entry 3626 added for thread 1 sequence 3640 ID 0xba3cdb71 dest 1:
Sun Jan 23 14:44:53 2011
Errors in file /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/trace/SID_ora_8953.trc (incident=67393):
ORA-00600: internal error code, arguments: [kglget-baddep-byd], [0xC0000000BE2C0C68], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/incident/incdir_67393/SID_ora_8953_i67393.trc
Sun Jan 23 14:45:12 2011
Trace dumping is performing id=[cdmp_20110123144512]
Sun Jan 23 14:45:12 2011
Errors in file /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/trace/SID_ora_10528.trc (incident=67329):
ORA-00600: internal error code, arguments: [kglget-baddep-byd], [0xC0000000BE2C0C68], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/incident/incdir_67329/SID_ora_10528_i67329.trc
Sun Jan 23 14:45:13 2011
Sweep Incident[67393]: completed
Trace dumping is performing id=[cdmp_20110123144516]
Sun Jan 23 14:45:17 2011
i77077.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/products/11.1.0/SID
System name: HP-UX
Node name: jebtdb01
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: SID
Redo thread mounted by this instance: 1
Oracle process number: 33
Unix process pid: 20193, image: oracle@jebtdb01
*** 2011-01-25 12:07:19.091
*** SESSION ID:(1286.42) 2011-01-25 12:07:19.091
*** CLIENT ID:() 2011-01-25 12:07:19.091
*** SERVICE NAME:(SID) 2011-01-25 12:07:19.091
*** MODULE NAME:() 2011-01-25 12:07:19.091
*** ACTION NAME:() 2011-01-25 12:07:19.091
Dump continued from file: /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/trace/SID_ora_20193.trc
ORA-00600: internal error code, arguments: [kglget-baddep-byd], [0xC0000000BE6E3398], [1], [], [], [], [], [], [], [], [], []
========= Dump for incident 77077 (ORA 600 [kglget-baddep-byd]) ========
----- Beginning of Customized Incident Dump(s) -----
LIBRARY HANDLE:c0000000be6e3398 bid=83014 hid=665f4446 lmd=S pmd=S sta=VALD
name=APPS.OE_ORDER_CACHE
hash=d8e84a32a505ce7325922162665f4446 idn=142222
tim=01-23-2011 14:43:39kkkk-dddd-llll=0000-0005-0005
exc=0 ivc=0 ldc=1 slc=1 lct=3 pct=3
cbb=1 rpr=2 kdp=0 kep=0 bus=5 hus=5 dbg=0
dmtx=c0000000be6e3440(0, 11, 0) mtx=c0000000be6e34b0(0, 291, 0)
nsp=TABL(01) typ=PCKG(09) llm=0 flg=KGHP/TIM/[00002800]
lwt=c0000000be6e3420[c0000000be6e3420,c0000000be6e3420]
pwt=c0000000be6e3400[c0000000be6e3400,c0000000be6e3400]
ref=c0000000be6e3430[c0000000b14d2230,c0000000b14d2230]
LIBRARY OBJECT: c0000000b14ca8a8
flg=EXS/LOC[0005] pfl=/IVR[0200] ssta=VALD
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 c0000000be2980a8 c0000000b14ca9c8 c0000000b14ca878 I/P/A/-/- 0 NONE 00
2 c0000000b14caa10 c0000000af89f2d8 c0000000af89f2a8 I/P/A/-/- 1 NONE 00
----- End of Customized Incident Dump(s) -----
sskgds_getcall: WARNING! *** Stack Unwind Error***
sdsnm: dlmodinfo failed for address : 0x40000000
*** 2011-01-25 12:07:19.289
----- Current SQL Statement for this session (sql_id=9sdn3bhqjhsnm) -----
CREATE or REPLACE PACKAGE OE_Set_Util AUTHID CURRENT_USER AS
/* $Header: OEXUSETS.pls 115.17.11510.6 2005/08/16 05:39:36 pkannan ship $ */
g_delivery_set_rec OE_ORDER_PUB.set_rec_type;
g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
g_ship_set_rec OE_ORDER_PUB.set_rec_type;
g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_Type;
G_Set_Recursive_Flag BOOLEAN := FALSE;
...
-- To delete set
Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
x_return_status OUT NOCOPY VARCHAR2);
END OE_Set_Util;
----- Call Stack Trace -----
kglget <- kglgob <- kgldpo0 <- kgldpo <- kgldon <- pl_don <- ptgxtn <- ptg_nd <- 0x0000000040000000 ... ---------------------------------------- SO: 0xc0000000bc706b70, type: 4, owner: 0xc0000000bd32f0e0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3 proc=0xc0000000bd32f0e0, name=session, file=ksu.h LINE:10719 ID:, pg=0 (session) sid: 1286 ser: 42 trans: 0xc0000000b9b6e640, creator: 0xc0000000bd32f0e0 flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/- flags2: (0x48008) -/DDLT2 DID: , short-term DID: txn branch: 0x0000000000000000 oct: 94, prv: 0, sql: 0x800003ffbfe9db18, psql: 0xc0000000be900918, user: 44/APPS ksuxds FALSE at location: 0 service name: SID client details: O/S info: user: appebzci, term: pts/0, ospid: 17679 machine: jaoridu1 program: Current Wait Stack: Not in wait; last wait ended 3.474204 sec ago Wait State: auto_close=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: 0: waited for 'db file sequential read' file#=6, block#=16a6a, blocks=1 wait_id=288 seq_num=289 snap_id=1 wait times: snap=0.007054 sec, exc=0.007054 sec, total=0.007054 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000023 sec of elapsed time 1: waited for 'db file sequential read' file#=3, block#=1669a, blocks=1 wait_id=287 seq_num=288 snap_id=1 wait times: snap=0.007692 sec, exc=0.007692 sec, total=0.007692 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000010 sec of elapsed time 2: waited for 'db file sequential read' file#=7, block#=1541a, blocks=1 wait_id=286 seq_num=287 snap_id=1 wait times: snap=0.005539 sec, exc=0.005539 sec, total=0.005539 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000222 sec of elapsed time 3: waited for 'db file sequential read' file#=6, block#=16e9b, blocks=1 wait_id=285 seq_num=286 snap_id=1 wait times: snap=0.005883 sec, exc=0.005883 sec, total=0.005883 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000020 sec of elapsed time ... ----- Invocation Context Dump ----- Address: 0x80000001002e8fd8 Phase: 3 flags: 0x18E0001 Incident ID: 77077 Error Descriptor: ORA-600 [kglget-baddep-byd] [0xC0000000BE6E3398] [1] [] [] [] [] [] Error class: 0 Problem Key # of args: 1 Number of actions: 8 ----- Incident Context Dump ----- Address: 0x800003ffc0003738 Incident ID: 77077 Problem Key: ORA 600 [kglget-baddep-byd] Error: ORA-600 [kglget-baddep-byd] [0xC0000000BE6E3398] [1] [] [] [] [] [] [00]: dbgexExplicitEndInc [diag_dde] [01]: dbgeEndDDEInvocationImpl [diag_dde] [02]: dbgeEndDDEInvocation [diag_dde] [03]: kglget []<-- Signaling [04]: kglgob [] [05]: kgldpo0 [] [06]: kgldpo [] [07]: kgldon [] [08]: pl_don [] [09]: ptgxtn [] [10]: ptg_nd [] [11]: 0x0000000040000000 [] MD [00]: 'SID'='1286.42' (0x3) MD [01]: 'ProcId'='33.6' (0x3) MD [02]: 'PQ'='(16777216, 1295942837)' (0x7) MD [03]: 'Client ProcId'='oracle@jebtdb01 (TNS V1-V3).20193_1' (0x0) Impact 0: Impact 1: Impact 2: Impact 3: Derived Impact: ----- END Incident Context Dump ----- ----- END Invocation Context Dump ----- Solution:
problem may be related to Bug 10034396 and Bug 8393217 both Suspended.
In one of this bugs the problem has been solved running utlirp.sql and utlrp.sql.
So execute as sysdba:
$ORACLE_HOME/rdbms/admin/utlirp.sql
$ORACLE_HOME/rdbms/admin/utlrp.sql
References:
As reported "Bug 8393217 - ORA-600 OCCURS WHEN APPLYING APPLICATIONS SHIPPING ROLLUP PATCH 1 FOR 11.5.10" (suspended) the only know workaround is to execute utlirp.sql and utlrp.sql
Symptoms:
ORA-600 [kglget-baddep-byd] creating or replacing a package
o Bug 10034396 - ORA-600 [KGLLOCK-BAD-BYD] REPORTED WHILE APPLYING EBS PATCH 9344987, Suspended, Req'd Info not Avail
o (not published yet) Note 988473.1 - ORA-00600: [kglget-baddep-byd] when compilying a package body
o Bug 8393217 - ORA-600 OCCURS WHEN APPLYING APPLICATIONS SHIPPING ROLLUP PATCH 1 FOR 11.5.10
Log files:
Alert log file:
Sun Jan 23 14:44:49 2011
Archived Log entry 3626 added for thread 1 sequence 3640 ID 0xba3cdb71 dest 1:
Sun Jan 23 14:44:53 2011
Errors in file /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/trace/SID_ora_8953.trc (incident=67393):
ORA-00600: internal error code, arguments: [kglget-baddep-byd], [0xC0000000BE2C0C68], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/incident/incdir_67393/SID_ora_8953_i67393.trc
Sun Jan 23 14:45:12 2011
Trace dumping is performing id=[cdmp_20110123144512]
Sun Jan 23 14:45:12 2011
Errors in file /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/trace/SID_ora_10528.trc (incident=67329):
ORA-00600: internal error code, arguments: [kglget-baddep-byd], [0xC0000000BE2C0C68], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/incident/incdir_67329/SID_ora_10528_i67329.trc
Sun Jan 23 14:45:13 2011
Sweep Incident[67393]: completed
Trace dumping is performing id=[cdmp_20110123144516]
Sun Jan 23 14:45:17 2011
i77077.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/products/11.1.0/SID
System name: HP-UX
Node name: jebtdb01
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: SID
Redo thread mounted by this instance: 1
Oracle process number: 33
Unix process pid: 20193, image: oracle@jebtdb01
*** 2011-01-25 12:07:19.091
*** SESSION ID:(1286.42) 2011-01-25 12:07:19.091
*** CLIENT ID:() 2011-01-25 12:07:19.091
*** SERVICE NAME:(SID) 2011-01-25 12:07:19.091
*** MODULE NAME:() 2011-01-25 12:07:19.091
*** ACTION NAME:() 2011-01-25 12:07:19.091
Dump continued from file: /u01/app/oracle/products/11.1.0/SID/prod11i/diag/rdbms/SID/SID/trace/SID_ora_20193.trc
ORA-00600: internal error code, arguments: [kglget-baddep-byd], [0xC0000000BE6E3398], [1], [], [], [], [], [], [], [], [], []
========= Dump for incident 77077 (ORA 600 [kglget-baddep-byd]) ========
----- Beginning of Customized Incident Dump(s) -----
LIBRARY HANDLE:c0000000be6e3398 bid=83014 hid=665f4446 lmd=S pmd=S sta=VALD
name=APPS.OE_ORDER_CACHE
hash=d8e84a32a505ce7325922162665f4446 idn=142222
tim=01-23-2011 14:43:39kkkk-dddd-llll=0000-0005-0005
exc=0 ivc=0 ldc=1 slc=1 lct=3 pct=3
cbb=1 rpr=2 kdp=0 kep=0 bus=5 hus=5 dbg=0
dmtx=c0000000be6e3440(0, 11, 0) mtx=c0000000be6e34b0(0, 291, 0)
nsp=TABL(01) typ=PCKG(09) llm=0 flg=KGHP/TIM/[00002800]
lwt=c0000000be6e3420[c0000000be6e3420,c0000000be6e3420]
pwt=c0000000be6e3400[c0000000be6e3400,c0000000be6e3400]
ref=c0000000be6e3430[c0000000b14d2230,c0000000b14d2230]
LIBRARY OBJECT: c0000000b14ca8a8
flg=EXS/LOC[0005] pfl=/IVR[0200] ssta=VALD
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 c0000000be2980a8 c0000000b14ca9c8 c0000000b14ca878 I/P/A/-/- 0 NONE 00
2 c0000000b14caa10 c0000000af89f2d8 c0000000af89f2a8 I/P/A/-/- 1 NONE 00
----- End of Customized Incident Dump(s) -----
sskgds_getcall: WARNING! *** Stack Unwind Error***
sdsnm: dlmodinfo failed for address : 0x40000000
*** 2011-01-25 12:07:19.289
----- Current SQL Statement for this session (sql_id=9sdn3bhqjhsnm) -----
CREATE or REPLACE PACKAGE OE_Set_Util AUTHID CURRENT_USER AS
/* $Header: OEXUSETS.pls 115.17.11510.6 2005/08/16 05:39:36 pkannan ship $ */
g_delivery_set_rec OE_ORDER_PUB.set_rec_type;
g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
g_ship_set_rec OE_ORDER_PUB.set_rec_type;
g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_Type;
G_Set_Recursive_Flag BOOLEAN := FALSE;
...
-- To delete set
Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
x_return_status OUT NOCOPY VARCHAR2);
END OE_Set_Util;
----- Call Stack Trace -----
kglget <- kglgob <- kgldpo0 <- kgldpo <- kgldon <- pl_don <- ptgxtn <- ptg_nd <- 0x0000000040000000 ... ---------------------------------------- SO: 0xc0000000bc706b70, type: 4, owner: 0xc0000000bd32f0e0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3 proc=0xc0000000bd32f0e0, name=session, file=ksu.h LINE:10719 ID:, pg=0 (session) sid: 1286 ser: 42 trans: 0xc0000000b9b6e640, creator: 0xc0000000bd32f0e0 flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/- flags2: (0x48008) -/DDLT2 DID: , short-term DID: txn branch: 0x0000000000000000 oct: 94, prv: 0, sql: 0x800003ffbfe9db18, psql: 0xc0000000be900918, user: 44/APPS ksuxds FALSE at location: 0 service name: SID client details: O/S info: user: appebzci, term: pts/0, ospid: 17679 machine: jaoridu1 program: Current Wait Stack: Not in wait; last wait ended 3.474204 sec ago Wait State: auto_close=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: 0: waited for 'db file sequential read' file#=6, block#=16a6a, blocks=1 wait_id=288 seq_num=289 snap_id=1 wait times: snap=0.007054 sec, exc=0.007054 sec, total=0.007054 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000023 sec of elapsed time 1: waited for 'db file sequential read' file#=3, block#=1669a, blocks=1 wait_id=287 seq_num=288 snap_id=1 wait times: snap=0.007692 sec, exc=0.007692 sec, total=0.007692 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000010 sec of elapsed time 2: waited for 'db file sequential read' file#=7, block#=1541a, blocks=1 wait_id=286 seq_num=287 snap_id=1 wait times: snap=0.005539 sec, exc=0.005539 sec, total=0.005539 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000222 sec of elapsed time 3: waited for 'db file sequential read' file#=6, block#=16e9b, blocks=1 wait_id=285 seq_num=286 snap_id=1 wait times: snap=0.005883 sec, exc=0.005883 sec, total=0.005883 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000020 sec of elapsed time ... ----- Invocation Context Dump ----- Address: 0x80000001002e8fd8 Phase: 3 flags: 0x18E0001 Incident ID: 77077 Error Descriptor: ORA-600 [kglget-baddep-byd] [0xC0000000BE6E3398] [1] [] [] [] [] [] Error class: 0 Problem Key # of args: 1 Number of actions: 8 ----- Incident Context Dump ----- Address: 0x800003ffc0003738 Incident ID: 77077 Problem Key: ORA 600 [kglget-baddep-byd] Error: ORA-600 [kglget-baddep-byd] [0xC0000000BE6E3398] [1] [] [] [] [] [] [00]: dbgexExplicitEndInc [diag_dde] [01]: dbgeEndDDEInvocationImpl [diag_dde] [02]: dbgeEndDDEInvocation [diag_dde] [03]: kglget []<-- Signaling [04]: kglgob [] [05]: kgldpo0 [] [06]: kgldpo [] [07]: kgldon [] [08]: pl_don [] [09]: ptgxtn [] [10]: ptg_nd [] [11]: 0x0000000040000000 [] MD [00]: 'SID'='1286.42' (0x3) MD [01]: 'ProcId'='33.6' (0x3) MD [02]: 'PQ'='(16777216, 1295942837)' (0x7) MD [03]: 'Client ProcId'='oracle@jebtdb01 (TNS V1-V3).20193_1' (0x0) Impact 0: Impact 1: Impact 2: Impact 3: Derived Impact: ----- END Incident Context Dump ----- ----- END Invocation Context Dump ----- Solution:
problem may be related to Bug 10034396 and Bug 8393217 both Suspended.
In one of this bugs the problem has been solved running utlirp.sql and utlrp.sql.
So execute as sysdba:
$ORACLE_HOME/rdbms/admin/utlirp.sql
$ORACLE_HOME/rdbms/admin/utlrp.sql
References:
As reported "Bug 8393217 - ORA-600 OCCURS WHEN APPLYING APPLICATIONS SHIPPING ROLLUP PATCH 1 FOR 11.5.10" (suspended) the only know workaround is to execute utlirp.sql and utlrp.sql
4 comments:
order xanax xanax class - xanax side effects liver
cheap tramadol order tramadol next day delivery - tramadol 50 mg tab amne
xanax no prescription does walmart drug test xanax - order generic xanax online
buy tramadol next day tramadol 50 mg 60 capsulas - buy tramadol online no prescription usa
Post a Comment