Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to deploy and install Oracle 12c in Centos7, which has a certain reference value, and interested friends can refer to it. I hope you can learn a lot after reading this article.

Oracle database is a leading product in the field of database. It can be said that Oracle database system is a popular relational database management system in the world at present. The system has good portability, easy to use and strong function, and is suitable for all kinds of large, medium, small and microcomputer environments. It is a database solution with high efficiency and good reliability, which adapts to high throughput.

Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage database clouds. In addition, some 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 layer data at higher density. These unique technological advances, coupled with major enhancements in availability, security, and big data support, make Oracle Database 12c an ideal platform for private and public cloud deployments.

Environmental preparation

Centos7 virtual machine

IP:172.16.10.25

4G physical memory, 8G virtual memory

The installation folder of Oracle is not less than 15g.

Assign more than two processors to the virtual machine

Disk SSD

Software package: Oracle 12c

The above virtual machine configuration is not a rigid requirement, except for the size of the installation directory, for the installation experience

Pre-installation preparation

Turn off the firewall and selinux firewall

Systemctl disable firewalld.service systemctl stop firewalld.servicesetenforce 0

Modify hostname

Vim / etc/hostnameoracle

Modify the hosts file

Vim / etc/hosts172.16.10.25 oracle / / can be added directly at the end of the configuration file

Restart the virtual machine

Reboot install Oracle 12c software environment package install [root@oracle ~] # yum-y install binutils\ > compat-libcap1\ > compat-libstdc++-33\ > gcc-c++\ > glibc\ > glibc-devel\ > ksh\ > libaio-devel\ > libgcc\ > libstdc++\ > libstdc++-devel\ > libXi\ > libXtst\ > make\ > unixODBC\ > unixODBC-devel kernel parameter adjustment vim / etc/sysctl.conffs.aio-max-nr = 1048576 / / Asynchronous The recommended value for the number of IO requests is: 1048576. In fact, it is equal to 1024K fs.file-max = 6815744 / / the maximum number of open file handles. The problem of preventing file descriptor exhaustion kernel.shmall = 2097152 / / Total shared memory page is in units Memory divided by 4K kernel.shmmax = 4294967295 kernel.shmmni = 4096kernel.sem = 250 32000 100 128 / / SEMMSL: maximum number of signals per signal set SEMMNS: maximum number of signals used to control the entire Linux system SEMOPM: kernel parameters are used to control the number of signal operations that can be performed per semop system call SEMMNI: kernel parameters are used to control the maximum number of signal sets in the entire Linux system Local_port_range = 9000 65500 / / Port range for outgoing connections net.core.rmem_default = 262144 / / default value of socket receive buffer size net.core.rmem_max = 4194304 / / maximum size of socket receive buffer size net.core.wmem_default = 262144 / / default value of socket send buffer size net.core.wmem_max = 1048576 / / socket send buffer size The small maximum value sysctl-p / / is not part of the profile. Reload the configuration file

User environment configuration groupadd oinstallgroupadd dbauseradd-g oinstall-G dba oracle/ / specify group for oinstall additional group dbapasswd oracle/ / create oracle user password 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 restrictions vim / etc/pam.d/loginsession required / lib/security/pam_limits.sosession required pam_limits.so

Vim / etc/security/limits.conforacle soft nproc 2047 / / number of processes available to a single user oracle hard nproc 16384oracle soft nofile 1024 / number of files that users can open oracle hard nofile 65536oracle soft stack 10240 / / Stack Settings / / all comment files are in this configuration file Just add vim / etc/profileif [$USER = "oracle"] thenif [$SHELL = "/ bin/ksh"] then ulimit-p 16384 / / buffer size ulimit-p 65536else ulimit-u 16384-n 65536 / / number of processes files fifi / / add oracle installation directly at the last line of the configuration file

Mount the extracted oracle installation files to the linux / opt folder

Xhost + / / use root user to operate su-oracle / / switch oracle user cd / chenexport DISPLAY=:0.0 / / adjust resolution in graphical interface. / runInstaller

Graphical interface installation

Treatment method of pop-up window in the process of installation

/ orc/app/oraInventory/orainstRoot.sh/orc/app/oracle/product/12.2.0/dbhome_1/root.sh / / reopen the new terminal to run as the root user

Web interface management

The administrative address is indicated on the completed installation interface.

The web interface uses the flash plug-in and needs to be installed manually

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

Use the account password to log in in the login interface

Account: the sys password is the password set when the database is installed

Character interface login

Users want to switch to oracle

Sqlplus / as sysdba / / sys user is the top administrator of oracle, so add ashelp index / / to view the command list, sql is not case-sensitive show user / / View the database created by the current user [oracle@Oracle ~] $dbca / / will automatically jump out, if you do not pop the window to execute: export DISPLAY=:0.0

Choose to create a database

Enter global database name, administrative password and confirmation password, cancel creation as container database

Enable listener [oracle@Oracle ~] $lsnrctl LSNRCTL > startTNS-01106: the listener using the name LISTENER has started [oracle@Oracle ~] $lsnrctl stop is connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=Oracle) (PORT=1521). Thank you for reading this article carefully. I hope the article "how to deploy and install Oracle 12c in Centos7" shared by the editor will be helpful to you. At the same time, I hope you will support it. Pay attention to the industry information channel, more related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.