Infrastructure at your Service

Stéphane Savorgnano

SQL Server 2012 SP1: Sixth Cumulative Update (CU6) available

By | Technology Survey | No Comments
 

  Some days ago, Microsoft published the sixth Cumulative Update (CU6) for Microsoft SQL Server 2012 Service Pack one, two months after the fifth one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it and just have a look at it. Which issues are covered by this CU6? It is a small CU, it contains only 23 Hotfixes, mainly for the Engine and…

Read More
Oracle Team

Oracle Grid Infrastructure 12c: prerequisites for installation

By | Operation systems | 7 Comments
 

  Grid infrastructure 12c has recently been released. In this posting, I will show that the installation prerequisites are quite similar between Grid Infrastructure 11g and 12c. We will see parts of them during a review for the deployment of Grid Infrastructure on a two nodes RAC database cluster. Server hardware requirements Let’s see the hardware part. Grid infrastructure 12.1 Grid infrastructure 11.2 Minimal size for /tmp 1 GB 1 GB Minimal size for Grid…

Read More
Oracle Team

Oracle 12c: Partitioning enhancements Part II – Other improvements

By | Database management | No Comments
 

  Oracle Database 12c offers several enhancements for partitioning. In a previous blog posting, I talked about reference partitioning enhancements. This post will present other enhancements in relation to general partitioning. Asynchronous index maintenance With Oracle database, a global index becomes UNUSABLE when dropping or truncating the partition on which this index points, until the clause UPDATE GLOBAL INDEXES is used. With Oracle 11g, droping or truncating a partition involves the index maintenance, consisting on…

Read More
Olivier Toussaint

Oracle Database 12c : démarrage automatique des Pluggable Databases

By | Database management | No Comments
 

  Dans ce blog post, nous allons nous intéresser à la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l’arrêt et le démarrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c. Le contexte Au préalable, il faut avoir installé Grid Infrastructure et créé une CDB (Container Database) avec une PDB. Nous allons utiliser le processus d’Oracle Restart pour gérer l’arrêt et…

Read More
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…

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…

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…

Read More
Sébastien RENTZ

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…

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,…

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…

Read More