How to install Oracle 11g on Linux system

Oracle 11g is a powerful relational database management system (RDBMS) that is widely used in enterprise-level applications. This article will explain how to install Oracle 11g on a Linux system.

First, make sure the system meets the following basic requirements:

• 64-bit Linux system
• At least 4GB of physical memory
• At least 12GB of disk space

Next, we need to do some pre-installation settings. First, create a new group and user for the Oracle user:

sudo groupadd oinstall
sudo groupadd dba
sudo useradd -g oinstall -G dba oracle

Next, we need to install some necessary dependencies. Use the following command to install dependencies:

sudo apt-get install gcc make binutils x11-utils libaio-dev -y

During the installation process, you may be prompted to install additional dependencies. Please follow the prompts.

Now, we need to download the installation file of Oracle 11g. You can download it from Oracle's official website. Once the download is complete, unzip the file into a folder.

unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip

After unzipping, you will get a folder named "database" which contains the installation files of Oracle 11g and other necessary files.

Next, open a terminal and execute the following command under the root user to start the graphical installer:

xhost +
sudo su
./runInstaller

After starting the installer, you will enter a GUI interface. In this interface you need to perform the following operations:

1. Select "Create and manage database".
2. Select "Standard Edition Database" (Enterprise Edition can also be used, but requires more hardware resources)
3. Enter the Oracle software installation location, for example: /u01/app/oracle/product/ 11.2.0/dbhome_1
4. Choose the language that suits you
5. Select the character set that suits you
6. Select "Singleton" on the next page
7. Under Select "Desktop System (Gnome or KDE)" on one page

Next, you need to make some settings:

1. Users and groups: the oracle created earlier here The users and groups already exist, just use them directly.
2. Set password: Set passwords for Oracle administrator and SYS and SYSTEM users.
3. Memory capacity: Set the size of SGA and PGA according to your physical memory.

Next, you need to do some additional configuration:

1. Select "Create New Database".
2. Enter the database name, for example: orcl.
3. Select "File System"
4. Enter the database file location, for example: /u01/app/oracle/oradata.
5. Select "English (United States) in Data" on the next page.

Next, you need to perform some additional installation:

1. Install the remaining components and licenses
2. Click install and wait for the installation process to end

After the installation is complete, you need to make some additional settings:

1. Set the ORACLE_HOME, ORACLE_SID and PATH variables:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
export ORACLE_SID=orcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

2. Start Oracle:

sqlplus / as sysdba
startup

3. Configure Listener:

netca

During this process, you need to enter the following information:

1. Listener Name : LISTENER
2. Listener Protocol: TCP
3. IP Address: Select all available IP addresses (If you don’t know your IP address, you can use the ifconfig command to check it.)
4. Port: 1521
5. Click Finish and wait for the configuration to be completed
6. Finally, start the Listener:

lsnrctl start

Now, Oracle 11g has been successfully installed on your Linux system . You can use the Oracle command line tool sqlplus to connect to your database and start using it.

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