View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 10:25 AM
Amogh
 
Posts: n/a
Default 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
Reply With Quote