Deploy Oracle 12c based on CentOS7 installation

Source: Internet
Author: User
Tags dba

Introduction to deploying Oracle 12c based on CentOS7 installation

Oracle Database, also known as Oracle RDBMS, or Oracle. is a relational database management system of Oracle Corporation. is one of the most popular client/server (client/server) or B/s architectures in the current database. Oracle database 12c is the latest version. Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage your database cloud.

Characteristics

1, the Complete data management function:

1)数据的大量性2)数据的保存的持久性3)数据的共享性4)数据的可靠性

2, complete relations of products:

1)信息准则---关系型DBMS的所有信息都应在逻辑上用一种方法,即表中的值显式地表示;2)保证访问的准则3)视图更新准则---只要形成视图的表中的数据变化了,相应的视图中的数据同时变化4)数据物理性和逻辑性独立准则

3. Distributed processing function:

ORACLE数据库自第5版起就提供了分布式处理能力,到第7版就有比较完善的分布式数据库功能了,一个ORACLE分布式数据库由oraclerdbms、sql*Net、SQL*CONNECT和其他非ORACLE的关系型产品构成。[2]

4, with Oracle can easily realize the operation of the Data Warehouse.

Advantages

High Availability

Strong scalability

Strong data security

Strong stability

CENTOS7 Installation Deploy Oracle 12c
    • System Configuration

CentOS7 system
Memory: 4GB and above
SWAP:8GB (twice times the physical memory)
CPU: Dual Core
Install Oracle's folder free space to be 15GB or above, this machine is 20GB
Install package database, Flash (can be managed using Firefox Web page)

    1. Installation action
    • Turn off firewalls and enhanced security features
      systemctl disable firewalld.servicesystemctl stop firewalld.servicesetenforce 0
    • Modify host name to Oracle
      vim /etc/hostname

      Hostname=oracle

    • Add Local resolution

      echo "192.168.234.188 Oracle" >>/etc/hosts

    • Modified hostname only reboot will take effect

      Reboot

    1. Installing Oracle 12c
    • Install the Software Environment pack

Yum-y install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc li bstdc++ libstdc++-devel libxi libxtst make Sysstat UnixODBC unixodbc-devel

    • modifying kernel parameters

Vim/etc/sysctl.conf

fs.aio-max-nr = 1048576   #异步IO请求数目 推荐值是:1048576 其实它等于 1024*1024 也就是 1024K 个fs.file-max = 6815744   #打开的文件句柄的最大数量,防止文件描述符耗尽的问题kernel.shmall = 2097152 #共享内存总量 页为单位,内存除以4K所得kernel.shmmax = 4294967295  kernel.shmmni = 4096kernel.sem = 250 32000 100 128  #SEMMSL: 每个信号集的最大信号数量 SEMMNS:用于控制整个 Linux 系统中信号的最大数 SEMOPM: 内核参数用于控制每个 semop 系统调用可以执行的信号操作的数量 SEMMNI :内核参数用于控制整个 Linux 系统中信号集的最大数量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   #套接字发送缓冲区大小的最大值

    • Reload the configuration file

Sysctl-p

    1. Configuration of the user environment

Groupadd Oinstall #创建oinstall组
Groupadd DBA #创建dba组
USERADD-G oinstall-g dba Oracle #创建oracle用户
passwd Oracle #密码123123
Mkdir-p/orc/app/oracle #创建oracle的工作目录
Chown-r oracle:oinstall/orc/app/#修改目录的属主, genus Group
Chmod-r 755/orc/app/oracle/#递归修改Oracle目录的权限

    • Oracle User Environment Configuration

Vim/home/oracle/.bash_profile

umask 022                                       #权限(反掩码)ORACLE_BASE=/orc/app/oracle                          #Oracle的bash目录定义ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/             #Oracle的home目录定义ORACLE_SID=orcl              NLS_LANG="SIMPLIFIED CHINESE_CHINA".UTF8                       PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin             #重新定义系统环境变量               LANG=zh_CN.UTF-8                    #定义字符集export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID                      #导入环境变量

    1. Oracle User Resource Limits
    • Enable the Pam_limits authentication module

Vim/etc/pam.d/login

     //末行添加session    required     /lib/security/pam_limits.sosession    required     pam_limits.so

Vim/etc/security/limits.conf

oracle        soft    nproc           2047          #单用户可使用的进程数量oracle        hard    nproc           16384oracle        soft    nofile          1024           #用户可打开的文件数量oracle        hard    nofile          65536oracle        soft    stack           10240         #堆栈设置

    • Edit/etc/profile File

Vim/etc/profile

      //末行添加if [ $USER = "oracle" ] then   if [ $SHELL = "/bin/ksh" ]     then       ulimit -p 16384       #缓冲区大小       ulimit -p 65536   else     ulimit -u 16384 -n 65536    #进程数  文件数   fifi

Oracle 12c Installation (operation in graphical interface)

Xhost + #以root用户在图形化界面擦欧总
Su-oracle #切换用户至oracle用户
cd/abc/oracle/
Export display=:0.0 #调整分辨率
./runinstaller #开启执行安装

    • Pop-up window handling during installation
    • Execute the following script (root user required)

      /orc/app/orainventory/orainstroot.sh
      /orc/app/oracle/product/12.2.0/dbhome_1/root.sh

When the installation is complete, you will see the management address on the completion screen

    • Web interface Management

Installing the Flash Plugin

RPM-IVH flash-player-npapi-26.0.0.131-release.x86_64.rpm

The user here is sys, password is the password that you set before

    • Command line Login

Switch to Oracle User

Su-oracle

Deploy Oracle 12c based on CentOS7 installation

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.