ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [], [], [], [], [
edited Feb 13, 2018 3:40PM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 7 commentsAnswered
Hi,
We are getting ORA-00600 error in our production DB
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [], [], [], [], []
Below query is found trace logs at the time of error
select id from dir_entry where lower(dn) = :1"
this query runs thousands of time in a day and is pretty straightforward.
as per oracle support ora-600 is thrown at the time bind variable is null in the query above
we think this is a bug in oracle and it should not throw ora-600 even if bind variable is null. it should return 0 rows. morever we checked the code and bind variable null doesn't seem possible
0