Oracle database abnormal shutdown

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

Started by Moses at November 24, 2016 - 9:52 PM

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







---------------------------------------------------------------
No. QQ: 107644445
BLOG

Posted by Jessie at November 29, 2016 - 10:32 PM

The information you provide is not much, my alert log and trace files, not necessarily the problem above

Posted by Jessie at December 10, 2016 - 10:51 PM

Hello, the problem you QQ mailbox, thank you!

Posted by Moses at December 24, 2016 - 11:01 PM