Friday, November 12, 2010

Installing Oracle Goldengate (Part 16 of series, Installing Oracle Goldengate on Linux)

The day dawns, and then it ends,and the night passes away. Man's life is diminishing, but he does not understand. Each day, the mouse of death is gnawing away at the rope of life. Maya spreads out like sweet molasses; the self-willed manmukh is stuck like a fly, rotting away.


Index of all the posts of Gurpartap Singh's Blog

Oracle Goldegate is a nice tool to do replication. Though its expensive but is accurate and very flexible and with very low overhead on the database it replicates very fast. Once you know the architecture of oracle goldengate and the are familiar with the commands its a nice tool to use. Always keep documentation handy as this has so many parameters that you may not remember them all. Also, to do complex replication you should know your data.


Installing goldengate, if you are doing replication from one server to another then do teh installation on both target and the source server. I will use it on both the target and the source. You can use it to do replication between two databases on the same server also.

Here starts the install. I will install goldengate on linux. Both my source and target are linux servers.

unzip the file as you downloaded from Oracle Edelivery as:
unzip V18159-01.zip

and the untar it as:
tar -xvof ggs_redhatAS50_x64_ora11g_64bit_v10.4.0.19_002.tar


I have seen the following errors on goldengate in one of the installs:

oracle : lab : @lab : /u01/app/oracle/product/goldengate
$ tar -xvof ggs_redhatAS50_x86_ora10g_32bit_v10.4.0.19_002.tar
mgr
tar: mgr: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ggsci
tar: ggsci: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ggMessage.dat
tar: ggMessage.dat: Cannot change ownership to uid 1901, gid 801: Operation not permitted
help.txt
tar: help.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
bcrypt.txt
tar: bcrypt.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
libxml2.txt
tar: libxml2.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
zlib.txt
tar: zlib.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
freeBSD.txt
tar: freeBSD.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
notices.txt
tar: notices.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
libicui18n.so.38
tar: libicui18n.so.38: Cannot change ownership to uid 1901, gid 801: Operation not permitted
libicuuc.so.38
tar: libicuuc.so.38: Cannot change ownership to uid 1901, gid 801: Operation not permitted
libicudata.so.38
tar: libicudata.so.38: Cannot change ownership to uid 1901, gid 801: Operation not permitted
cobgen
tar: cobgen: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddlcob
tar: ddlcob: Cannot change ownership to uid 1901, gid 801: Operation not permitted
emsclnt
tar: emsclnt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
keygen
tar: keygen: Cannot change ownership to uid 1901, gid 801: Operation not permitted
logdump
tar: logdump: Cannot change ownership to uid 1901, gid 801: Operation not permitted
reverse
tar: reverse: Cannot change ownership to uid 1901, gid 801: Operation not permitted
server
tar: server: Cannot change ownership to uid 1901, gid 801: Operation not permitted
convchk
tar: convchk: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddlgen
tar: ddlgen: Cannot change ownership to uid 1901, gid 801: Operation not permitted
defgen
tar: defgen: Cannot change ownership to uid 1901, gid 801: Operation not permitted
extract
tar: extract: Cannot change ownership to uid 1901, gid 801: Operation not permitted
replicat
tar: replicat: Cannot change ownership to uid 1901, gid 801: Operation not permitted
usrdecs.h
tar: usrdecs.h: Cannot change ownership to uid 1901, gid 801: Operation not permitted
tcperrs
tar: tcperrs: Cannot change ownership to uid 1901, gid 801: Operation not permitted
bcpfmt.tpl
tar: bcpfmt.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
db2cntl.tpl
tar: db2cntl.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_access.tpl
tar: ddl_access.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_db2_os390.tpl
tar: ddl_db2_os390.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_db2.tpl
tar: ddl_db2.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_informix.tpl
tar: ddl_informix.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_mss.tpl
tar: ddl_mss.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_mysql.tpl
tar: ddl_mysql.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_nssql.tpl
tar: ddl_nssql.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_oracle.tpl
tar: ddl_oracle.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_sqlmx.tpl
tar: ddl_sqlmx.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_sybase.tpl
tar: ddl_sybase.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_tandem.tpl
tar: ddl_tandem.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
sqlldr.tpl
tar: sqlldr.tpl: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/
UserExitExamples/ExitDemo_lobs/
UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
tar: UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_lobs/readme.txt
tar: UserExitExamples/ExitDemo_lobs/readme.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
tar: UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
tar: UserExitExamples/ExitDemo_lobs/exitdemo_lob.c: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX
tar: UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
tar: UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj
tar: UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/
tar: UserExitExamples/ExitDemo_lobs: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS
tar: UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX
tar: UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c
tar: UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj
tar: UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/readme.txt
tar: UserExitExamples/ExitDemo_pk_befores/readme.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX
tar: UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX
tar: UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/
tar: UserExitExamples/ExitDemo_pk_befores: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX
tar: UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/Makefile_exit_demo.AIX
tar: UserExitExamples/ExitDemo/Makefile_exit_demo.AIX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/readme.txt
tar: UserExitExamples/ExitDemo/readme.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/exitdemo.c
tar: UserExitExamples/ExitDemo/exitdemo.c: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/exitdemo.vcproj
tar: UserExitExamples/ExitDemo/exitdemo.vcproj: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX
tar: UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS
tar: UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/
tar: UserExitExamples/ExitDemo: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
tar: UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
tar: UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
tar: UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/readme.txt
tar: UserExitExamples/ExitDemo_more_recs/readme.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
tar: UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
tar: UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
tar: UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/
tar: UserExitExamples/ExitDemo_more_recs: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
tar: UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj
tar: UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/readme.txt
tar: UserExitExamples/ExitDemo_passthru/readme.txt: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX
tar: UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS
tar: UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c
tar: UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c: Cannot change ownership to uid 1901, gid 801: Operation not permitted
UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX
tar: UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX: Cannot change ownership to uid 1901, gid 801: Operation not permitted
chkpt_ora_create.sql
tar: UserExitExamples/ExitDemo_passthru: Cannot change ownership to uid 1901, gid 801: Operation not permitted
tar: UserExitExamples: Cannot change ownership to uid 1901, gid 801: Operation not permitted
tar: chkpt_ora_create.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_ora10.sql
tar: ddl_ora10.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_ora10upCommon.sql
tar: ddl_ora10upCommon.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_ora11.sql
tar: ddl_ora11.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_ora9.sql
tar: ddl_ora9.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_more_ora_create.sql
tar: demo_more_ora_create.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_more_ora_insert.sql
tar: demo_more_ora_insert.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_ora_create.sql
tar: demo_ora_create.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_ora_insert.sql
tar: demo_ora_insert.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_ora_lob_create.sql
tar: demo_ora_lob_create.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_ora_misc.sql
tar: demo_ora_misc.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_ora_pk_befores_create.sql
tar: demo_ora_pk_befores_create.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_ora_pk_befores_insert.sql
tar: demo_ora_pk_befores_insert.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
demo_ora_pk_befores_updates.sql
tar: demo_ora_pk_befores_updates.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_cleartrace.sql
tar: ddl_cleartrace.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_ddl2file.sql
tar: ddl_ddl2file.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_disable.sql
tar: ddl_disable.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_enable.sql
tar: ddl_enable.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_pin.sql
tar: ddl_pin.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_remove.sql
tar: ddl_remove.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_setup.sql
tar: ddl_setup.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_status.sql
tar: ddl_status.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_staymetadata_off.sql
tar: ddl_staymetadata_off.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_staymetadata_on.sql
tar: ddl_staymetadata_on.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_tracelevel.sql
tar: ddl_tracelevel.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_trace_off.sql
tar: ddl_trace_off.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
ddl_trace_on.sql
tar: ddl_trace_on.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
params.sql
tar: params.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
role_setup.sql
tar: role_setup.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
marker_remove.sql
tar: marker_remove.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
marker_setup.sql
tar: marker_setup.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
marker_status.sql
tar: marker_status.sql: Cannot change ownership to uid 1901, gid 801: Operation not permitted
tar: Error exit delayed from previous errors

oracle : lab : @lab : /u01/app/oracle/product/goldengate
$



After some research, I found, it is a bug and can be ignored.

----------------------------------------------------------------------------------------
If you get the following error, fix the OS package in error and try again.

oracle : lab : @lab : /u01/app/oracle/product/goldengate
$./ggsci
./ggsci: error while loading shared libraries: requires glibc 2.5 or later dynamic linker

----------------------------------------------------------------------------------------

After everything is fixed or after a clean install just logon to the ggsci prompt as shown below
by executing ggsci utility and you can put this utility in path and ld_library_path too.

oracle : rac1.rac.meditate.com : @simar1 : /u01/app/oracle/product/goldengate
$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 11 on Sep 17 2009 23:51:28

Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.




GGSCI (rac1.rac.meditate.com) 1> CREATE SUBDIRS

-------------------------------------------------------------------------

Now create the subdirectories as:

GGSCI (rac1.rac.meditate.com) 1> CREATE SUBDIRS

Creating subdirectories under current directory /u01/app/oracle/product/goldengate

Parameter files /u01/app/oracle/product/goldengate/dirprm: created
Report files /u01/app/oracle/product/goldengate/dirrpt: created
Checkpoint files /u01/app/oracle/product/goldengate/dirchk: created
Process status files /u01/app/oracle/product/goldengate/dirpcs: created
SQL script files /u01/app/oracle/product/goldengate/dirsql: created
Database definitions files /u01/app/oracle/product/goldengate/dirdef: created
Extract data files /u01/app/oracle/product/goldengate/dirdat: created
Temporary files /u01/app/oracle/product/goldengate/dirtmp: created
Veridata files /u01/app/oracle/product/goldengate/dirver: created
Veridata Lock files /u01/app/oracle/product/goldengate/dirver/lock: created
Veridata Out-Of-Sync files /u01/app/oracle/product/goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/oracle/product/goldengate/dirver/oosxml: created
Veridata Parameter files /u01/app/oracle/product/goldengate/dirver/params: created
Veridata Report files /u01/app/oracle/product/goldengate/dirver/report: created
Veridata Status files /u01/app/oracle/product/goldengate/dirver/status: created
Veridata Trace files /u01/app/oracle/product/goldengate/dirver/trace: created
Stdout files /u01/app/oracle/product/goldengate/dirout: created

-----------------------------------------------------------------------------------------

Now we will create a database user goldengate, that will be used for managing goldengate.

create tablespace goldengate
datafile '+DATA1' size 300m;


create user goldengate identified by goldengate
default tablespace goldengate
temporary tablespace temp;

and then grant the following permisssions to the goldengate user as:

grant connect,resource to goldengate;
grant select any dictionary, select any table to goldengate;
grant create table to goldengate;
grant flashback any table to goldengate;
grant execute on dbms_flashback to goldengate;
grant execute on utl_file to goldengate;
--though I gave DBA role also but its not required.
grant dba to goldengate;

Here are the results:

oracle : rac1.rac.meditate.com : @simar1 : /u01/app/oracle/product/goldengate
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 7 14:29:48 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> create tablespace goldengate
datafile '+DATA1' size 300m; 2

Tablespace created.

SQL> create user goldengate identified by goldengate
default tablespace goldengate
temporary tablespace temp;
2 3
User created.

SQL> grant connect,resource to goldengate;
grant select any dictionary, select any table to goldengate;
grant create table to goldengate;
grant flashback any table to goldengate;
grant execute on dbms_flashback to goldengate;
grant execute on utl_file to goldengate;

Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL>
Grant succeeded.

SQL> grant dba to goldengate;
Grant succeeded.



I am enabling supplemental logging on database level as follows.
Here is how the view v$database looks before and after enabling supplemental logging.

SQL> select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL,SUPPLEMENTAL_LOG_DATA_PL from v$database;

SUPPLEME SUP SUP SUP SUP SUP
-------- --- --- --- --- ---
NO NO NO NO NO NO

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

Database altered.

SQL> select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL,SUPPLEMENTAL_LOG_DATA_PL from v$database;

SUPPLEME SUP SUP SUP SUP SUP
-------- --- --- --- --- ---
IMPLICIT NO NO NO YES NO

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

oracle : rac1.rac.meditate.com : @simar1 : /u01/app/oracle/product/goldengate
$



I take the Support of the Lord's Lotus Feet; there is no other place of rest for me. I lean upon You as my Support, O Supreme Lord God. I exist only by Your Power. O God, You are the Honor of the dishonored. I seek to merge with You.

6 comments:

  1. Our requirement is source is standalone ASM 11gr3 and the target is 2 node 11gr3. How to go about this ? Ay ideas/directions is appreciated.

    ReplyDelete
  2. Thanks for visiting my blog.

    It's same install and it doesn't mater how many nodes you have on source or target as its teh replication on database to database. Please let me know, exactly what you want to ask?

    Regards,
    Gurpartap Singh

    ReplyDelete
  3. I am not very clear on how to install GG for a target with 2 node RAC. This is what I did
    1.created a ASM diskgroup
    2.created a volume out of this ASM diskgroup using ACFS utility ( basically created ACFS volume)
    3. Mounted the above create volume as /u01/app/oradata/gg
    4. Installed the GG in the /u01/app/oradata/gg. Since this is on a shared ACFS volume, both nodes can see and access the GG install.
    5. On node b, I created the replicate and started the manager process.

    Are the above steps correct for installing GG in a RAC environment ?

    ReplyDelete
    Replies
    1. Hi Shin,

      Yes, above steps are correct. You could place the gg binaries on NFS (if critical to bussiness). That way if you do some maintenence on ASM or cluster database, you don't need to stop manager process and just stop the replicats. That way manager will keep receiving files from pump processes.

      On RAC you can configure manager process to be integrated as cluster service to make goldengate available even if your node 2 goes down. It wil just failover to the surviving node. My note for this are here:

      http://gurpartapblog.blogspot.com/2011/02/part-32-of-series-integrate-goldengate.html

      Regards,
      Gurpartap Singh

      Delete
  4. Thank you very much.
    You have clarified my doubts. Only thing is I do have an NFS mount to install the binaries. I am just taking my chances on the ASM disk group that been mounted and shared as ACFS volume

    ReplyDelete
  5. Thats great your doubts are clear. Good luck with your project.

    Regards,
    Gurpartap Singh


    Remember : This life is the only chance (after having 8.4 million incarnations) to be one with TRUTH (One GOD). Pray for me that I do meditate, meditate and meditate and get absorbed in TRUTH before I die.

    ReplyDelete