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…
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…
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,…
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.
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: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-41-new-features-459652.html
Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.
Last week I encountered the following problem while installing Oracle 11g R2 on AIX 6.1 TL06 SP2. I met all the PreReqs of the installation document, but at the end of the installation process, I got the following error message:
Error in invoking target ‘agent nmb nmo nmhs’ of makefile ins_emagent.mk’
Are you experiencing network access issues after a migration to Oracle Database 11g Release 2 (11.2)? If yes, you probably have to allow the concerned PL/SQL packages to access your network again. This posting will show you how.
Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the correct number. In this posting, I will show you how.
You have recently migrated to Oracle Database 11g Release 1 (11.1) and have had some issues with so called “mutexes”? Don’t worry, these nasty sounding mutexes (not mutants) can be handled quite easily as I will show in my post. But first of all, what are mutexes?