Re: how to become SYSDBA rights

[Quoted] "Juergen Tolksdorf" <juergen.tolksdorf_at_de.twenty4help,com> wrote in message [Quoted] news:3beae108$0$191$4d4ebb8e_at_read.news.de.uu.net...
> Hello,
>
> I´ve a big problem!
> I cannot login to a Database as SYSDBA to shut down the database, cause I
> have not enough rights.
> When I log on as User SYS I get the message tha I have not enough right.
> I must reboot the DB, cause it makes many problems ...
>
> Has anyone a clue which Function/Role must be set to log on as Sysdba?
> The Database is startet on a cluster and I cannot reboot the whole
cluster,
> cause on the cluster are other tasks running ...
>
> fuck
>
> thanx in advance for your help
>
>

In a properly installed Unix system, any Unix user member of the dba group should be capable of using
connect / as sysdba
In a properly installed NT system, any account member of the _local_ ora_<sid>_dba group should be capable of doing this. SYS doesn't automatically have SYSDBA privs. You need to change remote_login_password_file in init<sid>.ora from none to [Quoted] shared to allow connect SYS/password as SYSDBA

Further details in the Oracle Server Administrators Manual.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address