Tag: Oracle

Simplify Oracle Critical Patch Updates Using Simple Configurations

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 >

Solving An Uncommon Oracle Error Code – ORA-01041

So, here is the thing. We have a customer running a 11.2 Single Instance Oracle database on Windows. I know the version is a bit old and Windows may not be the most common choice to run an Oracle database,…

Read More >

Recovering From Quarterly PSU Patching Disaster

Applying GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.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 >

The Best Times to Apply Oracle Quarterly Patches

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 >

How Do You Test Your Oracle Database Backup?

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 >

Troubleshooting a GoldenGate Error Code

After applying Oracle GoldenGate V12.2.0.1.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 >

Troubleshooting a Datapatch Error in Oracle

As part of patching preparation, the following command was executed and failed: Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/db Following step failed during analysis: /bin/sh -c ‘cd /u01/app/oracle/product/12.1.0/db; ORACLE_HOME=/u01/app/oracle/product/12.1.0/db ORACLE_SID=cdb /u01/app/oracle/product/12.1.0/db/OPatch/datapatch -prereq -verbose’ Let’s run datapatch -prereq -verbose manually. $ORACLE_HOME/OPatch/datapatch…

Read More >

Oracle Parallel Query Hints Reference – Part 7: PQ_DISTRIBUTE and Partitioned Tables

In Part 1 of the series, we covered in detail how the PQ_DISTRIBUTE can change the data distribution method across parallel query workers and the importance of avoiding BUFFERED hash joins. Through the remaining parts of the series, I showed…

Read More >

First Time Presenter, What a Feeling!

It’s been a couple weeks now, and the dust has settled but not the sentiment. I am talking about my very first public presentation performed at Spain Oracle Users Group (SPOUG) during the Technical SPOUG Day 2018 on September 25th….

Read More >

Log Buffer #555: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Cloud, Oracle and MySQL. Cloud: Cloud Directory is a neglected serverless data store that deserves much more attention. Many of our large enterprise customers have this worry hanging over their heads … what are they…

Read More >
Page 1 of 15312345...10...Last Page »