How to install Oracle 11g database on Windows 7

With the rapid development of computer technology, database systems have become one of the important infrastructures in the Internet era. As the industry's leading relational database management system, Oracle database is highly favored by users because of its reliability, efficiency, and security. favor. This article will introduce how to install Oracle 11g database on Windows 7 operating system.

1. Installation preparation

1. Download the Oracle11g database installation program

Download the Oracle 11g R2 version installation program on the Oracle official website (the download URL is: http:// www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html)

2. Check the system environment

Installing Oracle 11g needs to meet some system environment requirements, including the operating system , hardware, software, etc. Before installation, you need to confirm that the system has the following environment:

(1) Operating system: Windows 7 (32-bit or 64-bit)

(2) Memory: at least 1GB

(3) Hard disk space: at least 8GB

(4) Virtual memory: Set to 2 times the size of physical memory

(5) Other software: .NET Framework 2.0 and above, Java Runtime Environment 1.5.0 (1.5.0_12) and above

3. Create a local administrator account

Add the current user to the local administrator group and act as the administrator to install.

2. Installation steps

1. Double-click to run the installation program. After waiting for a period of time, the following interface will automatically appear:

Click "Next" to start the installation.

2. Select the installation type and installation path

In the next step, select the "Custom" type and specify the installation directory of the Oracle software. You can modify the installed configuration options according to actual needs. Use the default configuration here and click "Next".

3. Select the database type

Oracle database has two modes to choose from: Oltp mode and Data Warehousing mode. Generally speaking, we choose OLTP mode.

4. Set password and port number

In the "Password Management" page, you need to set the Oracle administrator's password and set the listening port number (default is 1521). This information is needed when accessing the database after installing the Oracle database. For security reasons, do not use the default password. After completing the settings, click "Next".

5. Installation completed

It will take some time before the installation is completed.

6. Enter the installation wizard

On the installation completion screen, select "Perform configuration after installation" and click the "Finish" button.

7. Configure

Generally, we will choose to create a new database and manage the directories of data files and control files (including archive logs). Various options can be modified according to actual needs. After completing the configuration wizard, the Oracle 11g database installation is completed.

3. Configure the listener

The Oracle listener is responsible for accepting the client's connection request and passing the connection request to the Oracle instance. So the listener must be started after the configuration is completed.

1. Open the CMD window

Enter the management state and open the CMD window as an administrator (shortcut key Win X, select the Command Prompt (Admin) menu item)

2. Enter Command

Enter the following command to start the listener:

NET START OracleOraDb11g_home1TNSListener

3. Check the listener status

If the listener is started successfully, run the following command Check the status of the current listener:

lsnrctl status

4. Connect to Oracle database

After the installation is completed, you can use tools such as PL/SQL Developer to connect to the Oracle database for data operations . The connection address and port number need to be specified. As shown in the figure:

5. Summary

This article introduces the steps to install the Oracle 11g database on the Windows 7 operating system, including the pre-installation preparations to the installation and configuration process. Each link. Oracle11g is a powerful database management system that can meet the current business growth needs after installation. I hope it will help readers who love database technology move towards the path of database learning.

The above is the detailed content of How to install Oracle 11g database on Windows 7. For more information, please follow other related articles on the PHP Chinese website!