我用SQL Plus登录与Oracle是可以连接的,但是用PLSQL Developer登录后总是显示程序无响应,我也试过在,tnsping显示响应20毫秒 没有问题,但是在sqlplus 用户名/密码@实例名(busbike/its@orcl)运行
C:\>tnsping orclTNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0- Production on 14-5月
2012 11:21:19Copyright (c) 1997, 2008, Oracle. All rights reserved.已使用的参数文件:
E:app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 毫秒)C:\>sqlplus busbike/its@orcl
SQL*Plus: Release 11.1.0.7.0 - Production on 星期一 5月 14 11:24:58 2012Copyright (c) 1982, 2008, Oracle. All rights reserved.
_后面就不出结果了,管理中的监听服务也已经打开了,tnsnames.ora中的内容也检查过了,如下:
# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-201107222300)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
listener.ora中的内容如下:
# listener.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
)
)
检查过了感觉没有错误,HOST中的内容页换过ip地址试下,也不行。
请哪位高手帮忙卡看吧,都弄了3天了。
C:\>tnsping orclTNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0- Production on 14-5月
2012 11:21:19Copyright (c) 1997, 2008, Oracle. All rights reserved.已使用的参数文件:
E:app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 毫秒)C:\>sqlplus busbike/its@orcl
SQL*Plus: Release 11.1.0.7.0 - Production on 星期一 5月 14 11:24:58 2012Copyright (c) 1982, 2008, Oracle. All rights reserved.
_后面就不出结果了,管理中的监听服务也已经打开了,tnsnames.ora中的内容也检查过了,如下:
# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-201107222300)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
listener.ora中的内容如下:
# listener.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
)
)
检查过了感觉没有错误,HOST中的内容页换过ip地址试下,也不行。
请哪位高手帮忙卡看吧,都弄了3天了。
中的HOST内容同时改为ip或是计算机名字都不行,到现在为止运行了2个小时了
C:\>sqlplus busbike/its@orcl中始终没有结果。