Oracle 10g installation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle 10g installation

  1. #1
    Join Date
    Oct 2006
    Posts
    3

    Oracle 10g installation

    I have oracle9i installed on Sun Solaris 5.9 and ORACLE_BASE is /ora01/app/oracle.There is a .profile for user oracle.The current oracle_home is /ora01/app/oracle/product/9.2.0.
    I plan to install 10g (to upgrade 9i to 10g later ) using the same ORACLE_BASE and new oracle-home /ora01/app/oracle/product/10.2.0.
    Do I need to create a new user oracle10 to different the oracle9i owner and oracle10g owner? If not, How to make change to .profile?
    Thanks for your input!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no you dont need to, you use oraenv after to change settings

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool


    No, you do not need to create a new user for 10g.
    With vi editor, change the Oracle home in .profile.
    If you need to work on both Oracle homes, create a script for each where you set the corresponding environment.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Oct 2006
    Posts
    3
    Thanks for the quick reply.This is the ponit I am not clear about. I don't know 'how to create a script for each where you set the corresponding environment'. Can user oracle have more than one .profile?
    Thanks!

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    the answer is no....u just use if then else logic within the profile
    but...
    for simplicity just create another userid and home for 10g
    like oracle10 so you won't mess both homes.
    Last edited by yxez; 10-17-2006 at 07:53 PM.
    Behind The Success And Failure Of A Man Is A Woman

  6. #6
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    hi all...i've noticed that the server time for this forum when i edit
    my post is 11:53PM and our time is 7:53AM ...so i'm ahead 8hrs
    Is the forums' server located at UK? davey?
    Behind The Success And Failure Of A Man Is A Woman

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