Robert Chung wrote:
>
> "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.
1) Set REMOTE_LOGIN_PASWORD to EXCLUSIVE
2) Create ORAPWDFILE through ORAPWD (please check the Oracle Admin Guide
for correct syntax).
3) grant SYSDBA to system
Received on Tue May 26 1998 - 20:45:20 CDT
