How to Install Oracle database on windows server

In this post we will quickly install the Oracle Database on top of a windows server 2008 r2 OS, before you go ahead on the installation make sure you have an ip address assigned to the host machine, you can follow some previous posts on “Virtual Box category”

I have also installed oracle dataase on oracle Linux but for these series of posts you can use the windows installation with no problem.

Proceed to install oracle db which is required before we continue with installation of other applications like OBIEE 11g which has its metadata stored in the DB whereas in the OBIEE 10g version it wasn’t necessary.  The main change from 10g to 11g was  after the “Fusion Middleware” strategy that Oracle started in the years 2000’s by acquiring several products for different purposes and embedding all of those products in one suite improving and leveraging data integration, data delivery,  compatibility, connectivity  and etc… the first release of fusion was in September 2010, and most of the applications relies on the DB to store the metadata repositories, in the link below you can have a brief about the evolution of “Fusion” concept: https://en.wikipedia.org/wiki/Oracle_Fusion_Middleware

  • To proceed with installation, first we download the database installers, double check your system is 32 or 64 bits,

Go to this link: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Extract both files into one single folder like the one below:

Share the files with the VM but if you already have done that you can skip this part:

I then add that as a shared folder on the VM:

And map the root folder where you have all the software installers you intend to install /share with the VM, restart your VM and login back:

  • In the VM, navigate to the D: drive and you will see the “Virtual Box Guest Additions ”, right click and run the exec  “VBoxWindowsAdditions-amd64 “,   this will enable you to share files in a bidirectional manner from host to VM and vice versa :
  • Click next, next and accept the default :

  • Click install

  • Installation completed:
  • After the reboot, log in the VM and you will see a new drive “E:” navigate into it and you can see what is shared by the host machine:

  • Now we need install the Oracle Database on top of the VM, as mentioned before typically you will have the Oracle database installed on Linux/unix but for demo purposes and speed up this step we will install it on Windows, you will need to set up the swap space and restart your VM. For more information about prereqs of the DB install check the link below : https://docs.oracle.com/cd/E11882_01/install.112/e47798/reqs.htm#NTDBI2692
  • Before running the installer increase the swap memory, this is important for OBIEE installation but also for the database install to work fine:

  • Make sure you have extracted the install files to a single folder,  copy the file from the shared folder to the VM and run the executable file :

  • Right click on it and run as Admin:
  • You should be able to see this screen:
  • Click next :
  • You will see a warning like this: “You have not provided an email address”
  • “Do you wish to remain uninformed of critical security issues in your configuration?”  Click “Yes” to skip the warning:
  • Choose the option “Skip software updates”, this option is more for a non-Production environment:

  • Choose the option ”create and configure a database”, this option is to create a DB from scratch:
  • Choose the “desktop class” option for a simple configuration, if you are performing a production install you should use a Server class option :
    • Select the following options below, default locations for :                                   oracle base, database file and software
    • Also define the edition of DB, in this case I chose “Enterprise”
    • Choose the character set as “Unicode (AL32UTF8)”, it makes your DB consistent with any character set used by other systems, it is a standardization of universal Unicode enabling an easier integration across different RDBMS in different languages in some cases and for some applications is the only “ Unicode ” acceptable , more detailed information about it in here :
    • https://docs.oracle.com/cd/B10500_01/server.920/a96529/ch5.htm
    • http://www.unicode.org/reports/tr44/
    • Give the database name: “orcl” and click next
    • Provide a password

Click “yes” if you get a warning pop up, this is because I gave a very short password, ignore it and proceed :Click Install :

  • Installation in Progress:

Installation complete, click ok:

  • Go to “start menu “and check the “EM”, which is basically a graphical interface that enables DBA’s and DW admin’s to visualize the database structures such as tablespaces, data files,  schemas,  initialization parameters etc… you also can manage your DB, usually the oracle DBA’s use EM more for monitoring not Db management :

  • Click in “Proceed” to “your domain”:

  • You can now log in Enterprise manager:
  • After logging in EM we can see the instance”ORCL” the default listener, the host , the version of DB and if the Database is running, also there are many other information you can see, you can monitor performance of user processes(SQL queries), storage and physical structures :

If you click in the server link on the top, you will be able to see the tablespaces structure (size), data files, control files, redo log files rollback segments, archive logs etc…

See you in the next post.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s