Oracle11gR2 Dataguard 物理备库 安装部署

写在前面，主机规划：

主机名	IP	备注
xypri	192.0.2.11	（奇数机）主
xystb	192.0.2.12	（偶数机）备

一、软件安装前环境配置（root用户操作）主备均要操作

 

1.修改主机名

vi /etc/sysconfig/network

 HOSTNAME=xypri

 

vi /etc/hosts

  192.0.2.11 xypri

  192.0.2.12 xystb

2.修改IP地址

IPADDR=192.0.2.11

 

3.修改内核参数

cp /etc/sysctl.conf /etc/sysctl.conf.bak

vi /etc/sysctl.conf

--文档最低要求，添加以下内容

fs.file-max = 6815744

fs.aio-max-nr = 1048576

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.ip_local_port_range = 9000 65500

 

修改完运行 sysctl -p 

 

4.修改资源限制

cp /etc/security/limits.conf /etc/security/limits.conf.bak

vi /etc/security/limits.conf

#末尾添加如下

# oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024

oracle   soft   nofile    1024

# oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536

oracle   hard   nofile    65536

# oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047

oracle   soft   nproc    2047

# oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384

oracle   hard   nproc    16384

# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB

oracle   soft   stack    10240

# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB

oracle   hard   stack    32768

 

5.创建用户和安装目录

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle

id oracle

uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)

 

mkdir -p /u01/app/

chown -R oracle:oinstall /u01/app/

chmod -R 775 /u01/app/

 

6.设置oracle用户环境变量,添加以下内容

vi /home/oracle/.bash_profile

export ORACLE_BASE=/u01/app/oracle

export ORACLE_SID=