Infrastructure at your Service

Oracle 11g Archives - Page 3 of 8 - Blog dbi services

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

Read More

Oracle Database 12c: Flashback Data Archive (FDA) – new features

By | Database management | 2 Comments

Oracle Database 12c was published in June and among the new features of this release are multiple improvements of the Flashback Data Archive (FDA), an option also known as Oracle Total Recall. In this post, I will present the new features coming with Oracle 12c. Overview Before speaking about these improvements, let me point out the main concept of Oracle FDA. Flashback Data Archive appeared with Oracle 11g and improved the flashback technology introduced with…

Read More
Oracle Team

Processor licensing for Oracle database on VMware ESX

By | Hardware & Storage | 2 Comments

In this post, I would like to share with you what I have learned about Oracle licensing particularities on a virtualization infrastructure (software partitioning) based on VMware ESX. Recently, I faced an Oracle licensing problem on a VMware ESX cluster on which I had to find a workaround in order to make the hardware comply with the customer’s licensing model. Without entering in details, the customer had a VMware cluster with three nodes and had…

Read More
Oracle Team

Oracle RAC 11.2.0.2: A disturbing loop in a “ohasd” startup script

By | Operation systems | No Comments

Last February, I performed an operating system rolling upgrade on a four-nodes RAC cluster (11.2.0.2). I then faced a strange problem when restarting the operating system… The first step of the procedure was to stop all Grid Infrastructure and Database services running on the first node as well as to disable Cluster and ASM autostart. The following command is supposed to prevent Oracle High Availability Service (OHAS) to be run at operating system startup: #…

Read More
Oracle Team

Scripts to duplicate an Oracle database virtual machine: step two

By | Hardware & Storage | No Comments

In January, I promised to show you the next step of a procedure to manage templates with Virtual Box. Don’t worry, I have not forgotten but I was very busy! This step, the final one, consists on customizing of a virtual machine configuration at the start. VMware does it with Templates on ESX, using for example Sysprep for MS Windows guests. I am going to show you how to do it with one simple text file….

Read More
Jérôme Witt

Wie kann ich Indexes und Daten mittels Data Pump trennen?

By | Database management | No Comments

Diese Frage habe ich in den letzten Jahren öfters gehört. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export/Import Tools. Angeblich war es früher mit dem Import-Parameter-Tool „INDEXFILE“ viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies möchte ich anhand eines ganz normalen Datapump-Export–Files verdeutlichen. In folgendem Beispiel handelt es sich um einen einfachen Schema-Export, der wie folgt erzeugt wurde: oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/ [DB112] cat expdp_SalesApp.par SCHEMAS=sh DIRECTORY=data_pump_dir DUMPFILE=expdp_SH_2013-02-17.dmp LOGFILE=expdp_SH_2013-02-17.log PARALLEL=4 oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/…

Read More
Oracle Team

Bug on Oracle 11.2 “ORION FAILS WITH ORA-27061″: Patch available!

By | Application integration & Middleware | No Comments

In march 2011, my colleague Gregory Steulet published an article about Simulating and testing I/O performances with Orion. In this article, he wrote about a bug concerning Orion on Oracle 11.2, reported in Oracle bug number 9104898: “ORION FAILS WITH ORA-27061: WAITING FOR ASYNC I/OS FAILED”. Trying to compare performances of storage devices on a virtual machine between a classical and a paravirtual storage adapter, I experienced the same error when using large IOs. I…

Read More
Yann Neuhaus

Configuration des options en Oracle 11g EE avec ‘chopt’

By | Database management | One Comment

La configuration des options sous Entreprise Edition avant Oracle 11g pouvait être un véritable parcours du combattant. Donc, une attention particulière devait avoir lieu avant l’installation des binaires Oracle; à savoir quelles options devaient être installées! Depuis la version 11g, les choses ont bien changé, grâce à l’utilitaire “chopt” se trouvant sous $ORACLE_HOME/bin. Voici la syntaxe d’utilisation de “chopt”: chopt [enable |disable] db_option db_option: dm = Oracle Data Mining dv = Oracle Database Vault lbac…

Read More
Yann Neuhaus

Oracle Automatic Memory Management: real memory usage!

By | Database management | One Comment

When using Automatic Memory Management for Oracle, it is sometimes difficult to monitor the memory usage and in particular to find the right tools to get the right information about currently allocated structures. The instance which will be analyzed has been configured with AMM (Automatic Memory Management) on Oracle Enterprise Linux 6.1. The current memory_target is set to 1 GB: SQL> show parameter memory_target NAME                                 TYPE        VALUE ———————————— ———– ———— memory_target                        big integer 1G  …

Read More
Oracle Team

Resource FAILOVER dans Grid Infrastructure

By | Hardware & Storage | No Comments

Dans le cadre d’un cluster Oracle Grid Infrastructure 11g R2 utilisé pour gérer des bases de données en mode FAILOVER, j’ai été amené à me pencher sur l’algorithme de basculement d’une ressource et des paramètres le régissant. On trouve dans la documentation Oracle des informations sur les cinq paramètres intervenant dans la prise de décision, à savoir: CHECK_INTERVAL: L’Intervalle de temps entre deux exécutions d’une action de vérification. RESTART_ATTEMPTS: Le nombre de tentatives de redémarrage…

Read More