There are many ways to upgrade your database to 23ai. You can use the OCI Console, OCI command-line tools, and AutoUpgrade. Why should I use AutoUpgrade? In this post, I will cover the Refreshable Clone PDBs. One thing to point out is you can use the same steps if you are on Oracle Exadata Database…
CPAT Checks – Cloud Premigration Advisor Tool – Part 5
CPAT currently includes more than 80 possible checks. Purpose: Identify issues that may interfere with the migration of the source database to the target. Each CPAT Check: The results of Checks are Listed from Most Serious to Least Serious. Action Required means there’s a significant chance that something from the source database will not be…
Plugin an On-premises PDB without TDE into a CDB running in the Oracle Base Database Service
I was assisting a customer with migrating a PDB from on-premises to OCI. The source database did not have TDE configured. After plugging the PDB into the OCI CDB, the customer encountered some TDE issues. I created the following test to replicate the steps. First, I’ll create a new on-premises PDB without TDE enabled: Let’s…
A Year of Transformation: Finding Balance, Health and Happiness at Oracle
One Year at Oracle: A Life Transformed A year ago, I joined Oracle after several intense years as a consultant. Looking back, this decision has brought about transformative changes in my personal and professional life. I’m excited to share this journey, reflecting on the differences Oracle has made and what a difference a supportive company…
AutoUpgrade Patching – Minimize Patching Downtime
In this blog post, we will discuss how to minimize patching downtime in Oracle Database environments using AutoUpgrade Patching. AutoUpgrade Patching is a new enhanced capability of AutoUpgrade that automates all of the necessary steps in the database patching process, including optional downloading. AutoUpgrade Patching will create a brand new target ORACLE_HOME using a base…
Troubleshooting CPAT – Cloud Premigration Advisor Tool – Part 4
Humans create software, and as such, it is inherently imperfect. Programmers work diligently to write code to perform complex tasks, solve problems, and make processes easier. However, mistakes or unforeseen issues can arise despite their best efforts, leading to software bugs or glitches. If you encounter any issues with CPAT, first verify that you’re using…
Running CPAT – Cloud Premigration Advisor Tool – Part 3
Gather target properties – Fetch Target Instance Properties for Use in Source Instance Analysis If the target environment already exists, a helpful approach is to create a properties file from the target database and utilize it to make a more precise evaluation of the source database. CPAT will consider the actual values of specific attributes,…
INS-08101 – Unexpected error while executing the action at state: ‘supportedOSCheck’
We got an email from a customer who was trying to install a new 19c Oracle Home with 19.25 DB RU applied and he was getting the error INS-08101. I gave it a try and found the same issue: An easy solution found by the customer was setting the environment variable CV_ASSUME_DISTID. I did more…
Options for Running CPAT – Cloud Premigration Advisor Tool – Part 2
The CPAT can be executed directly on the database server or from another machine using a remote connection. CPAT connects to your database using JDBC and accepts standard Oracle JDBC format connection strings. This means that both the “thick” and “thin” Oracle JDBC drivers can be used. Example of local connection with SYSDBA (remember to set…
Starting with CPAT – Cloud Premigration Advisor Tool – Part 1
I’m starting a blog post series about CPAT (Cloud Premigration Advisor Tool). In this series, I’m also planning to cover it for beginners and advanced users. What is CPAT? CPAT is a Java-based command line tool that evaluates a source database for suitability of migration to a cloud target. You can use CPAT to gather…