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

Hi!

Just to have my 2 cents here as well, I use:

set ORACLE_SID=<SID>
echo startup | sqlplus "/ as sysdba"

But since you are an administrator in your computes you also could just start the oracle service from service control panel or use "net start OracleServiceSID" from command prompt. (you might hit a conflict here, when Oracle service is configured to tun under SYSTEM OS user, you should remove sqlnet.authentication_services=(nts) from your sqlnet.ora in case of problems with startup. Or configure the service to run under a real domain user)

Cheers,
Tanel.

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:3aui4voeu0k2j2dfuloaj5448476rumbh9_at_4ax.com...
> On Tue, 11 Feb 2003 21:16:02 GMT, "SP"
> <sdpantDelete_this_to_reply_at_yahoo.com> wrote:
>
> >Thanks. Under the previously mentioned circumstance if I don't have a
sys
> >or system password (just a member of ora_dba group and domain user how do
I
> >start Oracle?
> >SP
>
>
> connect / as sysdba, as documented
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Feb 12 2003 - 16:14:29 CST