GoldenGate Service (GGS) – Connection Setup
Creating Connections
In Oracle GoldenGate (on-premises) we always have to setup a connection to the database. This is done by using the credential store to house the connection and then testing it. What happens when we move this concept to OCI and the GoldenGate Service (GGS)? The concept of the credential store is still there; however, in GGS it is listed under or considered a “Connection”.
Setup a Connection
The “Connection” can be setup from the main page of the GoldenGate Service (GGS). It is listed under the “GoldenGate” Sub-menu:
This will bring you to the “Connections” page. From here there is a “Create Connection” button.
By clicking on the “Create Connection” button, a dialog box opens up from the right-hand side of the screen. This is the details screen where we can provide general information and connection details for making the connection to a database.
In the dialog box, provide the general details and select the type of data source that the connection is used for. In this case, we will be connecting to an Oracle Database for this connection.
With selecting an Oracle Database and clicking the Next button, we are taken over to “Connection Details”. On this screen, we are presented with two radio buttons that allow us to determine how to connect to an Oracle Database. If we select the “Select database” option, we can select a database that is running in OCI. Or we can select “Enter Database Information”, this option we have to know exactly how we want to connect to the database – think of using a TNSName entry in this case. To simplify this approach and since we are OCI based, we are going to “Select database” option.
Notice that connection details are populated for us. All we needed to provide is the database user that we want to connect to. In this case, we are using a “common user” of C##GGATE (above). After which we can click “create”.
After clicking “Create”, notice that we are taken to the “Connections Detail” screen. This screen is setting up the connection.
Adding Deployment
After the connection is created, we can then assign the connection to a “Deployment”. This is done by using the “Assign Deployment” button that is on the Connections page.
.By clicking the “Assign Deployment” button, you will be presented with a dialog that comes up in the middle of the page. This dialog box will allow you to select the GGS deployment that the connection is to be assigned to. In this case, we only have one deployment – Atlanta.
Testing Connection
With the deployment assigned, we can now test the connection. This is done by using the elipsis at the end of the table and selecting “Test Connection”. If everything is correct, i.e password, for the user, a successful connection should be established.
A successful connection will look like this:
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”.
Hey there Dbasolved,
I came across your website and liked what I saw.
Is your business using Facebook to its full potential?
Many business owners are seeing stronger results by partnering with a specialist – focusing on running their business in the process.
Explore how smarter ads perform > View details: https://t.ly/ElevateStreamGrid.co
Rosemarie Lavin
Dear Founder,
An active investor we represent is now reviewing investment ready business ideas across all sectors no matter your industry or stage. What matters most is a compelling, scalable idea with strong execution potential.
Available Funding Options:
• 3% annual interest rate
• No early repayment penalties
• Convertible loan option available – convert to 10–15% equity after 2 years (optional)
Whether you’re building the next big tech platform, expanding a niche brand, or launching a bold new venture, now’s your chance to access smart capital on founder-friendly terms.
Simply send in your pitch deck or business plan to start the conversation. If your idea is solid, we’re ready to move.
Let’s help you bring your vision to life.
Yours Truly,
Chary Marshal
Investment Consultant/Strategist
Email: [email protected]
Hi,
I wanted to see if you’d be interested in a link exchange for mutual SEO benefits. I can link to your site (dbasolved.com) from a few of our high-authority websites. In return, you would link back to our clients’ sites, which cover niches like health, business services, real estate, consumer electronics, and more.
If you’re interested, let me know — I’d be happy to share more details!
Thanks for your time,
Karen
SEO Account Manager
Hi there Dbasolved,
regarding: – Facebook
Just had a look at your site—it’s clear you’re investing in visibility.
Do you feel your presence could generate more leads or sales?
Many business owners are seeing stronger results by bringing in a proven expert – avoiding the ad learning curve in the process.
Discover what a pro can offer – Start here: https://t.ly/FastScaleLab.ai
Giselle Mcnamee
347 businesses got their Employee Retention Credits last month using our system.
The one thing they all had in common?
They stopped waiting for the IRS and took action. Want to know what they did differently? Just reply YES or…
Email [email protected]
PO Box Addresss
Unsubscribe:
~ulr~
BREAKING NEWS! Sophie Cunningham caught wearing Geotrott at airport!…
https://www.tiktok.com/t/ZTjWFCK4L/
My name is Ahmet. I’m a bank staff in a Turkish bank. I’ve been looking for someone who has the same nationality as you. A citizen of your country died in the recent earthquake in Turkey, he had in our bank fixed deposit of $11.5 million.
My Bank management is yet to know of his death. If my bank executive finds out about his death ,They would use the funds for themselves and get richer and I would like to prevent that from happening only if I get your cooperation, I knew about it because I was his account manager. Last week my bank management held a meeting for the purpose of a bank audit to note the dormant and abandoned deposit accounts. I know this will happen and that’s why I’m looking for a solution to deal with this situation because if my bank discovers his death, they will divert the funds to the board of directors. I don’t want that to happen.
I request your cooperation to introduce you as the kin/heir of the account as you are of the same nationality as him. There is no risk; the transaction is carried out under a legal agreement that protects you from infringement. I suggest we split the funds, 60/40 and 40 for me. I need this fund for my daughter’s surgery so keep this info confidential. email me so i can provide you with more information. [email protected]
Ever stop to think how much you’re spending on marked-up CPMs for Connected TV ads?
If you’re using “premium” audience segments without verifying who you’re actually reaching, that money is likely feeding someone else’s family.
No pressure. Here’s the site if you’re open to see a revolutionary vision for digital advertising
topshelfaudience.com using real-time Intent data from an Integration in our platform to Lotame.com. You can reach me at [email protected] or 843-720-7301. And if this isn’t a fit please feel free to email me and I’ll be sure not to reach out again. Thanks!
Introducing Geotrott Luggage! Get yours now!
https://www.tiktok.com/t/ZTj7UYB5v/
Hey this is my TikTok!
https://www.tiktok.com/t/ZTj7CvdRa/
Hello Dbasolved,
Re: — Facebook
I came across your website and liked what I saw.
Is your business using Facebook to its full potential?
Many business owners are seeing stronger results by delegating ad strategy – focusing on running their business in the process.
Check what expert help can do >> View details: https://t.ly/CoreXReachCore.ai
Epifania Ecuyer
Hi there,
Every day, countless small businesses deliver outstanding products and services — but many remain unseen simply because they lack the massive marketing budgets of big corporations.
Their dedication, passion, and quality deserve to be noticed, appreciated, and chosen.
That’s exactly why AutoBuzz.ai was created — by a team of tech professionals who deeply understand this struggle. They’ve faced the same challenges: trying to get noticed without spending thousands on agencies or complex tools.
So they built a solution designed for businesses like yours:
✅ AI-generated professional promo videos in minutes
✅ No tech skills required
✅ Affordable and accessible for startups and small teams
✅ Fast turnaround — ready-to-share content for social media and your website
With AutoBuzz, you can finally showcase the true value of your work and stand out in your market — without a big marketing department behind you.
Now even the smallest businesses can access tools once reserved for the giants.
Ready to give your business the visibility it deserves?
Discover it : https://jvz9.com/c/3091907/416189/
Limited-time launch offer: $67 one-time fee.
And remember: the minds behind this tool have walked in your shoes. That’s why it works so well.
Regards
Mike Dalton
Hey, are you guys still waiting for your Employee Retention Credit to arrive?
If so, we can expedite it’s arrival from the IRS.
Email [email protected]
PO Box Addresss
Unsubscribe:
~ulr~
Hey Dbasolved,
FYI >> Facebook
Just had a look at your site—it’s clear you’re active online.
Is your business using Facebook to its full potential?
Many business owners are seeing stronger results by delegating ad strategy – avoiding the ad learning curve in the process.
Discover what a pro can offer >> Start here: https://t.ly/DirectLaunchZone.net
Daniel Gavin
Free forever
No credit card required
https://bit.ly/4kWBSvq
Hey there, I came across your website and was impressed—great work!
I know your time is valuable, so I’ll be brief.
AI is essential for business growth, and many owners struggle to know where to start—that’s why I’m here to help.
We’ve created two guides called AI For Entrepreneurs and Smarter with AI, normally priced at $29 each, and we’re offering it to you for free. Inside, you’ll discover:
+ How to quickly increase your business/website revenue.
+ A simple framework for incorporating AI into your business.
+ Proven strategies to boost productivity and save time.
+ Expert tips to get results, whether you’re just starting or well-established.
Remember, this is absolutely free and will cost you nothing!
Would you like a free copy?
Get yor guide here: http://aibusinessmastery.pro
I’m confident it’ll be a game-changer for you, and I’d love to hear how it works for your business!
Best regards
Hey Dbasolved,
regards: > Facebook
Just had a look at your site—it’s clear you’re serious about growth.
Do you feel your presence could generate more leads or sales?
Many business owners are seeing stronger results by delegating ad strategy – freeing up time in the process.
Check what expert help can do – See how it works: https://t.ly/BrandLaunchZone.io
Coy Small
Hi,
I hope you’re doing well!
I’m reaching out to see if you’d be open to a link exchange with us. I’d be happy to write a feature article about your business and include a backlink to your site (dbasolved.com) from one of our company websites. In return, we kindly ask that you link back to us from any page of your site on dbasolved.com.
Let me know if this sounds like something you’d be interested in — I’d love to explore the possibility with you.
Looking forward to your reply
!
Warm regards,
Choy
You probably get a lot of these messages, so I’ll keep it quick — we’re offering free web traffic to website owners, no signup or payment.
https://trafficboosterhub.top
Hello!
Client shocked you? Skip the predictable thank-yous.
Send flowers that actually feels thoughtful, in under a minute. Handled for you.
The easy way to say thanks: https://t.ly/dailyplantcorner.com
Freddie Hunter
Seeking Financial Support to Expand Your Business? We provide customized business loan options with no initial fees—merely a straightforward notary approval! Acquire the necessary funds to grow, innovate, and thrive. Email us today: [email protected]
Best regards,
Laura Cha
Customer Service Representative
Hi,
I’m Sachin, a senior web developer with over 10 years of hands-on experience in web design and development. I currently work with one of the top web development companies, delivering high-quality, scalable, and secure websites.
My hourly rate is $8.
My expertise includes:
* Custom website design (mockups and templates)
* Full website development (theme creation & backend customization)
* Responsive design for all screen sizes and devices
* Plugin and extension development
* Website speed optimization & on-page SEO
* Website security enhancements
* Website migration, ongoing support, and maintenance
If you have a project or specific requirement in mind, feel free to reach out—I’d be happy to discuss it further.
Email me at:
[email protected]
Best regards,
Sachin
We provide premium traffic for ANY offer.
https://bit.ly/3TT60fa
Hit them back
https://www.speed-seo.net/product/negative-seo-service/
whatsapp: +1 (833) 454-8622
Hello dbasolved.com
I am contacting you to introduce you to a tool that can really simplify the daily work of client research: it is called Aigency Valet Bundle and it is a platform powered by artificial
intelligence that:
-automatically finds local leads in your niche;
-analyzes websites, social networks and Google Business profiles;
-identifies real problems to solve;
-writes and sends personalized persuasive emails.
It is a “turnkey” solution to acquire new clients in a scalable way, even without technical skills or time to invest in manual outreach.
The bundle also includes professional web templates, free hosting, customizable reports, advanced audit tools and future updates included.
To encourage testing, access to the platform is covered by a 30-day money-back guarantee: you can try it with complete peace of mind and evaluate if it’s right for you.
Discover the full offer here: https://jvz6.com/c/3091907/419307
If you like, I can also guide you with a more detailed overview.
Best regards,
Kris Jones
hotanal.com
Hi,
Would you be open to a simple link exchange? I’ll publish a short feature article about your business & linking to your site (dbasolved.com) from one of ours — and in return, you link back to us from any page on your site
.
Let me know if you’re keen!
Best,
Choy
visit BitcoinPlatform.com
Get free Bitcoin & altcoin offers, fresh blockchain news, and crypto insights — updated daily. 100% free. No fluff. Just crypto. Visit: FreeAltcoins.com
Free traffic without the spammy tactics. We don’t ask for your login or make you sign up for anything. Just share your link and we’ll help get eyes on your content.
https://trafficboosterhub.top
visit BitcoinPlatform.com
Get free Bitcoin & altcoin offers, fresh blockchain news, and crypto insights — updated daily. 100% free. No fluff. Just crypto. Visit: FreeAltcoins.com
Hello! Just reaching out with a quick question – are you happy with your current website hosting?
We manage hosting and support for hundreds of websites, from local businesses to national brands. Our team handles speed, security, backups, and all the day-to-day tasks most companies don’t want to deal with.
If you’d like me to take a quick look at your site or send more details, just let me know!
– Emily at the Best Website Agency
[email protected]
This is going to help so many people.
My name is Kim and I’m with a publishing firm out of Los Angeles. Our team came across your info and were interested in your work..
We’re always on the lookout for interesting people and stories to write about, and yours caught our attention. We’d love to offer you a complimentary sample of our writing to show you what your story could look like on paper.
If you’d be interested in a quick sample of our work please book a time to chat here.
https://calendly.com/mystoryonboarding/discovery-call?utm_source=form&utm_campaign=a1&month=2025-08
Hope to hear from you soon!
Kim
PO Box Addresss
Unsubscribe:
~ulr~
Two types of businesses right now:
Type A: Still waiting anohter 12-18 months for their ERC refund, hoping the IRS eventually gets to them
Type B: Working with us to get their funds in 6 weeks or less
Which would you rather be?
Your guarantee: If we don’t cut your wait time by at least 75%, you pay nothing.
Reply to this messael or shoot a message to [email protected]
Let’s turn that pending credit into working capital NOW.
Best,
Anthony
JMR Capital
Limited to 20 new clients this month – 8 spots left
Ever stop to think how much you’re spending on marked-up CPMs for Connected TV ads?
If you’re using “premium” audience segments without verifying who you’re actually reaching, that money is likely feeding someone else’s family.
No pressure. Here’s the site if you’re open to see a revolutionary vision for digital advertising
topshelfaudience.com using real-time Intent data from an Integration in our platform to Lotame.com. You can reach me at [email protected] or 843-720-7301. And if this isn’t a fit please feel free to email me and I’ll be sure not to reach out again. Thanks!
Struggling to get targeted leads to your Dbasolved Com website? Watch this: https://www.youtube.com/shorts/A8YPkXQq4EY
Chat with a live psychic today! Visit PsychicChat.com