oracle远程登录 01017,远程登录sys用户报错：ORA-01017: invalid username/password; logon denied...

远程登录sys用户报错：ORA-01017: invalid username/password; logon denied

今天有个客户反应数据库不能用sys用户远程登陆

情况如下：

SQL> conn sys/system123@xxxx as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied

SQL> conn sys/system@xxx as sysdba

Connected.

1.重建密码文件

orapwd file=/oracle/app/11.2.0/db_1/dbs/orapwxxx1 password=system123 entries=5

orapwd file=/oracle/app/11.2.0/db_1/dbs/orapwxxx2 password=system123 entries=5

重建密码文件需要重启数据库

保险起见在数据库中修改下sys密码

SQL> alter user sys identified by system123

SQL> conn sys/system123@xxxx as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied

远程登陆依然不行

2.检查remote_login_passwordfile参数

查看数据库，该参数值默认为none，如果要使sys远程登录，必须要改为exclusive才可以。

修改该参数:

$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 7 20:11:59 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> show prameter REMOTE_LOGIN_PASSWORDFILE

NAME                                 TYPE

------------------------------------ ----------------------

VALUE

------------------------------

remote_login_passwordfile            string

NONE

SQL>alter system set remote_login_passwordfile=exclusive scope=spfile;

RAC 环境两边都要重启后生效。

$ sqlplus sys/"system123"@xxxxx as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 7 20:22:05 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> -------远程方式成功登陆sys用户

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29371470/viewspace-1156279/，如需转载，请注明出处，否则将追究法律责任。