Essentials of Oracle Database installation process under Linux

1, Data Preparation: Oracle installation files, Linux RAR decompression tools, XMANAGER5, Linux system image or DVD (without network conditions required)

2, Environment preparation: Linux Set up Oracle users

groupadd  oinstall groupadd  -G oinstall-g dba-m Oraclepasswd  Oracle

New Oracle directory under Linux to ensure sufficient disk space

Mkdir-p/data/oracle #oracle数据库安装目录

Mkdir-p/data/orainventory #oracle数据库配置文件目录

Mkdir-p/data/database #oracle数据库软件包解压目录

Give Oracle Permissions

Chown-r oracle:oinstall/data/oracle #设置目录所有者为oinstall用户组的oracle用户

Chown-r oracle:oinstall/data/orainventory

Chown-r Oracle:oinstall/data/database

Modify the Linux system parameters and modify the contents of the following files according to the actual situation

VI/etc/sysctl.conf Add the following content fs.file-max =6815744Fs.aio-MAX-NR =1048576Kernel.shmall=2097152Kernel.shmmax=2147483648#原文件中可能比之更大 Kernel.shmmni=4096Kernel.sem= - 32000  -  -Net.ipv4.ip_local_port_range=9000 65500#有1024 65500 Net.core.rmem_default=4194304Net.core.rmem_max=4194304Net.core.wmem_default=262144Net.core.wmem_max=1048576Source/etc/sysctl.conf

Modify the user's shell limit

VI  /etc/security/limits.conf    Add the following    content 2047    16384      1024x768 65536    

Modify the/etc/pam.d/login file

VI  /etc/pam.d/Login  Add session   required    /lib/security/pam_limits.so  session   Required    pam_limits.so

Edit/etc/profile

VI/etc/Profile Add the following contentif[$USER ="Oracle"]; Then                       if[$SHELL ="/bin/ksh"]; ThenUlimit-P16384Ulimit-N65536                       ElseUlimit-U16384-N65536                       fi                      fi

Configuring the Oracle User Environment

VI /home/oracle/
#在最后添加以下代码export oracle_base=/data/ORACLE #oracle数据库安装目录export oracle_home= $ORACLE _base/product/ 11.2. 0/db_1 #oracle数据库路径export oracle_sid=ORCL #oracle启动数据库实例名export oracle_term=xterm # Xterm window mode installation export PATH= $ORACLE _home/bin:/usr/sbin: $PATH #添加系统环境变量export Ld_library_path= $ORACLE _ home/lib:/lib:/usr/Lib #添加系统环境变量export #防止安装过程出现乱码export nls_lang=American_america. ZHS16GBK  #设置Oracle客户端字符集, must be consistent with the set of character sets at Oracle installation, such as: ZHS16GBK, otherwise the data import export Chinese garbled problem: Wq! #保存退出source. Bash_profile #使设置立刻生效

3. Oracle Installation

Direct installation, the middle will have the process of checking the package, if a package is missing, if there is no network, you need to configure the local image in Yum as a local source, as follows

Mount the ISO or DVD first

Mount –o loop–t iso9660 centos-6.0-i386-bin-dvd.isoMount /dev/cdrom  /media/ CDRom

Edit /etc/yum.repos.d/ Local.repo file

vim Local.repo (repo suffix) add the following [Local_server] (library name)name =thisis a local repo (name description) BaseURL=file ://Media/dvd (Yum source directory, source address)enabled=1(whether the Yum source is enabled, 0 is disabled) gpgcheck=1  (check gpg-key,0 for no check, 1 for check) gpgkey=file:///etc/pki/rpm-gpg/ Rpm-gpg-key-centos-6 (no configuration required when gpgcheck=0)

Back up the original. Repo file to a different location

Yum Clean All
Yum Makecache   

Install the package as needed

4. Errors during installation

(1) Monitoring does not start up

Edit the/etc/hosts file, map IP and host name

(2) Character Set issues

The character set required for export

(3) Oracle Admin Console Chinese button garbled

Need to add the italicized word body to the Oracle JRE, which can be queried by the network.

Essentials of Oracle Database installation process under Linux