TNS-01169

来源：互联网发布：沉迷网络的危害小短文编辑：程序博客网时间：2024/06/02 06:00

一、环境描述

数据库：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_passwordOld password:New password:Reenter new password:Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dzywjk02)(PORT=1521)))Password changed for LISTENERThe command completed successfullyLSNRCTL> set passwordPassword:The command completed successfullyLSNRCTL> save_configConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dzywjk02)(PORT=1521)))TNS-01169: The listener has not recognized the passwordLSNRCTL> exit

listener文件没有任何变化
此时任何操作均反馈
TNS-01169: The listener has not recognized the password

三、问题分析

设置密码后没保存成功，与忘了密码后注释掉listener.ora中PASSWORDS_LISTENER情况类似

四、解决方案

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

阅读全文

0 0