Infrastructure at your Service

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

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…

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…

Read More
Grégory Steulet

Errors while installing Oracle Database Vault on Oracle 11.2.0.3

By | Database management | 2 Comments
 

 During one of my last consulting missions, I had to install Oracle Database Vault on an existing Oracle environment. It clearly was not a straigthforward process, since I experienced some weird errors such as: ORA-28003: password verification for the specified password failed, ORA-20001: Password length less than 8, and ORA-01917: user or role ‘LBACSYS’ does not exist. After having a look at several log files, I found the root causes of this error. Below, you…

Read More
David Hueber

Oracle 12c Backup & Recovery: What’s new?

By | Database management | One Comment
 

  After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most remarkable change in this brand new version is the Pluggable Database or so called Multitenant Database concept, which is a huge change in the whole RDBMS architecture. So what does it offers in terms of…

Read More
Stephane Biehler

A comparison of Java Virtual Machines: Hotspot JVM vs JRockit JVM

By | Application integration & Middleware | 11 Comments
 

 You might know that there are many JVMs available today, but do you know the difference between them? In this blog I will not state all JVMs as it will take too much time But I will talk about Hotspot and JRockit, because they are pretty used and because they will eventually merge in Java 8! That’s what they say at least… What’s a JVM? Well this is a reminder and you might want to…

Read More
Stéphane Haby

SQL Server 2014: AlwaysOn-Verfügbarkeitsgruppen – jetzt mit Microsoft Cloud!

By | Database management | No Comments
 

  SQL Server 2014 bietet jetzt (oder bald :roll:) die Möglichkeit der Integration von AlwaysOn-Verfügbarkeitsgruppen mittels virtueller Maschinen, gehostet in der Windows-Azure-Infrastruktur (IaaS). Sie können sekundäre Datenbanken direkt in der Cloud vorhalten, wie das Beispiel zeigt: Der Einsatz von asynchroner sekundärer Replikation in der Cloud ist durch die Integration des Assistenten in SQL Server Management Studio (SSMS) erleichtert worden. Was sind die Vorteile dieser Entwicklung? Der erste Vorteil ist Kostensenkung, wenn Sie Ihre Hochverfügbarkeitslösung erweitern…

Read More
Oracle Team

Oracle Database 12c: Moving a datafile is now possible online

By | Database management | 9 Comments
 

  Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online! Up to Oracle 11.2.0.3, you had three ways to relocate a datafile: Put the tablespace offline Put the datafile offline Shutdown and mount the database Oracle 11g: Tablespace offline Renaming a datafile…

Read More
Stéphane Savorgnano

High availability and disaster recovery on Windows Azure VMs

By | Technology Survey | No Comments
 

  To be honest, I am not a specialist of Windows Azure. In order to learn a little bit more about this subject, I decided to follow a TechEd Europe 2013 session about High Availability and Desaster Recovery on Windows Azure Virtual Machines. Overview of Windows Azure Windows Azure is Microsoft’s application platform for the public cloud. You have the possibility to use this platform in many different ways: build a web application that runs…

Read More