在一个oracle 9208的数据库中,我们发现有大量的TNS-1169的告警:

24-APR-2012 11:13:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=au11qap850tels2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(PASSWORD=xxxxxxxx)(SERVICE=LISTENER_BDS02P1)(VERSION=153094144)) * status * 0
24-APR-2012 11:13:58 * ping * 0
24-APR-2012 11:13:58 * status * 1169
TNS-01169: The listener has not recognized the password


从数量上看,这么多的报错应该不是人为引起的,不可能是人为的在没有输入密码的前提下lsnrctl status失败。那么是什么引起的?




Listener Logs Show TNS-1169 When Agent is Monitoring Password Protected 9i Listener [ID 358411.1]

In this Document

Applies to:

Enterprise Manager Base Platform - Version: to - Release: 10.1 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 02-Apr-2012***

-The Following error messages gets logged in the password protected 9i listener that is being monitored by the Grid Control:

15-FEB-2006 23:58:04 * status * 1169
TNS-01169: The listener has not recognized the password


16-FEB-2006 00:00:45 * (CONNECT_DATA=(SID=dg2)(CID=(PROGRAM=perl)(HOST=incq048ad * services * 1169
TNS-01169: The listener has not recognized the password


16-FEB-2006 00:00:46 * (CONNECT_DATA=(CID=(PROGRAM=)(
ERSION=153093888)) * status * 1169
TNS-01169: The listener has not recognized the password

-These error messages are not logged when one of the following is done:

1) Agent is stopped
2) When the password is disabled for the listener
3) Remove the listener target from the grid control


The issue was investigated in BUG 6328973 : Agent Monitoring Password Protected Listener Logs Tns-1169 In Listener Log File


Follow either of below solution:

1) Upgrade to 10g or above listener where this problem is not encountered at all. Problem only occurs for 9i password protected listener. 

2) Disable listener password authentication if acceptable.

3) In case of, enter the Encrypted password into the Listener Password field.
 a. Copy the encrypted listener password from the listener.ora file
 b. Navigate to Targets -> All Targets -> Select the listener and click on Configure -> Enter the Encrypted password into the Listener Password field -> Click on OK.


au11qap850tels2:BDS01P1:/ora/product/emagent10g/agent10g/bin>emctl status agent
Oracle Enterprise Manager 10g Release 4 Grid Control  
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
Agent Version     :
OMS Version       :
Protocol Version  :
Agent Home        : /ora/product/emagent10g/agent10g/au11qap850tels2
Agent binaries    : /ora/product/emagent10g/agent10g
Agent Process ID  : 17720
Parent Process ID : 15931
Agent URL         : http://au11qap850tels2:3872/emd/main
Repository URL    :
Started at        : 2012-05-02 10:04:31
Started by user   : oracle
Last Reload       : 2012-05-03 15:25:25
Last successful upload                       : 2012-05-03 17:31:55
Total Megabytes of XML files uploaded so far :    28.10
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    31.63%
Last successful heartbeat to OMS             : 2012-05-03 17:33:53
Agent is Running and Ready



您的电子邮箱地址不会被公开。 必填项已用*标注