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

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

Mar 31

OUD failing with “Client requested protocol SSLv3 not enabled or not supported”

After installing the latest release of Oracle Unified Directory (11.1.2.2.0), all databases that tried to connect in the directory service started to receive the following error: SQL> conn T3204325 Enter password: ERROR: ORA-28030: Server encountered problems accessing LDAP directory service Checking on the OUD log file, the error was: [30/Mar/2015:10:50:46 -0300] CONNECT conn=19 from=10.192.38.28:34059 to=10.221.63.49:1636 protocol=LDAPS …

Continue reading