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 . Storing documents within the database is the easiest, especially because you get them consistent with the metadata stored in the database. If you store them externally, then you need to manage their backup, their synchronization to standby site, the consistency in case of flashback or PITR, etc. However, documents grow (in number and in size thanks…
Recently I exported an Oracle Virtual Box VM as an “.ova” file. When the file was imported again I faced issues with the network devices inside the VM. This post is about what I experienced and how I resolved it. In my example I have two networks devices configured for the VM in the Virtual Box: When I logged in…
Ausgangslage Wie gut lässt sich mit Oracle Standard Edition unter Windows eine Hochverfügbarkeitslösung aufbauen? Die Basis, zwei Windows Server 2012 R2, Oracle Standard Edition und Dbvisit Standby. Die eingesetzte Version Dbvisit Standby 7.0.48.15006. Die eingesetzte Oracle Version 12.1.0.2.0. Installation Die Windows Installation ist Standard, nur die beiden Server müssen, zwecks Namensauflösung im Hosts File(C:\Windows\System32\drivers\etc\hosts) unter Windows eingetragen werden. 192.168.198.129 node01.localdomain node01…
Why does the sysctl.conf value for swappiness on Oracle Linux 7.x not survive a reboot For a project I applied the dbi services best practices for Oracle databases. One of these is to adjust the swappiness parameter. We recommend to use a very low for the swappiness value like 10 or even lower to reduce the risk for Linux to begin swapping!…
By Franck Pachot . When non-CDB has been declared deprecated, I was a bit upset because multitenant with a lone PDB just looks like an overhead of 3 containers instead of one. But with experience I changed my mind. First because the multitenant architecture brings some features that are available even without the option. And second, because this overhead is…
I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2/12c the following manual steps were necessary: cd $ORACLE_HOME/lib mv libodm11.so libodm11.so_stub ln –s libnfsodm11.so libodm11.so In the context of make-commands, somebody in the audience asked…
Recently at a customer we again implemented a PostgreSQL architecture as described some time ago. When we delivered the first draft of the documentation the question popped up how to handle maintenance tasks in a failover cluster protected by EDB Failover Manager. So, here we go… The setup of my little test environment is as follows: IP Description 192.168.22.243 Current…
By Franck Pachot . Before 12c, the fixed stats statistics were not gathered automatically. In 12c this has changed: even when you have never gathered fixed objects statistics you can see that you have statistics for X$ tables. That may be better than having no statistics at all, but it doesn’t replace manual gathering at the right time. Documentation First…
By Franck Pachot . Il n’a jamais été aussi facile de créer une base Oracle. Et ceci grâce au Database as a Service (DBaaS). C’est l’occasion de tester le cloud: Oracle Cloud Service offre une version d’essai de un mois. Si vous êtes proches de Genève, passez nous voir lors du SITB les 26-27 avril: https://www.dbi-services.com/fr/events-fr/swiss-it-business-sitb-du-26-au-27-avril-2016/ Mais j’ai aussi fait…
By Franck Pachot . The Oracle Cloud has two interfaces that are very similar visually and it’s easy to get lost and don’t find what we are looking for in the menus. You see the difference: My Account on the left and My Service on the right. They look similar, but manage a different level of the Cloud Services. My…
By Franck Pachot . When you create a DBaaS on the Oracle Cloud Service you have only one way to access to your database: ssh with the public rsa key you provide. Then you can open some ports to access the VM. However, from the VM you can’t access your own network. You need it to move data between from…
This month, the Release Candidate 1 (RC1) for SQL Server is available. With this new version, you can now use the “CREATE TABLE” command for Stretch Databases. If you read the msdn page from CREATE TABLE for SQL Server 2016, you can see these options: The first step is to enable the functionality for the database “AdventureWorksDW2012” To enable the…
