Category: Oracle Database General

Oracle Database General

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

Mar 03

IMPDP failing with ORA-39083 and ORA-14024

Sometimes, when your EXPDP takes so long (probably because you have huge partitioned tables), when you try to IMPDP somewhere later you may receive the error: ORA-39083: Object type INDEX failed to create with error: ORA-14024: number of partitions of LOCAL index must equal that of the underlying table This usually happens because the export of …

Continue reading

Mar 02

IMPDP failing with ORA-31625 and ORA-01031: insufficient privileges with Database Vault

Those days, I was having a lot of errors during my Import Datapump session in a Oracle 11g with Database Vault environment. As the schema was protected, first I did the overall check up making sure the user I was using to import had the DBA permission and I also gave it full access to …

Continue reading

Feb 28

How to delete the incarnations of an Oracle Database

In this article, I will talk about database incarnation and how to clean the old and obsoletes ones. It's not intended to show you how to clean the incarnations on the recovery catalog, but from the database itself! Let's start. Sometimes, after performing several database recoveries or "open resetlogs", you can end up with so …

Continue reading

Nov 28

ORA-12853, ORA-04031 and ORA-06512: at "SYS.UTL_RECOMP", line 865

Those days I created a really small 11.2.0.4 database in a very powerful Sun Sparc 64 processors server. I've set up the database to use as memory_target the minimal possible: 524M. I planed to increase this size later after preparing the DB Server. When I started enabling the Database Vault, I received the following error …

Continue reading