Database Administration & Monitoring

dbi Tail ranked as the 4th best alternative !

Dear colleagues, Since the publication of the dbi Tail one year ago, lots of people downloaded, and some reporters wrote articles about it. We have got many positive feedbacks, and we would like to thank you all for your attention(…)

Dataguard Oracle 12.2 : Support for Multiple Observers

By Mouhamadou Diaw With Oracle 12cR2 it is now possible to configure multiple observers within a single Oracle Data Guard broker configuration. Multiple observers provide an immediate benefit for High Availability. If one observer fails, there are additional observers(…)

ORA-12801 and ORA-12154 with OracleRestart / GRID / RAC on Oracle Database 12c

ORA-12801 and ORA-12154 with OracleRestart / GRID / RAC on Oracle Database 12c Symptom/Analysis: Using Oracle 12c in a RAC environment, you may encounter the following errors: ORA-12801: error signaled in parallel query server P000, instance rac2.localdomain:DBRAC2 (2) ORA-12154:(…)

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned(…)

Dealing with WSFC 2016 quarantine state and availability groups

I was playing with my lab environment which includes Windows 2016 and SQL Server 2016 and I noticed an interesting scenario while testing cluster node failures. After simulating some network outage scenarios, I was not able to(…)

12cR2: no cardinality feedback for small queries

By Franck Pachot . This follows the comments on Clemens Bleile post about SQL Plan Directives in Oracle 12.2 where he discovered a new behavior that is not documented. The feature is good: bypass the cardinality feedback overhead when the(…)

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