How to install Oracle11g on CentOS 7 system (steps)

Oracle11g is a powerful relational database management system that can manage and store large amounts of data. Installing Oracle11g on the server can improve the server's data management and processing capabilities, and also facilitate remote management and data sharing.

The following are the steps to install Oracle11g on the CentOS 7 operating system:

Step 1: Download the Oracle11g installation file

First, you need to download Oracle11g for the server from the Oracle official website Installation files. It should be noted that you need to download the installation file of the Linux version suitable for the server, usually in zip or tar format.

Step 2: Install service packs and dependent libraries

Before downloading the Oracle11g installation file, you need to install some necessary service packs and dependent libraries to ensure that Oracle11g can be installed and run smoothly.

In the CentOS 7 operating system, you can use the following command to install the service pack and dependent libraries:

yum install -y binutils
yum install -y compat-libstdc++-33
yum install -y compat-libstdc++-33.i686
yum install -y gcc
yum install -y gcc-c++
yum install -y glibc
yum install -y glibc.i686
yum install -y glibc-devel
yum install -y glibc-devel.i686
yum install -y ksh
yum install -y libgcc
yum install -y libgcc.i686
yum install -y libstdc++
yum install -y libstdc++.i686
yum install -y libstdc++-devel
yum install -y libstdc++-devel.i686
yum install -y libaio
yum install -y libaio.i686
yum install -y libaio-devel
yum install -y libaio-devel.i686
yum install -y libXext
yum install -y libXext.i686
yum install -y libXtst
yum install -y libXtst.i686
yum install -y libX11
yum install -y libX11.i686
yum install -y libXau
yum install -y libXau.i686
yum install -y libxcb
yum install -y libxcb.i686
yum install -y libXi
yum install -y libXi.i686
yum install -y make
yum install -y sysstat

Step 3: Create a new user

Before installing Oracle11g, you need to create A new user to install and run Oracle11g.

You can use the following command to create a new user:

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

Step 4: Set system parameters

In order to ensure that Oracle11g can be installed and run normally, some system parameters need to be modified.

System parameters can be set using the following command:

vi /etc/sysctl.conf

Add the following lines to the open 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 exit the file.

Then use the following command to make the modified system parameters take effect immediately:

sysctl -p

Step 5: Create directories

Before installing Oracle11g, you need to create some directories for storing Oracle11g configuration files, data files and log files.

You can use the following command to create a directory:

mkdir /u01
mkdir /u01/app
mkdir /u01/app/oracle
mkdir /u01/app/oraInventory
chown -R oracle:oinstall /u01
chmod -R 775 /u01

Step 6: Edit environment variables

You need to edit the environment variables of the oracle user and add the path to Oracle11g.

Environment variables can be edited using the following command:

vi /home/oracle/.bash_profile

Add the following lines to the opened file:

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

Save and exit the file.

Then use the following command to make the modified environment variables take effect immediately:

source /home/oracle/.bash_profile

Step 7: Decompress the Oracle11g installation file

Extract the downloaded Oracle11g installation file to /u01/app /oracle directory.

You can use the following command to decompress the installation file:

unzip linux.x64_11gR2_database.zip -d /u01/app/oracle/

Step 8: Run the installation program

Log in as the oracle user and enter the /u01/app/oracle/database directory.

Then run the ./runInstaller command to start the Oracle11g installation program.

The installation program will sequentially perform client check, installation type selection, Oracle11g unique identifier (SID) setting, Oracle11g storage type setting, Oracle11g installation option setting and final installation.

When executing the ./runInstaller command, you need to pay attention to the following points:

• You must use the root user to execute the ./runInstaller command, otherwise a Permission denied error will be prompted.
• When selecting the installation type, select Typical to install using the default options.
• In the storage type settings of Oracle11g, select File System to use the file system for storage.
• In the installation option settings, select "Install and configure Oracle Database" and "Create Database".

The installation process may take some time, please wait patiently.

Step 9: Create Oracle11g database

After the Oracle11g installation is completed, you need to create a new Oracle11g database.

You can use the following command to create a database:

dbca

In the opened Oracle11g Database Configuration Assistant, follow the wizard and specify the database name, database storage location, administrator account and password and other information.

When creating a database, you need to pay attention to the following points:

• Use File System as the storage type.
• In the Administrator tab, specify the administrator account and password.
• In the Character Sets tab, use the AL32UTF8 character set.
• In the Storage tab, set the Database File Size of the Sizing tab to 1024MB.

Step 10: Verify Oracle11g installation

After the Oracle11g database is created, you can verify whether the installation and configuration of Oracle11g are correct.

You can use the following command to log in to the Oracle11g database:

sqlplus / as sysdba

After successfully logging in, you can execute some simple SQL statements to verify the installation and configuration of Oracle11g.

For example, you can use the following SQL statement to view the currently connected Oracle11g database version:

SELECT * FROM v$version;

If the returned result contains the version number of Oracle11g, it means that Oracle11g is installed and configured successfully.

Summary

Oracle11g is a very powerful and commonly used database management tool that can be used for server data management and processing. To install Oracle11g on the CentOS 7 operating system, you need to set some system parameters and install dependent libraries. Then you can use the Oracle11g installer for installation and configuration. After the installation is complete, you need to create a new Oracle11g database, and verify whether Oracle11g is installed and configured correctly.

The above is the detailed content of How to install Oracle11g on CentOS 7 system (steps). For more information, please follow other related articles on the PHP Chinese website!