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

You have few options

1. Use the SYSOPER or SYSDBA role
2. Add the other user as part of the DBA UNIX group

--Renzo

--Renzo
karl 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?
Received on Thu Nov 09 2006 - 21:12:11 CET