Infrastructure at your Service

Arnaud Berbier

OAM 11gR2PS2 series – Introduction

By | Application integration & Middleware | No Comments
 

 In this blog post, I will share my experience acquired on a customer interesting challenge which was a critical mission. The mission was not as easy as expected. On my side, all troubles that could happen to migrate an entire Identity Management – Oracle Access Manager 10g environment to 11g was exposed to me. As the challenge is completely finished, I must share my knowledge. In this first blog post for the OAM 11gR2PS2 series,…

Read More
Franck Pachot

Thinking about downgrading from Oracle Enterprise to Standard Edition?

By | Database management, Oracle | No Comments
 

 You are using an Oracle Enterprise Edition and thinking about downgrading to the Standard Edition? In this case, you must be sure that your applications are compatible. It’s not something easy to check. Here are a few ideas. Why? Why do you want to downgrade to the Standard Edition? For licensing costs, of course. Today, it is difficult to find a server with only a few cores. And Oracle Enterprise Edition is licenced per number…

Read More
David Barbarin

SQL Saturday 323: SQL Server AlwaysOn and availability groups session slides

By | Hardware & Storage | 4 Comments
 

 This SQL Saturday’s edition in Paris is now over. It was a great event with a lot of French and international speakers. There were also many attendees indicating that this event is a great place to share about SQL Server technologies. Maybe the Montparnasse tower in Paris played a role here with its panoramic view over Paris from the 40th floor! For those who didn’t attend on Saturday, you will find our SQL Server AlwaysOn…

Read More
Gérard Wisson

Documentum upgrade project – ActiveX and D2-Client 3.1Sp1

By | Application integration & Middleware | No Comments
 

 This is another blog posting an our Documentum upgrade project. This time, the following issue occured: the ActiveX could not be installed using the D2-Client. We had to access the D2-Config url to have it installed. For a normal user, this could not be used. Analyzes The workstation had the ActiveX for D2 3.0 installed, the version before the upgrade. Under C:\Windows\Downloaded Program Files, we had: ctx ctx.ocx D2UIHelper.dll On my workstation where I could…

Read More
Morgan Patou

Kerberos SSO with Liferay 6.1

By | Application integration & Middleware | 10 Comments
 

  In my previous blog, I described the process to install a Kerberos Client and how to Kerberized Alfresco. In this blog, I will continue in the same way and present another application that could be configured to use the Kerberos MIT KDC: Liferay. Liferay is a very popular and a leader in Open Source solution for enterprise web platform (Intranet/Extranet/Internet web sites). Liferay could be bundled with several application servers like Tomcat, JBoss, Glassfish,…

Read More
Grégory Steulet

MySQL high availability management with ClusterControl

By | Database management | No Comments
 

 Installing and managing a highly available MySQL infrastructure can be really tedious. Solutions to facilitate database and system administrator’s task exist, but few of these cover the complete database lifecycle and address all the database infrastructure management requirements. Severalnines’ product ClusterControl is probably the only solution that covers the full infrastructure lifecycle and is also able to provide a full set of functionalities required by database cluster architectures. In this article, I will show how…

Read More
Pierre Sicot

Oracle OEM Cloud Control 12.1.0.4 – AWR Warehouse

By | Database management | One Comment
 

 This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse. As OEM AWR warehouse automatically extracts the AWR data of the database you have selected, there is no impact on your production databases. The main advantage is that it allows to keep AWR historical…

Read More
Gérard Wisson

Documentum upgrade project – Documentum Administrator and ACS

By | Application integration & Middleware | No Comments
 

 After having installed the Documentum Administrator, one of our test was to open a document. When I opened one for the first time the content was empty although I knew it contained text. But the correct content was well displayed when I opened it a second time. In the ucf trace file I had: FINE: sun.net.www.MessageHeader@108565d6 pairs: {null: HTTP/1.1 500 Internal Server Error}{Server: Apache-Coyote/1.1}{Content-Type: text/html;charset=utf-8}{Content-Length: 3437}{Date: Mon, 27 Jan 2014 12:55:47 GMT}{Connection: close} Jan 27, 2014 1:55:47…

Read More
Gérard Wisson

Documentum upgrade project – D2EventSenderMailMethod & bug with Patch 12

By | Application integration & Middleware | No Comments
 

 We started the Documentum upgrade in the wintertime and our jobs ran successfully by following the defined schedule. Once we moved to the summertime we hit an issue: A job that was scheduled for instance at 4:00 AM was executed at 4:00 AM, but also started every 2 minutes until 5:00 AM. We had this issue on all our 6.7SP2P009 repositories – on upgraded as well as on new repositories. Before opening an SR in…

Read More
Franck Pachot

Oracle: How to move OMF datafiles in 11g and 12c

By | Database management, Oracle | One Comment
 

 With OMF datafiles, you don’t manage the datafile names. But how do you set the destination when you want to move them to another mount point? Let’s see how easy (and online) it works in 12c. And how to do it with minimal downtime in 11g. Testcase Let’s create a tablespace with two datafiles. It’s OMF and goes into /u01: SQL> alter system set db_create_file_dest=’/u01/app/oracle/oradata’ scope=memory; System altered. SQL> show parameter db_create_file_dest NAME TYPE VALUE…

Read More
Franck Pachot

Resize your Oracle datafiles down to the minimum without ORA-03297

By | Database management, Oracle | 32 Comments
 

 Your datafiles have grown in the past but now you want to reclaim as much space as possible, because you are short on filesystem space, or you want to move some files without moving empty blocks, or your backup size is too large. ALTER DATABASE DATAFILE … RESIZE can reclaim the space at the end of the datafile, down to the latest allocated extent. But if you try to get lower, you will get: ORA-03297:…

Read More
Gérard Wisson

Documentum upgrade project – sharing experience

By | Application integration & Middleware | One Comment
 

 A few weeks ago, we finished a Documentum upgrade at a customer site. Now, after having analyzed and made a status point (we do that after each upgrade project to optimize our procedures and skills) it is time to share our experiences. In this post and in the ones that will follow we will describe which issues we were confronted with, which bugs we discovered, and how we proceed to go forward to have a…

Read More