Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle ORA-00600

Posted on 2001-06-19
10
Medium Priority
?
1,734 Views
Last Modified: 2012-06-27
To all the experts out there
I'm trying to refresh our old stored procedure, so I've tried to drop the old stored procedure from within sqlplus but I've got error

---------------------------------
SQL> DROP PACKAGE BODY lfep.recon
  2  ;
DROP PACKAGE BODY lfep.recon
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcfnew_2], [4], [81290], [10240], [10240], [], [], []
----------------------------------

Does anyone knows how to solve this problem?

ps : I'm using Oracle 8.1.5 on AIX 4.3.3


Thanks in advance



Yours Truly
Ezree
0
Comment
Question by:ezree
  • 3
  • 2
  • 2
  • +3
10 Comments
 
LVL 4

Expert Comment

by:jtrifts
ID: 6205616
Is lfep the schema?  If so, try dropping without the schema name when you drop the package.

Alternatively, I have seen occassions where a package was actually created with mixed case, and only a drop command with the correct (mixed) case could drop it.

Additionally, the 0600 error is an ugly one.  Whenver I have experienced this I have logged out of all my sessions, and rebooted.  This has usually solved the problem. (If you check, the 0600 error is the one where you're supposed to call ORacle support with a book full of system information).

Presumably your user is either the schema owner or has the privs to perform this function...(?)

JT
0
 

Author Comment

by:ezree
ID: 6209852
JT thanks for your respond but it doesn't work

1) I've tried dropping without the schema name - still same error
2) I've tried stop and start the Oracle Server - still same error
3) I've rebooted the server (OS level) - still same error

Do you have any more ideas. Thanks again

Ezree
0
 
LVL 3

Expert Comment

by:myerpz
ID: 6210675
was the package created ok, then something happened ( e.g. a table was dropped ) which left the package invalid ?

could you check the status of the procedure ...
select object_name, status
from   user_objects
where  object_type = 'PACKAGE BODY'
and    object_name = 'RECON'
/

If it is invalid, then look at the objects etc referenced by the package, fix those, re-create the package body ( using "create or replace package body" ) then try to drop it again.

It's a long shot I know, but it might be worth a try.

Good luck
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

Expert Comment

by:slvrbullet420
ID: 6229090
not much help, but here's Oracle's info on ORA-00600:

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

Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:

timeouts

file corruption

failed data checks in memory

hardware, memory, or I/O errors

incorrectly restored files

The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.
0
 
LVL 3

Expert Comment

by:UsamaMunir
ID: 6272339
Hi
Well all internal Errors are reported in the Alert file of ur Oracle Server, check ur alert file for more details and any additional trace files will also be mentioned there, u can use them for ur utility, tell me more about what the trace file says and i can tell u more.

Regards
Usama!
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7036090
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
LVL 4

Expert Comment

by:jtrifts
ID: 7036589
I'd suggest either delete the question or split points amongst contributors.  All suggestions were reasonable, though it appears in this case the suggestions did not work for the questioner.
regards,
JT
0
 

Author Comment

by:ezree
ID: 7038154
jtrifts
   How to split points among contributors?
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 7046075
Sorry, splitting a few points between so many people is too much work. Since ezree didn't accept any answer I moved the question to PAQ

** Mindphaser - Community Support Moderator **
0
 
LVL 4

Expert Comment

by:jtrifts
ID: 7047026
ezree,
mindphaser will take care of it.
JT
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question