Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-12547 listener auto disabled without error

741659Dec 17 2009 — edited Dec 17 2009

Oracle9.2.0.1.0 auto shutdown during running.
how to solve this problem?
who and why establish sid on different port?
+11-12月-2009 17:58:36 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1219)) * establish * orcl * 0+
+11-12月-2009 17:58:37 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1224)) * establish * orcl * 0+

listener.log :

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-12月-2009 17:55:38

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

系统参数文件为D:\oracle\ora92\network\admin\listener.ora
写入D:\oracle\ora92\network\log\listener.log的日志信息
写入D:\oracle\ora92\network\trace\listener.trc的跟踪信息

以 pid=1796 开始
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100-vod-02)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
11-12月-2009 17:55:52 * service_register * orcl * 0
11-12月-2009 17:56:00 * service_update * orcl * 0
11-12月-2009 17:56:21 * service_update * orcl * 0
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100-vod-02)(PORT=8080))(Presentation=HTTP)(Session=RAW))
监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100-vod-02)(PORT=2100))(Presentation=FTP)(Session=RAW))
11-12月-2009 17:56:24 * service_update * orcl * 0
11-12月-2009 17:56:51 * service_update * orcl * 0
11-12月-2009 17:57:24 * service_update * orcl * 0
11-12月-2009 17:58:30 * service_update * orcl * 0
11-12月-2009 17:58:36 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1219)) * establish * orcl * 0
11-12月-2009 17:58:37 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1224)) * establish * orcl * 0
11-12月-2009 17:59:03 * service_update * orcl * 0
11-12月-2009 18:03:27 * service_update * orcl * 0
11-12月-2009 18:04:33 * service_update * orcl * 0
11-12月-2009 18:05:35 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1580)) * establish * orcl * 0
11-12月-2009 18:05:35 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1583)) * establish * orcl * 0
11-12月-2009 18:05:35 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1586)) * establish * orcl * 0
11-12月-2009 18:06:59 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1652)) * establish * orcl * 0
11-12月-2009 18:06:59 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1655)) * establish * orcl * 0
11-12月-2009 18:08:41 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1738)) * establish * orcl * 0
11-12月-2009 18:08:41 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1741)) * establish * orcl * 0
11-12月-2009 18:09:54 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1821)) * establish * orcl * 0
11-12月-2009 18:09:54 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1824)) * establish * orcl * 0
11-12月-2009 18:14:36 * service_update * orcl * 0
11-12月-2009 18:53:54 * http * handoff * 0
11-12月-2009 19:07:22 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=4235)) * establish * orcl * 0
11-12月-2009 19:14:54 * service_update * orcl * 0
11-12月-2009 19:20:42 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=4815)) * establish * orcl * 0
11-12月-2009 19:22:25 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=4899)) * establish * orcl * 0
11-12月-2009 19:22:25 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=4902)) * establish * orcl * 0
11-12月-2009 19:24:57 * service_update * orcl * 0
11-12月-2009 19:28:44 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1224)) * establish * orcl * 0
11-12月-2009 19:35:00 * service_update * orcl * 0
11-12月-2009 19:40:15 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=1731)) * establish * orcl * 0
11-12月-2009 19:41:21 * service_update * orcl * 0
11-12月-2009 19:42:27 * service_update * orcl * 0
11-12月-2009 19:46:51 * service_update * orcl * 0
11-12月-2009 19:47:57 * service_update * orcl * 0
11-12月-2009 19:48:30 * service_update * orcl * 0
11-12月-2009 19:49:03 * service_update * orcl * 0
11-12月-2009 19:50:06 * service_update * orcl * 0
11-12月-2009 19:50:09 * service_update * orcl * 0
11-12月-2009 19:50:42 * service_update * orcl * 0
11-12月-2009 19:50:54 * service_update * orcl * 0
11-12月-2009 19:51:15 * service_update * orcl * 0
11-12月-2009 19:51:48 * service_update * orcl * 0
11-12月-2009 19:52:21 * service_update * orcl * 0
11-12月-2009 19:52:54 * service_update * orcl * 0
11-12月-2009 19:54:00 * service_update * orcl * 0
11-12月-2009 19:54:33 * service_update * orcl * 0
11-12月-2009 19:57:51 * service_update * orcl * 0
11-12月-2009 19:58:57 * service_update * orcl * 0
11-12月-2009 20:00:04 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=2742)) * establish * orcl * 0
11-12月-2009 20:03:21 * service_update * orcl * 0
11-12月-2009 20:04:27 * service_update * orcl * 0
11-12月-2009 20:06:39 * service_update * orcl * 0
11-12月-2009 20:07:27 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=3080)) * establish * orcl * 0
11-12月-2009 20:07:45 * service_update * orcl * 0
11-12月-2009 20:17:48 * service_update * orcl * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:13 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:14 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * service_update * orcl * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:15 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:16 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:17 * http * handoff * 0
11-12月-2009 20:23:18 * service_update * orcl * 0
11-12月-2009 21:20:31 * http * handoff * 0
11-12月-2009 21:52:53 * http * handoff * 0
11-12月-2009 22:07:29 * http * handoff * 0
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100-vod-02)(PORT=2100))(Presentation=FTP)(Session=RAW))
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100-vod-02)(PORT=8080))(Presentation=HTTP)(Session=RAW))
11-12月-2009 22:07:29 * service_died * orcl * 12547
TNS-12547: TNS：丢失连接
11-12月-2009 22:49:06 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.31)(PORT=2008)) * establish * orcl * 12500
TNS-12500: TNS：监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 2: No such file or directory

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2010

Added on Dec 17 2009

#general-database-discussions

2 comments

813 views