Infrastructure at your Service

Replication Archives - Blog dbi services

Morgan Patou

Documentum story – Replicate an Embedded LDAP manually in WebLogic

By | Entreprise content management | No Comments

In this blog, I will talk about the WebLogic Embedded LDAP. This LDAP is created by default on all AdminServers and Managed Servers of any WebLogic installation. The AdminServer always contains the Primary Embedded LDAP and all other Servers are synchronized with this one. This Embedded LDAP is the default security provider database for the WebLogic Authentication, Authorization, Credential Mapping and Role Mapping providers: it usually contains the WebLogic users, groups, and some other stuff like…

 
Read More
Stéphane Haby

Attunity Replicate: additional column on the target

By | Development & Performance | No Comments

In December 2015, my colleague Vincent did a test with additional column with Oracle GoldenGate 12.2. Hervé & Vincent asked me to do the same test with Attunity Replicate between Oracle and SQL Server. For the story, Hervé does the test with a previous version here. I create a task and select the Scott schema. I run the replication On the target SQL Server database, I create an additional Column: alter table [SCOTT].[EMP] add SOURCE_COL…

 
Read More
Daniel Westermann

A near zero downtime, near zero impact major release upgrade using Oracle GoldenGate

By | Database Administration & Monitoring | No Comments

In this post I’d like to share what we did for a customer who had the following requirements: Use Oracle GoldenGate Upgrade an Oracle 10.2.0.4 database running on Solaris 10 SPARC to Oracle 12.1.0.2 running on Exadata Keep the downtime as small as possible Minimize the impact on the production database as much as possible I will not describe why GoldenGate was the product of choice nor will I describe how we verified that Golgengate…

 
Read More
Stéphane Haby

Attunity Replicate: Replicate numeric data types from Oracle to SQL Server is easy

By | Application integration & Middleware | No Comments

After the good article “A short glance at Attunity replicate” from Franck Pachot, I will continue to explain our test on Attunity Replicate with datatype and how this tool do the mapping between Oracle and SQL Server for numeric datatypes. Introduction The first step is to find the mapping between Oracle and SQL Server. I summarize this mapping in this table: As you known (or not), in SQL Server, you have a replication with Oracle…

 
Read More
Franck Pachot

A short glance at Attunity replicate

By | Database Administration & Monitoring | 5 Comments

If you follow my blog, you should know that I really like Dbvisit replicate because it’s simple, robust, has good features and excellent support. But that’s not a reason to ignore other alternatives (and this is the reason of http://www.dbi-services.com/news-en/replication-event-2/). When you have heterogeneous sources (not only Oracle) there is Oracle Golden Gate with very powerful possibilities, but maybe not an easy learning curve because of lack of simple GUI and setup wizard. You may…

 
Read More
David Barbarin

Windows Server 2016: Introducing stretch cluster functionality

By | Database Administration & Monitoring, Hardware & Storage | One Comment

Let’s continue with the new high available functionality shipped with the next Windows version. In my previous blog, I talked about the new site awareness feature that provides more flexibility to configure failover resources priorities and more granular heartbeat threshold as well by introducing the new site concept. This time, we’ll talk about stretch cluster. What’s that? Let’s introduce the concept with some customer experiences for which we introduced high availability with the implementation of…

 
Read More
Morgan Patou

Exception from executeScript in Alfresco Share

By | Application integration & Middleware | No Comments

I didn’t have the opportunity to post a new entry about Alfresco in this blog for a long time now, so I will fix this! In this blog entry, I will talk about a bug I encountered a few months ago. I resolved it but I, so far, not had the time to share my knowledge with you. I. Description of the issue This bug appears no matter what the version of Alfresco is used,…

 
Read More
Nicolas Jardot

Oracle Open World 2013: Final day – Database as a service and replication fundamentals

By | Technology Survey | No Comments

My final day at Oracle OpenWorld 2013, less sessions and less people but still a big day after almost one week in San Francisco. In this blog I’ll focus on the private cloud with databases as service and the fundamentals about replication. To conclude on Oracle OpenWorld, I would say that there are three big news – more on these at the end of this posting. On Thursday, there are less people in the sessions…

 
Read More
Jérôme Witt

Frankfurter Datenbanktage: Bei dbi services hat Ostern schon begonnen…

By | Database management | No Comments

Ganz klar: Unser dbi services Goldhase war das inoffizielle Maskottchen der Frankfurter Datenbanktage! Der Nachfrage nach zu urteilen war es sowohl ein Augen- als auch ein Gaumenschmaus … wir haben auch schon eines “geschlachtet” und brüderlich geteilt. Wir waren in 3 Sessions aktiv und hatten die Freude, viele interessierte Teilnehmer an unserem Stand zu begrüssen! Stéphane Haby hat in seiner Session ein neues SQL Server Monitoring-Tool für Microsoft DBAs vorgestellt: “SQL Server Management Datawarehouse”. Die…

 
Read More
Hervé Schweitzer

Adding new tables to an existing Oracle GoldenGate replication

By | Application integration & Middleware | 10 Comments

Once a replication environment is set up, it’s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation. This posting should help you with this task. In the example below, tables from schema G001 will be added to an existing replication setup from the database PROD1 to REP1. CFG_ADV_COND CFG_NARRATIVE_TEMPLATE CFG_REG_REPORT_RULES CMN_LOOKUP CMN_USER_LOGIN   Stop the replication environment Connect to the source database PROD1 and…

 
Read More