EBS 11i 数据库监听无法关闭

kjh2004yjn

今天想让机子休息一下，于是就进行了EBS关闭的流程。

首先是应用服务的关闭 - 正常

然后是数据库监听的关闭， 我的操作与结果如下：
[oravis@vostro VIS_vostro]$ pwd
/u01/oracle/ora/visdb/9.2.0/appsutil/scripts/VIS_vostro
[oravis@vostro VIS_vostro]$ sh addlnctl.sh stop
You are running addlnctl.sh version 115.6

addlnctl.sh: too few arguments specified.
        addlnctl.sh {start|stop} listener_name
        In general, available listeners are
                   Database Net8 listener : <ORACLE_SID>
[oravis@vostro VIS_vostro]$ sh addlnctl.sh stop ORACLE_VIS
You are running addlnctl.sh version 115.6
Logfile: /u01/oracle/ora/visdb/9.2.0/appsutil/log/VIS_vostro/addlnctl.txt
Shutting down listener process ORACLE_VIS ...

addlnctl.sh: exiting with status 1

于是我查看日志文件： /u01/oracle/ora/visdb/9.2.0/appsutil/log/VIS_vostro/addlnctl.txt

[oravis@vostro VIS_vostro]$ cat /u01/oracle/ora/visdb/9.2.0/appsutil/log/VIS_vostro/addlnctl.txt
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 11-SEP-2009 01:30:28
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCVIS))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=vostro.oraebs11i.com)(Port=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 11-SEP-2009 01:30:28
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Starting /u01/oracle/ora/visdb/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.6.0 - Production
System parameter file is /u01/oracle/ora/visdb/9.2.0/network/admin/VIS_vostro/listener.ora
Log messages written to /u01/oracle/ora/visdb/9.2.0/network/admin/vis.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCVIS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vostro.oraebs11i.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCVIS))
STATUS of the LISTENER
------------------------
Alias                     VIS
Version                   TNSLSNR for Linux: Version 9.2.0.6.0 - Production
Start Date                11-SEP-2009 01:30:28
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/oracle/ora/visdb/9.2.0/network/admin/VIS_vostro/listener.ora
Listener Log File         /u01/oracle/ora/visdb/9.2.0/network/admin/vis.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCVIS)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vostro.oraebs11i.com)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "VIS" has 1 instance(s).
  Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 11-SEP-2009 01:32:22
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCVIS))
The command completed successfully
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 11-SEP-2009 01:32:23
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCVIS))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=vostro.oraebs11i.com)(Port=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 11-SEP-2009 01:32:23
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Starting /u01/oracle/ora/visdb/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.6.0 - Production
System parameter file is /u01/oracle/ora/visdb/9.2.0/network/admin/VIS_vostro/listener.ora
Log messages written to /u01/oracle/ora/visdb/9.2.0/network/admin/vis.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCVIS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vostro.oraebs11i.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCVIS))
STATUS of the LISTENER
------------------------
Alias                     VIS
Version                   TNSLSNR for Linux: Version 9.2.0.6.0 - Production
Start Date                11-SEP-2009 01:32:23
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/oracle/ora/visdb/9.2.0/network/admin/VIS_vostro/listener.ora
Listener Log File         /u01/oracle/ora/visdb/9.2.0/network/admin/vis.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCVIS)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vostro.oraebs11i.com)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "VIS" has 1 instance(s).
  Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 11-SEP-2009 22:05:54
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Connecting to (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=ORACLE_VIS.oraebs11i.com))(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLE_VIS)(PORT=1521)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
  TNS-00505: Operation timed out
   Linux Error: 110: Connection timed out

各位可以帮我看看问题出在哪里吗？ 谢谢！

calvin

关闭监听时，如果不是默认的LISTENER，都需要指定监听的名字，EBS基本都不是默认的LISTENER ，而是安装时指定的SID，所以你在执行这个脚本时，应该按如下操作：
sh addlnctl.sh stop VIS

kjh2004yjn

谢谢, 问题解决了.