oracle 11gr2 installation

Oracle 11gR2 Installation

Oracle database is one of the most popular enterprise-level relational database management systems in the world. It's very powerful, reliable, secure, and widely used. Oracle 11gR2 is its latest version and its installation is very important as it is the basis of Oracle database. This article will detail how to install Oracle 11gR2 on Windows 10.

Step 1: Download the software

First, you need to download the Oracle 11gR2 installation program from the Oracle official website. The official website address is: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html.

Download a .zip file from here. After decompression, you will get two folders: database and client. Here, we only need the contents of the database folder.

Step 2: Modify the computer name

Before installing Oracle 11gR2, you need to ensure that your computer name does not contain any Chinese characters, otherwise the installation process and subsequent operations will be affected. The computer name can be viewed through "My Computer"->"Properties"->"Computer Name, Domain and Workgroup Settings"->"Computer Name".

If your computer name contains Chinese characters, please change it to English characters. If you don't know how to change the computer name to English, please refer to the article "Changing Computer Name and Computer Domain". Also, be careful not to use computer names with spaces.

Step 3: Prepare files

Before proceeding with the installation, some preparations are required. First, you must ensure that the Microsoft Visual C 2010 Redistributable Package is installed on your computer. If you haven't installed it yet, you can download it from the following link: https://www.microsoft.com/en-us/download/details.aspx?id=14632.

Secondly, you need to disable the firewall and anti-virus software, otherwise it may affect the installation and configuration of Oracle 11gR2. You can disable them through the Windows Firewall in Control Panel and the settings in your antivirus software.

Step 4: Run the installation program

Double-click the "setup.exe" file in the database folder to open the Oracle 11gR2 installation wizard. On the welcome screen, click the Next button.

On the "Software License Agreement" interface, select the "Accept License Agreement" option, and then click the "Next" button.

On the "System Check" interface, the system will automatically perform a series of system checks to ensure that the computer meets the requirements. If you receive any warning or error messages, follow the prompts. Otherwise, click the "Next" button to continue.

On the "Installation Options" interface, select the "Create and configure database" option, and then click the "Next" button.

On the "Database Edit Mode" interface, select the "Advanced Installation" option. This will open a new dialog box, in which please select the "Create your own database template" option and click on the "Next" button.

In the "Installation Type" interface, select the "Custom" option. This will open a new dialog box, please select the "Database" option there and click on the "Next" button.

In the "Database Type" interface, select the "Typical" option, and then click the "Next" button.

In the "Database Identification" interface, enter the database name you want to create for the Oracle database. You can use the defaults, but remember that you need to easily differentiate this database from any other Oracle database. Additionally, you will need to create passwords for the sys and system users. Please make sure this password is very secure and do not use the same password between evaluation and production systems under any circumstances. Click the "Next" button to continue.

In the "Management Options" interface, select the "Database with full permissions" option. This will give you maximum permissions, so be very cautious. After confirming your selection, click the "Next" button.

In the "Storage Options" interface, you need to select the location of the database file. This is usually an additional disk or partition, as Oracle databases require a lot of disk space. You can choose the default path, but make sure you have enough disk space. After confirming your selection, click the "Next" button.

In the "Configure Security Options" interface, select the "Use Oracle recommended security options" option. This will ensure that the database is properly secured. After confirming your selection, click the "Next" button.

In the "Start Installation" interface, the system will show that you have completed all configuration steps. If you are satisfied with the installation options, click the Install button to start the installation. The installation process takes a while, and the interface will display the progress of the installation. Please wait patiently until the installation is completed.

Step 5: Execute the configuration wizard

The installation program will automatically open the Oracle 11gR2 configuration wizard. On the first interface, you need to select the "Create new database" option, otherwise the system will not be able to create an instance of the database. After confirming your selection, click the "Next" button.

In the "Start Database" interface, you need to select the "Start as Service" option. This will ensure that the Oracle database starts automatically when the computer starts. After confirming your selection, click the "Next" button.

In the "Operating System User" interface, you need to enter the username and password of the Windows user who will run the database. If you must create a new user, click the "Create" button. After confirming the entered information, click the "Next" button.

In the "Network Configuration" interface, you need to keep the default settings. This will provide you with basic network functionality and security settings. After confirming your selection, click the "Next" button.

In the "Database Storage" interface, you need to select a storage standard. Typically, you should select the "Automatically manage space" option, which will automatically adjust disk space to suit the needs of your database. After confirming your selection, click the "Next" button.

In the "Database Settings" interface, you need to select the appropriate character set. This affects how data is stored, sorted, and compared in the database. Generally, you should choose the standard UTF8 character set. After confirming your selection, click the "Next" button.

In the "Summary" interface, the system will list all your installation options for you to view. If you are satisfied with all options, click the "Finish" button and the configuration wizard will automatically start configuring the Oracle database.

Step 6: Start the Oracle database

Once the installation and configuration are complete, you can use the "Oracle-oraDb11g_home1" item in the "Start" menu to start and stop the Oracle database. In the boot menu you will also find SQL Plus, which is the command line interface for Oracle database.

Before starting the Oracle database, please ensure that the available physical memory size is greater than 1 GB.

Summary

This article introduces the installation process of Oracle 11gR2 on Windows 10. Installing an Oracle database requires a full understanding of the various configuration options for your computer and database. Following the steps described in this article can ensure that you install, configure, and start the Oracle database under the correct conditions, ensuring that you obtain maximum database performance and functionality in your enterprise environment.

The above is the detailed content of oracle 11gr2 installation. For more information, please follow other related articles on the PHP Chinese website!