Oracle patch upgrade from 10.2.0.2 to 10.2.0.4

[Former Member]

Hi all,

I want to Upgrade my Oracle patch from 10.2.0.2 to higher version in AIX platform ..

Tech Details AIX , Oracle 10G (10.2.0.2) and ecc6.0 .

I have already downloaded the patch from service.sap.com (SAP_102044_201006_AIX.zip).

i ma also reading readme helpfile for applying patch set .

i was struck in the step : 2.2 Extracting the SAP Bundle Patch Documentation:

mention the below command for extracting SAP_102044_201006_AIX.zip .

/bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -v -d -s SAP_102044_201006_AIX.zip

I have downloaded a mopatch-2_1_3.zip also .

my question is i have to copy mopatch and (i have to extract MOpatch also) to /bin/sh $ORACLE_HOME this directory .

Oracle_home : Oracle/SID/102 in Windows Platform.

let me know in AIX for /bin/sh $ORACLE_HOME path

Kindly advise in AIX environment for applying Oracle patch .

Regards

[Former Member]

Dear all,

I have checked the Note 1027012 - MOPatch - Install Multiple Oracle Patches in One Run .

$ /bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -h

Kindly suggest for the above command for brief .

I have applied Oracle patches in Windows environment but not in AIX platform.

Kindly advise

[Former Member]

Dear all ,

I have checked servise.sap.com , now the latest oracle patch is 10.2.0.5

we can apply 10.2.0.5 instead of 10.2.0.4

Kindly advise

[former_member204746]

why don't you try to execute the command yourself?

try it. if you get problems, get back here.

[Former Member]

Hello Satheesh,

This is the syntax I used for my AIX script when upgrading to 10.2.0.4. I stayed at .4 rather than upgrading to .5

cp -R MOpatch /oracle/<SID>/102_64

mkdir /oracle/<SID>/opatch_base_dir_10204

1. copy the SBP patch to the base_dir. Make sure all patches are readable by oraSID.

1. You will also need to be running the latest version of Opatch. Unzip this into the $ORACLE_HOME dir

unzip -d $ORACLE_HOME OPatch_<release>.zip

1. Now install SBP patches using MOpatch. I do "dry run" mode first to review any possible errors. Then re-run it for real.

cd /oracle/<SID>/opatch_base_dir_10204

/bin/sh /oracle/<SID>/102_64/MOpatch/mopatch.sh -v -d

Make sure you read any information about post processing for specific patches after running mopatch.

[Former Member]

Hi BEN ,

Thanks for your valuable reply ..

[Former Member]

Hi Ben ,

Let me provide details steps for Oracle Upgrding patch from 10.2.0.2 to 10.2.0.4

The below patches i have downloaded from Service.sap.com

SAP_102044_201006_AIX.zip.

OPatch_10204_Generic_v9.zip

mopatch-2_1_3.zip

Let know any patches i have to download ....

Regards

[Former Member]

Hello Satheesh,

Other than the latest SBP, Opatch, and MOpatch you should be all set.

If there are any other downloads needed after you will see them in the related documentation for post processing in the report MOPatch creates after running.

Good luck!

[Former Member]

Hi BEN,

We have Prod Cluster Environment (PROD DB , PROD CI and APP1 , APP2 ) .

my current oracle patch is 10.2.0.2 , shall i apply 10.2.0.2 to 10.2.0.4 directly in PROD DB instanence .

Regards

[former_member204746]

shall i apply 10.2.0.2 to 10.2.0.4 directly in PROD DB instanence

answer is yes

[Former Member]

Agreed with Eric.

Apply it directly to the DB.

[Former Member]

Dear all,

i have checked the README_201006_AIX.htm .

its mentioned ,To install SBP 10.2.0.4.4 201006, the Oracle Home must have the 10.2.0.4.0 database patch set installed

but my Oracle patch is 10.2.0.2.0 ,

I have downloaded Oracle patchset for 10.2.0.4 (AIX)

let me know how to install Oracle patch set for 10.2.0.4

Patchset_10204_AIX5Laa.bin

Patchset_10204_AIX5Lab.bin

Patchset_10204_AIX5Lac.bin

Patchset_10204_AIX5Lad.bin

let me know any steps are appriciate

Regards

[Former Member]

Simple.

Install the base patch set using the Oracle Installer. This will bring you to 10.2.0.4

Once your DB is on 10.2.0.4 then it is time to use MOPatch to install the SBP.

After the SBP is installed then you must read the output it creates and follow any post processing steps for certain patches

that will have been applied. The output is easy to read and highlights the individual patches that will need post processing for your particular landscape.

Hope this helps.

[former_member524429]

Hi,

Steps:

1. Take Proper Backup of ORACLE_HOME directory.

2. Shutdown SAP & Oracle instances, Oracle Listener..

3. Apply the Oracle Patch-set 10.2.0.4

4. Apply the latest Patches/Patch collections for 10.2.0.4

Please refer the following useful SAP Notes as straight forward steps for your requirement.

SAP Note 839187 - Oracle 10.2.0: Applying patch set/patches/patch collection

To apply the patch set, follow the instructions in the patch set README file.

SAP Note 1137346 - Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4

You must apply the patches or the patch collection after you apply the patch set.

All the things are well discussed with the required detailed steps in the above helpful SAP Notes. Please read them carefully according to system environment.

Regards,

Bhavik G. Shroff

[Former Member]

dear all ,

After Upgrade Oracle patch 10.2.0.2 to oracle 10.2.04 .

i got error wheu i tried to start DB , pls check the below log.

Enter user-name: / as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name: / as sysdba

Connected to an idle instance.

SQL> startup upgrade;

ORACLE instance started.

Total System Global Area 1358954496 bytes

Fixed Size 1298568 bytes

Variable Size 1182797688 bytes

Database Buffers 167772160 bytes

Redo Buffers 7086080 bytes

Database mounted.

Database opened.

SQL> SPOOL upgrade_info.log

SQL> @?/rdbms/admin/utlu102i.sql

Oracle Database 10.2 Upgrade Information Utility 07-14-2010 00:08:01

.

**********************************************************************

Database:

**********************************************************************

--> name: ECC

--> version: 10.2.0.2.0

--> compatible: 10.2.0

--> blocksize: 8192

.

**********************************************************************

Tablespaces: [make adjustments in the current environment]

**********************************************************************

--> SYSTEM tablespace is adequate for the upgrade.

.... minimum required size: 840 MB

--> PSAPUNDO tablespace is adequate for the upgrade.

.... minimum required size: 71 MB

--> SYSAUX tablespace is adequate for the upgrade.

.... minimum required size: 270 MB

--> PSAPTEMP tablespace is adequate for the upgrade.

.... minimum required size: 58 MB

.

**********************************************************************

Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

WARNING: --> "large_pool_size" needs to be increased to at least 8388608

.

**********************************************************************

Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No renamed parameters found. No changes are required.

.

**********************************************************************

Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfi

**********************************************************************

-- No obsolete parameters found. No changes are required

.

**********************************************************************

Components: [The following database components will be upgraded or installed]

**********************************************************************

--> Oracle Catalog Views [upgrade] VALID

--> Oracle Packages and Types [upgrade] VALID

.

**********************************************************************

Miscellaneous Warnings

**********************************************************************

WARNING: --> Database contains INVALID objects prior to upgrade.

.... USER SAPSR3 has 348 INVALID objects.

.... USER PUBLIC has 19 INVALID objects.

.

PL/SQL procedure successfully completed.

SQL>

SQL>

SQL>

SQL> SPOOL OFF

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

SQL> startup

ORACLE instance started.

Total System Global Area 1358954496 bytes

Fixed Size 1298568 bytes

Variable Size 1182797688 bytes

Database Buffers 167772160 bytes

Redo Buffers 7086080 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

Kindly advise

[Former Member]

Adjust your large pool size to the requirement listed and try starting the DB again.