juvenile Posted June 20, 2013 Report Posted June 20, 2013 memu oka table long2lob conversion chestunnam .. everytime its failing with [size=3][font=arial, helvetica, sans-serif]ORA-03113: end-of-file on communication channel e We are using brtools .. internal SAPtool kani that calls DBMS_REDEF**only !! BR0280I BRSPACE time stamp: 2013-06-20 09.56.51 BR1101I Starting 'online' table reorganization... BR0280I BRSPACE time stamp: 2013-06-20 09.56.52 BR1124I Starting 'online' reorganization of table xxxxxxxxxxxxxxxxxx ... BR0280I BRSPACE time stamp: 2013-06-20 11.27.17 BR0301E SQL error -3113 at location tab_onl_reorg-63, SQL statement: 'BEGIN DBMS_REDEFINITION.FINISH_REDEF_TABLE (UNAME => '"xxxxx"', ORIG_TABLE => '"xxxxxxxxxxxx"', INT_TABLE => '"xxxxxxx"'); END;' ORA-03113: end-of-file on communication channel Process ID: 66920 Session ID: 1174 Serial number: 18553 similar time lo alertlog lo inthakante matter emi ledu... Stopping background process CJQ0 Thu Jun 20 11:37:19 2013 Process 0x700000788cfca60 appears to be hung while dumping Current time = 4031357755, process death time = 4031297575 interval = 60000 Attempting to kill process 0x700000788cfca60 with OS pid = 66920 OSD kill succeeded for process 700000788cfca60 Any idea guys where to start !![/font][/size]
juvenile Posted June 20, 2013 Author Report Posted June 20, 2013 [quote name='ChoclateBoy' timestamp='1371767990' post='1303875505'] [/quote] Help seyyochu ga
bokuboy Posted June 20, 2013 Report Posted June 20, 2013 [quote name='AggiRamudu' timestamp='1371768127' post='1303875509'] Help seyyochu ga [/quote] nenu inka pl/sql nerchukuntunna...dba varaku rale
JammichettuPandu Posted June 20, 2013 Report Posted June 20, 2013 Calling BOY ani thread start chey Mana boy is DBA
MeetFriendz Posted June 20, 2013 Report Posted June 20, 2013 check if there is any trace file generated or any other in the trace directory. looks to be some network issue. the PID got closed on servers. no idea y it got closed. better to check the reorg status and do it again.
juvenile Posted June 20, 2013 Author Report Posted June 20, 2013 [quote name='MeetFriendz' timestamp='1371771166' post='1303875560'] check if there is any trace file generated or any other in the trace directory. looks to be some network issue. the PID got closed on servers. no idea y it got closed. better to check the reorg status and do it again. [/quote] Reorg failed mayya !! we tried same thing 3,4 times .. same issue .. End lo finish redefinition phase lo fail autundi .. always at same point
peru_edaite_enti Posted June 20, 2013 Report Posted June 20, 2013 End of communication-- process killed or connection dropped avutundi ga
juvenile Posted June 20, 2013 Author Report Posted June 20, 2013 [quote name='CBZ' timestamp='1371771993' post='1303875576'] End of communication-- process killed or connection dropped avutundi ga [/quote] Ade ardam avvatla how its getting killed aa ani ...nothing in logs ..
peru_edaite_enti Posted June 20, 2013 Report Posted June 20, 2013 [quote name='AggiRamudu' timestamp='1371772027' post='1303875577'] Ade ardam avvatla how its getting killed aa ani ...nothing in logs .. [/quote] External ga kakunda dirct db lo login aiyi try chesi chudu
juvenile Posted June 20, 2013 Author Report Posted June 20, 2013 [quote name='CBZ' timestamp='1371772167' post='1303875581'] External ga kakunda dirct db lo login aiyi try chesi chudu [/quote] brtools we are running from DB host only .. No firewall in between ..
Recommended Posts