Shulou(Shulou.com)05/31 Report--

Editor to share with you the example analysis of ogg stand-alone installation, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

First, system check:

1.1 to install on UNIX, the person installing Oracle GoldenGate must have read and write access to the Oracle GoldenGate installation directory and establish a special directory to install the software

1.2 the Oracle database must be in ARCHIVELOG mode so that Extract can handle log files.

1.3 using the ANYDATA Data Types data type, the source database compatibility must be set to 11.2.0.0.0 or later.

Install trigger-based DDL capture (versions of Oracle earlier than version 11.2.0.4 require trigger-based capture). If the Extract process is for 11.2.0.4 or higher, no installation is required.

1.5 when the source database is Oracle 11.2.0.4 or later and Extract is running in integrated mode, DDL capture support is integrated into the database login server without the need for DDL triggers. However, the database parameter compatibility must be set to 11.2.0.4.0. In integrated capture mode, Extract supports DDL. Exe that contains password-based column encryption.

II. Installation

2.1 Setting ORACLE_HOME and ORACLE_SID set up ORACLE_HOME and ORACLE_SID

2.2 Setting Library Paths for Dynamic Builds on UNIX: set the dynamically built library path LD_LIBRARY_PATH on UNIX

Perform an interactive installation using OUI

III. Database configuration

3.1 configure logging properties:

Check whether the minimum supplementary log and force logging are enabled:

SELECT supplemental_log_data_min, force_logging FROM v$database

Enable the minimum supplementary log and force logging:

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

ALTER DATABASE FORCE LOGGING

3.2 enable schema-level supplementary logging:

Oracle GoldenGate supports Schema-level supplementary logging. When using the Oracle GoldenGate DDL replication feature, the Oracle source database requires Schema level logging. In all other use cases, it is optional, but you must use table-level logging instead of schema-level supplementary logging (see enabling table-level supplementary logging).

Enable Oracle GoldenGate in the database: set the parameter ENABLE_GOLDENGATE_REPLICATION = true

3.4 set flashback query: Grant either of the following privileges to the Oracle GoldenGate Extract user:

GRANT FLASHBACK ANY TABLE TO db_user

Or

GRANT FLASHBACK ON schema.table TO db_user

3.5 set STREAMS_POOL_SIZE size

STREAMS_POOL_SIZE=a*1+ (A0.25) unit: G, indicating that a refers to the number of Extract and Replicat processes on the source or target database

3.7 Parameter Settin

Setting parameter enable_goldengate_replication=true for source and target libraries

3.8 user Rights Settin

Authorized to users who manage ogg software, such as which permissions are specifically granted by grant dba to ogg;, refer to official documents, or grant dba permissions directly

The above is all the contents of the article "sample Analysis of ogg stand-alone installation". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.