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

Preparation: a CentOS7.3Oracle12c installation package had better be set to dual-core, 4 G memory, 8 G virtual memory NAT mode installation process: 1. Turn off firewall self-startup and related functions and enhanced security features systemctl disable firewalld.servicesystemctl stop firewalld.servicesetenforce 02. Create a xfs file system and mount it to no less than 15g. The mount directory might as well be / orc

Create a new 20g disk sdb

Fdisk / dev/sdb / / create a new partition and generate sdb1. The default space size can be mkfs-t xfs / dev/sdb1 / / formatted disk. Add xfsmount / etc/hosts 192.168.100.151 Oracle / / add HOSTNAME=oraclevim / etc/hosts 192.168.100.151 Oracle / / to the vim / etc/hostname / / change hostname Oracle in the / orc directory in the format 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 / / to create a shortcut domain name resolution 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 the kernel parameter vim / etc/sysctl.conf / / add the following content: 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 1024K fs.file-max = 6815744 / / open file handles, prevent file descriptor exhaustion kernel.shmall = 2097152 / / Total shared memory page is the unit Memory divided by 4K kernel.shmmax = 4294967295 kernel.shmmni = 4096 kernel.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 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 value of socket receive buffer size net.core.wmem_default = 262144 / / default value of socket send buffer size net.core.wmem _ max = 1048576 / / the maximum size of the socket send buffer sysctl-p / / reload configuration file 5. User environment configuration groupadd oinstall / / add user group groupadd dba / / add user group useradd-g oinstall-G dba oracle / / add user oracle, to which user group belongs is oinstall Affiliated user group is dbapasswd oracle/ / password 123123mkdir-p / orc/app/oracle/ / create working directory chown-R oracle:oinstall / orc/app/ change directory master group chmod-R755 / orc/app/oracle/ change permissions vim / home/oracle/.bash_profile / / oracle user environment configuration Add the following content: umask 022 ORACLE_BASE=/orc/app/oracle ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ 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_SID6.oracle user resource restrictions Use the end of pam_limits authentication module vim / etc/pam.d/login / / to add session required / lib/security/pam_limits.so session required pam_limits.sovim / etc/security/limits.conf / / add oracle soft nproc 2047 / / the number of processes available to a single user oracle hard nproc 16384 Oracle soft nofile 1024 / / number of files that users can open oracle hard nofile 65536 oracle soft stack 10240 / / Stack setting vim / etc/profile / / add if [$USER = "oracle"] then if [$SHELL = "/ bin/ksh"] then ulimit-p 16384 / / buffer at the end Size ulimit-p 65536 else ulimit-u 16384-n 65536 / / number of files fifi7. Install Oracle

Mount the prepared Oracle installation package folder in / abc for use

Do the following as root in the graphical interface xhost + / / all users can access X serversu-oracle / / switch to the oracle user cd / abc / / install the package mount directory export DISPLAY=:0.0./runInstaller / / run the installer

8. Install pop-up window processing su-root / / switch to root user / orc/app/oraInventory/orainstRoot.sh/orc/app/oracle/product/12.2.0/dbhome_1/root.sh9.web interface management rpm-ivh flash-player-npapi-26.0.0.131-release.x86_64.rpm / / manually install the flash plug-in

Open the Firefox browser in the graphical interface to access https://Oracle:5500/em, login name: sys password: abc123 check: as sysdba

10. Log in to sqlplus / as sysdba / / sys using the command line interface. The user is the top administrator of oracle, so add as. If an ordinary user logs in to sqlplus username / password SQL > help index / / to view the list of commands, the sql is not case-sensitive SQL > show user / / to view the current user.

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.