Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary     - HttpClient Tutorial (Programming)

- RHEL5.8 physical opportunities to Read-only file system (Linux)

- Oracle 12C truncate table cascade (Database)

- Iptables in Ubuntu (Linux)

- The difference between Linux su and sudo commands (Linux)

- Using PHP MySQL library (Programming)

- CentOS6 installed Tomcat (Server)

- Linux initialization init system - UpStart (Linux)

- How to modify the Ubuntu terminal user name changed to red color (Linux)

- Linux centos rm directory does not prompt (Linux)

- Hadoop 2.0 Detailed Configuration Tutorial (Server)

- Redhat 7 can only be read after installation Samba service catalog approach could not be written (Server)

- iptables allow only specific ip address to access the specified port (Linux)

- Based on Google Cloud Storage Mirroring open Maven Central Repository (Server)

- Linux user groups, file permissions Detailed (Linux)

- Use regular expressions to check whether the input box to enter a URL (Programming)

- Java MD5 encryption implementation (Programming)

- How to Use Nmap security scanner tool on Linux (Linux)

- The SVN installation, configuration and start - up under Linux (CentOS 6.5) (Server)

- to compile FFmpeg In Ubuntu (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:      
 
- Fundamentals of the Java virtual machine memory management principles (Programming)
- 14 useful example Linux Sort command (Linux)
- Erlang concurrency and foundation (Programming)
- File SUID, SGID, Sticky property (Linux)
- Ubuntu server 8.04 Firewall Guide (Linux)
- a virtual machine created migrated to host RHEL6.4 on Ubuntu 14.04 (Linux)
- PHP generates a random password several ways (Programming)
- Installation Experience open source car Automotive Grade Linux system (Linux)
- Docker manage data (Linux)
- Ubuntu Apache2 setting, problem solving css, pictures, etc. can not be displayed (Server)
- Ubuntu clean up unnecessary disk space usage (Linux)
- Android child thread really do not update UI (Programming)
- How to create a secure and easy to remember password (Linux)
- Fedora 20 users install the Mate 1.8 desktop (Linux)
- Spring Data JPA call a stored procedure examples (Programming)
- Oracle set the timer task JOB scheduler to execute stored procedures or PL / SQL code block (Database)
- Android custom controls create the simplest skid menu in the history (Programming)
- Servlet life cycle works (Programming)
- Kibana use installation (Linux)
- Java singleton mode (Singleton mode) (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.