Reply from vmilivoj on May 16 at 1:23 PM Hi,
This is two critical days of that log:
Wed May 11 09:14:20 2016
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 11 09:14:20 2016
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 80
sessions = 96
shared_pool_size = 260046848
sga_max_size = 563684020
shared_pool_reserved_size= 25763512
enqueue_resources = 8000
control_files = I:\oracle\TWS\origlogA\cntrl\cntrlTWS.dbf, I:\oracle\TWS\sapdata1\cntrl\cntrlTWS.dbf, I:\oracle\TWS\saparch\cntrl\cntrlTWS.dbf
db_block_size = 8192
db_cache_size = 260046848
compatible = 9.2.0
log_archive_start = TRUE
log_archive_dest = I:\oracle\TWS\oraarch\TWSarch
log_buffer = 1048576
log_checkpoint_interval = 0
db_files = 254
fast_start_mttr_target = 900
log_checkpoints_to_alert = TRUE
control_file_record_keep_time= 30
dml_locks = 4000
transaction_auditing = FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
remote_os_authent = TRUE
hash_join_enabled = FALSE
background_dump_dest = I:\oracle\TWS\saptrace\background
user_dump_dest = I:\oracle\TWS\saptrace\usertrace
core_dump_dest = I:\oracle\TWS\saptrace\background
optimizer_features_enable= 9.2.0
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = TWS
open_cursors = 800
optimizer_index_cost_adj = 10
pga_aggregate_target = 343513497
workarea_size_policy = AUTO
statistics_level = typical
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
Wed May 11 09:14:22 2016
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
ARC1 started with pid=9
Wed May 11 09:14:23 2016
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed May 11 09:14:23 2016
ARC0: Thread not mounted
Wed May 11 09:14:23 2016
alter database mount exclusive
Wed May 11 09:14:24 2016
ARC1: Archival started
Wed May 11 09:14:24 2016
ARC1: Thread not mounted
Wed May 11 09:14:28 2016
Successful mount of redo thread 1, with mount id 882476208
Wed May 11 09:14:28 2016
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 11 09:14:28 2016
alter database open
Wed May 11 09:14:28 2016
Beginning crash recovery of 1 threads
Wed May 11 09:14:28 2016
Started redo scan
Wed May 11 09:14:28 2016
Completed redo scan
697 redo blocks read, 104 data blocks need recovery
Wed May 11 09:14:28 2016
Started recovery at
Thread 1: logseq 109522, block 99524, scn 0.0
Wed May 11 09:14:28 2016
Recovery of Online Redo Log: Thread 1 Group 1 Seq 109522 Reading mem 0
Mem# 0 errs 0: I:\ORACLE\TWS\MIRRLOGA\LOG_G11M2.DBF
Mem# 1 errs 0: I:\ORACLE\TWS\ORIGLOGA\LOG_G11M1.DBF
Wed May 11 09:14:29 2016
Completed redo application
Wed May 11 09:14:29 2016
Ended recovery at
Thread 1: logseq 109522, block 100221, scn 0.981218757
104 data blocks read, 104 data blocks written, 697 redo blocks read
Crash recovery completed successfully
Wed May 11 09:14:29 2016
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 109523
Thread 1 opened at log sequence 109523
Current log# 2 seq# 109523 mem# 0: I:\ORACLE\TWS\ORIGLOGB\LOG_G12M1.DBF
Current log# 2 seq# 109523 mem# 1: I:\ORACLE\TWS\MIRRLOGB\LOG_G12M2.DBF
Successful open of redo thread 1
Wed May 11 09:14:29 2016
SMON: enabling cache recovery
Wed May 11 09:14:29 2016
ARC0: Evaluating archive log 1 thread 1 sequence 109522
ARC0: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
ARC0: Beginning to archive log 1 thread 1 sequence 109522
Creating archive destination LOG_ARCHIVE_DEST_1: 'I:\ORACLE\TWS\ORAARCH\TWSARCHARC09522.001'
Wed May 11 09:14:29 2016
Successfully onlined Undo Tablespace 6.
Wed May 11 09:14:29 2016
SMON: enabling tx recovery
Wed May 11 09:14:30 2016
Database Characterset is WE8DEC
Wed May 11 09:14:30 2016
ARC0: Completed archiving log 1 thread 1 sequence 109522
Wed May 11 09:14:32 2016
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Starting ORACLE instance (normal)
Thu May 12 05:34:53 2016
/* BRCONNECT */ ALTER TABLESPACE "SYSTEM" COALESCE
Thu May 12 05:34:53 2016
Completed: /* BRCONNECT */ ALTER TABLESPACE "SYSTEM" COALESCE
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 13
Thu May 12 05:35:36 2016
ALTER DATABASE CLOSE NORMAL
Thu May 12 05:35:36 2016
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu May 12 05:35:36 2016
Shutting down archive processes
Archiving is disabled
Thu May 12 05:35:36 2016
ARCH shutting down
ARC1: Archival stopped
Thu May 12 05:35:36 2016
Thread 1 closed at log sequence 109523
Successful close of redo thread 1
Thu May 12 05:35:36 2016
Completed: ALTER DATABASE CLOSE NORMAL
Thu May 12 05:35:36 2016
ALTER DATABASE DISMOUNT
Thu May 12 05:35:37 2016
ARCH shutting down
Thu May 12 05:35:37 2016
ARC0: Archival stopped
Thu May 12 05:35:37 2016
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu May 12 05:49:40 2016
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 80
sessions = 96
shared_pool_size = 260046848
sga_max_size = 563684020
shared_pool_reserved_size= 25763512
enqueue_resources = 8000
control_files = I:\oracle\TWS\origlogA\cntrl\cntrlTWS.dbf, I:\oracle\TWS\sapdata1\cntrl\cntrlTWS.dbf, I:\oracle\TWS\saparch\cntrl\cntrlTWS.dbf
db_block_size = 8192
db_cache_size = 260046848
compatible = 9.2.0
log_archive_start = TRUE
log_archive_dest = I:\oracle\TWS\oraarch\TWSarch
log_buffer = 1048576
log_checkpoint_interval = 0
db_files = 254
fast_start_mttr_target = 900
log_checkpoints_to_alert = TRUE
control_file_record_keep_time= 30
dml_locks = 4000
transaction_auditing = FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
remote_os_authent = TRUE
hash_join_enabled = FALSE
background_dump_dest = I:\oracle\TWS\saptrace\background
user_dump_dest = I:\oracle\TWS\saptrace\usertrace
core_dump_dest = I:\oracle\TWS\saptrace\background
optimizer_features_enable= 9.2.0
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = TWS
open_cursors = 800
optimizer_index_cost_adj = 10
pga_aggregate_target = 343513497
workarea_size_policy = AUTO
statistics_level = typical
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
Thu May 12 05:49:42 2016
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
ARC1 started with pid=9
Thu May 12 05:49:43 2016
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu May 12 05:49:43 2016
ARC0: Thread not mounted
Thu May 12 05:49:43 2016
ALTER DATABASE MOUNT
Thu May 12 05:49:44 2016
ARC1: Archival started
Thu May 12 05:49:44 2016
ARC1: Thread not mounted
Thu May 12 05:49:48 2016
Successful mount of redo thread 1, with mount id 882513720
Thu May 12 05:49:48 2016
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu May 12 05:49:49 2016
ALTER DATABASE OPEN
Thu May 12 05:49:49 2016
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu May 12 05:49:49 2016
Errors in file i:\oracle\tws\saptrace\background\tws_lgwr_6000.tr c:
ORA-01110: data file 7: 'I:\ORACLE\TWS\SAPDATA2\TWS_5\TWS.DATA5'
ORA-01114: IO error writing block to file 7 (block # 1)
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
Thread 1 opened at log sequence 109523
Current log# 2 seq# 109523 mem# 0: I:\ORACLE\TWS\ORIGLOGB\LOG_G12M1.DBF
Current log# 2 seq# 109523 mem# 1: I:\ORACLE\TWS\MIRRLOGB\LOG_G12M2.DBF
Successful open of redo thread 1
Thu May 12 05:49:49 2016
SMON: enabling cache recovery
Thu May 12 05:49:50 2016
Successfully onlined Undo Tablespace 6.
Thu May 12 05:49:50 2016
SMON: enabling tx recovery
Thu May 12 05:49:50 2016
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Starting ORACLE instance (normal)
Thu May 12 20:07:28 2016
Beginning log switch checkpoint up to RBA [0x1abd4.2.10], SCN: 0x0000.3a7d3553
Thread 1 advanced to log sequence 109524
Current log# 4 seq# 109524 mem# 0: I:\ORACLE\TWS\ORIGLOGB\LOG_G14M1.DBF
Current log# 4 seq# 109524 mem# 1: I:\ORACLE\TWS\MIRRLOGB\LOG_G14M2.DBF
Thu May 12 20:07:28 2016
ARC0: Evaluating archive log 2 thread 1 sequence 109523
ARC0: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
ARC0: Beginning to archive log 2 thread 1 sequence 109523
Creating archive destination LOG_ARCHIVE_DEST_1: 'I:\ORACLE\TWS\ORAARCH\TWSARCHARC09523.001'
ARC0: Completed archiving log 2 thread 1 sequence 109523
Thu May 12 20:17:56 2016
Errors in file i:\oracle\tws\saptrace\background\tws_ckpt_6004.tr c:
ORA-01171: datafile 7 going offline due to error advancing checkpoint
ORA-01122: database file 7 failed verification check
ORA-01110: data file 7: 'I:\ORACLE\TWS\SAPDATA2\TWS_5\TWS.DATA5'
ORA-01208: data file is an old version - not accessing current version
Thu May 12 20:17:56 2016
Completed checkpoint up to RBA [0x1abd4.2.10], SCN: 0x0000.3a7d3553
Thu May 12 20:18:38 2016
Beginning log switch checkpoint up to RBA [0x1abd5.2.10], SCN: 0x0000.3a7ec45b
Thread 1 advanced to log sequence 109525
Current log# 3 seq# 109525 mem# 0: I:\ORACLE\TWS\ORIGLOGA\LOG_G13M1.DBF
Current log# 3 seq# 109525 mem# 1: I:\ORACLE\TWS\MIRRLOGA\LOG_G13M2.DBF
Thu May 12 20:18:38 2016
ARC1: Evaluating archive log 4 thread 1 sequence 109524
ARC1: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
ARC1: Beginning to archive log 4 thread 1 sequence 109524
Creating archive destination LOG_ARCHIVE_DEST_1: 'I:\ORACLE\TWS\ORAARCH\TWSARCHARC09524.001'
ARC1: Completed archiving log 4 thread 1 sequence 109524
Thu May 12 20:48:51 2016
Completed checkpoint up to RBA [0x1abd5.2.10], SCN: 0x0000.3a7ec45b
Dump file i:\oracle\tws\saptrace\background\alert_tws.log
Fri May 13 06:50:26 2016
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Fri May 13 06:50:26 2016
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 80
sessions = 96
shared_pool_size = 260046848
sga_max_size = 563684020
shared_pool_reserved_size= 25763512
enqueue_resources = 8000
control_files = I:\oracle\TWS\origlogA\cntrl\cntrlTWS.dbf, I:\oracle\TWS\sapdata1\cntrl\cntrlTWS.dbf, I:\oracle\TWS\saparch\cntrl\cntrlTWS.dbf
db_block_size = 8192
db_cache_size = 260046848
compatible = 9.2.0
log_archive_start = TRUE
log_archive_dest = I:\oracle\TWS\oraarch\TWSarch
log_buffer = 1048576
log_checkpoint_interval = 0
db_files = 254
fast_start_mttr_target = 900
log_checkpoints_to_alert = TRUE
control_file_record_keep_time= 30
dml_locks = 4000
transaction_auditing = FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
remote_os_authent = TRUE
hash_join_enabled = FALSE
background_dump_dest = I:\oracle\TWS\saptrace\background
user_dump_dest = I:\oracle\TWS\saptrace\usertrace
core_dump_dest = I:\oracle\TWS\saptrace\background
optimizer_features_enable= 9.2.0
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = TWS
open_cursors = 800
optimizer_index_cost_adj = 10
pga_aggregate_target = 343513497
workarea_size_policy = AUTO
statistics_level = typical
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
What can I do?
Thanks
| | | ---------------Original Message---------------
From: Snowy
Sent: Monday, May 16, 2016 12:34 PM
Subject: Dispatcher stopped
Hi,
you might have a database issue:
ORA-376 occurred when executing SQL statement (parse error offset=0)
investigate contents of alert_TWS.log file |
| Reply to this email to post your response. __.____._ |  | vmilivoj
Programmer/Developer - Software | |    _.____.__ |
