TNS-01169

一、环境描述

• 数据库：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情况类似

四、解决方案

1. 杀掉监听
   ps -elf | grep lsnr | grep -v grep
   kill -9 进程号
2. 重启监听
3. 如果原因是忘记密码，重启监听前应注释监听中如下代码