boleh sharing, settingan apa saja yg dirubah ? saya dah ikutin setting parameter 10g sesuai dengan di 9i (kecuali memory)
----- Original Message ---- From: abip_palembang <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, August 23, 2007 8:45:02 AM Subject: [indo-oracle] Re: ORA-00600 internal error ... ga selalu internal error harus upgrade karena kemarin saya dapet internal error, tapi ternyata ada setingan yang saya ubah, tapi ternyata kurang tepat, setelah tepat. saya ga dapet masalah lagi --- In indo-oracle@ yahoogroups. com, agus purwanto <purwanto_ags@ ...> wrote: > > sebelumnya terima kasih atas tanggapannya, > saya lagi cari apakah 10g support atau tidak ke dev 6.0 > > untuk alert lognya saya lampirkan (lihat attachment) > mohon bantuannya > > terima kasih, > ags > > ----- Original Message ---- > From: Herry Yusirwan <herry.yusirwan@ ...> > To: oracle-coretech- indonesia@ yahoogroups. com > Sent: Wednesday, August 22, 2007 11:02:37 AM > Subject: RE: [***Maybe SPAM*** Score/Req: 04.90/4.9] Re: [oracle-coretech- indonesia] ORA-00600 internal error ... > > Dear Pak Agus, > > Ora-600 itu memang internal error oracle dan biasanya solusinya adalah upgrade versi database atau developer agar dapat menyelesaikan error tersebut. > pada email saya sebelumnya saya sarankan untuk melihat dokumentasi pada oracle 10gnya untuk mengetahui apakah 10g support atau tidak dev 6. > > Atau mungkin bapak bisa mengirimkan alert lognya, biar bisa dilihat lebih jelas oleh teman2 di milisÂ… > > Semoga bermanfaat > > Rgds, > Herry > > DISCLAIMER: > This Message is confidential; it contents does not constitute a commitment by PT. INDONESIA POWER, except where provided for in a written agreement between you and PT.INDONESIA POWER. Any unauthorized disclosure, use or dissemination of the content, either whole or partial, is strictly prohibited. If you are not the intended recipient of the message or you have received this electronic transmission in error, please notify or contact the sender immediately. > > > PT. INDONESIA POWER is subsidiary of PT. PLN PERSERO which operates in power generating business. Through its 130 power plants, with a total capacity of 8,872 MW, PT.INDONESIA POWER has contributed significantly to the Java Bali interconnection system electricity supply. PT.INDONESIA POWER operates through its eight generating Business Unit (GBU) : Suralaya, Priok, Saguling, Kamojang, Mrica, Semarang, Perak Grati, Bali and one maintenance Services business unit (MSBU). > > > > > ____________ _________ _________ _________ _________ _________ _ > Sick sense of humor? Visit Yahoo! TV's > Comedy with an Edge to see what's on, when. > http://tv.yahoo. com/collections/ 222 > ---------- > > Dump file c:\oracle\product\ 10.2.0/admin/ worlclas/ bdump\alert_ worlclas. log > Wed Aug 22 07:24:21 2007 > ORACLE V10.2.0.1.0 - Production vsnsta=0 > vsnsql=14 vsnxtr=3 > Windows Server 2003 Version V5.2 Service Pack 1 > CPU : 4 - type 586, 2 Physical Cores > Process Affinity : 0x00000000 > Memory (Avail/Total) : Ph:3754M/4031M, Ph+PgF:10743M/ 10868M, VA:2967M/3071M > Wed Aug 22 07:24:21 2007 > Starting ORACLE instance (normal) > LICENSE_MAX_ SESSION = 0 > LICENSE_SESSIONS_ WARNING = 0 > Picked latch-free SCN scheme 2 > Using LOG_ARCHIVE_ DEST_10 parameter default value as USE_DB_RECOVERY_ FILE_DEST > Autotune of undo retention is turned on. > IMODE=BR > ILAT =97 > LICENSE_MAX_ USERS = 0 > SYS auditing is disabled > ksdpec: called for event 13740 prior to event group initialization > Starting up ORACLE RDBMS Version: 10.2.0.1.0. > System parameters with non-default values: > processes = 800 > sessions = 885 > __shared_pool_ size = 218103808 > __large_pool_ size = 8388608 > __java_pool_ size = 8388608 > __streams_pool_ size = 0 > nls_language = INDONESIAN > nls_territory = INDONESIA > sga_target = 2147483648 > control_files = D:\WORLCLAS\ CTLFILE\CONTROL0 1.CTL, E:\WORLCLAS\ CTLFILE\CONTROL0 2.CTL, F:\WORLCLAS\ CTLFILE\CONTROL0 3.CTL > db_block_size = 8192 > __db_cache_size = 1904214016 > compatible = 10.2.0.1.0 > db_file_multiblock_ read_count= 8 > db_recovery_ file_dest = C:\oracle\product\ 10.2.0/flash_ recovery_ area > db_recovery_ file_dest_ size= 2147483648 > undo_management = AUTO > undo_tablespace = UNDOTBS1 > _kgl_large_heap_ warning_threshol d= 8388608 > remote_login_ passwordfile= EXCLUSIVE > db_domain = > dispatchers = (PROTOCOL=TCP) (SERVICE=worlclasXD B) > job_queue_processes = 10 > audit_file_dest = C:\ORACLE\PRODUCT\ 10.2.0\ADMIN\ WORLCLAS\ ADUMP > background_dump_ dest = C:\ORACLE\PRODUCT\ 10.2.0\ADMIN\ WORLCLAS\ BDUMP > user_dump_dest = C:\ORACLE\PRODUCT\ 10.2.0\ADMIN\ WORLCLAS\ UDUMP > core_dump_dest = C:\ORACLE\PRODUCT\ 10.2.0\ADMIN\ WORLCLAS\ CDUMP > db_name = worlclas > open_cursors = 500 > pga_aggregate_ target = 805306368 > MMAN started with pid=4, OS id=1964 > PMON started with pid=2, OS id=1976 > PSP0 started with pid=3, OS id=1972 > DBW0 started with pid=5, OS id=184 > LGWR started with pid=6, OS id=204 > CKPT started with pid=7, OS id=200 > SMON started with pid=8, OS id=196 > RECO started with pid=9, OS id=144 > CJQ0 started with pid=10, OS id=140 > MMON started with pid=11, OS id=2044 > MMNL started with pid=12, OS id=2040 > Wed Aug 22 07:24:26 2007 > starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL= YES)(PROTOCOL= TCP))'... > starting up 1 shared server(s) ... > Oracle Data Guard is not available in this edition of Oracle. > Wed Aug 22 07:24:28 2007 > alter database mount exclusive > Wed Aug 22 07:24:33 2007 > Setting recovery target incarnation to 2 > Wed Aug 22 07:24:33 2007 > Successful mount of redo thread 1, with mount id 3198677740 > Wed Aug 22 07:24:33 2007 > Database mounted in Exclusive Mode > Completed: alter database mount exclusive > Wed Aug 22 07:24:33 2007 > alter database open > Wed Aug 22 07:24:35 2007 > Beginning crash recovery of 1 threads > Wed Aug 22 07:24:35 2007 > Started redo scan > Wed Aug 22 07:24:36 2007 > Completed redo scan > 41811 redo blocks read, 9692 data blocks need recovery > Wed Aug 22 07:24:39 2007 > Started redo application at > Thread 1: logseq 173, block 170669 > Wed Aug 22 07:24:39 2007 > Recovery of Online Redo Log: Thread 1 Group 2 Seq 173 Reading mem 0 > Mem# 0 errs 0: E:\WORLCLAS\ LOGFILE\REDO02. LOG > Wed Aug 22 07:24:41 2007 > Recovery of Online Redo Log: Thread 1 Group 3 Seq 174 Reading mem 0 > Mem# 0 errs 0: F:\WORLCLAS\ LOGFILE\REDO03. LOG > Wed Aug 22 07:24:42 2007 > Completed redo application > Wed Aug 22 07:24:45 2007 > Completed crash recovery at > Thread 1: logseq 174, block 17175, scn 4017588 > 9692 data blocks read, 9692 data blocks written, 41811 redo blocks read > Wed Aug 22 07:24:46 2007 > Thread 1 advanced to log sequence 175 > Thread 1 opened at log sequence 175 > Current log# 4 seq# 175 mem# 0: D:\WORLCLAS\ LOGFILE\REDO04. LOG > Successful open of redo thread 1 > Wed Aug 22 07:24:47 2007 > SMON: enabling cache recovery > Wed Aug 22 07:24:49 2007 > Successfully onlined Undo Tablespace 1. > Wed Aug 22 07:24:49 2007 > SMON: enabling tx recovery > Wed Aug 22 07:24:49 2007 > Database Characterset is WE8MSWIN1252 > replication_ dependency_ tracking turned off (no async multimaster replication found) > Starting background process QMNC > QMNC started with pid=16, OS id=2264 > Wed Aug 22 07:25:00 2007 > Completed: alter database open > Wed Aug 22 07:25:00 2007 > db_recovery_ file_dest_ size of 2048 MB is 0.00% used. This is a > user-specified limit on the amount of space that will be used by this > database for recovery-related files, and does not reflect the amount of > space available in the underlying filesystem or ASM diskgroup. > Wed Aug 22 07:43:12 2007 > Thread 1 advanced to log sequence 176 > Current log# 5 seq# 176 mem# 0: F:\WORLCLAS\ LOGFILE\REDO05. LOG > Wed Aug 22 08:16:47 2007 > Thread 1 advanced to log sequence 177 > Current log# 1 seq# 177 mem# 0: D:\WORLCLAS\ LOGFILE\REDO01. LOG > Wed Aug 22 08:42:01 2007 > Thread 1 advanced to log sequence 178 > Current log# 2 seq# 178 mem# 0: E:\WORLCLAS\ LOGFILE\REDO02. LOG > Wed Aug 22 09:30:20 2007 > Thread 1 advanced to log sequence 179 > Current log# 3 seq# 179 mem# 0: F:\WORLCLAS\ LOGFILE\REDO03. LOG > Wed Aug 22 10:02:54 2007 > Thread 1 advanced to log sequence 180 > Current log# 4 seq# 180 mem# 0: D:\WORLCLAS\ LOGFILE\REDO04. LOG > Wed Aug 22 10:25:01 2007 > Thread 1 advanced to log sequence 181 > Current log# 5 seq# 181 mem# 0: F:\WORLCLAS\ LOGFILE\REDO05. LOG > Wed Aug 22 10:52:17 2007 > Thread 1 advanced to log sequence 182 > Current log# 1 seq# 182 mem# 0: D:\WORLCLAS\ LOGFILE\REDO01. LOG > Wed Aug 22 10:56:15 2007 > Process startup failed, error stack: > Wed Aug 22 10:56:15 2007 > Errors in file c:\oracle\product\ 10.2.0\admin\ worlclas\ bdump\worlclas_ psp0_1972. trc: > ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [spcdr:9261: 4200] [997] > ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [Overlapped I/O operation is in progress.] > ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [skgpspawn] > > Wed Aug 22 10:56:16 2007 > Process J000 died, see its trace file > Wed Aug 22 10:56:16 2007 > kkjcre1p: unable to spawn jobq slave process > Wed Aug 22 10:56:16 2007 > Errors in file c:\oracle\product\ 10.2.0\admin\ worlclas\ bdump\worlclas_ cjq0_140. trc: > > > Wed Aug 22 10:59:01 2007 > Process startup failed, error stack: > Wed Aug 22 10:59:01 2007 > Errors in file c:\oracle\product\ 10.2.0\admin\ worlclas\ bdump\worlclas_ psp0_1972. trc: > ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [spcdr:9261: 4200] [997] > ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [Overlapped I/O operation is in progress.] > ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [skgpspawn] > > Wed Aug 22 10:59:02 2007 > Process J000 died, see its trace file > Wed Aug 22 10:59:02 2007 > kkjcre1p: unable to spawn jobq slave process > Wed Aug 22 10:59:02 2007 > Errors in file c:\oracle\product\ 10.2.0\admin\ worlclas\ bdump\worlclas_ cjq0_140. trc: > > > Wed Aug 22 11:00:45 2007 > Process startup failed, error stack: > Wed Aug 22 11:00:45 2007 > Errors in file c:\oracle\product\ 10.2.0\admin\ worlclas\ bdump\worlclas_ psp0_1972. trc: > ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [spcdr:9261: 4200] [997] > ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [Overlapped I/O operation is in progress.] > ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [skgpspawn] > > Wed Aug 22 11:00:46 2007 > Process m001 died, see its trace file > Wed Aug 22 11:00:46 2007 > ksvcreate: Process(m001) creation failed > Wed Aug 22 11:00:52 2007 > Process startup failed, error stack: > Wed Aug 22 11:00:52 2007 > Errors in file c:\oracle\product\ 10.2.0\admin\ worlclas\ bdump\worlclas_ psp0_1972. trc: > ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [spcdr:9261: 4200] [997] > ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [Overlapped I/O operation is in progress.] > ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [skgpspawn] > > Wed Aug 22 11:00:53 2007 > Process J000 died, see its trace file > Wed Aug 22 11:00:53 2007 > kkjcre1p: unable to spawn jobq slave process > Wed Aug 22 11:00:53 2007 > Errors in file c:\oracle\product\ 10.2.0\admin\ worlclas\ bdump\worlclas_ cjq0_140. trc: > > > Wed Aug 22 11:08:48 2007 > Thread 1 advanced to log sequence 183 > Current log# 2 seq# 183 mem# 0: E:\WORLCLAS\ LOGFILE\REDO02. LOG > Wed Aug 22 11:12:59 2007 > Immediate Kill Session#: 767, Serial#: 709 > Immediate Kill Session: sess: B36129C4 OS pid: 4352 > Wed Aug 22 11:13:40 2007 > Immediate Kill Session#: 687, Serial#: 109 > Immediate Kill Session: sess: B35B4B44 OS pid: 332 > Immediate Kill Session#: 849, Serial#: 26379 > Immediate Kill Session: sess: B3672DD4 OS pid: 4452 > Wed Aug 22 11:13:52 2007 > Immediate Kill Session#: 789, Serial#: 1061 > Immediate Kill Session: sess: B362C6F4 OS pid: 5208 > Wed Aug 22 11:17:11 2007 > Immediate Kill Session#: 636, Serial#: 178 > Immediate Kill Session: sess: B3578D6C OS pid: 1496 > Immediate Kill Session#: 711, Serial#: 6160 > Immediate Kill Session: sess: B35D0E04 OS pid: 5364 > Immediate Kill Session#: 666, Serial#: 1160 > Immediate Kill Session: sess: B359C0DC OS pid: 5780 > Wed Aug 22 11:31:31 2007 > WARNING: inbound connection timed out (ORA-3136) > Wed Aug 22 11:32:57 2007 > WARNING: inbound connection timed out (ORA-3136) > Wed Aug 22 11:35:19 2007 > WARNING: inbound connection timed out (ORA-3136) > > > [Non-text portions of this message have been removed] > ____________________________________________________________________________________ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469 [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
