Re: SYSDBA access (newbie)

From: Chief <chiefgecko_at_mail.com>
Date: 19 May 2003 14:23:02 -0700
Message-ID: <71497b46.0305191323.62ef5e80@posting.google.com>

"John M" <bali1a_at_freemail.hu> wrote in message news:<bt9ya.7750$FJ4.81567_at_news.chello.at>...
> Hello,
>
> I have just installed an Oracle 8i. I want to use DBA Studio to connect to
> my DB. I want to login as SYSDBA with the default system/manager login. But
> I become a message:
> ORA-01031: insufficient privileges.
> I have installed this Oracle version to an other PC too, and there I can
> login.
>
> What can be the problem?
>
> Thanks!

Connect to the 'sys' username using
sqlplus "/ as sysdba"
or
using DBA Studio connect to SYS using password with the "AS SYSDBA" option.

Then...

execute the sql: GRANT SYSDBA TO SYSTEM
If this succeeds, then connect to the SYSTEM username using the "AS SYSDBA" option. If you still get ORA-01031 post a reply and someone can talk you through creating a password file and/or setting a init.ora param.

Ciao, Tim... Received on Mon May 19 2003 - 16:23:02 CDT