OGG
[OGG] INSTALL _ Redhat
from-sh
2022. 1. 13. 10:36
728x90
- OS 사전환경 조성
1. OS user 생성(oracle 계정의 그룹과 동일 설정)
| # id oracle
uid=1001(oracle) gid=1001(dba) groups=1001(dba)
# useradd -g dba ogg
# passwd ogg
Changing password for user ogg.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
|
2. OGG_HOME directory 생성
# mkdir /ogg
# chown -R ogg:dba /ogg/
3. OGG 계정 profile 설정
$cat .bash_profile
|
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export PATH
umask 022
export EDITOR=vi
export PS1="[\u@\h-$ORACLE_SID:\w]$"
export ORACLE_BASE=/oracle/base
export ORACLE_HOME=$ORACLE_BASE/product/19.3
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:.:
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:.:$PATH:$OGG_HOME
export ORACLE_TERM=xterm
stty erase ^H
export OGG_HOME=/ogg/oggs
|
- DB 사전 환경 확인
1. archive log list
| SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/base/product/19.3/dbs/arch
Oldest online log sequence 16
Next log sequence to archive 18
Current log sequence 18
|
2. enable_goldengate_replication parameter
| SQL> show parameter goldengate
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE
resource_manage_goldengate boolean FALSE
|
3. supplemental log
| SQL> select supplemental_log_data_min from v$database;
SUPPLEME
--------
YES
|
- OGG 설치
$unzip V983658-01.zip -d /ogg
$mkdir oraInventory
$vi oraInst.loc
|
inventory_loc=/ogg/oraInventory
inst_group=dba
|
$./runInstaller -silent -invPtrLoc /ogg/oraInst.loc \
INSTALL_OPTION=ORA19c \
SOFTWARE_LOCATION=/ogg/oggs
============================================================================
- rsp 파일 사용 설치
$cd /ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response
$vi oggcore.rsp
|
INSTALL_OPTION=ORA12c
SOFTWARE_LOCATION=/ogg/oggs
|
$./runInstaller -responseFile /ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp -invPtrLoc /ogg/oraInst.loc -silent
============================================================================
$ggsci
| Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
GGSCI (rhel8.3single) 1>
|
**
ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory
-> INSTALL_OPTION
-> bash_profile : export PATH=$OGG_HOME
확인!cle19 install
728x90