如何查看oracle配置是否合理,oracle listener 配置与查看

[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通，不代表就能连通。