centos 6.5 installation oracle

In recent years, Oracle database has been increasingly used and promoted, especially in enterprise-level applications and Internet applications, and its stability, performance and security have been widely recognized and applied. Before installing the Oracle database, we need to plan the hardware requirements we need, and then choose the system platform for installation. This article will introduce how to install Oracle database on CentOS 6.5 operating system.

1. Hardware requirements

Before installing the Oracle database, let’s first understand some hardware requirements to ensure a successful installation:

• CPU: It is recommended to use multiple Core and multi-threaded CPU, at least four cores;
• Memory: It is recommended to use at least 8GB of memory;
• Storage: It is recommended to prepare at least 50GB of disk space when installing the Oracle database;
• Network: It is recommended to use 1Gbps network interface.

The above are the minimum hardware requirements for Oracle database instances. In actual deployment, the Oracle database server should be planned and adjusted accordingly according to business needs and usage.

2. System installation

First, we need to download the CentOS 6.5 operating system and then install it on the target host. During the installation process, you need to pay attention to the following points:

1. Determine the host name and IP address, and configure the network environment;
2. Select the server type for installation, and there is no need to install a graphical interface. This will reduce system resource usage;
3. When creating a user, it is recommended to create a user named oracle and set a password.

After the installation is complete, update the system software and ensure that the system is in a stable state.

3. Oracle database installation

To install the Oracle database on the CentOS 6.5 operating system, we need to complete the following steps:

1. Install dependent software packages

First, we need to install some necessary software packages to satisfy some dependencies of the Oracle database during the installation process.

$ yum install -y binutils elfutils-libelf elfutils-libelf-devel

gcc gcc-c++ glibc-devel glibc-headers ksh kernel-devel 
libaio libaio-devel libgcc libstdc++ libstdc++-devel 
libX11 libXau libXi libXtst libXrender make numactl 
numactl-devel sysstat unixODBC unixODBC-devel

2. Configure kernel parameters

Before installing the Oracle database, you need to Configure the kernel parameters and add some parameters to meet the requirements of the Oracle database.

Add the following configuration in the /etc/sysctl.conf file:

kernel.sem = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Then execute the following command to activate the configuration file:

$ sysctl -p

3. Create Oracle related directories

Before installing the Oracle database, we need to create some necessary directories in the system files.

$ mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
$ chown -R oracle:oinstall /u01
$ chmod -R 775 /u01

4. Download and unzip the Oracle database software

Download the appropriate version of the Oracle database software from the Oracle official website. Once the download is complete, unzip and execute the installer. Please note that Oracle officially requires that the Oracle database software must be installed in RUNLEVEL 3 mode using the root account. The following are the commands to unzip the Oracle database software:

$ mkdir /tmp/database
$ unzip linux.x64_11gR2_database_1of2.zip -d /tmp/database
$ unzip linux.x64_11gR2_database_2of2.zip -d /tmp/database

After decompression is completed, we need to create the environment variable file oracle_env.sh of the oracle client in the /etc folder. The file content is as follows:

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

export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME /lib:/lib:/usr/lib

5. Execute Oracle database installation program

When executing the installation program, please choose to create a new database. After completing the installation, You need to execute the following two script files:

$ $ORACLE_HOME/root.sh
$ $ORACLE_HOME/network/install/netca

These scripts will start the database and configure the network and Other necessary settings.

4. Connect to the Oracle database

After installing the Oracle database on the CentOS 6.5 operating system, we need to run the SQLPlus tool to connect to the database. We need to log in to the system as the oracle user and run SQLPlus through the following command:

$ sqlplus / as sysdba

Please note that we need to set SYS in the Oracle database configuration file user password. After logging in to SQL*Plus, we can set the SYS user password through the following command:

SQL> alter user sys identified by cb1ebc435675187bdcfb539b370c2e37

When installing the Oracle database, Oracle officially provides Detailed installation guides and documents can help us further understand and master the installation and configuration skills of Oracle database.

Summarize:

Through this article, we learned how to install Oracle database on CentOS 6.5 operating system, including hardware requirements, system installation, Oracle database installation and connection. I hope this article can help you and provide reference and guidance for your Oracle database instance installation and deployment.

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