Re: ORA-01031: insufficient privileges

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 23 Feb 2007 16:37:48 -0800
Message-ID: <1172277468.166069@bubbleator.drizzle.com>

joel garry wrote:
> On Feb 23, 3:26 pm, "lazyboy..._at_yahoo.com" <lazyboy..._at_yahoo.com>
> wrote:

>> Thx all for the inputs/suggestions. I found out that there is a way to
>> get into it & I can stop & start & do some other stuffs in db w/o any
>> problems.  However, I still can't find out why it can't connect / as
>> sysdba.  I'd love to resolve why I can't do it.
>>
>>  $ sqlplus /nolog
>>
>> SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 23 15:17:00 2007
>>
>> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
>>
>> SQL> conn / as sysdba
>> ERROR:
>> ORA-01031: insufficient privileges
>>
>> SQL> conn sys/oracle as sysdba
>> Connected.
>> SQL>
>>
>> -Chris

>
> Correction to my previous post: You created a user named sysdba and a
> group named oracle. This is very confusing, backwards to how we
> usually think.
>
> Once again, do you have a password file (perhaps you need to recreate
> it - please post an ls -l of your $ORACLE_HOME/dbs)? What are the
> contents of your sqlnet.ora file (particularly, do you have an
> authentication_services line)? Have you looked at select * from v
> $pwfile_users; If you put in conn sys/blabla as sysdba do you connect?
>
> I just noticed my XE beta on W2K does the same thing, no / as sysdba
> allowed.
>
> jg
> --
> @home.com is bogus.
> http://www.peepresearch.org/vacuum.html

Again my advice to the OP.

Burn it to the ground.
Read the docs.
This time follow them.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Feb 23 2007 - 18:37:48 CST