Archive

Posts Tagged ‘Tally’

Preparing Windows 7 PC for DHSE (Kerala Plus Two) Computer Exam Practice

June 1st, 2012 No comments

Some time back, at my home town in Kerala, I had to help a student who is studying for Higher Secondary Education under Commerce Scheme (in Karnataka its called PUC), in my study time it was not there, we studied PDC (Pre-Degree Course)

 Ok, so this post is all about helping a Plus Two Commerce student to prepare for their Computer Application Subject.

 I am writing this mainly on the idea of how to run the applications which are not supported on your Windows 7 PC, and which is supported on Windows XP. Today also the Exam board is teaching Oracle 8i (for SQL), Visual Basic 6, and Tally 7.2.  Out of these Oracle 8i is no more available for download from the products web site, and I do not know the case of VB 6.

And out of these the three mentioned above (Oracle 8i, VB 6, and Tally 7) are not functional on Windows 7. so you need to have a Windows XP PC or use a latest version and keep up to date with the changes, because during examination you are provided with the old versions.

 Most of the juniors out there have a PC now at home, or at least their sister or brother has one.  And most of them are nowadays Windows 7.

 So here is my solution by using a Virtualization Software making you work around this situation.

 Oracle 8i is no more available from the Product Web site now, so what we will do is to make use of Oracle 11g Express Edition, and simulate its “SQL Command Line” Tool to work like the SQLPlus available in Oracle 8i.

 Virtualization Software, makes you something like Install an Operating System such as Windows XP on top of another OS for example your Windows 7.

 For following these instructions you need to have Windows XP CD with Serial Key,  Internet to download Oracle 11g (if you do not have internet at home, you can go to an Internet Cafe or tell your big Bro or Sis to get it done for you :-) ).

 

I don’t want to provide a single lengthy article, instead I did split this into 3 sections.  You can follow below three separate articles to get this done, if you are going to complete this all stuff one shot it might take around 3 hours including download.  You can also follow these steps at intervals there is no necessity to perform these at one shot. I suggest read all of them once before you start following them on your PC.

 

  1. Install  Oracle VM VirtualBox

              This article will explain you how to get the VirtualBox software and install the same on your Windows 7 PC.

 

  1. Install Windows XP in a Virtual Machine on VirtualBox

              This article details how to create a Windows XP Virtual Machine, and shows basic steps on using  VirtualBox software including copying data to the virtual machine

 

  1. Installing Oracle 11g Express Edition, Visual Basic, and using html on Virtual Machine

               This last article will show you how to install Oracle 11g and using it instead of Oracle 8i SQLPlus, and will give a glance of installing VB 6 and Tally 7.2

 

Note:- If your PC is already a Windows XP machine, and your concern is only about Oracle 8i, then you can follow above Step 3 Alone on your Windows XP PC.

Enjoy Learning…

 

Your comments and feedbacks are welcome

I hope this might be of help to someone.

 

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: http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

 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:

  1. CREATE USER scot IDENTIFIED BY tiger

              Where scot is the user name and tiger is the password

  1. GRANT CONNECT,RESOURCE TO scot

              Where scot is the user name

              

 

Some Tests:

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

 

          Answer:

          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: ,