Category: Oracle Database General

Oracle Database General

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

Nov 13

Howto apply OJVM PSU, DB PSU and Generic JDBC Patch in 11.2.0.4

Starting at October 2014, all the DB PSU come along with the OJVM PSU option on the main download page (Doc ID 756671.1). Oracle recommends to install both, as well as the Generic JDBC Patch that is also available there. In this tutorial, I will show how to install the OJVM PSU, DB PSU and JDBC …

Continue reading

Nov 07

Rename schema in Oracle 11g with Loopback DBLink

In this article, we will deal a very common situation where the DBA is tasked to rename or clone a user into the same database. In the following lines, I will explain how to make this copy without higher complexities and with no need to generate intermediate dump files, using DataPump import utility with a …

Continue reading