ORA-00600: internal error code, arguments: [opixrb-4], [1036], [ORA-01036: illegal variable name/num
..............[@more@]RESEARCH
=========
Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
Fixed-Releases: 9208 A203
.
CAUSE DETERMINATION
====================
OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
CAUSE JUSTIFICATION
====================
Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
.
PROPOSED SOLUTION(S)
======================
1.Applying patch 4964703
2.Replacing Bind Variable 'n' with another character. (if you use TOAD,this workaround can't
be accepted becuase this variable is defined in TOAD code.)
PROPOSED SOLUTION JUSTIFICATION(S)
====================================
1. Resolve the issue
2. Workaround the issue
.
SOLUTION / ACTION PLAN
=======================
1. Applying Patch 4964703.
--------------------
Description:ORA-600[OPIXRB-4] [1036] WHEN EXECUTING SELECT STMT WITH BIND VARIABLES
Product: RDBMS Server
RELEASE: 10.2.0.2
Platform: AIX5L Based Systems (64-bit)
Last Updated: 09-OCT-2006
Size: 19K (20245 bytes)
--------------------
2.Replacing Bind Variable 'n' with another character.
=========
Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
Fixed-Releases: 9208 A203
.
CAUSE DETERMINATION
====================
OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
CAUSE JUSTIFICATION
====================
Bug 4964703 OERI[opixrb-4] [1036] from SELECT over DBLINK with trailing :N or :Q bind names
.
PROPOSED SOLUTION(S)
======================
1.Applying patch 4964703
2.Replacing Bind Variable 'n' with another character. (if you use TOAD,this workaround can't
be accepted becuase this variable is defined in TOAD code.)
PROPOSED SOLUTION JUSTIFICATION(S)
====================================
1. Resolve the issue
2. Workaround the issue
.
SOLUTION / ACTION PLAN
=======================
1. Applying Patch 4964703.
--------------------
Description:ORA-600[OPIXRB-4] [1036] WHEN EXECUTING SELECT STMT WITH BIND VARIABLES
Product: RDBMS Server
RELEASE: 10.2.0.2
Platform: AIX5L Based Systems (64-bit)
Last Updated: 09-OCT-2006
Size: 19K (20245 bytes)
--------------------
2.Replacing Bind Variable 'n' with another character.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7318139/viewspace-915936/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [ktsircinfo_num1], [19]Error
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載:ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [729], [4280], [space leak]Error
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ErrorAST
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],ErrorAST
- ORA-00600: internal error code, arguments: [ksuinfos_modact1]ErrorUI
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [2103]錯誤Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250]Error
- ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [Error
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46]Error
- ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [ktecgeb-2], (一)Error