oracle数据库异常关闭

[lbhwwj]

Thu Sep 26 09:02:07 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_676.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D61141D] [ADDR:0x63005E] [UNABLE_TO_WRITE] []

Thu Sep 26 09:02:08 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_676.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D61141D] [ADDR:0x63005E] [UNABLE_TO_WRITE] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D61141D] [ADDR:0x63005E] [UNABLE_TO_WRITE] []

Thu Sep 26 09:03:04 2013
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_676.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D61141D] [ADDR:0x63005E] [UNABLE_TO_WRITE] []

Dump file d:\oracle\product\10.2.0\admin\orcl\bdump\alert_orcl.log
Thu Sep 26 09:05:16 2013
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:23345M/24575M, Ph+PgF:25340M/25844M, VA:3966M/4095M
Thu Sep 26 09:05:16 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =145
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.3.0.
System parameters with non-default values:
processes = 1200
__shared_pool_size = 452984832
__large_pool_size = 8388608
__java_pool_size = 8388608
__streams_pool_size = 0
sga_target = 2147483648
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 1669332992
compatible = 10.2.0.3.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 1073741824
Thu Sep 26 09:05:19 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Sep 26 09:05:19 2013
starting up 1 shared server(s) ...
Dump file d:\oracle\product\10.2.0\admin\orcl\bdump\alert_orcl.log
Thu Sep 26 09:32:13 2013
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:23322M/24575M, Ph+PgF:25330M/25844M, VA:3966M/4095M

[lbhwwj]

您好，问题发你QQ邮箱了，谢谢！

[惜分飞]

APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 and later Generic Windows ***Checked for relevance on 26-Apr-2013*** SYMPTOMS The following errors can be seen in alert.log: ORA-07445: exception encountered : core dump [ACCESS_VIOLATION] [kpudcr2c+89] [PC:0x100CD3D1] [ADDR:0x19EC0000] [UNABLE_TO_WRITE] [] ORA-07445: exception encountered : core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x5A1113A] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] ORA-27300: OS system dependent operation:WaitForSingleObject failed with status: 0 ORA-27301: OS failure message: The operation completed successfully. ORA-27302: failure occurred at: sssxcpttcs5 CAUSE The error ORA-07445: exception encountered : core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x5A1113A] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ] is typical for a Windows out of memory issue and is commonly seen when INIT.ORA parameters are set to that of the DBCA starter DB. The problem appears as likely on 64-bit platforms as on 32-bit. SOLUTION 1. Please refer to Note 342443.1 and apply latest Windows patch bundle. 2. Have sufficient physical memory on the server so that you can allocate more SGA/PGA to the database. Increase SGA_MAX_SIZE and SGA_TARGET so that you can accommodate SGA pools. Restart the instance. Increase INIT.ORA memory parameters and make sure following pools are set to recommended value i.e. 200M. SHARED_POOL_SIZE JAVA_POOL_SIZE STREAMS_POOL_SIZE --------------------------------------------------------------- qq号：107644445 BLOG：http://www.xifenfei.com

[惜分飞]

你提供的信息不多，发我alert日志和trace文件，不一定是上面问题