oracle 11g r2 installation

Oracle 11g R2 Installation Guide

Oracle 11g R2 is a widely used database management system for managing large-scale data. There are some steps that need to be followed to install Oracle 11g R2, and this article will provide a detailed installation guide.

1. System requirements

Before you start installing Oracle 11g R2, you need to check whether the system meets the following minimum requirements:

1. Operating system: Oracle 11g R2 for Windows , Linux and Solaris operating systems are supported. For Windows, Windows XP, Windows Vista, Windows 7, Windows 8 and Windows 10 are required. Linux is required to run CentOS, RedHat Enterprise, SUSE, Oracle Linux, Asianux, Debian and Ubuntu 14.04 LTS. Solaris is required to run Solaris10 Update 9 and Solaris11.
2. CPU: At least 2 GHz x86 or 64-bit processor required. For multiple processors, a 32-bit processor or a 64-bit underlying processor is required.
3. Memory: A minimum of 2 GB of memory is recommended, but the minimum requirement is 1 GB.
4. Hard disk: It is recommended to provide at least 10 GB of free space.
5. Monitor: The recommended resolution is 1024 x 768.
6. Java: Java SDK version 6 or 7 needs to be installed. Oracle recommends using JDK 7.
7. Required software: Oracle recommends installing Microsoft Visual C 2008 Redistributable Package.

2. Download Oracle 11g R2

Oracle 11g R2 can be downloaded for free on the Oracle official website. You need to first download the installation file from the Oracle official website. The format of the installation file is: win64_11gR2_database_1of2.zip and win64_11gR2_database_2of2.zip.

3. Install Oracle 11g R2

Install Oracle 11g R2 using a graphical interface for installation. Before installation, you need to ensure that there is no old version of Oracle 11g in the system.

1. Extract the installation files

Extract the two downloaded installation files (win64_11gR2_database_1of2.zip and win64_11gR2_database_2of2.zip) to the same directory. Disk 1 in settings will be skipped when importing.

2. Run the installation

Start the installation program, and proceed step by step under the graphical interface of the installation program, as follows:

Step 1: Password management

In this step, you need to set the password of the administrative user. This administrative user will manage all databases. Save this password in a safe location.

Step2: System Check

In this step, the system will check whether your system meets the requirements of Oracle 11g R2. If there are any problems with the system, there will be a warning or error message. If an error occurs, you need to go back to the system requirements to check. If it's a warning, you can continue with the installation process.

Step3: Installation type

In this step, select the installation type. You can choose Typical installation to install the default components, or you can choose Custom installation.

Step4: Database installation and configuration

In this step, you need to set the name of the database and the unique identifier of the database. Set the database identifier to a globally unique name, ensuring that it does not have the same name as another database.

After filling in the database related information, you need to configure the listener. Listeners can transmit important network information between clients and servers. Select the "Create a new listener" option and click "Next".

Step5: Data storage options

In this step, you need to set the data storage options for your Oracle database. You can select a default storage location, or you can create a new storage location. Make sure the storage location has enough space to accommodate all database files.

Step6: Check and Execute

In this step, a check is required to ensure that all settings are correct. If the check passes, the installation program will be executed. The installation process will continue until the installation is complete.

4. Database creation and startup

After the installation is completed, you can start the Oracle database. You need to use the following command to start the Oracle database at the command line prompt:

C:>set ORACLE_SID=<your_sid>
C:>set ORACLE_HOME=<Your_Oracle_Installation_Dir>
C:>%ORACLE_HOME%insqlplus /nolog
SQL>SQL> connect /as sysdba;

If the connection is successful, Oracle 11g R2 has been installed and started.

4. Conclusion

The above is a simple Oracle 11g R2 installation guide. You need to follow the steps. The only problem may be the system requirements. You need to ensure that the system meets the requirements. During the installation process, don't forget to save all administrative user passwords. After installation, you can use the command line or Oracle interface to operate the database.

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