Solved

Oracle ORA-00600

Posted on 2001-06-19
10
1,702 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

623 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