Re: Patch #2189751 (8.1.7.3) questions

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.

>

>