Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
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…
By Franck Pachot . 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…
By Franck Pachot . It’s next week at #DOAG2015 Interested in a deep dive of logical replication? Let’s try it. The best way to learn is to try it and this is the idea of #RepAttack where you can quickly install a replication configuration on your laptop, using VirtualBox, Oracle XE, and Dbvisit replicate trial version. Last year Jan Karremans…
By Franck Pachot . 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://dbi-services.com/blog/_rowsets_enabled’ scope=both; Our best practice is to document any…
Faisant suite à la première annonce de David Barbarin sur les journées SQL Server du 30 novembre et 1er décembre, j’ai le plaisirs de vous inviter à venir nous voir également à notre stand. Effectivement, comme l’année passée, nous sommes heureux d’être à nouveau sponsors GOLD de l’événement et seront placés comme le schéma ci-dessous vous le montre. N’hésitez pas…
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…
With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested just for 2 drop commands(See List of available objects below): one for a table one for a column in a…
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…
By Franck Pachot . I’ll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is a little demo to show how it looks like in an AWR report. In other words, I’ll demo the second…
By Franck Pachot . When you want to minimize the backup or restore duration, you can parallelize RMAN operations by allocating multiple channels. If you are in cluster, you can open channels from several nodes. Let’s see why, how, and a strange issue: need to set cell_offload_processing=false even if not on Exadata. Reason Why do I want to run backup…
By Franck Pachot . 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…
For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON With this new CTP version, JSON support…
