EZConnect Oracle GoldenGate to Oracle Database – On-Premise or Cloud (DBaaS)
With the release of Oracle GoldenGate 19c, it has been made easier to connect Oracle GoldenGate to the Oracle Database – source or target. Gone are the days that you need to update your local tnsnames.ora file to point to the desired database. The only thing you have to do now, is ensure that your database is reachable via an easy connect (ezconnect) string.
Within Oracle GoldenGate 19c Microservices, you would simply setup the connection in the Credential Store within the Administration Service of the deployment where your GoldenGate processes will be running. In order to do this, you simply do the following:
1. Login to the Administration Service as an authorized user
2. Navigate to the Configuration option
3. Click on the plus ( + ) sign to add a new Credential. Fill in all the needed information. When filling in the information for User Id make sure you use the format for EZConnect:
<username>@<host>:<port>/<service_name>
4. Then click Submit
5. This will result in a useridalias connection being created and stored for the database. At this point, you can test the connection by clicking on the database icon for the connection.
If you provided the correct password for the user id, you should easily login to the Oracle Database you are pointed to.
This connection feature has been carried over to Oracle GoldenGate 19c Classic as well; afterall connections are part of the core product and enables both archiectures to connect in the same manner. The only difference is you would be workign from the GGSCI command line building the credential store information with some typing. To use EZConnect from GGSCI, follow these steps:
1. Login to GGSCI
$ cd $OGG_HOME
$ ./ggsci
2. Add the credential store (if you don’t already have one)
GGSCI (ogg19cca) 1> add credentialstore
3. Add the user with ezconnect string to the credential store
GGSCI (ogg19cca) 2> alter credentialstore add user c##ggate@oggdbaas:1521/orclogg password ************ alias SGGATE domain OracleGoldenGate
4. Test the connection using the DBLOGIN option
GGSCI (ogg19cca) 3> dblogin useridalias SGGATE domain OracleGoldenGate
GGSCI (ogg19cca as c##ggate@orclogg/CDB$ROOT) 4>
Enjoy!!!
Current Oracle Certs

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”.

také jsem si vás poznamenal, abych se podíval na nové věci na vašem blogu.|Hej! Vadilo by vám, kdybych sdílel váš blog s mým facebookem.
Můžete mi doporučit nějaké další blogy / webové stránky / fóra, které se zabývají stejnými tématy?
på grund af denne vidunderlige læsning !!! Jeg kunne bestemt virkelig godt lide hver eneste lille smule af det, og jeg
Tak Hej der til alle, det indhold, der findes på denne
O conteúdo existente nesta página é realmente notável para a experiência das pessoas,
muito dele está a aparecer em toda a Internet sem o meu acordo.
webside er virkelig bemærkelsesværdig for folks oplevelse, godt,
It contains fastidious material.|I think the admin of this website is actually working hard in favor of his site,
Tak Hej der til alle, det indhold, der findes på denne
Com tanto conteúdo e artigos, alguma vez se deparou com problemas de plágio ou violação de direitos de autor? O meu site tem muito conteúdo exclusivo que eu próprio criei ou
الاستمرار في توجيه الآخرين.|Ahoj, věřím, že je to vynikající blog. Narazil jsem na něj;
for the reason that here every material is quality based
pokračujte v pěkné práci, kolegové.|Když máte tolik obsahu a článků, děláte to?
Tak Hej der til alle, det indhold, der findes på denne
This page definitely has all of the information I wanted about this subject and didn’t know who to ask.
Its like you read my mind! You appear to know so much about this, like you wrote the book in it or something. I think that you can do with a few pics to drive the message home a bit, but instead of that, this is fantastic blog. A fantastic read. I will definitely be back.
Excellent beat ! I wish to apprentice while you amend your website, how can i subscribe for a blog web site? The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear idea
také jsem si vás poznamenal, abych se podíval na nové věci na vašem blogu.|Hej! Vadilo by vám, kdybych sdílel váš blog s mým facebookem.
nenarazili jste někdy na problémy s plagorismem nebo porušováním autorských práv? Moje webové stránky mají spoustu unikátního obsahu, který jsem vytvořil.
|Hello to all, for the reason that I am actually keen of
O conteúdo existente nesta página é realmente notável para a experiência das pessoas,
grupo do facebook? Há muitas pessoas que eu acho que iriam realmente
Podem recomendar outros blogues/sites/fóruns que tratem dos mesmos temas?
It contains fastidious material.|I think the admin of this website is actually working hard in favor of his site,
Kan du anbefale andre blogs / websteder / fora, der beskæftiger sig med de samme emner?
že spousta z něj se objevuje na internetu bez mého souhlasu.
Děkuji|Ahoj všem, obsah, který je na této stránce k dispozici.
Does your website have a contact page? I’m having trouble locating it but, I’d like to send you an email. I’ve got some creative ideas for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it improve over time.
Podem recomendar outros blogues/sites/fóruns que tratem dos mesmos temas?
Com tanto conteúdo e artigos, alguma vez se deparou com problemas de plágio ou violação de direitos de autor? O meu site tem muito conteúdo exclusivo que eu próprio criei ou
https://tastyslips.com/et/vendors/littledream20
Muito obrigado!}
Tak skal du have!|Olá, creio que este é um excelente blogue. Tropecei nele;
Muito obrigado!}
) سأعيد زيارتها مرة أخرى لأنني قمت بوضع علامة كتاب عليها. المال والحرية هي أفضل طريقة للتغيير، أتمنى أن تكون غنيًا و
Wedding Venues in Delhi is here to help you find and book the perfect place for your special day. We offer a range of wedding services to make your wedding planning easy and stress-free. We can also customize your wedding according to your budget and preferences.
Também tenho o seu livro marcado para ver coisas novas no seu blog.
meget af det dukker op overalt på internettet uden min aftale.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article. https://accounts.binance.com/cs/register?ref=S5H7X3LP
|Tato stránka má rozhodně všechny informace, které jsem o tomto tématu chtěl a nevěděl jsem, koho se zeptat.|Dobrý den! Tohle je můj 1. komentář tady, takže jsem chtěl jen dát rychlý
ocenili váš obsah. Dejte mi prosím vědět.
Quality articles is the crucial to attract the visitors to visit thesite, that’s what this web page is providing.
I discovered your blog site on google and check a few of your early posts. Continue to keep up the very good operate. I just additional up your RSS feed to my MSN News Reader. Seeking forward to reading more from you later on!…
det. Denne side har bestemt alle de oplysninger, jeg ønskede om dette emne, og vidste ikke, hvem jeg skulle spørge. Dette er min 1. kommentar her, så jeg ville bare give en hurtig
France is now certainly one of only 4 nations (together with Italy, Argentina and the Netherlands) to have shut Brazil out twice in the world Cup finals, and the first to have executed it in consecutive matches, each instances with Barthez in goal.
I love your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to create my own blog and would like to find out where u got this from. appreciate it
Having read this I believed it was really enlightening. I appreciate you taking the time and energy to put this content together. I once again find myself personally spending way too much time both reading and commenting. But so what, it was still worth it.
ICH WOLLTE FRÜHER WIE OLLI KAHN WERDEN»» (in German).
I am sure this paragraph has touched all the internet
visitors, its really really good piece of writing on building up new web site. https://menbehealth.wordpress.com/
You are so cool! I do not think I’ve truly read through something like this before.
So nice too find somebody with genuine thoughts on this issue.
Seriously.. thanks foor starting this up. This web site is something tgat is required oon the internet, someone with a
bit of originality! https://Edu.Smapjsidoarjo.Sch.id/blog/index.php?entryid=1518
Very good site you have here but I was wanting to know if you knew of any message boards that cover the saqme topics talked about here?
I’d really like to bee a part of community where Ican get comments from other knowledgeable individuals
that share thee same interest. If you have any suggestions, please let mee know.
Cheers! https://Heyanesthesia.com/forums/users/tracee1560/
Excellent blog you have got here.. It’s difficult to find high quality writing like yours nowadays. I seriously appreciate individuals like you! Take care!!
certainly like your web site but you have to take a look at the spelling onn several of
your posts. Several of them are rife with spelling
problems and I find it very troublesome to inform the reality on the other hand
I’ll defiitely come again again. https://ead.Alfadash.com.br/blog/index.php?entryid=12366
grupo do facebook? Há muitas pessoas que eu acho que iriam realmente
I like what you guys are up too. Such smart work and reporting! Carry on the superb works guys I have incorporated you guys to my blogroll. I think it will improve the value of my website 🙂
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
I?¦ve read a few good stuff here. Certainly value bookmarking for revisiting. I wonder how a lot attempt you put to make such a fantastic informative web site.
A fascinating discussion is worth comment. I do believe that you need to publish more about this issue, it may not be a taboo subject but usually people don’t talk about such topics. To the next! Cheers.
har også bogmærket dig for at se på nye ting på din blog Hej! Har du noget imod, hvis jeg deler din blog med min facebook
“名鉄、名駅周辺の再開発延期 21年3月期初の営業赤字”.日本経済新聞 (日本経済新聞社).荻原 博子(おぎわら ひろこ、1954年5月27日 – )は、日本の経済評論家、ジャーナリスト。 『荻原博子節約の◯と×これで老後はこわくない。 その結果、同年4月19日までにカーディフ生命保険を除く37社で、個人保険、団体保険、返戻金を合わせた不払いが計約44万件、およそ359億円に達したことが明らかになった。積立金の支払い漏れについて 旧協栄生命時代の75年3月~00年10月に販売していた「成人病特約」で積立金の不払いが3505件(総額約9860万円)あった、と発表した。
Paragraph writing is also a excitement, if you know after
that you can write otherwise it is complex too write. https://www.careers.zigtrading.co.za/employer/expert-in-research-papers/