Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: starting Oracle from a account that has administrative privilege and a member of ora_dba group

Re: starting Oracle from a account that has administrative privilege and a member of ora_dba group

From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 12 Feb 2003 19:41:57 +0100
Message-ID: <3E4A9575.6090104@netscape.net>


Terry Dykstra wrote:
> Use sqlplus instead of svrmgrl.
>
> set oracle_sid = XXXX
> C:\oracle\ora9\BIN\sqlplusw.exe /nolog
>
> and connect as sysdba
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> "Frank" <fvanbortel_at_netscape.net> wrote in message
> news:3E494E02.5000706_at_netscape.net...
>

>>SP wrote:
>>
>>>I'm a domain user with administrative privileges and a memerber of
>>

> ora_dba
>
>>>group.  I want to start a Oracle instance, in absence of the dba who is
>>

> in
>
>>>charge of that box (Oracle 9i in windows 2000).  How do I do this?  I
>>

> used
>
>>>to start Oracle from svrmgrl in Oracle 8i in such situations.
>>>TIA,
>>>SP
>>>
>>>
>>
>>Still can... svrmgrl doesn't work for 9i anymore, but
>>still does for 8i...
>>
>>Frank
>>

>
>
>

I have seen many installations of 8i, where sysdba had to be granted explicitly to sys and system - and there's no way to do that, other than using svrmgrl.

Other than that, the OP seemed familiar with svrmgrl...

-- 
Regards, Frank van Bortel
Received on Wed Feb 12 2003 - 12:41:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US