My Latin American Tour in March

At March I will be presenting my very successful seminar “Mastering Backup and Recovery” in some countries of Latin America for the very first time. Thank you Panama, Chile and Brazil OUGs for inviting me to your amazing countries!

laouc.fwOracle_Magazine_Editors_Choice_Awards

Please, use the following links for registration and also to find more information about the seminar:

  • Panama City, Panama – March 17-18 (2014) Click Here
  • Porto Alegre, Brazil – March 20-21 (2014) Click Here
  • Sao Paulo, Brazil – March 24-25 (2014) Click Here
  • Santiago, Chile – March 27-28 (2014) Click Here

Note: the next 10 people on each country to register before February 15 will receive a free signed copy of my book “Oracle Database 12c Backup and Recovery Survival Guide”

Regards,

Francisco Munoz Alvarez

Posted in 11gR2, 12c, Books, General, News, Others, Questions, Tutorials

Join me at the next OTN Virtual Developer Day

260032_otn_virtual_dvlper_day_bnr_733w

 

 

Hi All,

On February 4, 2014 at 9:30 am PT I will be talking on the next OTN Virtual Developer Day about Oracle VM and Oracle Database. Come and discover the answers for the following questions:

  • Does an Oracle Database perform well on a virtualized environment?
  • What virtualization technology is more stable and allows an Oracle database to perform faster?
  • What is the performance difference between using a bare metal and a virtualized guest?
  • Is it safe to run a production database in a virtualized environment?

Come and join me on this fantastic event. Registrations and more information here.

Regards,

 

Francisco Munoz Alvarez

Posted in 11gR2, 12c, Cloud, General, Links, News, OVM, Questions, Tutorials, Virtualization

Problems when doing a V2V or P2V of a windows server to Oracle VM

Some time ago, I received the request to migrate some Windows 2008 Servers to my Oracle VM farm and after complete the P2V migration the newly create VM would not start. It would crash on boot with blue screen and error:
STOP: 0x0000007B (0xXXXXXXXX,0xXXXXXXXX,0×00000000,0×00000000)

This issue is related to the storage drivers needed for the guest VM, and to solve this issue you should do the following on your Windows Server before start the P2V or V2V migration:

  1. Extract the Atapi.sys, Intelide.sys, Pciide.sys, and Pciidex.sys files from the %SystemRoot%\Driver Cache\I386\Driver.cab file, copy the files to the %SystemRoot%\System32\Drivers folder.
  2. Merge this register file (NOTE: You would need access to My Oracle Support to be able to download it)
  3. Turn off the virtual machine, and then try import it to OracleVM again.

You can also find more information regarding this problem on the following Microsoft link:

http://support.microsoft.com/kb/314082

Hope this would help you if having the same issue I had.

 

Regards,

 

Francisco Munoz Alvarez

Posted in Cloud, General, Migrations, OVM, Virtualization

Joint Webinar with Oracle – Top 5 Key Reasons Why Oracle VM is Best for Oracle Database

Top 5 Key Reasons Why Oracle VM is Best for Oracle Database

ovm_hq_revera

When: Tuesday December 17th , 10am PST

Register Here:

http://event.on24.com/r.htm?e=725350&s=1&k=1512E332202610FE9518AB8B01354C6A&partnerref=Francisco

Oracle VM application-driven architecture is designed for rapid deployment and ease of lifecycle management providing IT a highly scalable and cost effective virtualization solution for Oracle Database and business-critical applications.

Join us in this webcast featuring Francisco Munoz Alvarez, a seasoned expert, and Oracle ACE Director as he shares his performance benchmark findings highlighting key reasons why Oracle VM is the best virtualization technology for Oracle Databases.

Posted in Cloud, General, OVM, Virtualization

My book: Oracle Database 12c Backup and Recovery Survival Guide

It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote with the help of my good friend Aman Sharma.

I would also take this opportunity to recognize the great work done by many good friends involved in the technical review of the book:

  • Tom Kyte
  • Arup Nanda
  • Robert Freeman
  • Laurent Schneider
  • Gokhan Atil
  • Wissem El Khlifi

Thank you so much my friends for all comments, suggestions, corrections and support during this long journey!

You can pre-order the book here: http://www.packtpub.com/oracle-database-12c-backup-recovery-survival-guide/book

1201EN_mockupcover_normal_0.jpg

Here is some information about the book:

The three main responsibilities of a successful DBA are to ensure the availability, recoverability, and performance of any database. To ensure the recoverability of any database, a DBA needs to have a strong backup and recovery skills set. Every DBA is always looking for a reference book that will help them to solve any possible backup and recovery situation that they can come across in their professional life.

Oracle Database 12c Backup and Recovery Survival Guide has the unique advantage to be a reference to all Oracle backup and recovery options available, making it essential for any DBA in the world. If you are new to Oracle Database, this book will introduce you to the fantastic world of backup and recovery that is vital to your success. If you are an experienced DBA, this book will become a reference guide and will also help you to learn some possible new skills, or give you some new ideas you were never aware about. It will also help you to easily find the solution to some of the most well known problems you could find during your career as a DBA. This book contains useful screenshots, scripts, and examples that you will find more than useful.

Most of the books currently available in the market concentrate only on the RMAN utility to backup and recovery. This book will be an exception to the rule and will become a must-have reference, allowing you to design a real and complete backup and recovery strategy. It covers the most important topics on Oracle database such as backup strategies, Nologging operations, new features in 12c, user managed backups and recoveries, RMAN (including reporting, catalog management, troubleshooting, and performance tuning), advanced data pump, Oracle Enterprise Manager 12c and SQL Developer.

"Oracle Database 12c Backup and Recovery Survival Guide" contains everything a DBA needs to know to keep data safe and recoverable, using real-life scenarios.

Posted in 12c, Backup & Recovery, Books, DBA Career Tips, General, Interview Tips, Others, Questions, Scripts, Tutorials, White Papers

Why use OVM for Oracle Databases

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 is more stable and allows an Oracle database to perform faster?
  •  What is the performance difference between using a bare metal and a virtualized guest?
  •  Is it safe to run a production database in a virtualized environment?

Here you can find the results and the answers to the questions above: http://oraclenz.org/wp-content/uploads/2008/06/Why-use-OVM.pdf

 

Regards,

 

Francisco Munoz Alvarez

Tagged with: , , ,
Posted in Cloud, General, News, Others, OVM, Virtualization, White Papers

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 .

SnapCrab_NoName_2013-7-1_20-33-26_No-00

2 – Unselect the option [I wish to receive security updates via My Oracle Support] and click [Next]. Of course, if you want to receive updates all you need to do is to leave this option marked and enter your My Oracle Support email and password.

.SnapCrab_NoName_2013-7-1_20-34-0_No-00

3 – You will receive a warning message that you have not provided an email address. Just click on [Yes].

SnapCrab_NoName_2013-7-1_20-34-27_No-00

4 – Select [Skip software updates] and click [Next].

SnapCrab_NoName_2013-7-1_20-34-46_No-00

5 – Select [Create and Configure a Database] and click [Next].

SnapCrab_NoName_2013-7-1_20-35-8_No-00

6 – Select [Server Class] and click [Next]. *** If you do not have enough resources on your laptop, please choose Desktop Class instead of Server Class.

 SnapCrab_NoName_2013-7-1_20-35-30_No-00

7 – Select the type of Database to be installed, choose [Single instance database installation] and click [Next].

 SnapCrab_NoName_2013-7-1_20-35-49_No-00

8 – Select the Install type. For this lab I will choose [Advanced Install] and click [Next].

 SnapCrab_NoName_2013-7-1_20-36-7_No-00

9 – Select the product Language, here all you need to to is leave English as the default and click [Next].

 SnapCrab_NoName_2013-7-1_20-36-24_No-00

10 – Select the Database Edition you want to install. Select [Enterprise Edition] and click [Next[.

 SnapCrab_NoName_2013-7-1_20-36-38_No-00

11 – Specify the Installation location and click [Next].

 SnapCrab_NoName_2013-7-1_20-36-53_No-00

12 – Create the Inventory and click [Next].

 SnapCrab_NoName_2013-7-1_20-37-15_No-00

13 – Select the type of database you want to create. Select [General Purpose] and click [Next].

 SnapCrab_NoName_2013-7-1_20-37-28_No-00

14 – Specify the database identifiers, enter “orcl” as the SID and here you can decide if you want to create a Container Database or as early releases a non-Container Database (by not selecting [Create as Container database]. For this example we will select Container database and create a Pluggable Database called “pdborcl” and click [Next].

 SnapCrab_NoName_2013-7-1_20-37-48_No-00

15 – Specify the configurations options, by default the Automatic Memory Management is enabled, click [Next].

 SnapCrab_NoName_2013-7-1_20-38-3_No-00

16 – Specify the storage to be used. Select [File System] and click [Next].

 SnapCrab_NoName_2013-7-1_20-38-26_No-00

17 – Management options. If you have an EM Cloud Control running on your environment, here is where you specify the EM details to manage this database. Leave as the default and click [Next].

 SnapCrab_NoName_2013-7-1_20-38-40_No-00

18 – Enable Recovery and click [Next].

 SnapCrab_NoName_2013-7-1_20-39-14_No-00

19 – Specify Passwords. For this scenario we use the password “oracle” to all accounts. Click [Next].

 SnapCrab_NoName_2013-7-1_20-39-38_No-00

20 – A warning will appear due that we are using a easy password. Click [Yes].

 SnapCrab_NoName_2013-7-1_20-39-53_No-00

21 – Click [Next] on Privileged Operating Systems groups.

 SnapCrab_NoName_2013-7-1_20-40-7_No-00

22 – Review the Summary page and click [install].

 SnapCrab_NoName_2013-7-1_20-40-35_No-00

 SnapCrab_NoName_2013-7-1_20-41-28_No-00

23 – Execute the configuration scripts as root and click [Ok] to continue the installation.

 SnapCrab_NoName_2013-7-1_20-43-51_No-00

 SnapCrab_NoName_2013-7-1_20-44-33_No-00

 SnapCrab_NoName_2013-7-1_20-45-15_No-00

 SnapCrab_NoName_2013-7-1_20-45-52_No-00

 SnapCrab_NoName_2013-7-1_20-51-35_No-00

24 – In the Finish page click [Close].

 SnapCrab_NoName_2013-7-1_20-52-3_No-00

25 – Edit /etc/oratab as follows.

 SnapCrab_NoName_2013-7-1_20-52-59_No-00

26 – Check the listener status.

 SnapCrab_NoName_2013-7-1_20-53-29_No-00

27 – Check if the Container Database is running.

 SnapCrab_NoName_2013-7-1_20-53-46_No-00

28 – Connect to the Enterprise Manager Database Express. It will first ask you to add a Security Exception in Firefox.

SnapCrab_NoName_2013-7-1_20-57-17_No-00

 SnapCrab_NoName_2013-7-1_20-57-30_No-00

29 – The Next step will be to download the Adobe Flash Player rpm and install it.

SnapCrab_NoName_2013-7-2_12-58-39_No-00

30 – Enter your database username and password. SYS and oracle and click [Login]

 SnapCrab_NoName_2013-7-2_13-1-6_No-00

31 – This is the First Screen of the new Enterprise Manager Database Express 12c. Here you are not able to use monitoring, set alertings or even execute backup and recovery operations. But you can do a lot of other stuff such  such as per example: Manage Storage such as: Undo, Redo Log Files, and Control Files, Configure Initialization Parameters, Memory  and Database Features and finally Manage  Performance, SQL Tuning and Users. and Roles (Security).

 SnapCrab_NoName_2013-7-2_13-47-36_No-00

SnapCrab_NoName_2013-7-2_13-44-55_No-00

SnapCrab_NoName_2013-7-2_13-45-27_No-00

SnapCrab_NoName_2013-7-2_13-45-56_No-00

SnapCrab_NoName_2013-7-2_13-44-21_No-00

 SnapCrab_NoName_2013-7-2_13-46-24_No-00

 SnapCrab_NoName_2013-7-2_13-47-3_No-00

 

Hope you enjoyed this tutorial and soon many more will come.

 

Regards,

 

Francisco Munoz Alvarez

//

Tagged with: , , , , , ,
Posted in 12c, General, Linux, Others, Tutorials, Virtualization
Follow

Get every new post delivered to your Inbox.