ITPub博客

首页 > 数据库 > Oracle > 配置RAC+DG时---监听部分配置

配置RAC+DG时---监听部分配置

原创 Oracle 作者:oracle_mao 时间:2014-01-20 16:45:22 0 删除 编辑

 配置RAC+DG的时候,发现在配置监听这里不太顺利,先将其记下。以下配置仅为监听部分的配置。
环境:
 RAC(主库)双节点
 备库为单实例
 Rdbms版本:11R2
RAC节点1:
$ pwd
/pmsdb/oracle/11.1.0/network/admin
$ cat listener.ora
# listener.ora.i2prddb5 Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/listener.ora.i2prddb5
# Generated by Oracle configuration tools.

SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=PMSZKFDB)(ORACLE_HOME=/pmsdb/oracle/11.1.0)(SID_NAME=ZKFP1)))

LISTENER_PMSZFPD3 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD3-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.139)(PORT = 1521)(IP = FIRST))
    )
  )
zkf_pri =
  (DESCRIPTION =
          (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD3)(PORT = 1521))
          )
  (CONNECT_DATA =
   (SERVICE_NAME = ZKF_PRI)
    )
    )

$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_DB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.142)(PORT = 1521))
  )

zkf_pri =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZKF_PRI)
    )
  )

zkf_stb =
    (DESCRIPTION =
        (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1521))
          )
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = ZKF_STB)
      )
        )
zkfp2 =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521))
          (CONNECT_DATA =
                (SERVER = DEDICATED)
                      (SERVICE_NAME = ZKF_PRI)
                          )
                            )
LISTENER_SCAN =
  (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.143)(PORT = 1521))


RAC节点2:
$ pwd
/pmsdb/oracle/11.1.0/network/admin
$ cat listener.ora
# listener.ora.i2prddb5 Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/listener.ora.i2prddb5
# Generated by Oracle configuration tools.
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=PMSZKFDB)(ORACLE_HOME=/pmsdb/oracle/11.1.0)(SID_NAME=ZKFP2)))

LISTENER_PMSZFPD4 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD4-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521)(IP = FIRST))
    )
  )
zkf_pri =
   (DESCRIPTION =
           (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD4)(PORT = 1521))
           )
   (CONNECT_DATA =
    (SERVICE_NAME = ZKF_PRI)
     )
     )

$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_DB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.142)(PORT = 1521))
  )

zkfp2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZKF_PRI)
    )
  )
zkf_stb = 
     (DESCRIPTION =
      (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1521))       
      )       
    (CONNECT_DATA =       
        (SERVER = DEDICATED)       
          (SERVICE_NAME = ZKF_STB)       
        )
        )
zkf_pri =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZKF_PRI)
     )
    )
LISTENER_SCAN =
  (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.143)(PORT = 1521))
    )

备库DG(单实例):
$ pwd
/pmsdb/oracle/ZKFT1/11.1.0/network/admin
$ cat listener.ora
# listener.ora Network Configuration File: /pmsdb/oracle/ZKFT1/11.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

ZKF_STB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1523))
  )

SID_LIST_ZKF_STB =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ZKF_STB)
      (ORACLE_HOME = /pmsdb/oracle/ZKFT1/11.1.0)
      (SID_NAME = ZKFP1)
    )
  )

$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /pmsdb/oracle/ZKFT1/11.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ZKF_PRI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZKF_PRI)
    )
  )

ZKF_STB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZKF_STB)
    )
  )

ZKFP2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZKF_PRI)
    )
  )

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = I2TRNDB2)(PORT = 1523))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TEST)
    )
  )

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24500180/viewspace-1073177/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 11R2--配置RAC+DG
请登录后发表评论 登录
全部评论

注册时间:2011-03-28

  • 博文量
    94
  • 访问量
    752885