Book Image

Oracle Goldengate 12c Implementers Guide

Book Image

Oracle Goldengate 12c Implementers Guide

Overview of this book

Table of Contents (21 chapters)
Oracle GoldenGate 12c Implementer's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
GGSCI Commands
GoldenGate Installed Components
Acronyms
Index

Appendix B. GoldenGate Installed Components

GoldenGate is architecturally a simple product with relatively few installed components. This is one of the main reasons for its performance and flexibility. If you ever need to work with Oracle support, the following information will help you understand the individual elements of the GoldenGate architecture. Let's take a look at the software bundle that is installed on both the source and target database servers.

The following table lists the files and directories that make up the GoldenGate Home:

Sub-directories

Description

deinstall

This offers support for OUI

diagnostics

This offers support for OUI

dirbdb

This stores the GoldenGate datastore files

dirchk

This stores the GoldenGate checkpoint files

dircrd

This stores the GoldenGate Credential Store files

dirdat

This stores the GoldenGate trail files

dirdef

This stores the GoldenGate definition mapping files

dirdmp

This stores the GoldenGate process dump files

dirjar

This stores the GoldenGate Java Archive files

dirout

This stores the GoldenGate output files

dirpcs

This Stores the GoldenGate process files

dirprm

This stores the GoldenGate process parameter files

dirrpt

This stores the GoldenGate process report files

dirsql

This stores the GoldenGate user defined SQL files

dirtmp

This stores the GoldenGate temporary files

dirwlt

This stores the GoldenGate wallet files

dirwww

This stores the GoldenGate web pages

dirver

This stores the GoldenGate Veridata files

install

This offers support for OUI

inventory

This stores Oracle inventory files

jdk

This supports Java Runtime Environment

UserExitExamples

This stores the GoldenGate User Exit example files

OPatch

This is Oracle patch utility for GoldenGate

oui

This offers support for OUI

srvm

This is server manager for RAC support

SQL filename

Description

chkpt_ora_create.sql

This creates the GoldenGate checkpoint table

ddl_cleartrace.sql

This clears the GoldenGate DDL Replication trace file

ddl_create.sql

This denotes the internal Oracle script

ddl_ddl2file.sql

This saves DDL from the marker table to a file

ddl_disable.sql

This disables the GoldenGate DDL replication trigger

ddl_enable.sql

This enables the GoldenGate DDL replication trigger

ddl_filter.sql

This is the filtering function for DDL replication

ddl_ora10.sql

This is the support script for version-specific Oracle10g logic

ddl_ora10upCommon.sql

This is the support script for version-specific Oracle 10g and 11g common logic

ddl_ora11.sql

This is the support script for version-specific Oracle 11g logic

ddl_ora9.sql

This is the support script for version-specific Oracle 9i logic

ddl_pin.sql

This pins the GoldenGate DDL replication packages in memory (shared pool)

ddl_remove.sql

This removes the GoldenGate DDL replication trigger and package

ddl_session1.sql

This is the support script to proceed with DDL installation in case of other sessions active

ddl_session.sql

This is the support script to proceed with DDL installation in case of other active sessions

ddl_setup.sql

This is the installation script for the GoldenGate DDL Replication trigger and package

ddl_status.sql

This obtains the status of the GoldenGate DDL replication installation

ddl_staymetadata_off.sql

This turns off STAYMETADATA

ddl_staymetadata_on.sql

This turns on STAYMETADATA

ddl_tracelevel.sql

This sets the tracing level for the GoldenGate DDL replication trigger

ddl_trace_off.sql

This turns off the Trace DDL execution

ddl_trace_on.sql

This turns on the Trace DDL execution for use with TKPROF

demo_more_ora_create.sql

This SQL supports the GoldenGate demonstration code.

demo_more_ora_insert.sql

This SQL supports the GoldenGate demonstration code.

demo_ora_create.sql

This SQL supports the GoldenGate demonstration code.

demo_ora_insert.sql

This SQL supports the GoldenGate demonstration code.

demo_ora_lob_create.sql

This SQL supports the GoldenGate demonstration code.

demo_ora_misc.sql

This SQL supports the GoldenGate demonstration code.

demo_ora_pk_befores_create.sql

This SQL supports the GoldenGate demonstration code.

demo_ora_pk_befores_insert.sql

This SQL supports the GoldenGate demonstration code.

demo_ora_pk_befores_updates.sql

This SQL supports the GoldenGate demonstration code.

label.sql

This contains the GoldenGate version displayed in the GGSCI logon header

marker_remove.sql

This is the removal script for the GoldenGate Marker table

marker_setup.sql

This denotes the installation script for the GoldenGate Marker table

marker_status.sql

This obtains status for GoldenGate Marker Installation

params.sql

This displays customizable parameters for GoldenGate

remove_seq.sql

This removes the Oracle sequence replication support

role_setup.sql

This is the installation script for the GoldenGate Security role

sequence.sql

This is the installation script for the GoldenGate replication support

ulg.sql

This is the upgrade script for the GoldenGate supplemental log groups

TPL filename

Description

bcpfmt.tpl

This is the template file used to specify the BCP version

db2cntl.tpl

This denotes the DB2 control file template

sqlldr.tpl

This denotes the SQLLDR control file template

Text filename

Description

bcrypt.txt

This denotes the copyright/license agreement file

ddl_setup_set.txt

This denotes SQL*Plus parameter setup script

FreeBSD.txt

This denotes the copyright file/license agreement

help.txt

This denotes the GoldenGate help file for GGSCI

libxml2.txt

This specifies the copyright/license agreement file

marker_setup_set.txt

This specifies the SQL*Plus parameter setup script

notices.txt

This specifies notices

zlib.txt

This denotes the copyright/license agreement file

Executable filename

Description

cachefiledump

This specifies the cache dump utility

convchk

This denotes the Oracle GoldenGate checkpoint conversion utility for newer versions

convprm

This denotes the Oracle GoldenGate parameter conversion utility for newer versions

defgen

This specifies the source table definitions generator utility

emsclnt

This is the program to send messages to an Event Management System

extract

This denotes the GoldenGate Extract process program

ggcmd

This denotes the GoldenGate command support for a Java agent

ggsci

This specifies the GoldenGate command-line interpreter

jagent.sh

This starts the GoldenGate Java agent

keygen

This specifies the encryption key generator utility

logdump

This denotes the log dump utility

mgr

This specifies the GoldenGate Manager process program

oggerr

This denotes the Oracle GoldenGate error lookup utility

pw_agent_util.sh

This supports the GoldenGate Java agent

replicat

This denotes the GoldenGate Replicat process program

retrace

This traces all the XML event files

reverse

This is the utility that reverses the order of transactional operations

server

This is the GoldenGate collector process program

User created filename

Description

ENCKEYS

This stores all the encryption keys generated by the keygen utility

CMDSEC

This denotes the GGSCI command security file (optional)

GLOBALS

This stores all the global parameters for the GoldenGate instance