一：环境信息主机平台：linux6.2数据库版本：11.2.0.3（psu5）单实例二：问题现象lsnrctlstatus查看监听状态时发现没有监听文件（listenerparameterfile，正常情
一：环境信息
主机平台：linux 6.2
数据库版本：11.2.0.3（psu5）单实例
二：问题现象
  lsnrctl status查看监听状态时发现没有监听文件（listener parameter file，正常情况是会有监听文件信息的）
--注意因为问题库是商用库，不能把信息直接发出来。下面的内容是用测试环境模拟的
1.问题库的lsnrctl status信息
[oracle@localhost admin]$ lsnrctl statuslsnrctl for linux: version 11.2.0.4.0 - production on 15-apr-2014 17:47:28copyright (c) 1991, 2013, oracle. all rights reserved.connecting to (address=(protocol=tcp)(host=)(port=1521))status of the listener------------------------aliaslistenerversiontnslsnr for linux: version 11.2.0.4.0 - productionstart date15-apr-2014 17:25:41uptime0 days 0 hr. 21 min. 47 sectrace leveloffsecurityon: local os authenticationsnmpofflistener log file/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmllistening endpoints summary...(description=(address=(protocol=tcp)(host=localhost.localdomain)(port=1521)))services summary...service ora11g has 1 instance(s).instance ora11g, status ready, has 1 handler(s) for this service...the command completed successfully
2. 正常库的lsnrctl status信息
[oracle@localhost admin]$ lsnrctl statuslsnrctl for linux: version 11.2.0.4.0 - production on 15-apr-2014 17:24:56copyright (c) 1991, 2013, oracle. all rights reserved.connecting to (description=(address=(protocol=tcp)(host=localhost.localdomain)(port=1521)))status of the listener------------------------aliaslistenerversiontnslsnr for linux: version 11.2.0.4.0 - productionstart date15-apr-2014 17:17:16uptime0 days 0 hr. 7 min. 39 sectrace leveloffsecurityon: local os authenticationsnmpofflistener parameter file /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.oralistener log file/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmllistening endpoints summary...(description=(address=(protocol=tcp)(host=localhost.localdomain)(port=1521)))(description=(address=(protocol=ipc)(key=extproc1521)))services summary...service ora11g has 1 instance(s).instance ora11g, status ready, has 1 handler(s) for this service...the command completed successfully--注意对比发现1,2的信息发现问题库的lsnrctl status信息中缺少“listener parameter file *****”这一行信息。 cd $oracle_home/network/admin 下发现确实没有listener.ora文件。这个问题到底是怎么出现的呢？查了mos也没找到什么相关的信息。
三：故障模拟1
----个人猜测可能是listener.ora文件被别人误删了，所以决定从这个方面着手模拟
1. lsnrctl status（某个正常库，“listener parameter file”信息存在）
[oracle@localhost admin]$ lsnrctl statuslsnrctl for linux: version 11.2.0.4.0 - production on 15-apr-2014 17:24:56copyright (c) 1991, 2013, oracle. all rights reserved.connecting to (description=(address=(protocol=tcp)(host=localhost.localdomain)(port=1521)))status of the listener------------------------aliaslistenerversiontnslsnr for linux: version 11.2.0.4.0 - productionstart date15-apr-2014 17:17:16uptime0 days 0 hr. 7 min. 39 sectrace leveloffsecurityon: local os authenticationsnmpofflistener parameter file /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.oralistener log file/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmllistening endpoints summary...(description=(address=(protocol=tcp)(host=localhost.localdomain)(port=1521)))(description=(address=(protocol=ipc)(key=extproc1521)))services summary...service ora11g has 1 instance(s).instance ora11g, status ready, has 1 handler(s) for this service...the command completed successfully2. 删除listener.ora文件
cd $oracle_home/network/admin
mv listener.ora listener.ora.bak
3. lsnrctl status
--同第一步中lsnrctl status信息完全相同（删除以后信息还是正常的，可能是因为监听没有重启下面我们重启监听试试）
4.重启监听
1）lsnrctl stop
2）lsnrctl start
3）lsnrctl status
[oracle@localhost admin]$ lsnrctl statuslsnrctl for linux: version 11.2.0.4.0 - production on 15-apr-2014 17:47:28copyright (c) 1991, 2013, oracle. all rights reserved.connecting to (address=(protocol=tcp)(host=)(port=1521))status of the listener------------------------aliaslistenerversiontnslsnr for linux: version 11.2.0.4.0 - productionstart date15-apr-2014 17:25:41uptime0 days 0 hr. 21 min. 47 sectrace leveloffsecurityon: local os authenticationsnmpofflistener log file/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmllistening endpoints summary...(description=(address=(protocol=tcp)(host=localhost.localdomain)(port=1521)))services summary...service ora11g has 1 instance(s).instance ora11g, status ready, has 1 handler(s) for this service...the command completed successfully--问题现象重现，此时的监听信息中已没有了“listener parameter file”信息。
--可能大家会有疑问怎么没有listener.ora文件还能重启监听，这是因为我们用的是默认监听，，9i开始没有listener.ora也可以启动监听（默认监听）
5.还原listener.ora文件
1)mv listener.ora.bak listener.ora
2)lsnrctl status(还是没有“listener parameter file”信息)
3)重启监听
lsnrctl stop
lsnrctl start
4）lsnrctl status（出现“listener parameter file”信息）
--监听恢复正常
四：总结
  9i开始不需要listener.ora文件即可启动默认监听（监听主机名所对应的ip地址的1521端口）
1）安装oracle软件（未建库）
2）启动监听（安装完oracle软件，未配置listener.ora）