Silent Rollback From an Out-of-Place Patching For Oracle 19c GI

My last post dealt with -->

My last post dealt with how to do an out-of-place patching for Oracle GI (Grid Infrastructure). The next thing I wanted ...

OPatchAuto Bug on 19.3 GI/RDBMS When Patching to 19.6

Background

The other day I was doing a fresh install of Oracle 19.3. I ...

Background The other day I was doing a fresh install of Oracle 19.3. I was using the binaries from edelivery, doing ...

Oracle RAC: Network Performance with Jumbo Frames

Introduction When working with Oracle RAC, it's strongly advised to use Jumbo Frames for the network that provides the ...

Mining Statspack and AWR Repositories for Historical Trends

There are various ways that we can approach the analysis of a past database performance problem. The initial steps ...

Resolving Error ORA-28353: Failed to Open Wallet

Troubleshooting TDE wallet failures after october 2018 patching

Full ...

Troubleshooting TDE wallet failures after october 2018 patching Full disclosure: this is a post I've had in draft mode ...

Overcoming ORA-01722 Error While Doing an Upgrade With Different DST Versions

This will be a short entry, but hopefully, it will help if you face the error "ORA-01722: ...

This will be a short entry, but hopefully, it will help if you face the error "ORA-01722: invalid number" while doing ...

Trace on Standby: Tracing MRP Process

Sounds simple, right? And it really is, although it might not seem obvious. Recently, I ran into an issue when trying ...

Silent Out-of-Place Patching For Oracle 19c GI

Troubleshooting OCI automatic backups

I am going through a process of ...

Troubleshooting OCI automatic backups I am going through a process of patching an Oracle Grid Infrastructure (GI) from ...

TNS-12564 Errors and the Importance of LOCAL_LISTENER During a Data Guard Switchover

A couple of weeks ago a client of mine had a situation where a Data Guard (DG) ...

A couple of weeks ago a client of mine had a situation where a Data Guard (DG) switchover that should have taken five ...

How I Finished a Recovery From an Active Duplicate After Facing Errors ORA-19909 and ORA-01110

The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, ...

The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, and got the following error: ...

19c Auto-Indexing: ORA-65532: Cannot Alter or Drop Automatically Created Indexes

It’s one of those classic "Oracle knows best" moments, isn't it? You try to take back control of your own schema, and ...

Datapatch Failing on ORA-65108 (PDB$SEED): Applying Datapatch Manually

Problem In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on ...

Installing OCI Command Line Utilities in Linux and Windows

As part of a recent project, I installed the Oracle Cloud command line utilities (oci) on the following Linux systems:

Issues With Database Service Names Starting With Pluggable Database (PDB) Name

In this post I'll describe a problem which occurs when creating and using a database service name which starts with the ...

CreateGoldImage Followup - Is CreateGoldImage Required for Cloning Oracle Home?

Comparing CreateGoldImage and Traditional Tar Cloning On October 31, 2019, I blogged about How To Use CreateGoldImage ...

Heart Disease Prediction Using Keras Deep Learning

Heart disease covers a range of different conditions that could affect your heart. It is one of the most complex ...

Converting Oracle Enterprise Manager Management Service (OMS) Repository from Legacy Non-CDB to CDB Architecture

The other day I was given the task of converting a single instance Oracle ...

The other day I was given the task of converting a single instance Oracle Enterprise Manager Management Service (OMS) ...

Management and Troubleshooting Features: Data Guard Command-Line Interface (DGMGRL) 19c

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it's ...

Exadata's InfiniBand Switch: Incorrect NTP settings Leading to Evictions, and Patching Recommendations

Overview This post describes a recent outage during a routine Exadata (X7-2) patching to the 19.2.12.0.0.200317 release ...

AWS RDS: 5 Must-Know Actions for Oracle DBAs

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS:

IPv6 Formatting for JDBC and SQLPlus

Does IPv6 formatting for JDBC and SQLPlus seem new to you well, it's been available since 11gR2. You're familiar with ...

Automatic Flashback Of Standby Database in Oracle 19c

Oracle 19c Data Guard introduced a very cool feature — you can now automatically ...

Oracle 19c Data Guard introduced a very cool feature — you can now automatically flashback your standby if you ...

EM 13c: Patching Oracle Enterprise Manager With Release 4 Update 6 (13.4.0.6)

This week I had the opportunity to patch Oracle Enterprise Manager (EM) 13c with ...

This week I had the opportunity to patch Oracle Enterprise Manager (EM) 13c with Release 4, Update 6: RU6 (13.4.0.6). I ...

How to Fix the Status of the Oracle GI CRS After a Failed Upgrade

Editor's Note: Because our bloggers have lots of useful tips, every now and then we update ...