Infrastructure at your Service


Migration Archives - Page 4 of 4 - Blog dbi services

Oracle Team

Oracle et Dbvisit Replicate pour migrer sans arrêt de service… et sans stress

By | Hardware & Storage, Oracle | No Comments

By Franck Pachot . Je viens d’assister au Webinar Zero Downtime Migration pour Oracle, présenté par Chris Lawless qui est récemment passé de Product Manager Golden Gate à Product Manager Dbvisit.  Je vais détailler ici un point très important évoqué par Chris Lawless. La migration par réplication n’est pas seulement envisagée pour éviter un arrêt de service. Arrêt nécéssaire lors de la migration proprement dite (qui peut aller de quelques minutes à plusieurs heures en…

Read More
Oracle Team

Oracle Database 12c: Database Migration Assistant for Unicode

By | Technology Survey | One Comment

The choice of the correct character set before you create an Oracle 12c database is an important decision. You have to know the type of data you have to store and the languages needed by the Oracle database. Oracle recommends to choose Unicode for its universality and compatibility. It supports all written languages and most of the technical and scientific symbols. Before Oracle 12c changing the database character set was an pretty nasty task and…

Read More
Grégory Steulet

Mysqldump issue – SELECT command denied to user

By | Database management | One Comment

During one of my last MySQL mission, I encountered a “security error” with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users. In order to do that, I used mysqldump. During the import of the data, I got the following warning: ERROR 1449 (HY000) at line 1860: The user specified as a definer (‘cdadmin’@’%’) does not exist Following the migration,…

Read More
Arnaud Berbier

Upgrading your Oracle Internet Application Server license

By | Application integration & Middleware | No Comments

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.

Read More
Grégory Steulet

Oracle Application Express (APEX) 4.1: a migration guide

By | Application integration & Middleware | 5 Comments


Oracle Application Express – APEX 4.1 Introduces many new features such as :

  • Improved error handling and user-defined exception processing

  • Application Express now supports the use of ROWID for updates, inserts and deletes as an alternative to specifying primary keys

  • Developers can now easily add the capability for end-users to load spreadsheet data into existing tables within an application

  • The calendar wizards have been enhanced to include the ability to create an Edit page as part of creating the calendar

  • Building on their initial introduction in Release 4.0, the look and feel of Websheets in Release 4.1 has been substantially improved and the controls redesigned to make it more intuitive for users

A complete list of APEX new features can be found on:

Read More