Database management

Oracle 12c – Issues with the HEATMAP Segment even if the heat map feature is not used

By William Sescu When I don’t need I feature, I don’t turn it on, or do not use it because it reduces the possibility to run into issues. Most of the times this is true, however, during the preparation for(…)

Oracle 12c – RMAN list failure does not show any failure even if there is one

By William Sescu Relying to much on the RMAN Data Recovery Advisor is not always the best idea. In a lot of situations,  it tells you the right things, however, sometimes it tells you not the optimal things, and sometimes,(…)

Oracle – RMAN Backups to CIFS

By William Sescu Not to often, but sometimes you need to offload your RMAN backups and your DataPump exports to CIFS. You might run out of space on your NFS server, or you are a Windows shop who has only(…)

Oracle 12cR2 – RMAN cold backup with TAG’s

By William Sescu I am planning to backup my 12R2 container database, because a huge application change is coming up, and I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I(…)

Oracle 12cR2 – DataGuard and Backups to NFS

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(…)

vagrant up – get your Oracle infrastructure up an running

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(…)

Introducing high-availability with SQL Server on Linux

A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So(…)

Oracle 12cR2 – DataGuard Switchover with Oracle Wallets

By William Sescu I would like to make my DataGuard environment more secure, by eliminating the typing of “connect sys/Manager1” for my DGMGRL commands. Especially the ones, that I have in my scripts. For example: oracle@dbidg01:/home/oracle/ [DBIT122] dgmgrl <<-EOF >(…)

Oracle 12cR2 – How to Setup DataGuard observer with Oracle Wallets

By William Sescu I am not a big fan of having passwords in clear text laying around. This applies not only to application servers, but also for my Data Guard observer. I do have a script for starting the observer(…)

MS Cloud Summit Paris 2017

Une nouvelle année commence et 2017 devrait être un bon cru dans le domaine de la base donnée notamment en prédiction des effets d’annonces faites par Microsoft cette fin d’année 2016. En effet, il a été notamment été question de la prochaine(…)