Configure OGG between two Oracle servers-synchronization DDL is not configured

Environment:
Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
VBOX Virtual Machine
Host Name, database instance, database name, and IP address planning:
Source Host IP Address: 192.168.1.213 HOSTNAME: bys001.oel.com
Target Host IP Address: 192.168.1.213 HOSTNAME: bys2.oel.com
The instance name is the same as the database name. The database structure of the two hosts is the same.
Configure the source host first, and then clone a host to modify the configuration as the target host.
The source host has installed the ORACLE database software and created a database.

The configuration is divided into six steps:
1. Modify environment variables and create directories
2. Upload the OGG software and decompress and install it.
3. query the database name and Instance name, enable archiving mode, and generate logs forcibly.
4. Create a user for OGG in the database
5. Start configuring OGG synchronization-DDL synchronization Not Configured
6. test whether DML operations can be performed on the test1 table of the test user.
######################################
1. Modify the environment variables and create the directory [oracle @ bys001 ~] $ Vi. bash_profile
Add this sentence:
Export OGG_HOME =/u01/ogg
". Bash_profile" 24L, 560C written
[Oracle @ bys001 ~] $ Source. bash_profile
[Oracle @ bys001 ~] $ Cd/u01
[Oracle @ bys001 u01] $ mkdir ogg
[Oracle @ bys001 u01] $ ls
Admin checkpoints oradata
App diag oraInventory
Archbys1 flash_recovery_area
Cfgtoollogs ogg
[Oracle @ bys001 u01] $ echo $ OGG_HOME
/U01/ogg

2. Upload the OGG software and decompress it and install it ---- use ssh secure shell for easy upload.
[Oracle @ bys001 ~] $ Ls ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip
[Oracle @ bys001 ~] $ Unzip ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip
[Oracle @ bys001 ~] $ Ls fbo_ggs_Linux_x86_ora11g_32bit.tar
Fbo_ggs_Linux_x86_ora11g_32bit.tar

[Oracle @ bys001 ~] $ Tar-xvf fbo_ggs_Linux_x86_ora11g_32bit.tar-C $ OGG_HOME

Solve an error when ggsci is Enabled:
I encountered an error using ggsci here because the library file cannot be found and an error is returned:
[Oracle @ oel-01 ogg] $./ggsci
./Ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory
We recommend that you run the following command in the OGG directory before use: [oracle @ bys001 ogg] $ ldd ggsci
If all the library files are in, you can directly execute [oracle @ bys001 ogg] $./ggsci
If the library file is missing, you can find/-name libnnz11.so and query it in the entire/directory.
You can create a soft link based on the detected location of the database file. Use the root account. For example:
[Root @ oel-01 ~] # Ln-s/u01/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so/lib/libnnz11.so

Create an OGG Directory: Call the OGG installation directory
[Oracle @ bys001 ogg] $./ggsci

GGSCI (bys001.oel.com) 2> create subdirs

Creating subdirectories under current directory/u01/ogg

Parameter files/u01/ogg/dirprm: already exists
Report files/u01/ogg/dirrpt: created
Checkpoint files/u01/ogg/dirchk: created
Process status files/u01/ogg/dirpcs: created
SQL script files/u01/ogg/dirsql: created
Database definitions files/u01/ogg/dirdef: created
Extract data files/u01/ogg/dirdat: created
Temporary files/u01/ogg/dirtmp: created
Stdout files/u01/ogg/dirout: created
You only need to write: PORT 7809 in the open window. The usage is the same as that of VI.
GGSCI (bys001.oel.com) 4> edit param mgr
PORT 7809
GGSCI (bys001.oel.com) 7> start mgr
Manager started.

GGSCI (bys001.oel.com) 8> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING

OGG installation is complete. Because the VM will be cloned later, you only need to install it once.
Configure OGG synchronization in step 1.
######################################## #######

For more details, please continue to read the highlights on the next page:

 

Management OGG-HA in RAC Environment

Configure OGG synchronization in RAC Environment

GoldenGate unidirectional table DML Synchronization

Oracle GoldenGate series: restoration principles of Extract processes

Oracle GoldenGate installation Configuration

OGG-01004 OGG-1296 error for Oracle goldengate

1 2 3 Next Page