Creating a VMware Workstation For Oracle Database Installation

posted January 6, 2016, 4:44 PM by

Andy Kerber, Senior Consultant

In this article we are going to cover how to create a VMware workstation to be used to install the Oracle database software. We are going to use VMware workstation 12, and Oracle Enterprise Linux 6.7. Please note that VMware workstation is absolutely not suitable for true business applications. While it can be very useful for learning Oracle methods and techniques, it is absolutely not suitable as an enterprise (or even small business) platform for Oracle.

This article assumes that you have VMware workstation properly installed on your PC. The minimum hardware I recommend for VMware workstation is 16G RAM, 2 TB HD, and a quad core processor.   My laptop has 32G RAM and my desktop has 64G RAM. Remember that you will need to run both, in order to use this virtual machine and still be able to do your regular work, so sufficient resources are critical.

The first step is to create an account on the Oracle web site.   Proceed to oracle.com, and choose Sign In/Register to create an account. No payment is required.

Step 1: Download the Oracle Enterprise Linux software

After creating an account, proceed to eDelivery.oracle.com to download the Oracle Enterprise Linux software:

Oracle-Linux

From there, sign in and proceed to the next screen:

Oracle-Linux-2

Choose your product, and select the platform.

Oracle-Linux-platform

OEL 7.1 will come up as the default, choose a different version and select version 6.Oracle-Linux-6-7
For installation, the best choice is the just the OEL 6.7 DVD, V77197-01.iso

S1_File-Download

S1_File-Download-2

Once the download is complete, you can begin the creation of your virtual machine. It does not download as a zip file, so it is not necessary to extract any files.

Step 2: Create the Virtual Machine

Start the wizard by choosing, File->New Virtual Machine in the VMware menu. Choose a custom VM.

S2_New-Virtual-Machine

Hardware compatibility isn’t particularly critical, but choosing the most recent version is best.

S2_Virtual-Machine-Hardware

Next, when it comes to guest operation system installation, choose the Installer disc from disk image file. Point this to the OEL installation ISO you just downloaded.

S2_Virtual-Machine-Wizard

Choose a virtual machine name. This is just the name that you will see on the VMware workstation menu, so the name you choose is not critical.

S2_Virtual-Machine-Wizard2

Since this is on your personal computer, you do not want to dedicate a lot of resources to it. Therefore, one processor is appropriate.

S2_VM-Processor-Config

For an Oracle installation, 8G RAM is really the minimum in order to get enough performance to do any kind of work at all.

S2_VM-Memory

If you have a home router, it is often best to use bridged networking so you can make sure that your test Oracle server has the same IP address all the time. If you are not concerned about this, you can use NAT.

S2_VM-Network-Type

Choose the default controller.

S2_VM-Controller-Types

Select the disk type of SCSI.

S2_VM-Disk-Type

Normally you will create a new virtual disk.

S2_VM-Select-Disk

40G is the absolute minimum size for the installation. Remember you will need space for the Oracle binaries, swap space, temp space, and the Linux operating system. Therefore for best performance, allocate all disk space upon creation. Otherwise substantial time will be spent whenever the disk needs to expand.

S2_VM-Specify-Disk

Make sure that there is sufficient space on your hdd for the virtual disk (VMDK).

S2_VM-Specify-Disk2

Review the configuration data, and proceed to create the virtual machine.

S2_VM-Create

There will be a substantial waiting period as the hard disk is pre-allocated.

S2_VM-Create2

Once the disk space is allocated, the VM will boot from the OEL ISO image specified earlier.

S2_VM-Create3

Step 3: Install the Oracle Enterprise Linux Software

Please note that with Enterprise level systems, normally this software will be installed using a puppet (or similar tool) to ensure that each installation is the same. This manual method should be used only for this sort of personal installation.

S3_Oracle-Linux-6

On the next screen, it is safe to skip the media test. Note that the mouse will not work on this screen, so you will need to use the tab and space bar or tab and enter key.

S3_Disc-Found

On the next screen, the mouse will work again, so use it to choose ‘next’.

S3_Oracle-Linux-6-2

On the next two screens, choose ‘English’, then ‘US English’.

S3_Oracle-English

S3_Keyboard

On the next screen, choose basic storage devices.

S3_Basic-Storage

If you get the message below, ignore it and discard the data. Any data on the VMDK is just blank disk space that once had valid data on it.

S3_Storage-Device

On the screen below, choose an appropriate name. Then choose configure network.

S3-Hostname

Click on the Ethernet device, and choose edit.

S3_Network-Connections

If necessary, set the IPV4 settings, and check the ‘Connect automatically’ and ‘Available to all users’ boxes. Then click apply.

S3-Editing-System

On the next screen, choose your time zone. I am in the central time zone, so I chose America/Chicago.

S3_Time-Zone

Choose a root password that you will remember and write it down.

S3_Root-Password

On the following screen, choose ‘use all space’, and make sure that the ‘review and modify partitioning layout’ box is checked. The partitioning must be modified for an Oracle installation.

S3-Use-All-Space

On the screen below, ensure that you have at least 8G swap. Note that if you have more than 8G RAM, swap should equal RAM up to 16G. At 16G RAM and more, only 16G swap is required.

S3-Select-Device

Click next and write changes to disk.

S3-Select-Device-2

Accept the defaults on the following page.

S3_Install-Boot-Loader

On the next screen choose database server, click on the customize now radio button, and then click next.

S3-DB-Server

With servers highlighted, choose the packages shown on the right. Click on the ‘optional packages’ button.

S3-Server-Platform

Under optional packages, choose the packages below. This will make your eventual Oracle installation much easier.

S3-Packages_SysAdmin

Next, under Desktops, choose the items shown on the right: Desktop, Desktop debugging and performance, Desktop Platform, fonts, general purpose desktop, graphical administration tools, and X-Windows system.

S3_Desktop-Platform

S3-Desktop_Windows-Systems

Next, the system will be configured and your chosen packages will be installed.

S3_Install-Packages

When installation is complete, you will be prompted to reboot the system.

S3_Reboot-System

Next, it will take you through a few more steps in order to complete installation.

S3_Install-Welcome

After clicking forward, accept the license if you choose (of course you cannot proceed until you accept it).

S3-Install_License-Info

Next comes the software updates setup screens. If you have purchased Oracle Enterprise Linux you can enter that information at this time. If you have not, you will be set up with the public OEL Yum repository by default.

S3-Software-Updates

Oracle really wants you to sign up for the OEL network. The last time I checked, it cost about $100/year, so its not necessarily cost prohibitive. However, the price has probably changed since I last checked, so you will need to check with Oracle to confirm the cost if you are interested in paying for a license.

S3-firstboot

S3_Finish-Updates

Skip the following screen. The Oracle database packages chosen earlier will create the Oracle user, and this article will show the activation of the Oracle user.

S3_Create-User

For data and time, choose the network synch option (if this VM will be able to access the internet). Otherwise, you can try synching with your computer (local time source), or just skipping this option.

S3_Date-Time

Enable kdump if you choose, and reboot the machine.

S3-Kdump

S3-Kdump2

S3-Kdump3

Step 4: Complete the VM Configuration for Oracle

After reboot is completed, there are only a few steps remaining to configure the VM.

First, enable the Oracle user. The Oracle user has been created in the appropriate group and with the required privileges, but it is impossible to log in to the account. To enable the account, do the following:

  1. Log in as root
  2. Enter the command: passwd oracle
  3. Enter the Oracle password
  4. Reenter the Oracle password when prompted
  5. At this point ,the account is enabled and the Oracle user can log in using the password you provided:
[root@oel64node Desktop]# passwd oracle
Changing password for user Oracle.
New password:
BAD PASSWORD: it is based on a (reversed) dictionary word
Retype new password:
passwd: all authentication tokens updated successfully.
[root@oel64node Desktop]#

 

Next, still logged in as the root user, install the available updates. To do this, enter the command “yum –y update”. This command will take quite a bit of time to complete as all the available updates are installed.

passwd: all authentication tokens updated successfully.
[root@oel64node Desktop]# yum -y update
Loaded plugins: refresh-packagekit, security, ulninfo
Setting up Update Process

. . .

Finally, install the kernel header and development kernel packages:

yum –y install kernel-uek-headers kernel-uek-devel

After the above packages are successfully installed, reboot the VM.

Step 5 is not critical, but will make the VM easier to use.

Step 5: Install VMware Tools

  1. Log in as root
  2. On the VMware menu, choose VMware->install VMware tools
  3. The VMware tools DVD will be mounted, so copy the .tar.gz file to the desktop of the virtual machine
  4. Extract the files: tar-zxvf *.tar.gz
  5. Change to the vmware-tools-distrib directory. (cd vmware-tools-distrib)
  6. Run the install program: ./vmware-install.pl
  7. Follow the prompts and accept the defaults (I generally do not install the agent, the thinprint driver, or the automatic kernel modules)
  8. After installation is complete, reboot, and you are ready to install Oracle
Share with your networkTweet about this on TwitterShare on LinkedInShare on FacebookDigg thisEmail this to someone

3 Comments

  • Gaurav says:

    Hi,

    What is the best practice to install a 1 Node RAC for Oracle 12c DB, if we want to go with cloning option.

    Regards,
    Gaurav

    • Andrew Kerber says:

      Hello. I do not understand the question. Can you explain what you mean by a 1 node RAC? and cloning option? Do you mean Oracle restart?

  • Hosting says:

    Hammerdb has a performance intensive load operation that is used to create OLTP transactional data in the database. We will compare the performance of this database load operation for compressed and non compressed tablespaces.

Leave a Reply

Your email address will not be published. Required fields are marked *

WANT TO LEARN MORE?

Share with your networkTweet about this on TwitterShare on LinkedInShare on FacebookDigg thisEmail this to someone