请教关于 listener 的问题

snail429

UID: 14095
帖子: 17
积分: 39
在线时间: 10 分钟

1^# snail429 发表于 2003-05-09 09:30

请教关于 listener 的问题

请教各位，

我的 listener 总是不好使，

$ lsnrctl start

几分钟之内还是好用的，
从客户端测试可以成功，
可是过不了一会就提示

The test did not succeed.
ORA-12545: 连接因对象主机或对象不存在而失败

$ lsnrctl stauts
Services Summary...
  rh7dev0             has 3 service handler(s)
  PLSExtProc          has 1 service handler(s)
  rh7dev0             has 1 service handler(s)
  rh7dev0             has 3 service handler(s)
The command completed successfully

其中 rh7dev0 是我建的数据库的 SID,

$ lsnrctl stop
$ lsnrctl start

就又可以用一会，可以测试成功，
请各位帮忙看一下，
谢谢。

listener.ora 文件如下，
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = rh7dev0.soft2)
   (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
   (SID_NAME = rh7dev0)
)
  )

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = soft2)(PORT = 1521))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
   )
)
  )　　　　　　