某客户生产系统迁移升级

明靓

云和恩墨交付战队

794

24页

19次

2022-07-18

25墨值下载

背景描述：客户某生产环境是单节点的 11203Oracle 数据库，根据要求需要升级操作系统并部署成两个节点

的 11204RAC 模式；新主机已搭建完成。

一、新环境搭建

##修改主机名

hostnamectl set-hostname --static "orcl2" #注：该命令会同步修改/etc/hostname

hostnamectl set-hostname --pretty "orcl2" #给主机起别名（昵称）

hostnamectl

##安装 unzip

yum install -y unzip zip

##安装包

[root@orcl2 soft]# pwd

/picc/soft

[root@orcl2 soft]# ls -l

总用量 3664204

-rw------- 1 root root 1395582860 4 月 17 2019 p13390677_112040_Linux-x86-

64_1of7.zip

-rw------- 1 root root 1151304589 4 月 26 2018 p13390677_112040_Linux-x86-

64_2of7.zip

-rw------- 1 root root 1205251894 4 月 26 2018 p13390677_112040_Linux-x86-

64_3of7.zip

##安装依赖包

yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-

33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-

33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio

libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++

libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst

libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-

devel*.i686

yum -y install bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf

elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel

libdtrace-ctf-devel libXrender libXrender-devel libX11 libXau libXi libXtst

libgcc libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-

configshell python-rtslib python-six targetcli smartmontools sysstat

##检查系统软件套件

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \

compat-libstdc++-33 \

compat-libstdc++-296 \

compat-libcap1.x86_64 \

compat-libcap1.i686 \

elfutils-libelf \

elfutils-libelf-devel \

gcc \

gcc-c++ \

glibc \

glibc-common \

glibc-devel \

glibc-headers \

libaio \

libaio-devel \

libgcc \

libstdc++ \

libstdc++-devel \

make \

sysstat \

unixODBC \

unixODBC-devel

##创建用户、组、目录

groupadd oinstall -g 1001

groupadd dba -g 1031

groupadd oper -g 1032

groupadd asmadmin -g 1020

groupadd asmdba -g 1021

groupadd asmoper -g 1022

useradd -g oinstall -G asmadmin,asmdba,asmoper,dba,oper -u 1100 grid

useradd -g oinstall -G dba,oper,asmadmin,asmdba -u 1101 oracle

echo "******" | passwd --stdin oracle

echo "******" | passwd --stdin grid

mkdir -p /u01/app/11.2.0/grid

mkdir -p /u01/app/grid

mkdir -p /u01/app

mkdir -p /u01/app/oracle/product/11.2.0/db_1

chown -R grid:oinstall /u01

chown -R grid:oinstall /u01/app/11.2.0

chown -R grid:oinstall /u01/app/grid

chown -R oracle:oinstall /u01/app/oracle

chmod -R 775 /u01

##修改/etc/pam.d/login

vi /etc/pam.d/login

session required pam_limits.so

##内核参数配置

vi /etc/sysctl.conf

# Oracle install config

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 39321600

kernel.shmmax = 214748364800

kernel.shmmni = 4096

kernel.sem = 250 32000 100 200

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

##Huge page

vm.nr_hugepages =

如下命令使更改生效：

sysctl -p

##修改系统 profile

vi /etc/profile

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -u 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

of 24

25墨值下载

关注

评论