Move database to new ORACLE_HOME
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Move database to new ORACLE_HOME

  1. #1
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612

    Move database to new ORACLE_HOME

    DB = 9.2.0.7
    OS = Solaris 8

    Its been a while, so I thoguht i'd keep you all busy wth another one of my stoopid questions:

    I have a test machine that rather annoyingly doesn't mirror our production environment in that in test there are two Oracle databases under a single $ORACLE_HOME rather than in their own homes. I'd like to create a home and move one of the databases into it... Something like this, I was thinking:

    - Install new Oracle Home

    - run any applicable patchset scripts on the new home

    - shutdown the database that needs to move homes

    - alter the oratab and listener.ora files in /var/opt/oracle to point to the new home.

    - set the environment to point to the new home (.oraenv)

    - startup the database

    However, one of my other team memebers pointed me in the direction of Metalink note 28433.1, which although talking about older versions of Oracle (not 9.2), seems to suggest it isn't as simple as that...

    Anyone got any idea whether i'm on the path to glory, or on the path to the Job Centre?
    Assistance is Futile...

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    err why you want a database per home - seems like a waste of space?

    but your method is sound

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    You are probably right (I can't think of a great reason why we'd want to do that either), but i'm only really looking to do this to get our testing environment to mirror production.

    Thanks for the re-assurance RE: my method.
    Assistance is Futile...

  4. #4
    Join Date
    Jul 2002
    Posts
    335
    Quote Originally Posted by waitecj
    You are probably right (I can't think of a great reason why we'd want to do that either), but i'm only really looking to do this to get our testing environment to mirror production.

    Thanks for the re-assurance RE: my method.
    As Davey says, your method is fine. Its very straightforward. One reason you may have this set up is in case you need to upgrade the databases to different releases at different times.

    Bazza

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Very true Bazza... And having thought about it, its because we use different Oracle technologies with one and not the other (RAC and stuff like that), so a critical patch update might be applicable to one and not the other...
    Assistance is Futile...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width