Tools you will use to Install Oracle Database Software, Create and Manage your database:

• Oracle universal Installer (OUI): Used to install your oracle software and can be used to automatically launch the Database Configuration Assistant to create a database.
• Database Configuration Assistant(DBCA): Used to create databases from templates supplied by Oracle. You can also create your own templates for your databases.
• Oracle Net Configuration Assistant(NetCA): Configures network connectivity for your database and applications.
• Oracle Net Manage(netmgr): A graphical tool used to configure and manage the Oracle network configurations.
• Oracle Enterprise Manager: A graphical web-based tool used to manage and monitor your database.
• SQL*Plus: Standard command-line interface for managing your database.

Before you install The oracle software in your company, you will have to plan the installation right?

What do I mean by planning? It is your responsibility to:

• Determine the version of the Oracle Software you are installing.
• Determine the required storage for the installation.
• Work with your system Administrators to identify the hardware and determine if it meets all the requirements for the oracle installation.
• The order of the oracle installation, if you are installing multiple oracle products at the same time.
• Determine if you have all the necessary permissions to install the oracle software and if you don't, find out who does and make sure they are available to support you.

Oracle Database 11.2.0.1 Windows Installation Requirements

Oracle provides all the installation requirements for each version of oracle in their online documentation library which is available on the www.oracle.com website.

Before you plan an Oracle Database Software Installation for a particular release and for the different platforms (Windows, Solaris, Linux, AIX ). You will go to the oracle website, download and review the oracle documentation for that release and create a document including the oracle install requirements which you will use as a guide to ensure that the Oracle servers are properly set up for your installation.

• Follow the link to download Oracle 11g R2 Oracle Technology Network.
• You will be required to create an account with oracle before you can download the software. You account is free (Oracle has made the software available to individuals for free for learning purposes but businesses are required to pay a licensing fee in order to get support).
• You need to install both an Oracle database Enterprise Edition and the Oracle client.
• I recommend that you install the Oracle SQL Developer client as well.

For the Oracle server, I recommend the Oracle 11g R2 Enterprise Edition. Oracle supports 32 bit and 64 bit versions of Oracle 11g. Check if your windows computer is a 32 bit or 64 bit .

Note :A 64-bit windows operating system can support either a 32-bit database or a 64-bit database. A 32-bit operating system cannot support a 64-bit database. So, version identification of the OS is necessary prior to install oracle.

The biggest difference between 32-bit and 64-bit OSes is that the 32-bit version can only address a bit less than 4GB of memory, in total, for the entire system.

Installation involves the normal tasks of downloading, copying files, setting up registry items, and so on. The last part of the installation is configuration of a default local database.

Follow the link to the oracle database 11gR2 installation guide for windows

Oracle Online Documentation For Oracle Database 11gR2 Installation Guide For Windows

Overview Of Database Management System Software Requirements

The Oracle software will be used as the choice for Database Management Software.

For Oracle, I suggest that you use a 32 or 64 bit operating system (windows) with at least 4G memory.

For this course, we encourage you to download the Oracle 11g R2 Enterprise DBMS.

• You will install and configure and Oracle database 11g R2 Enterprise edition
• You will install and configure the Oracle Client software and SQL developer
• You will setup a connection from the client to the server.

Glossary:

Download: To copy or transfer data from one computer system to another, typically over the internet

Install: Create all the necessary files to run a software program on a computer.

Oracle Database Release Numbers</strong

As you will notice when you jump start your Oracle DBA career, many companies do not immediately patch or upgrade to the latest version of the oracle database when it is initially released. As a result, multiple releases of the product exist simultaneously For example you will work in some companies still running Oracle 11g databases or 12c as is the case with my company.