环境:
OS:AIX 4.3
DB:8.1.7
今天刚接触到服务器上的数据库lsnrctl发现监控器没有启动，但用户可以连接到数据库。后来，发现服务器配备了多个监控器（其中一些不使用）。以下是问题定位过程.
1.进入监控，查看状态信息
$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 16-OCT-2012 17:54:03
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused
LSNRCTL>第一反应是监控没有启动，检查OS进程
2.查看OS进程
$ ps -ef|grep lsnr
oracle 24300 1 0 02:51:34 - 0:27 /usr/oracle/app/oracle/product/8.1.7/bin/tnslsnr lsnrm203 -inherit
oracle 28286 31382 0 17:14:27 pts/0 0:00 grep lsnr
这里有监控过程在运行.
3.客户端能tnsping通该数据库
$ tnsping m203_db
TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 16-OCT-2012 17:55:23
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.5.228)(PORT=1521))
OK (10 msec)
这里可以tnsping通.
在抑郁症中，所以检查listener.ora文件
4.查看listener.ora文件
$ more listener.ora
# LISTENER.ORA Network Configuration File: /usr/oracle/app/oracle/product/8.1.7/
network/admin/listener.ora
# Generated by Oracle configuration tools.
LSNRP203 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.230)(PORT = 1521))
)
LSNRM203 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.228)(PORT = 1521))
)
SID_LIST_LSNRM203 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = m203_db)
(ORACLE_HOME = /usr/oracle/app/oracle/product/8.1.7)
(SID_NAME = m203)
)
)
SID_LIST_LSNRP203 =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /usr/oracle/app/oracle/product/8.1.7)
(SID_NAME = p203)
)
)呵呵，好像配置了多个监听器。.
检查具体的监听器lsnrm203
5.检查具体的监听器
$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 16-OCT-2012 17:59:15
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status lsnrm203
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.5.228)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias lsnrm203
Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production
Start Date 16-OCT-2012 02:51:34
Uptime 0 days 15 hr. 7 min. 56 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /usr/oracle/app/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File /usr/oracle/app/oracle/product/8.1.7/network/log/lsnrm203.log
Services Summary...
m203 has 1 service handler(s)
The command completed successfully
LSNRCTL>可见监控正常。.
-- The End --