Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Instance fails to start automatically

By | Database Administration & Monitoring | No Comments

Recently at a customer I was confronted with a problem of restarting the Oracle Database 12c automatically on a Windows Server 2008 R2 x64. I installed Oracle 12.1.0.1.0 with a user of service in a domain who has member of the Group ORA_DBA. The authentication service is correctly set with the NTS parameter in the sqlnet.ora file. This Installation has been successfully but after a reboot we can see the database are not OPEN. oracle@********:C:\Users\oracle\…

 
Read More
Franck Pachot

Cloud Control 12c on your laptop

By | Database Administration & Monitoring, Oracle | No Comments

Today every DBA should have a lab on his laptop. This is where I reproduce most of cases before opening a SR, or to investigate something, to demo, to learn new features, or to prepare an OCM exam. I’ve a few basic VirtualBox VM with single instance databases (11g and 12c, SE and EE, CDB and non-CDB, etc). I’ve the RacAttack environement with a 3 nodes RAC in 12c on OEL7. But in order to…

 
Read More
Franck Pachot

set “_rowsets_enabled”=false

By | Database Administration & Monitoring, Oracle | No Comments

This 12c ‘wrong results’ issue is thoroughly described by Mike Dietrich (https://blogs.oracle.com/UPGRADE/entry/switch_off_rowsets_enabled_in) and I’ve nothing to add. This blog post is there to be used as a reference for the comment in the following recommendation that we give to our 12c customers: alter system set “_rowsets_enabled”=false comment=’see http://blog.dbi-services.com/_rowsets_enabled’ scope=both; Our best practice is to document any parameter that is set as a workaround so that it can be revert back when not needed anymore.  

 
Read More

Oracle DBA Essentials Workshop – Patchset 11.2.0.4 Available

By | Database Administration & Monitoring | No Comments

We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for the upgrade of your database: Update DMK to the version 14-10 Upgrade database Install Oracle Patchset 11.2.0.4 and PSU Update DMK 14-10 The first step it’s update Data Management Kit, included dmk_sql. We need to Download,…

 
Read More
Vincent Matthey

GoldenGate – Error during a register extract

By | Database Administration & Monitoring | 2 Comments

This week, I tried to install a GoldenGate environment to make some test. The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly. In a second time, I wanted try to use the integrated capture mode. When arrived the time to register my extract in the database, I have received an error. GGSCI (goldengate as ggadmin@DB1) 2> register extract test database ERROR: Cannot register or unregister EXTRACT TEST…

 
Read More
Franck Pachot

Dbvisit replicate allows DDL replication even when source and destination have different structure

By | Database Administration & Monitoring, Oracle | No Comments

I’ve tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software – at least in their current version – can manage both different target structure (which is often the main reason for logical replication) and keep up with new DDL on the source (which you can’t avoid – applications evolves). Let’s see how smart is Dbvisit replication with…

 
Read More