Friday, November 20, 2009

Installation of Oracle GoldenGate on RedHat Linux AS 4

I am going to install and configure standard GoldenGate configuration in which there is on Extract Group on the source machine, which sends the data to be replicated to the trail on the target system through normal network. On target system, the Replicat process consumes the data from the trail.

I am using 32-bit Oracle 10gR2 on both source and the target systems and the operating system is 32-bit Redhat Linux AS 4. I have created sourcedb on sourcemachine and targetdb on targetmachine. I have made sure that I can access both databases from both machines through SQLPLUS.

The Oracle GoldenGate was downloaded from here.

Then a folden 'ggs' was created in ORACLE_HOME and it is the directory where the GoldenGate will be installed, I added the path '$ORACLE_HOME/ggs' to the shared library enviornment variable LD_LIBRARY_PATH.

I opened up the terminal window, made sure that the ORACLE_HOME, ORACLE_SID, and LD_LIBRARY_PATH variables are set and then copied the downloaded the zip GoldenGate software file to ORACLE_HOME/ggs and unzipped it there.

It produced a TAR file. I untarred it by doing:

$ tar -xvof

Then I changed directories to the GoldenGate directory and started GoldenGate by doing:

$ ggsci

GGSCI> CREATE SUBDIRS

GGSCI> START MANAGER

GGSCI> EDIT PARAMS MGR

It will open a parameter file for the manager process in the vi editor, insert following line in the file and save and quit:

PORT 7809

:wq

GGSCI> STOP MANAGER

GGSCI> START MANAGER

I installed Oracle GoldenGate and configured the Manager process on both source and the target systems.

Now I will create Extract Group on the Source system. I am using the SCOTT SCHEMA and replicating the table 'dept':

ADD EXTRACT ext, TRANLOG, BEGIN

7 comments:

晴天 said...

enjoy your artical, thank you..................................................

Michael said...

The trail name must be two characters, eg: "rt". This creates a series of files prefixed by "rt", followed by six digits.

said...

小遊戲,同志聊天室,色情小遊戲,貼圖區,哈比寬頻成人,嘟嘟成人,玩美女人,視訊交友,自拍貼圖,正妹計時器,無碼影片,情人視訊,正妹牆,聊天室,ut聊天室,視訊聊天室,情色,微風成人,豆豆聊天室,視訊美女,85cc成人片,85cc成人片觀看,交友戀愛進行室,嘟嘟成人網,成人,色情,美女,色情小說,情色貼圖,情色小說,交友覓戀會館,情色文學,交友104速配網,視訊交友,成人韭南籽,18成人,ut男同志聊天室,成人圖片區,交友104相親網,0951成人頻道下載,男同志聊天室,

pbsl said...

you have a nice site. thanks for sharing this valuable resources. keep it up. anyway, various kinds of ebooks are available here

http://feboook.blogspot.com

JaimePatin said...

情色-風情萬種視訊秀視訊美女線上成人視訊美女情色-風情萬種視訊秀情色-風情萬種視訊秀成人影片交友104速配網成人漫畫情色-風情萬種視訊秀哈雷聊天室交友104速配網情色-風情萬種視訊秀哈雷聊天ut女同聊天室正妹牆正妹聊天視訊美女成人漫畫聊天室

aa said...

我是天山,等待一輪明月。.........................

如此的 said...

幸福是人人都要,又怎麼可能都歸你所有?要知道這世界幸福本來就不多........................................