17,377
社区成员
发帖
与我相关
我的任务
分享Oracle8.1.7本地可以SYS以NORMAL身份登录,但是不能用SYSDBA登录,怎么办???
用户SYS用SYSDBA身份登录出现提示"nsuffient privillage(权限不够)",Windows 2000 Advanced Server下以Adminstrator什么登录的.系统是NTFS分区的.
SYS用NORMAL身份可以登录.
哪位有过类似经验,请教了,谢谢.
SYS用NORMAL身份可以登录.
哪位有过类似经验,请教了,谢谢.
...全文
请发表友善的回复…
发表回复
zhaoyongzhu 2002-09-21
- 打赏
- 举报
哎。来晚了。
ultrared 2002-09-21
- 打赏
- 举报
多谢几位,给分了!
black_snail 2002-09-20
- 打赏
- 举报
You can query
V_$PWFILE_USERS
to know the current sysdba , sysopr
V_$PWFILE_USERS
to know the current sysdba , sysopr
black_snail 2002-09-20
- 打赏
- 举报
sys is not a sysdba user as default ,
Sysdba password is stored in password file , And normal dba password is stored in data dictionary .
So let's say sysdba password is oracle and sys's password is changed_on_install .
After grant sysdba to sys ( from internal ) ,
if you connect to sysdba
you should specify :
connect sys/oracle as sysdba
while normal connection is
connect sys/change_on_install (note the password is different)
Sysdba password is stored in password file , And normal dba password is stored in data dictionary .
So let's say sysdba password is oracle and sys's password is changed_on_install .
After grant sysdba to sys ( from internal ) ,
if you connect to sysdba
you should specify :
connect sys/oracle as sysdba
while normal connection is
connect sys/change_on_install (note the password is different)
jery_lu 2002-09-20
- 打赏
- 举报
你用的是不是操作系统认证啊?如果是这样的话,你要给你的登陆用户(administator)dba的权限.
或者你改成密码文件认证,那么这样:
你的初始参数文件(init.ora)中remote_login_passwordfile = exclusive;
并且sqlnet.ora中SQLNET.AUTHENTICATION_SERVICES= (NONE)
你去试一下吧
或者你改成密码文件认证,那么这样:
你的初始参数文件(init.ora)中remote_login_passwordfile = exclusive;
并且sqlnet.ora中SQLNET.AUTHENTICATION_SERVICES= (NONE)
你去试一下吧
bzszp 2002-09-20
- 打赏
- 举报
connect internal/oracle
grant sysdba to sys;
grant sysdba to sys;
