Re: How to become SYSDBA - Oracle 8i Sun Solaris

From: Anton G. Sokolovsky <me_at_dgraf.eu.org>
Date: Fri, 23 Mar 2001 17:34:49 +0200
Message-ID: <99fqdg$4he$1@alice.infopulse.kiev.ua>

"Carsten Jacobs" <carsten.jacobs_at_web.de> wrote in message news:99fp0d$12fn1$1_at_ID-21443.news.dfncis.de...
> Hi admins,
>
> I installed O8i 1.7 and a database whichnis running in NOARCHIVELOG mode.
> Now I want to change this. But I don't know how.
> In the DBA-studio I can't connect as SYS with SYSDBA priv. Igot the error
> message 'insufficient priviledges'. Then I tried to grant the
> systempriviledge SYSDBA to sys but it's simply not there.

I think it has something to do with "remote_login_passwordfile" option of init<SID>.ora file

Guess, it should be set to "exclusive"

>
> I have an O8i on NT and there I can find this priv.
>
> So what can I do for switching to ARCHIVELOG mode?
>
> Many thanks for any help
>
> Carsten
>
>
Received on Fri Mar 23 2001 - 09:34:49 CST