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

To access your database with all priviledges from Enterprise Manager it's another problem that you'll solve with orapwd: it's easy. To put your database in archivelog mode it's easy too :) modify three parameters in initSID.ora, something_archive_dest, something_archive_format and something_archive_start=true... :) :) (I don't remember these parameters well)
and then:
startup mount;
alter database archivelog;
alter database open;

Bye

Carsten Jacobs wrote:

> 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 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 Sat Mar 24 2001 - 15:57:44 CST