Since I published posts on how to retrieve command history within GGSCI using the Oracle provided commands of “history” and “fc”, I was pinged a couple of times by some friends asking about “rlwrap” usage with GoldenGate. The answer is a simple yes, rlwrap can be used with Oracle GoldenGate.
What exactly is “rlwrap”?
According to the readme file at http://utopia.knoware.nl/~hlub/uck/rlwrap/#rlwrap, rlwrap is a ‘read-one wrapper’. Basically, it allows for the editing of keyboard input for any command.
How to install?
There are two ways to install “rlwrap”. The first way is manually, which requires you to run the configure and make commands; however, the easiest way I’ve found is by using a yum repository. Tim Hall (a.k.a Oracle-Base) documents this process quite effortlessly over at his blog. Thanks Tim!
Usage?
After you have “rlwrap” installed, you simply have to create an alias in your profile to use it. You can use it from the command line as well; however, the alias approach ensure that it is executed every time you run ggsci. The below example is what I have running in my .bash_profile for the Oracle user.
alias ggsci='rlwrap $OGG_HOME/ggsci'
The next time I login to use ggsci, rlwrap will automatically be ran and then I will be able to scroll through the commands I typed while in ggsci. Another nice thing about “rlwrap” is that when I logout of ggsci, and then back in, my command history is available still.
Although the “history” and “fc” commands are handy, it would be nice to see Oracle include “rlwrap” into the core product of Oracle GoldenGate …
Enjoy!
@dbasolved
http://about.me/dbasolved
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
“Fixngotx offers top-quality garage door repair services, ensuring your home stays secure and functional. Our expert technicians provide fast, reliable, and affordable solutions for all garage door issues. From spring replacements to opener repairs, trust us to restore your garage door to perfect working condition. Call now!”
In today’s fast-paced world, home appliances play a crucial role in keeping our daily lives running smoothly. From refrigerators and washing machines to dishwashers and ovens, these appliances are essential for convenience and comfort. But when they break down, it can be a major disruption. That’s where authorized appliance service comes into play — providing peace of mind and professional repairs that protect your investment.
When it comes to the safety of your home, vehicle, or business, you want a service provider you can rely on. That’s where Brothers Locksmith steps in—offering expert locksmith services that combine efficiency, professionalism, and trustworthiness. Whether you’re locked out of your car at midnight or need to upgrade the security system of your business, Brothers Locksmith is the dependable solution you need.