FAQ on installation & Configuration of Oracle goldengate veridata
FAQ on installation & Configuration of Oracle goldengate veridata
Product Name:-Oracle GoldenGate Veridata
It has 2 features
Veridata Server
Veridata Agent
Veridata Server
The Veridata Server component includes the web server, the web
application, and command-line utilities such as vericom .
Veridata Agent
This component installs only the Veridata Agent.
Internal Features
Apache Ant
This is a software tool used for automating build processes.
FMW Upgrade
This is the upgrade assistant that can be used to upgrade your
11g Oracle GoldenGate Veridata software to 12c.
OPatch
The OPatch utility is a tool that allows the application and rollback
of interim patches to Oracle products
Repository Creation Utility
The Repository Creation Utility (RCU) is used for creating
database schemas
The Oracle GoldenGate Veridata distribution installs the following components:
• Oracle GoldenGate Veridata Server
• Oracle GoldenGate Veridata Web User Interface
• Oracle GoldenGate Veridata Repository
• Oracle GoldenGate Veridata Agent
• Oracle GoldenGate Veridata Command-line Utilities
This topology represents a standard WebLogic Server domain that contains an
Administration Server and a Managed Server on which the Infrastructure and Veridata
Server are deployed. The domain is configured on a single host and requires a
supported database where the Veridata Repository Database schema and required
Fusion Middleware schema are installed.
Oracle GoldenGate Veridata Server
The Veridata Server coordinates the execution of Oracle
GoldenGate Veridata tasks and processes information from multiple
Veridata Agents.
You must have a certified JDK already installed on your system in order to install and configure veridata
The Oracle WebLogic Server version is not forward compatible, which
means that it doesn't work with Oracle GoldenGate Monitor 12.2.1.3 and
future versions.
Oracle GoldenGate Veridata doesn't support the following databases for repair
functionality, but supported by Oracle GoldenGate
Non Stop (Enscribe, SQL/MP, SQL/MX)
• Big Data
At minimum, therefore, you will install two
agents — one to retrieve source rows and one to retrieve target rows (unless you are
comparing data within the same database instance). One agent can retrieve rows from
multiple databases or schemas within a given database instance. However, one agent
cannot retrieve rows from different database instances.
The Java agent uses the UTF-8 character for comparing character data. Out-ofsync
data is written to the report file using the UTF-8 character set.
The Oracle GoldenGate Veridata Oracle C-Agent can be used for comparisons
between Oracle databases where the source and target use the same character
set and the host system uses the same byte order
Character fields that contain characters
that are not valid UTF-8 characters are displayed as hexadecimal in the out-ofsync
reports.
The Java agent enables Oracle GoldenGate Veridata to support
comparisons in a heterogeneous environment, where different kinds of databases contain similar, but not identical data types
Environment Requirements to Use a Java Agent
For Oracle,The listener must be configured and running.
The agent requires at least 1GB of RAM.
The disk space requirements 200 MB
Database Privileges for the Agent Component
For Oracle
• GRANT CONNECT
• GRANT SELECT on the tables to be compared. It is recommended, but not necessary,
to GRANT SELECT ANY TABLE.
• SELECT_CATALOG_ROLE
Enough combined disk space and virtual memory is needed to store all of the rows
that are sent for comparison from the source and target systems
To estimate the
amount of memory per row:
((number of cols in key + 1) * 4) + 16 + (comparison width of a key col)
Where:
comparison width of a key col depends on the comparison format that is selected by
Oracle GoldenGate Veridata
For example, the number 109998877, if compared as a decimal float, would require:
((1 + 1) * 4) + 16 + 9 = 33 bytes of memory for this row
In-Memory Sort: This sorts the data entirely in memory and is the fastest method,
but the memory requirements may exceed what is available. The sort memory
must be approximately 2.5 times larger than the size of the data set
In general the Oracle
GoldenGate Veridata server can write the rows to disk faster than the agent can
read them from the database.
Use the Repository Creation Utility (RCU) to create the repository
You can use the following databases as a repository:
• Oracle
• SQL Server
Product Name:-Oracle GoldenGate Veridata
It has 2 features
Veridata Server
Veridata Agent
Veridata Server
The Veridata Server component includes the web server, the web
application, and command-line utilities such as vericom .
Veridata Agent
This component installs only the Veridata Agent.
Internal Features
Apache Ant
This is a software tool used for automating build processes.
FMW Upgrade
This is the upgrade assistant that can be used to upgrade your
11g Oracle GoldenGate Veridata software to 12c.
OPatch
The OPatch utility is a tool that allows the application and rollback
of interim patches to Oracle products
Repository Creation Utility
The Repository Creation Utility (RCU) is used for creating
database schemas
The Oracle GoldenGate Veridata distribution installs the following components:
• Oracle GoldenGate Veridata Server
• Oracle GoldenGate Veridata Web User Interface
• Oracle GoldenGate Veridata Repository
• Oracle GoldenGate Veridata Agent
• Oracle GoldenGate Veridata Command-line Utilities
This topology represents a standard WebLogic Server domain that contains an
Administration Server and a Managed Server on which the Infrastructure and Veridata
Server are deployed. The domain is configured on a single host and requires a
supported database where the Veridata Repository Database schema and required
Fusion Middleware schema are installed.
Oracle GoldenGate Veridata Server
The Veridata Server coordinates the execution of Oracle
GoldenGate Veridata tasks and processes information from multiple
Veridata Agents.
You must have a certified JDK already installed on your system in order to install and configure veridata
The Oracle WebLogic Server version is not forward compatible, which
means that it doesn't work with Oracle GoldenGate Monitor 12.2.1.3 and
future versions.
Oracle GoldenGate Veridata doesn't support the following databases for repair
functionality, but supported by Oracle GoldenGate
Non Stop (Enscribe, SQL/MP, SQL/MX)
• Big Data
At minimum, therefore, you will install two
agents — one to retrieve source rows and one to retrieve target rows (unless you are
comparing data within the same database instance). One agent can retrieve rows from
multiple databases or schemas within a given database instance. However, one agent
cannot retrieve rows from different database instances.
The Java agent uses the UTF-8 character for comparing character data. Out-ofsync
data is written to the report file using the UTF-8 character set.
The Oracle GoldenGate Veridata Oracle C-Agent can be used for comparisons
between Oracle databases where the source and target use the same character
set and the host system uses the same byte order
Character fields that contain characters
that are not valid UTF-8 characters are displayed as hexadecimal in the out-ofsync
reports.
The Java agent enables Oracle GoldenGate Veridata to support
comparisons in a heterogeneous environment, where different kinds of databases contain similar, but not identical data types
Environment Requirements to Use a Java Agent
For Oracle,The listener must be configured and running.
The agent requires at least 1GB of RAM.
The disk space requirements 200 MB
Database Privileges for the Agent Component
For Oracle
• GRANT CONNECT
• GRANT SELECT on the tables to be compared. It is recommended, but not necessary,
to GRANT SELECT ANY TABLE.
• SELECT_CATALOG_ROLE
Enough combined disk space and virtual memory is needed to store all of the rows
that are sent for comparison from the source and target systems
To estimate the
amount of memory per row:
((number of cols in key + 1) * 4) + 16 + (comparison width of a key col)
Where:
comparison width of a key col depends on the comparison format that is selected by
Oracle GoldenGate Veridata
For example, the number 109998877, if compared as a decimal float, would require:
((1 + 1) * 4) + 16 + 9 = 33 bytes of memory for this row
In-Memory Sort: This sorts the data entirely in memory and is the fastest method,
but the memory requirements may exceed what is available. The sort memory
must be approximately 2.5 times larger than the size of the data set
In general the Oracle
GoldenGate Veridata server can write the rows to disk faster than the agent can
read them from the database.
Use the Repository Creation Utility (RCU) to create the repository
You can use the following databases as a repository:
• Oracle
• SQL Server
Comments
Post a Comment