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 . This post starts a series about things I wrote while preparing the OCM 12c upgrade exam. Everything in those posts are written before taking the exam – so don’t expect any clue about the exam here. It’s based only on the exam topics, and only those points I wanted to brush up, so don’t expect it…
This post takes a look on how to migrate the Oracle 12cR1 sample schemas to PPAS 9.4 (PostgreSQL Plus Advanced Server 9.4). I’ll not dig into how to install PPAS as this was described in detail some time ago. Just follow this post if you need a setup guide. If you wonder why I am doing this there are two…
This week I worked on a GoldenGate 12.1.2.1.10 POC setup and was facing an issue which for me is a serious drawback of the Oracle GoldenGate product.If you want to create additional columns on the target database online in a GoldenGate configuration you have to be aware of the below situation which can happen in your setup:The below demo was…
Sometimes it is necessary to rename targets in Enterprise Manager Cloud Control 12c. In my case I have listener targets discovered by EM12c with the hostname at the end of the target name: TESTDBA_LSN_dbserver1 As I work in a Veritas clustered environment, when the target switches to the other node (dbserver2) the listener target is relocated, but its name is…
Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and enhancements that I will sow you in this blog. In previous versions of SQL Server 2016 CTP 2.x, before to be allowed…
The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to build a lot of various reports. The Oracle Management Service collects a huge amount of raw data from the agents…
A lot of people use the graphical way to upgrade Oracle software from one version to another. While there is nothing to say against that the same can be done without any graphical tools. This post outlines the steps to do so. Currently my cluster is running Grid Infrastructure 12.1.0.1 without any PSU applied. The node names are racp1vm1 and…
By Franck Pachot . I like to come upon new monitoring software that help to go quickly from user response time to root cause. And I love applications that can be installed easily and at which I can give a try without reading pages of manual. At DOAG 3rd floor I’ve visited the AppDynamics booth and immediately wanted to install…
In Enterprise Manager 12c, using the compliance standard results might be a good solution for DBA’s to detect security incoherences (for example a lambda user who has the sysdba role …) for their various targets. From the 12.1.0.3 version, a new column named ‘Required Data Available’ appeared in the Compliance Standard Result screen. This column defines if the data for…
By Franck Pachot . I was looking at twitter analytics showing my top tweets in November and that puzzled me because tweets with the most ‘impressions’ and ‘engagement’ are related to events that had low audience in real. Any comment is welcome as it can help to understand why some events have low audience. Here it is. I’ve put my…
I promised to upload the scripts of my session to our blog. So, here they are: create_12102_gi_rac_project.sh: This one creates the 12.1.0.2 GI/RAC project on the cobbler server finish_ora_12102_gi_rac_project.sh: This one does the configuration of the GI/RAC on the last node ora12102_gi_rac.ks: The 12.1.0.2 GI/RAC kickstart file pg940.ks: Template kickstart file for PostgreSQL 9.4 create_940_postgres_project.sh: Template project file for PostgreSQL…
By Franck Pachot . By default, In-Memory Column Store population is done in background, asynchronously. There are two hidden parameters that can change this behavior, let’s see how it works. Note that this is only good for research, those parameters are undocumented which means that they may not behave as you think they would. In a demo about in-Memory (slides,video)…
