Remote Diagnostic Agent (RDA) is often under-utilized. It has some very nice features such as database preinstallation check. Remote Diagnostic Agent (RDA) – FAQ (Doc ID 330363.1) Remote Diagnostic Agent (RDA) – Getting Started (Doc ID 314422.1) Stay with me…Read More >
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…Read More >
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…Read More >
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…Read More >
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…Read More >
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…Read More >
Applying GRID INFRASTRUCTURE PATCH SET UPDATE 188.8.131.52.181016(Patch 28429134) for AIX (64-Bit) was a disaster for Oracle Restart environment, as described in a previous post. # $GRID_HOME/OPatch/opatch auto $GI_PSU -ocmrf /tmp/ocm.rsp patch /stage/psu/11g/GI/2018OCT/28429134/27735020/custom/server/27735020 apply successful for home /u01/app/oracle/product/11.2.0/db_1 patch /stage/psu/11g/GI/2018OCT/28429134/28204707 apply failed…Read More >
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…Read More >
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…Read More >
After applying Oracle GoldenGate V184.108.40.206.170919 for Oracle Database 12c OPTIMIZER Patch for Bug# 26849949, starting GoldenGate extract failed with OGG-00303: Unable to open credential store. Error code 43,490. Here is what the report looks like. $ head -50 E_LAX6.rpt ***********************************************************************…Read More >
© Copyright 2019 Pythian Group Inc. ® ALL RIGHTS RESERVED.
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.