centos oracle 11g installation

CentOS is a popular Linux operating system, and Oracle database is a relational database management system widely used in the industry. In this article, we will discuss the installation process of Oracle 11g database in CentOS.

Required environment:

• CentOS 7 operating system
• Oracle 11g installation file

1. Install necessary software packages
   Before you start installing Oracle 11g, you need to install some necessary software packages. Execute the following command in the terminal to install:

yum install -y binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64

2. Create user and group
   You need to create a new group and a new user to install Oracle 11g. Execute the following commands in the terminal:

groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba oracle
passwd oracle

3. Download and decompress the Oracle 11g installation file
   Download the Oracle 11g Release 2 installation file from the official Oracle website and extract it to a directory:

mkdir /u01/app/oracle/product/11.2.0/dbhome_1
unzip linux.x64_11gR2_database_1of2.zip -d /install
unzip linux.x64_11gR2_database_2of2.zip -d /install

4. Set environment variables
   Before installing Oracle, you need to set some environment variables. Execute the following command in the terminal:

vi /etc/profile.d/oracle.sh

Enter the following in the editor:

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Then save and close the file.

source /etc/profile.d/oracle.sh

5. Modify kernel parameters
   Before installing Oracle, you need to modify the kernel parameters of the Linux operating system. Execute the following command in the terminal:

vi /etc/sysctl.conf

Add the following content to the end of the file:

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.aio-max-nr = 1048576

Save and close the file, then run the following command to reload the kernel parameters:

sysctl -p

6. Installation
   Now, you have completed all the installation preparations for Oracle 11g. Enter the directory where the installation file is located in the terminal and run the following command:

./runInstaller

Run the installation wizard and follow the prompts. After the installation is complete, close the terminal window.

7. Configuring the Oracle listener
   Before performing any database operations, you need to configure the Oracle listener. Run the following command in the terminal:

netca

Create a listener according to the prompts.

8. Create Database
   Finally, you can create a new database using the Database Configuration Assistant (DBCA) graphical tool or manually. Execute the following command in the terminal to run DBCA:

dbca

or manually:

sqlplus / as sysdba
SQL> create database mydb;

At this point, you have successfully installed the Oracle 11g database!

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