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

1. Add a hard disk to the virtual machine and format it

[root@localhost ~] # systemctl stop firewalld.service # # disable firewall [root@localhost ~] # setenforce 0 [root@localhost ~] # systemctl disable firewalld.service # # enable and do not automatically start [root@localhost ~] # fdisk / dev/sdb # # partition Welcome to fdisk (util-linux 2.23.2). The changes remain in memory until you decide to write them to disk. Think twice before using the write command. Device does not contain a recognized partition table uses the disk identifier 0x43608ab7 to create a new DOS disk label. Command (enter m for help): n # # create Partition type: P primary (0 primary, 0 extended, 4 free) e extendedSelect (default p): P # main partition number (1-4, default 1): start sector (2048-41943039, default is 2048): the default 2048Last sector will be used, + sector or + size {Kommerg G} (2048-41943039) Default is 41943039): use the default of 41943039 partition 1 has been set to Linux type, size set to 20 GiB command (enter m for help): W # # save The partition table has been altered calling ioctl () to re-read partition table. Synchronizing disks. [root@localhost ~] # mkfs.xfs / dev/sdb1 # # format [root@localhost ~] # vim / etc/hostnameHOSTNAME=oracle # # modify hostname [root@localhost ~] # vim / etc/hosts192.168.13.133 oracle # # Local resolution [root@localhost ~] # init 6 # # restart 2, mount partition Modify the system environment and user environment [root@oracle ~] # mkdir / orc [root@oracle ~] # mount / dev/sdb1 / orc/ # # Mount [root@oracle ~] # df-hT # # View the mount point [root@oracle ~] # components necessary for the 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## installation environment [root@oracle ~] # vim / etc/sysctl.conf # # modify kernel parameter fs.aio-max-nr = 1048576 # number of asynchronous IO requests the recommended value is: 1048576 actually it is equal to 1024K fs.file-max = 6815744 # the maximum number of open file handles Problem preventing file descriptor exhaustion kernel.shmall = 2097152 # Total shared memory pages 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 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 socket send buffer size [ Root@oracle ~] # sysctl-p # # load [root@oracle ~] # groupadd oinstall # # create user group [root@oracle ~] # groupadd dba [root@oracle ~] # useradd-g oinstall-G dba oracle # # create system user [root@oracle ~] # passwd oracle # # create password [root@oracle ~] # mkdir-p / orc/app/oracle # # create directory [root@oracle ~] # chown-R oracle.oinstall / orc/app / # # give group owner [root@oracle] # chmod-R 755 / orc/app/oracle/ # # give permission [root@oracle ~] # vim / home/oracle/.bash_profile # # modify Oracle's own environment variable # User specific environment and startup programsumask 022 # # permission ORACLE_BASE=/orc/app/oracle # # File path ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ # # Top level directory ORACLE_SID=orcl # # instance NLS_LANG= "SIMPLIFIED CHINESE_CHINA" .UTF8 # # simplified Chinese PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin # # command to import environment variable LANG=zh_CN.UTF-8export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID## into system environment variable 3 Oracle user resource limit [root@oracle ~] # vim / etc/pam.d/login # # modify pam_limits authentication module # # insert session required / lib/security/pam_limits.sosession required pam_ authentication. So under password include system-auth [root @ oracle ~] # vim / etc/security/limits.conf # # modify limits profile oracle soft nproc 2047 # single user Number of processes available oracle hard nproc 16384oracle soft nofile 1024 # number of files user can open oracle hard nofile 65536oracle soft stack 10240 # Stack setting [root@oracle ~] # vim / etc/profile # # modify environment variable # # insert if [$USER = "oracle"] then if [$SHELL at the end of the line = "/ bin/ksh"] then ulimit-p 16384 # buffer size ulimit-n 65536 # number of files else ulimit-u 16384-n 65536 # number of files fifi [root@oracle ~] # mount.cifs / / 192.168.100.3/LNMP-C7 / mnt/ # # mount Password for root@//192.168.100. 3/LNMP-C7: [root@oracle ~] # cd / mnt/database-Oracle/ [root@oracle database-Oracle] # lsinstall response rpm runInstaller sshsetup stage welcome.html # # View installation script 4 Use graphical interface to install with oracle user [root@oracle ~] # xhost + # use root user to operate access control disabled in graphical interface, clients can connect from any host [root@oracle ~] # su-oracle # # switch oracle user [oracle@oracle ~] $export DISPLAY=:0.0 # # set DISPLAY environment variable It is used to run the graphics program [oracle@oracle ~] $cd / mnt/database-Oracle/ [oracle@oracle database-Oracle] $. / runInstaller # # to execute installation script 5 Graphical installation 1, do not select security update, enter the next step

2. Select to create and configure the database and proceed to the next step

3. Select the server class and proceed to the next step

4. Select single instance installation and proceed to the next step.

5. Select a typical installation and proceed to the next step

6. Enter the Super Admin password to proceed to the next step

7, proceed to the next step by default

8, check the list and install

9. Execute the following two scripts [root@oracle database-Oracle] # / orc/app/oraInventory/orainstRoot.sh # # with root to change permissions / orc/app/oraInventory with root. 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 database-Oracle] # / orc/app/oracle/product/12.2.0/dbhome_1/root.shEnter the full pathname of the local bin directory: [/ usr/local/bin]: # # enter... Do you want to setup Oracle Trace File Analyzer (TFA) now? Yes | [no]: # # Select yesyes

10, installation complete

6. Enter the Oracle database [oracle@oracle] $sqlplus / as sysdba. Thank you for reading!

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.