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

Introduction to ultra-simple Oracle 12c installation:

Oracle Database, also known as OracleRDBMS, or Oracle for short. It is a relational database management system of Oracle. It 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.

System introduction:

ORACLE database system is a group of software products with distributed database as the core provided by ORACLE (Oracle). It is one of the most popular client / server (CLIENT/SERVER) or Bhand S architecture databases.

For example, SilverStream is a kind of middleware based on database. ORACLE database is the most widely used database management system in the world. As a general database system, it has complete data management function.

As a relational database, it is a complete relational product; as a distributed database, it realizes the distributed processing function. But with all its knowledge, as long as you learn ORACLE knowledge on one model, you can use it on all types of machines.

Installation conditions: 1. At least 4G physical memory and 8G virtual memory. two。 Prepare a new disk of no less than 15g. This case environment: operating system: CentOS 7.3x86x64 install Oracle: 1. Add disk, change hostname, associate: vim / etc/hostname # change hostname OracleHOSTNAME=oracle # add vim / etc/hosts192.168.217.134 oracle # associate local address 2. Restart the machine and change the disk properties: fdisk / dev/sdb # enter the newly added disk to process [root@oracle] # mkfs-t xfs / dev/sdb1 # convert xfs format meta-data=/dev/sdb1 isize=512 agcount=4, agsize=1310656 blks = sectsz=512 attr=2, projid32bit=1 = crc=1 finobt=0 Sparse=0data = bsize=4096 blocks=5242624, imaxpct=25 = sunit=0 swidth=0 blksnaming = version 2 bsize=4096 ascii-ci=0 ftype=1log = internal log bsize=4096 blocks=2560, version=2 = sectsz=512 sunit=0 blks, lazy-count=1realtime = none extsz=4096 blocks=0, rtextents=0mkdir / orcmount / dev/sdb1 / orc # mount 3. Install the software environment package: 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-devel4. Adjust kernel parameters: vim / etc/sysctl.conf # add the following fs.aio-max-nr = 1048576 # number of asynchronous IO requests the recommended value is: 1048576 it is actually equal to 1024024, that is, 1024K fs.file-max = 6815744 # the maximum number of open file handles to prevent file descriptor exhaustion kernel.shmall = 2097152 # total shared memory pages Memory divided by 4K kernel.shmmax = 4294967295 kernel.shmmni = 4096kernel.sem = 250100128 # SEMMSL (32000): maximum number of signals per semaphore set # SEMMNS (32000): maximum number of signals used to control the entire Linux system # SEMOPM (32000): kernel parameters are used to control the number of signal operations that can be performed per semop system call # SEMMNI (128): kernel parameters are used to control the entire Linux Maximum number of signal sets in the system net.ipv4.ip_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 socket receive buffer size net.core.wmem_default = 262144 # default value of socket send buffer size net.core.wmem_max = 1048576 # maximum size of socket send buffer sysctl-p # reload configuration file 5. User environment configuration: groupadd oinstall # create group installation group groupadd dba # create group management group useradd-g oinstall-G dba oracle # administrative user passwd oracle # set password mkdir-p / orc/app/oracle # working directory chown-R oracle:oinstall / orc/app/ chmod-R 755 / orc/app/oracle/vim / home/oracle/.bash_profile # oracle user environment configuration # remove PATH=$PATH : $HOME/.local/bin:$HOME/binexport PATH# add umask 022 # permission to create files ORACLE_BASE=/orc/app/oracle # installation directory ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ # product working directory ORACLE_SID=orcl # instance NLS_LANG= "SIMPLIFIED CHINESE_CHINA" .UTF8 # simplified Chinese PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin # oracle command import Environment variable LANG=zh_CN.UTF-8 # character set export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID # Import 6.oracle user resource restrictions: vim / etc/pam.d/login # manage limits# add session required / lib/security/pam_limits.so session required pam_limits.sovim / etc/security/limits.conf# add oracle soft nproc 2047 # single user can Number of processes used soft limit hard limit oracle hard nproc 16384oracle soft nofile 1024 # number of files that users can open oracle hard nofile 65536oracle soft stack 10240 # Stack setting vim / etc/profile# insert if [$USER = "oracle"] then if [$SHELL = "/ bin/ksh"] Then ulimit-p 16384 # buffer size kb unit ulimit-n 65536 # number of files else ulimit-u 16384-n 65536 # number of files fifi7. Unpack the installation package and install oracle Operate in the graphical interface: [root@oracle ~] # xhost + # display the graphical interface access control disabled with root user operation authorization in the graphical interface, clients can connect from any hostsu-oracle # switch oracle user export DISPLAY=:0.0 # set DISPLAY environment variable cd / abc/oracle # switch to oracle installation package location [oracle@oracle oracle] $. / runInstaller # installation is starting Oracle Universal Installer... Check temporary space: must be greater than 500 MB. The actual swap space is 11122 MB by checking: it must be greater than 150 MB. Actually check the monitor for 8191 MB: the monitor configuration must display at least 256colors. Actually launch Oracle Universal Installer / tmp/OraInstall2018-07-1709-17-43AM for 16777216 by preparing to launch it from the following address. Just a moment, please.

Tip: a prompt will pop up when installing to 79%. You need to execute the command in root. Click OK: [root@oracle ~] # / orc/app/oraInventory/orainstRoot.sh to change permissions / orc/app/oraInventory. Add read and write permissions for the group. Removes global read, write, and execute permissions. Change the group name / orc/app/oraInventory to oinstall. The execution of the script is complete. [root@oracle ~] # / orc/app/oracle/product/12.2.0/dbhome_1/root.shPerforming root user operation.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / orc/app/oracle/product/12.2.0/dbhome_1Enter the full pathname of the local bin directory: [/ usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the / etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Do you want to setup Oracle Trace File Analyzer (TFA) now? Yes | [no]: yesInstalling Oracle Trace File Analyzer (TFA). Log File: / orc/app/oracle/product/12.2.0/dbhome_1/install/root_oracle_2018-07-17 September 09-33-07-445808435.logFinished installing Oracle Trace File Analyzer (TFA) 8. Link database: use the command line interface: [root@oracle ~] # su-oracle Last login: July 17 09:43:58 CST 2018 [oracle@oracle ~] $sqlplus / as sysdba # sys user is the top administrator of oracle, so add asSQL*Plus: Release 12.2.0.1.0 Production on Tuesday July 17 09:48:54 2018Copyright (c) 1982, 2016, Oracle. All rights reserved. Connect to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit ProductionSQL > web Interface Management:

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.