Re: Reinstall sys packages
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: Richard.Goulet@xxxxxxxxxxx, John Dunn <jdunn@xxxxxxxxx>
- Date: Wed, 1 Dec 2010 15:07:43 +0100
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:
