How to Solve: SQL Developer can’t start because MSVCR71.dll is missing (On Windows)

I have installed SQL Developer (with JDK) on Windows many times before, and almost all the time I receive the system error bellow when trying to execute it by the first time. Due to this, I decided to publish the solution to this annoying issue.

error_sqldeveloper

We can easily fix this issue by following these simple steps:

  1. Run regedit (remember to run it as the administrator)
  2. Expand HKEY_LOCAL_MACHINE
  3. Expand SOFTWARE
  4. Expand Microsoft
  5. Expand Windows
  6. Expand CurrentVersion
  7. Expand App Paths
  8. At App Paths, add a new KEY called sqldeveloper.exe
  9. Expand sqldeveloper.exe
  10. Modify the (DEFAULT) value to the full pathway to the sqldeveloper executable (See example below step 11)
  11. Create a new STRING VALUE called Patch and set it value to the sqldeveloper pathway + \jdk\jre\bin                                                                                                                                                                                                                                                                                                             regedit
  12. After the step 11 is completed, please enjoy your SQLDEVELOPER Smile

works

Hope this tip would help you to solve this issue too!

 

Regards,

 

Francisco Munoz Alvarez

Posted in General, Others, Questions, Tutorials

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
Follow

Get every new post delivered to your Inbox.