ORA-600(kollasg:client-side tmp lob)錯誤

客戶11.2.0.3 RAC環境，出現ORA-600[kollasg:client-side tmp lob]錯誤。

[@more@]

錯誤資訊為：

Thu Apr 28 20:54:53 2011
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_31916032.trc (incident=148665):
ORA-00600: 內部錯誤程式碼, 引數: [kollasg:client-side tmp lob], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_148665/orcl1_ora_31916032_i148665.trc
Thu Apr 28 20:54:59 2011
Trace dumping is performing id=[cdmp_20110428205459]
Thu Apr 28 20:54:59 2011
Sweep [inc][148665]: completed
Sweep [inc2][148665]: completed

從錯誤資訊上很容易判斷，問題應該和客戶端處理臨時LOB有關。根據MOS文件ORA-00600 [kollasg:client-side tmp lob] Fetching Row With LOB Column in OCI Application [ID 1418135.1]，在11.1以上版本中，如果讀取一個沒有被初始化過的LOB列，會引發這個600錯誤。

Oracle給出的解決方案是對於空的CLOB，使用EMPTY_CLOB函式對齊進行初始化。