Infrastructure at your Service

Jérôme Witt

Oracle Database 12c: The secret of moving datafiles online

By | Database management | No Comments

Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals. To do that, I have written a tiny test protocol composed of two parts: Session 1: starts a batch (schema BATCH) processing which runs for hours Session 2: that’s us, we are connected as SYS (of course we…

Read More
Arnaud Berbier

Oracle Cloud Application Foundation for next-generation applications

By | Application integration & Middleware | No Comments

On 11 July 2013, Oracle launched the so-called Cloud Application Foundation. An online launch event was organized on 31 July 2013 to introduce this new term in the Oracle Stack. This event had two parts: Keynote and Customer & Industry Leader Panel Webcast (60 minutes) Technical Breakout Session featuring Oracle WebLogic, Oracle Coherence, Oracle Enterprise Manager and Oracle Developer tools Webcast (120 minutes) First of all: Cloud Application Foundation is yet another term from Oracle…

Read More
Yann Neuhaus

Oracle Database 12c: PDBs not fully transportable yet

By | Database management | No Comments

One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this…

Read More

Oracle Database 12c: SecureFiles enhancements

By | Database management | 2 Comments

Oracle Database 12c features with some enhancements for LOB objects and particularly for the SecureFiles. This is not a revolution, but we can see that the range of possibilities with LOB objects increases with the different releases of Oracle… SecureFiles is the default for LOB storage With Oracle 11g, when creating a table containing LOB data, LOB are stored as BASIC FILE per default and the default value for the init parameter DB_SECUREFILE is set…

Read More
Stéphane Savorgnano

SQL Server 2012 SP1: Fifth Cumulative Update (CU5) available

By | Technology Survey | No Comments

On 16 July, Microsoft published the fifth Cumulative Update (CU5) for Microsoft SQL Server 2012 Service Pack One. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU5? This Cumulative Update contains 29 Hotfixes: 20 for the Engine 5 for SSRS 2 for SSIS 2 for SSAS If you want more information and/or details about these Hotfixes, click…

Read More
Grégory Steulet

Oracle Database 12c new features: segregation of duties with new administrative roles

By | Database management | No Comments

Starting with Oracle Database 12C Release 1 a set of new administrative privileges that are more task oriented are available.

Before Oracle 12c it was needed to have the SYSDBA privilege to make a backup, to monitor the Data Guard status or to administrate some features of Oracle Transparent Data Encryption. Starting with this new Oracle release it is not anymore the case. We can grant limited administrative privileges to operate an Oracle 12c database.

Read More
Gérard Wisson

Documentum Administrator does not display the correct “Index Agent” status

By | Application integration & Middleware | One Comment

At one of my customers, I experienced a problem with the Documentum Administrator (DA), which did not display the correct Index Agent status. In this blog post, I will explain how I found the source of this problem and of course also how I solved this issue. But first, some background facts: The Documentum Administrator (DA) is displaying “not responding” for the Index Agent, however the Index Agent is running well. No solutions are mentioned…

Read More
Oracle Team

Oracle Database 12c: Partitioning enhancements Part I – Reference partitioning

By | Database management | No Comments

Oracle Database 12c offers several enhancements for partitioning. This blog posting will present some enhancements in relation to reference partitioning. The differences between the Oracle 11g R2 and Oracle 12c releases will be shown using practical examples. TRUNCATE and EXCHANGE with the CASCADE option With Oracle 12c, it is now possible to use the CASCADE option to cascade operations to a child-referenced table when truncating or exchanging a partition. As an example, I created the…

Read More
Stephane Biehler

Oracle Java EE 7 – an overview

By | Application integration & Middleware | No Comments

After announcing the availability of Oracle Java Enterprise Edition 7 (Java EE 7 or JEE7), Oracle organized a web event for the launch, covering topics such as the new features and the java community as well as showing some examples of the new APIs. This blog post summarizes some key points of this event. The show was driven by the following Oracle presenters: Hasan Rizvi, Executive Vice President, Oracle Fusion Middleware and Java, Oracle Cameron…

Read More
Jérôme Witt

Data Pump in Oracle Database 12c: die wichtigsten Neuigkeiten

By | Database management | No Comments

Letztes Jahr hat Oracle CEO Larry Ellison während der Oracle OpenWorld in San Francisco ein neues Datenbank Release angekündigt, das nun endlich zur Verfügung steht. In diesem Blogbeitrag möchte ich einige der wichtigsten Data Pump-Neuigkeiten vorstellen. Eine komplette Übersicht der Features finden Sie in Oracles Dokument „Oracle Database Utilities“. Fangen wir an mit dem riesen Hype von Oracle 12c! Oracle 12c Pluggable Databases (PDB): wie soll ich mit diesem Feature umgehen? In Oracle Database 12c…

Read More
Gérard Wisson

Oracle WebLogic 12.1.2 – new features

By | Application integration & Middleware | No Comments

The new Oracle WebLogic Sever 12c (WLS 12.1.2.0.0) was released on 11 July 2013. Since I read lots of documents, announcements, and information regarding this new version, I want to inform you about some new features that have an impact and/or changed my daily work as a WebLogic Server administrator. Some general information Here are a couple of new features that are good to know even if I do not use them for the time…

Read More
Pierre Sicot

Oracle Database 12c: Information Lifecycle Management

By | Technology Survey | 7 Comments

More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level. The idea behind…

Read More