ada account di metalink pak ? jika ada seperti rekomendasi dari note yg saya copy-khan point berikut lebih baik dilakukan:
For repeatable occurrences, please submit the trace files and alert.log to Oracle Support Services for further analysis. dikarenakan di bagian bawah dari note tersebut yang merujuk pada error di alert.log bapak, permasalahannya yg mungkin terjadi adalah sebuah bug. mohon maaf jika tidak banyak membantu. ----- Pesan Asli ---- Dari: murdi santoso <[EMAIL PROTECTED]> Kepada: [email protected] Terkirim: Selasa, 9 September, 2008 14:10:11 Topik: Re: Bls: [indo-oracle] error ora-03113 sebelum error ini terjadi sempat jaringan network error semua (down), tapi database dalam keadaan up, apakah karena ini yg menyebabkan save point error..??? and jika database nya di restart apakah itu akan menyelesaikan masalah..?? apakah check point akan bersih kembali. mohon pencerahannya para pendekar ..?? ----- Original Message ---- From: Sulistyo <bookonlineworm@ yahoo.com. sg> To: indo-oracle@ yahoogroups. com Sent: Tuesday, September 9, 2008 1:10:49 PM Subject: Bls: [indo-oracle] error ora-03113 berikut ini dari metalink: Subject: ORA-600 [4414] "Error popping Errorstack Savepoint" Doc ID: Note:29702.1 Type: REFERENCE Last Revision Date: 27-SEP-2006 Status: PUBLISHED Note: For additional ORA-600 related information please read Note 146580.1 PURPOSE: This article discusses the internal error "ORA-600 [4414]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [4414] [a] [b] [c] [d] [e] VERSIONS: versions 6.0 to 9.2 DESCRIPTION: There are 2 varieties of this internal error: With 4 additional arguments: ------------ --------- ------- At various places within the code, Oracle checks to make sure the current savepoint level is one greater than the old savepoint level. If this check fails, ORA-600 [4414] is logged.. There are usually other errors in the error stack along with this one. With no additional arguments: ------------ --------- -------- This error can also occur when there are problems cleaning up a distributed transaction. FUNCTIONALITY: TRANSACTION CONTROL IMPACT: PROCESS FAILURE POSSIBLE INSTANCE FAILURE - if background process dies. NON CORRUPTIVE - No underlying data corruption. SUGGESTIONS: For repeatable occurrences, please submit the trace files and alert.log to Oracle Support Services for further analysis. Known Issues: Bug# 3017434 See Note 3017434.8 OERI[4414] can occur Fixed: 9..2.0.4 Bug# 2395193 * See Note 2395193.8 * This bug is alerted in Note 200983.1 OERI:4414 / ORA-1403 on dequeue of pre-9.2 enqueued messages Fixed: 9.2.0.2 Bug# 2174897 See Note 2174897.8 OERI:4414 possible Fixed: 9.0.1.4, 9.2.0.1 Bug# 1279964 See Note 1279964.8 OERI:4414 PMON may die cleaning up failed distributed transaction Fixed: 8.0.6..2, 8.1.6.2, 8.1.7.0 semoga membantu. ----- Pesan Asli ---- Dari: murdi santoso <[EMAIL PROTECTED] com> Kepada: indo-oracle@ yahoogroups. com Terkirim: Selasa, 9 September, 2008 11:39:46 Topik: Re: [indo-oracle] error ora-03113 berikut cuplikan isi dari trace file 7782: JServer Release 9.2.0.7.0 - Production ORACLE_HOME = /oracle/home92 Oracle process number: 803 Unix process pid: 7782, image: [EMAIL PROTECTED] (TNS V1-V3) *** SESSION ID:(1050.46912) 2008-09-02 18:00:40.425 *** 2008-09-02 18:00:40.425 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [4414], [12226], [1], [5453], [3], [], [], [] ORA-03113: end-of-file on communication channel No current SQL statement being executed. ----- PL/SQL Call Stack ----- object line object handle number name dc0feae38 775 package body SYS.DBMS_LOB debc728d8 234 package body WIN.CBREP_SERVER debc728d8 284 package body WIN.CBREP_SERVER debc728d8 928 package body WIN.CBREP_SERVER e1ab42210 434 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) ------------ -------- -------- ------------ -------- ------------ --------- ------- ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ? 000000000 ? 103357D48 ? 00000003E ? FFFFFFFF7FFF09A8 ? ----- Original Message ---- From: Ujang Jaenudin <ujang.jaenudin@ gmail.com> To: indo-oracle@ yahoogroups. com Sent: Tuesday, September 9, 2008 11:27:45 AM Subject: Re: [indo-oracle] error ora-03113 bisa dipaste isi /oracle/home92/ admin/dumps/ cboss_ora_ 7782.trc ? terutama bagian process state dan memory dump :) -- thanks and regards ujang | oracle dba jakarta | http://ora62. wordpress. com 2008/9/9 murdi santoso <[EMAIL PROTECTED] com>: > ya bener sebelum error 03113, terjadi error 600 dgn argument 4414, > kira2 ini penyebabnya apa ya..??? > > dari aler log : > Errors in file /oracle/home92/ admin/dumps/ cboss_ora_ 7782.trc: > ORA-00600: internal error code, arguments: [4414], [12226], [1], [5453], > [3], [], [], [] > ORA-03113: end-of-file on communication channel > > <font color="#7f003f" ><strong> <img > src="http://us.i1. yimg.com/ us.yimg.com/ i/mesg/tsmileys2 /14.gif"></strong> > < /font> > <font color="#7f003f" ><strong> --Murdi Santoso--</strong> > </font> > > ----- Original Message ---- > From: hendra chen <h3ndr4ch3n@ yahoo. com.sg> > To: indo-oracle@ yahoogroups. com > Sent: Tuesday, September 9, 2008 10:56:02 AM > Subject: Re: [indo-oracle] error ora-03113 > > coba baca di alert log nya dl pak, > dari sana baru ketauan apa maslah nya. > > kalau cuma dari kode error nya itu luas sekali. > dan banyak pemyebab nya. > > Best Regards, > > Hendra > > --- On Tue, 9/9/08, murdi santoso <[EMAIL PROTECTED] com> wrote: > From: murdi santoso <[EMAIL PROTECTED] com> > Subject: [indo-oracle] error ora-03113 > To: indo-oracle@ yahoogroups. com > Date: Tuesday, 9 September, 2008, 10:03 AM > > halo para suhu oracle, > > saya ada masalah di oracle, semua user yg connect dan melakukan query selalu > terputus setelah waktu mendekati > > 2 jam, dengan error ORA-03113 end comunication channel, yang kemudian > diteruskan dengan error ORA-03114 not connected oracle. > > sebelumnya oracle selalu berjalan normal, dan kami tidak sama selali > melakukan update sesuatu selain add datafile. > > kami coba mengecek apakah ada query kill session yg dijalankan schedule, dan > ternyata tidak ada. > > mohon amat sangat pencerahannya. ... > > karna ini sudah sangat mengganggu, hampir semua query baik itu reporting > ataupun tarik data selalu putus. > > Salam > [Non-text portions of this message have been removed] ____________ _________ _________ _________ _________ _________ _ Dapatkan nama yang Anda sukai! Sekarang Anda dapat memiliki email di @ymail.com dan @rocketmail. com. http://mail. promotions. yahoo.com/ newdomains/ id/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ___________________________________________________________________________ Yahoo! sekarang memiliki alamat Email baru. Dapatkan nama yang selalu Anda inginkan di domain baru @ymail dan @rocketmail. Cepat sebelum diambil orang lain! http://mail.promotions.yahoo.com/newdomains/id/ [Non-text portions of this message have been removed]
