Shulou(Shulou.com)06/01 Report--

Introduction to installation and deployment of Oracle 12c based on CentOS7

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. It is one of the most popular client / server (CLIENT/SERVER) or Bram S architecture databases at present. The latest version of the Oracle database is Oracle Database 12c. Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage database clouds.

Characteristics

1. Complete data management functions:

1) large amount of data 2) persistence of data preservation 3) sharing of data 4) Reliability of data

2. Products with complete relationships:

1) Information criteria-all information in a relational DBMS should be logically expressed in a way that values in the table are explicitly represented; 2) criteria for guaranteed access; 3) criteria for view update-as long as the data in the table that forms the view changes, the data in the corresponding view changes at the same time. 4) data physical and logical independence criteria.

3. Distributed processing function:

ORACLE database has provided distributed processing capabilities since version 5, and has relatively perfect distributed database functions by version 7. An ORACLE distributed database is composed of oraclerdbms, sql*Net, SQL*CONNECT and other non-ORACLE relational products. [2]

4. The operation of data warehouse can be easily realized with ORACLE.

Advantages

■ is highly available

■ is scalable.

■ data has strong security.

■ has strong stability.

CentOS7 installation and deployment Oracle 12c system configuration

CentOS7 system

Memory: 4GB and above

Swap: 8GB (twice the physical memory)

Cpu: dual core

The free space of the folder where Oracle is installed requires 15GB or above. This machine is 20GB.

Install packages database, flash (can be managed using Firefox web web pages)

Install operation turn off firewall and enhanced security function systemctl disable firewalld.servicesystemctl stop firewalld.servicesetenforce 0 modify hostname to oraclevim / etc/hostname

HOSTNAME=oracle

Add local resolution

Echo "192.168.234.188 oracle" > > / etc/hosts

The host name has been changed and will not take effect until it is rebooted.

Reboot

Install Oracle 12c install software 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

Modify kernel parameters

Vim / etc/sysctl.conf

Fs.aio-max-nr = 1048576 # number of asynchronous IO requests the recommended value is: 1048576 it is actually equal to 1024024, that is, the maximum number of fs.file-max = 6815744 # open file handles, kernel.shmall = 2097152 # total shared memory page to prevent file descriptor exhaustion. Memory divided by 4K kernel.shmmax = 4294967295 kernel.shmmni = 4096kernel.sem = 250100128 # 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 net.ipv4.ip_local _ port_range = 9000 65500 # Port range for outgoing connections net.core.rmem_default = 262144 # default value for socket receive buffer size net.core.rmem_max = 4194304 # maximum socket receive buffer size net.core.wmem_default = 262144 # default value for socket send buffer size net.core.wmem_max = 1048576 # maximum socket send buffer size

Reload the configuration file

Sysctl-p

Configuration of user environment

Groupadd oinstall # create an oinstall group

Groupadd dba # create a dba group

Useradd-g oinstall-G dba oracle # create oracle user

Passwd oracle # password 123123

Mkdir-p / orc/app/oracle # create a working directory for oracle

Chown-R oracle:oinstall / orc/app/ # modifies the owner and group of the directory

Chmod-R 755 / orc/app/oracle/ # Recursive permissions to modify the Oracle directory

Oracle user environment configuration

Vim / home/oracle/.bash_profile

Umask 022 # permissions (reverse mask) bash directory definition for ORACLE_BASE=/orc/app/oracle # Oracle ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ # Oracle home directory definition ORACLE_SID=orcl NLS_LANG= "SIMPLIFIED CHINESE_CHINA" .UTF8 PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin # redefine system environment variable LANG=zh_CN.UTF-8 # define character set export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID # import environment variable

Oracle user resource restrictions enable pam_limits authentication module

Vim / etc/pam.d/login

/ / add session required / lib/security/pam_limits.sosession required pam_limits.so on the last line

Vim / etc/security/limits.conf

Oracle soft nproc 2047 # number of processes available to a single user oracle hard nproc 16384oracle soft nofile 1024 # number of files that a user can open oracle hard nofile 65536oracle soft stack 10240 # stack setting

Edit / etc/profile file

Vim / etc/profile

/ / add if [$USER = "oracle"] then if [$SHELL = "/ bin/ksh"] then ulimit-p 16384 # buffer size ulimit-p 65536 else ulimit-u 16384-n 65536 # number of processes fifi

Oracle 12c installation (operated in graphical interface)

Xhost + # wipes the total with root users in the graphical interface

Su-oracle # switch user to oracle user

Cd / abc/oracle/

Export DISPLAY=:0.0 # adjust resolution

. / runInstaller # enable execute installation

The pop-up window processing executes the following script during installation (root user is required)

/ orc/app/oraInventory/orainstRoot.sh

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

After the installation is complete, you will see the management address in the completion interface.

Web interface management

Install the flash plug-in

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

The user here is sys, and the password is the password set by yourself.

Command line login

Switch to oracle user

Su-oracle

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.