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

Home -> Community -> Usenet -> c.d.o.misc -> Re: connect / as sysdba

Re: connect / as sysdba

From: Amogh <amogh.r_at_nospam.com>
Date: Tue, 09 May 2006 10:33:47 +0530
Message-ID: <MGV7g.45$6s5.192@news.oracle.com>


Raj wrote:
> Hi,
> I am a newbie and i am going through the Oracle DBA guide. It says
> you should be able to use connect / as sysdba. But i am not able to
> connect. I get the following error.
>
> ERROR:
> ORA-01031: insufficient privileges
>
> I am in ORA_DBA group in windows. My init.ora file says
> remote_login_passwordfile=EXCLUSIVE
> My sqlnet.ora has the line authentication line commented out like
> #SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> I would appreciate any help.
>
> Regards,
> Raj
>

The OS user you log in as must be part of the DBA group in /etc/group for SYSDBA connections and OPER group in /etc/group for SYSOPER connections.

Rgds.
Amogh Received on Tue May 09 2006 - 00:03:47 CDT

Original text of this message

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