遭遇ORA-07445[ACCESS_VIOLATION][unable_to_trans_pc

像平常一樣，準(zhǔn)備啟動自己機(jī)器上的測試數(shù)據(jù)庫看點(diǎn)東西，net start oracleservicening，正常，sqlplus以sysdba登入，奇怪，這次怎么10秒了還沒反映，嗯，機(jī)器 不好，先做點(diǎn)別的事情吧。 幾分鐘后再來看看，還是掛起在那里，不對勁，第一反應(yīng)，看alert，果然有

像平常一樣，準(zhǔn)備啟動自己機(jī)器上的測試數(shù)據(jù)庫看點(diǎn)東西，net start oracleservicening，正常，sqlplus以sysdba登入，奇怪，這次怎么10秒了還沒反映，嗯，機(jī)器不好，先做點(diǎn)別的事情吧。

幾分鐘后再來看看，還是掛起在那里，不對勁，第一反應(yīng)，看alert，果然有機(jī)關(guān)：

PMON started with pid=2, OS id=404
PSP0 started with pid=3, OS id=888
MMAN started with pid=4, OS id=3628
DBW0 started with pid=5, OS id=148
LGWR started with pid=6, OS id=3944
CKPT started with pid=7, OS id=252
SMON started with pid=8, OS id=2336
RECO started with pid=9, OS id=2452
CJQ0 started with pid=10, OS id=3772
MMON started with pid=11, OS id=3728
MMNL started with pid=12, OS id=3204
Fri Mar 16 09:09:47 2007
Errors in file e:oracleora10adminningudumpning_ora_3848.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x77E7FA69] [ADDR:0x7D42] [UNABLE_TO_WRITE] []

暈，一直好好的，怎么突然出07445錯誤了，而且google，metalink轉(zhuǎn)了一遍，也沒發(fā)現(xiàn)什么有價值的地方。回想之前，唯一的改動好像是將

buffer cache調(diào)小了點(diǎn)，內(nèi)存不夠用，沒辦法。alert再往前看看

__db_cache_size = 41943040
db_cache_size = 41943040

嗯，只有40M，記得之前好像是48M，一直用的spfile，之前也沒有保存pfile，只有先startup nomout，然后create pfile from spfile來生成一個了。

停止服務(wù)，修改注冊表，將啟動服務(wù)時自動startup數(shù)據(jù)庫的選項(xiàng)改為false，然后重新啟動服務(wù)

C:>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Mar 16 09:15:04 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

@>conn / as sysdba
Connected to an idle instance.

SYS@ning>startup nomount;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

我暈，這招不靈光，根本instance都起不來，也對，如果是內(nèi)存參數(shù)有問題，起不來也正常。看來不能偷懶，還是利用alert里面記錄的非默認(rèn)參數(shù)自己弄一個pfile了，alert真是信息豐富啊:)

System parameters with non-default values:
processes = 150
__shared_pool_size = 83886080
shared_pool_size = 83886080
large_pool_size = 0
java_pool_size = 0
control_files = E:ORACLEORADATANINGCONTROL01.CTL, E:ORACLEORADATANINGCONTROL02.CTL,

E:ORACLEORADATANINGCONTROL03.CTL
db_block_size = 8192
__db_cache_size = 41943040
db_cache_size = 41943040
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
dml_locks = 2
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
job_queue_processes = 10
audit_file_dest = E:ORACLEORA10ADMINNINGADUMP
background_dump_dest = E:ORACLEORA10ADMINNINGBDUMP
user_dump_dest = E:ORACLEORA10ADMINNINGUDUMP
core_dump_dest = E:ORACLEORA10ADMINNINGCDUMP
db_name = ning
open_cursors = 300
pga_aggregate_target = 95420416

SYS@ning>startup nomount pfile='d:initning.ora';
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

偶分特，還不行。這次alert里面還報了一堆沒有參數(shù)的額07445了
Fri Mar 16 09:53:54 2007
Errors in file e:oracleora10adminningudumpning_ora_3812.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C911F52] [ADDR:0x6C63616F]

[UNABLE_TO_READ] []
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C911F52] [ADDR:0x6C63616F]

[UNABLE_TO_READ] []

嗯，不好意思，剛才好像只改了db_cache_size，忘記改__db_cache_size了，再來

SYS@ning>startup nomount pfile='d:initning.ora';
ORACLE instance started.

Total System Global Area 142606336 bytes
Fixed Size 1289340 bytes
Variable Size 83886980 bytes
Database Buffers 50331648 bytes
Redo Buffers 7098368 bytes

SYS@ning>alter database mount;

Database altered.

SYS@ning>alter database open;

Database altered.

終于起來了，哎，不過將buffer cache改小了8M，至于弄個07445的錯誤來嚇我么。

重新生成spfile

SYS@ning>create spfile from pfile;

File created.

不過這也告訴我們，生產(chǎn)庫上的參數(shù)，如果沒有經(jīng)過充分測試，千萬不要隨便亂改，尤其是一些高危參數(shù)，比如內(nèi)存大小啊，cursor_sharing啊什么的。并且做任何改變之前，先做好文檔記錄，萬一有問題，還能追查到出問題之前對于系統(tǒng)的改動情況，這個對于排錯是有相當(dāng)大的幫助的。

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com