oracle 监听的问题

最新推荐文章于 2023-04-04 14:04:24 发布

cuidang9742

最新推荐文章于 2023-04-04 14:04:24 发布

阅读量92

点赞数

一台HP-UX主机erp-1上运行着一个数据库,有两个instance, 监听也正常运行.

另外一台HP-UN主机test, 和上面的主机没什么联系, 运行着一个测试库,一个instance, listener.ora文件还没建, 因为懒省事, 把上面erp-1主机的listener.ora文件直接复制到这台test主机上.

还没来得及修改listener.ora, 被另外一同事在test主机上直接lsnrctl status, lsnrctl stop了, 结果就先在test主机上看到了erp-1主机上的正常状态, 接着又在test主机上把erp-1上的监听停掉了.

请问:
这样正常吗?
在一台完全不相关的服务器上运行lsnrctl可以完全控制另外一台数据库的监听状态?
还是因为其它哪里配置有问题?

环境:
OS: HP-UX 11.23(两台相同)
erp-1: oracle 9.2.0.6
test: oracle 10.2.0.1
user: oracle(两台相同)[@more@]

hotlite
版主

貼出你的listener.ora的內容

偶剛才在兩臺上試了，不會發生這種問題，
stop只會停止本機的
start的時候是提示無法通過認證的

偶回复的:

以下是我操作的步骤

$ hostname
erp-1
$ netstat -in
Name Mtu Network Address Ipkts Ierrs Opkts Oerrs Coll
lan0 1500 10.154.249.0 10.154.249.250 787997 0 11737417 0 0
lo0 4136 127.0.0.0 127.0.0.1 54550 0 54550 0 0
$ more listener.ora
# LISTENER.ORA Network Configuration File: /oracle/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl1)
(ORACLE_HOME = /oracle/oracle/product/9.2.0)
(SID_NAME = orcl1)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl2)
(ORACLE_HOME = /oracle/oracle/product/9.2.0)
(SID_NAME = orcl2)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = erp-1)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)

$ lsnrctl status

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 04-JUN-2008 10:29:51

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erp-1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 9.2.0.6.0 - Production
Start Date 04-JUN-2008 10:21:27
Uptime 0 days 0 hr. 8 min. 24 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /oracle/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erp-1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl2" has 2 instance(s).
Instance "orcl2", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orcl1" has 2 instance(s).
Instance "orcl1", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully

-bash-3.2$ hostname
test
-bash-3.2$ netstat -in
Name Mtu Network Address Ipkts Ierrs Opkts Oerrs Coll
lan0 1500 10.154.249.0 10.154.249.23 420679 0 354280 0 0
lo0 4136 127.0.0.0 127.0.0.1 474179 0 474179 0 0
-bash-3.2$ more listener.ora
# listener.ora Network Configuration File: /oracle/oracle/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl2)
(ORACLE_HOME = /oracle/oracle/product/10.2.0)
(SID_NAME = orcl2)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl1)
(ORACLE_HOME = /oracle/oracle/product/10.2.0)
(SID_NAME = orcl1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.154.249.250)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

-bash-3.2$ lsnrctl status

LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 04-JUN-2008 10:34:12

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.154.249.250)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 9.2.0.6.0 - Production
Start Date 04-JUN-2008 10:21:27
Uptime 0 days 0 hr. 12 min. 42 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /oracle/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RX3600-3)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl2" has 2 instance(s).
Instance "orcl2", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orcl1" has 2 instance(s).
Instance "orcl1", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
说明一下,两台主机的oracle用户的密码是相同的

vogts
财神

因为你监听没有设置密码，所以远程也能关闭你主机的监听。
1：把IP改掉。
2：或者设上密码。

偶回复滴:

郁闷

bash-3.2$ netstat -in
Name Mtu Network Address Ipkts Ierrs Opkts Oerrs Coll
lan0 1500 10.154.249.0 10.154.249.23 422594 0 355917 0 0
lo0 4136 127.0.0.0 127.0.0.1 476637 0 476637 0 0
-bash-3.2$ lsnrctl stop

LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 04-JUN-2008 11:58:56

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.154.249.250)(PORT=1521)))
The command completed successfully

明白了, 刚找到了老虎头大侠(eygle)的一篇文章, 解释了这个问题

http://www.eygle.com/archives/2007/11/listener_security.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/266238/viewspace-1005146/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/266238/viewspace-1005146/