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 [email protected], agus purwanto <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > 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\CONTROL01.CTL, E:\WORLCLAS\CTLFILE\CONTROL02.CTL, F:\WORLCLAS\CTLFILE\CONTROL03.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_threshold= 8388608 > remote_login_passwordfile= EXCLUSIVE > db_domain = > dispatchers = (PROTOCOL=TCP) (SERVICE=worlclasXDB) > 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] >
