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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-627304/