oracle监听无法关闭,EBS 11i 数据库监听无法关闭 [已解决]

今天想让机子休息一下，于是就进行了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 :

[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

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

[本帖最后由 kjh2004yjn 于 2009-9-15 11:13 编辑]