Change Oracle Home Directory Structure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Change Oracle Home Directory Structure

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Friends.

    Let's say my $ORACLE_HOME is
    /u01/oracle/product/ux61
    and I renamed directory ux61 to ux62

    so home is /u01/oracle/product/ux62

    would this affect anything Oracle ?


    I will change my environment variables so that they point to new oracle_home.

    Is there anything else i need to consider ?

    Thanks

    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I seem to remember the last time I did this (8.0.6) that I had to relink the oracle software. I think one of the client apps didn't work properly. In 8i, the command is relink all.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jul 2000
    Posts
    521
    Yes, you need to relink Oracle executables. You also need to change a file that specifies absolute path names and file names for some libraries.

    But after that, it works smooth.
    svk

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Come to think about it, I never was able to get it to fully work. I just re-installed the software in the new $OH and had two copies of the same software at once. When I switched $OH, I just removed the old $OH.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Apr 2001
    Posts
    108

    Changing the Oracle Home Directory

    It depends on the version of Oracle. Under 8i, there are many config files where the path for Oracle Home is hard coded, so if you move the directory you need to find all the config files and edit them. It's easier to just uninstall and reinstall the software. Under 8.0 it was much easier to move the Oracle executables.
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

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