ORA-04030: out of process memory when trying to allocate bytes (,)

系统环境

Solaris 10 Oracle10.2.0.5

启动数据库报以下错误：

Mon Jul 23 13:17:49 CST 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

[@more@]

IMODE=BR
ILAT =20
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.5.0.
System parameters with non-default values:
processes = 150
sessions = 170
timed_statistics = TRUE
resource_limit = TRUE
sga_max_size = 402653184
pre_page_sga = TRUE
__shared_pool_size = 130023424
__large_pool_size = 4194304
__java_pool_size = 8388608
__streams_pool_size = 50331648
streams_pool_size = 50331648
java_soft_sessionspace_limit= 4194304
java_max_sessionspace_size= 134217728
disk_asynch_io = TRUE
resource_manager_plan = SYSTEM_PLAN
sga_target = 402653184
control_files = /oracle/data1/AFC010C1/control01.dbf, /oracle/data2/AFC010C1/control02.dbf
control_file_record_keep_time= 14
db_block_size = 8192
__db_cache_size = 201326592
db_cache_size = 16777216
db_writer_processes = 1
compatible = 10.2.0
log_archive_format = AFC010C1_%d_%t_%s_%r.log
log_buffer = 6100480
log_checkpoint_interval = 0
log_checkpoint_timeout = 0
db_files = 1024
db_file_multiblock_read_count= 32
cluster_database = FALSE
db_recovery_file_dest = /oracle/flash
db_recovery_file_dest_size= 2147483648
log_checkpoints_to_alert = TRUE
dml_locks = 512
replication_dependency_tracking= FALSE
transactions = 200
undo_management = AUTO
undo_tablespace = UNDOTBS
undo_retention = 20000
db_block_checking = FALSE
_kgl_large_heap_warning_threshold= 83886080
remote_login_passwordfile= NONE
db_domain =
global_names = FALSE
job_queue_processes = 3
cursor_sharing = SIMILAR
background_dump_dest = /app/oracle/admin/AFC010C1/bdump
user_dump_dest = /app/oracle/admin/AFC010C1/udump
max_dump_file_size = 40960
core_dump_dest = /app/oracle/admin/AFC010C1/cdump
session_max_open_files = 20
audit_trail = DB, EXTENDED
sort_area_size = 262144
sort_area_retained_size = 65536
db_name = AFC010C1
db_unique_name = AFC010C1
open_cursors = 300
query_rewrite_enabled = TRUE
query_rewrite_integrity = trusted
pga_aggregate_target = 25165824
statistics_level = TYPICAL
PSP0 started with pid=3, OS id=8388
PMON started with pid=2, OS id=8386
MMAN started with pid=4, OS id=8390
DBW0 started with pid=5, OS id=8392
LGWR started with pid=6, OS id=8394
CKPT started with pid=7, OS id=8396
SMON started with pid=8, OS id=8398
RECO started with pid=9, OS id=8400
CJQ0 started with pid=10, OS id=8402
MMON started with pid=11, OS id=8404
MMNL started with pid=12, OS id=8406
Mon Jul 23 13:18:03 CST 2012
ALTER DATABASE MOUNT
Mon Jul 23 13:18:08 CST 2012
Setting recovery target incarnation to 1
Mon Jul 23 13:18:08 CST 2012
Successful mount of redo thread 1, with mount id 3070722635
Mon Jul 23 13:18:08 CST 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Jul 23 13:18:09 CST 2012
ALTER DATABASE OPEN
Mon Jul 23 13:18:10 CST 2012
Beginning crash recovery of 1 threads
Mon Jul 23 13:18:10 CST 2012
Started redo scan
Mon Jul 23 13:18:10 CST 2012
Completed redo scan
0 redo blocks read, 0 data blocks need recovery
Mon Jul 23 13:18:10 CST 2012
Started redo application at
Thread 1: logseq 22, block 76926, scn 514880
Mon Jul 23 13:18:10 CST 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 22 Reading mem 0
Mem# 0: /oracle/redo1/AFC010C1/redo02a.log
Mem# 1: /oracle/redo2/AFC010C1/redo02b.log
Mon Jul 23 13:18:10 CST 2012
Completed redo application
Mon Jul 23 13:18:10 CST 2012
Completed crash recovery at
Thread 1: logseq 22, block 76926, scn 534881
0 data blocks read, 0 data blocks written, 0 redo blocks read
Mon Jul 23 13:18:11 CST 2012
LGWR: STARTING ARCH PROCESSES
Process ARC0 died, see its trace file
Mon Jul 23 13:18:15 CST 2012
Errors in file /app/oracle/admin/AFC010C1/bdump/afc010c1_lgwr_8394.trc:
ORA-00444: background process "ARC0" failed while starting
ORA-04030: out of process memory when trying to allocate bytes (,)
Process ARC1 died, see its trace file
Mon Jul 23 13:18:20 CST 2012
Errors in file /app/oracle/admin/AFC010C1/bdump/afc010c1_lgwr_8394.trc:
ORA-00444: background process "ARC1" failed while starting
ORA-04030: out of process memory when trying to allocate bytes (,)
LGWR: Detected ARCH process failure
LGWR: Detected ARCH process failure
LGWR: STARTING ARCH PROCESSES COMPLETE
Mon Jul 23 13:18:20 CST 2012
Thread 1 advanced to log sequence 23 (thread open)
Thread 1 opened at log sequence 23
Current log# 3 seq# 23 mem# 0: /oracle/redo1/AFC010C1/redo03a.log
Current log# 3 seq# 23 mem# 1: /oracle/redo2/AFC010C1/redo03b.log
Successful open of redo thread 1
Mon Jul 23 13:18:20 CST 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jul 23 13:18:20 CST 2012
SMON: enabling cache recovery
Mon Jul 23 13:18:21 CST 2012
ARCH: STARTING ARCH PROCESSES
Mon Jul 23 13:18:26 CST 2012
Errors in file /app/oracle/admin/AFC010C1/bdump/afc010c1_arc0_8414.trc:
ORA-07445: exception encountered: core dump [ksmpgd_scan_pga_heaps_local_detail()+11] [SIGSEGV] [Address not mapped to object] [0xFFFFFD7FFFDE5BF0] [] []
Mon Jul 23 13:18:30 CST 2012
Successfully onlined Undo Tablespace 1.
Mon Jul 23 13:18:30 CST 2012
SMON: enabling tx recovery
Mon Jul 23 13:18:31 CST 2012
Database Characterset is AL32UTF8
Mon Jul 23 13:18:33 CST 2012
Errors in file /app/oracle/admin/AFC010C1/bdump/afc010c1_smon_8398.trc:
ORA-07445: exception encountered: core dump [kghalo()+15] [SIGSEGV] [Address not mapped to object] [0xFFFFFD7FFFDF4FF8] [] []
Mon Jul 23 13:18:34 CST 2012
Errors in file /app/oracle/admin/AFC010C1/udump/afc010c1_ora_8408.trc:
ORA-00600: internal error code, arguments: [ksnpost:ksnigb], [], [], [], [], [], [], []
Mon Jul 23 13:18:35 CST 2012
Errors in file /app/oracle/admin/AFC010C1/udump/afc010c1_ora_8408.trc:
ORA-00600: internal error code, arguments: [ksnpost:ksnigb], [], [], [], [], [], [], []
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 8408
ORA-1092 signalled during: ALTER DATABASE OPEN...

原因：内存分配不够，系统没有足够的内存可以让oracle实例分配。

解决方案：因为是在虚拟机上，重启虚拟机，将内存设置更大，然后打开oracle，一切正常。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24870090/viewspace-1058995/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24870090/viewspace-1058995/