[oracle@caijidb ~]$ lsnrctl
status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-AUG-2012
20:24:50
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=caijidb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 13-AUG-2012 20:22:14
Uptime 0 days 0 hr. 2 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/oracle/network/admin/listener.ora
Listener Log File /u01/oracle/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=caijidb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
Service "cms40" has 1 instance(s).
Instance "cms40", status READY, has 1 handler(s) for this
service...
Service "cms40XDB" has 1 instance(s).
Instance "cms40", status READY, has 1 handler(s) for this
service...
Service "cms40_XPT" has 1 instance(s).
Instance "cms40", status READY, has 1 handler(s) for this
service...
The command completed successfully
[oracle@caijidb ~]$
[oracle@caijidb ~]$ tnsping
cms40
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on
13-AUG-2012 20:26:44
Copyright (c) 1997, 2005, Oracle. All rights
reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = 192.168.214.159)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = cms40)))
OK (0 msec)
[oracle@caijidb ~]$ lsnrctl
service
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on
13-AUG-2012 20:27:29
Copyright (c) 1991, 2005, Oracle. All rights
reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=caijidb)(PORT=1521)))
Services Summary...
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 "cms40" has 1 instance(s).
Instance "cms40", status READY, has 1 handler(s)
for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "cms40XDB" has 1 instance(s).
Instance "cms40", status READY, has 1 handler(s)
for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER
2500>
(ADDRESS=(PROTOCOL=tcp)(HOST=caijidb)(PORT=31187))
Service "cms40_XPT" has 1 instance(s).
Instance "cms40", status READY, has 1 handler(s)
for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@caijidb ~]$
总结:
Oracle Net 工具(命令)tnsping,是一个OSI会话层的工具,它用来:
1)验证名字解析(name resolution,当然是oracle自己的网络服务名)
2)远程的listener是否启动
1.tnsping 命令可以检查tcp协议是否已同,俗称我们说的网络通不通
2.tnsping命令监听服务器上的监听是否已开启
3.tnsping命令不检测服务器上的监听的服务名,所以tnsping通,不代表就能连通。