当前位置:数据库 > Oracle >>

ORACLE 11G RAC监听配置(实例共享)

ORACLE 11G RAC监听配置(实例共享)
 
最近两天QQ上某网友RAC装完之后,监听怎么配置,下面我就共享一个实例
环境信息
cat /etc/hosts
192.168.1.11     racdb1 
192.168.2.2      racdb1-priv    
192.168.1.12     racdb1-vip     
192.168.1.13     racdb2 
192.168.2.3      racdb2-priv    
192.168.1.14     racdb2-vip     
192.168.1.15     scan-db  

 

 
在tnsnames.ora 添加
LISTENER_RACDB1,LISTENER_RACDB2,SCAN
vi tnsnames.ora     
LISTENER_RACDB1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521))

LISTENER_RACDB2 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = racdb2-vip)(PORT = 1521))

SCAN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = scan-db)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db)
    )
  )


su  - oracle

SQL>alter system set local_listener='LISTENER_RACDB1:1521',sid='db1';  
SQL>alter system set local_listener='LISTENER_RACDB2:1521',sid='db2';
SQL> alter system set remote_listener='racscan:1521'; 
SQL> alter system register;

 

 
客户端两种方式连接
 
TNS vip连接方式
RAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521))
    (LOAD_BALANCE = ON)
    (FAILOVER = ON) 
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db)
    )
  )

tns racscan连接方式
tns vip 方式
SCAN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db)
    )
  )

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,