topic Re: Oracle OPatch in Operating System - HP-UX

Oracle OPatch

Daedalus_1 — Tue, 26 Oct 2004 21:38:19 GMT

Hi

Does anyone have use Oracle opatch to install patches ? Would like to ask whether instance restart are required after the performing the "opatch-ing" in order to bring the pateches to take effect ? Or do i need to shut down all the instance before i perform opatch ?

Many thanks
Daedalus

Re: Oracle OPatch

Yogeeraj_1 — Wed, 27 Oct 2004 00:17:30 GMT

hi,

The Interim Patch Installer, OPatch, is an Oracle supplied utility to assist with the process of applying interim patches to Oracle's database software. It can only be used with Data Server Interim patches for Oracle9i Release 2 (version 9.2) or greater.

Being just a "tool", you must follow the normal procedure for applying your patches as per the instructions comming with the patch.

regards
Yogeeraj

Re: Oracle OPatch

Daedalus_1 — Wed, 27 Oct 2004 00:40:22 GMT

Thank Yogeer

I'm now actually going to install patch 3811887. (http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=281188.1)

From the readme i could find, there's no procedure mentioned for restarting nor shutdown the instance.

Is there any other material i could refer to?

Moreover, If instance restart is not required, how could i ensure that the patch has successfully installed and took effect?

Many Thanks
Daedalus

Re: Oracle OPatch

Yogeeraj_1 — Wed, 27 Oct 2004 02:26:40 GMT

hello daedalus!

just went through the readme of the patch and here is a quote:

# Patch Special Instructions:
# ---------------------------
# Make sure all instances running under the ORACLE_HOME being patched
# are cleanly shutdown before installing this patch. Also ensure that
# the tool used to terminate the instance(s) has exited cleanly.
#

(http://updates.oracle.com/ARULink/PatchDetails/view_readme?plat_lang=59P&patch_file=&file_id=&password_required=&merged_trans=&aru=6451608&patch_num=3811887&default_release=8092040&default_plat_lang=59P&patch_password=&orderby=&direction=&no_header=0&sortcolpressed=&tab_number=&email=unknown)

which is a clear instruction of what has to be done!

you should print the readme and read it carefully. It contains precious and specific information about patches.

hope this helps!
regards
Yogeeraj

Re: Oracle OPatch

Daedalus_1 — Wed, 27 Oct 2004 19:58:00 GMT

Yogeer

Thanks for your help.

I think the part you mentioned in the README is part of the "Patch Special Instructions".

Which, I'm not sure whether that's a must to go through these steps or I only need to run the "opatch apply", as stated in the "Patch Installation Instructions".

Quoted:
----------
Now, if using Context, follow the Special Instruction steps
below to update the Context schema.
----------

How can I check whether "Context Schema" are used in my Oracle?

Many thanks for that and sorry for my lack of knowledge.

Daedalus

Re: Oracle OPatch

Yogeeraj_1 — Thu, 28 Oct 2004 01:05:36 GMT

hi,

you can run the universal installer and check for the installed products. Look for "Oracle Context". If you have it listed over there, then you do have Oracle Context installed.

regards
Yogeeraj

Re: Oracle OPatch

Daedalus_1 — Thu, 28 Oct 2004 01:18:31 GMT

Thx Yogeer

That's helpful.

Re: Oracle OPatch

Daedalus_1 — Thu, 28 Oct 2004 01:20:26 GMT

case close