Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Caeli.

Asked: September 05, 2017 - 3:55 am UTC

Last updated: September 19, 2017 - 1:50 am UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Hi Tom, I want to ask. Is there any ways to create ggsci interface? Like using netbeans or something. Thanks

and we said...

GoldenGate Software Command Interface (GGSCI) is the interface to interact with the Oracle GoldenGate environment. This utility is similar to SQL*PLUS which allows you to interact with the Oracle Database.

Not exactly sure, on what you mean about "create ggsci"; you can execute the GGSCI executable from the Oracle GoldenGate Home directory.

If you want to access GGSCI from a shell script, you would do it the same way as you would with SQL*PLUS:

$OGG_HOME/ggsci << EOF
.
.
<commands>
.
.
EOF

Enjoy!!!

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Get your > and < right !

AndyHelm, September 18, 2017 - 12:41 pm UTC

Actually, you would need those double angle brackets to point the other way :

$OGG_HOME/ggsci << EOF
..
..
EOF
Connor McDonald
September 19, 2017 - 1:50 am UTC

Thanks, we've fixed that
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database