Hi, A new version (24.1.0) of CPAT is available for download! What is CPAT? CPAT (Cloud Pre-migration Advisor Tool) is a Java-based command line tool that evaluates a source database for migration. At a high level, CPAT:1 – Connects to a source database instance – The source can be on-premises or in the cloud –…

Hi, I was helping a customer who needed to migrate an AWS RDS Oracle Database (15TB) to OCI having a few minutes of downtime. Due to some restrictions, they cannot use Oracle Golden Gate. A good option is to use the RMAN incremental backups as described in these blog posts: https://blogs.oracle.com/maa/post/migrating-rman-backups-from-s3-to-oci-osb-cloud-module-for-aws-s3-to-db-cloud-backup-module-for-oci https://blogs.oracle.com/maa/post/physical-migration-of-an-aws-rds-oracle-database-to-oracle-cloud-infrastructure-via-rman-backup-and-restore Just change the…

Hi, The CPAT Development team created a great F.A.Q. and I’d like to share it with CPAT users. What are the various approaches to running CPAT? Does running CPAT require altering your database?  Does CPAT write to your database? What privileges does CPAT require? Does CPAT connect to the internet? How does the checks run by CPAT compare to Oracle Estate Explorer? What versions of Java…

Hi, I’m doing some import tests to an Autonomous Database Serverless and I have a few things to share. Usually, people use the dump files in an Object Storage, but you can also use it on an FSS. The recommendation on the documentation is to use the Service High and .25 ECPU per parallel: https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/load-data-data-pump.html#GUID-30DB1EEA-DB45-49EA-9E97-DF49A9968E24…

Hi, I’ve never been a big fan of using the System user to perform database exports and today I found another good reason not to use it. I was investigating some slowness during an export phase. The default tablespace for the user System is the system tablespace which is not ASSM. Getting the DDL for…

I was analyzing one export taking longer and one big table was not using the Direct Path mode. I tried to export only this table and set the access method using the expdp parameter “ACCESS_METHOD=DIRECT_PATH”. This table was created using Lower case and I struggled for a few minutes to find the right syntax 🙂…

Hi, In the Multitenant architecture, it’s common to have some components installed on the CDB but not installed on the PDB. But for Database Vault, you can have some issues. I was doing a Full export from one PDB and I got the error: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does…

Hi, I was helping a customer who wanted to be ready to migrate the database to 23c when it becomes available using zero or near-zero downtime upgrade techniques. Besides Oracle Golden Gate, one good technique to consider is using a logical standby database to perform a rolling upgrade of the Oracle Database. Oracle Transient Logical Standby is…

Hi, I was helping a customer who needed to migrate to Oracle Database 19c but still using JDK6 and JDK 7. Using JDK 6 and 7 to connect to Oracle Database 19c is not recommended, as Oracle Database 19c may have compatibility and security features that are best supported by later versions of the JDBC…

ORAdiff is an Oracle tool designed for comparing two Oracle Database releases, not only core releases but also patch levels. It highlights variations in parameters, privileges, users and roles, reserved words, patch fixes, database homes, objects, and more. ORAdiff helps answer some common questions: How frequently does the ORAdiff information get a refresh? It is…