郁闷,oracle突然连不上了,连接时包ora-12535 tns操作超时
oracle是装在本机的,前几天还能用,真奇怪,不知道碰了哪里.
listener.ora文件配置:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lihf-lenovo)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = lihf)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = lihf)
)
)
tnsnames.ora 配置:
LIHF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lihf-lenovo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lihf)
)
)我的计算机名叫lihf-lenovo,在服务哪里已经吧监听和服务都起了,请帮我分析下什么原因吧
oracle是装在本机的,前几天还能用,真奇怪,不知道碰了哪里.
listener.ora文件配置:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lihf-lenovo)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = lihf)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = lihf)
)
)
tnsnames.ora 配置:
LIHF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lihf-lenovo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lihf)
)
)我的计算机名叫lihf-lenovo,在服务哪里已经吧监听和服务都起了,请帮我分析下什么原因吧
lsnrctl status 看看错误
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>lsnrctl statusLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 15-10月-2010 14:19
:26Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
启动日期 15-10月-2010 10:56:49
正常运行时间 0 天 3 小时 22 分 36 秒
跟踪级别 off
安全性 OFF
SNMP OFF
监听器参数文件 d:\oracle\ora92\network\admin\listener.ora
监听器日志文件 d:\oracle\ora92\network\log\listener.log
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lihf-lenovo)(PORT=1521)))
服务摘要..
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "lihf" 包含 1 个例程。
例程 "lihf", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功C:\Documents and Settings\Administrator>上面是状态,有问题吗?
防火墙等没开呀,再说是本机,自己电脑上安装的服务器版。不会是前一阵我用虚拟机整linux吧,不过我看虚拟网卡都禁用了呀。我实在是看不出来为啥了
原来的监听无法启动了,通过命令行新建一个就好了