oracle监听 program,oracle 监听的问题

一台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