Installing Oracle Database 11g on Windows

In this tutorial, you learn how to install Oracle Database 11g on Windows.

This tutorial covers the following topics:

Overview
Installing the Oracle Database 11g Software
Creating a Listener
Creating a Database
Testing Your Installation
Summary

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Using the Oracle Universal Installer, you install the Oracle Database 11g software and create a database.

To install the Oracle software, you must use the Oracle Universal installer.

1.

For this installation, you need either the DVDs or a downloaded version of the DVDs. In this tutorial, you install from the downloaded version. From the directory where the DVD files were unzipped, open Windows Explorer and double-click on setup.exe from the \db\Disk1 directory.

 

2.

The product you want to install is Oracle Database 11g. Make sure the product is selected and click Next.

 

3.

You will perform a custom installation. Click Advanced Installation and click Next.

 

4.

If this is your first install, you need to specify your Inventory directory. The location should be set to /u01/app/oraInventory. Accept the default Operating System group name, oinstall. Then, click Next.

 

5.

You want to install the Real Application Testing component so you need to perform a custom install. Select Custom and click Next.

 

7.

Accept the install location defaults and click Next.

 

8.

The list of Product Components appears. Scroll down the list. In addition to the defaults, you want to select the Real Application Testing and click Next.

 

10.

At this time, you only want to install the software. Select Install database Software only and click Next.

 

11.

Review the Summary window to verify what is to be installed. Then, click Install.

 

12.

The progress window appears.

 

16.

Click Exit. Click Yes to confirm exit.

 

Before you create the database, a listener needs to exist. Perform the following steps to create a listener:

1.

From your terminal window, enter the following:

netca

 

2.

Make sure that Listener Configuration is selected and click Next.

 

3.

Select Add and click Next.

 

4.

Accept the default Listener name and click Next.

 

5.

Accept the default Selected Protocol and click Next.

 

6.

Accept the standard port of 1521 and click Next.

 

7.

Select No to not configure another listener and click Next.

 

8.

Click Next.

 

9.

Click Finish.

The listener has been created.

 

Perform the following steps to create your database:

1.

From your terminal window, enter the following:

dbca

 

2.

At the Database Configuration Assistant: Welcome window, click Next.

 

3.

Select Create a Database and click Next.

 

4.

Select General Purpose or Transaction Processing and click Next.

 

5.

Enter a Global Database name, in this case, orcl.us.oracle.com, and click Next.

 

6.

You do want to configure Enterprise Manager. Accept the defaults and click Next.

 

7.

Select the option Use the Same Administrative Password for All Accounts, enter a password and confirm password, then click Next.

 

8.

Accept the default Storage option and click Next.

 

9.

Accept the default database file location and click Next.

 

10.

Accept the default recovery configuration and click Next.

 

11.

Select the Sample Schemas check box and click Next.

 

12.

Accept the defaults and click Next.

 

14.

Accept the default security settings and click Next.

 

15.

Accept the default and click Next.

 

16.

Accept the default storage settings and click Next.

 

17.

Click Finish.

 

18.

Review the components that will be configured when the database is created and click OK.

 

19.

The progress window appears.

 

20.

Once the database is created, click Exit.

Your database has been created.

 

To test that your installation completed successfully, perform the following steps:

1.

Open a browser and enter the following URL:

https://<hostname>:1158/em

where <hostname> should be changed to your machine name, IP address, or localhost.

Because Enterprise Manager Database Control is a secure site, you need a certificate. Select the Accept this certificate permanently option, and then click OK.

 

2.

Enter system as the User Name and oracle as the Password, and then click Login.

 

3.

The Database Control Home Page appears. Your installation was successful.

 

In this tutorial, you learned how to install and test the Oracle Database 11g installation on Windows.

Back to Topic List

Move your mouse over this icon to hide all screenshots.