Re: Insufficient privileges error when connecting via /nolog?

On 26 Jul 2006 11:36:13 -0700, mwsenecal_at_yahoo.com wrote:

>I keep getting an error 01031: Insufficient Privileges, when attempting
>to connect to my database via sqlplus using the /nolog option. The
>account I am using is an account that is a domain administrator, and is
>in the local ORA_DBA and Administrators groups. From what I understand,
>this should be enough. Is there something I'm overlooking? Any
>assistance is appreciated.
>
>If it makes any difference, I'm operating on a Windows 2000 server
>(part of an MSCS Cluster) in a Windows 2000 domain with Active
>Directory.
>
>Thanks!
>
>---Matt
>

Feel free to give Oracle version next time...........

You don't "connect" with the /nolog option....in fact that switch effectively makes sql*plus startup without connecting at all......

I guess what you want is to connect as sysdba, which you can accomplish by doing the following :

1. add the following line in %ORACLE_HOME%\network\admin\sqlnet.ora :

SQLNET.AUTHENTICATION_SERVICES = (NTS) and then

c:\>set oracle_sid=<yourSID>
c:\>sqlplus "/ as sysdba"

OR

c:\>set oracle_sid=<yourSID>
c:\>sqlplus /nolog
SQL>connect / as sysdba

• Kenneth Koenraadt