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.
By Franck Pachot . I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the application objects, and is responsible for data integrity and performance. The Exadata Express Cloud Service is the implementation of that:…
By William Sescu From the RMAN point of view, you have generally two possibilities to store your backups, on Disk or on Tape. In case of a single instance, it doesn’t really matter from the accessible or inaccessible point of view. However, in a DataGuard environment it makes a huge difference. Per default, backups to Tape are always accessible and…
By using Vagrant to manage your Virtual Machines and Ansible for configuration management and provisioning you can easily automate the setup of your whole test environment in a standardized way. If you have never heard about Ansible and Vagrant I try to give you an idea with the following very short summary. There is a lot of good information available…
As you might know PostgreSQL 9.1 is out of support since last September. But, no surprise, there are still plenty of PostgreSQL 9.1 instances out there which need to be upgraded to a supported release. At one of our customers we exactly have this situation: The production environment is running on PostgreSQL 9.1.8 and needs to be upgraded to a…
A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So now it’s time to start the new year by talking about high availability on Linux with SQL Server vNext. Running standalone instances will be suitable for scenarios but I guess introducing high-availability with critical environments still…
Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our Open Infrastructure division. We’ll start with a few figures then look at the events we did and some of the projects we completed…
Dear colleagues, Since the publication of the dbi Tail one year ago, lots of people downloaded, and some reporters wrote articles about it. We have got many positive feedbacks, and we would like to thank you all for your attention ! The best article is from Softpedia website, and the author made an interesting description of the tool as…
By Mouhamadou Diaw With Oracle 12cR2 it is now possible to configure multiple observers within a single Oracle Data Guard broker configuration. Multiple observers provide an immediate benefit for High Availability. If one observer fails, there are additional observers that can continue to monitor the status of the configuration. In this blog we are going to talk about this new…
ORA-12801 and ORA-12154 with OracleRestart / GRID / RAC on Oracle Database 12c Symptom/Analysis: Using Oracle 12c in a RAC environment, you may encounter the following errors: ORA-12801: error signaled in parallel query server P000, instance rac2.localdomain:DBRAC2 (2) ORA-12154: TNS:could not resolve the connect identifier specified In this article, we will present you an issue that is inspired from a…
It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned table…online ! As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION package (since 9i to 12cR1) which…
I was playing with my lab environment which includes Windows 2016 and SQL Server 2016 and I noticed an interesting scenario while testing cluster node failures. After simulating some network outage scenarios, I was not able to bring back my cluster node online immediately by using traditional way. A quick look at the cluster manager led me to notice something…
By Franck Pachot . This follows the comments on Clemens Bleile post about SQL Plan Directives in Oracle 12.2 where he discovered a new behavior that is not documented. The feature is good: bypass the cardinality feedback overhead when the query is fast anyway. Feature In Clemens Bleile post about SQL Plan Directives changes in 12cR2 he determined than the…
