Solved

Oracle ORA-00600

Posted on 2001-06-19
10
1,639 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
 

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

762 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now