签到成功

知道了

CNDBA社区CNDBA社区

Redhat 7.9下安装Oracle 19C-基于ASM 的单实例

2021-09-22 21:59 2312 0 原创 oracle
作者： hbhe0316
本文链接：http://www.cndba.cn/hbhe0316/article/4742

1 设置/etc/hosts文件

[root@asm01 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.110 asm01

2.关闭防火墙

[root@asm01 ~]# systemctl stop firewalld.service
[root@asm01 ~]# systemctl disable firewalld.service

关闭selinuxhttp://www.cndba.cn/hbhe0316/article/4742

[root@asm01 ~]# sed -i  "s/SELINUX=enforcing/SELINUX=disabled/"  /etc/selinux/config
[root@asm01 ~]# setenforce 0

添加用户和组

[root@asm01 ~]# groupadd -g 1000 oinstall
[root@asm01 ~]# groupadd -g 1200 asmadmin
[root@asm01 ~]# groupadd -g 1201 asmdba
[root@asm01 ~]# groupadd -g 1202 asmoper
[root@asm01 ~]# groupadd -g 1300 dba
[root@asm01 ~]# groupadd -g 1301 oper
[root@asm01 ~]# useradd -m -u 1100 -g oinstall -Gasmadmin,asmdba,asmoper,dba -d /home/grid -s /bin/bash grid
[root@asm01 ~]# useradd -m -u 1101 -g oinstall -Gdba,oper,asmdba -d /home/oracle -s /bin/bash oracle
[root@asm01 ~]# echo "wwwwww" | passwd --stdin oracle 
[root@asm01 ~]# echo "wwwwww" | passwd --stdin grid

创建目录

 [root@asm01 oracle]# mkdir -p /u01/app/19.3.0/grid
 [root@asm01 oracle]# mkdir -p /u01/app/grid
 [root@asm01 oracle]# mkdir -p /u01/app/oracle/product/19.3.0/db_1
 [root@asm01 oracle]# chown -R grid:oinstall /u01
 [root@asm01 oracle]# chown -R oracle:oinstall /u01/app/oracle
 [root@asm01 oracle]# chmod -R 775 /u01/

配置oracle环境变量http://www.cndba.cn/hbhe0316/article/4742

[root@rac01 oracle]# vi /home/oracle/.bash_profile
ORACLE_SID=cxmtdb;export ORACLE_SID
ORACLE_UNQNAME=cxmtdb;export ORACLE_UNQNAME
JAVA_HOME=/usr/local/java; export JAVA_HOME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3.0/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="YYYY:MM:DDHH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=american_america.ZHS16GBK; export NLS_LANG
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
umask 022

设置grid用户

PATH=$PATH:$HOME/bin
export ORACLE_SID=+ASM1
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/19.3.0/grid
export PATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin/:.
export TEMP=/tmp
export TMP=/tmp
export TMPDIR=/tmp
umask 022
export PATH

修改资源限制

[root@asm01 oracle]# cat >> /etc/security/limits.conf <<EOF
grid  soft  nproc  2047
grid  hard  nproc  16384
grid  soft   nofile  1024
grid  hard  nofile  65536
grid  soft   stack  10240
grid  hard  stack  32768

oracle  soft  nproc  2047
oracle  hard  nproc  16384
oracle  soft  nofile  1024
oracle  hard  nofile  65536
oracle  soft  stack  10240
oracle  hard  stack  32768
oracle soft memlock 3145728
oracle hard memlock 3145728
EOF

设置PAM

http://www.cndba.cn/hbhe0316/article/4742 

[root@asm01 oracle]# cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF

配置NOZEROCONF

[root@asm01 oracle]# echo "NOZEROCONF=yes"  >>/etc/sysconfig/network

修改内核参数

http://www.cndba.cn/hbhe0316/article/4742 

[root@asm01 oracle]# cat >> /etc/sysctl.d/sysctl.conf <<EOF  
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
EOF
[root@asm01 oracle]# sysctl -p

安装rpm包

http://www.cndba.cn/hbhe0316/article/4742 

[root@asm01 oracle]# cat /etc/yum.repos.d/rhel79.repo 
[rhel7]
name=base
baseurl=ftp://192.168.56.199/pub/rhel79
enabled=1
gpgcheck=0

[root@asm01 oracle]# yum install binutils  compat-libstdc++-33   gcc  gcc-c++  glibc  glibc.i686  glibc-devel   ksh   libgcc.i686   libstdc++-devel  libaio  libaio.i686  libaio-devel  libaio-devel.i686  libXext  libXext.i686  libXtst  libXtst.i686  libX11  libX11.i686  libXau  libXau.i686  libxcb  libxcb.i686  libXi  libXi.i686  make  sysstat  unixODBC  unixODBC-devel  zlib-devel  zlib-devel.i686 compat-libcap1 -y
[root@asm01 oracle]# rpm -ivh /tmp/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

[root@asm01 ~]# for i in b c d e f g;
> do
> echo "KERNEL==/"sd*/", ENV{DEVTYPE}==/"disk/", SUBSYSTEM==/"block/", PROGRAM==/"/lib/udev/scsi_id -g -u -d /$devnode/",RESULT==/"`/lib/udev/scsi_id -g -u -d /dev/sd$i`/", SYMLINK+=/"asm-disk$i/", OWNER=/"grid/", GROUP=/"asmadmin/", MODE=/"0660/""
> done
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB30d48506-87170722", SYMLINK+="asm-diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB71365cad-572605db", SYMLINK+="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB80e61fca-ca90cb0b", SYMLINK+="asm-diskd", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB34ea5cca-1cfd0cfb", SYMLINK+="asm-diske", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB7d459f8a-c194a1fd", SYMLINK+="asm-diskf", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB42d60a52-9b0d90d2", SYMLINK+="asm-diskg", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@asm01 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB30d48506-87170722", SYMLINK+="asm-diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB71365cad-572605db", SYMLINK+="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB80e61fca-ca90cb0b", SYMLINK+="asm-diskd", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB34ea5cca-1cfd0cfb", SYMLINK+="asm-diske", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB7d459f8a-c194a1fd", SYMLINK+="asm-diskf", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/lib/udev/scsi_id -g -u -d $devnode",RESULT=="1ATA_VBOX_HARDDISK_VB42d60a52-9b0d90d2", SYMLINK+="asm-diskg", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@asm01 tmp]# /sbin/udevadm trigger --type=devices --action=change
[root@asm01 ~]# ls /dev/asm*
/dev/asm-diskb  /dev/asm-diskc  /dev/asm-diskd  /dev/asm-diske  /dev/asm-diskf  /dev/asm-diskg

安装GRID

[grid@asm01 tmp]$ unzip -d /u01/app/19.3.0/grid/ /tmp/LINUX.X64_193000_grid_home.zip
[root@asm01 ~]# rpm -ivh /u01/app/19.3.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm
[root@asm01 ~]# yum install libXp*.i686 libXt*.i686 libXtst  libXrender-0.9.10 -y

[grid@asm01 tmp]$ cd /u01/app/19.3.0/grid/
[grid@asm01 grid]$ ./gridSetup.sh

![](https://www.cndba.cn:8080/cndba/temp/1634458567703.png)











http://www.cndba.cn/hbhe0316/article/4742

安装Oracle软件

[root@asm01 root]# su - oracle
[oracle@asm01 oracle]$ unzip -d /u01/app/oracle/product/19.3.0/dbhome_1/ /tmp/LINUX.X64_193000_db_home.zip
[oracle@asm01 ~]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/
[oracle@asm01 dbhome_1]$ ./runInstaller










http://www.cndba.cn/hbhe0316/article/4742

[oracle@asm01 dbhome_1]$ dbca
















http://www.cndba.cn/hbhe0316/article/4742http://www.cndba.cn/hbhe0316/article/4742

http://www.cndba.cn/hbhe0316/article/4742

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问：1378681次
  • 积分：1523
  • 等级：核心会员
  • 排名：第6名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ