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 . When you set NLS_LANGUAGE then the values of NLS_DATE_LANGUAGE and NLS_SORT are set to their defaults for the LANGUAGE you set. When you set NLS_TERRITORY then values of NLS_DATE_FORMAT, NLS_NUMERIC_CHARACTERS, NLS_CURRENCY and NLS_ISO_CURRENCY are set to the defaults for the TERRITORY you set. For reference, I’ve listed the defaults in this post. Here for each value…
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 > connect sys/Manager1 > show configuration verbose; > EOF or something like that: oracle@dbidg01:/u01/app/oracle/local/dg/ [DBIT122] cat show_config.dg connect sys/Manager1; show configuration;…
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 that is reading a config file dgobserver.cfg, and this file contains the Username, Passwords and the Connectstring to my Primary…
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 vNext de SQL Server qui sera porté sous Linux ainsi que des nouvelles fonctionnalités prometteuses. A l’habitude, l’équipe dbi services tentera couvrir…
Today, to finish the year, I post a brief personal impression of the IT-Tage 2016 in Frankfurt at the Hotel Maritim, where I was also be a speaker. I presented 2 sessions on SQL Server: “SQL Server Errorlog Entmystifizierung” & “SQL Server 2016: Neue Sicherheitsfunktionen”. I wasn’t the only one from dbi services who spoke at that conference: David Barbarin…
Have you already a plan to migrate your old SQL Server 2012 availability group infrastructure to windows 2016 and SQL Server 2016? In a previous post, I talked about distributed availability groups and cross-cluster migration scenarios but this time the game is not the same because we want to achieve an in-place upgrade of the existing AG infrastructure. This question…
My colleague Franck posted a comment to one of my last “Can I do it with PostgreSQL” blog posts. The comment he posted is: “Here is an idea for a future “Can I do it with PostgreSQL?”. My favorite Oracle feature: transportable tablespaces.” When you’ve read my post about how PostgreSQL implements tablespaces then you probably already know the answer:…
During the Frankfurter IT Tage I provided a presentation about SQL Plan Directives and how to reproduce a testcase in a test environment for a plan with used SQL Plan Directives (SPD). In that context I did a couple of tests with 12cR2 (12.2.0.1) and wanted to blog about the change in behavior in that release. Here is my testcase…
By William Sescu Security is a quite important topic, especially when running Oracle in the cloud. To make your DataGuard a little bit more secure, you can enable the TCP.VALIDNODE_CHECKING feature. I call it SQL*Net Firewall. Enabling the SQL*Net Firewall is quite straight forward. There are only 3 sqlnet.ora parameters which are involved: TCP.VALIDNODE_CHECKING TCP.INVITED_NODES TCP.EXCLUDED_NODES The parameter TCP.VALIDNODE_CHECKING turns…
By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object link usage. What’s new in 12cR2 is the ability to run AWR snapshots at CDB or PDB level. I really think that it makes…
By Franck Pachot . In a previous post I explained how to use transportable tablespace from a standby database. Here I’m showing an alternative where you can transport from a backup instead of a standby database. RMAN can do that since 10gR2. Transportable Tablespace is a beautiful feature: the performance of physical copy and the flexibility of logical export/import. But…
In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image : “Oracle Partitioning in Oracle Database 12c Release 2” – Hermann Bär With the first release of 12c it wasn’t possible to create list partitioned…
