1. 首页
  2. IT资讯

oracle 10g rac ggs关键参数配置

源库:—-mgr—GGSCI (rac1) 8> view params mgrPORT 7809autostart er * autorestart er *PURGEOLDEXTRACTS ./dirdat, USECHECKPOINTS–EORA–GGSCI (rac1) 9> view params EORAextract eorauserid ggs,password ggsexttrail ./dirdat/aaTRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle table test.*;— PORA_1 —GGSCI (rac1) 12> view params PORA_1 EXTRACT PORA_1PASSTHRURMTHOST 192.168.8.219, MGRPORT 7809RMTTRAIL ./dirdat/paTABLE test.*;目标库:–RORA_1 —GGSCI (yitai.com) 11> view params RORA_1 REPLICAT RORA_1USERID ggs, PASSWORD ggsHANDLECOLLISIONSASSUMETARGETDEFSDISCARDFILE ./dirrpt/RORA_aa.DSC, PURGEMAP 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/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/195892.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code