Installing Oracle 12c in CENTOS7 deployment

Oracle database is a leading product in the field of database. It can be said that Oracle database system is currently the world's popular relational database management system, System portability, easy to use, strong function, applicable to all kinds of large, medium, small, microcomputer environment. It is a highly efficient and reliable database solution that adapts to high throughput.
Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage your database cloud. In addition, some of the innovative features maximize resource utilization and flexibility, such as Oracle Multitenant can quickly consolidate multiple databases, while automatic data optimization and heat map can compress and tier data at higher densities. These unique technological advancements, combined with major enhancements in availability, security, and big Data support, make Oracle database 12c an ideal platform for private and public cloud deployments.

This time for the construction of a brief introduction, how to install oracle12c in the CENTOS7 system.

Environment preparation

• CENTOS7 virtual Machines
• ip:172.16.10.25
• 4G physical memory, 8G virtual memory
• Oracle's installation folder is not less than 15G
• Allocating more than two processors to a virtual machine
• Disk SSD
  The above virtual machine configuration is not a hard requirement, remove the installation directory size, in order to install the experience
  Pre-Installation Preparation
• Shutting down firewalls and selinux firewalls

  systemctl disable firewalld.service systemctl stop firewalld.servicesetenforce 0

• Modify Host Name

  vim /etc/hostnameoracle

• Modify the Hosts file

  vim /etc/hosts172.16.10.25 oracle     //直接在配置文件末行添加即可

• Restarting a virtual machine

  reboot

  Install Oracle 12c Software Environment Pack installation

  [[email protected] ~]# yum -y install binutils > compat-libcap1 > compat-libstdc++-33 > gcc-c++ > glibc > glibc-devel > ksh > libaio > libaio-devel > libgcc > libstdc++ > libstdc++-devel > libXi > libXtst > make > sysstat > unixODBC > unixODBC-devel

  Kernel parameter tuning

  vim /etc/sysctl.conffs.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   //套接字发送缓冲区大小的最大值sysctl -p    //不属于配置文件内容，重新加载配置文件

  User Environment Configuration

  groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oracle      //指定组为oinstall附加组dbapasswd oracle                                     //创建oracle用户密码mkdir -p /orc/app/oraclechown -R oracle:oinstall /orc/app/chmod -R 755 /orc/app/oracle/

  Oracle User Environment Configuration

  vim /home/oracle/.bash_profileumask 022ORACLE_BASE=/orc/app/oracleORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ORACLE_SID=orclNLS_LANG="SIMPLIFIED CHINESE_CHINA".UTF8PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/binLANG=zh_CN.UTF-8export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID

  Oracle User Resource Limits

  vim /etc/pam.d/loginsession    required     /lib/security/pam_limits.sosession    required     pam_limits.so

  vim /etc/security/limits.conforacle        soft    nproc           2047       //单用户可使用的进程数量oracle        hard    nproc           16384oracle        soft    nofile          1024       //用户可打开的文件数量oracle        hard    nofile          65536oracle        soft    stack           10240      //堆栈设置//该配置文件中均为注释文件，只需在末行添加即可

  vim /etc/profileif [ $USER = "oracle" ]thenif [ $SHELL = "/bin/ksh" ] then   ulimit -p 16384                  //缓冲区大小   ulimit -p 65536else ulimit -u 16384 -n 65536           //进程数  文件数fifi                                      //配置文件末行直接添加

  Oracle Installation

  Mount the extracted Oracle installation files to the Linux/opt folder

  xhost +    //以root用户在图形化界面操作su - oracle   //切换oracle用户cd /chenexport DISPLAY=:0.0  //调整分辨率./runInstaller

  Graphical interface Installation

  
  
  
  
  

  Processing method of pop-up window during installation

  /orc/app/oraInventory/orainstRoot.sh/orc/app/oracle/product/12.2.0/dbhome_1/root.sh   //重新打开新的终端，以root用户运行

  Web interface Management
• The management address is indicated on the installation completed interface.
  
• The Web interface uses Flash plugins and requires manual installation

  rpm -ivh flash-player-npapi-26.0.0.131-release.x86_64.rpm

• Log in using your account password on the login screen

  账户：sys密码是在安装数据库是设置的口令

  Character Interface Login

  User to switch to Oracle

  sqlplus / as sysdba    //sys用户是oracle的最高管理员所以要加上ashelp index                  //查看命令列表，sql中不区分大写小写show user                  //查看当前用户

  Create a database

  [[email protected] ~]$ dbca     //会自动跳转出，如果不弹窗口执行: export DISPLAY=:0.0

  1. Select Create Database
  2. Enter global database name, manage password and Confirm password, cancel create to enable listener for container database

     [[email protected] ~]$ lsnrctl LSNRCTL> startTNS-01106: 使用名称LISTENER的监听程序已经启动[[email protected] ~]$ lsnrctl stop正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Oracle)(PORT=1521)))命令执行成功

Installing Oracle 12c in CENTOS7 deployment