- 论坛徽章:
- 0
|
求救：我的ORACLE转入归档日志后，大概一天就会down掉
这个是我的alert。log
Thu May 27 20:14:44 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu May 27 20:14:45 2004
/* OracleOEM */ ALTER DATABASE MOUNT
Thu May 27 20:14:51 2004
Successful mount of redo thread 1, with mount id 1610832503.
Thu May 27 20:14:51 2004
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Thu May 27 20:14:51 2004
/* OracleOEM */ ALTER DATABASE ARCHIVELOG
Completed: /* OracleOEM */ ALTER DATABASE ARCHIVELOG
Thu May 27 20:14:51 2004
/* OracleOEM */ ALTER DATABASE OPEN
Thu May 27 20:14:51 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 149
Current log# 1 seq# 149 mem# 0: /home/oracle/oradata/mes/redo01.log
Successful open of redo thread 1.
Thu May 27 20:14:52 2004
SMON: enabling cache recovery
Thu May 27 20:14:52 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu May 27 20:14:52 2004
SMON: enabling tx recovery
Thu May 27 20:14:52 2004
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Using log_archive_dest parameter default value
Archiving is enabled
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=14
ARC0: Archival started
ARC1 started with pid=15
ARC1: Archival started
Thu May 27 20:14:53 2004
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri May 28 03:33:14 2004
Thread 1 advanced to log sequence 150
Current log# 2 seq# 150 mem# 0: /home/oracle/oradata/mes/redo02.log
Fri May 28 03:33:14 2004
ARC0: Evaluating archive log 1 thread 1 sequence 149
ARC0: Beginning to archive log 1 thread 1 sequence 149
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_149.dbf'
ARC0: Completed archiving log 1 thread 1 sequence 149
Sat May 29 08:58:06 2004
Thread 1 advanced to log sequence 151
Current log# 3 seq# 151 mem# 0: /home/oracle/oradata/mes/redo03.log
Sat May 29 08:58:06 2004
ARC1: Evaluating archive log 2 thread 1 sequence 150
ARC1: Beginning to archive log 2 thread 1 sequence 150
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_150.dbf'
ARC1: Completed archiving log 2 thread 1 sequence 150
Sun May 30 07:28:09 2004
Thread 1 advanced to log sequence 152
Current log# 1 seq# 152 mem# 0: /home/oracle/oradata/mes/redo01.log
Sun May 30 07:28:09 2004
ARC0: Evaluating archive log 3 thread 1 sequence 151
ARC0: Beginning to archive log 3 thread 1 sequence 151
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_151.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 151
Sun May 30 07:32:36 2004
Thread 1 advanced to log sequence 153
Current log# 2 seq# 153 mem# 0: /home/oracle/oradata/mes/redo02.log
Sun May 30 07:32:36 2004
ARC1: Evaluating archive log 1 thread 1 sequence 152
ARC1: Beginning to archive log 1 thread 1 sequence 152
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_152.dbf'
ARC1: Completed archiving log 1 thread 1 sequence 152
Mon May 31 01:24:58 2004
Archive Log Next
Mon May 31 01:25:10 2004
Archive Log All
Mon May 31 02:58:12 2004
Thread 1 advanced to log sequence 154
Current log# 3 seq# 154 mem# 0: /home/oracle/oradata/mes/redo03.log
Mon May 31 02:58:12 2004
ARC0: Evaluating archive log 2 thread 1 sequence 153
ARC0: Beginning to archive log 2 thread 1 sequence 153
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_153.dbf'
ARC0: Completed archiving log 2 thread 1 sequence 153
Mon May 31 18:55:59 2004
alter tablespace qims begin backup
Mon May 31 18:55:59 2004
Completed: alter tablespace qims begin backup
Mon May 31 19:49:24 2004
create tablespace rman datafile '\home\oracle\oracledata\mes\rman.dbf' size 100M
Mon May 31 19:49:29 2004
Completed: create tablespace rman datafile '\home\oracle\orac
Mon May 31 21:30:51 2004
alter tablespace qims end backup
Mon May 31 21:30:51 2004
Completed: alter tablespace qims end backup
Mon May 31 21:58:46 2004
create tablespace rman datafile '/home/oracle/oracedata/rman.dbf' size 50M
Mon May 31 21:58:46 2004
ORA-1543 signalled during: create tablespace rman datafile '/home/oracle/orac...
Mon May 31 21:59:27 2004
/* OracleOEM */ DROP TABLESPACE "RMAN" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
Mon May 31 21:59:28 2004
Deleted file /home/oracle/dbs/homeoracleoracledatamesrman.dbf
Completed: /* OracleOEM */ DROP TABLESPACE "RMAN" INCLUDING C
Mon May 31 21:59:39 2004
create tablespace rman datafile '/home/oracle/oracedata/rman.dbf' size 50M
Mon May 31 21:59:39 2004
ORA-1119 signalled during: create tablespace rman datafile '/home/oracle/orac...
Mon May 31 22:04:08 2004
/* OracleOEM */ CREATE TABLESPACE "RMAN" LOGGING DATAFILE '/home/oracle/oradata/mes/RMAN.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
Mon May 31 22:04:10 2004
Completed: /* OracleOEM */ CREATE TABLESPACE "RMAN" LOGGING D
Tue Jun 1 00:13:23 2004
Thread 1 advanced to log sequence 155
Current log# 1 seq# 155 mem# 0: /home/oracle/oradata/mes/redo01.log
Tue Jun 1 00:13:23 2004
ARC1: Evaluating archive log 3 thread 1 sequence 154
ARC1: Beginning to archive log 3 thread 1 sequence 154
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_154.dbf'
ARC1: Completed archiving log 3 thread 1 sequence 154
Wed Jun 2 04:21:34 2004
Thread 1 advanced to log sequence 156
Current log# 2 seq# 156 mem# 0: /home/oracle/oradata/mes/redo02.log
Wed Jun 2 04:21:34 2004
ARC0: Evaluating archive log 1 thread 1 sequence 155
ARC0: Beginning to archive log 1 thread 1 sequence 155
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_155.dbf'
ARC0: Completed archiving log 1 thread 1 sequence 155
Thu Jun 3 03:32:01 2004
Thread 1 advanced to log sequence 157
Current log# 3 seq# 157 mem# 0: /home/oracle/oradata/mes/redo03.log
Thu Jun 3 03:32:01 2004
ARC1: Evaluating archive log 2 thread 1 sequence 156
ARC1: Beginning to archive log 2 thread 1 sequence 156
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_156.dbf'
ARC1: Completed archiving log 2 thread 1 sequence 156
Thu Jun 3 04:28:20 2004
Thread 1 advanced to log sequence 158
Current log# 1 seq# 158 mem# 0: /home/oracle/oradata/mes/redo01.log
Thu Jun 3 04:28:20 2004
ARC0: Evaluating archive log 3 thread 1 sequence 157
ARC0: Beginning to archive log 3 thread 1 sequence 157
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_157.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 157
Thu Jun 3 04:50:53 2004
Thread 1 advanced to log sequence 159
Current log# 2 seq# 159 mem# 0: /home/oracle/oradata/mes/redo02.log
Thu Jun 3 04:50:53 2004
ARC1: Evaluating archive log 1 thread 1 sequence 158
ARC1: Beginning to archive log 1 thread 1 sequence 158
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_158.dbf'
ARC1: Completed archiving log 1 thread 1 sequence 158
Thu Jun 3 05:34:39 2004
Thread 1 advanced to log sequence 160
Current log# 3 seq# 160 mem# 0: /home/oracle/oradata/mes/redo03.log
Thu Jun 3 05:34:39 2004
ARC0: Evaluating archive log 2 thread 1 sequence 159
ARC0: Beginning to archive log 2 thread 1 sequence 159
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_159.dbf'
ARC0: Completed archiving log 2 thread 1 sequence 159
Thu Jun 3 06:18:52 2004
Thread 1 advanced to log sequence 161
Current log# 1 seq# 161 mem# 0: /home/oracle/oradata/mes/redo01.log
Thu Jun 3 06:18:52 2004
ARC1: Evaluating archive log 3 thread 1 sequence 160
ARC1: Beginning to archive log 3 thread 1 sequence 160
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_160.dbf'
ARC1: Completed archiving log 3 thread 1 sequence 160
Thu Jun 3 18:37:52 2004
Thread 1 advanced to log sequence 162
Current log# 2 seq# 162 mem# 0: /home/oracle/oradata/mes/redo02.log
Thu Jun 3 18:37:52 2004
ARC0: Evaluating archive log 1 thread 1 sequence 161
ARC0: Beginning to archive log 1 thread 1 sequence 161
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_161.dbf'
krcpwnc: following controlfile record written over:
RECID #1 Recno 1 Record timestamp
05/28/04 03:33:17
Thread=1 Seq#=149
Flags:
<produced by archive operation>;
<created by the ARCH process>;
Resetlogs scn and time
scn: 0x0000.000291e9
12/05/03 05:33:49
filename /home/oracle/dbs/arch1_149.dbf
Low
scn: 0x0000.02dda788
05/27/04 19:28:39
Next
scn: 0x0000.02df062c
05/28/04 03:33:14
Block count=204798 Blocksize=512
ARC0: Completed archiving log 1 thread 1 sequence 161
Thu Jun 3 21:46:40 2004
Thread 1 advanced to log sequence 163
Current log# 3 seq# 163 mem# 0: /home/oracle/oradata/mes/redo03.log
Thu Jun 3 21:46:40 2004
ARC1: Evaluating archive log 2 thread 1 sequence 162
ARC1: Beginning to archive log 2 thread 1 sequence 162
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_162.dbf'
kccrsz: expanded controlfile section 11 from 12 to 24 records
requested to grow by 3 record(s); added 1 block(s) of records
ARC1: Completed archiving log 2 thread 1 sequence 162
Thu Jun 3 21:46:43 2004
Thread 1 advanced to log sequence 164
Current log# 1 seq# 164 mem# 0: /home/oracle/oradata/mes/redo01.log
Thu Jun 3 21:46:43 2004
ARC0: Evaluating archive log 3 thread 1 sequence 163
ARC0: Beginning to archive log 3 thread 1 sequence 163
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_163.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 163
Thu Jun 3 21:46:46 2004
Thread 1 advanced to log sequence 165
Current log# 2 seq# 165 mem# 0: /home/oracle/oradata/mes/redo02.log
Thu Jun 3 21:46:46 2004
ARC1: Evaluating archive log 1 thread 1 sequence 164
ARC1: Beginning to archive log 1 thread 1 sequence 164
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_164.dbf'
ARC1: Completed archiving log 1 thread 1 sequence 164
Fri Jun 4 02:09:53 2004
Thread 1 advanced to log sequence 166
Current log# 3 seq# 166 mem# 0: /home/oracle/oradata/mes/redo03.log
Fri Jun 4 02:09:53 2004
ARC0: Evaluating archive log 2 thread 1 sequence 165
ARC0: Beginning to archive log 2 thread 1 sequence 165
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_165.dbf'
ARC0: Completed archiving log 2 thread 1 sequence 165
Fri Jun 4 02:15:56 2004
Thread 1 advanced to log sequence 167
Current log# 1 seq# 167 mem# 0: /home/oracle/oradata/mes/redo01.log
Fri Jun 4 02:15:56 2004
ARC1: Evaluating archive log 3 thread 1 sequence 166
ARC1: Beginning to archive log 3 thread 1 sequence 166
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_166.dbf'
ARC1: Completed archiving log 3 thread 1 sequence 166
Fri Jun 4 02:24:09 2004
Thread 1 advanced to log sequence 168
Current log# 2 seq# 168 mem# 0: /home/oracle/oradata/mes/redo02.log
Fri Jun 4 02:24:09 2004
ARC0: Evaluating archive log 1 thread 1 sequence 167
ARC0: Beginning to archive log 1 thread 1 sequence 167
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_167.dbf'
ARC0: Completed archiving log 1 thread 1 sequence 167
Fri Jun 4 02:32:50 2004
Thread 1 advanced to log sequence 169
Current log# 3 seq# 169 mem# 0: /home/oracle/oradata/mes/redo03.log
Fri Jun 4 02:32:50 2004
ARC1: Evaluating archive log 2 thread 1 sequence 168
ARC1: Beginning to archive log 2 thread 1 sequence 168
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_168.dbf'
ARC1: Completed archiving log 2 thread 1 sequence 168
Fri Jun 4 02:40:34 2004
Thread 1 advanced to log sequence 170
Current log# 1 seq# 170 mem# 0: /home/oracle/oradata/mes/redo01.log
Fri Jun 4 02:40:34 2004
ARC0: Evaluating archive log 3 thread 1 sequence 169
ARC0: Beginning to archive log 3 thread 1 sequence 169
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_169.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 169
Fri Jun 4 02:48:24 2004
Thread 1 advanced to log sequence 171
Fri Jun 4 02:48:24 2004
Current log# 2 seq# 171 mem# 0: /home/oracle/oradata/mes/redo02.log
Fri Jun 4 02:48:24 2004
ARC1: Evaluating archive log 1 thread 1 sequence 170
Fri Jun 4 02:48:24 2004
ARC1: Beginning to archive log 1 thread 1 sequence 170
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_170.dbf'
ARC1: Completed archiving log 1 thread 1 sequence 170
Fri Jun 4 02:55:34 2004
Thread 1 advanced to log sequence 172
Current log# 3 seq# 172 mem# 0: /home/oracle/oradata/mes/redo03.log
Fri Jun 4 02:55:34 2004
ARC0: Evaluating archive log 2 thread 1 sequence 171
ARC0: Beginning to archive log 2 thread 1 sequence 171
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_171.dbf'
ARC0: Completed archiving log 2 thread 1 sequence 171
Fri Jun 4 03:03:00 2004
Thread 1 advanced to log sequence 173
Current log# 1 seq# 173 mem# 0: /home/oracle/oradata/mes/redo01.log
Fri Jun 4 03:03:00 2004
ARC1: Evaluating archive log 3 thread 1 sequence 172
ARC1: Beginning to archive log 3 thread 1 sequence 172
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_172.dbf'
ARC1: Completed archiving log 3 thread 1 sequence 172
Fri Jun 4 03:09:23 2004
Thread 1 advanced to log sequence 174
Current log# 2 seq# 174 mem# 0: /home/oracle/oradata/mes/redo02.log
Fri Jun 4 03:09:23 2004
ARC0: Evaluating archive log 1 thread 1 sequence 173
ARC0: Beginning to archive log 1 thread 1 sequence 173
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_173.dbf'
Fri Jun 4 03:09:36 2004
ARC0: Completed archiving log 1 thread 1 sequence 173
Fri Jun 4 03:17:29 2004
Thread 1 advanced to log sequence 175
Current log# 3 seq# 175 mem# 0: /home/oracle/oradata/mes/redo03.log
Fri Jun 4 03:17:29 2004
ARC1: Evaluating archive log 2 thread 1 sequence 174
ARC1: Beginning to archive log 2 thread 1 sequence 174
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_174.dbf'
kccrsz: expanded controlfile section 11 from 24 to 37 records
requested to grow by 5 record(s); added 1 block(s) of records
ARC1: Completed archiving log 2 thread 1 sequence 174
Fri Jun 4 03:23:35 2004
Thread 1 advanced to log sequence 176
Current log# 1 seq# 176 mem# 0: /home/oracle/oradata/mes/redo01.log
Fri Jun 4 03:23:35 2004
ARC0: Evaluating archive log 3 thread 1 sequence 175
ARC0: Beginning to archive log 3 thread 1 sequence 175
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_175.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 175
Fri Jun 4 03:29:59 2004
Thread 1 advanced to log sequence 177
Current log# 2 seq# 177 mem# 0: /home/oracle/oradata/mes/redo02.log
Fri Jun 4 03:29:59 2004
ARC1: Evaluating archive log 1 thread 1 sequence 176
ARC1: Beginning to archive log 1 thread 1 sequence 176
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_176.dbf'
ARC1: Completed archiving log 1 thread 1 sequence 176
Fri Jun 4 04:00:29 2004
Thread 1 advanced to log sequence 178
Current log# 3 seq# 178 mem# 0: /home/oracle/oradata/mes/redo03.log
Fri Jun 4 04:00:29 2004
ARC0: Evaluating archive log 2 thread 1 sequence 177
ARC0: Beginning to archive log 2 thread 1 sequence 177
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_177.dbf'
ARC0: Completed archiving log 2 thread 1 sequence 177
Fri Jun 4 05:10:57 2004
Thread 1 advanced to log sequence 179
Current log# 1 seq# 179 mem# 0: /home/oracle/oradata/mes/redo01.log
Fri Jun 4 05:10:57 2004
ARC1: Evaluating archive log 3 thread 1 sequence 178
ARC1: Beginning to archive log 3 thread 1 sequence 178
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_178.dbf'
ARC1: Completed archiving log 3 thread 1 sequence 178
Fri Jun 4 05:18:08 2004
Thread 1 advanced to log sequence 180
Current log# 2 seq# 180 mem# 0: /home/oracle/oradata/mes/redo02.log
Fri Jun 4 05:18:08 2004
ARC0: Evaluating archive log 1 thread 1 sequence 179
ARC0: Beginning to archive log 1 thread 1 sequence 179
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_179.dbf'
ARC0: Completed archiving log 1 thread 1 sequence 179
Fri Jun 4 05:21:51 2004
Thread 1 advanced to log sequence 181
Current log# 3 seq# 181 mem# 0: /home/oracle/oradata/mes/redo03.log
Fri Jun 4 05:21:51 2004
ARC1: Evaluating archive log 2 thread 1 sequence 180
ARC1: Beginning to archive log 2 thread 1 sequence 180
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_180.dbf'
Fri Jun 4 05:22:02 2004
ARC1: Completed archiving log 2 thread 1 sequence 180
Fri Jun 4 05:22:08 2004
Thread 1 advanced to log sequence 182
Current log# 1 seq# 182 mem# 0: /home/oracle/oradata/mes/redo01.log
Fri Jun 4 05:22:08 2004
ARC0: Evaluating archive log 3 thread 1 sequence 181
ARC0: Beginning to archive log 3 thread 1 sequence 181
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_181.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 181
Fri Jun 4 05:29:48 2004
Shutting down instance: further logons disabled
Fri Jun 4 05:30:01 2004
Shutting down instance (immediate)
License high water mark = 15
Fri Jun 4 05:30:06 2004
Thread 1 advanced to log sequence 183
Current log# 2 seq# 183 mem# 0: /home/oracle/oradata/mes/redo02.log
Fri Jun 4 05:30:06 2004
ARC1: Evaluating archive log 1 thread 1 sequence 182
ARC1: Beginning to archive log 1 thread 1 sequence 182
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_182.dbf'
Fri Jun 4 19:55:02 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
timed_os_statistics = 0
resource_limit = FALSE
license_max_sessions = 0
license_sessions_warning = 0
shared_pool_size = 50331648
large_pool_size = 16777216
java_pool_size = 117440512
trace_enabled = TRUE
nls_length_semantics = BYTE
nls_nchar_conv_excp = FALSE
file_mapping = FALSE
control_files = /home/oracle/oradata/mes/control01.ctl, /home/oracle/oradata/mes/control02.ctl, /home/oracle/oradata/mes/control03.ctl
db_block_checksum = TRUE
db_block_size = 4096
db_cache_size = 33554432
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_dest_state_4 = ENABLE
log_archive_dest_state_5 = ENABLE
log_archive_dest_state_6 = ENABLE
log_archive_dest_state_7 = ENABLE
log_archive_dest_state_8 = ENABLE
log_archive_dest_state_9 = ENABLE
log_archive_dest_state_10= ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
log_archive_trace = 0
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
archive_lag_target = 0
db_file_multiblock_read_count= 16
standby_file_management = MANUAL
fast_start_io_target = 0
fast_start_mttr_target = 300
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 7
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = FALSE
undo_retention = 10800
fast_start_parallel_rollback= LOW
db_block_checking = FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 0
db_domain =
global_names = FALSE
instance_name = mes
service_names = MES
dispatchers = (PROTOCOL=TCP) (SERVICE=mesXDB), (PROTOCOL=TCP)
shared_servers = 1
mts_servers = 1
remote_dependencies_mode = TIMESTAMP
plsql_v2_compatibility = FALSE
plsql_compiler_flags = INTERPRETED
plsql_native_library_subdir_count= 0
job_queue_processes = 10
cursor_sharing = EXACT
hash_join_enabled = FALSE
background_dump_dest = /home/oracle/admin/mes/bdump
user_dump_dest = /home/oracle/admin/mes/udump
max_dump_file_size = UNLIMITED
core_dump_dest = /home/oracle/admin/mes/cdump
oracle_trace_enable = FALSE
sort_area_size = 52428800
db_name = mes
open_cursors = 300
star_transformation_enabled= FALSE
parallel_adaptive_multi_user= FALSE
parallel_threads_per_cpu = 2
query_rewrite_enabled = FALSE
query_rewrite_integrity = ENFORCED
pga_aggregate_target = 25165824
workarea_size_policy = AUTO
optimizer_dynamic_sampling= 1
statistics_level = TYPICAL
aq_tm_processes = 1
hs_autoregister = TRUE
dg_broker_start = FALSE
drs_start = FALSE
Deprecated system parameters with specified values:
fast_start_io_target
mts_servers
drs_start
End of deprecated system parameter listing
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Jun 4 19:55:04 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jun 4 19:55:07 2004
ALTER DATABASE MOUNT
Fri Jun 4 19:55:12 2004
Successful mount of redo thread 1, with mount id 1611582427.
Fri Jun 4 19:55:12 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jun 4 19:55:12 2004
ALTER DATABASE OPEN
Fri Jun 4 19:55:12 2004
Beginning crash recovery of 1 threads
Fri Jun 4 19:55:12 2004
Started first pass scan
Fri Jun 4 19:55:13 2004
Completed first pass scan
45029 redo blocks read, 3485 data blocks need recovery
Fri Jun 4 19:55:13 2004
Started recovery at
Thread 1: logseq 182, block 187920, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 182 Reading mem 0
Mem# 0 errs 0: /home/oracle/oradata/mes/redo01.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 183 Reading mem 0
Mem# 0 errs 0: /home/oracle/oradata/mes/redo02.log
Fri Jun 4 19:55:20 2004
Ended recovery at
Thread 1: logseq 183, block 28152, scn 0.50248882
3485 data blocks read, 34 data blocks written, 45029 redo blocks read
Crash recovery completed successfully
Fri Jun 4 19:55:20 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 184
Thread 1 opened at log sequence 184
Current log# 3 seq# 184 mem# 0: /home/oracle/oradata/mes/redo03.log
Successful open of redo thread 1.
Fri Jun 4 19:55:20 2004
SMON: enabling cache recovery
Fri Jun 4 19:55:22 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Jun 4 19:55:22 2004
SMON: enabling tx recovery
Fri Jun 4 19:55:22 2004
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Fri Jun 4 19:55:38 2004
SMON: Parallel transaction recovery tried
Sat Jun 5 09:25:33 2004
Errors in file /home/oracle/admin/mes/bdump/mes_s000_26852.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Sat Jun 5 09:25:41 2004
Errors in file /home/oracle/admin/mes/bdump/mes_s001_33736.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Sat Jun 5 09:25:54 2004
found dead shared server 'S000', pid = (10, 1)
found dead shared server 'S001', pid = (15, 51)
Sat Jun 5 15:06:34 2004
ORACLE Instance mes - Can not allocate log, archival required
Sat Jun 5 15:06:34 2004
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 185
All online logs needed archiving
Current log# 3 seq# 184 mem# 0: /home/oracle/oradata/mes/redo03.log
Sun Jun 6 19:27:06 2004
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 11
Sun Jun 6 19:44:00 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
timed_os_statistics = 0
resource_limit = FALSE
license_max_sessions = 0
license_sessions_warning = 0
shared_pool_size = 50331648
large_pool_size = 16777216
java_pool_size = 117440512
trace_enabled = TRUE
nls_length_semantics = BYTE
nls_nchar_conv_excp = FALSE
file_mapping = FALSE
control_files = /home/oracle/oradata/mes/control01.ctl, /home/oracle/oradata/mes/control02.ctl, /home/oracle/oradata/mes/control03.ctl
db_block_checksum = TRUE
db_block_size = 4096
db_cache_size = 33554432
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_dest_state_4 = ENABLE
log_archive_dest_state_5 = ENABLE
log_archive_dest_state_6 = ENABLE
log_archive_dest_state_7 = ENABLE
log_archive_dest_state_8 = ENABLE
log_archive_dest_state_9 = ENABLE
log_archive_dest_state_10= ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
log_archive_trace = 0
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
archive_lag_target = 0
db_file_multiblock_read_count= 16
standby_file_management = MANUAL
fast_start_io_target = 0
fast_start_mttr_target = 300
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 7
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = FALSE
undo_retention = 10800
fast_start_parallel_rollback= LOW
db_block_checking = FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 0
db_domain =
global_names = FALSE
instance_name = mes
service_names = MES
dispatchers = (PROTOCOL=TCP) (SERVICE=mesXDB), (PROTOCOL=TCP)
shared_servers = 1
mts_servers = 1
remote_dependencies_mode = TIMESTAMP
plsql_v2_compatibility = FALSE
plsql_compiler_flags = INTERPRETED
plsql_native_library_subdir_count= 0
job_queue_processes = 10
cursor_sharing = EXACT
hash_join_enabled = FALSE
background_dump_dest = /home/oracle/admin/mes/bdump
user_dump_dest = /home/oracle/admin/mes/udump
max_dump_file_size = UNLIMITED
core_dump_dest = /home/oracle/admin/mes/cdump
oracle_trace_enable = FALSE
sort_area_size = 52428800
db_name = mes
open_cursors = 300
star_transformation_enabled= FALSE
parallel_adaptive_multi_user= FALSE
parallel_threads_per_cpu = 2
query_rewrite_enabled = FALSE
query_rewrite_integrity = ENFORCED
pga_aggregate_target = 25165824
workarea_size_policy = AUTO
optimizer_dynamic_sampling= 1
statistics_level = TYPICAL
aq_tm_processes = 1
hs_autoregister = TRUE
dg_broker_start = FALSE
drs_start = FALSE
Deprecated system parameters with specified values:
fast_start_io_target
mts_servers
drs_start
End of deprecated system parameter listing
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sun Jun 6 19:44:03 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Jun 6 19:44:04 2004
ALTER DATABASE MOUNT
Sun Jun 6 19:44:09 2004
Successful mount of redo thread 1, with mount id 1611733316.
Sun Jun 6 19:44:09 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Jun 6 19:44:09 2004
ALTER DATABASE OPEN
Sun Jun 6 19:44:10 2004
Beginning crash recovery of 1 threads
Sun Jun 6 19:44:10 2004
Started first pass scan
Sun Jun 6 19:44:10 2004
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Sun Jun 6 19:44:10 2004
Started recovery at
Thread 1: logseq 184, block 204799, scn 0.50428689
Recovery of Online Redo Log: Thread 1 Group 3 Seq 184 Reading mem 0
Mem# 0 errs 0: /home/oracle/oradata/mes/redo03.log
Sun Jun 6 19:44:10 2004
Ended recovery at
Thread 1: logseq 184, block 204799, scn 0.50448690
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sun Jun 6 19:44:10 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Sun Jun 6 19:44:10 2004
ARCH: Evaluating archive log 1 thread 1 sequence 182
ARCH: Beginning to archive log 1 thread 1 sequence 182
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_182.dbf'
ARCH: Completed archiving log 1 thread 1 sequence 182
Sun Jun 6 19:44:20 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 185
Thread 1 opened at log sequence 185
Current log# 1 seq# 185 mem# 0: /home/oracle/oradata/mes/redo01.log
Successful open of redo thread 1.
Sun Jun 6 19:44:20 2004
SMON: enabling cache recovery
Sun Jun 6 19:44:22 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Sun Jun 6 19:44:22 2004
SMON: enabling tx recovery
Sun Jun 6 19:44:22 2004
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Sun Jun 6 19:50:20 2004
ORACLE Instance mes - Can not allocate log, archival required
Sun Jun 6 19:50:20 2004
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 186
All online logs needed archiving
Current log# 1 seq# 185 mem# 0: /home/oracle/oradata/mes/redo01.log
Sun Jun 6 20:53:19 2004
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 22
Sun Jun 6 21:50:25 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
timed_os_statistics = 0
resource_limit = FALSE
license_max_sessions = 0
license_sessions_warning = 0
shared_pool_size = 50331648
large_pool_size = 16777216
java_pool_size = 117440512
trace_enabled = TRUE
nls_length_semantics = BYTE
nls_nchar_conv_excp = FALSE
file_mapping = FALSE
control_files = /home/oracle/oradata/mes/control01.ctl, /home/oracle/oradata/mes/control02.ctl, /home/oracle/oradata/mes/control03.ctl
db_block_checksum = TRUE
db_block_size = 4096
db_cache_size = 33554432
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_dest_state_4 = ENABLE
log_archive_dest_state_5 = ENABLE
log_archive_dest_state_6 = ENABLE
log_archive_dest_state_7 = ENABLE
log_archive_dest_state_8 = ENABLE
log_archive_dest_state_9 = ENABLE
log_archive_dest_state_10= ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
log_archive_trace = 0
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
archive_lag_target = 0
db_file_multiblock_read_count= 16
standby_file_management = MANUAL
fast_start_io_target = 0
fast_start_mttr_target = 300
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 7
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = FALSE
undo_retention = 10800
fast_start_parallel_rollback= LOW
db_block_checking = FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 0
db_domain =
global_names = FALSE
instance_name = mes
service_names = MES
dispatchers = (PROTOCOL=TCP) (SERVICE=mesXDB), (PROTOCOL=TCP)
shared_servers = 1
mts_servers = 1
remote_dependencies_mode = TIMESTAMP
plsql_v2_compatibility = FALSE
plsql_compiler_flags = INTERPRETED
plsql_native_library_subdir_count= 0
job_queue_processes = 10
cursor_sharing = EXACT
hash_join_enabled = FALSE
background_dump_dest = /home/oracle/admin/mes/bdump
user_dump_dest = /home/oracle/admin/mes/udump
max_dump_file_size = UNLIMITED
core_dump_dest = /home/oracle/admin/mes/cdump
oracle_trace_enable = FALSE
sort_area_size = 52428800
db_name = mes
open_cursors = 300
star_transformation_enabled= FALSE
parallel_adaptive_multi_user= FALSE
parallel_threads_per_cpu = 2
query_rewrite_enabled = FALSE
query_rewrite_integrity = ENFORCED
pga_aggregate_target = 25165824
workarea_size_policy = AUTO
optimizer_dynamic_sampling= 1
statistics_level = TYPICAL
aq_tm_processes = 1
hs_autoregister = TRUE
dg_broker_start = FALSE
drs_start = FALSE
Deprecated system parameters with specified values:
fast_start_io_target
mts_servers
drs_start
End of deprecated system parameter listing
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sun Jun 6 21:50:27 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Jun 6 21:50:29 2004
ALTER DATABASE MOUNT
Sun Jun 6 21:50:33 2004
Successful mount of redo thread 1, with mount id 1611783653.
Sun Jun 6 21:50:33 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sun Jun 6 21:50:34 2004
ALTER DATABASE OPEN
Sun Jun 6 21:50:34 2004
Beginning crash recovery of 1 threads
Sun Jun 6 21:50:34 2004
Started first pass scan
Sun Jun 6 21:50:34 2004
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Sun Jun 6 21:50:34 2004
Started recovery at
Thread 1: logseq 185, block 204799, scn 0.50454825
Recovery of Online Redo Log: Thread 1 Group 1 Seq 185 Reading mem 0
Mem# 0 errs 0: /home/oracle/oradata/mes/redo01.log
Sun Jun 6 21:50:34 2004
Ended recovery at
Thread 1: logseq 185, block 204799, scn 0.50474826
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Sun Jun 6 21:50:34 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Sun Jun 6 21:50:35 2004
ARCH: Evaluating archive log 2 thread 1 sequence 183
ARCH: Beginning to archive log 2 thread 1 sequence 183
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_183.dbf'
ARCH: Completed archiving log 2 thread 1 sequence 183
Sun Jun 6 21:50:36 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 186
Thread 1 opened at log sequence 186
Current log# 2 seq# 186 mem# 0: /home/oracle/oradata/mes/redo02.log
Successful open of redo thread 1.
Sun Jun 6 21:50:37 2004
SMON: enabling cache recovery
Sun Jun 6 21:50:38 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Sun Jun 6 21:50:38 2004
SMON: enabling tx recovery
Sun Jun 6 21:50:38 2004
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Sun Jun 6 21:52:09 2004
SMON: Parallel transaction recovery tried
Mon Jun 7 04:33:39 2004
ORACLE Instance mes - Can not allocate log, archival required
Mon Jun 7 04:33:39 2004
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 187
All online logs needed archiving
Current log# 2 seq# 186 mem# 0: /home/oracle/oradata/mes/redo02.log
Mon Jun 7 04:42:15 2004
Shutting down instance: further logons disabled
Mon Jun 7 04:42:32 2004
Shutting down instance (immediate)
License high water mark = 18
All dispatchers and shared servers shutdown
Mon Jun 7 04:57:39 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
timed_os_statistics = 0
resource_limit = FALSE
license_max_sessions = 0
license_sessions_warning = 0
shared_pool_size = 50331648
large_pool_size = 16777216
java_pool_size = 117440512
trace_enabled = TRUE
nls_length_semantics = BYTE
nls_nchar_conv_excp = FALSE
file_mapping = FALSE
control_files = /home/oracle/oradata/mes/control01.ctl, /home/oracle/oradata/mes/control02.ctl, /home/oracle/oradata/mes/control03.ctl
db_block_checksum = TRUE
db_block_size = 4096
db_cache_size = 33554432
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_dest_state_4 = ENABLE
log_archive_dest_state_5 = ENABLE
log_archive_dest_state_6 = ENABLE
log_archive_dest_state_7 = ENABLE
log_archive_dest_state_8 = ENABLE
log_archive_dest_state_9 = ENABLE
log_archive_dest_state_10= ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
log_archive_trace = 0
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
archive_lag_target = 0
db_file_multiblock_read_count= 16
standby_file_management = MANUAL
fast_start_io_target = 0
fast_start_mttr_target = 300
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 7
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = FALSE
undo_retention = 10800
fast_start_parallel_rollback= LOW
db_block_checking = FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 0
db_domain =
global_names = FALSE
instance_name = mes
service_names = MES
dispatchers = (PROTOCOL=TCP) (SERVICE=mesXDB), (PROTOCOL=TCP)
shared_servers = 1
mts_servers = 1
remote_dependencies_mode = TIMESTAMP
plsql_v2_compatibility = FALSE
plsql_compiler_flags = INTERPRETED
plsql_native_library_subdir_count= 0
job_queue_processes = 10
cursor_sharing = EXACT
hash_join_enabled = FALSE
background_dump_dest = /home/oracle/admin/mes/bdump
user_dump_dest = /home/oracle/admin/mes/udump
max_dump_file_size = UNLIMITED
core_dump_dest = /home/oracle/admin/mes/cdump
oracle_trace_enable = FALSE
sort_area_size = 52428800
db_name = mes
open_cursors = 300
star_transformation_enabled= FALSE
parallel_adaptive_multi_user= FALSE
parallel_threads_per_cpu = 2
query_rewrite_enabled = FALSE
query_rewrite_integrity = ENFORCED
pga_aggregate_target = 25165824
workarea_size_policy = AUTO
optimizer_dynamic_sampling= 1
statistics_level = TYPICAL
aq_tm_processes = 1
hs_autoregister = TRUE
dg_broker_start = FALSE
drs_start = FALSE
Deprecated system parameters with specified values:
fast_start_io_target
mts_servers
drs_start
End of deprecated system parameter listing
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Mon Jun 7 04:57:42 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jun 7 04:57:43 2004
ALTER DATABASE MOUNT
Mon Jun 7 04:57:48 2004
Successful mount of redo thread 1, with mount id 1611742471.
Mon Jun 7 04:57:48 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Jun 7 04:57:48 2004
ALTER DATABASE OPEN
Mon Jun 7 04:57:49 2004
Beginning crash recovery of 1 threads
Mon Jun 7 04:57:49 2004
Started first pass scan
Mon Jun 7 04:57:49 2004
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Mon Jun 7 04:57:49 2004
Started recovery at
Thread 1: logseq 186, block 204799, scn 0.50538660
Recovery of Online Redo Log: Thread 1 Group 2 Seq 186 Reading mem 0
Mem# 0 errs 0: /home/oracle/oradata/mes/redo02.log
Mon Jun 7 04:57:49 2004
Ended recovery at
Thread 1: logseq 186, block 204799, scn 0.50558661
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Jun 7 04:57:49 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Mon Jun 7 04:57:49 2004
ARCH: Evaluating archive log 3 thread 1 sequence 184
ARCH: Beginning to archive log 3 thread 1 sequence 184
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_184.dbf'
ARCH: Completed archiving log 3 thread 1 sequence 184
Mon Jun 7 04:57:59 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 187
Thread 1 opened at log sequence 187
Current log# 3 seq# 187 mem# 0: /home/oracle/oradata/mes/redo03.log
Successful open of redo thread 1.
Mon Jun 7 04:58:00 2004
SMON: enabling cache recovery
Mon Jun 7 04:58:01 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon Jun 7 04:58:01 2004
SMON: enabling tx recovery
Mon Jun 7 04:58:01 2004
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Mon Jun 7 04:58:06 2004
SMON: Parallel transaction recovery tried
Mon Jun 7 05:40:32 2004
ARCH: Possible network disconnect with primary database
Mon Jun 7 11:21:48 2004
ORACLE Instance mes - Can not allocate log, archival required
Mon Jun 7 11:21:48 2004
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 188
All online logs needed archiving
Current log# 3 seq# 187 mem# 0: /home/oracle/oradata/mes/redo03.log
Mon Jun 7 18:52:39 2004
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 13
Mon Jun 7 19:17:07 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
timed_os_statistics = 0
resource_limit = FALSE
license_max_sessions = 0
license_sessions_warning = 0
shared_pool_size = 50331648
large_pool_size = 16777216
java_pool_size = 117440512
trace_enabled = TRUE
nls_length_semantics = BYTE
nls_nchar_conv_excp = FALSE
file_mapping = FALSE
control_files = /home/oracle/oradata/mes/control01.ctl, /home/oracle/oradata/mes/control02.ctl, /home/oracle/oradata/mes/control03.ctl
db_block_checksum = TRUE
db_block_size = 4096
db_cache_size = 33554432
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_dest_state_4 = ENABLE
log_archive_dest_state_5 = ENABLE
log_archive_dest_state_6 = ENABLE
log_archive_dest_state_7 = ENABLE
log_archive_dest_state_8 = ENABLE
log_archive_dest_state_9 = ENABLE
log_archive_dest_state_10= ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
log_archive_trace = 0
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
archive_lag_target = 0
db_file_multiblock_read_count= 16
standby_file_management = MANUAL
fast_start_io_target = 0
fast_start_mttr_target = 300
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 7
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = FALSE
undo_retention = 10800
fast_start_parallel_rollback= LOW
db_block_checking = FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 0
db_domain =
global_names = FALSE
instance_name = mes
service_names = MES
dispatchers = (PROTOCOL=TCP) (SERVICE=mesXDB), (PROTOCOL=TCP)
shared_servers = 1
mts_servers = 1
remote_dependencies_mode = TIMESTAMP
plsql_v2_compatibility = FALSE
plsql_compiler_flags = INTERPRETED
plsql_native_library_subdir_count= 0
job_queue_processes = 10
cursor_sharing = EXACT
hash_join_enabled = FALSE
background_dump_dest = /home/oracle/admin/mes/bdump
user_dump_dest = /home/oracle/admin/mes/udump
max_dump_file_size = UNLIMITED
core_dump_dest = /home/oracle/admin/mes/cdump
oracle_trace_enable = FALSE
sort_area_size = 52428800
db_name = mes
open_cursors = 300
star_transformation_enabled= FALSE
parallel_adaptive_multi_user= FALSE
parallel_threads_per_cpu = 2
query_rewrite_enabled = FALSE
query_rewrite_integrity = ENFORCED
pga_aggregate_target = 25165824
workarea_size_policy = AUTO
optimizer_dynamic_sampling= 1
statistics_level = TYPICAL
aq_tm_processes = 1
hs_autoregister = TRUE
dg_broker_start = FALSE
drs_start = FALSE
Deprecated system parameters with specified values:
fast_start_io_target
mts_servers
drs_start
End of deprecated system parameter listing
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Mon Jun 7 19:17:09 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jun 7 19:17:11 2004
ALTER DATABASE MOUNT
Mon Jun 7 19:17:16 2004
Successful mount of redo thread 1, with mount id 1611852663.
Mon Jun 7 19:17:16 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Jun 7 19:17:16 2004
ALTER DATABASE OPEN
Mon Jun 7 19:17:16 2004
Beginning crash recovery of 1 threads
Mon Jun 7 19:17:16 2004
Started first pass scan
Mon Jun 7 19:17:16 2004
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Mon Jun 7 19:17:16 2004
Started recovery at
Thread 1: logseq 187, block 204799, scn 0.50633187
Recovery of Online Redo Log: Thread 1 Group 3 Seq 187 Reading mem 0
Mem# 0 errs 0: /home/oracle/oradata/mes/redo03.log
Mon Jun 7 19:17:16 2004
Ended recovery at
Thread 1: logseq 187, block 204799, scn 0.50653188
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Jun 7 19:17:17 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Mon Jun 7 19:17:17 2004
ARCH: Evaluating archive log 1 thread 1 sequence 185
ARCH: Beginning to archive log 1 thread 1 sequence 185
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_185.dbf'
ARCH: Completed archiving log 1 thread 1 sequence 185
Mon Jun 7 19:17:27 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 188
Thread 1 opened at log sequence 188
Current log# 1 seq# 188 mem# 0: /home/oracle/oradata/mes/redo01.log
Successful open of redo thread 1.
Mon Jun 7 19:17:27 2004
SMON: enabling cache recovery
Mon Jun 7 19:17:29 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon Jun 7 19:17:29 2004
SMON: enabling tx recovery
Mon Jun 7 19:17:29 2004
Database Characterset is ZHS16GBK
Mon Jun 7 19:17:29 2004
SMON: Parallel transaction recovery tried
Mon Jun 7 19:17:33 2004
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Mon Jun 7 20:36:17 2004
CKPT: Begin resize of buffer pool 3 (DEFAULT for block size 4096)
CKPT: Current size = 32 MB, Target size = 160 MB
CKPT: Could not allocate memory for buffer pool DEFAULT,
blocksize 4096
CKPT: Begin resize of buffer pool 3 (DEFAULT for block size 4096)
CKPT: Current size = 32 MB, Target size = 160 MB
CKPT: Could not allocate memory for buffer pool DEFAULT,
blocksize 4096
Mon Jun 7 20:49:37 2004
ARCH: Possible network disconnect with primary database
Mon Jun 7 21:36:11 2004
/* OracleOEM */ ALTER ROLLBACK SEGMENT "SYSTEM" STORAGE ( MAXEXTENTS UNLIMITED)
Mon Jun 7 21:36:11 2004
ORA-30019 signalled during: /* OracleOEM */ ALTER ROLLBACK SEGMENT "SYSTEM" ST...
Mon Jun 7 21:36:38 2004
/* OracleOEM */ ALTER ROLLBACK SEGMENT "SYSTEM" STORAGE ( MAXEXTENTS UNLIMITED)
Mon Jun 7 21:36:38 2004
ORA-30019 signalled during: /* OracleOEM */ ALTER ROLLBACK SEGMENT "SYSTEM" ST...
Mon Jun 7 21:37:53 2004
/* OracleOEM */ ALTER DATABASE ADD LOGFILE GROUP 4 ('/home/oracle/oradata/mes/logMES4.ora') SIZE 102400K
Mon Jun 7 21:37:57 2004
Completed: /* OracleOEM */ ALTER DATABASE ADD LOGFILE GROUP 4
Mon Jun 7 21:45:19 2004
ALTER ROLLBACK SEGMENT SYSTEM
STORAGE (
MAXEXTENTS UNLIMITED)
Mon Jun 7 21:45:19 2004
ORA-30019 signalled during: ALTER ROLLBACK SEGMENT SYSTEM
STORAGE (
MAXEXT...
Tue Jun 8 01:42:17 2004
create tablespace rmants datafile '/home/oradata/mes/rmants.dbf' size 50M
Tue Jun 8 01:42:17 2004
ORA-1119 signalled during: create tablespace rmants datafile '/home/oradata/m...
Tue Jun 8 01:44:03 2004
CREATE TABLESPACE rmants
DATAFILE
'/home/oradata/mes/rmants.dbf' SIZE 50 M
LOGGING
DEFAULT NOCOMPRESS
ONLINE
PERMANENT
EXTENT MANAGEMENT DICTIONARY
Tue Jun 8 01:44:03 2004
ORA-12913 signalled during: CREATE TABLESPACE rmants
DATAFILE
'/home/oradata...
Tue Jun 8 01:45:12 2004
/* OracleOEM */ DROP TABLESPACE "RMAN" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
Tue Jun 8 01:45:12 2004
Deleted file /home/oracle/oradata/mes/RMAN.dbf
Completed: /* OracleOEM */ DROP TABLESPACE "RMAN" INCLUDING C
Tue Jun 8 01:46:08 2004
create tablespace rmants datafile '/home/oracle/oradata/mes/rmants.dbf' size 50M
Tue Jun 8 01:46:10 2004
Completed: create tablespace rmants datafile '/home/oracle/or
Tue Jun 8 04:12:57 2004
Errors in file /home/oracle/admin/mes/udump/mes_ora_3232.trc:
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 4
Tue Jun 8 07:03:26 2004
Thread 1 advanced to log sequence 189
Current log# 4 seq# 189 mem# 0: /home/oracle/oradata/mes/logMES4.ora
Tue Jun 8 09:32:45 2004
ORACLE Instance mes - Can not allocate log, archival required
Tue Jun 8 09:32:45 2004
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 190
All online logs needed archiving
Current log# 4 seq# 189 mem# 0: /home/oracle/oradata/mes/logMES4.ora
Tue Jun 8 10:51:05 2004
Shutting down instance (abort)
License high water mark = 19
Tue Jun 8 10:51:25 2004
Instance terminated by USER, pid = 16296
Tue Jun 8 11:11:24 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
timed_os_statistics = 0
resource_limit = FALSE
license_max_sessions = 0
license_sessions_warning = 0
shared_pool_size = 50331648
large_pool_size = 16777216
java_pool_size = 117440512
trace_enabled = TRUE
nls_length_semantics = BYTE
nls_nchar_conv_excp = FALSE
file_mapping = FALSE
control_files = /home/oracle/oradata/mes/control01.ctl, /home/oracle/oradata/mes/control02.ctl, /home/oracle/oradata/mes/control03.ctl
db_block_checksum = TRUE
db_block_size = 4096
db_cache_size = 33554432
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_dest_state_4 = ENABLE
log_archive_dest_state_5 = ENABLE
log_archive_dest_state_6 = ENABLE
log_archive_dest_state_7 = ENABLE
log_archive_dest_state_8 = ENABLE
log_archive_dest_state_9 = ENABLE
log_archive_dest_state_10= ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
log_archive_trace = 0
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
archive_lag_target = 0
db_file_multiblock_read_count= 16
standby_file_management = MANUAL
fast_start_io_target = 0
fast_start_mttr_target = 300
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 7
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = FALSE
undo_retention = 10800
fast_start_parallel_rollback= LOW
db_block_checking = FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 0
db_domain =
global_names = FALSE
instance_name = mes
service_names = MES
dispatchers = (PROTOCOL=TCP) (SERVICE=mesXDB), (PROTOCOL=TCP)
shared_servers = 1
mts_servers = 1
remote_dependencies_mode = TIMESTAMP
plsql_v2_compatibility = FALSE
plsql_compiler_flags = INTERPRETED
plsql_native_library_subdir_count= 0
job_queue_processes = 10
cursor_sharing = EXACT
hash_join_enabled = FALSE
background_dump_dest = /home/oracle/admin/mes/bdump
user_dump_dest = /home/oracle/admin/mes/udump
max_dump_file_size = UNLIMITED
core_dump_dest = /home/oracle/admin/mes/cdump
oracle_trace_enable = FALSE
sort_area_size = 52428800
db_name = mes
open_cursors = 300
star_transformation_enabled= FALSE
parallel_adaptive_multi_user= FALSE
parallel_threads_per_cpu = 2
query_rewrite_enabled = FALSE
query_rewrite_integrity = ENFORCED
pga_aggregate_target = 25165824
workarea_size_policy = AUTO
optimizer_dynamic_sampling= 1
statistics_level = TYPICAL
aq_tm_processes = 1
hs_autoregister = TRUE
dg_broker_start = FALSE
drs_start = FALSE
Deprecated system parameters with specified values:
fast_start_io_target
mts_servers
drs_start
End of deprecated system parameter listing
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Jun 8 11:11:26 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jun 8 11:11:28 2004
ALTER DATABASE MOUNT
Tue Jun 8 11:11:33 2004
Successful mount of redo thread 1, with mount id 1611924000.
Tue Jun 8 11:11:33 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Jun 8 11:11:33 2004
ALTER DATABASE OPEN
Tue Jun 8 11:11:33 2004
Beginning crash recovery of 1 threads
Tue Jun 8 11:11:33 2004
Started first pass scan
Tue Jun 8 11:11:34 2004
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Tue Jun 8 11:11:34 2004
Started recovery at
Thread 1: logseq 189, block 204799, scn 0.50828401
Recovery of Online Redo Log: Thread 1 Group 4 Seq 189 Reading mem 0
Mem# 0 errs 0: /home/oracle/oradata/mes/logMES4.ora
Tue Jun 8 11:11:34 2004
Ended recovery at
Thread 1: logseq 189, block 204799, scn 0.50848402
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Tue Jun 8 11:11:34 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Tue Jun 8 11:11:34 2004
ARCH: Evaluating archive log 2 thread 1 sequence 186
ARCH: Beginning to archive log 2 thread 1 sequence 186
Creating archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/dbs/arch1_186.dbf'
ARCH: Completed archiving log 2 thread 1 sequence 186
Tue Jun 8 11:11:44 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 190
Thread 1 opened at log sequence 190
Current log# 2 seq# 190 mem# 0: /home/oracle/oradata/mes/redo02.log
Successful open of redo thread 1.
Tue Jun 8 11:11:44 2004
SMON: enabling cache recovery
Tue Jun 8 11:11:46 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jun 8 11:11:46 2004
SMON: enabling tx recovery
Tue Jun 8 11:11:46 2004
Database Characterset is ZHS16GBK
Tue Jun 8 11:11:47 2004
SMON: Parallel transaction recovery tried
Tue Jun 8 11:11:48 2004
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Tue Jun 8 15:05:36 2004
ORACLE Instance mes - Can not allocate log, archival required
Tue Jun 8 15:05:36 2004
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 191
All online logs needed archiving
Current log# 2 seq# 190 mem# 0: /home/oracle/oradata/mes/redo02.log
Tue Jun 8 19:35:05 2004
Shutting down instance (abort)
License high water mark = 15
Tue Jun 8 19:35:27 2004
Instance terminated by USER, pid = 13190
Tue Jun 8 19:36:49 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
timed_os_statistics = 0
resource_limit = FALSE
license_max_sessions = 0
license_sessions_warning = 0
shared_pool_size = 50331648
large_pool_size = 16777216
java_pool_size = 117440512
trace_enabled = TRUE
nls_length_semantics = BYTE
nls_nchar_conv_excp = FALSE
file_mapping = FALSE
control_files = /home/oracle/oradata/mes/control01.ctl, /home/oracle/oradata/mes/control02.ctl, /home/oracle/oradata/mes/control03.ctl
db_block_checksum = TRUE
db_block_size = 4096
db_cache_size = 33554432
db_cache_advice = ON
compatible = 9.2.0.0.0
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_dest_state_3 = ENABLE
log_archive_dest_state_4 = ENABLE
log_archive_dest_state_5 = ENABLE
log_archive_dest_state_6 = ENABLE
log_archive_dest_state_7 = ENABLE
log_archive_dest_state_8 = ENABLE
log_archive_dest_state_9 = ENABLE
log_archive_dest_state_10= ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
log_archive_trace = 0
log_checkpoint_interval = 0
log_checkpoint_timeout = 1800
archive_lag_target = 0
db_file_multiblock_read_count= 16
standby_file_management = MANUAL
fast_start_io_target = 0
fast_start_mttr_target = 300
log_checkpoints_to_alert = FALSE
control_file_record_keep_time= 7
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_suppress_errors = FALSE
undo_retention = 10800
fast_start_parallel_rollback= LOW
db_block_checking = FALSE
remote_login_passwordfile= EXCLUSIVE
license_max_users = 0
db_domain =
global_names = FALSE
instance_name = mes
service_names = MES
dispatchers = (PROTOCOL=TCP) (SERVICE=mesXDB), (PROTOCOL=TCP)
shared_servers = 1
mts_servers = 1
remote_dependencies_mode = TIMESTAMP
plsql_v2_compatibility = FALSE
plsql_compiler_flags = INTERPRETED
plsql_native_library_subdir_count= 0
job_queue_processes = 10
cursor_sharing = EXACT
hash_join_enabled = FALSE
background_dump_dest = /home/oracle/admin/mes/bdump
user_dump_dest = /home/oracle/admin/mes/udump
max_dump_file_size = UNLIMITED
core_dump_dest = /home/oracle/admin/mes/cdump
oracle_trace_enable = FALSE
sort_area_size = 52428800
db_name = mes
open_cursors = 300
star_transformation_enabled= FALSE
parallel_adaptive_multi_ |
-
1.jpg
(54.38 KB, 下载次数: 1)
|
免费注册
发表于 2004-06-21 17:18
