Archive for May, 2012

Installing Oracle Database 11g Express Edition and Other Applications in VirtualBox

May 31st, 2012 No comments

In this post I will detail step by step how to install few applications, which are taught in higher secondary school classes in Kerala for commerce stream on their computer application subject.  The applications include Oracle Database 11g Express Edition, Visual Basic and Tally.

 Downloading Oracle 11g:

Oracle Database 11g is of cause a product from Oracle , this Express edition is for Developers and home users. You can download the product from Oracles download page:

 Note that you need to register on the Oracle site (its free, you just need an email address) before you can start the download. When on the download page after logging in Accept the Licensee Agreement and click on the download for Windows x32, see the picture below which highlights the links for download, its around 300 Mb, the file will be a zip file with name OracleXE112_Win32



Once downloaded, extract the zip file and store it in your software collection folder, for this demo I have below collection as relevant to the Higher Secondary Commerce students “Computer Application” Subject requirements:


Accessing the Software Collection from inside virtual machine:

 Start our virtual machine MyWindowsXP and logon using our user account (this account should be super account, meaning it should have rights to install applications (Administrator account)


Copying the software collection to the MyWindowsXP Virtual Machine:

¬†¬†¬† From the “Devices” menu, select “Shared Folders‚Ķ”


    Click on the Add Shared Folder button


     From the new dialogue, select our folder of software and select Auto Mount and Permanent, then click on OK twice


     Restart the Virtual Machine MyWindowsXP

    Login back after the restart and open my computer, now you will see the software collection folder we shared as a Drive



 Installation of Applications:

 Installation of Oracle 11g and Basic Configuration:

 Memory Requirement: Oracle 11g Express requires at minimum 256 MB RAM (for the virtual machine here)


    Open the Drive of the shared folder, here as seen above the G Drive

    First unblock the Oracle Setup file, since it was downloaded from internet, Then Double Click on the Setup.exe 


    The following screen will appear


     Once the Extracting phase is completed the installation wizard will get started, click on Next to continue 


¬†¬†¬† Click on “I accept the terms in the license agreement” and click on Next


     You can leave the default location of the installation and click on Next


     Type a database password in both fields, this can be something like pass and click on Next


     Click on Install button to start the installation


     It will take a while to install the software


     And once installation is done, in one or two minutes, the wizard should complete service configuration and other basic system default settings, including creation of Desktop and Start Menu short cuts 


     Once completed, click finish to close the install wizard


Configuring your Oracle 11g to use it like SQLPlus

     Customizing the SQL Command line Interface to look like Old SQLPlus Interface

¬†¬†¬†¬†¬†¬†¬† Start SQL Command Line Tool from Start Menu – Programs – Oracle Database 11g Express Edition – “Run SQL Command Line”


         The command line tool is actually the original sqlplus.exe, but not the totally same as in Oracle 8i but an improved newer version


        In Oracle 8i, it was by default white background and black color font, so we will change it to the old style

        Click on the top left corner of the SQL Command Line window and select Properties


¬†¬†¬†¬†¬†¬†¬†¬† From the properties windows go to “color” tab and select Background color and click on White


         Then select Screen Text and click on Black, and then click ok to save the changes


¬†¬†¬†¬†¬†¬†¬†¬† Select “Modify shortcut that started this window” and click Ok


         Now the tool will look the old SQLPlus


        Creating a Desktop Shortcut

        Go to Start -> All Programs -> Oracle Database 11g Express Edition

¬†¬†¬†¬†¬†¬†¬† Then Right Click on “Run SQL Command Line”¬† and select “Send To”

¬†¬†¬†¬†¬†¬†¬† Then select “Desktop (create shortcut)”


        Once done, you will have a shortcut like below

¬†¬†¬†¬†¬†¬†¬† Right click and select “Properties”


¬†¬†¬†¬†¬†¬†¬†¬† Go to “General” tab, and replace “Run SQL Command Line” with “SQLPlus”

        Click on OK to complete


         Now you have a new short cut just like old SQLPlus



Creating a User and Password just like what was taught in school (scot / tiger)

         Open SQLPlus

        And login as SYSTEM


¬†¬†¬†¬†¬†¬†¬† At the first prompt, type “connect” ¬†and hit Enter

¬†¬†¬†¬†¬†¬†¬† You get a prompt as “Enter user-name:” type “SYSTEM” and hit Enter

¬†¬†¬†¬†¬†¬†¬† Now you get a prompt as “Enter password:” type the password you gave during installing Oracle 11g here “pass” so type “pass” and hit Enter


¬†¬†¬†¬†¬†¬†¬† If its successful, you will get response saying “Connected.”



        Creating a new user:

        User Name: scot

         Password: tiger


     Command to run:


              Where scot is the user name and tiger is the password


              Where scot is the user name



Some Tests:

  1. Creating a Table
  2. Inserting some data
  3. Displaying the information in the Table



          Connect as scot with password as tiger


           Creating a table of called people


            Inserting records into a table


            Querying for the records



 So that’s it about using Oracle 11g and doing whatever you did with Oracle 8i for the basic SQL Practice.


Installation of Microsoft Visual Basic 6:

 Using shared folder or CD, access the VB source file from Virtual Machine.

Double click on setup to start the installation


 Click on Next to continue

 Accept license agreement and click on Next

 Enter the product ID Number and click Next

¬†Select “Install Visual Basic 6.0 Professional Edition” and click on Next

 Use default and click Next

 Click on Continue

 Click OK

¬†Click on “Typical

 If you are getting prompt like below (its most of the time due to missing help file) just click on Ignore


Setup Progress


You might get some warning or error at the end and a message like below telling it was not completed successfully – Click on OK and Restart the Virtual Machine


After restart, login and open Visual Basic from the Programs Menu

 You can work with your VB Projects on this.

Note:- There are chances of issues when Oracle 11g and VB 6 are together on a Windows XP Virtual Machine, if you are having difficulty, then solution is to use a separate Virtual Machine for Visual Basic use.


Installation of Tally 7.2:

 Double click Install.exe from the source file of Tally 7.2

 Note where the application is getting installed by default and click on Install

 A quick status appears, and it completes Рclick on OK to complete

 If you have a serial key, enter it while first time start, or if you have a crack run it.

A desktop icon is created, click on it to open and start working Tally


Ok, so that concludes this article on using these applications in a Virtual Machine for some practice

 Enjoy learning and do provide your comments and feedback if there are any.


Categories: Virtualization Tags: ,

Installing Windows XP in Oracle VM VirtualBox

May 30th, 2012 4 comments

Here is a step by step instructions on how to install an Operating System  inside Oracle VM VirtualBox.  We are using a Windows 7 PC where Oracle VM VirtualBox is installed ( for instructions on how to install VirtualBox read this post ).  The operating system (called the Guest OS) can be any supported Operating System by VirtualBox, but for the purpose of demonstration we will be installing Windows XP inside a VirtualBox VM.

 So, lets get started:

 First Things First :

You need to have Windows XP CD or an ISO Image of the CD

You need to have the Serial Number of the Product

For a better performance of your system while running the VirtualBox and OS inside, you need to have 1GB RAM


Part 1: Creating a Virtual Machine

Virtual Machine will act as computer system inside VirtualBox, on this machine we will have hard disks, memory (RAM), CD ROM etc. But everything is virtual :-) don’t get confused, go ahead with below instructions

 From start menu, start Oracle VM VirtualBox

 From the Oracle VM VirtualBox Manager window click on New, a new wizard will be started

 Click Next

Give a name for our Virtual Machine in the Name field, here we call it MyWindowsXP.¬† From Operating System menu select “Microsoft Windows” and under Version select “Windows XP” and then click on Next


 Now select how much Memory (RAM) should be given to the Virtual Machine, this is the amount of RAM shared from the Physical Machine (our Windows 7 PC) to the Virtual Machine (our MyWindowsXP Machine), if you have 1GB RAM then allocate at least 512MB to the virtual machine. If you have more RAM you can allocate more memory to Virtual Machine

 We got RAM for our Virtual Machine, as any other physical machine required, now we also need a Disk to install Operating System and store Data, leave the default check boxes to create a new Start-up Disk and click Next

¬†Select “VDI (VirtualBox Disk Image)” and click Next.

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† You can also select “VHD (Virtual Hard Disk)” which will give you some added usage, such as mounting it on your Windows 7 just as a normal Disk in Disk Manager. That‚Äôs for an Advanced User, you can go ahead with the VDI option now.

Select Dynamically Allocated, and select Next

 Note:-   You need to have free space on your Windows 7 to store your Virtual Disk File (yes its stored on your Windows 7 PC as a File of extension VDI

                             a) Dynamically allocated: Starts with a new file and grows when ever new data is stored inside Virtual Machine

                             b) Fixed size: in this wizard itself, the file is created to its maximum size (such as if we select 20 GB then a file of 20 GB is created now itself)

 You can leave the default name and location of the Virtual Disk, and Select the amount of GB to be used for the Virtual Disk, for Windows XP you can keep 8 or 10GB, which will suffice most of the basic usage.

 You can review the settings provided for the Virtual Disk and click on Create to continue

 Final chance to continue or cancel the process of creating our new Virtual Machine, Click on Create to create the Virtual Machine

 This is how it looks on the Virtual Box:

 Have a look at the files behind this Virtual Machine, understand by default where the Virtual Machine files are stored, and what are the basic important files

Right Click on the virtual machine and select “Show in Explorer”


Changing Network Adapter Settings:

Note:- This is only required if your Windows 7 is your official laptop/desktop.

By default the virtual machine uses NAT (masking physical network) hence this Virtual Machine (MyWindowsXP) will be directly visible on the Network where the Physical Machine (Windows 7 PC) will be visible.

If its your home PC, below step is not required.

¬†Right Click on the MyWindowsXP and select “Settings”

¬†Go to Network option on the left, and then select “Host-only Adapter” from the “Attached to:” drop down list, by default it will be NAT.



Part 2: Installing the Operating System (Windows XP)

Now that we have the machine (virtual machine) with required Memory, Disk, and CPU we need to install the Operating System now.

 Insert the Windows XP (or which ever operating system you are installing) CD or Attach a CD Image (ISO File)

Right click on MyWindowsXP and select Settings

              Using a CD:

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† From Settings, Select Storage, then click on the CD Icon “Empty” on the right side -

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† Click on the small CD menu and select “Host Drive ‚Ķ” (in my machine its D:”

               Then click on OK


              Using a CD Image (ISO File):

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†From Settings, Select Storage, then click on the CD Icon “Empty” on the right side -

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† Click on the small CD menu and select “Choose a virtual CD/DVD disk file‚Ķ.”


            Select the CD iso file and select Open


             Click on OK to Finish:



Power on the Virtual Machine (MyWindowsXP)

      Select the virtual machine and then click on Start


       Select to not show the message again and click on OK


       The system loads


       The virtual machine load from the CD/ISO attached and Windows Setup Begins


       Since this is for a practice purpose, we will just create one Disk Partition, so Just Press Enter from the Virtual Machine to use complete disk space allocated (here 10GB)


      Select the Third option for NTFS (use down arrow) and hit Enter to continue


       Setup will format the disk now, it will take less than one minute


       Once formatting is done, setup start file copy process, takes around 2 minutes


       Once file copy is done, setup restarts the virtual machine automatically

      DO NOT Press any key, let the setup continue


       Setup starts to install the operating system


       Installing Windows Starts, this will take a couple of minutes so be with patience


      Provide a Name and Organization Name and click on Next, you can see it will take around 30 minutes to complete


       Give a name to our virtual machine something like MYXP and a password for administrator account, I gave 123 as a simple password, you can make is blank also Рclick on Next to continue


       Now the Installation continues to next steps


       Setup now does finalizing steps, we are almost there


      Once done, machine restarts, leave it to continue


       Click OK to the Display Adjustment prompt


      Please read the message, and click OK or Cancel



¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† On some Windows XP installations, Before getting onto below Logon screen you might get few other screens for configuring network or user settings, for all the steps if there is “Skip” button, click on Skip otherwise just click on Next, and for user account name, provide a user name.

       Click on the User Account to login and if there was a password assigned, enter it


      System Logs you in and loads a windows profile for you and then presents you the Desktop


      This completes our Windows XP base Installation.  Now we will run through basic configurations to be done to make our XP machine a working platform.  Follow below instructions to complete these.

      Installation of Guest Additions (this will make working on Virtual Machine smooth and easy

¬†¬†¬†¬†¬† From Devices menu, select “Install Guest Additions‚Ķ”


       A wizard for the Guest Tools Installation gets started, click Next to continue  


      Click Next


       Click on Install


      Setup progress


¬†¬†¬†¬†¬† During the Additions installation you might get multiple prompts like below, always click “Continue Anyway”


¬†¬†¬†¬†¬†¬† Once completed, select “Reboot now” and click on “Finish” or Hit Enter

      After Reboot, Login to the Virtual Machine


       Disabling Security Feature:

      Once on the desktop, double click on the Security Center


¬†¬†¬†¬†¬† Scroll down and click on “Windows Firewall”


¬†¬†¬†¬†¬† Select “Off (not recommended)” and then click OK


¬†¬†¬†¬†¬†¬† Click on “Automatic Updates” now


¬†¬†¬†¬†¬†¬† Select “Turn Off Automatic Updates.” and then click on Apply and OK

       Close the Security Center window


       This completes our basic configuration of the XP machine.


Working with Virtual Machine in Oracle VM VirtualBox

      How to start a Virtual Machine?

           Select the Virtual Machine to start and click on Start Button


¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† If you get a prompt like below, select “Do not show this message again” and click on OK¬†


      How to login to your Virtual Machine?

          Once started, click on the User Account to logon, if asked for password provide your password



     How to make the screen Full Screen?

¬†¬†¬†¬†¬†¬†¬†¬†¬† On the view menu, select “Switch to Full Screen”


¬†¬†¬†¬†¬†¬†¬†¬†¬† Click on Switch to switch to full scree, and the key to switch back to window mode is “Right Ctrl” + F¬† (Right Ctrl – it‚Äôs the Control Button on the right side of the keyboard)

¬†¬†¬†¬†¬†¬†¬†¬†¬† If you are sure to remember the Key Combination for future use, then you can select the check box “Do not show this message again” so that this dialogue is not shown again.


     How to perform a Ctrl + Atl + Del  to the Virtual Machine?

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† On the Machine menu select¬† “Insert Ctrl-Alt-Del” or you can press “Host+Del”

           Host is by default Ctrl Key so its Ctrl+Del



     What are the options to Shutdown or Stop running virtual machine?

             When you are done with working on the Virtual Machine, click on the close button on the window


      Below options appear, see explanation below and select the correct option and click on OK

  1. Save the machine state
    • If you select this option, what ever is kept open inside virtual machine or any running program are kept running and the state of the Virtual Machine is saved,
    • The Next time you start the virtual machine, it will be having all the open files and programs as it is while running.
    • Its always good to close all open applications and files before closing the virtual machine
  1. Send the shutdown signal
    • This option is similar to selecting Shutdown option from Start Menu
    • The system is shutdown properly and virtual machine is closed
  1. Power Off the machine
    • This is same as, pressing the power button on the Physical Machine CPU
    • All open files and programs are not saved and will be closed



     How to start a Saved Virtual Machine?

              If you have Saved virtual machine, you can start it like below by clicking on Start, just as starting a virtual machine which is powered off


 Note:- if you are getting any error while starting the saved virtual machine, you can Discard the saved state, what this does is something like switching power off without closing all open files and applications.

     How to discard the Saved State of a Virtual Machine?



     How to insert a CD onto the Virtual Machine?

           Using the physical CD/DVD Drive and accessing it inside Virtual Machine:

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† Use the Devices Menu, and then CD/DVD Devices and select “Host Drive X:” (X will be any letter corresponding to your Physical System (Windows 7) CD Drive


                Mounting an ISO image as CD/DVD:

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† From CD/DVD Devices option select “Choose a virtual CD/DVD disk file‚Ķ”


                  Select the CD iso file and select Open


                  Now you can see the CD mounted as a drive inside the Virtual Machine


     How to share and access a file from my Windows 7 (Physical PC) to the Virtual Machine?

               Shared Folders, makes you access data which is on your base (physical) machine from within Virtual Machine, this is helpful in scenarios such as when you want to install an application in virtual machine and the source file is in a folder on your base machine.

                    Click on Devices Menu and select Shared Folders


                   Click on the Add Shared Folder button


                    Click on Other from the drop down list


                     Browse for the folder you want to share and click on OK


¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† Select the options “Auto-mount” and “Make Permanent”

                    These options will make it available as a Drive in virtual machine and keep the settings always on this virtual machine


                      Click on OK to complete the settings


                       Now log off the virtual machine and login back, and you can see the shared folder as a drive in my computer, you can copy the data from this drive to the virtual machine or can just directly open it from this drive

¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† In my virtual machine, the shared folder named “myfiles” where showing as E Drive



This complete this article on installing Windows XP (for that matter any other operating system including Windows 8 Beta if you have) in a Oracle VM VirtualBox, Virtual Machine.

 I hope this is of help to someone.


Categories: Virtualization Tags:

Installing Free (GPL) Virtualization Software – Oracle VM VirtualBox

May 29th, 2012 No comments

VirtualBox is an easy use virtualization software available for enterprise and home users.  Its available in both x86 and x64 version. It can be used on Windows XP, Vista, or Windows 7, I am not covering any server editions or use of VirtualBox for enterprise or not even for an Extensive Lab purpose.

 My idea here is to only make a basic IT user able to understand the product a little and start using it for a moderate level testing purpose. For more detailed information about the product please explore and read at .  We will be looking at installing VirtualBox on Windows 7 PC.

For a minimum performance, you need to have 1GB Memory on your Windows 7 PC.

¬†Ok, lets get started, first we need to do is to get the binaries (software).¬† For that go to product home page and navigate to the “Downloads” page, or click here for the direct link.

 At the time of writing this article the latest version available is:  4.1.16 so if there are changes to the product in newer releases, before trying the steps provided here, do read the information available at the product site.

¬†The downloaded file for windows will be named like: VirtualBox-4.1.16-78094-Win.exe before starting the installation, Right Click on this file and then Click Properties from the drop down menu.¬† From the properties dialogue box click on “Unlock”¬† and then Apply and OK – as seen in below figure, this will make the file marked as safe and avoid further prompts for authorization.


 Now let us start the installation process, make sure you have administrative rights on your Windows 7 PC.  To kick in the installer just double click on the file VirtualBox-4.1.16-78094-Win.exe and follow the wizard as described below:

 It will take a few minutes to start the installer and below screen will appear first


 On the welcome screen click on Next to proceed:

The default settings are normally sufficient, if you want to change the installation location from default system drive (C Drive) then click on Browse and select the alternate location, otherwise click Next

Click Next


You get a prompt about changes to networking settings on the machine, if you are connected to internet it might get disconnected for a while when the installation proceeds, click Yes to continue

All the tests and preparations are done, all set to start the real setup – click Install

Installation will continue now

You can see the progress, it will take few minutes to complete

At the end of the setup you will get few prompts like seen below, click on Install, these add-ins are required for the software to work as expected

Once completed, click on Finish to close the wizard

This completes our installation procedure for Oracle VM VirtualBox, I hope this was of help to you.

 Any comments or feedbacks are welcome