• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1746
  • Last Modified:

Oracle ORA-00600

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
ezree
Asked:
ezree
  • 3
  • 2
  • 2
  • +3
1 Solution
 
jtriftsMI and AutomationCommented:
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
 
ezreeAuthor Commented:
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
 
myerpzCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
slvrbullet420Commented:
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
 
UsamaMunirCommented:
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
 
MindphaserCommented:
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
 
jtriftsMI and AutomationCommented:
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
 
ezreeAuthor Commented:
jtrifts
   How to split points among contributors?
0
 
MindphaserCommented:
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
 
jtriftsMI and AutomationCommented:
ezree,
mindphaser will take care of it.
JT
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now