The installation process of Oracle Database under Linux system
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!
