\u8fd9\u4e2abug\u6bd4\u8f83\u795e\u5947\uff0c\u5982\u679cSGA\u8bbe\u7f6e\u4e3a4G\u7684\u6574\u6570\u500d\uff0c\u5c31\u4f1a\u5bfc\u81f4\u7cfb\u7edfCRASH\u3002\u4ee5\u524d\u542c\u8bf4\u8fc7\u8fd9\u4e2abug\uff0c\u8fd9\u6b21\u8fd8\u662f\u7b2c\u4e00\u6b21\u78b0\u5230\u3002<\/p>\n
\u8be6\u7ec6\u7684\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n
<pre lang=’SQL’>Tue Oct 11 10:44:34 2011<\/p>\n
Starting ORACLE instance (normal)<\/p>\n
Tue Oct 11 10:44:34 2011<\/p>\n
Specified value of sga_max_size is too small, bumping to 12884901888<\/p>\n
LICENSE_MAX_SESSION = 0<\/p>\n
LICENSE_SESSIONS_WARNING = 0<\/p>\n
Picked latch-free SCN scheme 3<\/p>\n
Autotune of undo retention is turned on.<\/p>\n
IMODE=BR<\/p>\n
ILAT =61<\/p>\n
LICENSE_MAX_USERS = 0<\/p>\n
SYS auditing is disabled<\/p>\n
ksdpec: called for event 13740 prior to event group initialization<\/p>\n
Starting up ORACLE RDBMS Version: 10.2.0.3.0.<\/p>\n
System parameters with non-default values:<\/p>\n
processes = 500<\/p>\n
sga_max_size = 12884901888<\/p>\n
lock_sga = FALSE<\/p>\n
__shared_pool_size = 570425344<\/p>\n
shared_pool_size = 536870912<\/p>\n
__large_pool_size = 134217728<\/p>\n
large_pool_size = 134217728<\/p>\n
__java_pool_size = 33554432<\/p>\n
java_pool_size = 33554432<\/p>\n
__streams_pool_size = 0<\/p>\n
streams_pool_size = 0<\/p>\n
sga_target = 12884901888<\/p>\n
control_files = \/dev\/rcontrol01, \/dev\/rcontrol02, \/dev\/rcontrol03<\/p>\n
db_file_name_convert = \/dev\/, \/dev\/<\/p>\n
log_file_name_convert = \/dev\/, \/dev\/<\/p>\n
db_block_size = 8192<\/p>\n
__db_cache_size = 12129927168<\/p>\n
db_cache_size = 2147483648<\/p>\n
compatible = 10.2.0.3.0<\/p>\n
log_archive_config = DG_CONFIG=(oradb,orapri)<\/p>\n
log_archive_dest_1 = location=\/oraarch<\/p>\n
log_archive_dest_2 = service=oradb lgwr async
\nvalid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=oradb<\/p>\n
log_archive_dest_state_1 = enable<\/p>\n
log_archive_dest_state_2 = enable<\/p>\n
log_archive_max_processes= 3<\/p>\n
fal_client = orapri<\/p>\n
fal_server = oradb<\/p>\n
log_buffer = 14234624<\/p>\n
db_file_multiblock_read_count= 64<\/p>\n
db_recovery_file_dest =<\/p>\n
db_recovery_file_dest_size= 107374182400<\/p>\n
standby_file_management = AUTO<\/p>\n
fast_start_mttr_target = 300<\/p>\n
db_flashback_retention_target= 4320<\/p>\n
undo_management = AUTO<\/p>\n
undo_tablespace = UNDOTBS1<\/p>\n
undo_retention = 3600<\/p>\n
remote_login_passwordfile= EXCLUSIVE<\/p>\n
db_domain =<\/p>\n
utl_file_dir = \/oracle<\/p>\n
job_queue_processes = 0<\/p>\n
background_dump_dest = \/oracle\/admin\/oradb\/bdump<\/p>\n
user_dump_dest = \/oracle\/admin\/oradb\/udump<\/p>\n
core_dump_dest = \/oracle\/admin\/oradb\/cdump<\/p>\n
audit_file_dest = \/oracle\/admin\/oradb\/adump<\/p>\n
sort_area_size = 1048576<\/p>\n
db_name = oradb<\/p>\n
db_unique_name = orapri<\/p>\n
open_cursors = 300<\/p>\n
_b_tree_bitmap_plans = FALSE<\/p>\n
optimizer_index_cost_adj = 10<\/p>\n
pga_aggregate_target = 2147483648<\/p>\n
PMON started with pid=2, OS id=16121944<\/p>\n
PSP0 started with pid=3, OS id=14286974<\/p>\n
MMAN started with pid=4, OS id=11141216<\/p>\n
DBW0 started with pid=5, OS id=14418082<\/p>\n
DBW1 started with pid=6, OS id=14155834<\/p>\n
DBW2 started with pid=7, OS id=11862130<\/p>\n
LGWR started with pid=8, OS id=13828256<\/p>\n
CKPT started with pid=9, OS id=14024704<\/p>\n
SMON started with pid=10, OS id=12451932<\/p>\n
RECO started with pid=11, OS id=15073406<\/p>\n
MMON started with pid=12, OS id=12582914<\/p>\n
MMNL started with pid=13, OS id=12517546<\/p>\n
Tue Oct 11 10:45:03 2011<\/p>\n
Errors in file \/oracle\/admin\/oradb\/bdump\/oradb_mman_11141216.trc:<\/p>\n
ORA-00600: internal error code, arguments: [kmgs_pre_process_request_6], [6],
\n[723], [128], [3], [0x70000030630E608], [], []<\/p>\n
Tue Oct 11 10:45:04 2011<\/p>\n
Errors in file \/oracle\/admin\/oradb\/bdump\/oradb_mman_11141216.trc:<\/p>\n
ORA-00600: internal error code, arguments: [kmgs_pre_process_request_6], [6],
\n[723], [128], [3], [0x70000030630E608], [], []<\/p>\n
Tue Oct 11 10:45:04 2011<\/p>\n
MMAN: terminating instance due to error 822<\/p>\n
Instance terminated by MMAN, pid = 11141216<\/pre><\/p>\n
Oracle\u6570\u636e\u5e93\u91cd\u542f\u540e\u8fd8\u6ca1\u6709\u505a\u4efb\u4f55\u7684\u64cd\u4f5c\uff0c\u5c31\u88abmman\u8fdb\u7a0b\u4e2d\u6b62\u4e86\u3002\u663e\u7136\u8fd9\u65f6Oracle\u81ea\u5df1\u7684\u95ee\u9898\uff0c\u800c\u4e0e\u5e94\u7528\u65e0\u5173\u3002<\/p>\n
\u5728metalink\u4e0a\u5bf9\u5e94\u7684\u6587\u6863\u4e3aMMON Terminates Instance With ORA-600 [kmgs_pre_process_request_6]
\nor ORA-600 [kmgs_update_target_size_1] When Resizing Caches [ID 373802.1]\uff0c\u8fd9\u4e2a\u9519\u8bef\u5f71\u54cd\u7684\u7248\u672c\u662f10.2.0.1\u523010.2.0.3\uff0c\u800c\u5f53\u524d\u6b63\u662f10.2.0.3\u8fd9\u4e2a\u7248\u672c\u3002<\/p>\n
\u6b63\u5982\u6587\u7ae0\u5f00\u5934\u63d0\u5230\u7684\uff0c\u5f53SGA_TARGET\u662f4G\u7684\u6574\u6570\u500d\u65f6\uff0c\u5c31\u4f1a\u5f15\u53d1\u8fd9\u4e2a\u95ee\u9898\u3002\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u5012\u662f\u4e0d\u590d\u6742\uff0c\u9664\u4e86\u5347\u7ea7\u523010.2.0.4\u4ee5\u4e0a\u7248\u672c\u6216\u8005\u6253Bug:4433838\u5bf9\u5e94\u7684patch\u5916\uff0c\u7a0d\u5fae\u8c03\u6574\u4e00\u4e0bSGA\u7684\u5927\u5c0f\uff0c\u5c31\u53ef\u4ee5\u907f\u514d\u8fd9\u4e2a\u9519\u8bef\u7684\u4ea7\u751f\u3002<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8fd9\u4e2abug\u6bd4\u8f83\u795e\u5947\uff0c\u5982\u679cSGA\u8bbe\u7f6e\u4e3a4G\u7684\u6574\u6570\u500d\uff0c\u5c31\u4f1a\u5bfc\u81f4\u7cfb\u7edfCRASH\u3002\u4ee5\u524d\u542c\u8bf4\u8fc7\u8fd9\u4e2abug\uff0c\u8fd9\u6b21\u8fd8\u662f\u7b2c\u4e00\u6b21\u78b0\u5230\u3002 \u8be6\u7ec6\u7684\u9519\u8bef\u5982\u4e0b\uff1a <pre lang=’SQL’>Tue Oct 11 10:44:34 2011 Starting ORACLE instance (normal) Tue Oct 11 10:44:34 2011 Specified value of sga_max_size is too small, bumping to 12884901888 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Autotune of … Continue reading