GoldenGate Service (GGS) – Connection Setup

 

oci ggs trail files bridge

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:

ggs connections

This will bring you to the “Connections” page.  From here there is a “Create Connection” button.

gg_connectons_btn

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.

ggs connections dialog

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.  

ggs connection types

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.

ggs select db

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.  

ggs connection screen

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.

ggs add deployment

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

ggs deployment assign

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.

ggs test connection

A successful connection will look like this:

ggs connection success

Please follow and like:
Comments
  • 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~

  • 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!

  • 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

  • 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

  • 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

  • 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

  • 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

  • Get free Bitcoin & altcoin offers, fresh blockchain news, and crypto insights — updated daily. 100% free. No fluff. Just crypto. Visit: FreeAltcoins.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]

  • 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!

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.