Chinaunix

标题: 数据库监听程序问题 [打印本页]

作者: 余金 时间: 2006-04-25 08:25
标题: 数据库监听程序问题
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)
)
  )

作者: 余金 时间: 2006-04-25 09:20
有没有人帮帮我呀！

作者: rollingpig 时间: 2006-04-25 09:24
1。抱什么错？
2。客户端tnsnames.ora
3.报措时的操作log
4.报措时，再运行lsnrctl service

作者: 余金 时间: 2006-04-25 09:41
服务器为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

作者: 余金 时间: 2006-04-25 13:56
老大们帮我看一下吧。

作者: 余金 时间: 2006-04-25 21:48
自己顶一下，大家帮看看吧。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)