admin 管理员组

文章数量: 887021


2024年3月26日发(作者:cascade 数据库)

RAC数据库服务器配置文档

一、系统基础配置

1.安装软件包

yum -y install binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-

static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc

libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel libXext compat-

libstdc++-33 compat-libcap* perl smartmontools libXext compat-libstdc++-33

2.修改系统参数

cat /etc/hosts

192.168.108.201 pthello1

192.168.108.202 pthello1-vip

192.168.108.203 pthello2

192.168.108.204 pthello2-vip

192.168.108.205 pthello-scan

10.10.10.11 pthello1-priv

10.10.10.22 pthello2-priv

cat /etc/security/

#ORACLE SETTING

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

cat /etc/

#ORACLE SETTING

-max-nr = 1048576

-max = 6815744

# = 2097152

= 4096

= 250 32000 100 128

_local_port_range = 9000 65500

_default = 262144

_max = 4194304

_default = 262144

_max = 1048586

cat /etc/selinux/config

SELINUX=disabled

cat /etc/pam.d/login

#ORACLE SETTING

session required pam_

3.添加用户和组

groupadd -g 500 oinstall

groupadd -g 501 asmadmin

groupadd -g 502 asmdba

groupadd -g 503 asmoper

groupadd -g 504 dba

groupadd -g 505 oper

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

useradd -g oinstall -G dba,asmdba,oper oracle

mkdir /u01

chown oracle:oinstall /u01

chmod 777 /tmp

mkdir /u01/app

chown oracle:oinstall /u01/app

mkdir -p /u01/app/oraInventory

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

mkdir -p /u01/app/grid

chown grid:oinstall /u01/app/grid

mkdir -p /u01/app/11.2.0/grid

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

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

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

chmod -R 775 /u01/


本文标签: 配置 系统 数据库 用户 添加