Patch Oracle 10.2.0.4 to 10.2.0.4.8

[jorge_velasquez]

Hi Expertes,

I want to patch Oracle from 10.2.0.4 to 10.2.0.4.8 and I downloaded the file SAP_102048_201107_AIX.zip

Also I have read the README_201107_AIX.htm

My question is, if I put this commands one by one as root directly from the .ZIP directory (/PATCH_10) they will be executed fine or Do I have to create the folders and stuff?

-

---

Extract OPatch version 10.2.0.5.0 and install it in the Oracle Home:

unzip -qd $ORACLE_HOME/sapbundle SAP_102048_201107_AIX.zip 'SAP_102048_201107/OPatch/*'

mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch-pre-SAP_102048_201107

mv $ORACLE_HOME/sapbundle/SAP_102048_201107/OPatch $ORACLE_HOME/OPatch

-

---

Regards.

[Former Member]

Hi Jorge,

Follow this link https://service.sap.com/oracle-download to download, how suggest the note 1027012.

- Make the download of the recently package .

- Transfer in binary format to $ORACLE_HOME directory .

- Adjust the owner to ora<sid> and group dba.

-Step 2

- Run the command bellow, with user ora<sid> logged.

/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh \

-v -j /usr/java5/jre -s $ORACLE_HOME/SAP_102048_201107_AIX.zip

In the final of this step, verify the inconsistencies.

-Step 3 - Post installation

- Login with ora<sid>

- Adjust the tablespace SYSTEM.

- Entry in $ORACLE_HOME/rdbms/admin directory.

#cd $ORACLE_HOME/rdbms/admin

- Entry sqlplus

- Run the post installation script.

@$ORACLE_HOME/sapbundle/SAP_102048_201107/catsbp.sql

Best regards,

Denis

Brazil

[Former Member]

Hi Jorge,

Readme file has everything.Just follow what ever is written in it.

You dont need to create any directories jus execute the commands given in readme.

Its better to have a backup of Oracle_Home and oraInventory before you perform this activity.

Regards,

Ershad Ahmed.

[jorge_velasquez]

Hi,

Where is the oraInventory located?

Also I want to know if I have to execute this command after I have installed the new patch:

@?/sapbundle/SAP_102048_201107/catsbp.sql startup_upgrade=false

Regards.

[nicholas_chang]

Hi Jorge,

by default, oraInventory is located under /oracle. Please browse under /oracle.

not required to execute @?/sapbundle/SAP_102048_201107/catsbp.sql startup_upgrade=false as post installation if you just have one database instance associated with the $ORACLE_HOME you updating.

If you have more than one database instance associated, just run the command @?/sapbundle/SAP_102048_201107/catsbp.sql will do, omit startup_upgrade=false .

btw, if you have not started the patching, SAP_102049_201108_AIX.zip just released today, perhaps you can use the latest SBP.

Cheers,

Thanks,

Nicholas Chang.

[volker_borowski2]

> My question is, if I put this commands one by one as root directly from the .ZIP directory (/PATCH_10) they will be executed fine or Do I have to create the folders and stuff?
> 
> -
> Extract OPatch version 10.2.0.5.0 and install it in the Oracle Home:
> 
> unzip -qd $ORACLE_HOME/sapbundle/SAP_102048_201107_AIX.zip 'SAP_102048_201107/OPatch/*'
> mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch-pre-SAP_102048_201107
> mv $ORACLE_HOME/sapbundle/SAP_102048_201107/OPatch $ORACLE_HOME/OPatch
> -
> 
> Regards.

No , you do not have to create anything !

unzip -qd ...

will (q)uietly extract the entire (d)irectory "SAP_102048_201107/OPatch/" from the archive.

1) mv ...

will rename your existing old version of OPatch

2) mv ...

will move the entire OPatch directory from SAP_102048_201107 to your $ORACLE_HOME

"unzip -h" helps

Volker

[jorge_velasquez]

Hi Volker,

Ok I will backup my old Opatch - Mopatch and then execute the commands from the .zip folder as root.

Regards

[nicholas_chang]

Hi,

before you run the patching, i strongly advise you download the latest MOPatch and OPatch from SMP to avoid any error during your patch.

Software Downloads -> Database Patches -> Oracle -> Oracle 10.2.0.4 -> OPatch

Current latest level available:

OPatch_10205_Generic_v0.zip 10.08.2010

mopatch-2_1_10.zip 20.07.2011

Thanks,

Nicholas Chang.

[nicholas_chang]

Hi,

before you patch SBP:

1) please ensure you update your MOPatch and OPatch to latest level, download from SMP and extract to $ORACLE_HOME

2) To install SBP, shutdown your database and listener <-- Critical

3) run the below command:

/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -v -s /DirectoryWhereYouSaveTheSBP/SAP_<YourSBPVersion>.zip

4) once completed, Check that the patches are viewable via opatch :

$ cd $ORACLE_HOME/OPatch

$ opatch lsinventory | more

or you can check at $ORACLE_HOME/cfgtoollogs/mopatch

5) perform any post-installation if necessary.

For better understanding, i strongly advise you to download the readme file and go thru it before initiating the patching.

Cheers,

Thanks,

Nicholas Chang.

[Former Member]

I don't think its a software patch installation, just a bundle patch installation (OPatch using MOPatch).

Its good to use a latest bundle patch for latest corrections/bug fixes, but very bad that still you are on out dated version of Oracle.

Plan and execute Oracle upgrade from 10G to 11gR2 for latest/new features and for a sustainable support.

Regards,

Nick Loy

[Former Member]

Better to create folders. Keep a copy of old OPatch, however you are already doing it by mv command (second line) but do copy at another location as well.

Thanks