Patch error

[Former Member]

Hi to all,

I am installing orcale 10 g

after successfull installation i am going to install patch 10.2 but it is showing the error..

when i was apply patches...

it shows..

OUI-10091:There are no patches that need to be applied from the patchset orcale 10 g release to patch set 1 10.2.0.2.0

what can be the reason for that

please suggest

[Former Member]

thanks to all

[Former Member]

Hi Anuj,

Can you please post OPatch lsinventory output and what are the patchesets you are going to apply..

[former_member204746]

you probably installed Oracle 10.2.0.1, and trying to pathc to 10.2.0.2 with opatch?

this is not the way it works.

on windows, here are the steps:

install Oracle 10.2.0.1 (sapserver.cmd)

install 10.2.0.2 patch (setup.exe)

install 10.2.0.2 minpatch (opatch)

[Former Member]

Very first thanks for your valuable reply and support

you probably installed Oracle 10.2.0.1, and trying to pathc to 10.2.0.2 with opatch?

yes ....is it so...and also i am using win2003

so tell me ....whta are the right step for installing orcale 10 g on win 2003 .... For sap ecc 6.0

..

here i am mentioning step which i follow...

Go to the drive for orcale

\orcale\10G\NT\I386

now i have option

Database

Sap

but i choose Database

means

\orcale\10G\NT\I386\database\setup.exe

then got the screen

SELECT INSTALLATION METHOD

Basic installation installation or Advances installation

here i choose Advanced installation

SELECT INSTALLATION TYPE

EntrpriseEdition 10.2.0.1.0

SELECT CONFIGRATION OPTION

Install database software only

i got the message after all 8th step

END OF INSTALLATION

the installation of orcale database 10g was successful.

then i aply the patches

i choose the path

orcale10g\ORA Patch\NT\I386\setup.exe

i got orcale welcome window

Orcale Universal Installation 10.2

SPECIFY HOME DETAILautomatically take the path

D:\Orcale\Product\10.2.0\db_3

but after that give the same error

OUI-10091:There are no patches that need to be applied from the patchset orcale 10 g release to patch set 1 10.2.0.2.0

Now suggest me where shoud i change ....in which step i change..

Edited by: anuj sharma on Feb 27, 2009 5:48 AM

[former_member185031]

\orcale\10G\NT\I386\database\setup.exe

This is not the path of installing Oracle for SAP.

it should be \orcale\10G\NT\I386\SAP\RUNINSTALLER

Regards,

Subhash

[Former Member]

Dear Chandra

\orcale\10G\NT\I386\database\setup.exe is not correct...

then

\orcale\10G\NT\I386\sap\

then i a have 8 no of file there

Custom

DBATOOL>SAR

GetSID and Drive

SAP CAR

sapconn_role

SAPServer

SAPServer1

sapsrv

which one i have to choose my dear

regards

Anuj

[Former Member]

You should choose there sapserver.cmd.

after that install patch 10.2.0.2.0 by setup.exe

Ankit

[former_member603052]

Hi Anuj,

Are you installing Oracle with Oracle Software CD's or using SAP Provided Oracle DVD's.

To install Oracle for SAP you need to use only SAP provided Oracle DVDs.

In that DVD....you need to execute sapsever.cmd to install Oracle Software.

In the Patch DVD,you need to execute setup.exe to install patch

Regards,

Kalyan

[former_member603052]

Hi Anuj,

I think in the folder options > View Tab> UNCheck hide extensions for known types. So that you can see file extensions also.

You need to click \ORACLE\NT\I386\sapserver.cmd to install oracle.

Regards,

Kalyan

[Former Member]

Dear ,

You need to click \ORACLE\NT\I386\sapserver.cmd to install oracle.

will it automatically pick orcale exe ....

or else i have to do ...

[former_member603052]

Hi,

It picks and you no need to pick.

After you click sapserver.cmd it opens OUI where you give the Oracle Home and all....

Regards,

Kalyan

[Former Member]

Thanks mr. gupta i will try it....

but i am doing little bit R&D can you tell me

why sapserver.cmd

why notorcale 10 g exe..

please give the technical reasion...

[former_member603052]

Hi,

You must install Oracle using the SAP provided script called sapserver.cmd

This script will launch setup.exe with proper parameters and install what is needed for Oracle.

Regards,

Kalyan

[Former Member]

Thanks ,

for reply... it will provide the path of oui.exe

@%rootdir%\database\install\oui.exe -responseFile %rootdir%\sap\SAPServer.rsp ORACLE_HOME_NAME=%ohname% ORACLE_HOME=%ohdest%

thanks

[markus_doehr2]

> for reply... it will provide the path of oui.exe

> @%rootdir%\database\install\oui.exe -responseFile %rootdir%\sap\SAPServer.rsp ORACLE_HOME_NAME=%ohname% ORACLE_HOME=%ohdest%

The main reason is the "response file" - in contains preconfigured parameters and activated features for the database.

Markus

[former_member603052]

Hi Anuj,

I think your intial version of Oracle may be same as that of patch or more. Check it.

Regards,

Kalyan

[Former Member]

Hi,

What do you get when you run: select * from v$version;

Please check below links.

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=24542&SkipA=0

http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/549c407064e16c10

Hope this helps you.

Thanks,

Sushil

[markus_doehr2]

What initial version did you install?

Markus