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 ...

Oracle E-Business Suite Database Upgrade to 19c

Oracle E-Business Suite has been certified with Oracle Database 19c for over a year now. We've been seeing an uptick in ...

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 ...

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 ...

Oracle Database and 2FA Using Cisco Duo

Background Oracle Database connectivity using multi-factor (MFA) or two-factor (2FA) authentication is rather simple to ...

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 ...

Testing the 19c Grid Infrastructure by Performing a Dry-Run Upgrade

Testing oracle grid infrastructure upgrades Editor’s Note: Because our bloggers have lots of useful tips, every now and ...

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 ...

Save Time With This Quick OCI CLI Installation

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

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: ...

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 ...

Create 19c Database in Archive Mode Using DBCA Silent

I wanted to export 11.2 database schema and import it into a 19c database; creating the database in archive mode to ...

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 ...

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 ...

Migrating Oracle Workloads to Google Cloud - BMS

In these challenging and ever-changing times, most organizations would welcome the opportunity to reduce overhead, ...

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 ...