Some time ago I made a benchmark exercise to compare the performance of an Oracle Database running in a bare metal environment versus a virtualized environment to clear some of the main questions our team and clients in Revera have, such as: Does an Oracle Database performs well on a virtualized environment? What virtualization technology…
Category: Others
Playing with VirtualBox, Oracle 12c (12.1.0.1) and OEL 6.4 – Part 2
We will complete our lab by installing the Oracle Database software, create a Pluggable database and take a look in the Oracle Enterprise Manager Database Express. The steps to install and create an Oracle Database 12c are: 1 – Go to the database directory created when unzipped the 2 Oracle Database Files and run /runInstaller…
Are you getting short of SCN?
Did you know that Oracle has determine that some software bugs (affecting databases between version 10.1.0.5 and 11.2.0.3) could cause the database to attempt to exceed the current maximum SCN value (The limit is currently 281 trillion) causing a transaction to be cancelled by the database, and the application would see an error message. But…
What is new in 12c for Backup and Recovery?
OOW has announced the new Oracle Database 12c, and this new version of the database product as expected has introduced many new features and enhancements for Backup and Recovery, on this post I will introduce you to some of them. Of course, I cannot start talking about 12c without talk first about a revolutionary whole…
DB Control/DB Console (OEM) Changing Hostname or IP Address
I just got a client that changed his server hostname and discovered that after this change he was unable to use the DB Control. To solve this problem you will just need to follow these simple steps: 1) Set $ORACLE_HOSTNAME to the old hostname: [oracle]$ export ORACLE_HOSTNAME=oc-oracle-prod.com 2) De-configure the old DB Console by running…
Playing with Oracle VirtualBox : How to add a new Disk
In this small Tutorial we will learn how to add a new disk to our Virtual Machine created in our previous tutorial. Add a new disk to the virtual machine is very easy, just follow the tasks bellow: First, with your virtual machine off click on Settings, than go to Storage , than you will…
Playing with Oracle 11gR2, OEL 5.6 and VirtualBox 4.0.2 (Final Part)
The idea of this tutorial is to show you how you can create an Oracle Database 11gR2 using Oracle VirtualBox and OEL. This installation should never be used for Production or Development purposes. This installation was created for educational purpose only, and is extremely helpful to learn and understand how Oracle works if you do…
My European Tour–May 2011
May will be a very busy month with several seminars and conferences in Europe. I’ll be presenting some seminars for the Oracle Celebrity Series in UK, Germany, Spain and Slovakia, and also will be presenting at User Groups conferences at Finland and Bulgaria. The links to register to my seminars are: May 9-10, UK –…
Bye bye 2010, Welcome 2011
First than all, I’ll like to apologize to all my friends and followers for the absence of posts on my blog for the last few months but this last months were very intense to me as you can see bellow. The 2010 was a great year full of great, fantastic and wonderful experiences and news,…