Re: beginner question

From: ivo zaenen <ivzae_at_gengenp.rug.ac.be>
Date: 2000/06/30
Message-ID: <395CCA48.15D62ACC@gengenp.rug.ac.be>#1/1

Thank you for your answer.I followed your advice and in first instance it did not work.However..
(I am working on windowsNT4server)On NT4 there is already a passwordfile with the users SYS and internal in it and the remote_login_passwordfile was already set to exclusive. So I tried SYS again without success When I tried the user internal/oracle I could grant the user sysdba and sysoper without any problem.
I do not understand why internal is ok and sys is not ok, maybe you do. Anyhow thanks for the advice.

Ivo Zaenen

sybrandb_at_my-deja.com wrote:

>
>
> First of all, you need to have setup a password file. As you don´t
> mention your platform and this procedure is platform and version
> specific dependent, I´m not going to outline the details. Either use
> the oradim utility (NT) or orapwd (unix)
> Secondly, the init<sid>.ora parameter remote_login_passwordfile needs
> to be set to exclusive to allow other users than SYS and internal to
> receive SYSDBA privilege. Edit the file, bounce the database and it
> should work
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------------------------------
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jun 30 2000 - 00:00:00 CDT