本帖最后由 foolcatjr 于 2014-1-9 14:02 编辑
本机监听显示正常
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date
08-JAN-2014 14:24:36
Uptime
0 days 0 hr. 1 min. 27 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /home/ora11g/database/network/admin/listener.ora
Listener Log File /home/ora11g/diag/tnslsnr/dg1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dg" has 1 instance(s).
Instance "dg", status READY, has 1 handler(s) for this service...
Service "dgXDB" has 1 instance(s).
Instance "dg", status READY, has 1 handler(s) for this service...
The command completed successfully
要连接的就是这个叫dg的数据库
在本机连接正常
[oracle@dg1 ~]$ sqlplus system/oracle@dg
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 8 14:26:14 2014
Copyright (c) 1982, 2009, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
但在客户端
C:\Users\BB-VHD>tnsping dg81
TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 08-JAN-2
014 14:31:00
Copyright (c) 1997, 2011, Oracle.All rights reserved.
Used parameter files:
d:\oracle11r2\ora112\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.3.81) (PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dg) (SERV
ER = DEDICATED)))
TNS-12541: TNS:no listener
直接连接也不行
C:\Users\BB-VHD>sqlplus system/[email protected]/dg
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 8 14:32:03 2014
Copyright (c) 1982, 2011, Oracle.All rights reserved.
ERROR:
ORA-12541: TNS:no listener
网络连接正常
C:\Users\BB-VHD>ping 192.168.3.81
Pinging 192.168.3.81 with 32 bytes of data:
Reply from 192.168.3.81: bytes=32 time<1ms TTL=64
Reply from 192.168.3.81: bytes=32 time<1ms TTL=64
Reply from 192.168.3.81: bytes=32 time<1ms TTL=64
Reply from 192.168.3.81: bytes=32 time<1ms TTL=64
从来没有遇到过这种问题，这是什么情况？？
--------------------------------------------------------------------------------------------------------------------
补充：这个是用vmware做的虚拟机，在安装完操作系统后，通过复制磁盘文件，创建的新的虚拟机。
创建后更改过ip和机器名，但此时并未安装数据库软件，只有操作系统。
不知道跟这个有没有关系
--------------------------------------------------------------------------------------------------------------------
问题已经解决，在17楼
|
