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

I'm very sorry, in the prev mail I pressed the send button by accident!

So another stupid question regarding this issue: 'sysdba' is not a user of oracle. 'system' and 'sys' are initial users. So how can I connect as sysdba user?
Do I have to create it?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:tbn6jq24h9cj59_at_beta-news.demon.nl...
>
> "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 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
> >
> >
>
> Start a telnet session to the server, from your pc, connecting as unix
 user
> oracle. Now you should be able to connect as sysdba without problem.
> If you want to become sysdba from your pc you can at the same time change
> remote_login_password_file in init<sid>.ora to exclusive and bounce your
> database.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Sat Mar 24 2001 - 02:29:37 CST