test

Sun Cluster Geographic Edition 数据复制指南（适用于 Oracle Data Guard）

Procedure如何配置备用数据库侦听器和命名服务

  1. 为 Oracle Data Guard 创建静态侦听器。

    注 –

    请在所有 cluster-newyork 节点上执行此步骤。

    Oracle Data Guard 要求您配置静态侦听器。下面的示例使用 ${ORACLE_HOME}=/oracle/oracle/product/10.2.0/db_1，并说明在 ${ORACLE_HOME}/network/admin/listener.ora 文件中的什么位置添加静态侦听器的对应条目。SID_LIST_LISTENER_PHYS-NEWYORK-1 和 (SID_NAME = salesdr1) 行因节点而异，而 (GLOBAL_DBNAME=salesdr_DGMGRL) 在 cluster-paris 上有所不同。


    oracle (phys-newyork-1)$ cat ${ORACLE_HOME}/network/admin/listener.ora
SID_LIST_LISTENER_PHYS-NEWYORK-1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = salesdr1)
      (GLOBAL_DBNAME=salesdr_DGMGRL)
      (ORACLE_HOME = /oracle/oracle/product/10.2.0/db_1)
    )
  )
oracle (phys-newyork-1)$

  2. 重新启动侦听器。

    要启用这些静态条目，请在 cluster-newyork 中的每个节点上重新启动 Oracle 侦听器进程。


    oracle (phys-newyork-1)$ lsnrctl stop LISTENER_PHYS_PHYS-NEWYORK-1
LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 29-OCT-2008 02:04:56

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
oracle$ lsnrctl start LISTENER_PHYS_PHYS-NEWYORK-1
LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 29-OCT-2008 02:05:04

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Starting /oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.2.0.3.0 - Production
…
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "salesdr" has 2 instance(s).
  Instance "salesdr1", status READY, has 2 handler(s) for this service...
  Instance "salesdr2", status READY, has 1 handler(s) for this service...
Service "salesdrXDB" has 2 instance(s).
  Instance "salesdr1", status READY, has 1 handler(s) for this service...
  Instance "salesdr2", status READY, has 1 handler(s) for this service...
Service "salesdr_DGB" has 2 instance(s).
  Instance "salesdr1", status READY, has 2 handler(s) for this service...
  Instance "salesdr2", status READY, has 1 handler(s) for this service...
Service "salesdr_DGMGRL" has 1 instance(s).
  Instance "salesdr1", status UNKNOWN, has 1 handler(s) for this service...
Service "salesdr_XPT" has 2 instance(s).
  Instance "salesdr1", status READY, has 2 handler(s) for this service...
  Instance "salesdr2", status READY, has 1 handler(s) for this service...
The command completed successfully

  3. 检验所有数据库实例的 net 服务命名条目。

    确保您所使用的命名服务方法（tnsnames.ora 或目录服务）为所有 Oracle 数据库实例均定义了相应的条目。下面的示例仅显示针对 cluster-newyork 群集的条目类型。在本示例中，salesdr 数据库动态地向侦听器注册一个服务名 salesdr（请参见数据库的 service_names 初始化参数）。


    oracle (phys-newyork-1)$ cat ${ORACLE_HOME}/network/admin/tnsnames.ora
SALESDR1-SVC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phys-newyork-1-crs)(PORT = 1521)
      (SEND_BUF_SIZE = 65535)(RECV_BUF_SIZE = 65535))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = salesdr)
      (INSTANCE_NAME = salesdr1)
    )
  )

SALESDR2-SVC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phys-newyork-2>-crs)(PORT = 1521)
      (SEND_BUF_SIZE = 65535)(RECV_BUF_SIZE = 65535))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = salesdr)
      (INSTANCE_NAME = salesdr2)
    )
  )

SALESDR-SVC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phys-newyork-1-crs)(PORT = 1521)
      (SEND_BUF_SIZE = 65535)(RECV_BUF_SIZE = 65535))
      (ADDRESS = (PROTOCOL = TCP)(HOST = phys-newyork-2-crs)(PORT = 1521)
      (SEND_BUF_SIZE = 65535)(RECV_BUF_SIZE = 65535))
      (LOAD_BALANCE = yes)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = salesdr)
    )
  )

LISTENERS_SALESDR =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = phys-newyork-1-crs)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = phys-newyork-2-crs)(PORT = 1521))
  )

  4. 确认备用侦听器 listener.ora 和 tnsnames.ora 文件包含正确的条目，然后重新启动侦听器进程。

    确保这些文件包含静态 Oracle Data Guard 侦听器条目，以及对应主群集数据库服务和备用群集数据库服务的命名服务条目。如果您未使用 Oracle 目录命名服务查找，则需要在 tnsnames.ora 中包含这些条目。


    oracle (phys-newyork-1)$ lsnrctl stop LISTENER_PHYS-NEWYORK-1
LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 29-OCT-2008 02:04:56

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
oracle$ lsnrctl start LISTENER_PHYS-NEWYORK-1
LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 29-OCT-2008 02:05:04

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Starting /oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.2.0.3.0 - Production
…
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "salesdr_DGMGRL" has 1 instance(s).
  Instance "salesdr1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully