Re: 8.1.7.4 patchset question

Glen A Stromquist <glen_stromquist_at_no.spam.yahoo.com> wrote in message news:<w5z_9.113685$Ui4.3085795_at_news1.telusplanet.net>...
> I am installing the patchset on a new oracle install on which I have no
> databases created yet, should the _system_trig_enabled=false be in the
> init.ora file before I run the catalog and catproc scripts for the 1st
> time?
>

Yes, because some dictionary triggers may fire. See metalink note 149948.1 . If you don't set it and don't run into any errors you are ok.

> I assumed that since the database is created after the patch is applied
> that this is not neccesary, but the readme is a bit foggy on this, since
> it assumes that the patchset is being applied to an install that already
> has existing database(s) on it and doesnt specify if it is neccesary on
> a new install. All my other applications of this patch were on existing
> databases, so I have not had to deal with this issue yet.

The catalog and catproc are being run on your new db dictionary. Whether there are triggers depends on what is installed.

>
> Also I read on a different thread when trying to find this out that
> there is an 8.1.7.4.5 patch? Looking on metalink the latest I can find
> is the same as I have from last summer.

I vaguely recall seeing something about this being platform-dependent and uncertified. There are metalink forum postings about such a beast.

jg

--
@home is bogus.
IT'S FRIDAY!