Re: how to become SYSDBA rights

Thanks a lot for your help :-)))

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tulu4m7lbp3f09_at_corp.supernews.com...
>
> "Juergen Tolksdorf" <juergen.tolksdorf_at_de.twenty4help,com> wrote in
message
> 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
> 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
>
>
>
Received on Thu Nov 08 2001 - 22:43:05 CET