Home > Database > Oracle > How to install Oracle 11g on Linux system

How to install Oracle 11g on Linux system

PHPz
Release: 2023-04-04 11:42:30
Original
1705 people have browsed it

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:

1

2

3

sudo groupadd oinstall

sudo groupadd dba

sudo useradd -g oinstall -G dba oracle

Copy after login

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

1

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

Copy after login

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.

1

2

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip

Copy after login

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:

1

2

3

xhost +

sudo su

./runInstaller

Copy after login

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:

1

2

3

4

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

Copy after login
  1. Start Oracle:

1

2

sqlplus / as sysdba

startup

Copy after login
  1. Configure Listener:

1

netca

Copy after login

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:

1

lsnrctl start

Copy after login

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!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template