Detailed installation of Oracle 11g under Windows Server R2

This article reproduced http://www.it165.net/database/html/201212/3385.html

First, pre-installation preparation work:

1. Modify the computer name:

The computer name of the server is important for logging on to the Oracle database! remember!

(1) After you install the Oracle database, and then modify the computer name, you may not be able to start the service, that is, you cannot use the OEM (Oracle Enterprise Manager) in your browser;

(2) When Oracle Net Manager configures an Oracle server-side listener, the server's computer name is also used.

2. Unzip the 2 installation files, then copy the 2nd extracted file to the corresponding location of the 1th extracted file, as shown in:

Second, we formally install Oracle 11g R2:

1. Open the 1th unpacked folder and double-click Setup.exe as shown:

2. Enter the e-mail address as shown:

3. It is strongly recommended that you select the " Install only database software " item, which separates the software installation from the database creation, so that you can step through separate two processes, and perform easy inspection, configuration, and patch applications after installing the software.

Select the Single instance database installation as shown in the following:

We select the most functional Enterprise Edition, as shown in:

Below, select the installation location as shown in the requirements:

The following figure examines the summary, and if it is correct, click Done, as shown in:

As shown, the installation begins:

As shown, the installation is complete:

Third, configure the Oracle 11GR2 Listener:

We installed the Oracle 11GR2 software and the instance separately, the former is already installed, but to install the instance, you must first configure the Oracle 11GR2 Listener!

Configuring the Oracle 11GR2 Listener is a 5-step process:

(1) Prepare to create the listener:

(2) Select the configuration content;

(3) Add the listener program;

(4) Select the port number of the TCP/IP protocol;

(5) Complete the configuration and verify.

Let's configure it in detail below:

(1) Prepare to create the listener:

Method One:

Method Two:

Win + R---netca enter, pop up as shown:

(2) Select the configuration content:

Configure the listener for the first time, so you can only select Add, as shown in:

The Listener name defaults to:

(4) Select the port number of the TCP/IP protocol:

The TCP/IP port number is also used by default, as shown in:

(5) Complete the configuration and verify that:

We also want to confirm that the listener is started, as shown in: Www.it165.net

Win + R---services.msc enter, eject ...

Iv. Installing the database instance:

Now that you can install the data instance, there are 9 steps to creating a DB instance:

(1) Prepare to create the database instance;

(2) Select the creation type;

(3) Select the template to create the database;

(4) Fill in the database identification;

(5) Select the configuration of the database;

(6) Set the account password;

(7) Add an example scheme;

(8) Select initialization parameters;

(9) Complete the installation.

Here is the detailed configuration:

(1) Prepare to create a DB instance:

(2) Select Create Type:

(3) Select the template to create the database:

(4) Fill in the database ID:

(5) Select the configuration of the database:

Oracle Enterprise Manager is used to monitor and manage Oracle software infrastructure as well as applications and business services.

(6) Set the account password:

Here are the default choices:

(7) Add an example scenario:

For the convenience of learning, the sample scheme is selected, which includes the tablespace of the example.

(8) Select initialization parameters:

The key here is the setting of the character set, strongly recommended: The character set is best and the client is consistent! Otherwise it is easy to appear garbled.

(9) Complete the installation.

Start by choosing the default!

See above, that means installation success!!!

Note:

We click on the password management above, then pop up as shown:

Since we're going to use the username Scott, we'll remove the √ ( tick ) behind Scott.

If you do not remove the √ ( tick ), then you can use the command to unlock it later!!!

View the database service as shown in:

Win + R---services.msc enter as shown in:

Let's use the command to unlock the user account Scott:

Open Sqlplus, and log in as shown in the system User:

Detailed installation of Oracle 11g under Windows Server R2