In a WebLogic server domain set as a Production domain, when we try to connect to the Node Manager with WLST we get the following error:

This blog gives the solution to solve the issue.

En 2012, les principaux systèmes de gestion de bases de données relationnelles (SGBDR) sur le marché sont propriétaires. Nous parlons régulièrement d'Oracle Database, MySQL, Microsoft SQL Server. En dehors de ces solutions commerciales, il existe un SGDBR open-source largement utilisé: il s'agit de PostgreSQL et il est l'objet de cet article.

Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.

In my previous article, I announced the first fix for SQL Server 2012.

One week later, the first cumulative update is available on the Microsoft website.

With the appearance of WebLogic Server as Oracle application server and the emergence of the Oracle Fusion Middleware suite, some may wonder what will be the support of their Oracle Internet Application server license, e. g. Oracle Forms and Reports services, Business Intelligence Edition, etc. As a consultant, I am often dealing with these kinds of problems and aiming to improve license benefits. In this post, I want to focus on Oracle Internet Application server licenses.

Who never had to measure the disk performances on a system?

Speaking about Linux performance monitoring includes a significant part of disk performances. If you are facing applications or databases running slower than expected or than on other environments, you may take a look on the I/O performances.
This posting aims to provide an introduction to a pretty interesting tool: IOzone.

Even if we (dbi services) usually advise to setup Oracle Enterprise Linux for Oracle deployments on Linux, it might appear that some customers still prefer other certified distributions such as SuSE Linux Enterprise Server (SLES). This post describes the configuration of the tmpfs filesystem size on SuSE Linux Enterprise Server 11.0 (SLES 11, without any service pack) in order to use the Oracle 11.2 Automatic Memory Management feature (AMM) through the Oracle instance parameter memory_target.

Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.

In this post, I will describe how to migrate from Oracle APEX 3.0 to Oracle APEX 4.1. I will also focus on some encountered problems as well as the new features of Oracle Application Express (APEX) 4.1.

Le marché du Database Activity Monitoring (DAM) devenant de plus en plus important avec des produits tels que Imperva, Guardium ou Sentrigo, je me suis intéressé au produit Oracle Database Firewall, qu'Oracle présente comme un substitut aux différents acteurs du marché des DAMs.

Oracle has introduced three new caching features in its Oracle 11g release:

• Query result cache
• Client OCI result cache
• PL/SQL function result cache

In this posting, I will present the query result cache feature.

Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: "This zip does not include JRE" or "This zip file includes the JRE". On linux, the choice is limited because the only version available doesn't include Java Runtime Environment. And it's an RPM !! So what... In this post I will provide all information required to install and run these tools on an Ubuntu machine.

Last week at a customer site, we experienced an excessive redo log generation rapidly filling up the FRA (Flash/Fast Recovery Area) with archivelog files. This eventually caused the database to crash.

Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis or because the execution plan changed. Oracle offers two methods: statistics restore or statistics export. Both are in the dbms_stats package.