It’s a Wrap – OUGN 2024
At OUGN 2024 I presented two sessions about multitenant in Oracle Database. If you missed me on stage, you can still find valuable information in the slides.
Show Me Your Upgrade Runbook and Let’s See What You Can Remove
It’s important to have a runbook when you perform maintenance activities like upgrades. But, what if you have too many items in your runbook? Extra work increases downtime and adds complexity.
I Need Patch 35836860. Is It in 19.21.0?
What is the easiest way to tell whether a Release Update contains a specific patch for Oracle Database?
My Query Performs Horrible, Fix It!
What if you could fix a performance problem by simply calling a procedure? Sounds pretty awesome, right? In Oracle Database 19.22.0 it’s possible.
Are Your Oracle Database Clients Ready for the next Database Upgrade?
A new release of Oracle Database might not allow your older clients to connect. While preparing for the upgrade, check you clients and upgrade in due time.
Real-World Database Upgrade and Migration 19c and 23c
Mike Dietrich and I are hosting two in-person full-day workshops in early May in Sweden and Denmark. All tech, no marketing!
Sign up before it’s too late.
Does Data Pump Export Advanced Data Optimization Policies and Heat Maps?
Advanced Data Optimization helps you control data in your database. Don’t lose the information when you move to a new database. Learn how Data Pump handles ADO information.
How to Detect and Repair Corruption in Your Oracle Database
A sleeping corruption may cause havoc during important maintenance operations, like upgrades and PDB conversions. Increase your chance of success with a dictionary check.
It’s a Wrap – Transportable Tablespaces to the Extreme
The next-generation procedure for cross-platform migration is out. Our deep-dive webinar gives a solid introduction. You can now watch the recording and slides – and take a look at all the questions and answers.
The Next-generation Cross-platform Migration for Oracle Database
Oracle just launched a new and improved method for cross-platform migrations. Get a sneak peek at the details and find out how you can learn more.
Kickstart Learning in 2024
Stay on top of things with these two new webinars on cross-platform migrations and Oracle Database 23c and the multitenant architecture. Sign up now!
How to Export and Import Statistics Faster Using DBMS_STATS in Parallel
You often use DBMS_STATS to transport statistics when you migrate Oracle Database. When time is of the essence here is a way to speed up the process.
Does Exporting Database Statistics Include the Dictionary Statistics?
You often transport statistics when you migrate databases. When you export database statistics, the documentation states all objects are included. What does “all objects” mean? Plus, a few words about transporting statistics.
How to Upgrade Encrypted Oracle Database and Move to New Server
When you upgrade Oracle Database you often want to move to a new server as well. AutoUpgrade supports this option – even for encrypted databases. Get the instructions and read about the little details.
How to Upgrade Oracle Database and Replace the Operating System
How do you upgrade your Oracle Database and replace the operating system at the same time? Which options are at your disposal?
What Happens to Your Oracle Data Guard During Conversion to Multitenant
Oracle Data Guard keeps your data safe. When you convert to the multitenant architecture, you must follow the correct process. Otherwise, you jeopardize your Data Guard configuration.
How to Fix ORA-14519 Conflicting Tablespace Blocksizes During Oracle Data Pump Import
In certain cases, you might have a partitioned table with a definition that Oracle does not support. If your import fails with ORA-14519, it might be the case. What can you do about it?
How Often Do You Patch Your Oracle Database Client?
To protect your Oracle Database, you must patch the database itself. But what about the database clients? Do you need to patch them as well?
How to Trace Oracle Data Pump
Data Pump is hanging! No, it’s not (probably). Here’s how to look underneath the hood.
It’s a Wrap – DOAG 2023 Conference + Exhibition
Slides and impressions from the DOAG 2023 conference in Nuremburg, Germany.
Data Pump and Parallel Transportable Jobs
In later versions of Oracle Database, you can supercharge your migration with transportable tablespaces by using parallel jobs in Data Pump. This gives a massive performance boost.
It’s a Wrap – UKOUG Conference ’23
A few impressions from the UKOUG Conference 2023 and the slides. Learn why you should always patch out-of-place and why it’s a bad idea running old databases.
How to Use Oracle Data Pump When You Have Common Objects
Common objects in multitenant is a great way of unifying your environments which you can use to your advantage. However, when you need to move your data around, if you depend on common objects, you need to pay attention.
Understand How a Change of Database Time Zone Affects Transportable Tablespaces
Take care with the target database timezone when you migrate with transportable tablespaces. The wrong choice might prolong the import unnecessarily.
How to Connect SQL Developer to a Base Database Service Using SSH Tunnel
SQL Developer is a great tool to interact with Oracle Database. If access to your Base Database Service in OCI is restricted, you can connect via an SSH tunnel.
Upgrade Base Database Cloud Service to Oracle Database 23c
Oracle released the latest version of Oracle Database in OCI recently. Here’s a cool and easy way to upgrade your PDBs.
Oracle Grid Infrastructure and Apache Tomcat
How do you ensure Apache Tomcat is up-to-date in your Oracle Grid Infrastructure? It’s easier than you might think.
Data Pump and Faster Export of SecureFile LOBs
With SecureFile LOBs you have the best chances to unload data fast from your Oracle Database. But there are a few things to be aware of.
Why Are You Not Using Bigfile Tablespaces?
Bigfile tablespaces offer some advantages. Previously, they could be cumbersome. But not anymore – or what do you think? Why don’t you use bigfile tablespaces? Leave a comment.
Applying Parallelism to Data Pump Exports and Imports
When you use Oracle Data Pump, you often want it to happen fast. Using parallelism is the obvious choice, and Data Pump makes it easier than you think.
How to Export Database Scheduler Jobs Using Data Pump
You can move schedule jobs with Data Pump and the metadata API (DBMS_METADATA). Here’s a few tips and tricks.
It’s a Wrap – Real World Database Upgrade and Migration to 19c and 23c
The slide deck is a goodie bag full of tech content. Plus, there are answers to some tricky questions – like how does SQL Plan Management behave on a standby database.
Data Pump and Faster Export of BasicFile LOBs
If you have BasicFile LOBs in your Oracle Database, you probably don’t get the performance you want during export. What’s the reason, and what can you do about it?
How to Migrate from Oracle v5 to Oracle Database 23c
Oracle maintains over 40 years of backward compatibility for the original import utility. You can migrate a database from Oracle v5 (1985) and directly into a PDB on Oracle Database 23c. Plus, a few fun facts about the old releases.
It’s a Wrap – Danish Oracle User Group Day
Get the slides, learn about the event, and a few pictures.
Things to Consider When Importing Advanced Queues using Oracle Data Pump
A common pitfall when migrating queues is that Oracle Data Pump does not start the queues during import. Why is that and are there other things to be aware of when importing Advanced Queues?
How to Upgrade to Oracle Database 19c and Migrate to a PDB Using Refreshable Clone PDBs
Upgrading and converting has never been easier than using AutoUpgrade. For best protection, you should copy the data files before the PDB conversion. Using Refreshable Clone PDBs you can do that with very little downtime.
Honey, I Shrunk the Database! Why Is My Database Smaller after Migration?
After migration with Data Pump my database is now much smaller. What went wrong? Did something actually go wrong?
It’s a Wrap – Oracle DatabaseWorld at CloudWorld 2023
Notes from Oracle DatabaseWorld at CloudWorld. Get the slides, try our new free hands-on labs and more
Can Data Pump Export to ASM Storage?
For a Data Pump benchmark, I had access to high-speed storage on ASM. Is it possible to export directly to ASM storage?
Is It Possible to Migrate SQL Plan Baselines Before You Migrate Data
You can save downtime during migration by moving SQL plan baselines ahead of time. But there is a catch about plan evolution.
Sign up for Our Sessions at Oracle DatabaseWorld at CloudWorld
The session catalog for Oracle DatabaseWorld at CloudWorld is ready. Sign up for sessions before they sell out.
How to Clone Oracle Grid Infrastructure Home Using Golden Images
If you need to install Oracle Grid Infrastructure in many environments, it is very beneficial to use golden images. Not only does it save you time and work, but it also ensures consistency across all your environments. In this blog post, you can learn how to use golden images for your Oracle Grid Infrastructure deployments.
How to Remove an Old Oracle Grid Infrastructure 19c Home
If you are patching your Oracle Grid Infrastructure 19c using out-of-place method, then you must also get rid of the old GI homes when they are no longer needed. For how long should you keep the old homes and how can you get rid of them?
How to Roll Back Oracle Grid Infrastructure 19c Using SwitchGridHome
To prepare for a contingency it is important to know and test your rollback plans. When you patch Oracle Grid Infrastructure, you should also familiarize yourself with the steps needed to rollback the patch
Files to Move During Oracle Grid Infrastructure Out-Of-Place Patching
I strongly recommend patching Oracle Grid Infrastructure using an out-of-place method. Are there any files in the Oracle Home that you must move to the new Oracle Home?
A Rare Insight Into the Oracle Database Development Process
Have you ever wondered why Oracle didn’t include your bug fix in the next Release Update? Or what good is it that your bug is fixed in 23.1 when Oracle Database isn’t released yet? We’ll explain this – and much more in our next webinar.
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.
Pro Tips
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.
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 Non-CDB or CDB
Upgrading an encrypted database is easy. You just need an auto-login keystore.
Loading…
Something went wrong. Please refresh the page and/or try again.
Databases Are Fun 