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

"Carsten Jacobs" <carsten.jacobs_at_web.de> wrote in message news:99hlth$18b68$1_at_ID-21443.news.dfncis.de...
> 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?

System is a user who has been granted the DBA role. Sys is a user who has also been granted the DBA.

"Sysdba" is not a user, but a particular system privilege, which implies the right to startup, shutdown, backup, recover and create databases. Since it is a system privilege, it can be granted to anyone you like (provided you have an exclusive password file for each database). Oracle has already granted it to Sys, for you.

Therefore, you don't have to create a sysdba user, you simply have to log on as an existing user (to whom the privilege has been granted), but claim the exercise of that privilege as you do so. Hence 'connect sys/password' means 'get me on as sys'. But 'connect sys/password as sysdba' means 'get me on as sys, with the ability to exercise the sysdba password'.

To confuse things slightly, ordinary sys has the default password 'change_on_install', but when you ask to use sysdba privileges, because we change the authentication mechanism (clearly, if you are about to start the database up, we can't use the database to authenticate you), the password changes to 'oracle' (by default).

That difference in passwords is only true of sys, and only true in a fresh database. If you change sys's password, both versions are synchronised. And if you grant sysdba to a normal user, then that user's ordinary password is also used for sysdba authentication.

Regards
HJR
>
>
>
> "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 - 04:06:33 CST