Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot login as SYSTEM/SYSDBA
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
---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