OraFAQ Forum: Server Administration » Error In Drop Package

Home » RDBMS Server » Server Administration » Error In Drop Package (Oracle DB 11g, Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error In Drop Package [message #520113]

Thu, 18 August 2011 12:25

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

i have a problem while i drop a database package
SQL>drop package dd;
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],
[], [], [], [], []
Could anyone help me to solve that?
thank you alot;
the attached file is the trace file:

Attachment: chdb_ora_4360_i308698 - Copy.txt
(Size: 864.25KB, Downloaded 3923 times)

[Updated on: Thu, 18 August 2011 12:29]

Report message to a moderator

Re: Error In Drop Package [message #520114 is a reply to message #520113]

Thu, 18 August 2011 12:32

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

Even I try to drop the user but its fail, the same error is shown,
...

Report message to a moderator

Re: Error In Drop Package [message #520115 is a reply to message #520114]

Thu, 18 August 2011 12:33

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

When i run that:
dbms_utility.validate('CHYSERP', 'CHICM_PKG', namespace=>2);
the error is:
ORA-00600: internal error code, arguments: [6749], [3], [4277677], [0], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_UTILITY", line 1272
ORA-06512: at line 2

Report message to a moderator

Re: Error In Drop Package [message #520118 is a reply to message #520115]

Thu, 18 August 2011 12:53

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

Regards
Michel

Report message to a moderator

Re: Error In Drop Package [message #520121 is a reply to message #520118]

Thu, 18 August 2011 13:09

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

i dont have an account in Oracle support,
i am developing this project as a research for study,
the trace file i have attached at first post,
please help me,
i want to drop that package even by drop the user,

Report message to a moderator

Re: Error In Drop Package [message #520123 is a reply to message #520121]

Thu, 18 August 2011 13:14

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

by doing some google search i have met some cases, one of that lead me to find out a problem in sys.DEPENDENCY$ table,
when i analyze the table the error is accoured,
SQL>analyze table DEPENDENCY$ validate structure cascade;
--------------------
end_of_block_dump
kdgDump: tsn=0 tabn=0
Current Row Piece: rdba=0x00413cce slot=2
Head Row Piece: rdba=0x00413cce slot=2
kdgDumpRedo: dump redo on table/index mismatch:
table block tsn=0 rdba=0x00413cce index objn=107
head rowid 0x00413cce.0002
--------------------

Report message to a moderator

Re: Error In Drop Package [message #520124 is a reply to message #520121]

Thu, 18 August 2011 13:16

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So nobody can help you without breaking his contract with Oracle.
Recreate your database.

Regards
Michel

[Updated on: Thu, 18 August 2011 13:16]

Report message to a moderator

Re: Error In Drop Package [message #520125 is a reply to message #520124]

Thu, 18 August 2011 13:20

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

which is? "contract with Oracle"

Report message to a moderator

Re: Error In Drop Package [message #520126 is a reply to message #520125]

Thu, 18 August 2011 13:21

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

ok, how to recreate the database, by minimum lose of current data?

Report message to a moderator

Re: Error In Drop Package [message #520129 is a reply to message #520126]

Thu, 18 August 2011 13:28

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

is there any helpful scripts in RDBMS/ADMIN folder?
thank u again for your time,

Report message to a moderator

Re: Error In Drop Package [message #520135 is a reply to message #520129]

Thu, 18 August 2011 13:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ok, how to recreate the database, by minimum lose of current data?
answer depends upon what you have done with regards to previous backups

Report message to a moderator

Re: Error In Drop Package [message #520137 is a reply to message #520126]

Thu, 18 August 2011 14:01

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

jhora wrote on Thu, 18 August 2011 20:21

ok, how to recreate the database, by minimum lose of current data?

Export/recreate database/import.

Regards
Michel

Report message to a moderator

Re: Error In Drop Package [message #520139 is a reply to message #520137]

Thu, 18 August 2011 14:14

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

exp/imp, for only the corrupted schema or full database??
thank u again,

Report message to a moderator

Re: Error In Drop Package [message #520141 is a reply to message #520139]

Thu, 18 August 2011 14:41

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Who say there is only one schema corruption? It may be Oracle dictionary corruption or something else.
So export all (customer) schemas you will then import in a new database.

Regards
Michel

Report message to a moderator

Re: Error In Drop Package [message #520143 is a reply to message #520141]

Thu, 18 August 2011 14:43

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can also try to recover the database to a previous time and check if you can do what you want.

Regards
Michel

Report message to a moderator

Re: Error In Drop Package [message #520144 is a reply to message #520143]

Thu, 18 August 2011 14:51

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

how to recover the database to a previous time?

Report message to a moderator

Re: Error In Drop Package [message #520145 is a reply to message #520144]

Thu, 18 August 2011 14:55

jhora
Messages: 11
Registered: August 2011
Location: YE

Junior Member

look,
there is a dependency in sys.dependency$ table NON-EXISTENT
with that package and a type that auto generated when compile the package,
the type name is SYS_PLSQL_85527_1525_1
And the package obj#=85527
!!
So Is there any problem coused by the similarity between the package obj# 85527 and the type that contains the same _85527_
???
thank u again,

Report message to a moderator

Re: Error In Drop Package [message #520168 is a reply to message #520145]

Fri, 19 August 2011 01:01

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't understand what you're saying.
Copy and paste the SQL*Plus session.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Previous Topic:	How much flash recovery area is enough for flashback
Next Topic:	User Roles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 04:38:37 CDT 2024