Re: Cannot login as SYSTEM/SYSDBA

From: Vadim Grepan <kezal_at_mail.ru>
Date: Mon, 28 Jun 1999 17:53:42 +0400
Message-ID: <7l7uqq$c46$1@storm.comstar.ru>

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.

---cut-------------------------------------------------------

SVRMGR> grant sysdba on system;
grant sysdba on system

      *
ORA-00990: missing or invalid privilege

---cut-------------------------------------------------------

Received on Mon Jun 28 1999 - 08:53:42 CDT