与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博客

与orapwd有关的两个错误