Installation tutorial for Oracle database on CentOS 7

Oracle database is a widely used relational database management system used in various types of enterprise applications and data management. CentOS 7 is a widely used open source operating system commonly used as a server operating system. In this article, we will discuss how to install Oracle database on CentOS 7.

Step 1: Download the Oracle database

First, we need to download the installation software for the Oracle database. You can download the latest version from Oracle's official website (http://www.oracle.com/).

Step 2: Install the necessary software packages

Before installing the Oracle database, we need to install some necessary software packages to ensure that the Oracle database can run correctly. Use the following command to install the required packages:

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

Step Three: Create Oracle users and groups

We need to create a user named "oracle" and a user named "dba" Group. Please use the following command to create users and groups:

sudo groupadd dba
sudo useradd -g dba oracle

Step 4: Configure kernel parameters

Before installing the Oracle database on CentOS 7, we need to modify some kernel parameters. Edit the /etc/sysctl.conf file using the following command:

sudo vi /etc/sysctl.conf

Add the following line 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 = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2

Save and close the file. Use the following command to make the new kernel parameters take effect:

sudo sysctl -p

Step 5: Configure the user environment

We need to make some configurations for the oracle user environment. Edit the oracle user's .bash_profile file using the following command:

sudo vi ~oracle/.bash_profile

Add the following line to the end of the file:

export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=your-server-name
export ORACLE_UNQNAME=your-database-name
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=your-sid

export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Change "your-server-name" to your server name," your-database-name" to your database name and "your-sid" to the instance name you want to use. Save and close the file.

Step 6: Install the Oracle database

Now, we have completed the preparatory work before installation and can start installing the Oracle database. Use the following command to start the installation:

su - oracle
cd /path/to/oracle/installation/files
./runInstaller

Follow the instructions of the installation wizard to install. The installation process may take some time, depending on your system capabilities and installation options.

Step 7: Configure Oracle database

After the installation is completed, we need to perform some configurations. Run the Oracle Database Configuration Assistant using the following command:

$ORACLE_HOME/bin/dbca

Follow the instructions of the configuration wizard. This will include creating a database, configuring listeners, etc.

Step 8: Test the Oracle database

Now, we have installed and configured the Oracle database and can test it. Start the Oracle service using the following command:

sudo systemctl start oracle

Check the Oracle service status using the following command:

sudo systemctl status oracle

Start SQL*Plus using the following command:

sqlplus /nolog

At the SQL*Plus prompt Next, enter the following command:

SQL> connect sys/sys_password as sysdba

SQL> select instance_name from v$instance;

If the database has been successfully installed and configured, the name of the database instance should be returned.

Conclusion

In this article, we introduced the steps to install Oracle database on CentOS 7. Installing an Oracle database may take some time and a lot of running memory, but once installed and configured, you will have a powerful relational database management system that can handle all types and sizes of data.

The above is the detailed content of Installation tutorial for Oracle database on CentOS 7. For more information, please follow other related articles on the PHP Chinese website!