ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 10g rac ggs关键参数配置

oracle 10g rac ggs关键参数配置

原创 Linux操作系统 作者:perfychi 时间:2013-07-29 21:26:35 0 删除 编辑

源库:
----mgr---

GGSCI (rac1) 8> view params mgr

PORT 7809
autostart er *
autorestart er *
PURGEOLDEXTRACTS ./dirdat, USECHECKPOINTS

--EORA--
GGSCI (rac1) 9> view params EORA

extract eora
userid ggs,password ggs
exttrail ./dirdat/aa
TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle
table test.*;


-- PORA_1 --
GGSCI (rac1) 12> view params PORA_1
EXTRACT PORA_1
PASSTHRU
RMTHOST 192.168.8.219, MGRPORT 7809
RMTTRAIL ./dirdat/pa
TABLE test.*;


目标库:
--RORA_1 --

GGSCI (yitai.com) 11> view params RORA_1
REPLICAT RORA_1
USERID ggs, PASSWORD ggs
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA_aa.DSC, PURGE
MAP test.*, TARGET test.*;


RAC1的监听配置:

LISTENER_RAC1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.101)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER_RAC1 =
 (SID_LIST =
        (SID_DESC =
                (GLOBAL_DBNAME = ASM)
                (ORACLE_HOME = /u01/oracle/ora10g)
                (SID_NAME = +ASM1)
        )
)

RAC2的监听配置:

LISTENER_RAC2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.102)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )


SID_LIST_LISTENER_RAC2 =
 (SID_LIST =
        (SID_DESC =
                (GLOBAL_DBNAME = ASM)
                (ORACLE_HOME = /u01/oracle/ora10g)
                (SID_NAME = +ASM2)
        )
)



RAC1 tnsname.ora:
RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
    )
  )

ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (SID_NAME = +ASM2)

    )
  )

RAC2  tnsname.ora:
RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)

    )
  )

ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM1)

    )
  )




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

下一篇: 索引检查
请登录后发表评论 登录
全部评论

注册时间:2012-06-06

  • 博文量
    486
  • 访问量
    2681991