Oracle Golden gate version using shell scrip

Question

I am trying to grep the Oracle golden gate from a remote machine, But along with version it is giving some error details also, How do I resolve it ?

user@serverhost:/dbei > echo  <golgengate install path>/ggsci | ssh gger@payhlc203 | grep "Version"

Pseudo-terminal will not be allocated because stdin is not a terminal.
stty: standard input: Invalid argument
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO

score 1 · Answer 1 · edited Oct 04 '15 at 12:18

1

Use the -T option to ssh;

-T Disable pseudo-tty allocation.

from the manpage.

edited Oct 04 '15 at 12:18

Jenny D

27,780
21
75
114

answered Apr 13 '13 at 16:58

Chris Rees

275
1
7

score 0 · Answer 2 · answered Oct 16 '13 at 06:48

Even if you disable pseudo-tty allocation (-T option), you may still get the Invalid argument error.

It looks like ggsci is an interactive program that expects some input. You might try something like this instead:

echo | ssh gger@payhlc203 /path/to/goldengate/ggsci | grep Version

Failing that, you can always get rid of the extraneous output by redirecting stderr, eg:

echo | ssh gger@payhlc203 /path/to/goldengate/ggsci 2>/dev/null | grep Version

Oracle Golden gate version using shell scrip

2 Answers2