0 积分	1 好友	7 主题

发消息

[SQL调优] 数据库监听自动停掉，求助

1^#

发表于 2013-7-17 09:28:01 | 查看: 3564| 回复: 4

麻烦给看一下，数据库监听自动停掉，附近是监听配置文件和监听日志，谢谢

监听和日志.rar

115.58 KB, 下载次数: 896

监听和日子

分享0

收藏0 回复只看该作者道具举报

sunjt888@qq.com

2^#

发表于 2013-7-17 09:32:09

本帖最后由 sunjt888@qq.com 于 2013-7-17 09:37 编辑

数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

[oracle@bidwh admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-JUL-2013 09:38:27

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date             17-JUL-2013 07:46:01
Uptime                   0 days 1 hr. 52 min. 26 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Listener Log File       /u01/app/grid/diag/tnslsnr/bidwh/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bidwh.daphne.com.cn)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "DWH" has 1 instance(s).
  Instance "DWH", status READY, has 1 handler(s) for this service...
Service "DWHXDB" has 1 instance(s).
  Instance "DWH", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@bidwh admin]$

回复只看该作者道具举报