Tue Jul 21 14:58:51 2009 Starting background process EMN0 EMN0 started with pid=28, OS id=5472 Tue Jul 21 14:58:51 2009 Shutting down instance: further logons disabled Tue Jul 21 14:58:51 2009 Stopping background process QMNC Tue Jul 21 14:58:52 2009 Stopping background process CJQ0 Tue Jul 21 14:58:53 2009 Stopping background process MMNL Tue Jul 21 14:58:54 2009 Stopping background process MMON Tue Jul 21 14:58:55 2009 Shutting down instance (immediate) License high water mark = 146 Tue Jul 21 14:58:55 2009 Stopping Job queue slave processes Tue Jul 21 14:58:55 2009 Job queue slave processes stopped Tue Jul 21 14:59:01 2009 ALTER DATABASE CLOSE NORMAL Tue Jul 21 14:59:01 2009 SMON: disabling tx recovery SMON: disabling cache recovery Tue Jul 21 14:59:02 2009 Shutting down archive processes Archiving is disabled Tue Jul 21 14:59:12 2009 ARC1: Becoming the heartbeat ARCH Tue Jul 21 14:59:12 2009 ARC1: Archiving disabled ARCH shutting down ARC1: Archival stopped Tue Jul 21 14:59:13 2009 ARCH shutting down Tue Jul 21 14:59:13 2009 ARC0: Archival stopped Tue Jul 21 14:59:14 2009 Thread 1 closed at log sequence 57119 Successful close of redo thread 1 Tue Jul 21 14:59:14 2009 Completed: ALTER DATABASE CLOSE NORMAL Tue Jul 21 14:59:14 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Tue Jul 21 15:16:13 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:7535M/8189M, Ph+PgF:15712M/16184M, VA:2948M/3071M Tue Jul 21 15:16:13 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 524288000 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 377487360 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PSP0 started with pid=3, OS id=5188 MMAN started with pid=4, OS id=5192 DBW0 started with pid=5, OS id=5204 LGWR started with pid=6, OS id=5208 CKPT started with pid=7, OS id=5212 SMON started with pid=8, OS id=5216 RECO started with pid=9, OS id=5220 CJQ0 started with pid=10, OS id=5224 MMON started with pid=11, OS id=5228 MMNL started with pid=12, OS id=5232 Tue Jul 21 15:16:16 2009 alter database mount exclusive PMON started with pid=2, OS id=5184 Tue Jul 21 15:16:20 2009 Setting recovery target incarnation to 1 Tue Jul 21 15:16:20 2009 Successful mount of redo thread 1, with mount id 104621888 Tue Jul 21 15:16:20 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Tue Jul 21 15:16:20 2009 alter database open Tue Jul 21 15:16:21 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=13, OS id=5260 Tue Jul 21 15:16:21 2009 ARC0: Archival started Tue Jul 21 15:16:21 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57119 Current log# 2 seq# 57119 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57119 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Tue Jul 21 15:16:21 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Jul 21 15:16:21 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Tue Jul 21 15:16:21 2009 SMON: enabling cache recovery Tue Jul 21 15:16:22 2009 Incremental checkpoint up to RBA [0xdf1f.fbf.0], current log tail at RBA [0xdf1f.fbf.0] ARC1 started with pid=14, OS id=5264 Tue Jul 21 15:16:22 2009 ARC1: Becoming the heartbeat ARCH Tue Jul 21 15:16:22 2009 Successfully onlined Undo Tablespace 1. Tue Jul 21 15:16:22 2009 SMON: enabling tx recovery Tue Jul 21 15:16:22 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=5300 Tue Jul 21 15:16:30 2009 Completed: alter database open Tue Jul 21 15:17:18 2009 Beginning log switch checkpoint up to RBA [0xdf20.2.10], SCN: 1174466452 Thread 1 advanced to log sequence 57120 Current log# 1 seq# 57120 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57120 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Thread 1 cannot allocate new log, sequence 57121 Checkpoint not complete Current log# 1 seq# 57120 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57120 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 15:17:21 2009 Completed checkpoint up to RBA [0xdf20.2.10], SCN: 1174466452 Tue Jul 21 15:17:21 2009 Beginning log switch checkpoint up to RBA [0xdf21.2.10], SCN: 1174468636 Thread 1 advanced to log sequence 57121 Current log# 2 seq# 57121 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57121 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 15:20:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7848.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:22:22 2009 Completed checkpoint up to RBA [0xdf21.2.10], SCN: 1174468636 Tue Jul 21 15:24:34 2009 Beginning log switch checkpoint up to RBA [0xdf22.2.10], SCN: 1174475303 Thread 1 advanced to log sequence 57122 Current log# 1 seq# 57122 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57122 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 15:27:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:27:51 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5404.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:27:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6656.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:28:19 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:28:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:28:28 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:28:32 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:28:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6388.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:28:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:29:12 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:29:13 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:29:13 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:29:38 2009 Completed checkpoint up to RBA [0xdf22.2.10], SCN: 1174475303 Tue Jul 21 15:29:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_3548.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:30:03 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4924.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:30:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_452.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:31:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:31:51 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:31:52 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:31:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6756.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:31:59 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:32:01 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:32:01 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:32:02 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:32:04 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:32:07 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:32:39 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:32:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6712.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:33:12 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:33:15 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:33:18 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:33:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:33:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7112.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:34:21 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:36:14 2009 Incremental checkpoint up to RBA [0xdf22.acd.0], current log tail at RBA [0xdf22.2548.0] Tue Jul 21 15:38:26 2009 Beginning log switch checkpoint up to RBA [0xdf23.2.10], SCN: 1174482895 Thread 1 advanced to log sequence 57123 Current log# 2 seq# 57123 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57123 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 15:39:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6712.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:39:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_560.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:02 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:04 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:05 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6556.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:06 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_mmon_5228.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_keltfill+86] [PC:0xBC375A] [ADDR:0x0] [UNABLE_TO_READ] [] Tue Jul 21 15:40:10 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:11 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:27 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:28 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_3556.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:40:44 2009 Restarting dead background process MMON MMON started with pid=11, OS id=6000 Tue Jul 21 15:40:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6444.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:42 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:46 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:47 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7812.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:55 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:56 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6572.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:41:59 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:42:00 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:42:02 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:42:03 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:42:34 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:42:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:42:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6676.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:43:28 2009 Completed checkpoint up to RBA [0xdf23.2.10], SCN: 1174482895 Tue Jul 21 15:43:56 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_mmon_6000.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_keltfill+86] [PC:0xBC375A] [ADDR:0x0] [UNABLE_TO_READ] [] Tue Jul 21 15:43:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_832.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:44:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6184.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:45:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7376.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:45:59 2009 Restarting dead background process MMON MMON started with pid=19, OS id=4656 Tue Jul 21 15:46:19 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:46:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:46:32 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:46:32 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:46:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7528.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:47:02 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:47:03 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:47:25 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:47:37 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:47:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6232.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:48:04 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_3820.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:48:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_1928.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:48:58 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:49:11 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_mmon_4656.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_keltfill+86] [PC:0xBC375A] [ADDR:0x0] [UNABLE_TO_READ] [] Tue Jul 21 15:49:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:49:55 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6448.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:49:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4960.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:49:59 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:01 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7988.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:02 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7844.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:02 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7816.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:10 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7844.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:12 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7844.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:21 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7844.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:35 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7844.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7844.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:50:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:51:11 2009 Restarting dead background process MMON MMON started with pid=19, OS id=6156 Tue Jul 21 15:51:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_1620.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:53:22 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5488.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 15:53:41 2009 Beginning log switch checkpoint up to RBA [0xdf24.2.10], SCN: 1174490644 Thread 1 advanced to log sequence 57124 Current log# 1 seq# 57124 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57124 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 15:56:14 2009 Incremental checkpoint up to RBA [0xdf23.2312.0], current log tail at RBA [0xdf24.1132.0] Tue Jul 21 15:58:31 2009 Completed checkpoint up to RBA [0xdf24.2.10], SCN: 1174490644 Tue Jul 21 16:02:13 2009 Starting background process EMN0 EMN0 started with pid=36, OS id=5804 Tue Jul 21 16:02:13 2009 Shutting down instance: further logons disabled Tue Jul 21 16:02:13 2009 Stopping background process QMNC Tue Jul 21 16:02:14 2009 Stopping background process CJQ0 Tue Jul 21 16:02:15 2009 Stopping background process MMNL Tue Jul 21 16:02:16 2009 Stopping background process MMON Tue Jul 21 16:02:16 2009 Shutting down instance (immediate) License high water mark = 152 Tue Jul 21 16:02:16 2009 Stopping Job queue slave processes Tue Jul 21 16:02:16 2009 Job queue slave processes stopped Tue Jul 21 16:02:38 2009 ALTER DATABASE CLOSE NORMAL Tue Jul 21 16:02:39 2009 Beginning log switch checkpoint up to RBA [0xdf25.2.10], SCN: 1174495985 Thread 1 advanced to log sequence 57125 Current log# 2 seq# 57125 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57125 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 16:02:39 2009 SMON: disabling tx recovery SMON: disabling cache recovery Tue Jul 21 16:02:40 2009 Shutting down archive processes Archiving is disabled Tue Jul 21 16:02:45 2009 ARCH shutting down ARC1: Archival stopped Tue Jul 21 16:02:50 2009 ARCH shutting down ARC0: Archival stopped Tue Jul 21 16:02:51 2009 Thread 1 closed at log sequence 57125 Successful close of redo thread 1 Tue Jul 21 16:02:51 2009 Completed: ALTER DATABASE CLOSE NORMAL Tue Jul 21 16:02:51 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Tue Jul 21 16:24:22 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5594M/6141M, Ph+PgF:11670M/12102M, VA:2951M/3071M Tue Jul 21 16:24:22 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 528482304 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 373293056 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PSP0 started with pid=3, OS id=5152 MMAN started with pid=4, OS id=5156 DBW0 started with pid=5, OS id=5160 LGWR started with pid=6, OS id=5164 CKPT started with pid=7, OS id=5168 SMON started with pid=8, OS id=5172 RECO started with pid=9, OS id=5176 CJQ0 started with pid=10, OS id=5180 MMON started with pid=11, OS id=5184 MMNL started with pid=12, OS id=5188 Tue Jul 21 16:24:25 2009 alter database mount exclusive PMON started with pid=2, OS id=5148 Tue Jul 21 16:24:29 2009 Setting recovery target incarnation to 1 Tue Jul 21 16:24:29 2009 Successful mount of redo thread 1, with mount id 104653881 Tue Jul 21 16:24:29 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Tue Jul 21 16:24:29 2009 alter database open Tue Jul 21 16:24:30 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=13, OS id=5232 Tue Jul 21 16:24:30 2009 ARC0: Archival started Tue Jul 21 16:24:30 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57125 Current log# 2 seq# 57125 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57125 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Tue Jul 21 16:24:30 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Jul 21 16:24:30 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Tue Jul 21 16:24:30 2009 SMON: enabling cache recovery Tue Jul 21 16:24:30 2009 Incremental checkpoint up to RBA [0xdf25.165.0], current log tail at RBA [0xdf25.165.0] ARC1 started with pid=14, OS id=5236 Tue Jul 21 16:24:31 2009 ARC1: Becoming the heartbeat ARCH Tue Jul 21 16:24:31 2009 Successfully onlined Undo Tablespace 1. Tue Jul 21 16:24:31 2009 SMON: enabling tx recovery Tue Jul 21 16:24:31 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=5296 Tue Jul 21 16:24:40 2009 Completed: alter database open Tue Jul 21 16:25:30 2009 Beginning log switch checkpoint up to RBA [0xdf26.2.10], SCN: 1174500987 Thread 1 advanced to log sequence 57126 Current log# 1 seq# 57126 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57126 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 16:27:17 2009 Thread 1 cannot allocate new log, sequence 57127 Checkpoint not complete Current log# 1 seq# 57126 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57126 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 16:27:19 2009 Completed checkpoint up to RBA [0xdf26.2.10], SCN: 1174500987 Tue Jul 21 16:27:19 2009 Beginning log switch checkpoint up to RBA [0xdf27.2.10], SCN: 1174503617 Thread 1 advanced to log sequence 57127 Current log# 2 seq# 57127 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57127 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 16:30:40 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4976.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:30:42 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_mmon_5184.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_keltfill+86] [PC:0xBC375A] [ADDR:0x0] [UNABLE_TO_READ] [] Tue Jul 21 16:31:00 2009 Restarting dead background process MMON MMON started with pid=11, OS id=8176 Tue Jul 21 16:32:25 2009 Completed checkpoint up to RBA [0xdf27.2.10], SCN: 1174503617 Tue Jul 21 16:33:06 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_544.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:33:07 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6492.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:33:08 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_544.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:33:14 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_544.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:33:16 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_544.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:33:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_544.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:33:21 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_3872.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Tue Jul 21 16:38:12 2009 Starting background process EMN0 EMN0 started with pid=16, OS id=7596 Tue Jul 21 16:38:12 2009 Shutting down instance: further logons disabled Tue Jul 21 16:38:13 2009 Stopping background process QMNC Tue Jul 21 16:38:14 2009 Stopping background process CJQ0 Tue Jul 21 16:38:15 2009 Stopping background process MMNL Tue Jul 21 16:38:16 2009 Stopping background process MMON Tue Jul 21 16:38:17 2009 Shutting down instance (immediate) License high water mark = 143 Tue Jul 21 16:38:17 2009 Stopping Job queue slave processes Tue Jul 21 16:38:17 2009 Job queue slave processes stopped Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Tue Jul 21 16:44:34 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5504M/6141M, Ph+PgF:11555M/12102M, VA:2951M/3071M Tue Jul 21 16:44:34 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 532676608 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 369098752 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PMON started with pid=2, OS id=6020 PSP0 started with pid=3, OS id=468 MMAN started with pid=4, OS id=3512 DBW0 started with pid=5, OS id=4208 LGWR started with pid=6, OS id=788 CKPT started with pid=7, OS id=924 SMON started with pid=8, OS id=4200 RECO started with pid=9, OS id=380 CJQ0 started with pid=10, OS id=4184 MMON started with pid=11, OS id=4212 MMNL started with pid=12, OS id=4216 Tue Jul 21 16:44:34 2009 alter database mount exclusive Tue Jul 21 16:44:38 2009 Setting recovery target incarnation to 1 Tue Jul 21 16:44:38 2009 Successful mount of redo thread 1, with mount id 104666610 Tue Jul 21 16:44:38 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Tue Jul 21 16:44:39 2009 alter database open Tue Jul 21 16:44:39 2009 Beginning crash recovery of 1 threads parallel recovery started with 3 processes Tue Jul 21 16:44:39 2009 Started redo scan Tue Jul 21 16:44:39 2009 Completed redo scan 30 redo blocks read, 6 data blocks need recovery Tue Jul 21 16:44:39 2009 Started redo application at Thread 1: logseq 57127, block 8082 Tue Jul 21 16:44:39 2009 Recovery of Online Redo Log: Thread 1 Group 2 Seq 57127 Reading mem 0 Mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 16:44:39 2009 Completed redo application Tue Jul 21 16:44:39 2009 Completed crash recovery at Thread 1: logseq 57127, block 8112, scn 1174529927 6 data blocks read, 6 data blocks written, 30 redo blocks read Tue Jul 21 16:44:39 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=17, OS id=7200 Tue Jul 21 16:44:39 2009 ARC0: Archival started Tue Jul 21 16:44:39 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 advanced to log sequence 57128 Thread 1 opened at log sequence 57128 Current log# 1 seq# 57128 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57128 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Successful open of redo thread 1 Tue Jul 21 16:44:39 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Jul 21 16:44:39 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Tue Jul 21 16:44:39 2009 SMON: enabling cache recovery Tue Jul 21 16:44:40 2009 Successfully onlined Undo Tablespace 1. Tue Jul 21 16:44:40 2009 SMON: enabling tx recovery Tue Jul 21 16:44:40 2009 Incremental checkpoint up to RBA [0xdf28.3.0], current log tail at RBA [0xdf28.75.0] ARC1 started with pid=18, OS id=7212 Tue Jul 21 16:44:40 2009 ARC1: Becoming the heartbeat ARCH Tue Jul 21 16:44:40 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=19, OS id=7196 Tue Jul 21 16:44:48 2009 Completed: alter database open Tue Jul 21 16:46:38 2009 Starting background process EMN0 EMN0 started with pid=20, OS id=2292 Tue Jul 21 16:46:38 2009 Shutting down instance: further logons disabled Tue Jul 21 16:46:38 2009 Stopping background process QMNC Tue Jul 21 16:46:39 2009 Stopping background process CJQ0 Tue Jul 21 16:46:40 2009 Stopping background process MMNL Tue Jul 21 16:46:41 2009 Stopping background process MMON Tue Jul 21 16:46:42 2009 Shutting down instance (immediate) License high water mark = 4 Tue Jul 21 16:46:42 2009 Stopping Job queue slave processes Tue Jul 21 16:46:42 2009 Job queue slave processes stopped Tue Jul 21 16:46:47 2009 ALTER DATABASE CLOSE NORMAL Tue Jul 21 16:46:48 2009 SMON: disabling tx recovery SMON: disabling cache recovery Tue Jul 21 16:46:48 2009 Shutting down archive processes Archiving is disabled Tue Jul 21 16:46:53 2009 ARCH shutting down ARC1: Archival stopped Tue Jul 21 16:46:58 2009 ARCH shutting down ARC0: Archival stopped Tue Jul 21 16:46:59 2009 Thread 1 closed at log sequence 57128 Successful close of redo thread 1 Tue Jul 21 16:47:00 2009 Completed: ALTER DATABASE CLOSE NORMAL Tue Jul 21 16:47:00 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Tue Jul 21 16:59:34 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5393M/6141M, Ph+PgF:11265M/12102M, VA:2946M/3071M Tue Jul 21 16:59:34 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 536870912 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 364904448 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PSP0 started with pid=4, OS id=4992 PMON started with pid=3, OS id=5424 MMAN started with pid=5, OS id=6020 DBW0 started with pid=6, OS id=4144 LGWR started with pid=7, OS id=1928 CKPT started with pid=8, OS id=696 SMON started with pid=9, OS id=5076 RECO started with pid=10, OS id=5072 CJQ0 started with pid=11, OS id=4776 MMON started with pid=12, OS id=5876 MMNL started with pid=13, OS id=5996 Tue Jul 21 16:59:38 2009 ALTER DATABASE MOUNT Tue Jul 21 16:59:43 2009 Setting recovery target incarnation to 1 Tue Jul 21 16:59:43 2009 Successful mount of redo thread 1, with mount id 104678267 Tue Jul 21 16:59:43 2009 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Tue Jul 21 16:59:43 2009 ALTER DATABASE OPEN Tue Jul 21 16:59:43 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=15, OS id=4112 Tue Jul 21 16:59:43 2009 ARC0: Archival started Tue Jul 21 16:59:43 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57128 Current log# 1 seq# 57128 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57128 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Successful open of redo thread 1 Tue Jul 21 16:59:43 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Jul 21 16:59:43 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Tue Jul 21 16:59:43 2009 SMON: enabling cache recovery Tue Jul 21 16:59:44 2009 Incremental checkpoint up to RBA [0xdf28.3a0.0], current log tail at RBA [0xdf28.3a0.0] ARC1 started with pid=16, OS id=1096 Tue Jul 21 16:59:44 2009 ARC1: Becoming the heartbeat ARCH Tue Jul 21 16:59:45 2009 Successfully onlined Undo Tablespace 1. Tue Jul 21 16:59:45 2009 SMON: enabling tx recovery Tue Jul 21 16:59:45 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=17, OS id=4680 Tue Jul 21 16:59:53 2009 Completed: ALTER DATABASE OPEN Tue Jul 21 17:00:01 2009 Starting background process EMN0 EMN0 started with pid=30, OS id=160 Tue Jul 21 17:00:01 2009 Shutting down instance: further logons disabled Tue Jul 21 17:00:01 2009 Stopping background process QMNC Tue Jul 21 17:00:02 2009 Stopping background process CJQ0 Tue Jul 21 17:00:03 2009 Stopping background process MMNL Tue Jul 21 17:00:04 2009 Stopping background process MMON Tue Jul 21 17:00:05 2009 Shutting down instance (immediate) License high water mark = 10 Tue Jul 21 17:00:05 2009 Stopping Job queue slave processes Tue Jul 21 17:00:05 2009 Job queue slave processes stopped Tue Jul 21 17:00:07 2009 ALTER DATABASE CLOSE NORMAL Tue Jul 21 17:00:08 2009 SMON: disabling tx recovery SMON: disabling cache recovery Tue Jul 21 17:00:08 2009 Shutting down archive processes Archiving is disabled Tue Jul 21 17:00:13 2009 ARCH shutting down ARC1: Archival stopped Tue Jul 21 17:00:18 2009 ARCH shutting down ARC0: Archival stopped Tue Jul 21 17:00:19 2009 Thread 1 closed at log sequence 57128 Successful close of redo thread 1 Tue Jul 21 17:00:20 2009 Completed: ALTER DATABASE CLOSE NORMAL Tue Jul 21 17:00:20 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Tue Jul 21 17:01:12 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5582M/6141M, Ph+PgF:11659M/12102M, VA:2951M/3071M Tue Jul 21 17:01:12 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 541065216 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 360710144 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PMON started with pid=2, OS id=5248 PSP0 started with pid=3, OS id=368 MMAN started with pid=4, OS id=5116 DBW0 started with pid=5, OS id=5728 LGWR started with pid=6, OS id=5732 CKPT started with pid=7, OS id=5736 SMON started with pid=8, OS id=5744 RECO started with pid=9, OS id=4312 CJQ0 started with pid=10, OS id=5672 MMON started with pid=11, OS id=5676 MMNL started with pid=12, OS id=5680 Tue Jul 21 17:01:12 2009 alter database mount exclusive Tue Jul 21 17:01:16 2009 Setting recovery target incarnation to 1 Tue Jul 21 17:01:16 2009 Successful mount of redo thread 1, with mount id 104656088 Tue Jul 21 17:01:16 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Tue Jul 21 17:01:16 2009 alter database open Tue Jul 21 17:01:16 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=14, OS id=5708 Tue Jul 21 17:01:16 2009 ARC0: Archival started Tue Jul 21 17:01:16 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57128 Current log# 1 seq# 57128 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57128 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Successful open of redo thread 1 Tue Jul 21 17:01:16 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Jul 21 17:01:16 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Tue Jul 21 17:01:16 2009 SMON: enabling cache recovery Tue Jul 21 17:01:17 2009 Successfully onlined Undo Tablespace 1. Tue Jul 21 17:01:17 2009 SMON: enabling tx recovery Tue Jul 21 17:01:17 2009 Database Characterset is US7ASCII ARC1 started with pid=15, OS id=5712 Tue Jul 21 17:01:17 2009 ARC1: Becoming the heartbeat ARCH Tue Jul 21 17:01:18 2009 replication_dependency_tracking turned off (no async multimaster replication found) Tue Jul 21 17:01:18 2009 Incremental checkpoint up to RBA [0xdf28.745.0], current log tail at RBA [0xdf28.79a.0] Tue Jul 21 17:01:18 2009 Starting background process QMNC QMNC started with pid=16, OS id=5720 Tue Jul 21 17:01:25 2009 Completed: alter database open Tue Jul 21 17:02:05 2009 Beginning log switch checkpoint up to RBA [0xdf29.2.10], SCN: 1174535212 Thread 1 advanced to log sequence 57129 Current log# 2 seq# 57129 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57129 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 17:03:38 2009 Thread 1 cannot allocate new log, sequence 57130 Checkpoint not complete Current log# 2 seq# 57129 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57129 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 17:03:40 2009 Completed checkpoint up to RBA [0xdf29.2.10], SCN: 1174535212 Tue Jul 21 17:03:40 2009 Beginning log switch checkpoint up to RBA [0xdf2a.2.10], SCN: 1174538938 Thread 1 advanced to log sequence 57130 Current log# 1 seq# 57130 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57130 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 17:08:45 2009 Completed checkpoint up to RBA [0xdf2a.2.10], SCN: 1174538938 Tue Jul 21 17:11:40 2009 Beginning log switch checkpoint up to RBA [0xdf2b.2.10], SCN: 1174544561 Thread 1 advanced to log sequence 57131 Current log# 2 seq# 57131 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57131 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 17:16:39 2009 Completed checkpoint up to RBA [0xdf2b.2.10], SCN: 1174544561 Tue Jul 21 17:17:34 2009 Beginning log switch checkpoint up to RBA [0xdf2c.2.10], SCN: 1174549526 Thread 1 advanced to log sequence 57132 Current log# 1 seq# 57132 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57132 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 17:21:11 2009 Incremental checkpoint up to RBA [0xdf2b.c5e.0], current log tail at RBA [0xdf2c.986.0] Tue Jul 21 17:22:33 2009 Completed checkpoint up to RBA [0xdf2c.2.10], SCN: 1174549526 Tue Jul 21 17:29:16 2009 Beginning log switch checkpoint up to RBA [0xdf2d.2.10], SCN: 1174557915 Thread 1 advanced to log sequence 57133 Current log# 2 seq# 57133 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57133 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 17:34:20 2009 Completed checkpoint up to RBA [0xdf2d.2.10], SCN: 1174557915 Tue Jul 21 17:41:09 2009 Incremental checkpoint up to RBA [0xdf2d.ae3.0], current log tail at RBA [0xdf2d.d50.0] Tue Jul 21 18:00:53 2009 Beginning log switch checkpoint up to RBA [0xdf2e.2.10], SCN: 1174569124 Thread 1 advanced to log sequence 57134 Current log# 1 seq# 57134 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57134 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 18:01:09 2009 Incremental checkpoint up to RBA [0xdf2d.1872.0], current log tail at RBA [0xdf2e.208.0] Tue Jul 21 18:05:56 2009 Completed checkpoint up to RBA [0xdf2e.2.10], SCN: 1174569124 Tue Jul 21 18:21:09 2009 Incremental checkpoint up to RBA [0xdf2e.f4f.0], current log tail at RBA [0xdf2e.1456.0] Tue Jul 21 18:41:09 2009 Incremental checkpoint up to RBA [0xdf2e.1e60.0], current log tail at RBA [0xdf2e.21b9.0] Tue Jul 21 18:52:28 2009 Beginning log switch checkpoint up to RBA [0xdf2f.2.10], SCN: 1174585937 Thread 1 advanced to log sequence 57135 Current log# 2 seq# 57135 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57135 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 18:57:32 2009 Completed checkpoint up to RBA [0xdf2f.2.10], SCN: 1174585937 Tue Jul 21 19:01:09 2009 Incremental checkpoint up to RBA [0xdf2f.1be.0], current log tail at RBA [0xdf2f.ddd.0] Tue Jul 21 19:21:09 2009 Incremental checkpoint up to RBA [0xdf2f.16e8.0], current log tail at RBA [0xdf2f.1acd.0] Tue Jul 21 19:41:09 2009 Incremental checkpoint up to RBA [0xdf2f.2303.0], current log tail at RBA [0xdf2f.2639.0] Tue Jul 21 19:45:55 2009 Beginning log switch checkpoint up to RBA [0xdf30.2.10], SCN: 1174603587 Thread 1 advanced to log sequence 57136 Current log# 1 seq# 57136 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57136 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 19:50:59 2009 Completed checkpoint up to RBA [0xdf30.2.10], SCN: 1174603587 Tue Jul 21 20:01:09 2009 Incremental checkpoint up to RBA [0xdf30.777.0], current log tail at RBA [0xdf30.14b4.0] Tue Jul 21 20:19:55 2009 Beginning log switch checkpoint up to RBA [0xdf31.2.10], SCN: 1174614227 Thread 1 advanced to log sequence 57137 Current log# 2 seq# 57137 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57137 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 20:21:09 2009 Incremental checkpoint up to RBA [0xdf30.25d9.0], current log tail at RBA [0xdf31.55.0] Tue Jul 21 20:24:59 2009 Completed checkpoint up to RBA [0xdf31.2.10], SCN: 1174614227 Tue Jul 21 20:41:09 2009 Incremental checkpoint up to RBA [0xdf31.9ac.0], current log tail at RBA [0xdf31.c3a.0] Tue Jul 21 21:01:09 2009 Incremental checkpoint up to RBA [0xdf31.1575.0], current log tail at RBA [0xdf31.2123.0] Tue Jul 21 21:11:00 2009 Beginning log switch checkpoint up to RBA [0xdf32.2.10], SCN: 1174630031 Thread 1 advanced to log sequence 57138 Current log# 1 seq# 57138 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57138 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 21:16:05 2009 Completed checkpoint up to RBA [0xdf32.2.10], SCN: 1174630031 Tue Jul 21 21:21:09 2009 Incremental checkpoint up to RBA [0xdf32.315.0], current log tail at RBA [0xdf32.567.0] Tue Jul 21 21:41:09 2009 Incremental checkpoint up to RBA [0xdf32.e4b.0], current log tail at RBA [0xdf32.110b.0] Tue Jul 21 22:00:18 2009 Beginning log switch checkpoint up to RBA [0xdf33.2.10], SCN: 1174644472 Thread 1 advanced to log sequence 57139 Current log# 2 seq# 57139 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57139 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Tue Jul 21 22:01:09 2009 Incremental checkpoint up to RBA [0xdf32.19f2.0], current log tail at RBA [0xdf33.2da.0] Tue Jul 21 22:05:23 2009 Completed checkpoint up to RBA [0xdf33.2.10], SCN: 1174644472 Tue Jul 21 22:21:09 2009 Incremental checkpoint up to RBA [0xdf33.cc8.0], current log tail at RBA [0xdf33.1008.0] Tue Jul 21 22:41:09 2009 Incremental checkpoint up to RBA [0xdf33.181d.0], current log tail at RBA [0xdf33.1b7a.0] Tue Jul 21 23:00:01 2009 Beginning log switch checkpoint up to RBA [0xdf34.2.10], SCN: 1174667526 Thread 1 advanced to log sequence 57140 Current log# 1 seq# 57140 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57140 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Tue Jul 21 23:01:09 2009 Incremental checkpoint up to RBA [0xdf33.2366.0], current log tail at RBA [0xdf34.61c.0] Tue Jul 21 23:05:05 2009 Completed checkpoint up to RBA [0xdf34.2.10], SCN: 1174667526 Tue Jul 21 23:21:09 2009 Incremental checkpoint up to RBA [0xdf34.fdb.0], current log tail at RBA [0xdf34.12e7.0] Tue Jul 21 23:41:09 2009 Incremental checkpoint up to RBA [0xdf34.1b76.0], current log tail at RBA [0xdf34.1e7a.0] Tue Jul 21 23:58:02 2009 Beginning log switch checkpoint up to RBA [0xdf35.2.10], SCN: 1174685104 Thread 1 advanced to log sequence 57141 Current log# 2 seq# 57141 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57141 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 00:01:09 2009 Incremental checkpoint up to RBA [0xdf34.270a.0], current log tail at RBA [0xdf35.c9e.0] Wed Jul 22 00:03:02 2009 Completed checkpoint up to RBA [0xdf35.2.10], SCN: 1174685104 Wed Jul 22 00:21:09 2009 Incremental checkpoint up to RBA [0xdf35.173f.0], current log tail at RBA [0xdf35.1a77.0] Wed Jul 22 00:41:09 2009 Incremental checkpoint up to RBA [0xdf35.237a.0], current log tail at RBA [0xdf35.2631.0] Wed Jul 22 00:44:09 2009 Beginning log switch checkpoint up to RBA [0xdf36.2.10], SCN: 1174700603 Thread 1 advanced to log sequence 57142 Current log# 1 seq# 57142 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57142 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 00:49:14 2009 Completed checkpoint up to RBA [0xdf36.2.10], SCN: 1174700603 Wed Jul 22 01:01:09 2009 Incremental checkpoint up to RBA [0xdf36.725.0], current log tail at RBA [0xdf36.124f.0] Wed Jul 22 01:21:09 2009 Incremental checkpoint up to RBA [0xdf36.1c1a.0], current log tail at RBA [0xdf36.1e55.0] Wed Jul 22 01:38:01 2009 Beginning log switch checkpoint up to RBA [0xdf37.2.10], SCN: 1174718071 Thread 1 advanced to log sequence 57143 Current log# 2 seq# 57143 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57143 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 01:41:09 2009 Incremental checkpoint up to RBA [0xdf36.2672.0], current log tail at RBA [0xdf37.1a1.0] Wed Jul 22 01:43:05 2009 Completed checkpoint up to RBA [0xdf37.2.10], SCN: 1174718071 Wed Jul 22 02:00:30 2009 Beginning log switch checkpoint up to RBA [0xdf38.2.10], SCN: 1174724059 Thread 1 advanced to log sequence 57144 Current log# 1 seq# 57144 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57144 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Thread 1 cannot allocate new log, sequence 57145 Checkpoint not complete Current log# 1 seq# 57144 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57144 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 02:00:32 2009 Completed checkpoint up to RBA [0xdf38.2.10], SCN: 1174724059 Wed Jul 22 02:00:32 2009 Beginning log switch checkpoint up to RBA [0xdf39.2.10], SCN: 1174724077 Thread 1 advanced to log sequence 57145 Current log# 2 seq# 57145 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57145 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 02:01:10 2009 Incremental checkpoint up to RBA [0xdf38.c.0], current log tail at RBA [0xdf39.39.0] Wed Jul 22 02:05:42 2009 Completed checkpoint up to RBA [0xdf39.2.10], SCN: 1174724077 Wed Jul 22 02:08:01 2009 Starting control autobackup Control autobackup written to DISK device handle 'F:\ORACLE\ORADB\DATABASE\C-32940950-20090722-00' Wed Jul 22 02:08:06 2009 Beginning log switch checkpoint up to RBA [0xdf3a.2.10], SCN: 1174727258 Thread 1 advanced to log sequence 57146 Current log# 1 seq# 57146 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57146 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Thread 1 cannot allocate new log, sequence 57147 Checkpoint not complete Current log# 1 seq# 57146 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57146 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 02:08:08 2009 Completed checkpoint up to RBA [0xdf3a.2.10], SCN: 1174727258 Wed Jul 22 02:08:10 2009 Beginning log switch checkpoint up to RBA [0xdf3b.2.10], SCN: 1174727282 Thread 1 advanced to log sequence 57147 Current log# 2 seq# 57147 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57147 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Thread 1 cannot allocate new log, sequence 57148 Checkpoint not complete Current log# 2 seq# 57147 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57147 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 02:08:11 2009 Completed checkpoint up to RBA [0xdf3b.2.10], SCN: 1174727282 Wed Jul 22 02:08:13 2009 Beginning log switch checkpoint up to RBA [0xdf3c.2.10], SCN: 1174727297 Thread 1 advanced to log sequence 57148 Current log# 1 seq# 57148 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57148 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 02:12:15 2009 Starting control autobackup Control autobackup written to DISK device handle 'F:\ORACLE\ORADB\DATABASE\C-32940950-20090722-01' Starting control autobackup Control autobackup written to DISK device handle 'F:\ORACLE\ORADB\DATABASE\C-32940950-20090722-02' Wed Jul 22 02:13:14 2009 Completed checkpoint up to RBA [0xdf3c.2.10], SCN: 1174727297 Wed Jul 22 02:21:14 2009 Incremental checkpoint up to RBA [0xdf3c.c34.0], current log tail at RBA [0xdf3c.f87.0] Wed Jul 22 02:41:14 2009 Incremental checkpoint up to RBA [0xdf3c.1786.0], current log tail at RBA [0xdf3c.1b0d.0] Wed Jul 22 03:00:01 2009 Beginning log switch checkpoint up to RBA [0xdf3d.2.10], SCN: 1174741761 Thread 1 advanced to log sequence 57149 Current log# 2 seq# 57149 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57149 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 03:01:14 2009 Incremental checkpoint up to RBA [0xdf3c.22d1.0], current log tail at RBA [0xdf3d.c36.0] Wed Jul 22 03:05:02 2009 Completed checkpoint up to RBA [0xdf3d.2.10], SCN: 1174741761 Wed Jul 22 03:21:14 2009 Incremental checkpoint up to RBA [0xdf3d.1457.0], current log tail at RBA [0xdf3d.1741.0] Wed Jul 22 03:41:14 2009 Incremental checkpoint up to RBA [0xdf3d.1f91.0], current log tail at RBA [0xdf3d.230d.0] Wed Jul 22 03:51:10 2009 Beginning log switch checkpoint up to RBA [0xdf3e.2.10], SCN: 1174761460 Thread 1 advanced to log sequence 57150 Current log# 1 seq# 57150 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57150 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 03:56:02 2009 Completed checkpoint up to RBA [0xdf3e.2.10], SCN: 1174761460 Wed Jul 22 04:01:14 2009 Incremental checkpoint up to RBA [0xdf3e.30f.0], current log tail at RBA [0xdf3e.ea1.0] Wed Jul 22 04:21:14 2009 Incremental checkpoint up to RBA [0xdf3e.16dd.0], current log tail at RBA [0xdf3e.1a66.0] Wed Jul 22 04:41:14 2009 Incremental checkpoint up to RBA [0xdf3e.2248.0], current log tail at RBA [0xdf3e.2713.0] Wed Jul 22 04:44:10 2009 Beginning log switch checkpoint up to RBA [0xdf3f.2.10], SCN: 1174777302 Thread 1 advanced to log sequence 57151 Current log# 2 seq# 57151 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57151 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 04:49:14 2009 Completed checkpoint up to RBA [0xdf3f.2.10], SCN: 1174777302 Wed Jul 22 05:01:14 2009 Incremental checkpoint up to RBA [0xdf3f.714.0], current log tail at RBA [0xdf3f.1268.0] Wed Jul 22 05:21:14 2009 Incremental checkpoint up to RBA [0xdf3f.1b2a.0], current log tail at RBA [0xdf3f.1e71.0] Wed Jul 22 05:38:05 2009 Beginning log switch checkpoint up to RBA [0xdf40.2.10], SCN: 1174793371 Thread 1 advanced to log sequence 57152 Current log# 1 seq# 57152 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57152 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 05:41:14 2009 Incremental checkpoint up to RBA [0xdf3f.26bf.0], current log tail at RBA [0xdf40.242.0] Wed Jul 22 05:43:05 2009 Completed checkpoint up to RBA [0xdf40.2.10], SCN: 1174793371 Wed Jul 22 06:01:14 2009 Incremental checkpoint up to RBA [0xdf40.99f.0], current log tail at RBA [0xdf40.15d8.0] Wed Jul 22 06:21:14 2009 Incremental checkpoint up to RBA [0xdf40.1e47.0], current log tail at RBA [0xdf40.2171.0] Wed Jul 22 06:33:25 2009 Beginning log switch checkpoint up to RBA [0xdf41.2.10], SCN: 1174808643 Thread 1 advanced to log sequence 57153 Current log# 2 seq# 57153 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57153 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 06:38:05 2009 Completed checkpoint up to RBA [0xdf41.2.10], SCN: 1174808643 Wed Jul 22 06:41:14 2009 Incremental checkpoint up to RBA [0xdf41.154.0], current log tail at RBA [0xdf41.4bd.0] Wed Jul 22 07:01:14 2009 Incremental checkpoint up to RBA [0xdf41.cb9.0], current log tail at RBA [0xdf41.1872.0] Wed Jul 22 07:21:14 2009 Incremental checkpoint up to RBA [0xdf41.2281.0], current log tail at RBA [0xdf41.24ee.0] Wed Jul 22 07:25:02 2009 Beginning log switch checkpoint up to RBA [0xdf42.2.10], SCN: 1174825627 Thread 1 advanced to log sequence 57154 Current log# 1 seq# 57154 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57154 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 07:30:05 2009 Completed checkpoint up to RBA [0xdf42.2.10], SCN: 1174825627 Wed Jul 22 07:41:13 2009 Incremental checkpoint up to RBA [0xdf42.650.0], current log tail at RBA [0xdf42.89c.0] Wed Jul 22 08:01:13 2009 Incremental checkpoint up to RBA [0xdf42.1244.0], current log tail at RBA [0xdf42.1f59.0] Wed Jul 22 08:12:02 2009 Beginning log switch checkpoint up to RBA [0xdf43.2.10], SCN: 1174840893 Thread 1 advanced to log sequence 57155 Current log# 2 seq# 57155 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57155 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 08:17:05 2009 Completed checkpoint up to RBA [0xdf43.2.10], SCN: 1174840893 Wed Jul 22 08:21:13 2009 Incremental checkpoint up to RBA [0xdf43.626.0], current log tail at RBA [0xdf43.139c.0] Wed Jul 22 08:24:30 2009 Beginning log switch checkpoint up to RBA [0xdf44.2.10], SCN: 1174847252 Thread 1 advanced to log sequence 57156 Current log# 1 seq# 57156 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57156 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 08:29:32 2009 Completed checkpoint up to RBA [0xdf44.2.10], SCN: 1174847252 Wed Jul 22 08:41:13 2009 Incremental checkpoint up to RBA [0xdf44.b19.0], current log tail at RBA [0xdf44.126d.0] Wed Jul 22 09:00:05 2009 Beginning log switch checkpoint up to RBA [0xdf45.2.10], SCN: 1174863612 Thread 1 advanced to log sequence 57157 Current log# 2 seq# 57157 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57157 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 09:01:13 2009 Incremental checkpoint up to RBA [0xdf44.1d4f.0], current log tail at RBA [0xdf45.41d.0] Wed Jul 22 09:05:08 2009 Completed checkpoint up to RBA [0xdf45.2.10], SCN: 1174863612 Wed Jul 22 09:07:33 2009 Starting background process EMN0 EMN0 started with pid=22, OS id=2364 Wed Jul 22 09:07:33 2009 Shutting down instance: further logons disabled Wed Jul 22 09:07:34 2009 Stopping background process CJQ0 Wed Jul 22 09:07:35 2009 Stopping background process QMNC Wed Jul 22 09:07:35 2009 Stopping background process MMNL Wed Jul 22 09:07:36 2009 Stopping background process MMON Wed Jul 22 09:07:37 2009 Shutting down instance (immediate) License high water mark = 159 Wed Jul 22 09:07:37 2009 Stopping Job queue slave processes Wed Jul 22 09:07:37 2009 Job queue slave processes stopped Wed Jul 22 09:07:42 2009 ALTER DATABASE CLOSE NORMAL Wed Jul 22 09:07:43 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 09:07:43 2009 Shutting down archive processes Archiving is disabled Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 09:08:10 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5467M/6141M, Ph+PgF:11573M/12102M, VA:2951M/3071M Wed Jul 22 09:08:10 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 545259520 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 356515840 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PMON started with pid=2, OS id=6920 PSP0 started with pid=3, OS id=6912 MMAN started with pid=4, OS id=7356 DBW0 started with pid=5, OS id=7508 LGWR started with pid=6, OS id=4676 CKPT started with pid=7, OS id=5288 SMON started with pid=8, OS id=8112 RECO started with pid=9, OS id=8108 CJQ0 started with pid=10, OS id=6904 MMON started with pid=11, OS id=3480 MMNL started with pid=12, OS id=3648 Wed Jul 22 09:08:10 2009 alter database mount exclusive Wed Jul 22 09:08:14 2009 Setting recovery target incarnation to 1 Wed Jul 22 09:08:14 2009 Successful mount of redo thread 1, with mount id 104745082 Wed Jul 22 09:08:14 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 09:08:14 2009 alter database open Wed Jul 22 09:08:14 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=14, OS id=7904 Wed Jul 22 09:08:14 2009 ARC0: Archival started Wed Jul 22 09:08:14 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57157 Current log# 2 seq# 57157 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57157 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Wed Jul 22 09:08:14 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 09:08:14 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 09:08:14 2009 SMON: enabling cache recovery Wed Jul 22 09:08:15 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 09:08:15 2009 SMON: enabling tx recovery Wed Jul 22 09:08:15 2009 Database Characterset is US7ASCII ARC1 started with pid=15, OS id=3868 Wed Jul 22 09:08:15 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 09:08:16 2009 replication_dependency_tracking turned off (no async multimaster replication found) Wed Jul 22 09:08:16 2009 Incremental checkpoint up to RBA [0xdf45.f78.0], current log tail at RBA [0xdf45.fcc.0] Wed Jul 22 09:08:16 2009 Starting background process QMNC QMNC started with pid=16, OS id=7400 Wed Jul 22 09:08:23 2009 Completed: alter database open Wed Jul 22 09:11:37 2009 Beginning log switch checkpoint up to RBA [0xdf46.2.10], SCN: 1174868458 Thread 1 advanced to log sequence 57158 Current log# 1 seq# 57158 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57158 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 09:15:31 2009 Thread 1 cannot allocate new log, sequence 57159 Checkpoint not complete Current log# 1 seq# 57158 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57158 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 09:15:32 2009 Completed checkpoint up to RBA [0xdf46.2.10], SCN: 1174868458 Wed Jul 22 09:15:32 2009 Beginning log switch checkpoint up to RBA [0xdf47.2.10], SCN: 1174872591 Thread 1 advanced to log sequence 57159 Current log# 2 seq# 57159 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57159 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 09:20:34 2009 Completed checkpoint up to RBA [0xdf47.2.10], SCN: 1174872591 Wed Jul 22 09:20:46 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:20:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:03 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:03 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:17 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:18 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:23 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_960.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:30 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:31 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:34 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4860.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:35 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:56 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:21:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:22:23 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7392.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:22:30 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:22:30 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:23:23 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_804.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:23:27 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:23:36 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:26:22 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6628.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:26:23 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7116.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:26:50 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:26:51 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6616.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:26:52 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7140.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:26:59 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7804.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:27:10 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7804.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:27:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7804.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:27:23 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_1768.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:27:32 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7804.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 09:28:16 2009 Incremental checkpoint up to RBA [0xdf47.986.0], current log tail at RBA [0xdf47.182b.0] Wed Jul 22 09:48:16 2009 Incremental checkpoint up to RBA [0xdf47.23be.0], current log tail at RBA [0xdf47.282d.0] Wed Jul 22 09:48:39 2009 Beginning log switch checkpoint up to RBA [0xdf48.2.10], SCN: 1174887661 Thread 1 advanced to log sequence 57160 Current log# 1 seq# 57160 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57160 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 09:53:25 2009 Completed checkpoint up to RBA [0xdf48.2.10], SCN: 1174887661 Wed Jul 22 10:06:57 2009 Starting background process EMN0 EMN0 started with pid=23, OS id=7940 Wed Jul 22 10:06:58 2009 Shutting down instance: further logons disabled Wed Jul 22 10:06:58 2009 Stopping background process CJQ0 Wed Jul 22 10:06:59 2009 Stopping background process QMNC Wed Jul 22 10:06:59 2009 Stopping background process MMNL Wed Jul 22 10:07:00 2009 Stopping background process MMON Wed Jul 22 10:07:01 2009 Shutting down instance (immediate) License high water mark = 147 Wed Jul 22 10:07:01 2009 Stopping Job queue slave processes Wed Jul 22 10:07:01 2009 Job queue slave processes stopped Wed Jul 22 10:07:16 2009 ALTER DATABASE CLOSE NORMAL Wed Jul 22 10:07:16 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 10:07:17 2009 Shutting down archive processes Archiving is disabled Wed Jul 22 10:07:22 2009 ARCH shutting down ARC1: Archival stopped Wed Jul 22 10:07:27 2009 ARCH shutting down ARC0: Archival stopped Wed Jul 22 10:07:28 2009 Thread 1 closed at log sequence 57160 Successful close of redo thread 1 Wed Jul 22 10:07:28 2009 Completed: ALTER DATABASE CLOSE NORMAL Wed Jul 22 10:07:28 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 10:08:31 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5477M/6141M, Ph+PgF:11605M/12102M, VA:2962M/3071M Wed Jul 22 10:08:31 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 549453824 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 352321536 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PMON started with pid=2, OS id=3536 PSP0 started with pid=3, OS id=7496 MMAN started with pid=4, OS id=6644 DBW0 started with pid=5, OS id=4900 LGWR started with pid=6, OS id=5320 CKPT started with pid=7, OS id=4780 SMON started with pid=8, OS id=8172 RECO started with pid=9, OS id=8076 CJQ0 started with pid=10, OS id=5844 MMON started with pid=11, OS id=4264 MMNL started with pid=12, OS id=5784 Wed Jul 22 10:08:31 2009 alter database mount exclusive Wed Jul 22 10:08:35 2009 Setting recovery target incarnation to 1 Wed Jul 22 10:08:36 2009 Successful mount of redo thread 1, with mount id 104706207 Wed Jul 22 10:08:36 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 10:08:36 2009 alter database open Wed Jul 22 10:08:36 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=14, OS id=6332 Wed Jul 22 10:08:36 2009 ARC0: Archival started Wed Jul 22 10:08:36 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57160 Current log# 1 seq# 57160 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57160 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Successful open of redo thread 1 Wed Jul 22 10:08:36 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 10:08:36 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 10:08:36 2009 SMON: enabling cache recovery Wed Jul 22 10:08:37 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 10:08:37 2009 SMON: enabling tx recovery ARC1 started with pid=15, OS id=4888 Wed Jul 22 10:08:37 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 10:08:37 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Wed Jul 22 10:08:37 2009 Incremental checkpoint up to RBA [0xdf48.24d5.0], current log tail at RBA [0xdf48.2529.0] Wed Jul 22 10:08:38 2009 Starting background process QMNC QMNC started with pid=16, OS id=4804 Wed Jul 22 10:08:45 2009 Completed: alter database open Wed Jul 22 10:09:23 2009 Beginning log switch checkpoint up to RBA [0xdf49.2.10], SCN: 1174898814 Thread 1 advanced to log sequence 57161 Current log# 2 seq# 57161 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57161 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Thread 1 cannot allocate new log, sequence 57162 Checkpoint not complete Current log# 2 seq# 57161 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57161 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 10:09:27 2009 Completed checkpoint up to RBA [0xdf49.2.10], SCN: 1174898814 Wed Jul 22 10:09:27 2009 Beginning log switch checkpoint up to RBA [0xdf4a.2.10], SCN: 1174901360 Thread 1 advanced to log sequence 57162 Current log# 1 seq# 57162 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57162 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 10:14:29 2009 Completed checkpoint up to RBA [0xdf4a.2.10], SCN: 1174901360 Wed Jul 22 10:17:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_5432.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:17:52 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1540.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:17:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:18:12 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:18:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7388.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:19:22 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:19:22 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:19:39 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:19:40 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:19:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_5808.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:20:14 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:21:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4256.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:22:32 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:22:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7692.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:22:50 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:23:00 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7796.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:23:05 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4676.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:23:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:24:37 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:24:43 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:24:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6336.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:19 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:34 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:35 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:37 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:38 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_1068.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:25:55 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:26:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_mmon_4264.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_keltfill+86] [PC:0xBC375A] [ADDR:0x0] [UNABLE_TO_READ] [] Wed Jul 22 10:26:27 2009 Beginning log switch checkpoint up to RBA [0xdf4b.2.10], SCN: 1174910075 Thread 1 advanced to log sequence 57163 Current log# 2 seq# 57163 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57163 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 10:26:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:26:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:26:59 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:27:04 2009 Restarting dead background process MMON MMON started with pid=11, OS id=7032 ORA-25253 encountered when generating server alert SMG-3500 Wed Jul 22 10:27:16 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:27:17 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:27:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6524.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:27:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:27:46 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:27:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:27:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4680.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:11 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:12 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_952.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:17 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:18 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5556.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:26 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:37 2009 Incremental checkpoint up to RBA [0xdf4a.2576.0], current log tail at RBA [0xdf4b.8ae.0] Wed Jul 22 10:28:43 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:43 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4000.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:28:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:29:10 2009 ORA-25253 encountered when generating server alert SMG-3500 Wed Jul 22 10:29:17 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:29:17 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:29:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7548.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 10:31:29 2009 Completed checkpoint up to RBA [0xdf4b.2.10], SCN: 1174910075 Wed Jul 22 10:32:47 2009 Starting background process EMN0 EMN0 started with pid=26, OS id=6872 Wed Jul 22 10:32:47 2009 Shutting down instance: further logons disabled Wed Jul 22 10:32:48 2009 Stopping background process QMNC Wed Jul 22 10:32:49 2009 Stopping background process CJQ0 Wed Jul 22 10:32:50 2009 Stopping background process MMNL Wed Jul 22 10:32:51 2009 Stopping background process MMON Wed Jul 22 10:32:52 2009 Shutting down instance (immediate) License high water mark = 138 Wed Jul 22 10:32:52 2009 Stopping Job queue slave processes Wed Jul 22 10:32:52 2009 Job queue slave processes stopped Wed Jul 22 10:32:56 2009 alter database close normal Wed Jul 22 10:32:56 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 10:32:57 2009 Shutting down archive processes Archiving is disabled Wed Jul 22 10:33:02 2009 ARCH shutting down ARC1: Archival stopped Wed Jul 22 10:33:07 2009 ARCH shutting down ARC0: Archival stopped Wed Jul 22 10:33:08 2009 Thread 1 closed at log sequence 57163 Successful close of redo thread 1 Wed Jul 22 10:33:08 2009 Completed: alter database close normal Wed Jul 22 10:33:08 2009 alter database dismount Completed: alter database dismount ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 10:44:30 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:5537M/6141M, Ph+PgF:11585M/12102M, VA:2951M/3071M Wed Jul 22 10:44:30 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 553648128 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 348127232 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PSP0 started with pid=3, OS id=4892 PMON started with pid=2, OS id=6732 MMAN started with pid=4, OS id=916 DBW0 started with pid=5, OS id=7080 LGWR started with pid=6, OS id=4172 CKPT started with pid=7, OS id=4916 SMON started with pid=8, OS id=7652 RECO started with pid=9, OS id=7660 CJQ0 started with pid=10, OS id=1904 MMON started with pid=11, OS id=6084 MMNL started with pid=12, OS id=664 Wed Jul 22 10:44:35 2009 alter database mount exclusive Wed Jul 22 10:44:39 2009 Setting recovery target incarnation to 1 Wed Jul 22 10:44:39 2009 Successful mount of redo thread 1, with mount id 104730899 Wed Jul 22 10:44:39 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 10:44:39 2009 alter database open Wed Jul 22 10:44:39 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=14, OS id=4156 Wed Jul 22 10:44:39 2009 ARC0: Archival started Wed Jul 22 10:44:39 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57163 Current log# 2 seq# 57163 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57163 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Wed Jul 22 10:44:39 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 10:44:39 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 10:44:39 2009 SMON: enabling cache recovery ARC1 started with pid=15, OS id=5292 Wed Jul 22 10:44:40 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 10:44:40 2009 Incremental checkpoint up to RBA [0xdf4b.123b.0], current log tail at RBA [0xdf4b.123b.0] Wed Jul 22 10:44:40 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 10:44:40 2009 SMON: enabling tx recovery Wed Jul 22 10:44:40 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=16, OS id=6128 Wed Jul 22 10:44:48 2009 Completed: alter database open Wed Jul 22 10:55:23 2009 Starting background process EMN0 EMN0 started with pid=29, OS id=972 Wed Jul 22 10:55:24 2009 Shutting down instance: further logons disabled Wed Jul 22 10:55:24 2009 Stopping background process QMNC Wed Jul 22 10:55:25 2009 Stopping background process CJQ0 Wed Jul 22 10:55:26 2009 Stopping background process MMNL Wed Jul 22 10:55:27 2009 Stopping background process MMON Wed Jul 22 10:55:28 2009 Shutting down instance (immediate) License high water mark = 10 Wed Jul 22 10:55:28 2009 Stopping Job queue slave processes Wed Jul 22 10:55:28 2009 Job queue slave processes stopped Wed Jul 22 10:55:36 2009 ALTER DATABASE CLOSE NORMAL Wed Jul 22 10:55:36 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 10:55:37 2009 Shutting down archive processes Archiving is disabled Wed Jul 22 10:55:47 2009 ARCH shutting down Wed Jul 22 10:55:47 2009 ARC0: Archival stopped Wed Jul 22 10:55:48 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 10:55:48 2009 ARC1: Archiving disabled ARCH shutting down ARC1: Archival stopped Wed Jul 22 10:55:50 2009 Thread 1 closed at log sequence 57163 Successful close of redo thread 1 Wed Jul 22 10:55:50 2009 Completed: ALTER DATABASE CLOSE NORMAL Wed Jul 22 10:55:50 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 11:10:39 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:7593M/8189M, Ph+PgF:15715M/16184M, VA:2951M/3071M Wed Jul 22 11:10:39 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 557842432 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 343932928 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 MMAN started with pid=4, OS id=3952 DBW0 started with pid=5, OS id=3960 LGWR started with pid=6, OS id=3956 CKPT started with pid=7, OS id=3944 SMON started with pid=8, OS id=4140 RECO started with pid=9, OS id=4136 CJQ0 started with pid=10, OS id=4156 MMON started with pid=11, OS id=4152 MMNL started with pid=12, OS id=4200 Wed Jul 22 11:10:41 2009 alter database mount exclusive PMON started with pid=2, OS id=836 PSP0 started with pid=3, OS id=3896 Wed Jul 22 11:10:45 2009 Setting recovery target incarnation to 1 Wed Jul 22 11:10:45 2009 Successful mount of redo thread 1, with mount id 104739377 Wed Jul 22 11:10:45 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 11:10:46 2009 alter database open Wed Jul 22 11:10:46 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=13, OS id=4360 Wed Jul 22 11:10:46 2009 ARC0: Archival started Wed Jul 22 11:10:46 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57163 Current log# 2 seq# 57163 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57163 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Wed Jul 22 11:10:46 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 11:10:46 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 11:10:46 2009 SMON: enabling cache recovery Wed Jul 22 11:10:47 2009 Incremental checkpoint up to RBA [0xdf4b.1773.0], current log tail at RBA [0xdf4b.1773.0] ARC1 started with pid=14, OS id=540 Wed Jul 22 11:10:47 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 11:10:47 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 11:10:47 2009 SMON: enabling tx recovery Wed Jul 22 11:10:47 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=4444 Wed Jul 22 11:10:55 2009 Completed: alter database open Wed Jul 22 11:11:38 2009 Beginning log switch checkpoint up to RBA [0xdf4c.2.10], SCN: 1174923198 Thread 1 advanced to log sequence 57164 Current log# 1 seq# 57164 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57164 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 11:11:52 2009 Thread 1 cannot allocate new log, sequence 57165 Checkpoint not complete Current log# 1 seq# 57164 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57164 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 11:11:56 2009 Completed checkpoint up to RBA [0xdf4c.2.10], SCN: 1174923198 Wed Jul 22 11:11:56 2009 Beginning log switch checkpoint up to RBA [0xdf4d.2.10], SCN: 1174924407 Thread 1 advanced to log sequence 57165 Current log# 2 seq# 57165 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57165 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 11:16:02 2009 Thread 1 cannot allocate new log, sequence 57166 Checkpoint not complete Current log# 2 seq# 57165 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57165 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 11:16:04 2009 Completed checkpoint up to RBA [0xdf4d.2.10], SCN: 1174924407 Wed Jul 22 11:16:05 2009 Beginning log switch checkpoint up to RBA [0xdf4e.2.10], SCN: 1174927945 Thread 1 advanced to log sequence 57166 Current log# 1 seq# 57166 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57166 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 11:21:06 2009 Completed checkpoint up to RBA [0xdf4e.2.10], SCN: 1174927945 Wed Jul 22 11:24:12 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:24:14 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:24:15 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6964.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:24:33 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:24:34 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:24:47 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:24:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:25:15 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7560.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:25:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:25:50 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:26:15 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:26:33 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:26:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6704.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:26:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6704.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:28:04 2009 Beginning log switch checkpoint up to RBA [0xdf4f.2.10], SCN: 1174935455 Thread 1 advanced to log sequence 57167 Current log# 2 seq# 57167 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57167 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 11:29:23 2009 Starting background process EMN0 EMN0 started with pid=34, OS id=7504 Wed Jul 22 11:29:23 2009 Shutting down instance: further logons disabled Wed Jul 22 11:29:23 2009 Completed checkpoint up to RBA [0xdf4f.2.10], SCN: 1174935455 Wed Jul 22 11:29:23 2009 Stopping background process QMNC Wed Jul 22 11:29:24 2009 Stopping background process CJQ0 Wed Jul 22 11:29:24 2009 Stopping background process MMNL Wed Jul 22 11:29:25 2009 Stopping background process MMON Wed Jul 22 11:29:26 2009 Shutting down instance (immediate) License high water mark = 138 Wed Jul 22 11:29:26 2009 Stopping Job queue slave processes Wed Jul 22 11:29:26 2009 Job queue slave processes stopped Wed Jul 22 11:29:38 2009 ALTER DATABASE CLOSE NORMAL Wed Jul 22 11:29:39 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 11:29:39 2009 Shutting down archive processes Archiving is disabled Wed Jul 22 11:29:49 2009 ARC1: Becoming the heartbeat ARCH ARC1: Archiving disabled ARCH shutting down ARC1: Archival stopped Wed Jul 22 11:29:50 2009 ARCH shutting down Wed Jul 22 11:29:50 2009 ARC0: Archival stopped Wed Jul 22 11:29:51 2009 Thread 1 closed at log sequence 57167 Successful close of redo thread 1 Wed Jul 22 11:29:52 2009 Completed: ALTER DATABASE CLOSE NORMAL Wed Jul 22 11:29:52 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 11:42:05 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:7587M/8189M, Ph+PgF:15712M/16184M, VA:2951M/3071M Wed Jul 22 11:42:05 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 562036736 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 339738624 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 MMAN started with pid=4, OS id=4552 DBW0 started with pid=5, OS id=4556 LGWR started with pid=6, OS id=4560 CKPT started with pid=7, OS id=4564 SMON started with pid=8, OS id=4568 RECO started with pid=9, OS id=4572 CJQ0 started with pid=10, OS id=4576 MMON started with pid=11, OS id=4580 MMNL started with pid=12, OS id=4584 Wed Jul 22 11:42:07 2009 alter database mount exclusive PMON started with pid=2, OS id=4544 PSP0 started with pid=3, OS id=4548 Wed Jul 22 11:42:11 2009 Setting recovery target incarnation to 1 Wed Jul 22 11:42:11 2009 Successful mount of redo thread 1, with mount id 104699279 Wed Jul 22 11:42:11 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 11:42:11 2009 alter database open Wed Jul 22 11:42:11 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=13, OS id=4700 Wed Jul 22 11:42:11 2009 ARC0: Archival started Wed Jul 22 11:42:11 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57167 Current log# 2 seq# 57167 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57167 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Wed Jul 22 11:42:12 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 11:42:12 2009 SMON: enabling cache recovery Wed Jul 22 11:42:12 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 11:42:12 2009 Incremental checkpoint up to RBA [0xdf4f.5c5.0], current log tail at RBA [0xdf4f.5c5.0] ARC1 started with pid=14, OS id=4704 Wed Jul 22 11:42:12 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 11:42:13 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 11:42:13 2009 SMON: enabling tx recovery Wed Jul 22 11:42:13 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=4720 Wed Jul 22 11:42:21 2009 Completed: alter database open Wed Jul 22 11:43:03 2009 Beginning log switch checkpoint up to RBA [0xdf50.2.10], SCN: 1174939222 Thread 1 advanced to log sequence 57168 Current log# 1 seq# 57168 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57168 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 11:47:30 2009 Thread 1 cannot allocate new log, sequence 57169 Checkpoint not complete Current log# 1 seq# 57168 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57168 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 11:47:31 2009 Completed checkpoint up to RBA [0xdf50.2.10], SCN: 1174939222 Wed Jul 22 11:47:31 2009 Beginning log switch checkpoint up to RBA [0xdf51.2.10], SCN: 1174945185 Thread 1 advanced to log sequence 57169 Current log# 2 seq# 57169 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57169 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 11:52:32 2009 Completed checkpoint up to RBA [0xdf51.2.10], SCN: 1174945185 Wed Jul 22 11:58:32 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:58:35 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6636.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:58:42 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:58:43 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6596.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:58:44 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4028.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:58:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7804.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:58:57 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:58:58 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:59:04 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:59:09 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:59:10 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 11:59:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_1984.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:00:29 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:00:30 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6084.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:00:36 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8060.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:00:39 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8060.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:00:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_440.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:01:40 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8060.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:01:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_5704.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:02:04 2009 Incremental checkpoint up to RBA [0xdf51.b8e.0], current log tail at RBA [0xdf51.2613.0] Wed Jul 22 12:02:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_3916.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:03:26 2009 Beginning log switch checkpoint up to RBA [0xdf52.2.10], SCN: 1174953733 Thread 1 advanced to log sequence 57170 Current log# 1 seq# 57170 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57170 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 12:08:28 2009 Completed checkpoint up to RBA [0xdf52.2.10], SCN: 1174953733 Wed Jul 22 12:08:42 2009 Starting background process EMN0 EMN0 started with pid=26, OS id=3640 Wed Jul 22 12:08:42 2009 Shutting down instance: further logons disabled Wed Jul 22 12:08:44 2009 Stopping background process QMNC Wed Jul 22 12:08:45 2009 Stopping background process CJQ0 Wed Jul 22 12:08:46 2009 Stopping background process MMNL Wed Jul 22 12:08:52 2009 Beginning log switch checkpoint up to RBA [0xdf53.2.10], SCN: 1174955794 Thread 1 advanced to log sequence 57171 Current log# 2 seq# 57171 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57171 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Thread 1 cannot allocate new log, sequence 57172 Checkpoint not complete Current log# 2 seq# 57171 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57171 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 12:08:55 2009 Completed checkpoint up to RBA [0xdf53.2.10], SCN: 1174955794 Wed Jul 22 12:08:55 2009 Beginning log switch checkpoint up to RBA [0xdf54.2.10], SCN: 1174956329 Thread 1 advanced to log sequence 57172 Current log# 1 seq# 57172 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57172 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 12:09:02 2009 Stopping background process MMON Wed Jul 22 12:09:03 2009 Shutting down instance (immediate) License high water mark = 142 Wed Jul 22 12:09:03 2009 Stopping Job queue slave processes Wed Jul 22 12:09:03 2009 Job queue slave processes stopped Wed Jul 22 12:09:08 2009 ALTER DATABASE CLOSE NORMAL Wed Jul 22 12:09:08 2009 Thread 1 cannot allocate new log, sequence 57173 Checkpoint not complete Current log# 1 seq# 57172 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57172 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 12:09:10 2009 Completed checkpoint up to RBA [0xdf54.2.10], SCN: 1174956329 Wed Jul 22 12:09:10 2009 Beginning log switch checkpoint up to RBA [0xdf55.2.10], SCN: 1174957243 Thread 1 advanced to log sequence 57173 Current log# 2 seq# 57173 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57173 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 12:09:11 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 12:09:12 2009 Shutting down archive processes Archiving is disabled Wed Jul 22 12:09:17 2009 ARCH shutting down ARC1: Archival stopped Wed Jul 22 12:09:22 2009 ARCH shutting down ARC0: Archival stopped Wed Jul 22 12:09:23 2009 Thread 1 closed at log sequence 57173 Successful close of redo thread 1 Wed Jul 22 12:09:23 2009 Completed: ALTER DATABASE CLOSE NORMAL Wed Jul 22 12:09:23 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 12:18:56 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:7451M/8189M, Ph+PgF:15347M/16184M, VA:2945M/3071M Wed Jul 22 12:18:56 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 566231040 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 335544320 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 MMAN started with pid=6, OS id=5820 DBW0 started with pid=7, OS id=3380 LGWR started with pid=8, OS id=6028 CKPT started with pid=9, OS id=364 SMON started with pid=10, OS id=5856 RECO started with pid=11, OS id=4828 CJQ0 started with pid=12, OS id=5724 MMON started with pid=13, OS id=868 MMNL started with pid=14, OS id=612 Wed Jul 22 12:18:59 2009 ALTER DATABASE MOUNT PSP0 started with pid=5, OS id=1136 PMON started with pid=3, OS id=5800 Wed Jul 22 12:19:03 2009 Setting recovery target incarnation to 1 Wed Jul 22 12:19:03 2009 Successful mount of redo thread 1, with mount id 104723763 Wed Jul 22 12:19:03 2009 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Wed Jul 22 12:19:03 2009 ALTER DATABASE OPEN Wed Jul 22 12:19:03 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=4, OS id=904 Wed Jul 22 12:19:03 2009 ARC0: Archival started Wed Jul 22 12:19:03 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57173 Current log# 2 seq# 57173 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57173 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Wed Jul 22 12:19:03 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 12:19:03 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 12:19:03 2009 SMON: enabling cache recovery Wed Jul 22 12:19:04 2009 Incremental checkpoint up to RBA [0xdf55.539.0], current log tail at RBA [0xdf55.539.0] ARC1 started with pid=15, OS id=5480 Wed Jul 22 12:19:04 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 12:19:04 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 12:19:04 2009 SMON: enabling tx recovery Wed Jul 22 12:19:04 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=16, OS id=1340 Wed Jul 22 12:19:12 2009 Completed: ALTER DATABASE OPEN Wed Jul 22 12:19:24 2009 Starting background process EMN0 EMN0 started with pid=33, OS id=5596 Wed Jul 22 12:19:24 2009 Shutting down instance: further logons disabled Wed Jul 22 12:19:25 2009 Stopping background process QMNC Wed Jul 22 12:19:25 2009 Stopping background process CJQ0 Wed Jul 22 12:19:26 2009 Stopping background process MMNL Wed Jul 22 12:19:27 2009 Stopping background process MMON Wed Jul 22 12:19:28 2009 Shutting down instance (immediate) License high water mark = 12 Wed Jul 22 12:19:28 2009 Stopping Job queue slave processes Wed Jul 22 12:19:28 2009 Job queue slave processes stopped Wed Jul 22 12:19:31 2009 ALTER DATABASE CLOSE NORMAL Wed Jul 22 12:19:32 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 12:19:32 2009 Shutting down archive processes Archiving is disabled Wed Jul 22 12:19:37 2009 ARCH shutting down ARC1: Archival stopped Wed Jul 22 12:19:42 2009 ARCH shutting down ARC0: Archival stopped Wed Jul 22 12:19:43 2009 Thread 1 closed at log sequence 57173 Successful close of redo thread 1 Wed Jul 22 12:19:44 2009 Completed: ALTER DATABASE CLOSE NORMAL Wed Jul 22 12:19:44 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 12:20:24 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:7585M/8189M, Ph+PgF:15694M/16184M, VA:2951M/3071M Wed Jul 22 12:20:24 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 570425344 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 331350016 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PMON started with pid=2, OS id=4100 PSP0 started with pid=3, OS id=4396 MMAN started with pid=4, OS id=4860 DBW0 started with pid=5, OS id=4556 LGWR started with pid=6, OS id=5780 CKPT started with pid=7, OS id=4748 SMON started with pid=8, OS id=5680 RECO started with pid=9, OS id=1736 CJQ0 started with pid=10, OS id=792 MMON started with pid=11, OS id=4788 MMNL started with pid=12, OS id=2116 Wed Jul 22 12:20:24 2009 alter database mount exclusive Wed Jul 22 12:20:28 2009 Setting recovery target incarnation to 1 Wed Jul 22 12:20:28 2009 Successful mount of redo thread 1, with mount id 104703624 Wed Jul 22 12:20:28 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 12:20:28 2009 alter database open Wed Jul 22 12:20:28 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=14, OS id=4552 Wed Jul 22 12:20:28 2009 ARC0: Archival started Wed Jul 22 12:20:28 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57173 Current log# 2 seq# 57173 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57173 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Wed Jul 22 12:20:28 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 12:20:28 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 12:20:29 2009 Successfully onlined Undo Tablespace 1. ARC1 started with pid=15, OS id=4588 Wed Jul 22 12:20:29 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 12:20:29 2009 SMON: enabling cache recovery Wed Jul 22 12:20:29 2009 SMON: enabling tx recovery Wed Jul 22 12:20:30 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Wed Jul 22 12:20:30 2009 Incremental checkpoint up to RBA [0xdf55.923.0], current log tail at RBA [0xdf55.979.0] Wed Jul 22 12:20:31 2009 Starting background process QMNC QMNC started with pid=16, OS id=5872 Wed Jul 22 12:20:37 2009 Completed: alter database open Wed Jul 22 12:21:19 2009 Beginning log switch checkpoint up to RBA [0xdf56.2.10], SCN: 1174963337 Thread 1 advanced to log sequence 57174 Current log# 1 seq# 57174 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57174 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 12:21:50 2009 Thread 1 cannot allocate new log, sequence 57175 Checkpoint not complete Current log# 1 seq# 57174 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57174 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 12:21:51 2009 Completed checkpoint up to RBA [0xdf56.2.10], SCN: 1174963337 Wed Jul 22 12:21:51 2009 Beginning log switch checkpoint up to RBA [0xdf57.2.10], SCN: 1174964986 Thread 1 advanced to log sequence 57175 Current log# 2 seq# 57175 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57175 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 12:26:52 2009 Completed checkpoint up to RBA [0xdf57.2.10], SCN: 1174964986 Wed Jul 22 12:31:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_2108.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:32:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6692.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:33:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6484.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:33:21 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6792.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:33:25 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:33:26 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6928.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:33:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_5728.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:34:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7416.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:34:55 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:34:59 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:35:00 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7624.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:35:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_5640.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:36:37 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:36:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_8080.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:37:24 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:37:25 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:37:43 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:37:43 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:37:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7512.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:38:05 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:38:06 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1912.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:38:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7588.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:39:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7900.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:40:27 2009 Incremental checkpoint up to RBA [0xdf57.13f6.0], current log tail at RBA [0xdf57.1ead.0] Wed Jul 22 12:40:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_8008.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 12:52:17 2009 Beginning log switch checkpoint up to RBA [0xdf58.2.10], SCN: 1174975114 Thread 1 advanced to log sequence 57176 Current log# 1 seq# 57176 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57176 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 12:57:18 2009 Completed checkpoint up to RBA [0xdf58.2.10], SCN: 1174975114 Wed Jul 22 13:00:27 2009 Incremental checkpoint up to RBA [0xdf58.10de.0], current log tail at RBA [0xdf58.1d9d.0] Wed Jul 22 13:01:48 2009 Beginning log switch checkpoint up to RBA [0xdf59.2.10], SCN: 1174979049 Thread 1 advanced to log sequence 57177 Current log# 2 seq# 57177 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57177 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 13:06:51 2009 Completed checkpoint up to RBA [0xdf59.2.10], SCN: 1174979049 Wed Jul 22 13:08:59 2009 Beginning log switch checkpoint up to RBA [0xdf5a.2.10], SCN: 1174982905 Thread 1 advanced to log sequence 57178 Current log# 1 seq# 57178 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57178 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 13:14:00 2009 Completed checkpoint up to RBA [0xdf5a.2.10], SCN: 1174982905 Wed Jul 22 13:20:27 2009 Incremental checkpoint up to RBA [0xdf5a.d02.0], current log tail at RBA [0xdf5a.ebf.0] Wed Jul 22 13:23:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4764.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:24:05 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:24:06 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7676.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:24:07 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:24:18 2009 ORA-25253 encountered when generating server alert SMG-3503 Wed Jul 22 13:24:25 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:24:26 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:24:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_8120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:25:06 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:25:07 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:25:34 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:25:35 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:25:41 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:25:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4260.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:32:37 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5452.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:32:48 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5452.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:32:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7972.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:32:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:32:56 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6048.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:33:00 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5452.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:33:19 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5452.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:33:41 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5452.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:33:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7612.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:34:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_296.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:35:10 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:35:11 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:35:26 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:35:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7736.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:36:12 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:36:14 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:36:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6432.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:37:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_8100.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:38:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7464.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:39:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_716.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:40:27 2009 Incremental checkpoint up to RBA [0xdf5a.183a.0], current log tail at RBA [0xdf5a.19b9.0] Wed Jul 22 13:40:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4220.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:41:33 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7880.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 13:56:29 2009 Beginning log switch checkpoint up to RBA [0xdf5b.2.10], SCN: 1174996507 Thread 1 advanced to log sequence 57179 Current log# 2 seq# 57179 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57179 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 14:00:27 2009 Incremental checkpoint up to RBA [0xdf5a.2679.0], current log tail at RBA [0xdf5b.ebf.0] Wed Jul 22 14:01:33 2009 Completed checkpoint up to RBA [0xdf5b.2.10], SCN: 1174996507 Wed Jul 22 14:10:47 2009 Beginning log switch checkpoint up to RBA [0xdf5c.2.10], SCN: 1175002570 Thread 1 advanced to log sequence 57180 Current log# 1 seq# 57180 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57180 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 14:13:31 2009 ALTER DATABASE DATAFILE 'H:\ORACLE\PRODDATA\A_MEDIA01.DBF' RESIZE 1998800K Wed Jul 22 14:13:32 2009 Completed: ALTER DATABASE DATAFILE 'H:\ORACLE\PRODDATA\A_MEDIA01.DBF' RESIZE 1998800K Wed Jul 22 14:13:32 2009 ALTER DATABASE DATAFILE 'H:\ORACLE\PRODDATA\A_MEDIA01.DBF' AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED Completed: ALTER DATABASE DATAFILE 'H:\ORACLE\PRODDATA\A_MEDIA01.DBF' AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED Wed Jul 22 14:14:23 2009 ALTER DATABASE DATAFILE 'H:\ORACLE\PRODDATA\A_MEDIA01.DBF' RESIZE 2998800K Wed Jul 22 14:14:45 2009 Completed: ALTER DATABASE DATAFILE 'H:\ORACLE\PRODDATA\A_MEDIA01.DBF' RESIZE 2998800K Wed Jul 22 14:15:51 2009 Completed checkpoint up to RBA [0xdf5c.2.10], SCN: 1175002570 Wed Jul 22 14:20:27 2009 Incremental checkpoint up to RBA [0xdf5c.1174.0], current log tail at RBA [0xdf5c.1e80.0] Wed Jul 22 14:22:17 2009 Beginning log switch checkpoint up to RBA [0xdf5d.2.10], SCN: 1175016692 Thread 1 advanced to log sequence 57181 Current log# 2 seq# 57181 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57181 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 14:22:35 2009 Thread 1 cannot allocate new log, sequence 57182 Checkpoint not complete Current log# 2 seq# 57181 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57181 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 14:22:36 2009 Completed checkpoint up to RBA [0xdf5d.2.10], SCN: 1175016692 Wed Jul 22 14:22:36 2009 Beginning log switch checkpoint up to RBA [0xdf5e.2.10], SCN: 1175017489 Thread 1 advanced to log sequence 57182 Current log# 1 seq# 57182 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57182 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 14:25:30 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6640.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:25:31 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6568.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:27:42 2009 Completed checkpoint up to RBA [0xdf5e.2.10], SCN: 1175017489 Wed Jul 22 14:35:32 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:36:13 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6724.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:36:15 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5320.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:36:22 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6724.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:36:26 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:36:40 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:36:41 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:36:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6996.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:37:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_440.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:38:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4784.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:39:39 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:39:40 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:39:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_4720.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:39:52 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:39:52 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:40:18 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_4944.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:40:25 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:40:27 2009 Incremental checkpoint up to RBA [0xdf5e.20a4.0], current log tail at RBA [0xdf5e.25f3.0] Wed Jul 22 14:40:29 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:40:45 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_5312.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:40:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_3892.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:40:49 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_6724.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 14:42:23 2009 Beginning log switch checkpoint up to RBA [0xdf5f.2.10], SCN: 1175025837 Thread 1 advanced to log sequence 57183 Current log# 2 seq# 57183 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57183 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 14:44:53 2009 Starting background process EMN0 EMN0 started with pid=39, OS id=5804 Wed Jul 22 14:44:54 2009 Shutting down instance: further logons disabled Wed Jul 22 14:44:54 2009 Completed checkpoint up to RBA [0xdf5f.2.10], SCN: 1175025837 Wed Jul 22 14:44:54 2009 Stopping background process CJQ0 Wed Jul 22 14:44:55 2009 Stopping background process QMNC Wed Jul 22 14:44:55 2009 Stopping background process MMNL Wed Jul 22 14:44:56 2009 Stopping background process MMON Wed Jul 22 14:44:57 2009 Shutting down instance (immediate) License high water mark = 159 Wed Jul 22 14:44:57 2009 Stopping Job queue slave processes Wed Jul 22 14:44:57 2009 Job queue slave processes stopped Wed Jul 22 14:45:27 2009 ALTER DATABASE CLOSE NORMAL Wed Jul 22 14:45:28 2009 SMON: disabling tx recovery SMON: disabling cache recovery Wed Jul 22 14:45:28 2009 Shutting down archive processes Archiving is disabled Wed Jul 22 14:45:34 2009 ARCH shutting down ARC1: Archival stopped Wed Jul 22 14:45:39 2009 ARCH shutting down ARC0: Archival stopped Wed Jul 22 14:45:40 2009 Thread 1 closed at log sequence 57183 Successful close of redo thread 1 Wed Jul 22 14:45:40 2009 Completed: ALTER DATABASE CLOSE NORMAL Wed Jul 22 14:45:40 2009 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 14:55:27 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:7592M/8189M, Ph+PgF:15731M/16184M, VA:2948M/3071M Wed Jul 22 14:55:27 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 574619648 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 327155712 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 MMAN started with pid=4, OS id=5124 DBW0 started with pid=5, OS id=5128 LGWR started with pid=6, OS id=5132 CKPT started with pid=7, OS id=5136 SMON started with pid=8, OS id=5140 RECO started with pid=9, OS id=5144 CJQ0 started with pid=10, OS id=5148 MMON started with pid=11, OS id=5152 MMNL started with pid=12, OS id=5156 Wed Jul 22 14:55:29 2009 alter database mount exclusive PMON started with pid=2, OS id=5116 PSP0 started with pid=3, OS id=5120 Wed Jul 22 14:55:33 2009 Setting recovery target incarnation to 1 Wed Jul 22 14:55:33 2009 Successful mount of redo thread 1, with mount id 104747745 Wed Jul 22 14:55:33 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 14:55:33 2009 alter database open Wed Jul 22 14:55:34 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=13, OS id=5180 Wed Jul 22 14:55:34 2009 ARC0: Archival started Wed Jul 22 14:55:34 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 opened at log sequence 57183 Current log# 2 seq# 57183 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57183 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Successful open of redo thread 1 Wed Jul 22 14:55:34 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 14:55:34 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 14:55:34 2009 SMON: enabling cache recovery Wed Jul 22 14:55:35 2009 Incremental checkpoint up to RBA [0xdf5f.695.0], current log tail at RBA [0xdf5f.695.0] ARC1 started with pid=14, OS id=5184 Wed Jul 22 14:55:35 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 14:55:35 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 14:55:35 2009 SMON: enabling tx recovery Wed Jul 22 14:55:35 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=5192 Wed Jul 22 14:55:43 2009 Completed: alter database open Wed Jul 22 14:56:27 2009 Beginning log switch checkpoint up to RBA [0xdf60.2.10], SCN: 1175030164 Thread 1 advanced to log sequence 57184 Current log# 1 seq# 57184 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57184 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 14:58:03 2009 Thread 1 cannot allocate new log, sequence 57185 Checkpoint not complete Current log# 1 seq# 57184 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57184 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 14:58:05 2009 Completed checkpoint up to RBA [0xdf60.2.10], SCN: 1175030164 Wed Jul 22 14:58:05 2009 Beginning log switch checkpoint up to RBA [0xdf61.2.10], SCN: 1175034153 Thread 1 advanced to log sequence 57185 Current log# 2 seq# 57185 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57185 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 15:00:51 2009 Thread 1 cannot allocate new log, sequence 57186 Checkpoint not complete Current log# 2 seq# 57185 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57185 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 15:00:53 2009 Completed checkpoint up to RBA [0xdf61.2.10], SCN: 1175034153 Wed Jul 22 15:00:54 2009 Beginning log switch checkpoint up to RBA [0xdf62.2.10], SCN: 1175038426 Thread 1 advanced to log sequence 57186 Current log# 1 seq# 57186 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57186 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Wed Jul 22 15:05:56 2009 Completed checkpoint up to RBA [0xdf62.2.10], SCN: 1175038426 Wed Jul 22 15:10:17 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8148.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:01 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7552.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:01 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:02 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:20 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:21 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:22 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:23 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:11:34 2009 Beginning log switch checkpoint up to RBA [0xdf63.2.10], SCN: 1175043569 Thread 1 advanced to log sequence 57187 Current log# 2 seq# 57187 mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Current log# 2 seq# 57187 mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 15:12:05 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6284.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:12:39 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:12:40 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:12:51 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_8124.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:12:53 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:12:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:05 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:09 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6540.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:26 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:28 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:28 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:29 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:30 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_1120.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:54 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:55 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:13:56 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:14:07 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:14:08 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:14:09 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:14:09 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_8048.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:14:23 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:14:24 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:14:29 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7904.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:15:13 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_6168.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:15:24 2009 Incremental checkpoint up to RBA [0xdf62.20d0.0], current log tail at RBA [0xdf63.6e0.0] Wed Jul 22 15:16:13 2009 Errors in file f:\oracle\oradb\admin\prod_emccerp\bdump\prod_j000_7564.trc: ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], [] Wed Jul 22 15:16:33 2009 Completed checkpoint up to RBA [0xdf63.2.10], SCN: 1175043569 Wed Jul 22 15:19:24 2009 Starting background process EMN0 EMN0 started with pid=18, OS id=7772 Wed Jul 22 15:19:25 2009 Shutting down instance: further logons disabled Wed Jul 22 15:19:25 2009 Stopping background process QMNC Wed Jul 22 15:19:26 2009 Stopping background process CJQ0 Wed Jul 22 15:19:27 2009 Stopping background process MMNL Wed Jul 22 15:19:28 2009 Stopping background process MMON Wed Jul 22 15:19:29 2009 Shutting down instance (immediate) License high water mark = 142 Wed Jul 22 15:19:29 2009 Stopping Job queue slave processes Wed Jul 22 15:19:29 2009 Job queue slave processes stopped Wed Jul 22 15:19:35 2009 Process OS id : 7404 alive after kill Errors in file f:\oracle\oradb\admin\prod_emccerp\udump\prod_ora_7588.trc Dump file f:\oracle\oradb\admin\prod_emccerp\bdump\alert_prod.log Wed Jul 22 15:19:53 2009 ORACLE V10.2.0.3.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows NT Version V5.2 Service Pack 2 CPU : 4 - type 586, 2 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:7576M/8189M, Ph+PgF:15712M/16184M, VA:2951M/3071M Wed Jul 22 15:19:53 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Autotune of undo retention is turned on. IMODE=BR ILAT =88 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.3.0. System parameters with non-default values: _trace_files_public = TRUE processes = 400 sessions = 800 timed_statistics = TRUE sga_max_size = 943718400 __shared_pool_size = 578813952 shared_pool_size = 419430400 __large_pool_size = 4194304 __java_pool_size = 16777216 __streams_pool_size = 8388608 shared_pool_reserved_size= 41943040 nls_language = american nls_territory = america nls_sort = binary nls_date_format = DD-MON-RR nls_numeric_characters = ., nls_comp = binary nls_length_semantics = BYTE sga_target = 943718400 control_files = H:\ORACLE\PRODDATA\CNTRL01.DBF, H:\ORACLE\PRODDATA\CNTRL02.DBF, F:\ORACLE\PRODDATA\CNTRL03.DBF db_block_checksum = TRUE db_block_size = 8192 __db_cache_size = 322961408 compatible = 10.2.0 log_archive_dest_1 = LOCATION=F:\oradb_archive\ log_archive_format = ARC%S_%R.%T log_buffer = 11114496 log_checkpoint_interval = 100000 log_checkpoint_timeout = 1200 db_files = 512 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE dml_locks = 10000 undo_management = AUTO undo_tablespace = APPS_UNDOTS1 db_block_checking = FALSE remote_login_passwordfile= SHARED session_cached_cursors = 500 utl_file_dir = c:\temp, f:\oracle\proddb\9.2.0\plsql\temp, f:\oracle\proddb\9.2.0\appsutil\outbound\PROD_emccerp, c:\temp, c:\temp plsql_native_library_dir = f:\oracle\oradb\plsql\nativelib plsql_native_library_subdir_count= 149 plsql_code_type = INTERPRETED plsql_optimize_level = 2 job_queue_processes = 2 _system_trig_enabled = TRUE cursor_sharing = EXACT parallel_min_servers = 0 parallel_max_servers = 8 background_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\BDUMP user_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\UDUMP max_dump_file_size = 20480 core_dump_dest = F:\ORACLE\ORADB\ADMIN\PROD_EMCCERP\CDUMP db_name = PROD open_cursors = 600 _sort_elimination_cost_ratio= 5 _b_tree_bitmap_plans = FALSE _fast_full_scan_enabled = FALSE query_rewrite_enabled = true _index_join_enabled = FALSE _sqlexec_progression_cost= 2147483647 _like_with_bind_as_equality= TRUE pga_aggregate_target = 1572864000 workarea_size_policy = AUTO optimizer_secure_view_merging= TRUE aq_tm_processes = 1 olap_page_pool_size = 4194304 PMON started with pid=2, OS id=6344 PSP0 started with pid=3, OS id=7628 MMAN started with pid=4, OS id=4980 DBW0 started with pid=5, OS id=5012 LGWR started with pid=6, OS id=4996 CKPT started with pid=7, OS id=5340 SMON started with pid=8, OS id=6540 RECO started with pid=9, OS id=7356 CJQ0 started with pid=10, OS id=7892 MMON started with pid=11, OS id=6692 MMNL started with pid=12, OS id=7868 Wed Jul 22 15:19:54 2009 alter database mount exclusive Wed Jul 22 15:19:58 2009 Setting recovery target incarnation to 1 Wed Jul 22 15:19:58 2009 Successful mount of redo thread 1, with mount id 104715674 Wed Jul 22 15:19:58 2009 Database mounted in Exclusive Mode Completed: alter database mount exclusive Wed Jul 22 15:19:58 2009 alter database open Wed Jul 22 15:19:58 2009 Beginning crash recovery of 1 threads parallel recovery started with 3 processes Wed Jul 22 15:19:58 2009 Started redo scan Wed Jul 22 15:19:58 2009 Completed redo scan 0 redo blocks read, 0 data blocks need recovery Wed Jul 22 15:19:58 2009 Started redo application at Thread 1: logseq 57187, block 3627, scn 1175047693 Wed Jul 22 15:19:58 2009 Recovery of Online Redo Log: Thread 1 Group 2 Seq 57187 Reading mem 0 Mem# 0: H:\ORACLE\PRODDATA\LOG02A.DBF Mem# 1: H:\ORACLE\PRODDATA\LOG02B.DBF Wed Jul 22 15:19:58 2009 Completed redo application Wed Jul 22 15:19:58 2009 Completed crash recovery at Thread 1: logseq 57187, block 3627, scn 1175067694 0 data blocks read, 0 data blocks written, 0 redo blocks read Wed Jul 22 15:19:58 2009 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=17, OS id=5220 Wed Jul 22 15:19:58 2009 ARC0: Archival started Wed Jul 22 15:19:58 2009 ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Thread 1 advanced to log sequence 57188 Thread 1 opened at log sequence 57188 Current log# 1 seq# 57188 mem# 0: H:\ORACLE\PRODDATA\LOG01A.DBF Current log# 1 seq# 57188 mem# 1: H:\ORACLE\PRODDATA\LOG01B.DBF Successful open of redo thread 1 Wed Jul 22 15:19:59 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Jul 22 15:19:59 2009 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Wed Jul 22 15:19:59 2009 SMON: enabling cache recovery Wed Jul 22 15:19:59 2009 Incremental checkpoint up to RBA [0xdf64.3.0], current log tail at RBA [0xdf64.74.0] Wed Jul 22 15:19:59 2009 Successfully onlined Undo Tablespace 1. Wed Jul 22 15:19:59 2009 SMON: enabling tx recovery ARC1 started with pid=18, OS id=6640 Wed Jul 22 15:19:59 2009 ARC1: Becoming the heartbeat ARCH Wed Jul 22 15:20:00 2009 Database Characterset is US7ASCII replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=19, OS id=7984 Wed Jul 22 15:20:08 2009 Completed: alter database open