How to login as sysdba?
I have an Oracle8.03 on NT, I cannot login as SYSDBA or SYSOPER even
using SYS
or SYSTEM users, login as NORMAL, I found SYS and SYSTEM do have DBA
role
gained, then why cannot I login as SYSDBA to do backup work?
Ans1:
While sysdba is a special privilege granted through the password file.
remote_login_passwordfile init.ora parameter should be either shared
or exclusive,
the default is none. In the former case only SYS and INTERNAL will
have sysdba
privilege, in the latter case any account can be granted sysdba privilege.
This
can be done by grant sysdba to <user> and verified by
select * from v$pwfile_users.
Hth,
Sybrand Bakker, Oracle DBA
Ans2:
grant sysdba to sys