一、环境描述
- 数据库:9.2.0.8.0
- 系 统:Linux dzywjk02 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux
二、问题描述
- 设置密码
LSNRCTL> change_password Old password: New password: Reenter new password: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dzywjk02)(PORT=1521))) Password changed for LISTENER The command completed successfully LSNRCTL> set password Password: The command completed successfully LSNRCTL> save_config Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dzywjk02)(PORT=1521))) TNS-01169: The listener has not recognized the password LSNRCTL> exit
- listener文件没有任何变化
- 此时任何操作均反馈
TNS-01169: The listener has not recognized the password
三、问题分析
设置密码后没保存成功,与忘了密码后注释掉listener.ora中PASSWORDS_LISTENER情况类似四、解决方案
- 杀掉监听
ps -elf | grep lsnr | grep -v grep
kill -9 进程号 - 重启监听
- 如果原因是忘记密码,重启监听前应注释监听中如下代码