Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: connect / as sysdba
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
![]() |
![]() |