Should is use separate OS users per RDBMS version? [message #121004] |
Wed, 25 May 2005 06:46 |
o011rie
Messages: 2 Registered: May 2005
|
Junior Member |
|
|
Hello,
I have installed 10g besides our 8i software. The OS users that owns the 8i is named oracle8 and the OS user oracle10 owns the 10g software.
We have a discussion going if we made the right choice. Should we have used one OS user that owns all the RDBMS software or should we did we made the right choice?
What are the pros and cons between these two?
Thanks in advance,
André
ps. we use HP-UX
|
|
|
|
|
Re: Should is use separate OS users per RDBMS version? [message #121069 is a reply to message #121061] |
Wed, 25 May 2005 12:32 |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
Probably having separate users will help in ur case, as in that case u can set the default values including oracle home, oracle base etc.. separately in each users own profile.
In case u use single user, u may need to make the changes in default parameter settings manually for at least one of these installtions.
Otherwise I don't think u should be facing any other issue.
|
|
|
Re: Should is use separate OS users per RDBMS version? [message #121080 is a reply to message #121069] |
Wed, 25 May 2005 17:31 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
personally I'd use a single user. It's easy enough to keep environments separate and you won't have files in the same directories having different owners. It's no fun to be 1/2 way through an installation only have it fail because the file it's writing to is owned by someone else. OraInventory is a directory which comes to mind. I would use different users if I have different groups of administrators and only wanted them to have access to their stuff.
|
|
|