oracle user on Solaris in multi-version environment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: oracle user on Solaris in multi-version environment

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    oracle user on Solaris in multi-version environment

    I have an existing Oracle 8.1.7.3 DB on Solaris 8 and plan to upgrade it to 9.2.0.3. Of couse I have an existing Oracle user called "oracle" for the 8i DB. I am wondering when I install 9i on the same machine, do I need to create another UNIX user for Oracle as the owner of the 9i installation or I can use the same UNIX user "oracle"? My understanding is I should create another UNIX user for 9i but would like someone to confirm it.

    Thanks,
    Last edited by a128; 08-10-2003 at 05:46 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    no need to create a new user, as long as you are choosing different ORACLE_HOMES.

    Unless you want to restrict access for whatever reason

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    It is not a bad idea to create a separate user, oracle9, who owns the 9i software. Your oracle and oracle9 UNIX users/accounts can be in the same groups (dba, oinstall). Creating a user, which is a one-time process, is much easier than changing ORACLE_HOMEs, which you may wind up doing numerous times as you go back and forth between versions.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    surely thats whats oraenv is for?

    personally I like one user - but its all personal choice on this really
    Last edited by davey23uk; 08-10-2003 at 07:16 PM.

  5. #5
    Join Date
    Apr 2001
    Posts
    257
    Since the existing is for 8i and the new install is for 9i, will it mess up oraInventory, which is at directory level above the default ORACLE_HOME?

    For example, my existing has structure:

    /ora01/app/oracle/oraInventory
    /ora01/app/oracle/product/8.1.7 (ORACLE_HOME for 8i)
    /ora01/app/oracle/product/9.2.0 (ORACLE_HOME for 9i?)
    /ora01/app/oracle/admin/ORCL/...

    Also I suppose even though they share the admin subdirectory (at level above ORACLE_HOMEs), they won't mess up the existing setup as long as no DB from each home uses the same SID?

    thanks,

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by stecal
    It is not a bad idea to create a separate user, oracle9, who owns the 9i software. Your oracle and oracle9 UNIX users/accounts can be in the same groups (dba, oinstall). Creating a user, which is a one-time process, is much easier than changing ORACLE_HOMEs, which you may wind up doing numerous times as you go back and forth between versions.
    During conversion, you will need to chmod your datafiles, control files, etc. Personally, I think that's a lot of extra work, but that's also your choice...
    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."

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