Infrastructure at your Service

Mouhamadou Diaw

Dataguard: QUIZZ on Snapshot Standby

By | Database Administration & Monitoring | No Comments
 

 In oracle documentation we can find this about snapshot standby: A snapshot standby database is a fully updatable standby database that provides disaster recovery and data protection benefits that are similar to those of a physical standby database. The concept of snapshot standby is that we can temporary convert a physical standby to an updatable database for different purposes and then convert back to a physical standby. During the time that the database is a…

Read More
Daniel Westermann

Are statistics immediately available after creating a table or an index in PostgreSQL?

By | Database Administration & Monitoring | No Comments
 

 While giving the last PostgreSQL DBA Essentials workshop this question came up: When we create a table or an index: are the statistics available automatically? To be more precise: When we create and load a table in one step, create an index on that table afterwards: Do we have the statistics available by default or do we need to wait for autovacuum to kick in or analyze manually? Lets see …

Read More
Pierre Sicot

DBVISIT from Oracle to Postgres

By | Database Administration & Monitoring | No Comments
 

 As I regularly work on Oracle and PostgreSQL, I decided to test the replication from Oracle to PostgreSQL using the Dbvisit Replicate tool. Dbivisit Replicate does not use Oracle logminer ot triggers but its own mining processes to get the changes when they are written to the redo logs. When a change appears in the redo log, an external file called PLOG is generated and transferred to the target. The architecture is quite easy to…

Read More
Morgan Patou

WebLogic – SSO/Atn/Atz – How to enable debug logs

By | Application integration & Middleware, Entreprise content management | No Comments
 

 Let’s say that you have an application deployed on a WebLogic Server and that the SSO/Atn/Atz (SSO/Authentication/Authorization) isn’t working or throwing a 4xx error code like ‘401 – Unauthorized’ or ‘403 – Forbidden’. How would you be able to know what is happening and how to solve it? Well the answer is always the same: enable debug logs, it is just a matter or choosing the right scope and choosing a way to do it…

Read More
Morgan Patou

Documentum – DFC traces setup & investigation

By | Application integration & Middleware, Entreprise content management | No Comments
 

 When working with Documentum, you will most probably have to enable the DFC traces one day or another and then work with these traces to analyze them. The purpose of this blog is simply to show how the DFC traces can be enabled, which tools can be used to quickly process them and what are the limitations of such things. Enabling the DFC traces can be done very easily by updating the dfc.properties file of…

Read More
Clemens Bleile

DOAG 2017: avg_row_len with virtual columns

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

 At the DOAG I attended a session “Top-level DB design for Big Data in ATLAS Experiment at CERN” provided by Gancho Dimitrov. The presentation was actually very interesting. As part of Gancho’s improvement activities to reduce space in a table he stored data in a 16 Bytes raw format (instead of a string representing hex values which requires 36 Bytes) and use virtual columns to actually calculate the real hex-string. So the original value is…

Read More
Thomas Rein

DOAG 2017

By | Database Administration & Monitoring | No Comments
 

 Als Consultant bei dbi services war ich die letzten 2 Jahre hauptsächlich in Konsolidierungsprojekten basierend auf den Oracle Engineered Systems unterwegs. Deshalb waren für mich natürlich die Vorträge über die neue Generation der Oracle Database Appliance X7-2 interessant. Aus meiner Sicht hat Oracle den richtigen Schritt getan und die Vielfalt der ODA Systeme wie es sie noch in der X6-2 Generation gab (Small/Medium/Large und HA) reduziert. Künftig wird es die ODA X7-2 nur noch in…

Read More
Hervé Schweitzer

DOAG2017 my impressions

By | Database Administration & Monitoring | No Comments
 

  As each year at end of November the biggest Oracle European conference takes place in Nürnberg, #DOAG2017. This year is a little bit special, because the DOAG celebrate the 30th edition of the conference. dbi services is for the 5th time present with a booth and 8 sessions at the DOAG. During the last 2 days I already followed many sessions, and I want to give you my impression and feedback’s about the market…

Read More
Franck Pachot

12c Multitenant Internals: compiling system package from PDB

By | Oracle | No Comments
 

 When I explain the multitenant internals, I show that all metadata about system procedures and packages are stored only in CDB$ROOT and are accessed from the PDBs through metadata links. I take an example with DBMS_SYSTEM that has nothing in SOURCE$ of the PDB. But I show that we can compile it from the PDB. This is my way to prove that the session can access the system objects, internally switching the session to the…

Read More
Daniel Westermann

firewalld rules for Veritas Infoscale 7.3 with Oracle

By | Database Administration & Monitoring | No Comments
 

 You might wonder, but yes, Veritas is still alive and there are customers that use it and are very happy with it. Recently we upgraded a large cluster from Veritas 5/RHEL5 to Veritas InfoScale 7.3/RHEL7 and I must say that the migration was straight forward and very smooth (when I have time I’ll write another post specific to the migration). At a point in time during this project the requirement to enable the firewall on…

Read More