ORA-600(kssadd: null parent)錯誤

Oracle 11.1.0.6資料庫在歸檔到遠端例項時出現這個錯誤。

[@more@]

詳細錯誤資訊為：

Wed Dec 26 12:39:20 2012
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Errors in file /oracle/app/diag/rdbms/orcl/orcl1/trace/orcl1_arc2_533302.trc:
ORA-16191: 主日誌傳送客戶機沒有登入到備用資料庫
PING[ARC2]: Heartbeat failed to connect to standby 'orcl2'. Error is 16191.
Wed Dec 26 12:43:05 2012
Errors in file /oracle/app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_455450.trc (incident=852209):
ORA-00600: 內部錯誤程式碼, 引數: [kssadd: null parent], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/orcl/orcl1/incident/incdir_852209/orcl1_ora_455450_i852209.trc
Wed Dec 26 12:43:07 2012
Trace dumping is performing id=[cdmp_20121226124307]
Wed Dec 26 12:43:08 2012
Sweep Incident[852209]: completed
Wed Dec 26 12:43:12 2012
Errors in file /oracle/app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_1827082.trc (incident=852210):
ORA-00600: 內部錯誤程式碼, 引數: [kssadd: null parent], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/orcl/orcl1/incident/incdir_852210/orcl1_ora_1827082_i852210.trc
Trace dumping is performing id=[cdmp_20121226124314]
Wed Dec 26 12:43:22 2012
Errors in file /oracle/app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_1426102.trc (incident=852211):
ORA-00600: 內部錯誤程式碼, 引數: [kssadd: null parent], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/orcl/orcl1/incident/incdir_852211/orcl1_ora_1426102_i852211.trc
Wed Dec 26 12:43:25 2012
Trace dumping is performing id=[cdmp_20121226124325]
Wed Dec 26 12:44:09 2012
Sweep Incident[852211]: completed
Sweep Incident[852210]: completed

很遺憾，沒有拿到客戶的相關TRACE檔案。因此無法確認出現ORA-600錯誤時，具體引發錯誤的語句以及堆疊資訊。根據MOS的查詢結果，這個kssadd: null parent的相關錯誤，只有一個和JOB相關的，雖然確認影響版本為11.1.0.7，很符合當前問題的版本，但是報錯並未發生在JOB程式或CJQ程式上。

而從這個報錯資訊的發生來看，這個錯誤的出現與ORA-16191錯誤直接相關。這個600錯誤的出現都是在ORA-16191大量產生後出現的，而隨著ORA-16191錯誤的被最終解決，該錯誤也沒有再次出現。基本上可以確定，ORA-16191是這個ORA-600[kssadd: null parent]錯誤產生的一個誘因。

最後簡單說明一下ORA-16191錯誤，導致這個問題的原因是主庫修改了SYS的密碼，導致主庫歸檔到本庫時密碼不正確。在11g的情況下，如果開啟了SEC_CASE_SENSITIVE_LOGON引數，那麼有時即使複製了密碼檔案到目標資料庫，報錯依舊。將SEC_CASE_SENSITIVE_LOGON置為false，可以避免這個錯誤。