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

This article mainly introduces "the installation process of Oracle database under the Linux system". In the daily operation, I believe that many people have doubts about the installation process of Oracle database under Linux system. 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 about "the installation process of Oracle database in Linux system". Next, please follow the editor to study!

1. Kernel parameters and restrictions are changed 1. Edit the / etc/sysctl.conf file and add the following

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 16069803776

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

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

# sysctl-p to make the parameter effective

two。 Edit the / etc/security/limits.conf file and add the following

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

Oracle hard stack 32768

Create users and user groups

Installation of oracle database requires oracle users and groups dba, oinstall, oper groups

1. Create groups and users

# groupadd-g 501 oinstall

# groupadd-g 502 dba

# groupadd-g 503 oper

# useradd-g oinstall-G dba,oper-u 501-d / home/oracle oracle

Parameter description-g specifies the user group

-G specifies additional group

-d specify user directory

Activate oracle user (change oracle user password)

# passwd oracle

two。 Check oracle users

# id oracle

Uid=501 (oracle) gid=501 (oinstall) groups=501 (oinstall), 503 (oper), 502 (dba)

Create directories and assign permissions

# mkdir-p / u01/app/oracle/product/11.2.0/db_1

# mkdir-p / u01/setup/os-- for storing iso files in the operating system

# mkdir-p / u01/setup/db-for storing software package files

# chown-R oracle:oinstall / U01

# chown-R oracle:oinstall / oradata

# chown-R oracle:oinstall / backup

# chown-R oracle:oinstall / archivelog

# chmod-R 775 / U01

# chmod-R 775 / oradata

# chmod-R 775 / backup

# chmod-R 775 / archivelog

Note: in a normal production environment, we install the database software (ORACLE_HOME) locally and the data (oradata/backup/archivelog) in storage

Fourth, write environmental variables

# su-oracle

$vi .bash _ pfile

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

Export ORACLE_SID=bhtcdb

Export NLS_LANG='AMERICAN_AMERICA.ZHS16GBK'

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Export PATH=$PATH:/sbin:/usr/lbin:/usr/sbin:$ORACLE_HOME/bin:$ORACLE_HOME/lib

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Fifth, configure the local yum source and install rpm package 1. Configure a local yum source

# mount-o loop / u01Universe setupUnix * / mnt

# yum-config-manager-- add-repo file:///mnt

# vi / etc/yum.repos.d/mnt.repo

Add the following

[mnt]

Name=Yum Source

Baseurl= file:///mnt

Enabled=1

Gpgcheck=0

# yum makecache

two。 Install the following packages

[root@rac01 opt] # yum install-y binutils compat* elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio libgcc libstdc++ libstdc++-devel make sysstat unixODBC-devel libaio-devel ksh

6. Database software installation 1. Extract the uploaded software package

[oracle@cqtc1 ~] $cd / u01/setup/db/

[oracle@cqtc1 db] $ls

P13390677_112040_Linux-x86-64_1of7.zip p13390677_112040_Linux-x86-64_2of7.zip

$unzip p13390677_112040_Linux-x86-64_1of7.zip

$unzip p13390677_112040_Linux-x86-64_2of7.zip

two。 Install database software

Open xmanager-passive

$export DISPLAY=IP:0.0

$cd database/

$. / runInstaller-run

Pdksh package error description: there is no such package in the RHEL operating system, but there is a ksh package. These two packages have the same effect, so we can ignore this error when we install the ksh package.

OK, database software installation completed

At this point, the study on "the installation process of Oracle database in Linux system" 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.