Re: Error ORA-01031

From: Hans <Hans.Wijte_at_mail.ing.nl>
Date: 27 Sep 2006 06:20:38 -0700
Message-ID: <1159363238.353692.322870@m7g2000cwm.googlegroups.com>

calms wrote:
> HI,
>
> I installed the Optional SQL*Plus package but still i cudnt get rid of
> the error.
>
> Anyone know how to solve this error
>
> thks in advance

I'm not familiar with Windows, but in unix environments this usually occurs if :

- your database uses a password file
- and you try to connect as a privileged user (SYS, SYSTEM etc.)
- and the user with which you are trying to connect is not mentioned in

that password file (i.e. has NOT been granted sysdba)

If you had SQL*Plus you could have checked which users have been granted the SYSDBA privilege :

SQL> select * from v$pwfile_users;

Hans Received on Wed Sep 27 2006 - 08:20:38 CDT