以前都正常,今天就不正常了,oracle 10g 服务器,在系统服务里面看了监听已经启动了,各位大虾,帮助解决一下
listener.ora
# listener.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zf02)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora
# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.CDW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zf02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cdw)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora
# listener.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zf02)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora
# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.CDW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zf02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cdw)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
在服务器上不能用,换个机器就好了。不明白
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
) 改成下面的样子后, 重启监听试试:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = cdw)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
)
)
lsnrctl stat停止监听,
lsnrctl stop
再打开
lsnrctl start再lsnrctl stat把信息都贴上来看看
7:31Copyright (c) 1991, 2006, Oracle. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
ction
启动日期 23-2月 -2009 16:59:31
正常运行时间 0 天 0 小时 7 分 59 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 c:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 c:\oracle\product\10.2.0\db_1\network\log\listener.log监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
服务摘要..
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功C:\Documents and Settings\Administrator>lsnrctl stopLSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 23-2月 -2009 17:0
8:49Copyright (c) 1991, 2006, Oracle. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
命令执行成功C:\Documents and Settings\Administrator>lsnrctl startLSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 23-2月 -2009 17:0
9:43Copyright (c) 1991, 2006, Oracle. All rights reserved.启动tnslsnr: 请稍候...TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
系统参数文件为c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入c:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
ction
启动日期 23-2月 -2009 17:09:45
正常运行时间 0 天 0 小时 0 分 1 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 c:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 c:\oracle\product\10.2.0\db_1\network\log\listener.log监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
服务摘要..
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功C:\Documents and Settings\Administrator>lsnrctl statLSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 23-2月 -2009 17:1
0:31Copyright (c) 1991, 2006, Oracle. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
ction
启动日期 23-2月 -2009 17:09:45
正常运行时间 0 天 0 小时 0 分 46 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 c:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 c:\oracle\product\10.2.0\db_1\network\log\listener.log监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
服务摘要..
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
把c:\oracle\product\10.2.0\db_1\network\log\listener.log 里最近的错误也帖一些上来看看
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = cdw)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(SID_NAME = cdw)
) LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zf02)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
9:08Copyright (c) 1991, 2006, Oracle. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
服务摘要..
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
处理程序:
"DEDICATED" 已建立:0 已被拒绝:0
LOCAL SERVER
命令执行成功监听日志太大了不好打开有2个G
TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production on 24-2月 -2009 11:27:21Copyright (c) 1991, 2006, Oracle. All rights reserved.系统参数文件为c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入c:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
写入c:\oracle\product\10.2.0\db_1\network\trace\listener.trc的跟踪信息
跟踪级别当前为0以 pid=2572 开始
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zf_database)(PORT=1521)))
Listener completed notification to CRS on startTIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
24-2月 -2009 11:27:39 * (CONNECT_DATA=(SID=cdwsjd)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ZF_DATABASE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=125.69.80.26)(PORT=1415)) * establish * cdwsjd * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
24-2月 -2009 11:27:47 * (CONNECT_DATA=(SID=cdwsjd)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ZF_DATABASE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=125.69.80.26)(PORT=1416)) * establish * cdwsjd * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
4楼13楼的办法均可,楼主是改过后没有重启监听吧?
用lsnrctl stop/start启,启完后用lsnrctl services应看到至少两个,比如:
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "CDW" has 1 instance(s).
Instance "CDW", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0
LOCAL SERVER
The command completed successfully