配置系统参数
vi /etc/hosts
#public ip
192.168.. rac1
192.168.. rac2
#priv ip
10.10.. rac1priv
10.10.. rac2priv
#vip ip
192.168.. rac1vip
192.168.. rac2vip
#scan ip
192.168.. racscan
检查网络是否能通
修改 ifcfg-enp0s8 文件 为ONBOOT=yes 这样私有ip就能通了
2、设置环境变量字符集
echo “export LANG=en_US” >> ~/.bash_profile
cat ~/.bash_profile
3、创建组和用户
/usr/sbin/groupadd -g 60001 oinstall
/usr/sbin/groupadd -g 60002 dba
/usr/sbin/groupadd -g 60003 oper
/usr/sbin/groupadd -g 60004 backupdba
/usr/sbin/groupadd -g 60005 dgdba
/usr/sbin/groupadd -g 60006 kmdba
/usr/sbin/groupadd -g 60007 asmdba
/usr/sbin/groupadd -g 60008 asmoper
/usr/sbin/groupadd -g 60009 asmadmin
/usr/sbin/useradd -u 61001 -g oinstall -G asmadmin,asmdba,dba,asmoper grid
/usr/sbin/useradd -u 61002 -g oinstall -G dba,backupdba,dgdba,kmdba,asmadmin,oper,asmdba oracle
passwd grid
passwd oracle
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/19.3.0/grid
chown -R grid:oinstall /oracle
mkdir -p /oracle/app/oraInventory
chown -R grid:oinstall /oracle/app/oraInventory
mkdir -p /oracle/app/oracle
chown -R oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle
4、配置yum源
mount /dev/cdrom /mnt
yum list | more
From Public Yum or ULN
From Public Yum or ULN
yum -y install autoconf
yum -y install automake
yum -y install binutils
yum -y install binutils-devel
yum -y install bison
yum -y install cpp
yum -y install dos2unix
yum -y install ftp
yum -y install gcc
yum -y install gcc-c++
yum -y install lrzsz
yum -y install python-devel
yum -y install compat-gcc-34-c++
yum -y install compat-libcap1
yum -y install compat-db*
yum -y install compat-gcc-34
yum -y install compat-libstdc+±33
yum -y install compat-libstdc+±33.i686
yum -y install glibc-*
yum -y install glibc-.i686
yum -y install libXpm-.i686
yum -y install libXp.so.6
yum -y install libXt.so.6
yum -y install libXtst.so.6
yum -y install libXext
yum -y install libXext.i686
yum -y install libXtst
yum -y install libXtst.i686
yum -y install libX11
yum -y install libX11.i686
yum -y install libXau
yum -y install libXau.i686
yum -y install libxcb
yum -y install libxcb.i686
yum -y install libXi
yum -y install libXi.i686
yum -y install libXtst
yum -y install libstdc+±docs
yum -y install libgcc_s.so.1
yum -y install libstdc++.i686
yum -y install libstdc+±devel
yum -y install libstdc+±devel.i686
yum -y install libaio
yum -y install libaio.i686
yum -y install libaio-devel
yum -y install libaio-devel.i686
yum -y install ksh
yum -y install libXp
yum -y install libaio-devel
yum -y install numactl
yum -y install numactl-devel
yum -y install make -y
yum -y install sysstat -y
yum -y install unixODBC
yum -y install unixODBC-devel
yum -y install elfutils-libelf-devel-0.97
yum -y install elfutils-libelf-devel
yum -y install redhat-lsb-core
yum install libnsl.x86_64
yum install binutils gcc gcc-c++ glibc glibc-devel glibc32
ksh libstdc+±devel libaio libaio-devel libXext libXtst
libX11 libXau libxcb libXi make sysstat unixODBC
unixODBC-devel zlib-devel elfutils-libelf elfutils-libelf-devel
glibc-headers glibc-common kernel-headers libgcc libgomp libstdc++
numactl-devel sysstat libXau libdmx xorg-x11-utils xorg-x11-xauth libXv
libXt libXmu libXxf86misc libXxf86dga libXxf86vm nfs-utils smartmontools
libnsl2-devel libnsl -y
5、修改资源限制 单位kb
vi /etc/security/limits.conf
#ORACLE SETTING
grid soft nproc 16384
grid hard nproc 16384
grid soft nofile 65536
grid hard nofile 65536
grid soft stack 32768
grid hard stack 32768
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft stack 32768
oracle hard stack 32768
oracle hard memlock 5242880
oracle soft memlock 5242880
ulimit -a
6、修改nproc参数 这里面也有一些进程数
echo “* - nproc 16384” > /etc/security/limits.d/20-nproc.conf
7、控制给用户分配的资源 修改的权限 让登录生效
echo “session required pam_limits.so” >> /etc/pam.d/login
cat /etc/pam.d/login
8、修改内核参数
vi /etc/sysctl.conf
#ORACLE SETTING
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
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 = 1048586
kernel.panic_on_oops = 1 这个参数就是应用程序如果出错是否运行，1是不运行了，0是还运行
vm.nr_hugepages = 1500 – 大内存页 物理内存大于8G必须要开大内存页 每页2M为单位 经验设置值 sga/2M+(100~500)
kernel.shmmax = 2576980378 --定义单个内存共享段的最大值>SGA <物理内存 2.4G
kernel.shmall = 629146 – 控制共享内存页数 shmmax/(getconfig Pagesize)=2576980378/4096
kernel.shmmni = 4096
sysctl -p
9、打开了大内存页 就必须要关闭透明页
cat /sys/kernel/mm/transparent_hugepage/defrag
[always] madvise never
cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
vi /etc/rc.d/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
chmod +x /etc/rc.d/rc.local
10、关闭numa功能
numactl --hardware
vi /etc/default/grub
numa=off
grub2-mkconfig -o /etc/grub2.cfg
numactl --hardware
11、将图形界面修改成字符界面
systemctl set-default multi-user.target
12、共享内存段 默认情况是物理内存的50% 是不够的 我们的是6G 设置为6000
echo “none /dev/shm tmpfs defaults,size=5000m 0 0” >>/etc/fstab
mount -o remount /dev/shm
13、修改市区
ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
hwclock
14、配置安全
禁用SELINUX 安全认证关掉
echo “SELINUX=disabled” > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 0
15、关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl status firewalld.service
16、配置NOZEROCONF 配置网络服务规范 可能会自动生产一些ip 对集群有影响 所以关闭掉
echo “NOZEROCONF=yes” >> /etc/sysconfig/network
17、设置解析顺序 设置解析顺序
vi /etc/nsswitch.conf
修改行
hosts: files dns myhostname
为
hosts: files dns myhostname nis
18、和配置NOZEROCONF 是一样的 防止多出现一些ip 影响网络性能
systemctl stop avahi-daemon.socket avahi-daemon.service
systemctl disable avahi-daemon.socket avahi-daemon.service
19 设置两台机器的时间要一样
systemctl stop ntpd
systemctl disabled ntpd
systemctl status ntpd
date -s ‘Thu Apr 20 10:07:00 CST 2023’
20、配置环境变量
第一台：
su - grid
PS1=“[whoami@hostname:”‘ P W D ] PWD] PWD]’
export PS1
umask 022
#alias sqlplus=“rlwrap sqlplus”
export TMP=/tmp
export LANG=en_US.UTF8
export TMPDIR= T M P O R A C L E S I D = + A S M 1 ; e x p o r t O R A C L E S I D O R A C L E T E R M = x t e r m ; e x p o r t O R A C L E T E R M O R A C L E B A S E = / o r a c l e / a p p / g r i d ; e x p o r t O R A C L E B A S E O R A C L E H O M E = / o r a c l e / a p p / 19.3.0 / g r i d ; e x p o r t O R A C L E H O M E N L S D A T E F O R M A T = " y y y y − m m − d d H H 24 : M I : S S " ; e x p o r t N L S D A T E F O R M A T P A T H = . : TMP ORACLE_SID=+ASM1; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM ORACLE_BASE=/oracle/app/grid; export ORACLE_BASE ORACLE_HOME=/oracle/app/19.3.0/grid; export ORACLE_HOME NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT PATH=.: TMPORACLESID=+ASM1;exportORACLESIDORACLETERM=xterm;exportORACLETERMORACLEBASE=/oracle/app/grid;exportORACLEBASEORACLEHOME=/oracle/app/19.3.0/grid;exportORACLEHOMENLSDATEFORMAT="yyyy−mm−ddHH24:MI:SS";exportNLSDATEFORMATPATH=.:PATH: H O M E / b i n : HOME/bin: HOME/bin:ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = “oracle” ] || [ $USER = “grid” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
su - oracle
oracle用户的环境变量如下：
PS1=“[whoami@hostname:”‘ P W D ] PWD] PWD]’
#alias sqlplus=“rlwrap sqlplus”
#alias rman=“rlwrap rman”
export PS1
export TMP=/tmp
export LANG=en_US.UTF8
export TMPDIR= T M P e x p o r t O R A C L E U N Q N A M E = o r c l O R A C L E B A S E = / o r a c l e / a p p / o r a c l e ; e x p o r t O R A C L E B A S E O R A C L E H O M E = TMP export ORACLE_UNQNAME=orcl ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE ORACLE_HOME= TMPexportORACLEUNQNAME=orclORACLEBASE=/oracle/app/oracle;exportORACLEBASEORACLEHOME=ORACLE_BASE/product/19.3.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT=“yyyy-mm-dd HH24:MI:SS”; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.UTF8;export NLS_LANG
PATH=.:<
最低0.47元/天 解锁文章
576
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
