Re: Need to start Oracle DB under account other than 'oracle'

On Oct 25, 1:58 am, "karl" <mkmorri..._at_gmail.com> wrote:
> Hi, I have Oracle 10 on RHEL 4 Linux. The user 'oracle' was used to
> install two databases, demo1 and test1. I also created another user
> with oinstal and oragroup memebership which can start either DB however
> once they start up they both run under the account 'oracle'. I need
> them to run under the account name of the other user.
>
> I tried editing dbstart & using sqlplus but in each case the databasees
> all start under oracle, as seen in a ps output.
>
> Any suggestions?

I would recommend NOT to follow the suggestion to use 2 different users, or to verify the following problem, I noticed in Oracle 9i. Using a second user will change the ownership of the oraInventory, and will register the name of the installing user in the Orainventory. The consequence is you won't be able to upgrade Oracle any longer without hacking the Orainventory for every individual upgrade. This is obviously not supported.
What is your pressing business need? Or do you just like to live dangerously?

-- 
Sybrand Bakker