Re: Insufficient privileges error when connecting via /nolog?

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 27 Jul 2006 17:27:30 +0200
Message-ID: <44c8dcf2$0$22017$9b4e6d93@newsread2.arcor-online.net>

mwsenecal_at_yahoo.com schrieb:
> Sorry, I banged that post out in a hurry.
>
> I'm using Oracle 9. I'm attempting to connect to it this way:
>
> sqlplus /nolog
>
> ....no problems here...
>
> connect /@<<DB_NAME>> as sysdba
>
> And this is where error "ORA-01030: insufficient privileges" is thrown.
> This is the first time I've ever seen this problem. Like I said in my
> original post, the account I'm using is already in the ORA_DBA group.
>

To be able connect as sysdba over Net 8, you must (in addition to be a member of privileged group and sqlnet.ora properly configured) have a password file and corresponding parameter configured in the parameter file. See
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1177.htm#1023215 http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1167

Best regards

Maxim Received on Thu Jul 27 2006 - 10:27:30 CDT