Installation of Oracle Database "super Detailed text map detailed"

About Oracle
Oracle Database, also known as Oracle RDBMS, or Oracle. is a relational database management system of Oracle Corporation. It 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.
??

Characteristics
1, the Complete data management function: The large amount of data, the persistence of data preservation, data sharing, data reliability
2, complete relations of Products: information Standards---All information about a relational DBMS should be logically represented by a method, the values in the table, guaranteed access guidelines, view Update guidelines---As long as the data in the table that forms the view changes, the data in the corresponding view changes, Independent criteria for data physics and logic
3, Distributed processing function: Oracle database since the 5th edition of the distributed processing capabilities, to the 7th version of the more complete distributed database functionality, an Oracle distributed database by ORACLERDBMS, SQLNet, SQL Connect and other non-Oracle relational products.
4, with Oracle can easily realize the operation of the Data Warehouse.
??

Advantages
High Availability
Strong scalability
Strong data security
Strong stability
??

Installation Environment

Centos7 memory 4G, cpu:2 core, install graphical interface

Install package database, Flash (can be managed using Firefox Web page)
Install package Address: Click to download

Installation action

Turn off firewall self-booting, as well as related features and enhanced security features

# systemctl disable firewalld.service# systemctl stop firewalld.service# setenforce 0

Change host name Oracle

# echo "oracle" > /etc/hostname # echo "192.168.235.132 Oracle" >> /etc/hosts# init 6    // 重启

Create XFS system files/disks and mount the/ORC directory requires no less than 15G

# mkfs.xfs -f /dev/sdb1 # mount /dev/sdb1 /orc

Install the Environment pack

# yum -y install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel

Tuning kernel parameters

  # vim/etc/sysctl.conf  

Fs.aio-max-nr = 1048576
#异步IO请求 The recommended number of values is: 1048576 in fact, it equals 1024*1024 1024K
Fs.file-max = 6815744
#打开的文件句柄的最大数量 To prevent file descriptor exhaustion problems
Kernel.shmall = 20 97152
#共享内存总量 page, Memory divided by 4K
Kernel.shmmax = 4294967295
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128 br> #SEMMSL: Maximum number of signals per signal set Semmns: Used to control the maximum number of signals in the entire Linux system semopm: The kernel parameter is used to control the number of signal operations that each SEMOP system call can perform Semmni: The kernel parameter is used to control the entire Linux Maximum number of signal sets in the system
Net.ipv4.ip_local_port_range = 9000 65500
#用于向外连接的端口范围
Net.core.rmem_default = 262144
# Default value for socket receive buffer size
Net.core.rmem_max = 4194304
#套接字接收缓冲区大小的最大值
Net.core.wmem_default = 262144
# Default value for socket send buffer size
Net.core.wmem_max = 1048576
#套接字发送缓冲区大小的最大值

  # sysctl-p//Reload Config Piece  

User Environment Configuration

# groupadd oinstall# groupadd dba# useradd -g oinstall -G dba oracle# passwd oracle     //设置用户密码# mkdir -p /orc/app/oracle# chown -R oracle:oinstall /orc/app/# chmod -R 755 /orc/app/oracle/

.

    # vim /home/oracle/.bash_profile   //oracle用户环境配置

Umask 022
Oracle_base=/orc/app/oracle
oracle_home=/orc/app/oracle/product/12.2.0/dbhome_1/
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

??
??

• Oracle User Resource Limits

  # vim /etc/pam.d/login  （添加下面2行使用pam_limits认证模块）        session    required     /lib/security/pam_limits.so        session    required     pam_limits.so# vim /etc/security/limits.conf        #单用户可使用的进程数量        oracle        soft    nproc           2047               #用户可打开的文件数量        oracle        hard    nproc           16384        oracle        soft    nofile          1024               #堆栈设置        oracle        hard    nofile          65536        oracle        soft    stack           10240      

  # vim /etc/profile

  if [$USER = "Oracle"]
  Then
  if [$SHELL = "/bin/ksh"]
  Then
  Ulimit-p 16384 #缓冲区大小
  Ulimit-p 65536
  Else
  Ulimit-u 16384-n 65536 number of files #进程数
  Fi
  Fi

?
?

• Oracle Installation
• Attach the extracted database package to the LINUX/ABC

• Operation in Linxu graphical interface

   # xhost +    //以root用户在图形化界面操作

  # su - oracle   //切换oracle用户# cd /abc# export DISPLAY=:0.0# ./runInstaller     //直接进入图形化安装

• Install pop-up window handling-

• Switch to root user

  # /orc/app/oraInventory/orainstRoot.sh# /orc/app/oracle/product/12.2.0/dbhome_1/root.sh

  
  ?
  ?
  ?

• Web interface Management
• installation of RPM package mounted flash
• Use Firefox to browse open
• Add as Secure Web page
• Https://Oracle:5500/em
• Login name: sys password: the password set above is checked: as Sysdba
  ?
  ?
  ?
  
  

?
?

• Using the command line interface

• Sign in with an Oracle user

  $ sqlplus / as sysdba   //登录数据库 （sys用户是oracle的最高管理员所以要加上as  如果是普通用户登录   sqlplus 用户名/密码）SQL> help index     （查看命令列表，sql中不区分大写小写）SQL> show user       （查看当前用户）

?
?

?
?

• Create a database

• Sign in with an Oracle user

  $  dbca     //(如果不弹窗口执行: export DISPLAY=:0.0)1：选择创建数据库2：输入全局数据库名、管理口令和确认口令、取消创建为容器数据库

?
?

?
?

• Enable monitoring

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

Installation of Oracle Database "super Detailed text map detailed"