Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GoldenGate Running with no error but no replication.How to Troubleshoot?

VIRUJan 12 2012 — edited Jan 17 2012
Hi,

I am using 2 servers

OS DB
Server 1 - IBM AIX ORACLE 11g - Source Machine.
Server 2 - Oracle Linux 5 ORACLE 11g - Target Machine.

I am trying to apply goldengate to replicate data as well as DDL modifications from Server 1 to Server 2.

Details of Server 1 :-

Manager is running.

Parameter file for Extract IUT01

EXTRACT IUT01
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST OFSMUG-VM-87.i-flex.com, MGRPORT 7809
RMTTRAIL /oracle/GoldenGate/Setup/dirdat/rt
TABLE NGPIUT01.*;

Parameter file for Extract IUT01DP - Data pump Extract

EXTRACT IUT01DP
USERID ggs_owner, PASSWORD ggs_owner
EXTTRAIL /data01/oradata/GoldenGate/dirdat/dpump/lt
TABLE IUT01.*;

GGSCI (FIFLX595) 56> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING IUT01 00:00:00 00:00:05
EXTRACT RUNNING IUT01DP 00:00:00 00:00:09


Details of Server 2 :-

Manager is running.

Parameter file for Replicat NGPIUT01

REPLICAT NGPIUT01
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ggs_owner
MAP NGPIUT01.*, TARGET IUT01.*;

GGSCI (OFSMUG-VM-87.i-flex.com) 42> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING NGPIUT01 00:00:00 00:00:08


But I can't see the changes happening in the Source db getting reflected in the Target db .


Please guide me how should i troubleshoot here???? I am not getting any error but no effect of replication as well.


Thanks in advance!

Comments

Dude!

You should be able to open the vi utility by simply giving the absolute path:

# cd ~

# /bin/vi .bashrc

There isn't really much in .bashrc

# cat .bashrc

# .bashrc

# User specific aliases and functions

alias rm='rm -i'

alias cp='cp -i'

alias mv='mv -i'

# Source global definitions

if [ -f /etc/bashrc ]; then

    . /etc/bashrc

fi

ReemaPuri

Actually  when i logged in with root user  then i am not able to use vi command

[reema@reema Desktop]$ vi /etc/oratab

[reema@reema Desktop]$ su

Password:

[root@reema Desktop]# vi /etc/oratab

bash: vi: command not found

[root@reema Desktop]#

But  with normal user i am able to use vi command

why ?

Dude!

When you type "vi", the command line interpreter attempts to locate the path to the executable by walking through the directories defined by the PATH environment variable. If your PATH does not contain the directory where the program resides, you will have to specify the correct path instead, e.g.: /bin/vi. The PATH environment variable and other things are defined in the login scripts, such as .bashrc, /etc/profile, etc. and read depending on your type of shell. Note the difference between "su" and "su -". The later will perform a login and reset the current environment. You obviously screwed up the root login environment.

[root@localhost ~]# ls -al

total 36

dr-xr-x---.  2 root root 4096 Jan  3 00:00 .

drwxr-xr-x. 17 root root 4096 Jan  3 00:00 ..

-rw-------.  1 root root  903 Jan  2 21:43 anaconda-ks.cfg

-rw-------.  1 root root  525 Jan  3 01:24 .bash_history

-rw-r--r--.  1 root root   18 Apr 30  2014 .bash_logout

-rw-r--r--.  1 root root  176 Apr 30  2014 .bash_profile

-rw-r--r--.  1 root root  176 Apr 30  2014 .bashrc

-rw-r--r--.  1 root root  100 Apr 30  2014 .cshrc

-rw-r--r--.  1 root root  129 Apr 30  2014 .tcshrc

[root@localhost ~]# cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

    . ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

[root@localhost ~]#

ReemaPuri

Yes u r right but what i found is in .bash_profile

Screenshot.png

I am setting in .bash_rc

export ORACLE_HOME=/u01/app/oracle/

product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$/u01/app/oracle/product/11.2.0/dbhome_1
export PATH

Is it my Path clashing am i right

in .bash_profile and .bash_rc

Dude!
Answer

Pretty much everything there is wrong. What you probably want to set is the following:

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export PATH=$PATH:$ORACLE_HOME/bin

or better:

$ . oraenv

Enter your oracle SID and all your Oracle environment variables will be set.

Marked as Answer by ReemaPuri · Sep 27 2020
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 14 2012
Added on Jan 12 2012
4 comments
1,562 views