Oracle 10.2.0.4 patch from oracle 10.2.0.1 giving error

[Former Member]

Hi Experts,

I have installed oracle 10.2.0.1(software only) in windows server 2008 R2(X64).

Now I want to patch this to oracle 10.2.0.4 version.

I have downloaded the patch and extracted and run the installer.

Now when I choose the oracle to patch, it gives the error that 'this can be used on an existing oracle home only'.

Also in the 'installed product' button, this is not showing any software details.

I am not able to understand what is the reason for this error. Please help.

Thanks,

Arijit

MODERATOR: If there was an answer that helped you to fix the issue then you should mark it as the correct answer so that will help others in the future when they face same issue.

[former_member182657 · Accepted solution]

Hi,

Could you check with environment variable ORACLE_HOME and if possible share the result by following command C:\echo %ORACLE_HOME% .

Also confirm are you able to start/stop the database,as per me this might be an issue with initial installations of oracle 10.2.0.1 and in defining of environment variables & directories.

Regards,

Gaurav

[Former Member · Accepted solution]

Thanks Gaurav.

The problem was with oracle home environment variable.

When I set it through environment variable option, the error went away and patch installation was successful.

Best Regards,

Arijit

[former_member182657]

Oh Great !! Nice to know your issue has been resolved now.Kindly close the thread .

Regards,

Gaurav

[Former Member]

Dear Arjit,

which type of upgrade are you perform.

1) in Place 2) out of place....

if you perform in place then no need to create a new oracle home.

[janos_mucsi-besze]

Hi Arijit,

Make sure the oracle Software owner has all required env. variables set, like %ORACLE_HOME%,%PATH% and by trying to execute any oracle executable, it get at least started. Close all previous Windows Command promt, open a new one and verify if the required oracle variables are read. Try to apply the patch from this Command Prompt.

Regards,

János

[thiago_cavalheiro]

Hi Arijit,

Are you using SAP patches? Please check the installation/upgrade guide in service.sap.com/instguides and make sure the steps are followed.

Best regards,

Thiago.