DBASolved

Subscribe to  DBASolved feed  DBASolved
Updated: 11 hours 6 min ago

Build an HVR Hub without underlying database

Thu, 2020-05-07 13:57

In recent years, the data integration/replication space has stared to become crowded.  Products like Oracle GoldenGate have become stables inside of organizations, but companies like HVR are chipping away at that marketshare.  Since I left Oracle, I’ve been evaluating and looking at some of these data integration/replication tools and I like HVR.  HVR provides some […]

The post Build an HVR Hub without underlying database appeared first on DBASolved.

Categories: DBA Blogs

Installing SnowSQL, Testing and using Auto-Login

Mon, 2020-05-04 16:46

SHOUT OUT – Need to give Danny Bryant (@dbaontap) a huge thanks for taking my call today and setting me on the right path when dealing with Snowflake.  Thanks buddy!!! Today I’ve been reviewing and playing with Snowflake through their developer platform (https://developer.snowflake.com). Getting setup was pretty painless other than having to provide contact information; […]

The post Installing SnowSQL, Testing and using Auto-Login appeared first on DBASolved.

Categories: DBA Blogs

Generate an RSA key to use with Cloud platforms

Wed, 2020-04-22 15:57

An SSH key consists of a pair of files.  One file is the private key, which you keep to yourself and never give out to anyone.  The other is a public key which you share with other people or platforms.  Key pairs are handy when you are provisioning cloud environments because they give you a […]

The post Generate an RSA key to use with Cloud platforms appeared first on DBASolved.

Categories: DBA Blogs

Install Azure CLI on MacBook Pro

Mon, 2020-04-06 18:58

Microsoft has enabled its cloud platform to have a command line (CLI) utility that can interact with the cloud based services.  This CLI is installed on the Mac OS X operating system by using homebrew.   Homebrew To install homebrew, use the package manager.  Homebrew makes it easy to install the Azure CLI with very few commands. […]

The post Install Azure CLI on MacBook Pro appeared first on DBASolved.

Categories: DBA Blogs

Add a deployment to Oracle GoldenGate 19c Microservices

Tue, 2020-01-21 13:33

Once you have an up and running Oracle GoldenGate Microservices environment, there may come a time when you need to add another deployment to the enviornment.  Adding deployments is easily done using Oracle GoldenGate Configuration Assistant (OGGCA).  In the below video, I show you how to add a deployment to an existing ServiceManager.  Additionally, I […]

The post Add a deployment to Oracle GoldenGate 19c Microservices appeared first on DBASolved.

Categories: DBA Blogs

Installing Oracle GoldenGate 19c Microservices – Binaries Only

Wed, 2020-01-15 12:43

It has taken me some time to get around to doing more videos; mostly because I don’t like the way that I sound when I hear my voice. Maybe next time, I’ll just do a silent video..lol.  Moving forward,  I’ll make more of an effort to produce a more videos that explain a few of […]

The post Installing Oracle GoldenGate 19c Microservices – Binaries Only appeared first on DBASolved.

Categories: DBA Blogs

@DATE, @DATENOW … Date functions in GoldenGate

Tue, 2020-01-14 11:59

Dates are always fun to play with when it comes to the Oracle Database, much less any other relational database.  Dates are used for many thinks in a wide range of application and schemas.  You have birthdays, ship dates, order dates, registration date, etc….  You get the picture.   In the Oracle Database you can […]

The post @DATE, @DATENOW … Date functions in GoldenGate appeared first on DBASolved.

Categories: DBA Blogs

Configure Distribution Service between two Secure GoldenGate Microservices Architectures

Mon, 2019-12-30 14:46

Once you configure an Oracle GoldenGate Microservices environment to be secure behind the Nginx reverse proxy, the next thing you have to do is tackle how to connect one environment to the other using the Distribution Server.  In using the Distribution Server, you will be creating what is called a Distribution Path. Distribution Paths are […]

The post Configure Distribution Service between two Secure GoldenGate Microservices Architectures appeared first on DBASolved.

Categories: DBA Blogs

Installing Nginx

Sat, 2019-12-28 22:03

With Oracle GoldenGate Microservices, you have the option of using a reverse proxy or not.  In reality, it is a best practice to install the recommended reverse proxy for the architecture.  The main benefit here is the security aspect of using it.  In Oracle GoldenGate Microservices, depending on the number of deployments you have per […]

The post Installing Nginx appeared first on DBASolved.

Categories: DBA Blogs

Identity wallets used by Oracle GoldenGate Microservices

Tue, 2019-12-24 13:54

Wallets, Wallets, and more wallets! … Wallets are used for a few different things within Oracle GoldenGate Microservices; identifying what wallet is being used by a service is simple if you know where to look.   The biggest usage of wallets within Oracle GoldenGate Microservices is to help secure the communication between the Distribution Service […]

The post Identity wallets used by Oracle GoldenGate Microservices appeared first on DBASolved.

Categories: DBA Blogs

Updating the trail file location for Oracle GoldenGate Microservices

Fri, 2019-12-13 09:21

When you first install Oracle GoldenGate Microservices, you may have taken the standard installation approach and all the configuration, logging and trail file information will reside in a standard directory structure.  This makes the architecture of your enviornment really easy.   Let’s say you want to identify what trail files are being used by the […]

The post Updating the trail file location for Oracle GoldenGate Microservices appeared first on DBASolved.

Categories: DBA Blogs

Updating parameter files from REST

Tue, 2019-12-10 10:12

One of the most important and time consuming things to do with Oracle GoldenGate is to build parameter files for the GoldenGate processes.  In the past, this required you to access GGSCI and run commands like: GGSCI> edit params <process group> After which, you then had to bounce the process group for the changes to […]

The post Updating parameter files from REST appeared first on DBASolved.

Categories: DBA Blogs

Installing Oracle GoldenGate Microservices – Part 2 of 2

Wed, 2019-11-20 14:32

In the my last post, I showed you how to install the binaries for Oracle GoldenGate Microservices.  Then at the end of the post, I mentioned that you will need to run Oracle GoldenGate Configuration Assistant to finish the configuration of Oracle GoldenGate Microservices.  Let’s take a look at how to do this. After installing […]

The post Installing Oracle GoldenGate Microservices – Part 2 of 2 appeared first on DBASolved.

Categories: DBA Blogs

Installing Oracle GoldenGate Microservices – Part 1 of 2

Wed, 2019-11-20 10:43

Recently I was exchanging emails with a few community members about Oracle GoldenGate Microservices.  One of them commented on that Oracle GoldenGate Microservices was difficult to install; at the time, I was puzzled.  The reason I was puzzled was due to the install process for Oracle GoldenGate hasn’t changed since Oracle GoldenGate 12.1 came out […]

The post Installing Oracle GoldenGate Microservices – Part 1 of 2 appeared first on DBASolved.

Categories: DBA Blogs

Oracle Database Views and Tables for Oracle GoldenGate

Fri, 2019-11-08 16:40

Oracle GoldenGate for Oracle over the last few releases have been moving towards an integrated architecture.  This means that there is more views and tables within the Oracle Database that support Oracle GoldenGate.  You can quickly find these views and tables by using a where clause with a filter for GoldenGate: select * from all_views […]

The post Oracle Database Views and Tables for Oracle GoldenGate appeared first on DBASolved.

Categories: DBA Blogs

Bridge network missing Gateway – Docker Issue

Sun, 2019-11-03 11:41

Here is a little something for you.  I’m working on building a demo of Oracle GoldenGate Microservices between three (3) containers. In order to do this, I wanted to setup a dedicated network between the containers. In order to setup a dedicated network, I needed to configure a network for the containers to use.  Docker […]

The post Bridge network missing Gateway – Docker Issue appeared first on DBASolved.

Categories: DBA Blogs

ServiceManager … as a daemon

Thu, 2019-10-24 15:34

In an earlier post on ServiceManager, I took a look at how you could start/stop the ServiceManager manually.  A lot of what was said in that post still applies to this post; however, in this one I’m going to take a look at how to review the ServiceManager when it is configured as a daemon […]

The post ServiceManager … as a daemon appeared first on DBASolved.

Categories: DBA Blogs

Where is my StreamAdmin account?

Wed, 2019-09-25 15:10

One of the huge benefits of Oracle GoldenGate Microservices is the security framework which comes standard when you install GoldenGate. As you setup the ServiceManager and first deployment, you are prompted to build an administration account. As a best practice we recommend that the account be named “oggdmin” with the password you define. Although it […]

The post Where is my StreamAdmin account? appeared first on DBASolved.

Categories: DBA Blogs

Understanding/Modifying Oracle GoldenGate Microservices Settings

Fri, 2019-09-20 10:40

Oracle GoldenGate Microservices provide a wide range of options from administration and security to enhance the replication setup and experience. The Microservices architecture makes interaction with Oracle GoldenGate much easier compared to the traditional Classic architecture. This architecture provides you with not one but four avenues to interact with GoldenGate to ensure replication is configured, […]

The post Understanding/Modifying Oracle GoldenGate Microservices Settings appeared first on DBASolved.

Categories: DBA Blogs

Improving URLs for Oracle GoldenGate Microservices using a Reverse Proxy

Fri, 2019-09-20 06:16

Oracle GoldenGate finally has a GUI/Web Page interface to work with the product. This has been a long over due and welcomed feature that was initally released with Oracle GoldenGate Microservices in 12.3. Since 12.3 and through 19.1, the Oracle GoldenGate team has been preaching the simplicity and securty benefits of using a reverse proxy […]

The post Improving URLs for Oracle GoldenGate Microservices using a Reverse Proxy appeared first on DBASolved.

Categories: DBA Blogs

Pages