Re: Patch #2189751 (8.1.7.3) questions

Thanks guys...

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 - 14:02:27 CDT