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…
Some Tips to Import to an Autonomous Database Serverless
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…
One more reason to avoid using the SYSTEM user to export a database
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…
Data Pump – Troubleshooting Direct Path Unload Method
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 🙂…
Missing Database Vault on the PDB – 19c
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…
Using Oracle Transient Logical Standby and DBMS_ROLLING to Upgrade your Oracle Database
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…
JDK + JDBC + 19c Database
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 – Compare two Oracle Database releases and find the differences
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…
A Dream Come True: Starting My Journey at Oracle
Dreams have a funny way of coming true when you least expect them. After years of hard work, dedication, and unwavering determination, I find myself at the threshold of a new and exciting chapter in my career: starting at Oracle, the company I’ve always dreamt of being a part of. Join me on this journey…