Home » SQL & PL/SQL » SQL & PL/SQL » internal error code (10g,xp)
internal error code [message #438653] Mon, 11 January 2010 07:44 Go to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
I am getting this error
Any ideas
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [],
[], []
ORA-06512: at "XXMITG.XX_REPORTS_PKG", line 2886
ORA-06512: at line 2
Re: internal error code [message #438655 is a reply to message #438653] Mon, 11 January 2010 07:51 Go to previous messageGo to next message
Littlefoot
Messages: 20825
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORA-00600 is usually bad news ("Call Oracle Support"). However, what's written in (around) line 2886 in that package?
Re: internal error code [message #438658 is a reply to message #438655] Mon, 11 January 2010 08:04 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
Bad exception block
WHEN OTHERS THEN 
RAISE;


Sorry I did not wrote the code,trying to run after removing that.
Re: internal error code [message #438663 is a reply to message #438655] Mon, 11 January 2010 08:55 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
The query is a connect by query and
http://forums.oracle.com/forums/thread.jspa?threadID=676727
thread helped me
the second action is working fine for me
SQL> set linesize 2000
SQL> @ r1
  WITH x AS (
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [], [], []


SQL> alter session set "_optimizer_connect_by_cost_based"=false;

Session altered.

SQL> @ r1

DEPL_PACKAGE_NUMBER DEPL_PACKAGE_LINE DEPL_PACKAGE_SEQ OBJECT_REVISION                                  
------------------- ----------------- ---------------- ---------------------------------------------
              44748             86448                1 126422                                           

SQL>
Re: internal error code [message #438720 is a reply to message #438663] Mon, 11 January 2010 23:42 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks for the link..

Sriram Smile

[Updated on: Mon, 11 January 2010 23:42]

Report message to a moderator

Re: internal error code [message #438760 is a reply to message #438720] Tue, 12 January 2010 01:53 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Isn't that an internal parameter (starting with an underscore) you're changing? I don't know whether that is such a brilliant idea without consulting Oracle support... .

MHE
Re: internal error code [message #438762 is a reply to message #438760] Tue, 12 January 2010 02:10 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
_optimizer_connect_by_cost_based

NOTE: This is an internal Oracle parameter. Do NOT use it unless instructed to do so by Oracle Support. Playing with this parameter may be harmful.
Re: internal error code [message #438764 is a reply to message #438762] Tue, 12 January 2010 02:29 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes its not advisable,,But Have a look at this..

And even Quote:
After searching on metalink,

We could find two workarounds -

1. Use a /*+no_unnest*/ hint, but this may have perfomance implications.
2. alter session set "_optimizer_connect_by_cost_based"=false;





sriram Smile
Re: internal error code [message #438765 is a reply to message #438762] Tue, 12 January 2010 02:30 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
Thanks Guys
Its strange as the query runs fine on another db with same version.Will call Oracle Support.
Re: internal error code [message #439208 is a reply to message #438765] Thu, 14 January 2010 22:57 Go to previous message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
SQL> select banner from v$version
  2  /

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> select 1 from 
  2  sys.table_privileges tp, user_objects uo 
  3  where tp.grantee in 
  4  (select 1 from 
  5  sys.dba_role_privs connect by prior granted_role=grantee start with 
  6  grantee ='scott')
  7  /
sys.table_privileges tp, user_objects uo
             *
ERROR at line 2:
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [],
[], []


Oracle has a patch for this bug but only for Solaris 64-bit platform(for 10.2.0.4). Also Oracle says that this bug is fixed in 10.2.0.5 & starting from 11.1.0.7. We have got 10.2.0.4 version.We can update our database to 10.2.0.5 version (anyway we should do this some when) or use workaround provided by Oracle:

1. Use a /*+no_unnest*/ hint, but this may have perfomance implications.
2. alter session set "_optimizer_connect_by_cost_based"=false;

The second workaround is preferable because the first one may have performance implications.

[Updated on: Thu, 14 January 2010 23:10]

Report message to a moderator

Previous Topic: procedure inside transaction
Next Topic: Server with two IP Address (SAN, LAN)
Goto Forum:
  


Current Time: Sun Sep 25 21:29:10 CDT 2016

Total time taken to generate the page: 0.11841 seconds