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.

As you may have heard, the Oracle Database 23ai is available on OCI and as a Free Developer Edition. Some good blog posts about the announcement: https://blogs.oracle.com/database/post/oracle-23ai-now-generally-available https://blogs.oracle.com/database/post/oracle-database-23ai-where-to-find-more-information https://blogs.oracle.com/datawarehousing/post/23ai-autonomous-database-free https://blogs.oracle.com/database/post/oracle-database-23ai-now-available-in-the-cloud Some good videos about it: Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/index.html https://docs.oracle.com/en/database/oracle/oracle-database/23/upgrd/index.html

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…