Database Administration & Monitoring

NLS defaults for LANGUAGE and TERRITORY

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

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

Migrating your existing availability group infrastructure to 2016

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

Can I do it with PostgreSQL? – 8 – Transportable tablespaces

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

SQL Plan Directives in 12cR2. Behavior is different than in 12cR1.

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

Oracle 12cR2 – DataGuard and TCP.VALID_NODE_CHECKING

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

Oracle 12cR2: AWR views in multitenant

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

RMAN> TRANSPORT TABLESPACE

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.

Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions

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