錯誤信息
應(yīng)用包運行時收到報錯信息如下：
ORA-00600: internal error code, arguments: [4450],[kpotx.c],[2866],[],…
ORA-02063: preceding line from DW_JOB_PROD
line ORA-06512: line at ""APP.PKG_JOB_FAST_NEW"" …
ORA-00600報錯一般與Oracle數(shù)據(jù)庫內(nèi)部Bug有關(guān)。注意第一行arguments后面三個方括號中的數(shù)字與信息，可用于確定相關(guān)的數(shù)據(jù)庫Bug。
Bug信息
在MOS上匹配到相關(guān)的Bug信息描述如下：
ORA-00600 [4450] can occur when using autonomous transactions and
multiple database links if the value for open_links was too small.
If you get ORA-00600[4450] at the remote side of a database link, it may be
this bug. Check for traces at the local side and find out if more database
links were potentially being used than the configured value for open_links
(the default value is 4).
經(jīng)確認(rèn)，報錯的應(yīng)用確實使用了大量DBLINK，與該BUG描述的觸發(fā)場景一致。
檢查open_links當(dāng)前值：
--當(dāng)前值為16
SQL> show parameter open_links
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_links integer 16
open_links_per_instance integer 16
應(yīng)對辦法
官方推薦了兩種應(yīng)對辦法。一種是workaround辦法，另一種是升級數(shù)據(jù)庫到版本12.2.0.1。
Workaround:
Increase the value for open_links.
Bug 22114696 - ORA-600 [4450], [kpotx.c], [2866] (Doc ID 22114696.8)
問題數(shù)據(jù)庫版本為11g，沒有升級到12c的計劃。因此這里我們采用workaround，即調(diào)大open_links，將其調(diào)大到100。該參數(shù)調(diào)整后需要重啟數(shù)據(jù)庫。
調(diào)整open_links參數(shù)：文章來源：http://www.zghlxwxcb.cn/news/detail-693230.html
sys@ORA11G> alter system set open_links=100 scope=both;
alter system set open_links=100 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
sys@ORA11G> alter system set open_links=100 scope=spfile;
System altered.
sys@ORA11G> shutdown immediate;
sys@ORA11G> startup;
??OPEN_LINKS參數(shù)含義文章來源地址http://www.zghlxwxcb.cn/news/detail-693230.html
- OPEN_LINKS specifies the maximum number of concurrent open connections to remote databases in one session.
- These connections include database links, as well as external procedures and cartridges, each of which uses a separate process.
到了這里，關(guān)于ORA-00600之?dāng)?shù)據(jù)庫內(nèi)部BUG 22114696的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
![記錄一次ORA-00600 [kdsgrp1]導(dǎo)致的large tracefile的處理過程](https://imgs.yssmx.com/Uploads/2024/02/686357-1.png)
