Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Patch #2189751 (8.1.7.3) questions

Re: Patch #2189751 (8.1.7.3) questions

From: Daud <daud11_at_hotmail.com>
Date: 1 May 2002 23:17:16 -0700
Message-ID: <f0bf3cc3.0205012217.45d25076@posting.google.com>


wow!! I thought I was the only one who was confused with the documentation and was about to give up my job as a DBA....

"Glen A Stromquist" <glen_stromquist_at_nospam.yahoo.com> wrote in message news:<9aTz8.376$rS5.90345_at_news2.telusplanet.net>...
> Thanks John
>
> I read the bug report and I don't think it applies to me.
>
> You are right about the incomplete instructions, at least I found them a tad
> confusing / unclear if anything.
>
> Just to be on the safe side I'm calling Oracle support to find out what
> *exactly* it is I have to do for my particular installation and what I
> don't.
>
> I'll post the answer here
>
> cheers!
>
>
> "John MacAskill" <jmacaski_at_bigpond.net.au> wrote in message
> news:uvlvcu8gq3dd6lnqenmai92r2u7je8rb0t_at_4ax.com...
> > Word of warning to the group. If you run Java and XML be very careful as
> this is
> > a particularly ugly patch. As with all previous 8.1.7 patches the read me
> and
> > installation instructions are incomplete and there are required steps
> missing..
> >
> > I strongly recommend you consult with Oracle support before applying this
> patch
> > to verify if the issues are relevant to your installation.
> >
> > Regards,
> >
> > John
> >
> > PS for details refer to bug 2350386 for further details
> >
> > On Tue, 30 Apr 2002 15:46:58 GMT, "Glen A Stromquist"
> > <glen_stromquist_at_nospam.yahoo.com> wrote:
> >
> > >Just want to know if anyone else has installed this patch. I found that
> the
> > >patch notes instructions are not the clearest, and have you change the
> > >init.ora file to disable system triggers on startup, rerun the catalog
> and
> > >catproc scripts, along with several others that seem to be for java if
> it's
> > >installed. But it's not clear if this all has to be done ONLY if java was
> > >enabled in the DB or not.
> > >
> > >I put this patch in because I noticed that if the OS was shutdown the
> > >databases were not brought down automatically as they were supposed to
> be,
> > >and did a crash recovery on startup. This patch is supposed to stop this
> > >from happening. (and does)
> > >
> > >I installed on a test installation with 2 databases on it, I applied all
> of
> > >the changes on one database, and left the other database alone, started
> both
> > >databases, then restarted the PC without doing manual shutdowns on either
> of
> > >them. Checked the alert logs on startup and both databases started up
> fine
> > >with no crash recovery.
> > >
> > >This is on a workstation, and I installed the java component with the
> > >initial install, but we have no databases that use java.
> > >
> > >I have to install the patch on two production machines, and don't want to
> > >touch the databases any more than I have to. However I'm sure re running
> the
> > >oracle scripts is harmless enough, but I want to be sure.
> > >
> > >thanks.
> > >
> >
> > Slainthe,
> >
> > John
Received on Thu May 02 2002 - 01:17:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US