April 2015 archive

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

Apr 02

OCM 11g Preparation - Administer partitioned tables and indexes using appropriate methods and keys

Partitioning is the key for performance when you are talking about DW or any object with a lot of rows. What you must study and practice in this topic is how to create a table with: Basic Partitioning Strategies: RANGE, LIST and HASH. Advanced Partitioning Strategies: REFERENCE, INTERVAL, SYSTEM and VIRTUAL COLUMN-BASED. Composite Partitions (all the combinations) …

Continue reading