Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot login as SYSTEM/SYSDBA

Re: Cannot login as SYSTEM/SYSDBA

From: Vadim Grepan <kezal_at_mail.ru>
Date: Tue, 29 Jun 1999 09:44:28 +0400
Message-ID: <7l9mhf$i49$1@storm.comstar.ru>


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 Received on Tue Jun 29 1999 - 00:44:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US