Soy sauce DBA dedication Oracle 11gR2 RAC on linux integrated script installation (3)
Soy sauce DBA dedication Oracle 11gR2 RAC on linux integrated script installation (3)
As a Party A soy sauce DBA, how can it not build RAC? The following talk about Party A soy sauce DBA is how to script the installation of RAC? (I have 10 + sets of RAC building experience, AIX,HP-UNIX,LINUX, if you have any questions, please feel free to consult.)
Purpose of this article: RAC integrated script installation under Linux platform.
There are all kinds of scripted installations online, some of which are problematic. In this paper, the problematic part has been removed and is now safe to use. Only my production environment, other friends' production environment is used carefully, if there are problems, it is not responsible.
The essence of this article: "scripted" three-word summary, hoping to be useful to the DBA of soy sauce
Soy sauce DBA dedication ORACLE database monitoring health script (1)
Http://www.itpub.net/thread-1841912-1-1.html
Soy sauce DBA offers expdp,impdp multi-user migration data (2)
Http://www.itpub.net/thread-1868059-1-1.html
Soy sauce DBA dedication Oracle 11gR2 RAC on linux integrated script installation (3)
Http://www.itpub.net/thread-1900973-1-1.html
Environment:
Operating system: redhat 6.264bit
Database: rac 11.2.0.4.0
Storage: EMC VNX5700
11gR2 RAC on linux integrated scripted installation
1. Basic environment script installation
Cat dou.sh = > to collect dou.1sh script logs
Sh dou1.sh > dou.log
The cat dou1.sh = > script is as follows:
Echo "# Information Collection###"
#
# Information Collection #
#
Echo "# redhat version###"
Cat / etc/redhat-release
Echo "# os memory###"
Cat / proc/meminfo | grep MemTotal
Echo "# os swap###"
Cat / proc/meminfo | grep SwapTotal
Echo "# os filesystem###"
Df-h
Echo "# os cpu numbers###"
Cat / proc/cpuinfo | grep "processor" | wc-l
Echo "# os cpu cores###"
Cat / proc/cpuinfo | grep "cores" | uniq
Echo "# create group and user###"
#
# create group and user #
#
/ 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
Useradd-u 1100-g oinstall-G asmadmin,asmdba,asmoper,dba grid
Useradd-u 1101-g oinstall-G dba,oper,asmdba oracle
Echo "# create / etc/oraInst.loc###"
#
# create / etc/oraInst.loc #
#
Echo "inventory_loc=/oracle/app/oracle/oraInventory" > > / etc/oraInst.loc
Echo "inst_group=oinstall" > > / etc/oraInst.loc
Echo "# create directory and Privilege###"
#
# create directory and Privilege #
#
Mkdir-p / oracle/app/11.2.0/grid
Mkdir-p / oracle/app/grid
Mkdir-p/oracle/ app/oracle/oraInventory
Chown grid:oinstall / oracle/app/11.2.0/grid
Chown grid:oinstall / oracle/app/grid
Chmod-R 775 / oracle/
Chown-R grid:oinstall / oracle
Chown oracle:oinstall / oracle/app/oracle
Echo "# LINUX optimize parameters####"
#
# modify sysctl.conf | memory=64G #
#
Cat > > / etc/sysctl.conf / etc/security/limits.conf > / etc/profile / etc/pam.d/login
Sleep 1
Echo "# # oracle environment variable #"
# # #
# setting user oracle env #
# # #
Cat > > / home/oracle/.bash_profile / home/grid/.bash_profile to collect dou.1sh script logs
Sh dou1.sh > dou.log
The cat dou1.sh = > script is as follows:
Echo "# Information Collection###"
#
# Information Collection #
#
Echo "# redhat version###"
Cat / etc/redhat-release
Echo "# os memory###"
Cat / proc/meminfo | grep MemTotal
Echo "# os swap###"
Cat / proc/meminfo | grep SwapTotal
Echo "# os filesystem###"
Df-h
Echo "# os cpu numbers###"
Cat / proc/cpuinfo | grep "processor" | wc-l
Echo "# os cpu cores###"
Cat / proc/cpuinfo | grep "cores" | uniq
Echo "# create group and user###"
#
# create group and user #
#
/ 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
Useradd-u 1100-g oinstall-G asmadmin,asmdba,asmoper,dba grid
Useradd-u 1101-g oinstall-G dba,oper,asmdba oracle
Echo "# create / etc/oraInst.loc###"
#
# create / etc/oraInst.loc #
#
Echo "inventory_loc=/oracle/app/oracle/oraInventory" > > / etc/oraInst.loc
Echo "inst_group=oinstall" > > / etc/oraInst.loc
Echo "# create directory and Privilege###"
#
# create directory and Privilege #
#
Mkdir-p / oracle/app/11.2.0/grid
Mkdir-p / oracle/app/grid
Mkdir-p/oracle/ app/oracle/oraInventory
Chown grid:oinstall / oracle/app/11.2.0/grid
Chown grid:oinstall / oracle/app/grid
Chmod-R 775 / oracle/
Chown-R grid:oinstall / oracle
Chown oracle:oinstall / oracle/app/oracle
Echo "# LINUX optimize parameters####"
#
# modify sysctl.conf | memory=64G #
#
Cat > > / etc/sysctl.conf / etc/security/limits.conf > / etc/profile / etc/pam.d/login
Sleep 1
Echo "# # oracle environment variable #"
# # #
# setting user oracle env #
# # #
Cat > > / home/oracle/.bash_profile / home/grid/.bash_profile
