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

tolywang發表於2010-02-19

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>

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-627304/,如需轉載,請註明出處,否則將追究法律責任。

相關文章