Re: Reinstall sys packages

Yes, that will work fine in most cases, key being that you can't have any
users connected.

If it doesn't work, the next level would be:

- startup migrate
- run catupgrd.sql   (yes, even if you haven't upgraded)

This will go over *everything* you can installed, even components not
explicitly touched by catproc or catalog

Done many times pre-11.2 releases

Stefan



=========================

Stefan P Knecht
CEO & Founder
s@xxxxxxxx

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch

=========================


On Wed, Dec 1, 2010 at 3:00 PM, Goulet, Richard
<Richard.Goulet@xxxxxxxxxxx>wrote:

>  I had a problem with a sys package many years ago.  Don't know why it
> became invalid but it did and we could not manually compile it.  At the time
> I opened a TAR with Oracle on the subject because the package was wrapped
> and therefore not something you can troubleshoot.  Anyway, the support
> analyst told me very clearly that one can run the basic install scripts
> (catalog, catproc, etc...) at anytime without damaging the database as long
> as one did it with no users connected to the database. (duh, that makes
> sense).  So we did over a night and presto the package was valid, our
> problems cleared up and everyone was happy.  Recently I had another problem
> with the OLAP package and again files a TAR.  Same answer, almost verbatim,
> came back and yes it did fix the problem.
>
>
> Dick Goulet
> Senior Oracle DBA
>
>
>  ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *John Dunn
> *Sent:* Wednesday, December 01, 2010 4:15 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Reinstall sys packages
>
>  Is there a quick way to re-install sys packages(other than complete
> re-install/backups). I seem to have accidentially deleted some!!
>
>
>
>
> **
>
> *John *
>

Other related posts: