今天下午,有同事说有个数据库sys用户无法远程登录,总是报密码错误:
ORA-01017: invalid username/password; logon denied
连过去发现果然是这样:
SQL> conn
sys/admin@orcl
as sysdba
Connected.
Connected.
怀疑是remote_login_passwordfile参数的问题,查看数据库,果然是这个参数的问题,该参数值为none,如果要使sys远程登录,必须要改为exclusive才可以。于是按照下面的操作让他修改参数的值:
16:37:14
sys@ORCL
> alter system set REMOTE_LOGIN_PASSWORDFILE=none scope=spfile;
System altered.
16:37:16
sys@ORCL
> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:39:43 idle> startup
ORACLE instance started.
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
16:39:53 idle> conn
sys/admin@orcl
as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
16:40:02 idle> conn / as sysdba
Connected.
Connected.
16:40:43
sys@ORCL
> alter system set remote_login_passwordfile=exclusive scope=spfile;
System altered.
16:41:26
sys@ORCL
> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:41:37 sys@ORCL > startup
ORACLE instance started.
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
Connected.
16:42:02 sys@ORCL >
但是,同事一会说他这样做了之后依然不行。觉得很是奇怪~~最后突然想到,这个库是很久以前的库,装完数据库之后修改过sys用户的密码,所以怀疑之后修改的sys密码和密码文件里的密码不一致造成的。
这样可以通过两种方法解决:
1、把sys的密码修改成最初建库时的密码。
2、按照现在的sys密码重建密码文件。
这两种方法都不难,都可以很容易解决问题。于是,我猜了一下当初建库时可能的密码:change_on_install ~~~
当在sqlplus里把sys密码改成change_on_install之后,果然成功~~~~
相信重建密码文件也是可以达到这样的效果。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751371/viewspace-712565/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/751371/viewspace-712565/