数据库监听程序问题

余金

A为数据库服务器，B为客户端，现发现所有的客户端都不能连接数据库，报ORA-12545:TNS:无法察看名称,此时察看监听状态如下：
$ lsnrctl status

LSNRCTL for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production on 25-APR-06 08:13:4
0

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Intel SVR4 UNIX: Version 8.1.5.0.0 - Produ
ction
Start Date                25-APR-06 07:47:49
Uptime                    0 days 0 hr. 25 min. 51 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/network/admin/listener.ora
Listener Log File         /oracle/network/log/listener.log
Services Summary...
  PLSExtProc            has 1 service handler(s)
  ORCL          has 3 service handler(s)
The command completed successfully
如果把监听stop然后在重新启动之后，用户就可以联接上A，但4~5分钟后又不能连接，在服务器上仍然可以连接到数据库。
listener.ora配置如下：
# LISTENER.ORA Configuration File:/oracle/network/admin/listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = obs)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle)
      (PROGRAM = extproc)
    )
  )

余金

有没有人帮帮我呀！

rollingpig

1。 抱什么错？
2。客户端tnsnames.ora
3.报措时的操作log
4.报措时，再运行lsnrctl service

余金

服务器为scounix
报错时运行lsnrctl service报告如下：
LSNRCTL for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production on 25-APR-06 09:28:2
6

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
  PLSExtProc            has 1 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
  ORCL          has 3 service handler(s)
    DEDICATED SERVER established:6 refused:0
      LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:254 state:ready
      D000 <machine: obs, pid: 1805>
      (ADDRESS=(PROTOCOL=tcp)(HOST=obs.obs174)(PORT=32807))
      Presentation: oracle.aurora.server.SGiopServer
    DISPATCHER established:4 refused:0 current:0 max:254 state:ready
      D001 <machine: obs, pid: 1807>
      (ADDRESS=(PROTOCOL=tcp)(HOST=obs.obs174)(PORT=3280)
The command completed successfully


客户端配置如下（winxp）：
OBS174 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.236.9.174)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = obs)
    )
  )

listener.log如下：
25-APR-06 09:08:54 * obs * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)(PORT=1317
)) * service_update * ORCL * 0
25-APR-06 09:14:01 * obs * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)(PORT=1317
)) * service_update * ORCL * 0
25-APR-06 09:18:56 * obs * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)(PORT=1317
)) * service_update * ORCL * 0
25-APR-06 09:18:56 * obs * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)(PORT=1317
)) * service_update * ORCL * 0
25-APR-06 09:24:03 * obs * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)(PORT=1317
)) * service_update * ORCL * 0
25-APR-06 09:28:26 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=obs)(USER=oracle))(COMMA
ND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135286784)) * services * 0
25-APR-06 09:28:56 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PLUS33.exe)(HOST=MS-7
F47C5A0AD70)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)
(PORT=1420)) * establish * ORCL * 0
25-APR-06 09:28:57 * obs * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)(PORT=1420
)) * service_update * ORCL * 0
25-APR-06 09:28:57 * obs * (ADDRESS=(PROTOCOL=tcp)(HOST=133.236.37.52)(PORT=1420
)) * service_update * ORCL * 0

余金

老大们帮我看一下吧。

余金

自己顶一下，大家帮看看吧。