If you performed an out-of-place upgrade, then you have created a new ORACLE_HOME for 18.104.22.168, and OPatch will need to be executed from this HOME. The setting is most likely in the registry.
Once the upgrade is successfully completed, you will need to use the deinstall tool to deinstall the old (22.214.171.124) ORACLE_HOME
Yes, of course I created a new Oracle_home for 126.96.36.199; but rest of the document [Oracle Database Upgrade Guide,document E23633-09] including the following:
4 Post-Upgrade Tasks for Oracle Database
The chapter contains the following topics:
- Required Tasks to Complete After Upgrading Oracle Database
- Recommended Tasks to Complete After Upgrading Oracle Database
- Tasks to Complete Only After Manually Upgrading Oracle Database
- Required Tasks After Oracle Grid Infrastructure Upgrades
- Required Tasks After Oracle ASM Upgrades
- Recommended Tasks After Oracle ASM Upgrades
Give instructions to change the oracle_home for *windows* platform. The link above is for Setting Environment Variables on Linux and UNIX Systems After Manual Upgrades. I think most people like myself see this section and think: This section does not apply to my platform. Skip it.
Nor are there any instructions as to what files you can delete after the upgrade. The link above is to the Installation Guide. A different document entirely
No link or even a document id in the upgrade guide. This is my point. This document is incomplete. Since it is the source document referenced from the installation instructions, it should be complete and unambiguous.
You have answered my question though :-)
What Srini is trying to say is that when you ran opatch prior to the upgrade you ran using the old home - see old syntax below.
> E:\oracle\product\11.2.0\db_1\opatch\opatch lsinventory
After upgrade you have a new home. My new home is DB_4 - see new syntax below.
> E:\oracle\product\11.2.0\db_4\opatch\opatch lsinventory
Hope this helps,