Re: ORA-01031: insufficient privileges

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