Re: Cannot connect as SYSDBA!

From: <andreas.prusch_at_sintec.de>
Date: Sun, 24 May 1998 07:19:25 GMT
Message-ID: <6k8hlt$fve$1@nnrp1.dejanews.com>

In Oracle 7 you could set REMOTE_LOGIN_PASSWORD=EXCLUSIVE and then apply grant sysdba to system from the internal account. Naturally you have first create a password file. Because connect as sysdba works without database being up oracle can do the authentification only by passwordfile. Unfortunately (by Oracle 7) thze passwordfile only is updating when REMOTE_LOGIN_PASSWORD is set EXCLUSIVE which means that only one instance has access to the passwordfile. Hope this will help.

mfg
Andreas Prusch

In article <356768d6.2586836_at_news.mindspring.com>, robertch_at_mindspring.com wrote:
>
>
> I just installed Oracle 8 on Windows NT. Everything is working fine
> except for the fact that I cannot connect to Oracle as SYSDBA.
>
> "connect system/manager" works, but "connect system/manager as SYSDBA"
> does not. "select * from user_sys_privs" confirms "sys" and "system"
> accounts do not have SYSDBA privilege. What can I do to get SYSDBA
> privilege? Currently, REMOTE_LOGIN_PASSWORD is set to SHARED. Thanks
> in advance.
>
> PS: if I set REMOTE_LOGIN_PASSWORD to NONE to enable operating system
> athentication, Oracle instance fails to start. Why is that?
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun May 24 1998 - 02:19:25 CDT