Oracle连接太慢的原因及TNS无监听程序

原因一：

listener.log文件太大，删掉它

原因二：

OracleOraDb11g_home1TNSListener（services.msc）服务没启

原因三：

没有配置监听或者监听错误

1.172.16.53.145是你数据库服务器的正确的ip地址吗，如果不是请改这两个文件

2.命令行上启动监听 ：lsnrctl start

3.等2分钟后，命令行上查看监听状态：lsnrctl status结果贴一下

这里会有service开头的服务名，它的status可能有READY和UNKNOW的，对应你的实例名，同时这个service也对应你tnsnames.ora文件里的service_name

4.命令行上执行：tnsping orcl 结果贴一下

5.实例是否启动

sqlplus "/as sysdba"

select status from v$instance

贴一下结果

检查oracle\product\10.1.0\db_1\NETWORK\log\listener.log：TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 04-1月 -2010 13:38:34 Copyright (c) 1991, 2004, Oracle. All rights reserved. 系统参数文件为D:\oracle\product\10.1.0\db_1\network\admin\listener.ora写入D:\oracle\product\10.1.0\db_1\network\log\listener.log的日志信息写入D:\oracle\product\10.1.0\db_1\network\trace\listener.trc的跟踪信息跟踪级别当前为0 以 pid=7180 开始监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pc-xxx.mail.yyy.cn)(PORT=1521)))TNS-12542: TNS: 地址已被占用 TNS-12560: TNS: 协议适配器错误 TNS-00512: 地址已在使用 32-bit Windows Error: 48: Unknown error不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))2. Oracle的listener已经启动。3. 查看oracle\product\10.1.0\db_1\NETWORK\ADMIN\listener.ora# listener.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST =(SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.1.0\db_1) (PROGRAM = extproc)) ) LISTENER = (DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521)) )) ) 把(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))改为(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))pc-xxx.mail.yyy.cn是计算机名127.0.0.1也就是目前数据库正在用的ip地址。4. 查看oracle\product\10.1.0\db_1\NETWORK\ADMIN\tnsnames.ora找到下列语句：ORCL = (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)) )将(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))改为(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))5. 关闭后再启动listener运行->cmd启动dos窗口，执行lsnrctl stop关闭，lsnrctl start启动。

---