Re: Cannot login as SYSTEM/SYSDBA

Hi Vadim
What is the value of
remote_login_passwordfile (never remember where the underscores are) For SYSTEM to be enabled as SYSDBA it should be 'exclusive'. The error message below is a clear symptom of an incorrect parameter.

Hth,

Sybrand Bakker, Oracle DBA

In article <7l9mhf$i49$1_at_storm.comstar.ru>,   "Vadim Grepan" <kezal_at_mail.ru> wrote:
> Hello Pete!
>
> Pete Sharman ïèøåò â ñîîáùåíèè <37779BB6.977F8E27_at_us.oracle.com> ...
> >Simple syntax error. It should be "grant sysdba to system".
> Yes, I've found already, but...
>
> ---cut-------------------------------------------------------
> SVRMGR> connect internal
> Connected.
> SVRMGR>grant sysdba to system
> grant sysdba to system
> *
> ORA-01994: GRANT failed: cannot add users to public password file
> ---cut-------------------------------------------------------
>
> Password file '/opt/oracle7/dbs/orapwWG73' has been created by orapwd
>
> >> Hello Kenny!
> >> >Check v$pwfile_user. By default SYSTEM does not have SYSDBA
privileges.
> >>
> >> Yes:
> >> ---cut-------------------------------------------------------
> >> SVRMGR> select * from v$pwfile_users;
> >> USERNAME SYSDB SYSOP
> >> ------------------------------ ----- -----
> >> INTERNAL TRUE TRUE
> >> SYS TRUE TRUE
> >> 2 rows selected.
> >> ---cut-------------------------------------------------------
> >>
> >> And what should i do to grant SYSDBA to anyone, e.g. SYSTEM?
> >> I tried login as oracle and startup svrmgrl,but It fails.
> >>
>
> Rgds, Vadim
>
>

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 29 1999 - 03:14:21 CDT