DBASolved

Subscribe to  DBASolved feed  DBASolved
Updated: 14 hours 52 min ago

Speaking at HashiCorp User Group (HUG) Tampa – 6/30/2020 @ 6 pm

Thu, 2020-06-25 13:30

Since leaving Oracle, I’ve been trying to get back into the swing of things when it comes to talking on the conference circuit.  It didn’t help that this whole pandemic thing happened, but it is what it is.  So in an effort I’m starting out small again and looking to build from there.  A big […]

The post Speaking at HashiCorp User Group (HUG) Tampa – 6/30/2020 @ 6 pm appeared first on DBASolved.

Categories: DBA Blogs

Terraforming your way to an Autonomous Database

Thu, 2020-06-25 12:58

Oracle Cloud Infrastructure (OCI) is a good platform for many things including building enterprise grade databases on.  Over the last few years, Oracle has been promoting the Oracle Autonomous Database (ADB) quite extensively and how to build them on OCI.  The way that Oracle builds it within the OCI framework is simply through the console […]

The post Terraforming your way to an Autonomous Database appeared first on DBASolved.

Categories: DBA Blogs

Moving Terraform State file to OCI Object Store

Sat, 2020-06-20 23:06

When developing with Terraform it is nice to keep everything local on your laptop. Makes for great ease of development; there are time when you want to share your environment, i.e. state file, with others in your development organization.  In order to do this, the state file has to be moved to a common area. […]

The post Moving Terraform State file to OCI Object Store appeared first on DBASolved.

Categories: DBA Blogs

Building OCI Compute Nodes via Code

Fri, 2020-06-19 16:32

Over the last couple of posts, we’ve been showing how to use the OCI provider and upgrading the associated OCI modules.  In this post, we’ll show you how to use the OCI modules that were upgraded to build OCI compute node(s) through code.  The node(s) that will be built are just standard Oracle Linux 7.8 […]

The post Building OCI Compute Nodes via Code appeared first on DBASolved.

Categories: DBA Blogs

Upgrading OCI Modules for Terraform

Mon, 2020-06-15 11:27

Automation is all the rage now; yet I’ve though automation has been the key to a lot of improvements over the years.  Part of any automation process is to make the process simple to use and repeatable.  When you start looking at cloud platforms the first thing that sticks out to you is all the […]

The post Upgrading OCI Modules for Terraform appeared first on DBASolved.

Categories: DBA Blogs

Setting up OCI Terraform Provider

Fri, 2020-06-12 11:24

Over the last few months, I’ve been working to convert my skills from a core DBA/Replication specialist into a from dynamic DevOps persona.  Part of this is looking at all of the cloud providers out there and getting an understanding of what is going on and how to maximize interaction with each of these platforms. […]

The post Setting up OCI Terraform Provider appeared first on DBASolved.

Categories: DBA Blogs

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

Pages