How to Apply Patches Out-of-place to Oracle Grid Infrastructure and Oracle Data Guard Using Standby-First
Step-by-step instructions on how to patch your single instance Oracle Database and Grid Infrastructure using Standby-First Patch Apply to minimize downtime.
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.
Understand Why Data Pump Produce ORA-39218 or ORA-39216 on Evolved Types
Transportable tablespace is an excellent way of migrating your data. If you are using object types, be aware of type evolution. Data Pump might be unable to replay the type evolution, which can lead to errors. Here are your options.
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.
While writing the blog post series I lot of nuggets came up. I gathered the best pro tips in this blog post.
Which Method Should I Choose When Patching Oracle Grid Infrastructure 19c
There are many ways to patch Oracle Grid Infrastructure. Which method is the best? It depends on a number of things. Read about the pros and cons.
My Best Advice on Patching Oracle Grid Infrastructure
Mr. RAC himself, Anil Nair, shares his top tips for patching success.
How to Patch Oracle Grid Infrastructure 19c Using Zero Downtime Oracle Grid Infrastructure Patching
Are you curious about how you can avoid downtime when you patch Oracle Grid Infrastructure? You can use these step-by-step instructions to patch your stack with no downtime.
A Word about Zero Downtime Oracle Grid Infrastructure Patching
ZDOGIP is a cool feature but it is also slightly more complicated. Here’s answers to some of the questions together with a brief explanation of the feature.
Why You Need to Use Oracle Fleet Patching and Provisioning
FPP is a great tool that can help you with lifecycle activities. It does patching and so much more. Learn about the benefits and how to get started.
What to Do about RMAN Recovery Catalog When You Upgrade Oracle Database
Take care of your Recovery Catalog when you upgrade. Also, ensure to upgrade your catalog database at one point in time.
Use Cluster Verification Utility (cluvfy) and Avoid Surprises
It is a good idea to use CVU to check your environment before and after patching Grid Infrastruture. Learn how to get the newest version of CVU and how to use it.
How to Avoid Interruptions When You Patch Oracle Grid Infrastructure 19c
You can patch your Grid Infrastructure in a rolling manner without downtime. With a few changes you can hide the outage completely from your application.
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.
How to Patch Oracle Grid Infrastructure 19c Using Out-Of-Place OPatchAuto
Step-by-step instructions on how to patch Oracle Grid Infrastructure 19c on a 2-node Oracle RAC system. I am using the out-of-place method and opatchauto.
How to Patch Oracle Grid Infrastructure 19c Using In-Place OPatchAuto
Step-by-step instructions on how to patch Oracle Grid Infrastructure 19c on a 2-node Oracle RAC system
How to Patch Oracle Grid Infrastructure 19c Using Out-Of-Place SwitchGridHome
Step-by-step instructions on how to patch Oracle Grid Infrastructure 19c on a 2-node Oracle RAC system
Upgrading with Oracle Database Vault – AIOUG Follow-up
Here’s what to know when you upgrade your Oracle Database that uses Oracle Database Vault.
Patching Oracle Grid Infrastructure 19c – Beginner’s Guide
Learn the basic about patching Oracle Grid Infrastructure. How do you apply patches and what impact does it have on the Oracle Databases managed by Oracle Grid Infrastructure
How to Migrate to Autonomous Database Using Database Migration Service and OCI CLI
You can migrate Oracle Databases to OCI using Database Migration Service. It’s simple and easy. If you have many databases to migrate consider using one of the many interfaces like OCI CLI.
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.
Oracle Data Pump and Compression – Also Without a License
Oracle Data Pump compression is convenient way of saving disk space and transferring files quicker. There are also options for those without Advanced Compression Option.
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.
Installing Oracle Database 19c and All the Things to Put on Top
When patching or upgrading to Oracle Database 19c, you can use this blog post to get a good overview of which patches to apply.
Upgrade, Data Guard and Downtime
Does Data Guard add more downtime to an upgrade? Can you do anything to make it lower?
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 – Standby Offline Method
If you want maximum protection during an Oracle Database upgrade with Data Guard, you should use the “standby offline” approach. Here’s how to do it.
Changing COMPATIBLE Parameter and Data Guard
How do you raise COMPATIBLE in a Data Guard configuration? Are there things to consider? What is the procedure? Find all the answers here.
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.
Upgrade of Time Zone File and Flashback Database
You should always have a fallback plan. If you need to upgrade the time zone file, can you rely on Flashback Database?
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.
If Importing Statistics Using DBMS_STATS Is Slow
Working with a customer learned us about the importance of gathering statistics as part of a migration.
Do I Need To Disable the Scheduler During Upgrade?
No, you don’t. But it might be a good idea.
Transparent Data Encryption and Multitenant
In a CDB the encryption keys goes into a united keystore. You can now isolate the PDBs even more by using a separate keystore for each PDB.
AutoUpgrade and Secure External Password Store Enables Complete Automation
Avoid typing TDE keystore password at all! Secure External Password Store and AutoUpgrade in combination enables complete automation of your Oracle Database upgrade and PDB conversion.
Upgrading an Encrypted Non-CDB and Converting To PDB
AutoUpgrade can automate the entire upgrade and PDB conversion process. With just one command.
Upgrading an Encrypted PDB
Latest version of AutoUpgrade now enables you to upgrade encrypted PDBs.
Upgrading an Encrypted Non-CDB or CDB
Upgrading an encrypted database is easy. You just need an auto-login keystore.
AutoUpgrade and Transparent Data Encryption (TDE)
Introduction blog post on how to use AutoUpgrade on encrypted databases.
XTTS: Full Transportable Export/Import
Get the know the details of Full Transportable Export/Import. What is included, and what is not included.
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: ASM Aliases and Why You Should Get Rid of Them
ASM aliases are very useful during the migration. But it is highly recommended to get rid of the aliases immediately after the migration.
XTTS: Testing the Procedure Multiple Times Using Read-Only Tablespaces
You can perform multiple tests of migrations using transportable tablespaces. If you keep the tablespaces in read-only mode, you can avoid restoring the data files every time.
XTTS: Testing the Procedure On Activated Standby Database
You should test your migration procedure. You can do that without interrupting your primary database by using a temporarily activated standby database.
XTTS: Target Database and Data Guard
Ensure that your target database is protected by Data Guard as soon as the migration completes.
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.
XTTS: Slow Network Between Source and Target
When migrating a database to a host over a slow network, it might pay off to compress the backup files.
What Is a Self-contained Transportable Tablespace Set
To use transportable tablespaces you must have a set of self-contained tablespaces. What does self-contained mean and what happens when you try to export anyway?
Rolling Upgrades of Oracle Database on Exadata Cloud Service
Upgrade your Oracle Database on ExaCS with very little downtime using DBMS_ROLLING
Get Started with Autoupgrade
Get started with AutoUpgrade and learn how to use our Hands-On Lab to sharpen your skills.
I Never Meet Joel, But I Have Met His Spirit #JoelKallmanDay
New Webinars Coming Your Way
We are planning more webinars filled with great tech content. Sign up before your colleague.
Zero Downtime Migration – Logical Offline Migration How To Minimize Downtime
Logical offline approach requires downtime. Here is a few tricks to make the downtime as short as possible.
How To Upgrade An Encrypted Oracle Database and Convert to PDB
Your encrypted Oracle Database can now be upgraded and converted to a PDB using AutoUpgrade
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.
Zero Downtime Migration – Logical Migration and Statistics
Logical Migration does not transfer your optimizer statistics. It is crucial that you get statistics into your target database before starting production
Zero Downtime Migration – Logical Online Migration and Testing
Be sure to test your OCI database before going live. With Logical Online migration you have several options with Flashback Database being the preferred option.
Zero Downtime Migration – Physical Online Migration of Very Large Databases
Like huge container ships need a pilot, your huge database might also need a helping hand to navigate successfully to OCI using physical online migration in ZDM.
Zero Downtime Migration – Logical Online Migration of Very Large Databases
Migrating very large databases using ZDM and the logical online method might require special considerations. This post discusses the crucial aspects of migrating with Data Pump and Oracle GoldenGate.
Zero Downtime Migration – Physical Online Migration and Testing
One of the really cool features of ZDM is that you can use a standby database for testing in OCI – before you decide to do the switchover.
Zero Downtime Migration – Physical Online Migration to ExaCS
It is also easy to migrate to ExaCS. But there are a few other things to be aware of. This post will give you a head start on your ExaCS migration.
Zero Downtime Migration – Physical Online Migration to DBCS
Learn how to migrate a database to OCI using Zero Downtime Migration. This procedure uses the physical online method to migrate using Data Guard.
Zero Downtime Migration – Physical Online Migration
Get to know the pros and cons of using the physical online method in ZDM. This method uses Data Guard to migrate your database to OCI.
Zero Downtime Migration – Logical Migration and the Final Touches
These extra tasks will help you avoid any performance issues after the migration. If a problem arise anyway, you are better off if you followed these recommendations.
Zero Downtime Migration – Logical Online Migration to DBCS
Step-by-step instructions on how to migrate your database into OCI using Data Pump and GoldenGate.
Zero Downtime Migration – Logical Offline Migration to Autonomous Database
Step-by-step instructions on how to migrate your data into an Autonomous Database using ZDM and the “logical offline” method.
Zero Downtime Migration – Monitor GoldenGate Replication
When migrating with Oracle GoldenGate you can easily use the console to monitor the replication and resolve errors
Zero Downtime Migration – Logical Online Migration
You can migrate into OCI with very little downtime using the Logical Online method. It uses a combination of Data Pump and Oracle GoldenGate.
Zero Downtime Migration – Create GoldenGate Hub
To migrate an Oracle Database with ZDM using the Logical Online method, you need an Oracle GoldenGate Hub. It is easily deployed from the OCI marketplace.
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.
Performance Stability after Upgrade and Migration
Slides from talk to Danish Oracle User Group.
Upgrade Internals – Webinar
Here is a sneak peek into our upcoming webinar.
Control Upgrade Parallelism In AutoUpgrade
AutoUpgrade allows you to fine-tune the parallel options of a database upgrade.
Follow-up On Cool Features Webinar – Jan 2021
Follow-up on our Cool Features webinar with answers to the questions that we couldn’t answer live. Thanks for attending.
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.
How to Upgrade with AutoUpgrade and Data Guard
It is easier to upgrade a Data Guard setup when using AutoUpgrade.
Upgrading in the Cloud – VM DB Systems – Automated Upgrade to 19c – The Details
Learn all the details about the automated upgrade in OCI. In addition, you can find answers to the most common questions.
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.
Something went wrong. Please refresh the page and/or try again.