Re:RE: Big problem with 8.1.6.3 patch

This is an ugly answer but here goes.

Shutdown all of your instances, disable db_start, bounce the box, manually start each instance after you are absolutely sure about where $ORACLE_HOME/dbs/instance_link is pointed, start each instance, run catalog and catproc.

The 8.1.6.3 patch is a very ugly puppy. Read the instruction very, very closely!

Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
pnbarne_at_regence.com

On Thu, 11 Jan 2001 dgoulet_at_vicr.com wrote:

> Hate to state the obvious, but did you follow the install instructions totally?
> And have you called Oracle Tech Support?
>
> Normally they have you run catalog.sql, catproc.sql, etc... after each patch
> install & these are the symptoms of not doing so.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Molina; Gerardo" <Gerardo.Molina_at_schwab.com>
> Date: 1/11/2001 12:20 PM
>
> I'm not sure about this particular patch, but normally you would perform a
> cold backup of your database and Oracle binaries prior to the patch
> application. This allows you to fall back to these (by doing a file
> restore) if the patch isn't successful.
>
> I know this is not much help after the fact though.
>
> Gerardo
>
> -----Original Message-----
> Sent: Thursday, January 11, 2001 8:28 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all,
>
> Big troubles occur after I apllied the 8.1.6.3 patch on an Oracle 8.1.6.2
> enterprise edition.
>
> Databases are opened, but nothing is working (as PL/sql proc, system views,
> etc..) any more.
> All this databases are now unusable !!
>
> Can I uninstall the 8.1.6.3 patch. I' m afraid not because runInstaller
> doesn' t allow desintalling patch product.
> How can I do to un-apply this patch ?
>
> thanks for your help, any advises are welcome
>
> Pascal Dumas
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: pascal dumas
> INET: pdumas_at_ota.fr.socgen.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Molina, Gerardo
> INET: Gerardo.Molina_at_schwab.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Jan 12 2001 - 08:57:41 CST