Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary     - Easy to install CentOS 6.6 desktop environment (Linux)

- React Native (Programming)

- Android use canvas board painting (Programming)

- MySQL Data Types (Database)

- Spring Data JPA call a stored procedure examples (Programming)

- Java concurrent programming combat (using synchronized synchronization method) (Programming)

- How to Install Redis server on CentOS 7 (Server)

- Vim (Linux)

- Some Linux networking tools you might not know (Linux)

- Vim simple configuration (Linux)

- Using DOS command to change UNIX administrator password (Linux)

- Struts2 form of non-use component tags (Programming)

- HAProxy performance under high concurrency (Server)

- Selection sort, insertion sort, and Shell sort (Programming)

- Linux command find (Linux)

- phpinfo (): like phpinfo as a Python script (Programming)

- Java singleton mode (Singleton mode) (Programming)

- Nginx installation configuration Zabbix (Server)

- mysqldump implement database logical backup (Database)

- Eclipse configuration GTK (Linux)

 
         
  Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary
     
  Add Date : 2017-01-08      
         
       
         
  1. Installation preparation:

Operating System: RHEL6.5
Storage: Huawei, configured multipathing
Business card, heartbeat NIC teaming, and through redundancy test
YUM source configuration
BASH / SSL vulnerability patch
2. Check the system requirements

A.LINUX version

cat / etc / issue

B. memory (at least 1G)

grep MemTotal / proc / meminfo

C.SWAP partition
When memory is 2.5GB-16GB, Swap equal to the system memory size.
When the memory is greater than 16GB, Swap equal to 16GB.

D.TMP space

df -h / tmp
lvcreate -L 2G -n lv_tmp vg_temp
mount / dev / vg_temp / lv_tmp / tmp
df -h / tmp

E. Check the patch

# Rpm -q binutils compat-libcap1 compat-libstdc ++ - 33 gcc gcc-c ++ glibc glibc-devel ksh libgcc libstdc ++ libstdc ++ - devel libaio libaio-devel make sysstat
binutils-2.20.51.0.2-5.36.el6.x86_64
compat-libcap1-1.10-1.x86_64
compat-libstdc ++ - 33-3.2.3-69.el6.x86_64
gcc-4.4.7-4.el6.x86_64
gcc-c ++ - 4.4.7-4.el6.x86_64
glibc-2.12-1.132.el6.x86_64
glibc-2.12-1.132.el6.i686
glibc-devel-2.12-1.132.el6.x86_64
ksh-20120801-10.el6.x86_64
libgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.i686
libstdc ++ - 4.4.7-4.el6.x86_64
libstdc ++ - devel-4.4.7-4.el6.x86_64
libaio-0.3.107-10.el6.x86_64
libaio-devel-0.3.107-10.el6.x86_64
make-3.81-20.el6.x86_64
sysstat-9.0.4-22.el6.x86_64

F. Disable the firewall

service iptables status
service iptables stop
chkconfig iptables off

G. Close SELinux

#vi / etc / selinux / config
The file SELINUX = "" is disabled, and then restart.
If you do not want to reboot the system, use the command setenforce 0
Note:
setenforce 1 set SELinux become enforcing mode
setenforce 0 is set to become permissive mode SELinux
getenforce / setenforce view and set the current operating mode SELinux

H. Core parameter adjustment

vim /etc/sysctl.conf
# Oracle install config

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 270853791744 - set the size of physical memory (B)
kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500
 net.core.rmem_default = 262144
 net.core.rmem_max = 4194304
 net.core.wmem_default = 262144
 net.core.wmem_max = 1048576

2. Set the / etc / hosts:
 Claim:
Private IP address should be separated from the public network, two nodes can communicate with each other can ping, must in / etc / hosts there;

Virtual IP address with the public IP address is a network segment, if there is to be registered in DNS DNS, if no DNS to write in / etc / hosts file;

Public IP address, host real IP address, host administrator pre-allocated, if there is to be registered in DNS DNS, if no DNS to write in / etc / hosts file), and to ensure that each client system is written the hosts file.

NIC configuration must be the same in each node, for example: the first node is bind0 public IP, then the other nodes have to use bind0

3. Establishment oracle, grid users and dba groups:

Create group

/ Usr / sbin / groupadd -g 1000 oinstall
/ Usr / sbin / groupadd -g 1020 asmadmin
/ Usr / sbin / groupadd -g 1021 asmdba
/ Usr / sbin / groupadd -g 1022 asmoper
/ Usr / sbin / groupadd -g 1031 dba
/ Usr / sbin / groupadd -g 1032 oper
Create a user

/ Usr / sbin / useradd -g oinstall -G asmadmin, asmdba, asmoper, oper, dba -u 1100 grid
/ Usr / sbin / useradd -g oinstall -G dba, asmdba, oper -u 1101 oracle

4. Set the system limits:
- Do the same on each node

im /etc/security/limits.conf
SETTING for ORACLE

racle soft nproc 2047

racle hard nproc 16384
racle soft nofile 4096
racle hard nofile 65536
racle soft stack 10240
racle hard stack 32768

rid soft nproc 2047

grid hard nproc 16384
grid soft nofile 4096
grid hard nofile 65536
grid soft stack 10240
grid hard stack 32768

5. Establish GRID and RAC installation directory:
- Were established in the following directory node 2

mkdir -p /oracle/app/11.2.0/grid
mkdir -p / oracle / app / grid
mkdir -p / oracle / app / oracle
chown -R grid: oinstall / oracle
chown grid: oinstall /oracle/app/11.2.0/grid
chown grid: oinstall / oracle / app / grid
chown oracle: oinstall / oracle / app / oracle
chmod -R 775 / oracle /
 
6. Set the NTP service:
NTP services are provided at the two nodes

vim /etc/ntp.conf
driftfile / var / lib / ntp / drift
restrict default kod nomodify notrap nopeer noquery
restrict -6 default kod nomodify notrap nopeer noquery
restrict 127.0.0.1
restrict -6 :: 1
server 202.106.5.193 prefer
server 172.16.66.92
restrict 202.106.5.193
 restrict 172.16.66.92
 includefile / etc / ntp / crypto / pw
 keys / etc / ntp / keys


vim / etc / sysconfig / ntpd
# Drop root to id 'ntp: ntp' by default.
OPTIONS = "- x -u ntp: ntp -p /var/run/ntpd.pid"
Modify these two files, you can start the service.

rpm -q ntp
ntp-4.2.6p5-1.el6.x86_64
service ntpd start
Can you view the ntp and services through the following two commands normal state:

ntpq -p
ntpstat

7. Set the user's environment variables:
grid users:

# Vim ~ / .bash_profile
# .bash_profile


# Get the aliases and functions
if [-f ~ / .bashrc]; then
. ~ / .bashrc
fi


# User specific environment and startup programs
 

 PATH = $ PATH: $ HOME / bin
 

 export PATH
 

 export ORACLE_BASE = / oracle / app / grid
 export ORACLE_HOME = / oracle / app / 11.2.0 / grid
 export ORACLE_SID = + ASM2
 export NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
 export NLS_DATE_FORMAT = "yyyy-mm-dd hh24: mi: ss"
 export PATH =:. $ {PATH}: $ HOME / bin: $ ORACLE_HOME / bin: $ ORACLE_HOME / OPatch
 export PATH = $ {PATH}: / usr / bin: / bin: / usr / bin / X11: / usr / local / bin
 export PATH = $ {PATH}: $ ORACLE_BASE / common / oracle / bin
 export ORACLE_TERM = xterm
 export LD_LIBRARY_PATH = $ ORACLE_HOME / lib
 export LD_LIBRARY_PATH = $ {LD_LIBRARY_PATH}: $ ORACLE_HOME / oracm / lib
 export LD_LIBRARY_PATH = $ {LD_LIBRARY_PATH}: / lib: / usr / lib: / usr / local / lib
 export CLASSPATH = $ ORACLE_HOME / JRE
 export CLASSPATH = $ {CLASSPATH}: $ ORACLE_HOME / jlib
 export CLASSPATH = $ {CLASSPATH}: $ ORACLE_HOME / rdbms / jlib
 export CLASSPATH = $ {CLASSPATH}: $ ORACLE_HOME / network / jlib
 export THREADS_FLAG = native
 export TEMP = / tmp
 export TMPDIR = / tmp
 umask 022
 export TMOUT = 0

oracle user:

#vim ~ / .bash_profile
# .bash_profile


# Get the aliases and functions
if [-f ~ / .bashrc]; then
. ~ / .bashrc
fi


# User specific environment and startup programs
 

 PATH = $ PATH: $ HOME / bin
 

 export PATH
 

 export ORACLE_BASE = / oracle / app / oracle
 export ORACLE_HOME = $ ORACLE_BASE / product / 11.2.0 / dbhome_1
 export ORACLE_SID = test
 export LANG = en_US.UTF-8

 export NLS_LANG = american_america.ZHS16GBK
 export NLS_DATE_FORMAT = "yyyy-mm-dd hh24: mi: ss"
 export PATH =:. $ {PATH}: $ HOME / bin: $ ORACLE_HOME / bin: $ ORACLE_HOME / OPatch
 export PATH = $ {PATH}: / usr / bin: / bin: / usr / bin / X11: / usr / local / bin
 export PATH = $ {PATH}: $ ORACLE_BASE / common / oracle / bin: / home / oracle / run
 export ORACLE_TERM = xterm
 export LD_LIBRARY_PATH = $ ORACLE_HOME / lib
 export LD_LIBRARY_PATH = $ {LD_LIBRARY_PATH}: $ ORACLE_HOME / oracm / lib
 export LD_LIBRARY_PATH = $ {LD_LIBRARY_PATH}: / lib: / usr / lib: / usr / local / lib
 export CLASSPATH = $ ORACLE_HOME / JRE
 export CLASSPATH = $ {CLASSPATH}: $ ORACLE_HOME / jlib
 export CLASSPATH = $ {CLASSPATH}: $ ORACLE_HOME / rdbms / jlib
 export CLASSPATH = $ {CLASSPATH}: $ ORACLE_HOME / network / jlib
 export THREADS_FLAG = native
 export TEMP = / tmp
 export TMPDIR = / tmp
 export GI_HOME = / oracle / app / 11.2.0 / grid
 export PATH = $ {PATH}: $ GI_HOME / bin
 export ORA_NLS10 = $ GI_HOME / nls / data
 umask 022
 export TMOUT = 0
 
8. Configure UDEV:

The following operation requires two nodes perform:

# Cd /etc/udev/rules.d
# Vim 99-oracle-asmdevices.rules
KERNEL == "sd *", SUBSYSTEM == "block", PROGRAM == "/ sbin / scsi_id --whitelisted --replace-whitespace --device = / dev / $ name", RESULT == "364862761000560eb82f364f700000014", NAME = "asmdisk001", OWNER = "grid", GROUP = "asmadmin", MODE = "0660"
Wherein the value of the disk UUID RESULT
Get disk UUID command is as follows:
# Scsi_id --whitelisted --replace-whitespace --device = / dev / sdb
Recommended for all disks script UUID output to x.log, then use the column editor to get all the asm disk
 ./test.sh> x.log
 
After performing and check after 99-oracle-asmdevices.rules, you will be able to execute the command to start udev:

# ./sbin/start_udev
# Ls -al / dev / asm *
brw-rw ---- 1 grid asmadmin 8, 16 Aug 7 14:57 / dev / asmdisk001

9. Install cvudisk package

# Cd $ INSTALL_MEDIA / grid / rpm /
## CVUQDISK_GRP = oinstall; export CVUQDISK_GRP - can customize the installation user group here

# Rpm -ivh cvuqdisk-1.0.9-1.rpm
Preparing ... ########################################### [100% ]
Using default group oinstall to install package
1: cvuqdisk ########################################### [100%]

10. Configure SSH trust

# Cp $ INSTALL_MEDIA / grid / sshsetup / sshUserSetup.sh / home / grid
# Cd / home / grid
# Chown grid: oinstall sshUserSetup.sh
# Su - grid
$ ./sshUserSetup.sh -user Grid -hosts "test1 test1-priv test2 test2-priv" -advanced -noPromptPassphrase
$ Date; ssh test2 date; ssh test1-priv date; ssh test2-priv date


# Cp $ INSTALL_MEDIA / grid / sshsetup / sshUserSetup.sh / home / oracle
# Cd / home / oracle

 # Chown oracle: oinstall sshUserSetup.sh
 # Su - oracle
 $ ./sshUserSetup.sh -user Oracle -hosts "test1 test1-priv test2 test2-priv" -advanced -noPromptPassphrase
 $ ./date;ssh Test date; ssh test1-priv date; ssh test2-priv date

11. Pre-installation check the operation of GI

# Su - grid
$ Cd $ INSTALL_MEDIA / grid /
$ ./runcluvfy.sh Stage -pre crsinst -n test1, test2 -fixup -verbose
12. Install the GI Software
# Su - grid
 $ Cd $ INSTALL_MEDIA / grid
 $ ./runInstaller
A little later on, I do not want the map ... tired ...

13. Install Database Software

 

# Su - oracle
$ Cd $ INSTALL_MEDIA / database /
$ ./runcluvfy.sh Stage -pre dbcfg -n test1, test2
Back with a little, little bit of the operation point, please choose on her own.
PS: official recommendations and GI Database regarded Chinese language package up, it could be used.

14.Opatch Patch Update
First, we need to replace and update OPatch /u01/app/11.2.0/grid/ file under $ ORACLE_HOME, remember to stop crs.
Then perform the following procedures:

 

root user to perform:
# /oracle/app/11.2.0/grid/crs/install/rootcrs.pl -unlock


grid users to perform:
$ /oracle/app/11.2.0/grid/OPatch/opatch Napply -oh /oracle/app/11.2.0/grid -local /oracle/app/11.2.0/grid/OPatch/20996923/20831122
$ /oracle/app/11.2.0/grid/OPatch/opatch Napply -oh /oracle/app/11.2.0/grid -local /oracle/app/11.2.0/grid/OPatch/20996923/20299019
$ /oracle/app/11.2.0/grid/OPatch/opatch Apply -oh /oracle/app/11.2.0/grid -local /oracle/app/11.2.0/grid/OPatch/20996923/20760982


oracle user to perform:
 $ /oracle/app/11.2.0/grid/OPatch/20996923/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome /oracle/app/oracle/product/11.2.0/dbhome_1
 $ /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch Napply -oh /oracle/app/oracle/product/11.2.0/dbhome_1 -local /oracle/app/11.2.0/grid/OPatch / 20996923/20831122 / custom / server / 20831122
 $ /oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch Apply -oh /oracle/app/oracle/product/11.2.0/dbhome_1 -local /oracle/app/11.2.0/grid/OPatch / 20996923/20760982
 $ /oracle/app/11.2.0/grid/OPatch/20996923/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome /oracle/app/oracle/product/11.2.0/dbhome_1
 

 root user to perform:
 # /oracle/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
 # /oracle/app/11.2.0/grid/crs/install/rootcrs.pl -patch
 

 After installation is complete run the following command to check whether the updated version:
 $ Opatch lsinventory
 Oracle Interim Patch Installer version 11.2.0.3.11
 Copyright (c) 2015, Oracle Corporation. All rights reserved.
15.ASM parameter settings

alter diskgroup DATA set attribute 'disk_repair_time' = '2400h';
alter diskgroup ARCH set attribute 'disk_repair_time' = '2400h';
alter diskgroup OCRDG set attribute 'disk_repair_time' = '2400h';
alter system set asm_diskgroups = 'DATA', 'ARCH' SCOPE = SPFILE sid = '*';
alter system set memoey_max_target = 4096M scope = spfile;
alter system set memoey_target = 4096M scope = spfile;

16. Create a database
     
         
       
         
  More:      
 
- Build Python3.4 + PyQt5.3.2 + Eric 6.0 development platform Ubuntu 14.04 (Server)
- JavaScript notes --Objects (Programming)
- Nine artifact control disk partition under Linux (Linux)
- Linux 0.12 kernel and modern kernels difference in memory management (Linux)
- Ubuntu 14.04 How to install Cinnamon 2.4.5 (Linux)
- How to use Evernote in the Linux command line (Linux)
- Use virt-manager to create and manage virtual machines (Linux)
- MySQL high availability cluster fragmentation of deployment uses Cobar (Database)
- JavaScript in null undefined summary (Linux)
- Oracle Sql Loader tool has shown signs (Database)
- An Example of GoldenGate Extract Process Hang Problem Solving (Database)
- Oracle Database High-Risk Vulnerability Warning (Database)
- Use JMS listener Oracle AQ, trigger the execution of Java programs in the database changes (Database)
- Android judgment toward camera pictures (Programming)
- Java string concatenation techniques (StringBuilder tips) (Programming)
- Java regular expressions examples (Programming)
- Linux installation JDK1.6 rpm.bin assembly (Linux)
- Oracle rebuild index script (Database)
- How SSHfs mount a remote file system on Linux (Linux)
- Linux rpm command Detailed (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.