Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Patch #2189751 (8.1.7.3) questions
Glen,
_system_trig_enabled=false parameter setup was since 8.1.6 patches upgrades. It is described in the patch release notes and it is a step in the procedure.
Great, that the shutdown problem was fixed in 8.1.7.3.0 patch.
Trifon Anguelov
Senior Oracle DBA
Trifon, the registry settings you described were set correctly in the first place, but this is/was a bug in 8.1.7.3, in that it still did not shut down "gracefully" when the OS shut down if the database(s) were still up at the time. This patch fixed that, I verified that as soon as I finished installing it.
However I did manage to hunt down a few more articles on metalink regarding the patch set, in 8.1.7 and 9i you HAVE to set the "hidden" parameter _system_trigs_enabled = false before you do anything to the data dictionary, or run any scripts as sys or internal. The document 120607.1 describes it fairly well.
"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:jaBz8.4049$u81.2379037835_at_newssvr21.news.prodigy.com...
> Glen,
>
> "But it's not clear if this all has to be done ONLY if java was enabled in
> the DB or not."
>
> If you choose to install JAVA (java classes and JAVA support) in the DB, it
> does not matter if you are using it or not. If you installed then it is
> enabled. Check it out:
>
> SQL>describe dbms_java or SQL>select count(*) from all_objects where
> object_type like 'JAVA%'; (run as internal)
>
>
> "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."
>
> To make that happend you have to check if in the registry:
> HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME<n> parameters are set:
>
> ORA_<SID>_AUTOSTART=TRUE
> ORA_<SID>_SHUTDOWN=TRUE
> ORA_<SID>_SHUTDOWN_TIMEOUT=?
>
> However, you did no harm installing the latest 8i patch. If you application
> is working fine, then the chance to hit some know bugs before 8.1.7.3.0 are
> less.
>
> Check the latest Oracle DBA forums for more information:
>
> http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
>
>
> Hope that helps,
>
> Trifon Anguelov
> Senior Oracle DBA
>
> http://www.dbaclick.com
>
>
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ---
>
>
>
>
>
>
> "Glen A Stromquist" <glen_stromquist_at_nospam.yahoo.com> wrote in message
> news:S%yz8.5618$2D1.149772_at_news2.telusplanet.net...
> > 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.
> >
> >
>
>
Received on Tue Apr 30 2002 - 22:12:08 CDT