PSU升级后不reload listener是否会导致客户端无法连接

myownstars

OS: HP-UX
DB: 10205，刚从10204升级完毕
症状：数据库前几天从10204升级至10205，今天有开发人员报告说无法连接数据库。
登陆服务器，发现sqlplus / as sysdba可以登陆，且listener也已开启
SQL> select status,startup_time from v$instance;
STATUS       STARTUP_TIME
------------ -------------------
OPEN         2012-05-30 07:33:29
但是用sql developer则抱错ora-01304/ora-27101：oracle not available
在该服务器上配置tnsname指向该instance，  tnsping可以完成，但是sqlplus  [email=system/***@tnsname]system/***@tnsname[/email]还是报告ora-01304/ora-27101
数据库明明是启动的，但是错误信息却显示该instance没有启动(客户端配置无误)
该服务器上安装6个数据库，3个已升级至10205，剩余仍为10204，但凡10205从客户端连接均抱错，10204均可正常连接。
检查listener，看到拒绝了9个连接请求，此时别无他法，暂且将其reload一下，问题居然解决了。
不过还是不明白其中有何蹊跷，请Maclean帮忙查看一下吧，谢谢！
justin[justin]:/etc>/orasw/app/oracle/product/10.2.0.4/bin/lsnrctl service LISTENER
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 04-JUN-2012 05:28:14
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
Connecting to (ADDRESS=(COMMUNITY=TCPIP.world)(PROTOCOL=TCP)(Host=justin)(Port=1526))
Services Summary...
Service "justin" has 1 instance(s).
  Instance "justin", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:45270 refused:9
         LOCAL SERVER
The command completed successfully
justin[justin]:/etc>/orasw/app/oracle/product/10.2.0.4/bin/lsnrctl
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 04-JUN-2012 05:28:22
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> reload
Connecting to (ADDRESS=(COMMUNITY=TCPIP.world)(PROTOCOL=TCP)(Host=justin)(Port=1526))
The command completed successfully
LSNRCTL> exit
justin[justin]:/etc>/orasw/app/oracle/product/10.2.0.4/bin/lsnrctl service LISTENER
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 04-JUN-2012 05:30:01
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
Connecting to (ADDRESS=(COMMUNITY=TCPIP.world)(PROTOCOL=TCP)(Host=justin)(Port=1526))
Services Summary...
Service "justin" has 1 instance(s).
  Instance "justin", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2 refused:0
         LOCAL SERVER
The command completed successfully

Maclean Liu(刘相兵

你的10.2.0.5的数据库仍在使用 10.2.0.4的LISTENER ， 且10.2.0.4 的LISTENER没有reload 过 这会导致一些库信息失效， 在升级Patchset 的过程中式要求 关闭和重启 LISTENER的， 显然你这里没有这样做。

再次声明一下， 10.2.0.4=> 10.2.0.5 的 升级是patchset的升级， 不是 PSU !!