Re: Patching Oracle Database

From: Mark D Powell <markp28665_at_gmail.com>
Date: Tue, 16 Sep 2014 08:45:12 -0700 (PDT)
Message-ID: <939ef925-6fda-4f5a-90e9-acb3a40a7528_at_googlegroups.com>


On Tuesday, September 16, 2014 9:44:02 AM UTC-4, rr wrote:
> hello
>
>
>
> I apply patch on Oracle database 11.2.0.4.0 (Patch 18522509)
>
> during patching system ask for creating new ORACLE_HOME (because of
>
> patch conflicts,
>
> so I created it in /ora/app/oracle/product/11.2.0/dbhome_2
>
>
> I also aply post patch script
>
> but in some places I have old oracle home for example:
>
> -----
>
> select * from dba_libraries where library_name = 'DBMS_SUMADV_LIB' or
>
> library_name = 'ORDIMLIBS'
>
> -----
>
> select * from dba_directories
>
> -----
>
> - Why is that patching proces didn't change that paths to new one?
>
> - Did I made mistake to apply patch in new Oracle_Home?
>
> - should I for example - install in old one?
>
> - scould I uninstall conflicting patches first?
>
> thants

If the patch process created a complete 11.2.0.4 installation then I would think you could follow the standard upgrade process. Install new home, change environment set up scripts, oratab, listener.ora, etc ... to reference the new home, stop the Oracle instance, startup upgrade using the new home, run any required upgrade scripts, and open the instance for business.

If the new home is not complete then yes I think you would need to remove the conflicting patches and try again after backing up the binary.

HTH -- Mark D Powell -- Received on Tue Sep 16 2014 - 17:45:12 CEST

Original text of this message