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…

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…

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,…

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…

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…

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…

I’d like to thank our customers, partners, and colleagues for a great Oracle Cloud World. It was an intense week of learning and experience sharing. Slides Hands-On Labs Some pictures I want to give a big thanks to my team: Mike, Rodrigo, and Daniel. The content we deliver is truly a collaborative effort. I hope…

Oracle Cloud World 2024 is just around the corner in sunny Las Vegas. Fortunately, the hotel and conference areas are fully air-conditioned, so you can stay cool while attending our sessions and labs. Here’s why we’re excited for you to join us at OCW24: Upgrade, Migrations, and Patching to Oracle Database 23ai sessions, hands-on labs,…

Are you thinking about attending Oracle DatabaseWorld at CloudWorld, or have you already booked your ticket? Either way, here’s a fantastic opportunity for you. Optimizing Oracle Database 23ai Multitenant Upgrade Enroll here for the price of $795. This is the agenda that we’ve prepared for you. It’s 8 hours of intense training. Once you complete this training,…

If you haven’t registered yet, please do it now. Thursday, June 27, 2024, you can watch the Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2. If you missed part 1, you can watch it here.