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
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)
- Installation action
- 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
- 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 #导入环境变量
- 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 #堆栈设置
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
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
Switch to Oracle User
Su-oracle
Deploy Oracle 12c based on CentOS7 installation