Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
Received on Fri Apr 30 2004 - 00:41:51 CDT