Skip to main content

Posts

Showing posts from November 27, 2014

ORA-00600: internal error code, arguments: [7005],

Hi all, Today i am going to write another one of mine analysis by using My oracle support site document. In one of our client's database, we are getting the following error message continuously. Alert log entry: Wed Jul 23 11:45:43 2014 Errors in file /home/oracle/app/oracle/diag/rdbms/db/db/trace/db_ora_14547.trc  (incident=149824): ORA-00600: internal error code, arguments: [7005], [0], [], [], [], [], [], [], [], [], [], [] SQL_TEXT involved in this error is  select iso_country_code  from countries  where (SDO_RELATE(geom,SDO_GEOMETRY(:"SYS_B_0",:"SYS_B_1"),:"SYS_B_2")=:"SYS_B_3") So one of our dba has reported like below after searching the document for the error. According to Doc ID 138935.1 The error occurred due to Bug 8770557 Description: ORA-600 [7005] from SQL with user defined selectivity function (eg: Text queries) Solution: The issue is fixed in 11.2.0.2, 12.1.0.1 But o