March 2015 archive

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

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