 | | | SLES 9 Oracle 10g Instance Crash opteron | SLES 9 Oracle 10g Instance Crash opteron 2005-07-11 - By Seah Hong Yee
Ok, the log is pretty big but I isolate an incident around 2am 7/72005, before
and after around that time.
Current log# 1 seq# 107 mem# 0: /u01/app/oracle/oradata/compiere/redo01.log
Thu Jul 7 00:21:54 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 108
Current log# 2 seq# 108 mem# 0: /u01/app/oracle/oradata/compiere/redo02.log
Thu Jul 7 01:42:40 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 109
Current log# 3 seq# 109 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Thu Jul 7 02:00:13 2005
Starting background process EMN0
EMN0 started with pid=48, OS id=3244
Thu Jul 7 02:00:13 2005
Shutting down instance: further logons disabled
Thu Jul 7 02:00:14 2005
Stopping background process CJQ0
Thu Jul 7 02:00:14 2005
Stopping background process QMNC
Thu Jul 7 02:00:48 2005
Stopping background process MMNL
Thu Jul 7 02:00:49 2005
Stopping background process MMON
Thu Jul 7 02:00:50 2005
Errors in file /u01/app/oracle/admin/compiere/udump/compiere_ora_3242.trc:
ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1
ORA-06521 (See ORA-06521.ora-code.com): PL/SQL: Error mapping function
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512 (See ORA-06512.ora-code.com): at line 6
Thu Jul 7 02:00:50 2005
Shutting down instance (immediate)
License high water mark = 31
Thu Jul 7 02:00:50 2005
Stopping Job queue slave processes
Thu Jul 7 02:00:50 2005
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Thu Jul 7 02:00:56 2005
ALTER DATABASE CLOSE NORMAL
Thu Jul 7 02:00:56 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 7 02:00:56 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 109
Successful close of redo thread 1
Thu Jul 7 02:00:56 2005
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 7 02:00:56 2005
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 7 02:00:58 2005
Starting ORACLE instance (normal)
Thu Jul 7 02:00:58 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Running with 1 strand for Non-Enterprise Edition
Dynamic strands is set to FALSE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.3.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 155189248
__large_pool_size = 4194304
__java_pool_size = 16777216
sga_target = 603979776
control_files
= /u01/app/oracle/oradata/compiere/control01.ctl, /u0
1/app/oracle/oradata/compiere/control02.ctl, /u01/app/oracle/oradata/compiere/co
ntrol03.ctl
db_block_size = 8192
__db_cache_size = 423624704
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area/
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain = polyscientific.com.my
dispatchers = (PROTOCOL=TCP) (SERVICE=compiereXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/compiere/bdump
user_dump_dest = /u01/app/oracle/admin/compiere/udump
core_dump_dest = /u01/app/oracle/admin/compiere/cdump
db_name = compiere
open_cursors = 300
pga_aggregate_target = 200278016
PMON started with pid=2, OS id=3260
MMAN started with pid=3, OS id=3262
DBW0 started with pid=4, OS id=3264
LGWR started with pid=5, OS id=3266
CKPT started with pid=6, OS id=3268
SMON started with pid=7, OS id=3270
RECO started with pid=8, OS id=3272
Thu Jul 7 02:00:59 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)
(PROTOCOL
=TCP))'...
CJQ0 started with pid=9, OS id=3274
Thu Jul 7 02:00:59 2005
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Jul 7 02:00:59 2005
ALTER DATABASE MOUNT
Thu Jul 7 02:00:59 2005
Controlfile identified with block size 16384
Thu Jul 7 02:01:03 2005
Setting recovery target incarnation to 2
Thu Jul 7 02:01:03 2005
Successful mount of redo thread 1, with mount id 3919384091
Thu Jul 7 02:01:03 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Jul 7 02:01:05 2005
db_recovery_file_dest_size of 2048 MB is 44.38% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Incremental restore complete of datafile 2 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_undotbs1_02dycwoh_.dbf
checkpoint is 938084
Incremental restore complete of datafile 4 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_users_02dyczrh_.dbf
checkpoint is 938084
Incremental restore complete of datafile 3 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_sysaux_02dyc3kr_.dbf
checkpoint is 938084
Incremental restore complete of datafile 1 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_system_02dyb0ds_.dbf
checkpoint is 938084
Thu Jul 7 02:01:52 2005
Created Oracle managed
file /u01/app/oracle/flash_recovery_area/COMPIERE/backups
et/2005_07_07/o1_mf_nnnd1_TAG20050707T020120_1dr73jyd_.bkp
Created Oracle managed
file /u01/app/oracle/flash_recovery_area/COMPIERE/backups
et/2005_07_07/o1_mf_ncsn1_TAG20050707T020120_1dr74ng9_.bkp
Thu Jul 7 02:10:37 2005
Shutting down instance: further logons disabled
Thu Jul 7 02:10:37 2005
Shutting down instance (immediate)
Thu Jul 7 02:10:37 2005
Stopping background process CJQ0
License high water mark = 4
Thu Jul 7 02:10:37 2005
Stopping Job queue slave processes
Thu Jul 7 02:10:37 2005
Job queue slave processes stopped
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Thu Jul 7 02:10:38 2005
ALTER DATABASE CLOSE NORMAL
ORA-1109 (See ORA-1109.ora-code.com) signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Jul 7 02:10:38 2005
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 7 02:10:48 2005
Starting ORACLE instance (normal)
Thu Jul 7 02:10:48 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Running with 1 strand for Non-Enterprise Edition
Dynamic strands is set to FALSE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.3.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 155189248
__large_pool_size = 4194304
__java_pool_size = 16777216
sga_target = 603979776
control_files
= /u01/app/oracle/oradata/compiere/control01.ctl, /u0
1/app/oracle/oradata/compiere/control02.ctl, /u01/app/oracle/oradata/compiere/co
ntrol03.ctl
db_block_size = 8192
__db_cache_size = 423624704
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area/
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain = polyscientific.com.my
dispatchers = (PROTOCOL=TCP) (SERVICE=compiereXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/compiere/bdump
user_dump_dest = /u01/app/oracle/admin/compiere/udump
core_dump_dest = /u01/app/oracle/admin/compiere/cdump
db_name = compiere
open_cursors = 300
pga_aggregate_target = 200278016
PMON started with pid=2, OS id=5750
MMAN started with pid=3, OS id=5752
DBW0 started with pid=4, OS id=5754
LGWR started with pid=5, OS id=5756
CKPT started with pid=6, OS id=5758
SMON started with pid=7, OS id=5760
RECO started with pid=8, OS id=5762
Thu Jul 7 02:10:48 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)
(PROTOCOL
=TCP))'...
CJQ0 started with pid=9, OS id=5764
Thu Jul 7 02:10:48 2005
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Jul 7 02:10:48 2005
ALTER DATABASE MOUNT
Thu Jul 7 02:10:48 2005
Controlfile identified with block size 16384
Thu Jul 7 02:10:52 2005
Setting recovery target incarnation to 2
Thu Jul 7 02:10:53 2005
Successful mount of redo thread 1, with mount id 3919392616
Thu Jul 7 02:10:53 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Jul 7 02:10:53 2005
ALTER DATABASE OPEN
Thu Jul 7 02:10:53 2005
Maximum redo generation record size = 132096 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 2 at log switch
Thread 1 opened at log sequence 109
Current log# 3 seq# 109 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Successful open of redo thread 1
Thu Jul 7 02:10:53 2005
SMON: enabling cache recovery
Thu Jul 7 02:10:53 2005
Successfully onlined Undo Tablespace 1.
Thu Jul 7 02:10:53 2005
SMON: enabling tx recovery
Thu Jul 7 02:10:53 2005
Database Characterset is WE8ISO8859P1
Thu Jul 7 02:10:53 2005
Starting background process QMNC
QMNC started with pid=13, OS id=5775
Thu Jul 7 02:10:53 2005
replication_dependency_tracking turned off (no async multimaster replication
fou
nd)
Thu Jul 7 02:10:53 2005
Starting background process MMON
Starting background process MMNL
MMON started with pid=14, OS id=5777
MMNL started with pid=15, OS id=5779
Thu Jul 7 02:10:54 2005
Errors in file /u01/app/oracle/admin/compiere/udump/compiere_ora_5773.trc:
ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1
ORA-06521 (See ORA-06521.ora-code.com): PL/SQL: Error mapping function
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512 (See ORA-06512.ora-code.com): at line 7
Thu Jul 7 02:10:54 2005
Completed: ALTER DATABASE OPEN
Thu Jul 7 02:10:57 2005
db_recovery_file_dest_size of 2048 MB is 44.89% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Jul 7 02:13:52 2005
alter database open
Thu Jul 7 02:13:52 2005
ORA-1531 (See ORA-1531.ora-code.com) signalled during: alter database open...
Thu Jul 7 03:00:04 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 110
Current log# 1 seq# 110 mem# 0: /u01/app/oracle/oradata/compiere/redo01.log
Thu Jul 7 04:00:38 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 111
Current log# 2 seq# 111 mem# 0: /u01/app/oracle/oradata/compiere/redo02.log
Thu Jul 7 05:12:38 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 112
Current log# 3 seq# 112 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Thu Jul 7 06:42:33 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 113
Current log# 1 seq# 113 mem# 0: /u01/app/oracle/oradata/compiere/redo01.log
Thu Jul 7 08:00:19 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 114
Current log# 2 seq# 114 mem# 0: /u01/app/oracle/oradata/compiere/redo02.log
Thu Jul 7 09:12:41 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 115
Current log# 3 seq# 115 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Thu Jul 7 10:47:36 2005
Private_strands 3 at log switch
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
|