Implementing Oracle Golden Gate on Oracle 11g Database

The topic lists scripts to implement for Oracle Golden Gate 11g for PeopleSoft. For detailed information on any of the steps and the scripts required for Oracle 12c database see, Implementing Oracle GoldenGate for PeopleSoft Off-Load Reporting.

You can also find more information on installing Oracle GoldenGate at Oracle® GoldenGate Installing and Configuring Oracle GoldenGate for Oracle Database, “ Installing Oracle Golden Gate”.

You can create the Oracle GoldenGate user by creating a script similar to the following:

set echo on
spool createogguser.log
-- Create the OGG User
GRANT CONNECT, RESOURCE to OGGUSER identified by OGGUSER;
--Grant OGG required privileges
GRANT CREATE SESSION to OGGUSER;
GRANT ALTER SESSION to OGGUSER; 
GRANT SELECT ANY DICTIONARY to OGGUSER;
GRANT FLASHBACK ANY TABLE to OGGUSER;
GRANT ALTER ANY TABLE to OGGUSER;
GRANT SELECT ANY TABLE to OGGUSER;
GRANT INSERT ANY TABLE to OGGUSER;
GRANT DELETE ANY TABLE to OGGUSER;
GRANT UPDATE ANY TABLE to OGGUSER;
GRANT CREATE TABLE to OGGUSER;
GRANT UNLIMITED TABLESPACE to OGGUSER;
GRANT EXECUTE on DBMS_FLASHBACK to OGGUSER;
GRANT SELECT ON dba_clusters to OGGUSER;
spool off;

For more information on creating a Oracle Golden Gate user and script for Oracle database 12c, see Configuring PeopleSoft Databases for Oracle GoldenGate.

Example to List the Privileges Granted to the GoldenGate User in Oracle 11g

To list the privileges granted to the Oracle GoldenGate User, you can run the following script:

set echo on
set heading off
spool showogguserprivileges.log
-- Show all privileges associated with the OGG User
select
  lpad(' ', 2*level) || granted_role "USER, his roles and privileges"
from
  (
  /* THE USERS */
    select 
      null     grantee, 
      username granted_role
    from 
      dba_users
    where
      username like upper('OGGUSER')
  /* THE ROLES TO ROLES RELATIONS */ 
  union
    select 
      grantee,
      granted_role
    from
      dba_role_privs
  /* THE ROLES TO PRIVILEGE RELATIONS */ 
  union
    select
      grantee,
      privilege
    from
      dba_sys_privs
  )
start with grantee is null
connect by grantee = prior granted_role;
spool off;

The above script generates following result:

  OGGUSER
    ALTER ANY TABLE 
    ALTER SESSION
    CONNECT 
      CREATE SESSION
    CREATE TABLE  
    DELETE ANY TABLE 
    FLASHBACK ANY TABLE 
    INSERT ANY TABLE  
    RESOURCE  
      CREATE CLUSTER  
      CREATE INDEXTYPE
      CREATE OPERATOR
      CREATE PROCEDURE 
      CREATE SEQUENCE
      CREATE TABLE 
      CREATE TRIGGER 
      CREATE TYPE
    SELECT ANY DICTIONARY 
    SELECT ANY TABLE 
     UNLIMITED TABLESPACE 
    UPDATE ANY TABLE 

22 rows selected.

For the following information, see Enabling and Viewing Archive Logging and Supplemental Logging:

Example of Archive Logging on Oracle 12c.
Examples for viewing archive logging status.
Example to enable supplemental logging.

Example to Enable Archive Logging in 11g

To enable archive logging for Oracle GoldenGate on Oracle 11g, use these commands in SQL Plus:

SQL> startup mount
ORACLE instance started.

Total System Global Area  805933056 bytes
Fixed Size                  2230680 bytes
Variable Size             469763688 bytes
Database Buffers          327155712 bytes
Redo Buffers                6782976 bytes
Database mounted.
SQL> ALTER DATABASE ARCHIVELOG;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

This section describes the parameter files that you need to create and modify manually for the primary database on Oracle 11g. See Creating Oracle GoldenGate Parameter Files for the Primary Databasefor examples on Oracle 12c.

mgr.prm
priaddtrndata.oby
configure_primary.oby
primecap.prm
primepmp.prm

Creating mgr.prm

Create a file named mgr.prm and add the following:

--
--  mgr.prm file 
--
PORT 7809
PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS, MINKEEPDAYS 3

Note: The port number defaults to 7809 or 7810.

Creating priaddtrndata.oby

Example to create a file named priaddtrndata.oby on Oracle 11g:

--
--  PRIADDTRNDATA.oby file
--
-- ##########################################################################################
-- ADD Trandata Obey file for Primary
-- This file defines the tables which we are interested in having OGG capture changes from the Transaction logs.
-- We initially specify an add TRANDATA SYSADM.* with wildcard to capture all tables.
-- We then direct OGG to ignore specific table trandata.  In our case all of the PeopleSoft type ‘7’ temp tables.
-- This is done by appending the output from the PSGGgeneratetrandatadeletes.txt (eg. just the generated 
-- DELETE -- TRANDATA statements) after the ADD TRANDATA SYSADM.* statement
-- ##########################################################################################
-- 
-- Edit and modify 'OGGUSER' to Oracle GoldenGate Admin Userid and PW
--  
-- Edit and modify 'SYSADM' to PSACCESSID
-- 
-- Append the output from the PSGGgeneratetrandatadeletes.txt (eg. just the generated 
-- DELETE TRANDATA       -- statements) after the ADD TRANDATA SYSADM.* statement
--
-- ##########################################################################################
DBLOGIN USERID OGGUSER PASSWORD OGGUSER

ADD TRANDATA SYSADM.*

-- ##########################################################################################
-- This section lists the generated DELETE TRANDATA  statements 
-- ##########################################################################################

<Copy in the generated DELETE TRANDATA statements after the preceding ADD TRANDDATA statement.>

-- Example:
-- DELETE TRANDATA SYSADM.PS_AR_CMANRT_TAO3
-- DELETE TRANDATA SYSADM.PS_AR_CMANRT_TAO4
-- DELETE TRANDATA SYSADM.PS_AR_CMANRT_TAO5
-- <more>

 
-- ##########################################################################################
-- This section lists the required static DELETE TRANDATA statements 
-- ##########################################################################################

DELETE TRANDATA SYSADM.PSLOCK 
DELETE TRANDATA SYSADM.PS_SERVERMONITOR 
DELETE TRANDATA SYSADM.PS_SERVERACTVTY 
DELETE TRANDATA SYSADM.PS_PRCSSEQUENCE 
DELETE TRANDATA SYSADM.PS_MESSAGE_LOGPARM 
DELETE TRANDATA SYSADM.PS_MESSAGE_LOG 
DELETE TRANDATA SYSADM.PS_AETEMPTBLMGR 
DELETE TRANDATA SYSADM.PS_AERUNCONTROLPC 
DELETE TRANDATA SYSADM.PS_AERUNCONTROL 
DELETE TRANDATA SYSADM.PS_AELOCKMGR 
DELETE TRANDATA SYSADM.PSWEBPROFHIST 
DELETE TRANDATA SYSADM.PSSERVERSTAT 
DELETE TRANDATA SYSADM.PSQRYTRANS 
DELETE TRANDATA SYSADM.PSPRCSJOBSTATUS 
DELETE TRANDATA SYSADM.PSOPRDEFN 
DELETE TRANDATA SYSADM.PSIBSUBSLAVE 
DELETE TRANDATA SYSADM.PSIBPUBSLAVE 
DELETE TRANDATA SYSADM.PSIBFOLOCK 
DELETE TRANDATA SYSADM.PSIBFAILOVER 
DELETE TRANDATA SYSADM.PSIBBRKSLAVE 
DELETE TRANDATA SYSADM.PSACCESSLOG 
DELETE TRANDATA SYSADM.PS_PTFP_ACCESS_LOG 
DELETE TRANDATA SYSADM.PS_PTFP_OPTIONS 
DELETE TRANDATA SYSADM.PSIBPROFILESYNC 
DELETE TRANDATA SYSADM.PSIBLOGHDR 
DELETE TRANDATA SYSADM.PSIBLOGERR 
DELETE TRANDATA SYSADM.PSIBLOGERRP 
DELETE TRANDATA SYSADM.PSIBLOGDATA 
DELETE TRANDATA SYSADM.PSIBLOGIBINFO 
DELETE TRANDATA SYSADM.PSQASRUN 
DELETE TRANDATA SYSADM.PSPRCSRQST 
DELETE TRANDATA SYSADM.PSPRCSQUE 
DELETE TRANDATA SYSADM.PSPRCSRQSTFILE 
DELETE TRANDATA SYSADM.PSPRCSPARMS 
DELETE TRANDATA SYSADM.PSPRCSRQSTTEXT 
DELETE TRANDATA SYSADM.PSPRCSRQSTTEXT2 
DELETE TRANDATA SYSADM.PS_CDM_LIST 
DELETE TRANDATA SYSADM.PS_CDM_TRANSFER 
DELETE TRANDATA SYSADM.PS_CDM_AUTH 
DELETE TRANDATA SYSADM.PS_BAT_TIMINGS_LOG 
DELETE TRANDATA SYSADM.PS_BAT_TIMINGS_DTL 
DELETE TRANDATA SYSADM.PS_AE_TIMINGS_LG 
DELETE TRANDATA SYSADM.PS_AE_TIMINGS_DT 
DELETE TRANDATA SYSADM.PS_BAT_TIMINGS_FN 
DELETE TRANDATA SYSADM.PSQRYFAVORITES 
DELETE TRANDATA SYSADM.PSQRYSTATS 
DELETE TRANDATA SYSADM.PSFILE_ATTDET 
DELETE TRANDATA SYSADM.PSPTFILE_REF 
DELETE TRANDATA SYSADM.PSPTFILE_WART 
DELETE TRANDATA SYSADM.PS_PTSF_SCHED_STAT 
DELETE TRANDATA SYSADM.PSPGVIEWOPT 
DELETE TRANDATA SYSADM.PSPGCHARTOPT 
DELETE TRANDATA SYSADM.PSPGCHRTFLRSOPT
DELETE TRANDATA SYSADM.PSPGCHTFLRSLANG 
DELETE TRANDATA SYSADM.PSPGDISPOPT 
DELETE TRANDATA SYSADM.PSPGGRIDOPT 
DELETE TRANDATA SYSADM.PSPGQRYPROMPT 
DELETE TRANDATA SYSADM.PSPGQRYPROMPLNG 
DELETE TRANDATA SYSADM.PSPGCHARTOPTLNG 
DELETE TRANDATA SYSADM.PSPGVIEWOPTLANG 
DELETE TRANDATA SYSADM.PSPGVIEWOPTPERS 
DELETE TRANDATA SYSADM.PSPGAXISPERS 
DELETE TRANDATA SYSADM.PSPGAXISPERSLNG 
DELETE TRANDATA SYSADM.PSPGCHARTOPTPER 
DELETE TRANDATA SYSADM.PSPGQRYPRMPTPER 
DELETE TRANDATA SYSADM.PSPGGRIDOPTPERS 
DELETE TRANDATA SYSADM.PSPGCHTOPTPERLN 
DELETE TRANDATA SYSADM.PSPGQRYPRMPTPLN 
DELETE TRANDATA SYSADM.PSPGVWOPTPERLN
DELETE TRANDATA SYSADM.PSPTFILE_PRCS 
DELETE TRANDATA SYSADM.PSUSEROBJTYPE 
DELETE TRANDATA SYSADM.PSUSERSRCHDEFN 
DELETE TRANDATA SYSADM.PSUSERPRSNLOPTN 
DELETE TRANDATA SYSADM.PSVERSION 
DELETE TRANDATA SYSADM.PSUSRTAPAGECUST 
DELETE TRANDATA SYSADM.PSBATCHAUTH 
DELETE TRANDATA SYSADM.PSBATCHAUTHLONG 
DELETE TRANDATA SYSADM.PSPRCSCHLDINFO 
DELETE TRANDATA SYSADM.PS_PTNVSLYTQRY 
DELETE TRANDATA SYSADM.PSTREESELNUM 
DELETE TRANDATA SYSADM.PSTREESELCTL 
DELETE TRANDATA SYSADM.PSNVSBATCHRSTRT 
DELETE TRANDATA SYSADM.PSNVSDRILLQRY 
DELETE TRANDATA SYSADM.PSNVSDRLPROMPTS 
DELETE TRANDATA SYSADM.PS_CDM_TEXT 
DELETE TRANDATA SYSADM.PS_PRCSRQSTDIST 
DELETE TRANDATA SYSADM.PSTREESELECT01 
DELETE TRANDATA SYSADM.PSTREESELECT02 
DELETE TRANDATA SYSADM.PSTREESELECT03 
DELETE TRANDATA SYSADM.PSTREESELECT04 
DELETE TRANDATA SYSADM.PSTREESELECT05 
DELETE TRANDATA SYSADM.PSTREESELECT06 
DELETE TRANDATA SYSADM.PSTREESELECT07 
DELETE TRANDATA SYSADM.PSTREESELECT08 
DELETE TRANDATA SYSADM.PSTREESELECT09 
DELETE TRANDATA SYSADM.PSTREESELECT10 
DELETE TRANDATA SYSADM.PSTREESELECT11 
DELETE TRANDATA SYSADM.PSTREESELECT12 
DELETE TRANDATA SYSADM.PSTREESELECT13 
DELETE TRANDATA SYSADM.PSTREESELECT14 
DELETE TRANDATA SYSADM.PSTREESELECT15 
DELETE TRANDATA SYSADM.PSTREESELECT16 
DELETE TRANDATA SYSADM.PSTREESELECT17 
DELETE TRANDATA SYSADM.PSTREESELECT18 
DELETE TRANDATA SYSADM.PSTREESELECT19 
DELETE TRANDATA SYSADM.PSTREESELECT20 
DELETE TRANDATA SYSADM.PSTREESELECT21 
DELETE TRANDATA SYSADM.PSTREESELECT22 
DELETE TRANDATA SYSADM.PSTREESELECT23 
DELETE TRANDATA SYSADM.PSTREESELECT24 
DELETE TRANDATA SYSADM.PSTREESELECT25 
DELETE TRANDATA SYSADM.PSTREESELECT26 
DELETE TRANDATA SYSADM.PSTREESELECT27 
DELETE TRANDATA SYSADM.PSTREESELECT28 
DELETE TRANDATA SYSADM.PSTREESELECT29 
DELETE TRANDATA SYSADM.PSTREESELECT30

Creating configure_primary.oby

Example to create a file named configure_primary.oby on Oracle 11g:

-- ################################################################################
-- 
-- Edit and modify local and remote Trail Directory
-- 
-- ################################################################################
DBLOGIN USERID OGGUSER PASSWORD OGGUSER
add extract primecap, tranlog, begin now
add exttrail ./dirdat/pt, extract primecap
add extract primepmp, exttrailsource ./dirdat/pt
add rmttrail ./dirdat/pr, extract primepmp

Creating primecap.prm

Example to create a file named primecap.prm on Oracle 11g:

-- ########################################################################################## 
-- Edit and modify NLS_LANG parameter as required (eg. language.territory.character)
-- Edit and modify ORACLE_HOME
-- Edit and modify Primary ORACLE_SID
-- 
-- Edit and modify 'OGGUSER' to Oracle GoldenGate Admin Userid and PW
-- 
-- Edit and modify 'SYSADM' to PSACCESSID
--  
-- Copy the output from the PSGGgeneratetableexcludes.txt (eg. just the generated TABLEEXCLUDE  
-- statements) between the WILDCARDRESOLVE DYNAMIC statement and before the TABLE SYSADM.*
-- statement
--
-- ##########################################################################################
EXTRACT primecap

SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
SETENV (ORACLE_HOME = "/products/oracle/11.2.0.2.0-64bit")
SETENV (ORACLE_SID = pg112064")

USERID OGGUSER PASSWORD OGGUSER

DISCARDFILE ./dirrpt/primecap.dsc, purge

EXTTRAIL ./dirdat/pt

WILDCARDRESOLVE DYNAMIC

-- ##########################################################################################
-- This section lists the generated TABLEEXCLUDE statements 
-- ##########################################################################################

-- <Copy in the generated TABLEEXCLUDE statements after the preceding WILDCARDRESOLVE DYNAMIC 
-- statement.>

-- Example:

-- TABLEEXCLUDE SYSADM.PS_AR_CMANRT_TAO3;
-- TABLEEXCLUDE SYSADM.PS_AR_CMANRT_TAO4;
-- TABLEEXCLUDE SYSADM.PS_AR_CMANRT_TAO5;
-- TABLEEXCLUDE SYSADM.PS_AR_CMANRT_TAO6;
-- TABLEEXCLUDE SYSADM.PS_AR_CMANRT_TAO7;
-- TABLEEXCLUDE SYSADM.PS_AR_CMCOLPRC_I;
-- TABLEEXCLUDE SYSADM.PS_AR_CMCOLPRC_I1;

 
-- ##########################################################################################
-- This section lists the required static TABLEEXCLUDE statements 
-- ##########################################################################################
TABLEEXCLUDE SYSADM.PSLOCK;
TABLEEXCLUDE SYSADM.PS_SERVERMONITOR;
TABLEEXCLUDE SYSADM.PS_SERVERACTVTY;
TABLEEXCLUDE SYSADM.PS_PRCSSEQUENCE;
TABLEEXCLUDE SYSADM.PS_MESSAGE_LOGPARM;
TABLEEXCLUDE SYSADM.PS_MESSAGE_LOG;
TABLEEXCLUDE SYSADM.PS_AETEMPTBLMGR;
TABLEEXCLUDE SYSADM.PS_AERUNCONTROLPC;
TABLEEXCLUDE SYSADM.PS_AERUNCONTROL;
TABLEEXCLUDE SYSADM.PS_AELOCKMGR;
TABLEEXCLUDE SYSADM.PSWEBPROFHIST;
TABLEEXCLUDE SYSADM.PSSERVERSTAT;
TABLEEXCLUDE SYSADM.PSQRYTRANS;
TABLEEXCLUDE SYSADM.PSPRCSJOBSTATUS;
TABLEEXCLUDE SYSADM.PSOPRDEFN;
TABLEEXCLUDE SYSADM.PSIBSUBSLAVE;
TABLEEXCLUDE SYSADM.PSIBPUBSLAVE;
TABLEEXCLUDE SYSADM.PSIBFOLOCK;
TABLEEXCLUDE SYSADM.PSIBFAILOVER;
TABLEEXCLUDE SYSADM.PSIBBRKSLAVE;
TABLEEXCLUDE SYSADM.PSACCESSLOG;
TABLEEXCLUDE SYSADM.PS_PTFP_ACCESS_LOG;
TABLEEXCLUDE SYSADM.PS_PTFP_OPTIONS;
TABLEEXCLUDE SYSADM.PSIBPROFILESYNC;
TABLEEXCLUDE SYSADM.PSIBLOGHDR;
TABLEEXCLUDE SYSADM.PSIBLOGERR;
TABLEEXCLUDE SYSADM.PSIBLOGERRP;
TABLEEXCLUDE SYSADM.PSIBLOGDATA;
TABLEEXCLUDE SYSADM.PSIBLOGIBINFO; 
TABLEEXCLUDE SYSADM.PSQASRUN;
TABLEEXCLUDE SYSADM.PSPRCSRQST;
TABLEEXCLUDE SYSADM.PSPRCSQUE;
TABLEEXCLUDE SYSADM.PSPRCSRQSTFILE;
TABLEEXCLUDE SYSADM.PSPRCSPARMS; 
TABLEEXCLUDE SYSADM.PSPRCSRQSTTEXT;
TABLEEXCLUDE SYSADM.PSPRCSRQSTTEXT2;
TABLEEXCLUDE SYSADM.PS_CDM_LIST;
TABLEEXCLUDE SYSADM.PS_CDM_TRANSFER;
TABLEEXCLUDE SYSADM.PS_CDM_AUTH;
TABLEEXCLUDE SYSADM.PS_BAT_TIMINGS_LOG; 
TABLEEXCLUDE SYSADM.PS_BAT_TIMINGS_DTL; 
TABLEEXCLUDE SYSADM.PS_AE_TIMINGS_LG; 
TABLEEXCLUDE SYSADM.PS_AE_TIMINGS_DT; 
TABLEEXCLUDE SYSADM.PS_BAT_TIMINGS_FN; 
TABLEEXCLUDE SYSADM.PSQRYFAVORITES;
TABLEEXCLUDE SYSADM.PSQRYSTATS;
TABLEEXCLUDE SYSADM.PSFILE_ATTDET; 
TABLEEXCLUDE SYSADM.PSPTFILE_REF; 
TABLEEXCLUDE SYSADM.PSPTFILE_WART;
TABLEEXCLUDE SYSADM.PS_PTSF_SCHED_STAT;
TABLEEXCLUDE SYSADM.PSPGVIEWOPT;
TABLEEXCLUDE SYSADM.PSPGCHARTOPT;
TABLEEXCLUDE SYSADM.PSPGCHRTFLRSOPT;
TABLEEXCLUDE SYSADM.PSPGCHTFLRSLANG;
TABLEEXCLUDE SYSADM.PSPGDISPOPT;
TABLEEXCLUDE SYSADM.PSPGGRIDOPT;
TABLEEXCLUDE SYSADM.PSPGQRYPROMPT;
TABLEEXCLUDE SYSADM.PSPGQRYPROMPLNG;
TABLEEXCLUDE SYSADM.PSPGCHARTOPTLNG; 
TABLEEXCLUDE SYSADM.PSPGVIEWOPTLANG;
TABLEEXCLUDE SYSADM.PSPGVIEWOPTPERS;
TABLEEXCLUDE SYSADM.PSPGAXISPERS;
TABLEEXCLUDE SYSADM.PSPGCHARTOPTPER;
TABLEEXCLUDE SYSADM.PSPGQRYPRMPTPER;
TABLEEXCLUDE SYSADM.PSPGGRIDOPTPERS;
TABLEEXCLUDE SYSADM.PSPGCHTOPTPERLN;
TABLEEXCLUDE SYSADM.PSPGQRYPRMPTPLN;
TABLEEXCLUDE SYSADM.PSPGVWOPTPERLN;
TABLEEXCLUDE SYSADM.PSPGAXISPERSLNG;
TABLEEXCLUDE SYSADM.PSPTFILE_PRCS;
TABLEEXCLUDE SYSADM.PSUSEROBJTYPE;
TABLEEXCLUDE SYSADM.PSUSERSRCHDEFN;
TABLEEXCLUDE SYSADM.PSUSERPRSNLOPTN;
TABLEEXCLUDE SYSADM.PSVERSION;
TABLEEXCLUDE SYSADM.PSUSRTAPAGECUST; 
TABLEEXCLUDE SYSADM.PSBATCHAUTH; 
TABLEEXCLUDE SYSADM.PSBATCHAUTHLONG;
TABLEEXCLUDE SYSADM.PSPRCSCHLDINFO; 
TABLEEXCLUDE SYSADM.PS_PTNVSLYTQRY; 
TABLEEXCLUDE SYSADM.PSTREESELNUM;
TABLEEXCLUDE SYSADM.PSTREESELCTL;
TABLEEXCLUDE SYSADM.PSNVSBATCHRSTRT;
TABLEEXCLUDE SYSADM.PSNVSDRILLQRY;
TABLEEXCLUDE SYSADM.PSNVSDRLPROMPTS;
TABLEEXCLUDE SYSADM.PS_CDM_TEXT;
TABLEEXCLUDE SYSADM.PS_PRCSRQSTDIST;
TABLEEXCLUDE SYSADM.PSTREESELECT01;
TABLEEXCLUDE SYSADM.PSTREESELECT02;
TABLEEXCLUDE SYSADM.PSTREESELECT03;
TABLEEXCLUDE SYSADM.PSTREESELECT04;
TABLEEXCLUDE SYSADM.PSTREESELECT05;
TABLEEXCLUDE SYSADM.PSTREESELECT06;
TABLEEXCLUDE SYSADM.PSTREESELECT07;
TABLEEXCLUDE SYSADM.PSTREESELECT08;
TABLEEXCLUDE SYSADM.PSTREESELECT09;
TABLEEXCLUDE SYSADM.PSTREESELECT10;
TABLEEXCLUDE SYSADM.PSTREESELECT11;
TABLEEXCLUDE SYSADM.PSTREESELECT12;
TABLEEXCLUDE SYSADM.PSTREESELECT13;
TABLEEXCLUDE SYSADM.PSTREESELECT14;
TABLEEXCLUDE SYSADM.PSTREESELECT15;
TABLEEXCLUDE SYSADM.PSTREESELECT16;
TABLEEXCLUDE SYSADM.PSTREESELECT17;
TABLEEXCLUDE SYSADM.PSTREESELECT18;
TABLEEXCLUDE SYSADM.PSTREESELECT19;
TABLEEXCLUDE SYSADM.PSTREESELECT20;
TABLEEXCLUDE SYSADM.PSTREESELECT21;
TABLEEXCLUDE SYSADM.PSTREESELECT22;
TABLEEXCLUDE SYSADM.PSTREESELECT23;
TABLEEXCLUDE SYSADM.PSTREESELECT24;
TABLEEXCLUDE SYSADM.PSTREESELECT25;
TABLEEXCLUDE SYSADM.PSTREESELECT26;
TABLEEXCLUDE SYSADM.PSTREESELECT27;
TABLEEXCLUDE SYSADM.PSTREESELECT28;
TABLEEXCLUDE SYSADM.PSTREESELECT29;
TABLEEXCLUDE SYSADM.PSTREESELECT30;


TABLE SYSADM.*;

Creating primepmp.prm

Example to create a file named primepmp.prm on Oracle 11g:

-- ##########################################################################################
-- Pump for Extract primecap
-- 
-- Edit and modify REMOTE Host, Port and Trail Directory
-- Edit and modify 'SYSADM' to PSACCESSID
-- ##########################################################################################
EXTRACT primepmp

PASSTHRU
PASSTHRUMESSAGES

-- Remote Host and Trail Information
RMTHOST <hostname> MGRPORT 7810
RMTTRAIL ./dirdat/pr

-- Table Mapping Parameters
WILDCARDRESOLVE DYNAMIC

TABLE SYSADM.*;

This section describes the parameter files that you need to create and modify manually for the standby database on Oracle 11g. SeeCreating Oracle GoldenGate Parameter Files for the Standby Database for examples on Oracle 12c.

mgr.prm
configure_standby.oby
trgtrep.prm

Creating mgr.prm

See Creating Oracle GoldenGate Parameter Files for the Standby Database, mgr.prm section.

Creating configure_standby.oby

Example to create a file named configure_standby.oby, on Oracle 11g:

-- ##########################################################################################
-- Edit and modify 'OGGUSER' to Oracle GoldenGate Admin Userid and PW
-- Edit and modify REMOTE Host and Trail 
-- ##########################################################################################
dblogin, userid OGGUSER, password OGGUSER
add checkpointtable OGGUSER.GGSCHKPT
add replicat trgtrep, exttrail ./dirdat/pr, checkpointtable OGGUSER.GGSCHKPT

Creating trgtrep.prm

Example to create a file named trgtrep.prm, on Oracle 11g:

-- ##########################################################################################
-- Edit and modify NLS_LANG parameter as required (eg. language.territory.character)
-- Edit and modify ORACLE_HOME
-- Edit and modify Primary ORACLE_SID
-- Edit and modify 'OGGUSER' to Oracle GoldenGate Admin Userid and PW
-- Edit and modify 'SYSADM' to PSACCESSID
-- ##########################################################################################
REPLICAT trgtrep

SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
SETENV (ORACLE_HOME = "/products/oracle/11.2.0.2.0-64bit")
SETENV (ORACLE_SID = "sg112064")

USERID OGGUSER PASSWORD OGGUSER

ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/trgtrep.dsc, APPEND

DISCARDROLLOVER ON SUNDAY
ALLOWNOOPUPDATES

MAP SYSADM.*, TARGET SYSADM.*;

Implementing Oracle Golden Gate on Oracle 11g Database

Creating and Granting Privileges to the Oracle GoldenGate User for Oracle 11g

Example to List the Privileges Granted to the GoldenGate User in Oracle 11g

Enabling Archive Logging for Oracle 11g

Example to Enable Archive Logging in 11g

Creating Oracle GoldenGate Parameter Files for the Primary Database on Oracle 11g

Creating mgr.prm

Creating priaddtrndata.oby

Creating configure_primary.oby

Creating primecap.prm

Creating primepmp.prm

Creating Oracle GoldenGate Parameter Files for the Standby Database on Oracle 11g

Creating mgr.prm

Creating configure_standby.oby

Creating trgtrep.prm