When implementing GoldeGate solutions, something as simple as path to trail files can create havoc. What is the correct path for trail format? It depends. There is one important factor to consider. You can change any of the attributes specified…

I am currently working on a project to install Oracle Enterprise Manager Cloud Control Release 13.3 and was looking for a more simplified method to create a 12.2 database with all the required components. I was excited to find: Creating a…

Working with a secure environment presents some challenges and this post will demonstrate how to overcome one of the challenges. Prerequisites: Configuration for X-Windows must have been completed. Scenario: From laptop, connect to dinh@host, then connect to ssh ec2-user, then…

It’s feasible to delete agents and targets using GUI but can take a lot of work depending on configuration and security. Some of the complexities involve port forwarding and access to web browser which is not always available or simple…

There are many automation tools available and what I am about to share doesn’t require any. Currently, I am patching Oracle July 2018 for AIX and October 2018 for Linux. The steps are the same and only the patch number…

When is the best time to apply an Oracle quarterly patch? I suppose the answer is, “It depends.” As it turns out, we started to apply October 2018 Grid Infrastructure PSU for AIX the day after it was released and…

From my experience, the one area where a DBA cannot afford to make errors is in database backup. When was the last time database backup was tested? Was it successful? How often is backup tested? Is testing automated? I was…

PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.