oracle patch with Opatch

[Former Member]

Hi

I am trying to apply Oracle patch 10.2.0.4 ( currently 10.2.0.2 ) with opatch but getting the following error message,

Do you have any idea , what is wrong here ?

SEVERE:OPatch invoked as follows: 'apply '

INFO:

Oracle Home : C:\oracle\product\10.2.0\db_1

Central Inventory : C:\Program Files\Oracle\Inventory

from : n/a

OPatch version : 10.2.0.4.5

OUI version : 10.2.0.2.0

OUI location : C:\oracle\product\10.2.0\db_1\oui

Log file location : C:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch2009-01-30_08-52-05AM.log

INFO:Patch history file: C:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch_history.txt

INFO:Starting ApplySession at Fri Jan 30 08:52:08 EST 2009

INFO:Starting Apply Session at Fri Jan 30 08:52:08 EST 2009

INFO:ApplySession applying interim patch '7494876' to OH 'C:\oracle\product\10.2.0\db_1'

INFO:Starting to apply patch to local system at Fri Jan 30 08:52:08 EST 2009

INFO:Start the Apply initScript at Fri Jan 30 08:52:08 EST 2009

INFO:Finish the Apply initScript at Fri Jan 30 08:52:08 EST 2009

INFO:Patch 7494876 has no conflicts/superset wiht any other patch processed till now

INFO:Checking conflicts for patch: 7494876

INFO:Checking conflicts/supersets for patch: 7494876 with patch:7494876

INFO:

Running prerequisite checks...

INFO:Space Needed : 955386200

INFO:Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 7494876

INFO:Patch 7494876: Optional component(s) missing : [ oracle.rdbms, 10.2.0.4.0 ] , [ oracle.odbc.ic, 10.2.0.4.0 ] , [ oracle.rdbms.util, 10.2.0.4.0 ] , [ oracle.rdbms.dbscripts, 10.2.0.4.0 ] , [ oracle.sdo.locator, 10.2.0.4.0 ] , [ oracle.nlsrtl.rsf, 10.2.0.4.0 ] , [ oracle.network.rsf, 10.2.0.4.0 ] , [ oracle.ntoledb.odp_net, 10.2.0.4.0 ] , [ oracle.ntoledb.odp_net_2, 10.2.0.4.0 ] , [ oracle.ntoledb, 10.2.0.4.0 ] , [ oracle.oo4o, 10.2.0.4.0 ] , [ oracle.ntoramts, 10.2.0.4.0 ] , [ oracle.network.rsf.ic, 10.2.0.4.0 ] , [ oracle.oracore.rsf, 10.2.0.4.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.0a ] , [ oracle.sysman.console.db, 10.2.0.4.0 ] , [ oracle.rdbms.ic, 10.2.0.4.0 ] , [ oracle.ctx, 10.2.0.4.0 ] , [ oracle.oraolap, 10.2.0.4.0 ] , [ oracle.oraolap.api, 10.2.0.4.0 ] , [ oracle.has.crs, 10.2.0.4.0 ] , [ oracle.has.rsf, 10.2.0.4.0 ] , [ oracle.has.db, 10.2.0.4.0 ] , [ oracle.rdbms.dv, 10.2.0.4.0 ]

INFO:Prereq checkComponents failed. So, checkApplicable returning without execution.

INFO:Prerequisite check "CheckApplicable" failed.

The details are:

Patch 7494876: Required component(s) missing : [ oracle.rdbms.rsf, 10.2.0.4.0 ]

SEVERE:OUI-67074:ApplySession failed during prerequisite checks: Prerequisite check "CheckApplicable" failed.

INFO:System intact, OPatch will not attempt to restore the system

INFO:Finishing ApplySession at Fri Jan 30 08:52:12 EST 2009

INFO:Total time spent waiting for user-input is 0 seconds. Finish at Fri Jan 30 08:52:12 EST 2009

INFO:Stack Description: oracle.opatch.PrereqFailedException: Prerequisite check "CheckApplicable" failed.

INFO:StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:3471)

INFO:StackTrace: oracle.opatch.ApplySession.processLocal(ApplySession.java:3543)

INFO:StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5369)

INFO:StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:1602)

INFO:StackTrace: oracle.opatch.OPatch.main(OPatch.java:629

[Former Member · Accepted solution]

Hi Al Mamum,

You cannot use Opatch for this.

You need to upgrade using DBUA (database upgrade assistant) from 10.2.0.2 to 10.2.0.4.

Revert for any queries.

siddhartha

[former_member204746]

upgrade to 10.2.0.4 using upgrade CD.

then, use opatch to patch 10.2.0.4 to latest patch level.

[Former Member]

An upgrade from 10.2.0.2 to 10.2.0.4 is not done by Opatch.

Well, actually Opatch is a small part of the whole procedure. A lot of other things have to be done first.

And you will have to read a lot of documentation first.

Maybe start with SAP note 551542.

hope this helps