Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install Oracle database on Linux". In daily operation, I believe many people have doubts about how to install Oracle database on Linux. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to install Oracle database on Linux". Next, please follow the editor to study!

First, prepare the environment

Operating system version: CentOS 6.5

The version of Oracle database is: Oracle-11.2.0.4.0

1. Modify the server hostname

(1) modify network file vi / etc/sysconfig/networkNETWORKING=yesHOSTNAME=hostname (2) modify hosts file vi / etc/hosts10.119.99.99 hostname (3) effective hostname 2, disk partition

For more information, please see the linux disk partition section.

3. Configure yum source

For more information, please see configuring yum sources.

Second, install the database

1. Configure Xwindowyum groupinstall "X Window System" 2 and comment out the operating system version vim / etc/redhat-release#CentOS release 6.5 (Final). Plus the following Red Hat Enterprise Linux 63, Install the related package yum-y install\ binutils\ compat-libcap1\ compat-libstdc++-33\ compat-libstdc++-33*.i686\ elfutils-libelf-devel\ gcc\ gcc-c++\ glibc*.i686\ glibc\ glibc-devel\ glibc-devel*.i686\ ksh\ libgcc*.i686\ libgcc\ libstdc++*.i686\ libstdc++-devel\ libstdc++-devel*.i686\ libaio\ libaio*.i686\ libaio-devel\ libaio-devel*.i686\ make\ sysstat\ unixODBC\ unixODBC*.i686\ unixODBC -devel\ unixODBC-devel*.i686\ libXp Note: Oracle12c needs to install the smartmontools-5.43-1.el6.x86_64 installation package yum install smartmontools4, Modify linux system configuration

Log in through root user

(1) modify the restrictions of users:

Vi / etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 32768

(2) modify the password verification file:

Vi / etc/pam.d/loginsession required / lib64/security/pam_limits.sosession required pam_limits.so

(3) modify the system kernel file:

Vi / etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.sem = 25032000100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576 Parameter effective: sysctl-p

(4) modify the environment variable file:

Vi / etc/profile if [$USER = "oracle"]; then if [$SHELL = "/ bin/ksh"]; then ulimit-p 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fifi

(5) create oracle users and groups:

A: create a group and use the following command groupadd oinstallgroupadd dbaB: create an oracle user and set the password, such as the command useradd-g oinstall-G dba oracleecho "oracle" | passwd-- stdin password

(6) create a database software directory and a data file storage directory:

Mkdir-p / home/oracle/appmkdir-p / home/oracle/app/oraclemkdir-p / home/oracle/app/oradatamkdir-p / home/oracle/app/oracle/productmkdir-p / home/oracle/oraInventory grants directory permissions to oracle users: chown-R oracle:oinstall / home/oracle/

(7) upload the installation package and decompress it

Extract the installation package to the directory / home/oracle/app/databasechmod-R 755 / home/oracle/app/database

(8) modify oracle user environment variables:

Su-oraclevi .bash _ profileexport ORACLE_BASE=/home/oracle/appexport ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1export ORACLE_SID=orclexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

(9) call up the graphical interface

If xhost + fails to call up, check the tunnel settings of xshell and execute the following: export DISPLAY= server IP:0.05, installation

(1) execute the installation script

Switch oracle user su-oracle./runInstaller

(2) execute shell script

Open a new interface and switch to root user / home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh/home/oracle/app/oraInventory/orainstRoot.sh

(3) create a database

(4) configure monitoring

(5) testing

At this point, the study on "how to install Oracle database on Linux" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.