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 >

Taking Your Hybrid Cloud From Automation to Orchestration

Cloud computing has been accessible to enterprise for a little over a decade, and that milestone is significant. It’s fitting to think of the cloud as a technology that’s approaching its adolescence. Though it’s awkward and a challenge to understand…

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 >

Look Sharp: An Introduction to Edge Computing

For years, data consumption was associated with individuals: people who stream videos, play games and otherwise live life with the help of the internet. But even though the average user’s daily data consumption is expected to increase to 1.5 gigabytes…

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 >

How to Get Cloud Analytics Costs Under Control

Big data analytics can potentially cost big money. But being reactive instead of proactive about optimizing your analytics in the cloud can, unfortunately, cost you even more money. This may sound obvious, but making the right decisions when configuring your…

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 >

The Latest Azure SQL Features in GA

I recently joined Chris Presley for his podcast, Cloudscape, to talk about what’s happening in the world of cloud-related matters. I shared the most recent events surrounding Microsoft Azure. Topics of discussion included: Ethereum Proof-of-Authority on Azure Azure Cost Forecast…

Read More >
Page 4 of 334« First Page...23456...10...Last Page »