Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle ORA-00600

Posted on 2001-06-19
10
Medium Priority
?
1,720 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

704 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