首页 > IT职业 > IT职场 > 以SYSDBA登录报错的一例
无法使用sqlplus的 conn sys/syspass@finance as sysdba登录,报错信息为ERROR:
ORA-01017: invalid username/password; logon denied
怀疑sys用户的密码不对,尝试修改用户密码:
sql>alter user sys identified by syspass;
然后使用conn sys/syspass@finance as sysdba登录仍然报相同错误,而使用conn sys/syspass as sysdba可以正常连接,没辙了。。。
不会是权限不足吧,权限不足的报错是ORA-01031 insufficient privileges 啊,管它,SQL> conn / as sysdba
Connected.
SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
又报这个错,这下信息明朗多了,oracle的解释是
Cause: A grant failed because a user could not be added to the password file. This is because the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to SHARED.
Action: To add a user to the password file, shut down the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and restart the database.
sql>show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string NONE
修改该参数SQL> alter system set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE scope=spfile;
重新启动数据库,再次使用sql>conn sys/syspass@finance as sysdba
Connected.
问题解决,个人觉得有点意思,所以记录下来。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/73920/viewspace-1008989/ ,如需转载,请注明出处,否则将追究法律责任。