Re: [Q] insufficient privilege while "connect / as sysdba" on NT?

Having "administrator" privileges (actually being a member of "Administrators" group) is not enough.
If you want to "connect / as sysdba", you should be a member of ORA_DBA group.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, February 14, 2003 2:31 PM

>
> e have ORACLE 8.1.7 on NT server and I login as user wirh
> "administrator" privilege. I tried to "connect / as sysdba" and got
> "insufficient prvilege". The procedure are:
>
> 1. on DOS window
> 2. sqlplus /nolog
> 3. connect / as sysdba
> ORA-001031 insufficient privileges
>
>
> I have been recreate the password file on oracle
> ($ORACLE_HOME/databae/pwXXX.ora). Still make no difference.
> If I use "svrmgrl" ==> "connect internal", it work fine.
>
>
> Does anyone know why?
>
> Thanks.
>
>
>
>
>
> _________________________________________________________________
> Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: dist cash
> INET: mccdba_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).