Installing Oracle Database 11g on Windows OS in simple steps

-

Oracle Database: Acclaimed as the world most flexible and robust database management system is the result of over 3 decades of innovative development. Founded by Larry Ellison, Bob Miner, and Ed Oates in 1977. Oracle’s first relational database (ORACLE version 2) was born in 1979. Please note that there was no version 1, as Larry Ellison, knew consumers will not have faith in buying version 1 😀😀. The most recent database version now is Oracle 12c.
In today’s post, I will show you how to install oracle 11g database on a Microsoft Windows PC.
This will be done using Oracle Database 11g Release 2 Software.
System Requirement Minimum Recommended
It is important that while preparing for installation, the following minimum requirement should be met:

  • Random Access Memory(RAM) with minimum of 1GB in size. Note  that Oracle always recommends more RAM be available than specified in the system requirements. This avoids performance problems like paging and swapping due to lack of resources.
  • Swap / Page File Space 1GB Twice the size of RAM. Swap space /Page File is used mainly for supporting the RAM when it runs out of space. It is actually a portion on the hard disk that behaves like the RAM.
  • Temp Space ( \TEMP) at least 1GB. The Temp space is used to store file for installation. When Installation is compete the file are deleted.
  • Disk Space 1.5GB for Oracle software. The Oracle software can be located in this default directory:   C:\app\Administrator\product\11.2.0\dbhome_1
  • Disk Space of 1.5GB for starter database. The starter database is the database that contains the sample data and tools needed to create objects in your database. This database would be located in the following default directory: C:\app\Administrator\oradata\orcl where "orcl" is the name given to the database during installation should you choose to use it.


Step 1
If you do not have the installation file, please click here to download it
Do not worry it is free to download. Please note however that the file size is about 2gig
Also ensure you select the installation for your operating system type (32 or 64 bit)


Step 2
Unzip the file and click on setup as seen in the screen shot. You might want to execute the setup file as an administrator

This will initiate two things:
o   Verify the minimum requirement for installation and
o   Startup the installation program


Step 3
Configure security updates. This is an optional setting so we will skip it by clicking next
Please ensure you unchecked the “I wish to receive security update…….”


An error message will appear. Please ignore by pressing the “yes” button

Step 4
The next step is to select an installation option. Here we will stay with the default which is
“Create and configure a database”


Step 5
Next step is the selection of System Class. Please select "Desktop Class" since it’s for training purpose. This setting ensures minimum configuration is used to reduce workload on the computer


Step 6
This step is where you customize your configuration setting. I will take you through:
  •         Oracle Base: The Oracle Base is the location where Oracle Database binaries are stored.  The directory will be created in this location.

  •        Software location: The software location is where the oracle database software will be installed. Please note the path.

  •        Database file location: This is where the database related data files will be stored.

  •         Database edition: This is where you select which database edition you want. For this installation let’s stay with Enterprise Edition

  •        Character set: This is used for selecting the character set to be used for the installation. We will also leave this as default  WE8MSWIN1252

  •         Global Database name: This is where we will name our database. For this training let us call the database orcl

  •        Administrative password: This is the admin password used to log in to the orcl database. Please note that oracle has enforced password complexity so let’s give our password Oracle11g

  •         Confirm password: Just as it implies


Step 7
A second pre-configuration check is done before the installation commences


Step 8
Once pre-configuration is successful, a summary of what is to be installed is displayed for confirmation before installation commences. Once started it can no longer be stopped until it’s done with installation.
Click on Finish to start the installation


Step 9
Installation of the Oracle software commences 

Step 10
Once Software Installation is completed, the installer initiates the installation of the database.


Step 11
Once database Installation is completed, you will be required to set the password for the sample database schemas. These are the users we will be using for training.

 Click on Password management button


Step 12
Set the password for the following:

  •          HR with password of hr
  •          SCOTT with password of tiger
Once done click on OK to go back to database configuration assistance page


Step 13
Once at the database configuration assistance page click OK to finish database installation


Step 14
Congratulation!!! 

 You have just installed your very own Oracle 11g database server on Windows PC. You can now click on Close to exit the finished installation.











Comments

  1. Unknown9 October 2017 at 02:22

    Whaoooooo...Valuable knowledge shared. Thanks Boss

    ReplyDelete
  2. Olutayo Oluwole17 January 2018 at 09:41

    Thank you Rotimi. Really Appreciate

    ReplyDelete
  3. Unknown9 May 2018 at 06:58

    Am loving this already....

    ReplyDelete
    Replies
    1. Unknown9 May 2018 at 15:26

      i am supposed to be sleeping yet i just want to practice 1 more lesson. Thanks so so much for this SIr.

      Delete
    2. Olutayo Oluwole11 August 2018 at 14:37

      Thank you Eri... More to come that will be more easy to learn

      Delete

Post a Comment

Popular posts from this blog

Auditing Virtualization

-
Image
Virtualization is the process of creating virtual, representation of an entity, such as virtual applications, servers, storage and networks. It is the single most effective way to reduce IT expenses by reducing hardware footprint while boosting efficiency and agility for all size businesses. However good as it is, virtualization can create a single point of failure if poor implementation introduced a security flaw to the system. In this post I will be sharing with you how to audit virtualization.
Read more

How to Identify if the capacity of your FLASH storage device is genuine or counterfeit

-
Image
Have you at some time purchased a flash drive  or memory card that always stored corrupt data? You paid for a 64gig memory card and all you stored in it is simply just got corrupted. I have been a victim several times even with reputable retailers. These counterfeit flash storages are low capacity in nature, devices that have been maliciously altered so that they appear to have much more capacity than its original. An example is the 64 gig memory card I purchased which ended up having actual capacity of 2gig. So I actually paid for 2gig. Now I didn't get to know this on time because I actually copied a video file inside it as a test which checked out fine. The video file size was 1.5gb. I was able to play the video with no issue of corruption. Thus I "Assumed" the flash was genuine. Boy was I wrong. Later in the week I decided to do a major backup of my mobile phone since I was purchasing another one. After the backup, I formatted ...
Read more

Address Resolution Protocol (ARP): Understanding the basics

-
Image
Address resolution Protocol or ARP for short is basically used to resolve an IP address to a MAC address. A MAC address is a unique identifier for any device. And since we are talking networking today, The mac address we will be concentration on is that of a network device. Its important to note that, no two device can have the same mac address. Whenever a network device needs to communicate with another network device in a Local Area Network, it needs the MAC address of that device. This is where ARP comes to play. Lets take a look at the scenario bellow to clearly understand this concept: 1. There are 2 computers say A and B on the network. 2. They have both been assigned an IP address as seen below:        A: 192.168.0.1        B: 192.168.0.2 3. Computer A needs to communicate with computer B. 4. It looks at a list for the IP address to see if it has a corresponding MAC address. This list is called an ARP Cache. 5. If the en...
Read more