与orapwd有关的两个错误
1.用sys用户以sysdba登录报ORA-01031错误
SQL> conn sys/password@tnsname as sysdba
ERROR:
ORA-01031: insufficient privileges
原因:orapwd使用不当造成,文件名命名错误导致.
网上有人说是因为sqlnet.ora文件不存在,经验证在oracle10g r2下不管sqlnet.ora文件是否存在都可以登录
2.用sys用户以sysdba登录报ORA-01017
SQL> conn sys/password as sysdba
Connected.
SQL> conn sys/password@tnsname as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
解决方法:用orapwd重建密码文件即可.
附:orapwd的使用说明
Usage: orapwd file= password= entries= force=
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and
force - whether to overwrite existing file
file命名规则为orapw$ORACLE_SID
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7419833/viewspace-410016/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7419833/viewspace-410016/