Blog


Files to Move During Oracle Database Out-Of-Place Patching

I strongly recommend using out-of-place patching. When doing so, you must move all the database configuration files to the new Oracle Home. But how many configuration files are there? Can you make it easier for yourself by moving files outside of the Oracle Home?

Release and Patching Strategies for Oracle Database 23c

Our recent webinar contains everything you need to know about release and patching strategies for 19c and 23c. The recording is now only and there is also an updated slide deck. Because we received so many good questions, we decided to make an updated version of the slide deck which should answer all the questions,…

Did You Sign Up For Oracle CloudWorld Yet?

We are working really hard to prepare of lot of new content for you. I am very excited about the sessions and labs that we have in our pipeline. You should book your ticket to Oracle CloudWorld to ensure you are not missing out. Read more about the event and how you can convince your…

Is Oracle Java Virtual Machine (OJVM) Used In My Database?

Oracle Java Virtual Machine allows you to execute Java code directly in the database. This offers some amazing benefits. However, if it is not in use, you can speed up patching and upgrading by removing it. But how do you know whether it is in use?

Why Does Data Pump Need a Read Write Tablespace

Data Pump relies on a control table to keep track of an export or import job. The control table must be written to the database, which means that you can’t use Data Pump in certain situations. What can you do about it?

How to use Transportable Tablespace with TDE Tablespace Encryption

Transportable Tablespace is a good way of migrating data to another database. If the tablespace is encrypted using TDE Tablespace Encryption there are some additional tasks that must be executed. In some situations, transportable tablespace will not work for encrypted tablespaces.

How to Clone Oracle Home Without Using Clone.pl

Clone.pl is a convenient way of cloning Oracle Homes. However, in recent versions of Oracle Database it is deprecated. In this post, you can read how to clone Oracle Homes using fully supported functionality. Plus a few pro tips to make cloning even more useful.

Why Does User ID Columns Change Data Type When You Recreate a Queue Table

Advanced Queueing has evolved over time but offers backward compatibility using a dedicated parameter. Depending on the compatible setting the underlying AQ objects might change. Is this something to worry about? Also, learn how to migrate your old queue tables to use the latest AQ functionality.

Data Pump and a Norwegian Sneak Peek

Our popular Data Pump webinar is now available on demand. I’ll tell you my favorite moments or you can just dive right into the individual topics.

How to Apply Compression During Data Pump Import

When you migrate data using Data Pump it is a good opportunity to transform your data and apply compression. Oracle Database offers many good compression options and you can easily enable them during import.

Oracle Data Pump and BFILEs

BFILEs or external LOBs allow you to store data outside the database. The data is stored in the operating system. What exactly is a BFILE and what do you need to be aware of when you want to export the data?

Patching Oracle Grid Infrastructure And Oracle Data Guard

Often, when you have RAC, you also have Data Guard. What must you know when patching Grid Infrastructure when Data Guard is present? How can you apply patches to Grid Infrastructure and the database when Data Guard is present? This blog post answers these questions.

Pro Tips

While writing the blog post series I lot of nuggets came up. I gathered the best pro tips in this blog post.

New Webinars Coming Up

Dates are settled for the next two webinars. Sign up now to get the latest updates on Data Pump and Release and Patching Strategy for Oracle Database 23c.

Oracle CloudWorld 2022 On-Demand

Get the very last out of Oracle CloudWorld 2022 by watching some of the recordings. You can find some really great sessions available on demand. All available for free on YouTube.

Can I Run Datapatch When Users Are Connected

To complete a patch apply you must execute datapatch. You can execute datapatch on a running database with users connected. But beware of the pitfalls.

Upgrade, Data Guard, and Restore Points

When you upgrade your Oracle Database, Flashback Database is an excellent fallback mechanism. It works fine in a Data Guard configuration as longs as you follow the right procedure.

How To Upgrade Data Guard – MAA Method

It is not that complicated to upgrade your database, even if it is part of a Data Guard setup. Using AutoUpgrade is fully supported and highly recommended. A little extra legwork is needed to take care of the standby database. But the good thing is that your Data Guard setup is maintained throughout the process.

Downgrade and Data Guard

If you experience problems with a new release of Oracle Database after go-live – downgrade might be the answer. Data Guard and downgrade works fine together if you follow the right procedure. Here’s how to do it.

Flashback and Data Guard

If you need to fallback a failed upgrade, you can use Flashback Database. You can even do it without compromising your Data Guard if you follow the procedure.

Upgrade and Data Guard

You can upgrade your Oracle Database to a new release and keep the Data Guard setup intact. There is no need to rebuild the standby database after the upgrade.

Why Does It Take so Long to Import Check Constraints?

When Data Pump creates constraints during import, they will be created in the same way as they were exported. Validated constraints must be validated again which can take quite some time.

XTTS: Prerequisites

The easiest way to migrate with XTTS is to use version 4 of the Perl script and Full Transportable Export Import. Can you meet the requirements?

XTTS: Pro Tips

A collection of nuggets that I gathered while writing the blog post series on XTTS.

XTTS: Make It Fast

To make your migration with transportable tablespace faster, there are a few knobs you can turn.

XTTS: Bigfile Tablespaces

Bigfile tablespaces are often used in very large databases. Do they have an impact on your migration with transportable tablespaces and incremental backups?

XTTS: Backup on Standby Database

Offload the backups from the primary database when doing cross platform migrations with transportable tablespaces and incremental backups.

Get Started with Autoupgrade

Get started with AutoUpgrade and learn how to use our Hands-On Lab to sharpen your skills.

Oracle Database 21c Is Here

Oracle Database 21c is now available on more platforms. Here’s my take on it.

Upgrade with Less Downtime

If your database is sensitive to downtime, you can use the fast deploy mode to run some tasks while the database is still online.

DataPump Export from Data Guard

To save resources on your primary database when doing Data Pump exports and to avoid ORA-01555, you can use a snapshot standby database.

Future-proof Your Encrypted Database During Upgrade

When you upgrade an encrypted database to Oracle Database 19c you configure AutoUpgrade to change the keystore definition from sqlnet.ora to the new recommended parameter – WALLET_ROOT.

AutoUpgrade One-liner

You can specify all input to AutoUpgrade in a single command – without using a config file. Ideal for scripting and automation.

How to Upgrade a Single PDB

You can use AutoUpgrade to perform unplug-plug upgrade of your PDB. It is faster, but there are some things you must be aware of.

New Version of AutoUpgrade

A new of AutoUpgrade is out and it contains several cool features like unplug/plug upgrade and better handling of data guard.

Loading…

Something went wrong. Please refresh the page and/or try again.