Home > 11g > How to change the oracle_home for GRID based database.

How to change the oracle_home for GRID based database.

December 10, 2015

Today i was asked to change the oracle home of my database due to naming standards. So i had installed oracle home in new location.

OLD oracle_home:- /local0/app/oracle/product/11.2

NEW oracle_home:- /local0/app/oracle/product/11.2.0.4

After that i did the following actions.

  1. Copied the parameter and password files  to $ORACLE_HOME/dbs of new.
  2. Collected the current configuration of the database using srvctl.

    ncclpdomds06<grid>srvctl config database -d domds
    Database unique name: domds
    Database name:
    Oracle home: /local0/app/oracle/product/11.2
    Oracle user: oracle
    Spfile: +data/domds_06/parameterfile/spfile.409.892459461
    Domain:
    Start options: open
    Stop options: immediate
    Database role: PRIMARY
    Management policy: AUTOMATIC
    Database instance: domds
    Disk Groups: DATA,FRA,RDOEV
    Services:
    ncclpdomds06<grid>

  3. Change the oracle_home location using srvctl using below command.

ncclpdomds06<grid>srvctl modify database -d domds -o /local0/app/oracle/product/11.2.0.4

     4.   Now check the configuration changes reflected or not?

ncclpdomds06<grid>srvctl config database -d domds
Database unique name: domds
Database name:
Oracle home: /local0/app/oracle/product/11.2.0.4
Oracle user: oracle
Spfile: +data/domds_06/parameterfile/spfile.409.892459461
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: domds
Disk Groups: DATA,FRA,RDOEV
Services:
ncclpdomds06<grid>

5.   Start the database.

ncclpdomds06<grid>srvctl start database -d domds

 

Advertisements
Categories: 11g
%d bloggers like this: