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

1. Official document BOOK → Database Installation Guide for Linux → 2 Oracle Database Preinstallation Tasks

Second, complete the minimum installation of Linux Desktop (including graphical interface): general default selection, easy to install

Third, system environment management 1. Check the kernel version

# uname-r

2. View memory

Free-h

3. Disk space

Df-h

4. The following are the minimum storage requirements for installing oracle

5. The following settings are briefly set, which will be shared in different topics later.

A) graphical resolution settings

B) set Transparent Huge Pages

C) set up the ntp server

D) set disk scheduling algorithm

E) Network check and setup

F) Network card binding

G) DNS check and setup

H) make sure that the bandwidth from the network card to the network is correct.

4. Service & component management 1. Service

In order to facilitate database external services, turn off firewalls and other unused services

NetworkManager 、 auditd 、 cpuspeed 、 cups 、 ip6tables 、 iptables 、 rhsmcertd 、 selinux 、 sendmail

2. Configure yum

3. Install the package script

Due to the inconsistent installation packages of different systems, no scripts are provided. Please organize and install them according to the list of scripts given on the official website.

5. Hosts configure vi / etc/hosts

# rac node192.168.6.101 node1192.168.6.102 node2#rac vip192.168.6.201 node1vip192.168.6.202 node2vip#rac priv10.10.10.101 node1priv10.10.10.102 node2priv#rac scan192.168.6.12 Nodescan VI. Set user permissions 1. Create users & groups

A) Group

I. Oinstall

Install the primary user for a stand-alone server and must belong to the oracle user group.

ii. Dba

This group must be created when the database software is installed on the system. This group identifies the operating system and has database administration privileges (SYSDBA privileges).

iii. Oper

This is an optional group. If you want a separate operating system user group, create this group with limited database administration permissions.

This group cannot be connected directly unless explicitly granted. However, they grant privileges with SYSOPER privileges. By default, members of this osdba group are authorized by SYSOPER.

iv. Asmadmin

Asmadmin permissions are administrator privileges for Oracle ASM files and provide Oracle ASM instance management access.

If the grid user does not have asmadmin privileges, he will not be able to operate asm disk group.

V. Asmoper

This group is similar to the oper user group, which is an additional user group. Asmoper users have sysoper permissions for asm.

Can be used to start and shut down asm instances, and asmadmin users have asmoper group privileges by default.

vi. Asmdba

This user group has read, write and access to asm files, and both the oracle user group and the GI user must have this permission.

If the oracle user does not have asmdba privileges, the files on asm cannot be used and the database cannot be started.

B) create users

Oracle

Grid

2. Create a script

Groupadd-g 201 oinstallgroupadd-g 202 dbagroupadd-g 203 opergroupadd-g 204 asmadmingroupadd-g 205 asmdbagroupadd-g 206 asmoperuseradd-u 201-g oinstall-G dba,asmdba,oper oracleuseradd-u 202-g oinstall-G asmadmin,asmdba,asmoper,oper,dba gr

3. Configure the resource restrictions for software installation users

A) vi / etc/profile

# add the following part if [$USER = "oracle"] | | [$USER = "grid"]; thenif [$SHELL = "/ bin/ksh"]; thenulimit-u 16384ulimit-n 65536elseulimit-u 16384-n 65536fifi b) vi / etc/security/limits.conf# add the following part oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 4096oracle hard nofile 65536oracle soft stack 10240oracle hard stack 32768grid soft nproc 2047grid hard nproc 16384grid soft nofile 4096grid hard nofile 65536grid soft stack 32768grid hard stack 327687, configure kernel parameters to set vi / etc/sysctl.conf

Fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmax = 4398046511104kernel.shmall = 1073741824kernel.shmmni = 4096kernel.sem = 25032000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 16777216net.core.rmem_max = 16777216net.core.wmem_default = 16777216net.core.wmem_max = 16777216 execute

Sysctl-p

Create the installation directory mkdir-p / u01/app/oraclemkdir-p / u01/app/11.2.0/gridmkdir-p / u01/app/gridchown-R grid:oinstall / u01chown oracle:oinstall / u01/app/oraclechmod-R 775 / u0119, configure oracle, grid initialization parameters 1, Oracle

Unset USERNAMEumask 022export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatchexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LANG=en_USexport NLS_LANG=american_america.ZHS16GBKexport NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss" export ORACLE_SID=racdb12, Grid

Unset USERNAMEumask 022export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/11.2.0/gridexport GRID_HOME=$ORACLE_HOMEexport PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatchexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LANG=en_USexport ORACLE_SID=+ASM1export NLS_LANG=american_america.ZHS16GBKexport NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss" 10. Configure oracle & grid users with mutual trust

1. Generate the secret key (two node operations)

Mkdir ~ / .sshssh-keygen-t rsassh-keygen-t dsa2, establish trust relationship between hosts (node-operation)

Cat ~ / .ssh/id_rsa.pub > > .ssh / authorized_keyscat ~ / .ssh/id_dsa.pub > > .ssh / authorized_keysssh node2 cat ~ / .ssh/id_rsa.pub > > .ssh / authorized_keysssh node2 cat ~ / .ssh/id_dsa.pub > > .ssh / authorized_keysscp ~ / .ssh/authorized_keys node2:~/.ssh/authorized_keys

3. Verify the trust relationship

Ssh node name date 11. Verify whether the installation conditions meet cd / soft/grid./runcluvfy.sh stage-pre crsinst-n node1,node2-fixup-verbose

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.