数据库正常shutdown的时候，alertlog中报错：
Completed: ALTER DATABASE OPEN
Sat Apr1 04:20:14 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 57
Sat Apr1 04:20:18 2006
ALTER DATABASE CLOSE NORMAL
Sat Apr1 04:20:18 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Apr1 04:20:18 2006
Shutting down archive processes
Archiving is disabled
Sat Apr1 04:20:18 2006
ARCH shutting down
Sat Apr1 04:20:18 2006
ARCH shutting down
Sat Apr1 04:20:18 2006
ARC0: Archival stopped
Sat Apr1 04:20:18 2006
ARC1: Archival stopped
Sat Apr1 04:20:18 2006
Thread 1 closed at log sequence 25206
Successful close of redo thread 1.
Sat Apr1 04:20:19 2006
Completed: ALTER DATABASE CLOSE NORMAL
Sat Apr1 04:20:19 2006
ALTER DATABASE DISMOUNT
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
Sat Apr1 04:20:23 2006
Errors in file /opt/oracle/db01/app/oracle/admin/ORCL/udump/orcl_ora_12459.trc:
ORA-07445: exception encountered: core dump [0000000100F8DCC8] [SIGSEGV] [Address not mapped to object] [0x000000182] [] []
Sat Apr1 04:20:23 2006
Errors in file /opt/oracle/db01/app/oracle/admin/ORCL/udump/orcl_ora_12461.trc:
ORA-07445: exception encountered: core dump [0000000100F8DCC8] [SIGSEGV] [Address not mapped to object] [0x00000017E] [] []
Sat Apr1 04:20:23 2006
Errors in file /opt/oracle/db01/app/oracle/admin/ORCL/udump/orcl_ora_12463.trc:
ORA-07445: exception encountered: core dump [0000000100F8DCC8] [SIGSEGV] [Address not mapped to object] [0x000000182] [] []
Sat Apr1 04:25:10 2006
Starting ORACLE instance (normal)
Sat Apr1 04:25:10 2006
WARNING: EINVAL creating segment of size 0x0000000121c00000
fix shm parameters in /etc/system or equivalent
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.4.0.
System parameters with non-default values:
processes
= 300
timed_statistics = TRUE
shared_pool_size = 318767104
sga_max_size
= 4841054952
shared_pool_reserved_size= 31457280
large_pool_size
= 67108864
java_pool_size = 67108864
control_files
= /opt/oracle/db02/oradata/ORCL/control01.ctl, /opt/oracle/db04/oradata/ORCL/control03.ctl, /opt/oracle/db03/oradata/ORCL/control02.ctl
db_block_size
= 8192
db_cache_size
= 2684354560
compatible
= 9.2.0
log_archive_start= TRUE
log_archive_dest_1 = location=/opt/oracle/arch/ORCL
log_archive_format = arch_%t_%s.arc
log_buffer
= 8192000
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
instance_name
= ORCL
service_names
= ORCL
job_queue_processes= 4
background_dump_dest = /opt/oracle/db01/app/oracle/admin/ORCL/bdump
user_dump_dest = /opt/oracle/db01/app/oracle/admin/ORCL/udump
core_dump_dest = /opt/oracle/db01/app/oracle/admin/ORCL/cdump
open_links
= 4
sort_area_size = 6553600
sort_area_retained_size= 6553600
db_name
= ORCL
open_cursors
= 1800
os_authent_prefix=
pga_aggregate_target = 268435456
Sat Apr1 04:25:13 2006
Oracle instance running on a system with low open file
descriptor limit. Tune your system to increase this
limit to avoid severe performance degradation.
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=7
RECO started with pid=6
CJQ0 started with pid=8
Sat Apr1 04:25:13 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=10
ARC0: Archival started
ARC1 started with pid=9
Sat Apr1 04:25:13 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Sat Apr1 04:25:13 2006
ARC0: Thread not mounted
Sat Apr1 04:25:13 2006
ARC1: Archival started
ARC1: Thread not mounted
Sat Apr1 04:25:14 2006
WARNING: -------------------------------
WARNING: oradism not set up correctly.
Dynamic ISM can not be locked. Please
setup oradism, or unset sga_max_size.
[diagnostic 0, 16, 10100]
----------------------------------------
Sat Apr1 04:25:14 2006
ALTER DATABASE MOUNT
Sat Apr1 04:25:18 2006
Successful mount of redo thread 1, with mount id 1114342954.
Sat Apr1 04:25:18 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Sat Apr1 04:25:18 2006
ALTER DATABASE OPEN
Sat Apr1 04:25:18 2006
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 25206
Current log# 5 seq# 25206 mem# 0: /opt/oracle/db03/oradata/ORCL/redo05_01.log
Current log# 5 seq# 25206 mem# 1: /opt/oracle/db04/oradata/ORCL/redo05_02.log
Successful open of redo thread 1.
Sat Apr1 04:25:18 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr1 04:25:18 2006
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Apr1 04:25:18 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
启动正常；
trace文件中报错：
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x182, PC: [0
x100f8dcc8, 0000000100F8DCC8]
*** 2004-12-20 22:28:22.278
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [0000000100F8DCC8] [SIGSEGV] [Address not mappe
d to object] [0x000000182] [] []
Current SQL information unavailable - no session.
请各位看看
|
