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.
When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you By Franck Pachot . only the CPU_COUNT no instance caging will occur. Except during the maintenance window where the maintenance plan is set internally. You don’t want that kind of unpredictable behavior, so the recommandation is to always…
By Franck Pachot . If SQL Server, the database for GUI fans, goes to Linux then Oracle, the database for command line fans, can go to Windows. Ok, that’s not new. But I’m not talking about the Windows with media player, animated icons, and The Microsoft Hearts Network. A real server: Windows Server Core. Actually, this is the first time…
As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with Enterprise Manager 13c, and to avoid to have different monitoring tools for each kinf of database. Once you have downloaded…
Starting wiht PostgreSQL 9.4 you can change parameters in postgresql.conf with the “alter system” command in psql. In principle every parameter can be changed that way but not every parameter is applied immediately. Some of the parameters require a reload others require a complete restart of the instance. But which of these parameter require what? How can you know which…
In my last blog post, here, I spoke about how to place SCOM group in maintenance mode. This script is really interesting with an integration in Windows Task Scheduler. At the end, the main purpose is to plan a maintenance window of our different servers. Let’s see how we can do that with PowerShell script. First, I try to use…
Some weeks ago, I wrote a blog post about the creation of SCOM groups in order to subscribe to alerts. Subscribe to alert is mandatory, of course, to be able to receive alerts concerning our group. But during operations like an update, a patching, …, we don’t want to be spoiled by lots of alerts. To avoid those unexpected Emails,…
Breaking news lady and gentlemen. In case you missed it, SQL Server 2016 is live from MSDN subscription. As a reminder, this version offers a lot of very interesting new features and enhancements. Here a summary of the new features per edition. From my part, I’m looking forward to see what it was made of in real customer cases, especially new…
With Enterprise Manager 13c, we have the possibility to define corrective actions. Let me show you how to use it. From the Enterprise à Monitoring select Corrective Actions : Choose Add Space to Tablespace in the Create Library Corrective Action : Enter the name, a description and choose Metric Alert as event: Finally choose to Save to Library You have to publish…
By Franck Pachot . In the previous blog post, to the question “where is the ASM SPFILE” I answered by running ‘asmcmd spget’. But this is available only if the ASM instance is started. If you have corrupted your SPFILE (and it’s easy to do it) you can start with a local PFILE and the CREATE SPFILE= FROM PFILE. But…
By Mouhamadou Diaw To install a flex cluster (or a flex ASM) Grid Naming Service (GNS) is required. A GNS can be configured with dynamic public networks (DHCP) for VIP. This method is suitable for a big number of nodes.In this case GNS domain delegation is mandatory. In case of a few number of nodes, GNS can be configured without…
A couple of days ago, I was in charge to install a new SQL Server AlwaysOn and availability group with one of my colleague Nathan Courtine. During the installation, we talked about testing a disaster recovery scenario where we have to restart the Windows Failover cluster in forced quorum mode. Restarting a WSFC in such mode implies some internal stuff…
By Franck Pachot . You query a simple table to get its rows. Did you ever ask yourself how oracle knows which blocks to read from disk? Let’s question everything and follow the path to dictionary, bootstrapping, spfile,… up to GPnP profile. If you want to read the rows that are stored in a table, you have to read from…
