Oracle Database Discussions

Our database instance crashed temporarily and it opened again itself, i can't find reason for problem, so please help me to solve this problem in future. For your reference i am pasting the alert log file.


Thread 1 advanced to log sequence 133432
Current log# 6 seq# 133432 mem# 0: /oracle/BP3/origlogA/log_g16m1.log
Current log# 6 seq# 133432 mem# 1: /oracle/BP3/mirrlogA/log_g16m2.log
Thu Jul 5 19:00:27 2007
Completed checkpoint up to RBA [0x20936.2.10], SCN: 2413862365
Thu Jul 5 19:01:02 2007
Beginning log switch checkpoint up to RBA [0x20939.2.10], SCN: 2413997841
Thread 1 advanced to log sequence 133433
Current log# 7 seq# 133433 mem# 0: /oracle/BP3/origlogA/log_g17m1.log
Current log# 7 seq# 133433 mem# 1: /oracle/BP3/mirrlogA/log_g17m2.log
Thu Jul 5 19:02:33 2007
Completed checkpoint up to RBA [0x20937.2.10], SCN: 2413908159
Thu Jul 5 19:03:11 2007
Beginning log switch checkpoint up to RBA [0x2093a.2.10], SCN: 2414042832
Thread 1 advanced to log sequence 133434
Current log# 5 seq# 133434 mem# 0: /oracle/BP3/origlogA/log_g15m1.log
Current log# 5 seq# 133434 mem# 1: /oracle/BP3/mirrlogA/log_g15m2.log
Thu Jul 5 19:04:47 2007
Completed checkpoint up to RBA [0x20938.2.10], SCN: 2413952612
Thu Jul 5 19:05:23 2007
Beginning log switch checkpoint up to RBA [0x2093b.2.10], SCN: 2414088684
Thread 1 advanced to log sequence 133435
Current log# 8 seq# 133435 mem# 0: /oracle/BP3/origlogB/log_g18m1.log
Current log# 8 seq# 133435 mem# 1: /oracle/BP3/mirrlogB/log_g18m2.log
Thu Jul 5 19:07:02 2007
Completed checkpoint up to RBA [0x20939.2.10], SCN: 2413997841
Thu Jul 5 19:07:38 2007
Beginning log switch checkpoint up to RBA [0x2093c.2.10], SCN: 2414134803
Thread 1 advanced to log sequence 133436
Current log# 6 seq# 133436 mem# 0: /oracle/BP3/origlogA/log_g16m1.log
Current log# 6 seq# 133436 mem# 1: /oracle/BP3/mirrlogA/log_g16m2.log
Thu Jul 5 19:09:12 2007
Completed checkpoint up to RBA [0x2093a.2.10], SCN: 2414042832
Thu Jul 5 19:09:50 2007
Beginning log switch checkpoint up to RBA [0x2093d.2.10], SCN: 2414180408
Thread 1 advanced to log sequence 133437
Current log# 7 seq# 133437 mem# 0: /oracle/BP3/origlogA/log_g17m1.log
Current log# 7 seq# 133437 mem# 1: /oracle/BP3/mirrlogA/log_g17m2.log
Thu Jul 5 19:10:58 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_197.trc:
ORA-04098: trigger 'SYS.BLOCK_TOAD_FROM_PROD' is invalid and failed re-validation
Thu Jul 5 19:11:23 2007
Completed checkpoint up to RBA [0x2093b.2.10], SCN: 2414088684
Thu Jul 5 19:11:58 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_221.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:11:59 2007
Beginning log switch checkpoint up to RBA [0x2093e.2.10], SCN: 2414226317
Thread 1 advanced to log sequence 133438
Current log# 5 seq# 133438 mem# 0: /oracle/BP3/origlogA/log_g15m1.log
Current log# 5 seq# 133438 mem# 1: /oracle/BP3/mirrlogA/log_g15m2.log
Thu Jul 5 19:12:58 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_427.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:13:58 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_466.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:14:59 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_686.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:15:59 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_886.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:16:59 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_941.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:18:00 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_973.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:19:00 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_988.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:19:03 2007
Incremental checkpoint up to RBA [0x2093b.6efe9.0], current log tail at RBA [0x2093e.25272.0]
Thu Jul 5 19:20:00 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1250.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:21:00 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1353.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:22:01 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1392.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:23:01 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1421.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:24:01 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1435.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:25:01 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1449.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:26:02 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1465.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:26:26 2007
WARNING: inbound connection timed out (ORA-3136)
Thu Jul 5 19:27:02 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1489.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:28:02 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1654.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:29:03 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1693.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:30:01 2007
Errors in file /oracle/BP3/saptrace/usertrace/bp3_ora_1960.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:30:03 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_1978.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:31:03 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_2357.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:32:03 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_2377.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:33:04 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_2428.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:34:04 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_2651.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:35:04 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_2673.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:36:04 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_2728.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:37:05 2007
Errors in file /oracle/BP3/saptrace/background/bp3_j000_2770.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
Thu Jul 5 19:37:48 2007
Completed checkpoint up to RBA [0x2093c.2.10], SCN: 2414134803
Thu Jul 5 19:39:59 2007
Completed checkpoint up to RBA [0x2093d.2.10], SCN: 2414180408
Thu Jul 5 19:42:06 2007
Completed checkpoint up to RBA [0x2093e.2.10], SCN: 2414226317
Thu Jul 5 19:49:09 2007
Incremental checkpoint up to RBA [0x2093e.25277.0], current log tail at RBA [0x2093e.32ed4.0]
Thu Jul 5 19:52:10 2007
Errors in file /oracle/BP3/saptrace/background/bp3_mman_6680.trc:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 36
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Thu Jul 5 19:52:10 2007
MMAN: terminating instance due to error 27157
Thu Jul 5 19:52:10 2007
Errors in file /oracle/BP3/saptrace/background/bp3_ckpt_6692.trc:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 36
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Instance terminated by MMAN, pid = 6680
Thu Jul 5 19:52:11 2007
Errors in file /oracle/BP3/saptrace/background/bp3_mman_6680.trc:
ORA-27300: OS system dependent operation:semctl failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwrm1
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 36
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Thu Jul 5 19:57:08 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
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.2.0.
System parameters with non-default values:
spincount = 1000
processes = 550
sessions = 1100
event = 10027 trace name context forever, level 1, 10028 trace name context forever, level 1, 10162 trace name context forever, level 1, 10191 trace name context forever, level 1, 38068 trace name context forever, level 100, 38089 trace name context forever, level 3
sga_max_size = 35433480192
shared_pool_size = 9277800448
java_pool_size = 167772160
shared_pool_reserved_size= 927712935
filesystemio_options = setall
control_files = /oracle/BP3/origlogA/cntrl/cntrlBP3.dbf, /oracle/BP3/origlogB/cntrl/cntrlBP3.dbf, /oracle/BP3/sapdata1/cntrl/cntrlBP3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
__db_cache_size = 21474836480
db_cache_size = 21474836480
dbblock_hash_latches = 32768
compatible = 10.2.0
log_archive_dest = /oracle/BP3/oraarch/BP3arch
log_buffer = 2097152
log_checkpoint_interval = 0
db_files = 254
fast_start_mttr_target = 0
log_checkpoints_to_alert = TRUE
dml_locks = 4000
replication_dependency_tracking= FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
inmemory_undo = FALSE
undo_retention = 3600
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
smtp_out_server = 10.22.2.61
job_queue_processes = 1
parallel_max_servers = 80
fixcontrol = 4728348:OFF
background_dump_dest = /oracle/BP3/saptrace/background
user_dump_dest = /oracle/BP3/saptrace/usertrace
max_dump_file_size = 20000
core_dump_dest = /oracle/BP3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = BP3
open_cursors = 800
sortelimination_cost_ratio= 10
btree_bitmap_plans = FALSE
star_transformation_enabled= TRUE
query_rewrite_enabled = FALSE
indexjoin_enabled = FALSE
optimpeek_user_binds = FALSE
pga_aggregate_target = 21474836480
workarea_size_policy = AUTO
statistics_level = typical
optimizermjc_enabled = FALSE
PMON started with pid=5, OS id=6614
PSP0 started with pid=9, OS id=6616
MMAN started with pid=13, OS id=6618
DBW0 started with pid=2, OS id=6620
DBW1 started with pid=3, OS id=6622
DBW2 started with pid=4, OS id=6624
DBW3 started with pid=17, OS id=6626
LGWR started with pid=7, OS id=6628
CKPT started with pid=21, OS id=6630
SMON started with pid=25, OS id=6632
RECO started with pid=29, OS id=6634
CJQ0 started with pid=6, OS id=6638
MMON started with pid=33, OS id=6642
MMNL started with pid=37, OS id=6646
Thu Jul 5 19:57:20 2007
WARNING: -------------------------------
WARNING: oradism not set up correctly.
Dynamic ISM can not be locked. Please
setup oradism, or unset sga_max_size.
[diagnostic 0, 8, 206]
----------------------------------------
Thu Jul 5 19:57:20 2007
ALTER DATABASE MOUNT
Thu Jul 5 19:57:25 2007
Setting recovery target incarnation to 1
Thu Jul 5 19:57:25 2007
Successful mount of redo thread 1, with mount id 2027930081
Thu Jul 5 19:57:25 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Jul 5 19:57:25 2007
ALTER DATABASE OPEN
Thu Jul 5 19:57:25 2007
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Thu Jul 5 19:57:28 2007
Started redo scan
Thu Jul 5 19:57:29 2007
Completed redo scan
53669 redo blocks read, 3846 data blocks need recovery
Thu Jul 5 19:57:29 2007
Started redo application at
Thread 1: logseq 133438, block 155533
Thu Jul 5 19:57:29 2007
Recovery of Online Redo Log: Thread 1 Group 5 Seq 133438 Reading mem 0
Mem# 0 errs 0: /oracle/BP3/origlogA/log_g15m1.log
Mem# 1 errs 0: /oracle/BP3/mirrlogA/log_g15m2.log
Thu Jul 5 19:57:30 2007
Completed redo application
Thu Jul 5 19:57:30 2007
Completed crash recovery at
Thread 1: logseq 133438, block 209202, scn 2414267882
3846 data blocks read, 3846 data blocks written, 53669 redo blocks read
Thu Jul 5 19:57:30 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=26, OS id=6785
Thu Jul 5 19:57:30 2007
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=27, OS id=6787
Thu Jul 5 19:57:30 2007
Thread 1 advanced to log sequence 133439
Thread 1 opened at log sequence 133439
Current log# 8 seq# 133439 mem# 0: /oracle/BP3/origlogB/log_g18m1.log
Current log# 8 seq# 133439 mem# 1: /oracle/BP3/mirrlogB/log_g18m2.log
Successful open of redo thread 1
Thu Jul 5 19:57:30 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jul 5 19:57:30 2007
ARC0: STARTING ARCH PROCESSES
Thu Jul 5 19:57:30 2007
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Thu Jul 5 19:57:30 2007
SMON: enabling cache recovery
Thu Jul 5 19:57:31 2007
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=24, OS id=6793
Thu Jul 5 19:57:31 2007
Successfully onlined Undo Tablespace 1.
Thu Jul 5 19:57:31 2007
SMON: enabling tx recovery
Thu Jul 5 19:57:31 2007
Incremental checkpoint up to RBA [0x2093f.3.0], current log tail at RBA [0x2093f.19d.0]
Thu Jul 5 19:57:31 2007
Database Characterset is UTF8
Starting background process QMNC
QMNC started with pid=30, OS id=6806
Thu Jul 5 19:57:36 2007
Completed: ALTER DATABASE OPEN
Thu Jul 5 19:57:38 2007
Starting background process EMN0
EMN0 started with pid=53, OS id=6947
Thu Jul 5 19:58:30 2007
Shutting down archive processes
Thu Jul 5 19:58:35 2007
ARCH shutting down
ARC2: Archival stopped
Thu Jul 5 20:06:50 2007
Beginning log switch checkpoint up to RBA [0x20940.2.10], SCN: 2414269262
Thread 1 advanced to log sequence 133440
Current log# 6 seq# 133440 mem# 0: /oracle/BP3/origlogA/log_g16m1.log
Current log# 6 seq# 133440 mem# 1: /oracle/BP3/mirrlogA/log_g16m2.log
Thu Jul 5 20:06:50 2007
alter database begin backup
Thu Jul 5 20:06:51 2007
Completed checkpoint up to RBA [0x20940.2.10], SCN: 2414269262
Thu Jul 5 20:06:51 2007
Completed: alter database begin backup
Thu Jul 5 20:07:05 2007
alter database end backup
Thu Jul 5 20:07:06 2007
Completed: alter database end backup
Thu Jul 5 20:07:06 2007
Beginning log switch checkpoint up to RBA [0x20941.2.10], SCN: 2414269283
Thread 1 advanced to log sequence 133441
Current log# 7 seq# 133441 mem# 0: /oracle/BP3/origlogA/log_g17m1.log
Current log# 7 seq# 133441 mem# 1: /oracle/BP3/mirrlogA/log_g17m2.log
Thu Jul 5 20:07:07 2007
alter database backup controlfile to '/oracle/BP3/oraarch/cntrlBP3.dbf' reuse
Thu Jul 5 20:07:10 2007
Completed: alter database backup controlfile to '/oracle/BP3/oraarch/cntrlBP3.dbf' reuse
Thu Jul 5 20:09:48 2007
Shutting down instance: further logons disabled
Thu Jul 5 20:09:48 2007
Completed checkpoint up to RBA [0x20941.2.10], SCN: 2414269283
Thu Jul 5 20:09:48 2007
Stopping background process QMNC
Thu Jul 5 20:09:48 2007
Stopping background process CJQ0
Thu Jul 5 20:09:50 2007
Stopping background process MMNL
Thu Jul 5 20:09:51 2007
Stopping background process MMON
Thu Jul 5 20:09:52 2007
Shutting down instance (immediate)
License high water mark = 17
Thu Jul 5 20:09:52 2007
Stopping Job queue slave processes
Thu Jul 5 20:09:52 2007
Job queue slave processes stopped
Thu Jul 5 20:09:57 2007
ALTER DATABASE CLOSE NORMAL
Thu Jul 5 20:09:57 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 5 20:09:58 2007
Shutting down archive processes
Archiving is disabled
Thu Jul 5 20:10:03 2007
ARCH shutting down
ARC1: Archival stopped
Thu Jul 5 20:10:08 2007
ARCH shutting down
ARC0: Archival stopped
Thu Jul 5 20:10:09 2007
Thread 1 closed at log sequence 133441
Successful close of redo thread 1
Thu Jul 5 20:10:09 2007
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 5 20:10:09 2007
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
Thu Jul 5 20:10:33 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
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.2.0.
System parameters with non-default values:
spincount = 1000
processes = 550
sessions = 1100
event = 10027 trace name context forever, level 1, 10028 trace name context forever, level 1, 10162 trace name context forever, level 1, 10191 trace name context forever, level 1, 38068 trace name context forever, level 100, 38089 trace name context forever, level 3
sga_max_size = 35433480192
shared_pool_size = 9277800448
java_pool_size = 167772160
shared_pool_reserved_size= 927712935
filesystemio_options = setall
control_files = /oracle/BP3/origlogA/cntrl/cntrlBP3.dbf, /oracle/BP3/origlogB/cntrl/cntrlBP3.dbf, /oracle/BP3/sapdata1/cntrl/cntrlBP3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
__db_cache_size = 21474836480
db_cache_size = 21474836480
dbblock_hash_latches = 32768
compatible = 10.2.0
log_archive_dest = /oracle/BP3/oraarch/BP3arch
log_buffer = 2097152
log_checkpoint_interval = 0
db_files = 254
fast_start_mttr_target = 0
log_checkpoints_to_alert = TRUE
dml_locks = 4000
replication_dependency_tracking= FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
inmemory_undo = FALSE
undo_retention = 3600
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
smtp_out_server = 10.22.2.61
job_queue_processes = 1
parallel_max_servers = 80
fixcontrol = 4728348:OFF
background_dump_dest = /oracle/BP3/saptrace/background
user_dump_dest = /oracle/BP3/saptrace/usertrace
max_dump_file_size = 20000
core_dump_dest = /oracle/BP3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = BP3
open_cursors = 800
sortelimination_cost_ratio= 10
btree_bitmap_plans = FALSE
star_transformation_enabled= TRUE
query_rewrite_enabled = FALSE
indexjoin_enabled = FALSE
optimpeek_user_binds = FALSE
pga_aggregate_target = 21474836480
workarea_size_policy = AUTO
statistics_level = typical
optimizermjc_enabled = FALSE
PMON started with pid=5, OS id=11644
PSP0 started with pid=9, OS id=11646
MMAN started with pid=13, OS id=11654
DBW0 started with pid=2, OS id=11662
DBW1 started with pid=3, OS id=11664
DBW2 started with pid=4, OS id=11666
DBW3 started with pid=17, OS id=11668
LGWR started with pid=7, OS id=11670
CKPT started with pid=25, OS id=11678
SMON started with pid=21, OS id=11685
RECO started with pid=29, OS id=11687
CJQ0 started with pid=6, OS id=11689
MMON started with pid=33, OS id=11691
MMNL started with pid=37, OS id=11693
Thu Jul 5 20:10:45 2007
WARNING: -------------------------------
WARNING: oradism not set up correctly.
Dynamic ISM can not be locked. Please
setup oradism, or unset sga_max_size.
[diagnostic 0, 8, 206]
----------------------------------------
Thu Jul 5 20:10:45 2007
ALTER DATABASE MOUNT
Thu Jul 5 20:10:49 2007
Setting recovery target incarnation to 1
Thu Jul 5 20:10:49 2007
Successful mount of redo thread 1, with mount id 2027896581
Thu Jul 5 20:10:49 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Jul 5 20:10:50 2007
ALTER DATABASE OPEN
Thu Jul 5 20:10:50 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=11729
Thu Jul 5 20:10:50 2007
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=11, OS id=11731
Thu Jul 5 20:10:50 2007
Thread 1 opened at log sequence 133441
Current log# 7 seq# 133441 mem# 0: /oracle/BP3/origlogA/log_g17m1.log
Current log# 7 seq# 133441 mem# 1: /oracle/BP3/mirrlogA/log_g17m2.log
Successful open of redo thread 1
Thu Jul 5 20:10:50 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jul 5 20:10:50 2007
ARC0: STARTING ARCH PROCESSES
Thu Jul 5 20:10:50 2007
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Thu Jul 5 20:10:50 2007
SMON: enabling cache recovery
Thu Jul 5 20:10:50 2007
Incremental checkpoint up to RBA [0x20941.2d6.0], current log tail at RBA [0x20941.2d6.0]
Thu Jul 5 20:10:50 2007
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=8, OS id=11735
Thu Jul 5 20:10:50 2007
Successfully onlined Undo Tablespace 1.
Thu Jul 5 20:10:50 2007
SMON: enabling tx recovery
Thu Jul 5 20:10:51 2007
Database Characterset is UTF8
Starting background process QMNC
QMNC started with pid=18, OS id=11741
Thu Jul 5 20:10:52 2007
Completed: ALTER DATABASE OPEN
Thu Jul 5 20:10:52 2007
Starting background process EMN0
EMN0 started with pid=41, OS id=11776
Thu Jul 5 20:11:50 2007
Shutting down archive processes
Thu Jul 5 20:11:55 2007
ARCH shutting down
ARC2: Archival stopped
Thu Jul 5 20:24:41 2007
ALTER SYSTEM SET db_cache_size='12884901888' SCOPE=BOTH;
Thu Jul 5 20:25:54 2007
WARNING: Detected too many memory locking problems.
WARNING: Performance degradation may occur.
Thu Jul 5 20:26:20 2007
ALTER SYSTEM SET sga_max_size='26843545600' SCOPE=SPFILE;
Thu Jul 5 20:28:51 2007
Shutting down instance: further logons disabled
Thu Jul 5 20:28:51 2007
Stopping background process QMNC
Thu Jul 5 20:28:51 2007
Stopping background process CJQ0
Thu Jul 5 20:28:53 2007
Stopping background process MMNL
Thu Jul 5 20:28:54 2007
Stopping background process MMON
Thu Jul 5 20:28:55 2007
Shutting down instance (immediate)
License high water mark = 3
Thu Jul 5 20:28:55 2007
Stopping Job queue slave processes
Thu Jul 5 20:28:55 2007
Job queue slave processes stopped
Thu Jul 5 20:28:55 2007
ALTER DATABASE CLOSE NORMAL
Thu Jul 5 20:28:56 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 5 20:28:56 2007
Shutting down archive processes
Archiving is disabled
Thu Jul 5 20:29:01 2007
ARCH shutting down
ARC1: Archival stopped
Thu Jul 5 20:29:06 2007
ARCH shutting down
ARC0: Archival stopped
Thu Jul 5 20:29:07 2007
Thread 1 closed at log sequence 133441
Successful close of redo thread 1
Thu Jul 5 20:29:08 2007
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 5 20:29:08 2007
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
Thu Jul 5 20:30:30 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
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.2.0.
System parameters with non-default values:
spincount = 1000
processes = 550
sessions = 1100
event = 10027 trace name context forever, level 1, 10028 trace name context forever, level 1, 10162 trace name context forever, level 1, 10191 trace name context forever, level 1, 38068 trace name context forever, level 100, 38089 trace name context forever, level 3
sga_max_size = 26843545600
shared_pool_size = 9277800448
java_pool_size = 167772160
shared_pool_reserved_size= 927712935
filesystemio_options = setall
control_files = /oracle/BP3/origlogA/cntrl/cntrlBP3.dbf, /oracle/BP3/origlogB/cntrl/cntrlBP3.dbf, /oracle/BP3/sapdata1/cntrl/cntrlBP3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
__db_cache_size = 12884901888
db_cache_size = 12884901888
dbblock_hash_latches = 32768
compatible = 10.2.0
log_archive_dest = /oracle/BP3/oraarch/BP3arch
log_buffer = 2097152
log_checkpoint_interval = 0
db_files = 254
fast_start_mttr_target = 0
log_checkpoints_to_alert = TRUE
dml_locks = 4000
replication_dependency_tracking= FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
inmemory_undo = FALSE
undo_retention = 3600
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
smtp_out_server = 10.22.2.61
job_queue_processes = 1
parallel_max_servers = 80
fixcontrol = 4728348:OFF
background_dump_dest = /oracle/BP3/saptrace/background
user_dump_dest = /oracle/BP3/saptrace/usertrace
max_dump_file_size = 20000
core_dump_dest = /oracle/BP3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = BP3
open_cursors = 800
sortelimination_cost_ratio= 10
btree_bitmap_plans = FALSE
star_transformation_enabled= TRUE
query_rewrite_enabled = FALSE
indexjoin_enabled = FALSE
optimpeek_user_binds = FALSE
pga_aggregate_target = 21474836480
workarea_size_policy = AUTO
statistics_level = typical
optimizermjc_enabled = FALSE
PMON started with pid=2, OS id=16832
PSP0 started with pid=6, OS id=16836
MMAN started with pid=10, OS id=16841
DBW0 started with pid=14, OS id=16853
DBW1 started with pid=3, OS id=16863
DBW2 started with pid=4, OS id=16867
DBW3 started with pid=5, OS id=16869
LGWR started with pid=7, OS id=16871
CKPT started with pid=18, OS id=16873
SMON started with pid=22, OS id=16875
RECO started with pid=26, OS id=16877
CJQ0 started with pid=30, OS id=16879
MMON started with pid=34, OS id=16881
MMNL started with pid=38, OS id=16883
Thu Jul 5 20:30:41 2007
WARNING: -------------------------------
WARNING: oradism not set up correctly.
Dynamic ISM can not be locked. Please
setup oradism, or unset sga_max_size.
[diagnostic 0, 8, 206]
----------------------------------------
Thu Jul 5 20:30:41 2007
ALTER DATABASE MOUNT
Thu Jul 5 20:30:45 2007
Setting recovery target incarnation to 1
Thu Jul 5 20:30:45 2007
Successful mount of redo thread 1, with mount id 2027876785
Thu Jul 5 20:30:45 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Jul 5 20:30:46 2007
ALTER DATABASE OPEN
Thu Jul 5 20:30:46 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=42, OS id=16922
Thu Jul 5 20:30:46 2007
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=11, OS id=16924
Thu Jul 5 20:30:46 2007
Thread 1 opened at log sequence 133441
Current log# 7 seq# 133441 mem# 0: /oracle/BP3/origlogA/log_g17m1.log
Current log# 7 seq# 133441 mem# 1: /oracle/BP3/mirrlogA/log_g17m2.log
Successful open of redo thread 1
Thu Jul 5 20:30:46 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jul 5 20:30:46 2007
ARC0: STARTING ARCH PROCESSES
Thu Jul 5 20:30:46 2007
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Thu Jul 5 20:30:46 2007
SMON: enabling cache recovery
Thu Jul 5 20:30:46 2007
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=8, OS id=16926
Thu Jul 5 20:30:46 2007
Incremental checkpoint up to RBA [0x20941.967.0], current log tail at RBA [0x20941.97e.0]
Thu Jul 5 20:30:46 2007
Successfully onlined Undo Tablespace 1.
Thu Jul 5 20:30:46 2007
SMON: enabling tx recovery
Thu Jul 5 20:30:46 2007
Database Characterset is UTF8
Starting background process QMNC
QMNC started with pid=46, OS id=16951
Thu Jul 5 20:30:48 2007
Completed: ALTER DATABASE OPEN
Thu Jul 5 20:30:48 2007
Starting background process EMN0
EMN0 started with pid=58, OS id=16968
Thu Jul 5 20:31:46 2007
Shutting down archive processes
Thu Jul 5 20:31:51 2007
ARCH shutting down
ARC2: Archival stopped
Thu Jul 5 20:37:04 2007
ALTER SYSTEM SET pga_aggregate_target='16106127360' SCOPE=BOTH;
Thu Jul 5 20:39:28 2007
Shutting down instance: further logons disabled
Thu Jul 5 20:39:29 2007
Stopping background process QMNC
Thu Jul 5 20:39:29 2007
Stopping background process CJQ0
Thu Jul 5 20:39:31 2007
Stopping background process MMNL
Thu Jul 5 20:39:32 2007
Stopping background process MMON
Thu Jul 5 20:39:33 2007
Shutting down instance (immediate)
License high water mark = 4
Thu Jul 5 20:39:33 2007
Stopping Job queue slave processes
Thu Jul 5 20:39:33 2007
Job queue slave processes stopped
Thu Jul 5 20:39:33 2007
ALTER DATABASE CLOSE NORMAL
Thu Jul 5 20:39:33 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 5 20:39:33 2007
Shutting down archive processes
Archiving is disabled
Thu Jul 5 20:39:38 2007
ARCH shutting down
ARC1: Archival stopped
Thu Jul 5 20:39:44 2007
ARCH shutting down
ARC0: Archival stopped
Thu Jul 5 20:39:45 2007
Thread 1 closed at log sequence 133441
Successful close of redo thread 1
Thu Jul 5 20:39:45 2007
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 5 20:39:45 2007
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
Thu Jul 5 20:40:24 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
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.2.0.
System parameters with non-default values:
spincount = 1000
processes = 550
sessions = 1100
event = 10027 trace name context forever, level 1, 10028 trace name context forever, level 1, 10162 trace name context forever, level 1, 10191 trace name context forever, level 1, 38068 trace name context forever, level 100, 38089 trace name context forever, level 3
sga_max_size = 26843545600
shared_pool_size = 9277800448
java_pool_size = 167772160
shared_pool_reserved_size= 927712935
filesystemio_options = setall
control_files = /oracle/BP3/origlogA/cntrl/cntrlBP3.dbf, /oracle/BP3/origlogB/cntrl/cntrlBP3.dbf, /oracle/BP3/sapdata1/cntrl/cntrlBP3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
__db_cache_size = 12884901888
db_cache_size = 12884901888
dbblock_hash_latches = 32768
compatible = 10.2.0
log_archive_dest = /oracle/BP3/oraarch/BP3arch
log_buffer = 2097152
log_checkpoint_interval = 0
db_files = 254
fast_start_mttr_target = 0
log_checkpoints_to_alert = TRUE
dml_locks = 4000
replication_dependency_tracking= FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
inmemory_undo = FALSE
undo_retention = 3600
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
smtp_out_server = 10.22.2.61
job_queue_processes = 1
parallel_max_servers = 80
fixcontrol = 4728348:OFF
background_dump_dest = /oracle/BP3/saptrace/background
user_dump_dest = /oracle/BP3/saptrace/usertrace
max_dump_file_size = 20000
core_dump_dest = /oracle/BP3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = BP3
open_cursors = 800
sortelimination_cost_ratio= 10
btree_bitmap_plans = FALSE
star_transformation_enabled= TRUE
query_rewrite_enabled = FALSE
indexjoin_enabled = FALSE
optimpeek_user_binds = FALSE
pga_aggregate_target = 16106127360
workarea_size_policy = AUTO
statistics_level = typical
optimizermjc_enabled = FALSE
PMON started with pid=3, OS id=19582
PSP0 started with pid=11, OS id=19591
MMAN started with pid=7, OS id=19632
DBW0 started with pid=2, OS id=19638
DBW1 started with pid=15, OS id=19644
DBW2 started with pid=4, OS id=19650
DBW3 started with pid=5, OS id=19656
LGWR started with pid=19, OS id=19670
CKPT started with pid=23, OS id=19684
SMON started with pid=27, OS id=19692
RECO started with pid=31, OS id=19696
CJQ0 started with pid=6, OS id=19698
MMON started with pid=35, OS id=19700
MMNL started with pid=39, OS id=19702
Thu Jul 5 20:40:36 2007
WARNING: -------------------------------
WARNING: oradism not set up correctly.
Dynamic ISM can not be locked. Please
setup oradism, or unset sga_max_size.
[diagnostic 0, 8, 206]
----------------------------------------
Thu Jul 5 20:40:36 2007
ALTER DATABASE MOUNT
Thu Jul 5 20:40:41 2007
Setting recovery target incarnation to 1
Thu Jul 5 20:40:41 2007
Successful mount of redo thread 1, with mount id 2027909381
Thu Jul 5 20:40:41 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Jul 5 20:40:41 2007
ALTER DATABASE OPEN
Thu Jul 5 20:40:41 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=10, OS id=19754
Thu Jul 5 20:40:41 2007
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=43, OS id=19756
Thu Jul 5 20:40:41 2007
Thread 1 opened at log sequence 133441
Current log# 7 seq# 133441 mem# 0: /oracle/BP3/origlogA/log_g17m1.log
Current log# 7 seq# 133441 mem# 1: /oracle/BP3/mirrlogA/log_g17m2.log
Successful open of redo thread 1
Thu Jul 5 20:40:41 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jul 5 20:40:41 2007
ARC0: STARTING ARCH PROCESSES
Thu Jul 5 20:40:41 2007
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Thu Jul 5 20:40:41 2007
SMON: enabling cache recovery
Thu Jul 5 20:40:42 2007
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=12, OS id=19758
Thu Jul 5 20:40:42 2007
Incremental checkpoint up to RBA [0x20941.1046.0], current log tail at RBA [0x20941.10d7.0]
Thu Jul 5 20:40:42 2007
Successfully onlined Undo Tablespace 1.
Thu Jul 5 20:40:42 2007
SMON: enabling tx recovery
Thu Jul 5 20:40:42 2007
Database Characterset is UTF8
Starting background process QMNC
QMNC started with pid=14, OS id=19762
Thu Jul 5 20:40:43 2007
Completed: ALTER DATABASE OPEN
Thu Jul 5 20:40:43 2007
Starting background process EMN0
EMN0 started with pid=47, OS id=19779
Thu Jul 5 20:41:41 2007
Shutting down archive processes
Thu Jul 5 20:41:46 2007
ARCH shutting down
ARC2: Archival stopped
Thu Jul 5 20:53:31 2007
ALTER SYSTEM SET processes=400 SCOPE=SPFILE;
Thu Jul 5 20:55:42 2007
WARNING: Detected too many memory locking problems.
WARNING: Performance degradation may occur.
Thu Jul 5 21:10:55 2007
Incremental checkpoint up to RBA [0x20941.1151.0], current log tail at RBA [0x20941.989a.0]