REHL8 oracle 19C RAC安装一(环境准备)(更新前)

摘要:
1. 三个虚拟机的配置如下[root@nymtxasm]#cat/etc/hosts127.0.0.1本地主机localhost.localdomainlocalhost4本地主机4.本地域4::1本地主机localhost.localmainlocalhost6本地主机6.本地域6192.168.1.80nymtx

1.三台虚拟机 虚拟机的配置如下
REHL8 oracle 19C RAC安装一(环境准备)(更新前)第1张
[root@nymtx asm]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.80 nymtx.inno.com nymtx
192.168.1.88 hzmtx.inno.com hzmtx
10.10.10.80 nymtx-prv.inno.com nymtx-prv
10.10.10.88 hzmtx-prv.inno.com hzmtx-prv
192.168.1.83 nymtx-vip.inno.com nymtx-vip
192.168.1.84 hzmtx-vip.inno.com hzmtx-vip
192.168.1.85 mtx-scan.inno.com mtx-scan
192.168.1.90 cnmtx.inno.com cnmtx

2.关防火墙,三台主机都做
echo "SELINUX=disabled" > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 1
systemctl stop firewalld.service
systemctl disable firewalld.service
3.禁止NTP 三台主机都做
systemctl stop ntpd
systemctl disabled ntpd
systemctl stop chronyd.service
systemctl disable chronyd.service
rm -f /etc/chrony.conf
4.安装组件(YUM配置请参考https://www.cnblogs.com/tingxin/p/13137951.html)
yum -y install xdpyinfo
yum -y install libnsl
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-db*
yum -y install compat-gcc-34
yum -y install compat-gcc-34-c++
yum -y install compat-libcap1
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
yum -y install redhat-lsb-core
yum -y install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make smartmontools sysstat
5. 创建用户,在RAC主机上(nymtx,hzmtx)
groupdel oinstall
groupdel dba
groupadd -g 5001 oinstall
groupadd -g 5002 dba
groupadd -g 5003 asmdba
groupadd -g 5004 asmoper
groupadd -g 5005 asmadmin
useradd -u 6001 -g oinstall -G asmadmin,asmdba,asmoper grid
useradd -u 6002 -g oinstall -G dba,asmadmin,asmdba oracle
echo "oracle" |passwd --stdin grid
echo "oracle" |passwd --stdin oracle

6.创建目录 在RAC主机上(nymtx,hzmtx)
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/19c/grid
chown -R grid:oinstall /oracle
mkdir -p /oracle/app/oraInventory
chown -R grid:oinstall /oracle/app/oraInventory
mkdir -p /oracle/app/oracle/19c
chown -R oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle

7.设置grid 和oracle 用户环境 在RAC主机上(nymtx,hzmtx)
主机 nymtx:
su - grid
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_SID=+ASM1
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export TNS_ADMIN=(ORACLE_HOME/network/admin;export TNS_ADMIN export PATH=.:)PATH:(HOME/bin:)ORACLE_HOME/bin

su - oracle
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=(ORACLE_BASE/product/19c/dbhome_1 export ORACLE_UNQNAME=mtxdb export ORACLE_SID=mtxdb1 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export TNS_ADMIN=)ORACLE_HOME/network/admin;export TNS_ADMIN
export PATH=.:(PATH:)HOME/bin:$ORACLE_HOME/bin

主机 hzmtx:
su - grid
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_SID=+ASM2
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/app/19c/grid
export TNS_ADMIN=(ORACLE_HOME/network/admin;export TNS_ADMIN export PATH=.:)PATH:(HOME/bin:)ORACLE_HOME/bin

su - oracle
vi ~/.bash_profile
umask 022
export CV_ASSUME_DISTID=RHEL7.6;export CV_ASSUME_DISTID
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"; export NLS_DATE_FORMAT
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=(ORACLE_BASE/product/19c/dbhome_1 export ORACLE_UNQNAME=mtxdb export ORACLE_SID=mtxdb2 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export TNS_ADMIN=)ORACLE_HOME/network/admin;export TNS_ADMIN
export PATH=.:(PATH:)HOME/bin:$ORACLE_HOME/bin

8.NFS Server 配置 主机 cnmtx
vi /etc/exports
/asm *(rw,sync,no_wdelay,insecure,no_root_squash)
systemctl restart nfs-server.service
showmount -e
exportfs -v
创建 共享磁盘
mkdir -p /asm/oracleasm/disks
dd if=/dev/zero of=/asm/oracleasm/disks/asm1 bs=8192k count=1280
dd if=/dev/zero of=/asm/oracleasm/disks/asm2 bs=8192k count=1280
dd if=/dev/zero of=/asm/oracleasm/disks/asm3 bs=8192k count=1280
dd if=/dev/zero of=/asm/oracleasm/disks/asm4 bs=8192k count=1280
dd if=/dev/zero of=/asm/oracleasm/disks/asm5 bs=8192k count=1280
dd if=/dev/zero of=/asm/oracleasm/disks/asm6 bs=8192k count=128
dd if=/dev/zero of=/asm/oracleasm/disks/asm7 bs=8192k count=128

9.RAC挂载共享磁盘,并设置权限 在RAC主机上(nymtx,hzmtx)
mkdir /asm
vi /etc/fstab
192.168.1.90:/asm /asm nfs rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 0 0
mount -a
chown -R grid:asmadmin /asm/*
chmod g+s /asm/*

免责声明:文章转载自《REHL8 oracle 19C RAC安装一(环境准备)(更新前)》仅用于学习参考。如对内容有疑问,请及时联系本站处理。

上篇libiconv GNU Project Free Software Foundation (FSF)screen的使用下篇

宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=

相关文章

centos7 yum快速安装php7.1

1. 安装nginx yum install nginx ##开启nginx service nginx start 2.安装MYSQLyum localinstall http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm yum install mysql-commun...

ORACLE如何实现函数、包、存储过程的导入和导出

建 议可以用常规的检查,检查一下:数据字典信息/exp 导出结构检查 1.检查 SELECT * FROM ALL_SOURCE t WHERE T.OWNER = '要查询用户' AND t.TYPE = 'PACKAGE BODY' select * from USER_SOURCE where type = 'PACKAGE' 2.exp 结构。检查...

c#远程连接oracle(本地无oracle客户端)

我的操作系统是win10 x64 ,服务器oracle版本是g11 服务器上oracle做一些配置 然后更改tnsnames.ora 添加你的配置 我的例如: ddd=zkrOracle108 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.108)(P...

关于oracle 数据库效率的优化

最近项目快要快要结束了,我们最终还是要面对我们一直存在的问题,就是数据库查询编码的问题,但是通过各个方面观察我们发现数据库仅仅200w条数据查询议一天的数据也就仅仅不到两万条数据没结果查了将近两分钟,这按章正常状态来讲那是不可能出现的情况,但是经过很久的观察我们还是找到了原因,那就是我们在做sql语句编写的时候那是不合理的 接下来我就给大家罗列一下相关情况...

运维配置环境中间件

日常Linux运维环境配置笔记---不定期更新 声明:本文为个人维护笔记,当中的例子或者步骤都是借鉴网络上的方法或者方案,后自己一步步的进行试验后得出来的。有可能会写错,也有可能是缺少某部分没有记录,如发现请大家指出。谢谢 版权声明:本文为博主原创文章,未经博主允许不得转载。 1.环境建立 输入用户、密码登录Luinx 查看网络情况如何,有没有加载网...

oracle 的用户管理 sqlplus的常用命令

创建用户:create user 用户名 identified by 密码; SQL> create user scw identified by 123; 用户已创建。 SQL> 在oracle中创建用户只能由管理员或者具有管理员的权限的用户创建 修改密码: 1.修改自己的密码: SQL> passw; 更改 SCW 的口令 旧口令...