Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Natascha Karfich

vagrant up – get your Oracle infrastructure up an running

By | Database Administration & Monitoring, Database management, Operation systems | No Comments
 

 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 I try to give you an idea with the following very short  summary. There is a lot of good information available about Ansible and Vagrant. Please check the provided links at the end of this blog…

Read More
Daniel Westermann

From PostgreSQL 9.1.8 to PostgreSQL 9.5.5 including a standby database with minimal downtime

By | Database Administration & Monitoring | No Comments
 

 As you might know PostgreSQL 9.1 is out of support since last September. But, no surprise, there are still plenty of PostgreSQL 9.1 instances out there which need to be upgraded to a supported release. At one of our customers we exactly have this situation: The production environment is running on PostgreSQL 9.1.8 and needs to be upgraded to a recent release (9.5.5 in this case). To make life a little bit more fun there…

Read More
David Barbarin

Introducing high-availability with SQL Server on Linux

By | Database Administration & Monitoring, Database management | No Comments
 

 A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So now it’s time to start the new year by talking about high availability on Linux with SQL Server vNext. Running standalone instances will be suitable for scenarios but I guess introducing high-availability with critical environments still remain mandatory.Currently, the CTP1 supports installing a SQL Server Failover Cluster Instance on the top…

Read More
Daniel Westermann

2016 is over and it was great, 2017 will be even more exiting in the open source area

By | Database Administration & Monitoring | No Comments
 

 Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our Open Infrastructure division. We’ll start with a few numbers then look at the events we did and some of the projects we completed in 2016. Here we go …

Read More
Philippe Schweitzer

dbi Tail ranked as the 4th best alternative !

By | Database Administration & Monitoring | No Comments
 

 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 !   The best article is from Softpedia website, and the author made an interesting description of the tool as you can see: http://www.softpedia.com/get/System/File-Management/dbi-Tail.shtml   More interesting, in June, the tool was published alongside of…

Read More
Mouhamadou Diaw

Dataguard Oracle 12.2 : Support for Multiple Observers

By | Database Administration & Monitoring | No Comments
 

 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 that can continue to monitor the status of the configuration. In this blog we are going to talk about this new feature. Our configuration have 3 servers: primaserver.localdomain with db_unique_name ORCL_SITE standserver1.localdomain with db_unique_name ORCL_SITE1 standserver2.localdomain with db_unique_name ORCL_SITE2…

Read More
Olivier Gautreau

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

By | Database Administration & Monitoring | No Comments
 

 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: TNS:could not resolve the connect identifier specified In this article, we will present you an issue that is inspired from a real case: olivier@olivier-ThinkPad-T550 ~ $ sqlplus sys/***@DBRAC1 as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon…

Read More
Joël Cattin

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

By | Database Administration & Monitoring | No Comments
 

 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 table…online ! As a reminder, the way to convert a table to a partitioned table were to use the DBMS_REDEFINITION package (since 9i to 12cR1) which require few steps : Verify that the table is a candidate for redefinition : DBMS_REDEFINITION.CAN_REDEF_TABLE…

Read More
David Barbarin

Dealing with WSFC 2016 quarantine state and availability groups

By | Database Administration & Monitoring, Operation systems | No Comments
 

 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 bring back my cluster node online immediately by using traditional way. A quick look at the cluster manager led me to notice something new: A quarantined state value … interesting! But what does it mean exactly? In respect…

Read More
William Sescu

Oracle 12cR2 – DataGuard Switchover with Oracle Wallets

By | Database Administration & Monitoring, Database management | No Comments
 

 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; oracle@dbidg01:/u01/app/oracle/local/dg/ [DBIT122] dgmgrl @show_config.dg DGMGRL for Linux: Release 12.2.0.1.0 – Production on Wed Jan 4 12:54:11 2017 Copyright…

Read More