取消某個節點的remote_listener, 使它上面的應用獨立

Linux AS 5.3 ,   Oracle 10.2.0.4  ,  3 Nodes    64bit  .

3 個節點分別為 1， 3， 4 (備註： 其中節點2損壞) 

現在要求1，3 節點為production 訪問 ， 而節點4 為web report 查詢訪問， 要求節點4上的查詢

動作不要影響到節點1，3 生產系統上的負載， 這裡透過取消節點4的remote_listener 引數來實現。 

生產系統的客戶端只連線 1， 3 的VIP ,   web report server 只連線節點 4 的實體IP .  這樣生產系統

上的session 不會連線到節點 4，   節點4 上的web session 也不會連線到 1， 3 生產系統節點上。

相互不影響 。  

-----------------------------------------------------------------------------------------------------------------------------------------------

 

mxrac01$sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 18 19:58:47 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
             
SQL> show parameter listen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LOCAL_MXDELL
remote_listener                      string      LISTENERS_MXDELL
SQL>
SQL>

 

 

 

mxrac03$sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 18 20:00:28 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL>
SQL> show parameter listen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LOCAL_MXDELL
remote_listener                      string      LISTENERS_MXDELL
SQL>

 

 

 

mxrac04$sqlplus  "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 18 19:59:31 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter listen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LOCAL_MXDELL
remote_listener                      string
SQL>