Apr 09

Oracle Data Guard error - Force closing the keystore for standby rekey.

I have a Primary 11g Oracle Database with a single Physical Standby. Those days I tried to create an encrypted column inside one table for testing purposes. I end up accidentally messing the things: Force closing the keystore for standby rekey. Please re-copy the keystore from primary before re-open as needed. Apply redo for database master …

Continue reading

Apr 08

OCM 11g Preparation - Implement securefile LOB

Securefile LOBs are a new way of storing LOBs that allows us to enable compression, deduplication, or encryption. In the exam, we need to know how to manage them: Using CREATE TABLE with SecureFiles LOBs Using ALTER TABLE with SecureFiles LOBs Initialization Parameter db_securefile for SecureFiles LOBs PL/SQL Packages for SecureFiles LOBs "Database File System …

Continue reading

Apr 07

OCM 11g Preparation - Maintain indexes on a partitioned table

Now that you know how to manage the partitions, start working with their indexes: Rebuilding Global Index Partitions Rebuild each partition by issuing the ALTER INDEX ... REBUILD PARTITION statement (you can run the rebuilds concurrently). Drop the entire global index and re-create it. This method is more efficient because the table is scanned only …

Continue reading

Apr 06

OCM 11g Preparation - Perform partition maintenance operations

The partition maintanence is as important as knowing create them. Study in this topic all the kinds of partition operations, and be ready to access quickly the documentation to get or adapt codes: Partition operations: Adding / Coalescing / Dropping / Exchanging / Merging / Moving / Renaming / Splitting / Truncating Modifying Default Attributes …

Continue reading

Apr 06

DBCA failing with "oracle.net.TNSAddress.Description.toString(Unknown Source)"

During some days, when I was testing and creating the integration of my Oracle Databases with OUD 11.1.2.2.0  (OUD-EUS integration), I received the error below: In the trace file generated by dbca inside "cfgtoollogs/dbca" folder, I could find: java.lang.NullPointerException at oracle.net.TNSAddress.Description.toString(Unknown Source) at java.lang.String.valueOf(String.java:2615) at java.util.AbstractCollection.toString(AbstractCollection.java:454) at java.util.Vector.toString(Vector.java:946) at java.lang.String.valueOf(String.java:2615) at java.lang.StringBuilder.append(StringBuilder.java:116) at oracle.sysman.assistants.util.NetworkUtils.registerDBWithDirSrvc(NetworkUtils.java:1917) at oracle.sysman.assistants.util.NetworkUtils.registerDBWithDirSrvc(NetworkUtils.java:1833) at oracle.sysman.assistants.util.step.network.DirServiceStep.executeImpl(DirServiceStep.java:248) …

Continue reading