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

Lab environment: OracleLinux7.6 x64 minimal installation

Database version: Oracle 12c R2

IP address: 192.168.6.6

Linux connection tool: xmanager 6 / / you can also use graphics to install Linux without tools

Description:

Database service name: oracledb.example.com

Database instance name: oracledb

Package download: official website download

Step 1 of Database installation. Modify the system hostname, hosts file, system parameters 2. Add user and group information to create the Oracle installation directory 3. 0. Modify user environment variable 4. Start installation (install linux components, upload Oracle package, and decompress and run installation) 5. DBCA build library 1, improve system information 1. Close the firewall and disable the firewall: [root@localhost ~] # systemctl stop firewalld [root@localhost ~] # systemctl disable firewalld2. Close seLinux: [root@localhost ~] # vim / etc/sysconfig/selinuxSELINUX=disabled3. Restart the operating system: [root@localhost ~] # reboot4. To modify the hostname [root@localhost ~] # hostnamelocalhost.localdomain # # Oracle database installation, the hostname should be carefully considered in production to avoid secondary modification. [root@localhost ~] # hostnamectl set-hostname oracledb.example.com [root@localhost ~] # hostname # # verify whether it is successful 5. Add the hosts parsing entry [root@localhost ~] # cat > / etc/hosts > 192.168.6.6 oracledb.example.com oracle > EOF6. The following parameters are written to the parameter values of [root@localhost ~] # cat / etc/sysctl.conffs.file-max = 6815744kernel.sem = 250 32000 100 12 kernel.shmall and kernel.shmmax in the / etc/sysctl.conf file Please configure as follows (RAM: physical memory of the operating system) # kernel.shmall=kernel.shmmax/kernel.shmmni# kernel.shmmax=RAM*80%*1024*1024*1024kernel.shmmni = 4096kernel.shmall = 419430kernel.shmmax = 1717986918kernel.panic_on_oops = 1net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.conf.all.rp_filter = 2net.ipv4.conf.default.rp _ filter = 2fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500 [root@localhost ~] # / sbin/sysctl-p / / execution takes effect 7. Add the following parameters to / etc/security/limits.conforacle soft nofile 1024oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768oracle hard memlock 134217728oracle soft memlock 1342177288. Add the following entry to / etc/pam.d/loginsession required pam_limits.so # # copy to the same field of session 2. Add user and user group information 1. Create user and group information [root@localhost ~] # groupdel oinstall [root@localhost ~] # groupadd-g 2000 oinstall [root@localhost ~] # groupadd-g 2001 dba [root@localhost ~] # groupadd-g 2002 oper [root@localhost ~] # useradd-g oinstall-G 2000 oracle [root@localhost ~] # echo oracle | passwd-stdin oracleChanging password for user oracle.passwd: all authentication tokens updated successfully. [root@localhost ~] # id oracleuid=1000 (oracle) gid=2000 (oinstall) groups=2000 (oinstall), 2001 (dba), 2002 (oper) 2. Create directory structure [root@localhost ~] # mkdir / u01/app/oracle/product/12.2.0/dbhome_1-p [root@localhost ~] # chown-R oracle.oinstall / U01 [root@localhost ~] # chmod-R 775 / U01 III, start installation 1. Installer component yum install bc- yyum install binutils-yyum install compat-libcap-yyum install compat-libstdc + +-yyum install glibc- yyum install glibc-devel-yyum install ksh-yyum install libaio- yyum install libaio-devel-yyum install libX11-yyum install libXau-yyum install libXi-yyum install libXtst-yyum install libXrender- yyum install libXrender-devel-yyum install libgcc-yyum install libstdc + +-yyum install libxcb-yyum install make-yyum install smartmontools-yyum install sysstat-yyum install compat-libcap1-y check installation result: rpm-qa bc Binutils compat-libcap compat-libstdc + + glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc + + libxcb make smartmontools sysstat compat-libcap12. If you are following me as the minimum installation, then you need to install the tool [root@oracle ~] # yum provides xhost [root@oracle ~] # yum-y install xorg-x11-server-utils3 that supports the "xhost +" command in root environment. Upload the downloaded database package to the Oracle user / home/oracle directory. It is very convenient for xmanager tools to come with xftp.

Modify root user environment variable [oracle@oracle ~] $vim / etc/profile by adding if [$USER = "oracle"]; then if [$SHELL = "/ bin/ksh"]; then ulimit-p 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fifib; modify oracle user environment variable [oracle@oracle ~] $su-oracle [oracle@oracle ~] $cat .bash _ profile# .bash _ profile# Get the aliases and functionsif [- f ~ / .bashrc] Then. ~ / .bashrcfi # User specific environment and startup programsexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1export TNS_ADMIN=$ORACLE_HOME/network/adminexport ORACLE_SID=oracledbexport ORACLE_TERM=xtermexport PATH=/usr/sbin:/usr/local/bin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibPATH=$PATH:$HOME/.local/bin $HOME/bin:$ORACLE_HOME/binexport PATH [oracle@oracle] $. .bash _ profile5. Upload the downloaded database package to the Oracle user / home/oracle directory and extract [oracle@oracledb ~] $unzip linuxx64_12201_database.zip6.6. Set up the DISPLAY environment, run once for each root user and oracle user, this IP address is the IP address of the client, and import the language [root@oracledb ~] $export DISPLAY=192.168.1.106:0.0 [oracle@oracledb ~] $export DISPLAY=192.168.1.106:0.0 [oracle@oracledb ~] $export LANG=en_ US [oracle @ oracledb ~] $. / database/runInstaller / / execute installation screenshot 1 of the installer under oracle user. Skip email login and update

2. Install only the database

3. Installation of single instance database

4. Install the enterprise version

5. Installation environment: ORACLE_BASE and ORACLE_HOME

6. Oracle user group

7. Check kernel parameters and dependency packages

8. Click Fix & Check Again

9. Execute / tmp/CVU_12.2.0.1.0_oracle/runfixup.sh under root, and then click ok [root @ oracledb ~] # / tmp/CVU_12.2.0.1.0_oracle/runfixup.sh

Note: if there are components that need to be installed, which cannot be ignored in the production environment, download the corresponding version of the package from net-tools-*.rpm, and click Check Again installation steps after installation: [root@oracledb ~] # yum install compat-libcap1 [root@oracledb opt] # yum localinstall net-tools-*.rpm

10. Install. At 95% of the time, Oracle asks us to install the script. After the two scripts are completed, click OK to continue, and the second script presses enter all the way.

11. Complete the installation

4. Dbca to build a database, [oracle@oracledb ~] # dbca1, and next step to create a database

2. Advanced configuration

3. Single instance installation, general service purposes and processes

4. Enter the global name and instance name of the database

5. Next step

6. Customize the Quick recovery area

7. Configure monitoring

8. Automatic memory management

9. The number of concurrency is written according to the environment

10. Custom character set

11. Add an example

12. Do not configure em

13. Set the password

14. Next step

15. Complete, start the installation

16. End of installation

Connect to the database [oracle@oracledb] $sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 30 10:37:43 2019Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit ProductionSQL > select status, instance_name from vastness instance situation INSTANCE_NAME--OPEN oracledbSQL >

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.