View Single Post

   
  #2 (permalink)  
Old 02-23-2008, 10:12 AM
Howard J. Rogers
 
Posts: n/a
Default Re: W2000 connect / as sysdba problem

Andrew wrote:
> Hi,
> I am setting up new Oracle 9.2 DB on my laptop.
> problem is that I can connect as SYSDBA using
>
> connect sys/sys as sysdba
>
> but when I am using
>
> connect / as sysdba
>
> I am always getting ORA-01031: insufficient privileges
>
> I have created instance using
> oradim -new -sid OPWVDB1L -startmode manual -pfile
> c:\oracle\ora92\database\initOPWVDB1L.ora
>
> in sqlnet.ora I have
> SQLNET.AUTHENTICATION_SERVICES= (NTS)


Get rid of that line (or comment it out) and then see what happens.

Regards
HJR
Reply With Quote