Re: Patching Oracle Database

On Tuesday, September 16, 2014 11:54:54 AM UTC-4, rr wrote:
> W dniu 2014-09-16 17:45, Mark D Powell pisze:
>
> > On Tuesday, September 16, 2014 9:44:02 AM UTC-4, rr wrote:
>
> >> hello
>
> >>
>
> >>
>
> >>
>

No, you do dot change the tables manually.
> >> 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 --
>
> >
>
>
> thanks for respond.
>
>
> so I will have to do changes manually in tables like: dba_libraries
>
> dba_directories is is ok - it's not the problem;
>
> - how to findout where are other tables I need to corect?
>
> - can I rename old oracle_home directory and then delete?

No, you do not change the Oracle tables manually. Each patch has a README file that explains the procedure you should follow. Most of the information in dba_libraries is picked up from the binary Oracle is started with.

HTH -- Mark D Powell -- Received on Wed Sep 17 2014 - 19:32:58 CEST