Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Soy sauce DBA dedication Oracle 11gR2 RAC on linux integrated script installation (3)

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

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

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report