Codeinsane

• เปิดโปรแกรม GoldenGate

# gg
# ./ggsci

•  แสดง Process ทั้งหมด

GGSCI (lab-ora.lab.local) > info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED

•  แก้ไขไฟล์ bash_profile

# vi .bash_profile

# .bash_profile

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# User specific aliases and functions

PATH=$PATH:$HOME/bin

export PATH

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=lab-ora.lab.local; export ORACLE_HOSTNAME
ORACLE_UNQNAME=ORCL; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_GG=$ORACLE_BASE/product/gg; export ORACLE_GG
ORACLE_SID=ORCL; export ORACLE_SID
ORACLE_SSID=orcl; export ORACLE_SSID

PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
PATH=$ORACLE_HOME/OPatch:$PATH; export PATH
PATH=$ORACLE_GG:$PATH; export PATH

alias gg='cd $ORACLE_GG'
alias network='cd $ORACLE_HOME/network/admin'
alias trace='cd $ORACLE_BASE/diag/rdbms/$ORACLE_SSID/$ORACLE_SID/'
alias RMAN_LOG='cd /usr/openv/netbackup/ext/db_ext/oracle/samples/rman'
alias rlsqlplus='rlwrap sqlplus'
alias rlrman='rlwrap rman'
alias rlggsci='rlwrap ./ggsci'
#stty erase ^H
#stty erase ^?

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

• ทำการอัพเดทไฟล์ bash_profile

# source .bash_profile

• เปิดโปรแกรม GoldenGate

# gg
# ggsci

• สร้าง Sub Directory ผ่าน GGSCI

GGSCI (lab-ora.lab.local) > create subdirs

Creating subdirectories under current directory /u01/app/oracle/product/gg

Parameter files                /u01/app/oracle/product/gg/dirprm: already exists
Report files                   /u01/app/oracle/product/gg/dirrpt: created
Checkpoint files               /u01/app/oracle/product/gg/dirchk: created
Process status files           /u01/app/oracle/product/gg/dirpcs: created
SQL script files               /u01/app/oracle/product/gg/dirsql: created
Database definitions files     /u01/app/oracle/product/gg/dirdef: created
Extract data files             /u01/app/oracle/product/gg/dirdat: created
Temporary files                /u01/app/oracle/product/gg/dirtmp: created
Credential store files         /u01/app/oracle/product/gg/dircrd: created
Masterkey wallet files         /u01/app/oracle/product/gg/dirwlt: created
Dump files                     /u01/app/oracle/product/gg/dirdmp: created

• ทำการ Start MGR

GGSCI (lab-ora.lab.local) > start mgr
ERROR: Parameter file /u01/app/oracle/product/gg/dirprm/mgr.prm does not exist.

• แก้ไข Parameter File

GGSCI (lab-ora.lab.local) > edit param mgr

PORT 7809
--AUTOSTART ER *
--AUTORESTART ER *, RETRIES 10, WAITMINUTES 2, RESETMINUTES 30
PurgeOldExtracts ./dirdat/*, UseCheckpoints, MINKEEPDAYS 7
--PurgeOldExtracts ./dirdat/*, UseCheckpoints, MINKEEPDAYS 7
--STARTUPVALIDATIONDELAY 5

• ทำการ Start MGR อีกครั้งหนึ่ง

GGSCI (lab-ora.lab.local) > start mgr
Manager started.

• ทำการตรวจสอบสถานะ MGR

GGSCI (lab-ora.lab.local) > info mgr

Manager is running (IP port lab-ora.lab.local.7809, Process ID 4124).

• ทำการตรวจสอบ Process

GGSCI (lab-ora.lab.local) > info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING