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

1 设置/etc/hosts文件

[root@asm01 tmp]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.56.200 asm01[root@asm01 tmp]# cat /etc/redhat-release Red Hat Enterprise Linux release 8.5 (Ootpa)

2.关闭防火墙

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

关闭selinux

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

添加用户和组

[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环境变量

ORACLE_SID=testdb;export ORACLE_SIDORACLE_UNQNAME=testdb;export ORACLE_UNQNAMEJAVA_HOME=/usr/local/java; export JAVA_HOMEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/19.3.0/db_1; export ORACLE_HOMEORACLE_TERM=xterm; export ORACLE_TERMNLS_DATE_FORMAT="YYYY:MM:DDHH24:MI:SS"; export NLS_DATE_FORMATNLS_LANG=american_america.ZHS16GBK; export NLS_LANGTNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMINORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/binPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATHLD_LIBRARY_PATH=$ORACLE_HOME/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexport LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRECLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport CLASSPATHTHREADS_FLAG=native; export THREADS_FLAGexport TEMP=/tmpexport TMPDIR=/tmpumask 022

设置grid用户

[root@asm01 tmp]# vi /home/grid/.bash_profilePATH=$PATH:$HOME/binexport ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/19.3.0/gridexport PATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin/:.export TEMP=/tmpexport TMP=/tmpexport TMPDIR=/tmpumask 022export PATH

修改资源限制

[root@asm01 oracle]# cat >> /etc/security/limits.conf <

设置PAM

[root@asm01 oracle]# cat >> /etc/pam.d/login <

配置NOZEROCONF

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

修改内核参数

[root@asm01 oracle]# cat >> /etc/sysctl.d/sysctl.conf <

安装rpm包

[root@asm01 tmp]# cat /etc/yum.repos.d/rhel85.repo [AppStream]name=basebaseurl=ftp://192.168.56.199/pub/rhel85/AppStreamenabled=1gpgcheck=0[base]name=basebaseurl=ftp://192.168.56.199/pub/rhel85/BaseOSenabled=1gpgcheck=0

dnf install -y bc dnf install -y binutilsdnf install -y compat-libstdc++-33dnf install -y elfutils-libelfdnf install -y elfutils-libelf-develdnf install -y fontconfig-develdnf install -y glibcdnf install -y glibc-develdnf install -y kshdnf install -y libaiodnf install -y libaio-develdnf install -y libXrenderdnf install -y libXrender-develdnf install -y libX11dnf install -y libXaudnf install -y libXidnf install -y libXtstdnf install -y libgccdnf install -y librdmacm-develdnf install -y libstdc++dnf install -y libstdc++-develdnf install -y libxcbdnf install -y makednf install -y net-tools # Clusterwarednf install -y nfs-utils # ACFSdnf install -y python # ACFSdnf install -y python-configshell # ACFSdnf install -y python-rtslib # ACFSdnf install -y python-six # ACFSdnf install -y targetcli # ACFSdnf install -y smartmontoolsdnf install -y sysstatdnf install -y unixODBCdnf install -y libnsl2dnf install -y libnsl2.i686dnf install -y libnsl

[root@asm01 tmp]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules KERNEL=="sd?",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB174cb4b5-a7312766",SYMLINK+="asm-diskb",OWNER="grid",GROUP="asmadmin",MODE="0660"KERNEL=="sd?",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB65f6fcc8-df908d40",SYMLINK+="asm-diskc",OWNER="grid",GROUP="asmadmin",MODE="0660"KERNEL=="sd?",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB11e87c4d-48cf117f",SYMLINK+="asm-diskd",OWNER="grid",GROUP="asmadmin",MODE="0660"KERNEL=="sd?",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VBffcae079-d1122272",SYMLINK+="asm-diske",OWNER="grid",GROUP="asmadmin",MODE="0660"KERNEL=="sd?",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB41e00855-d80aa9bd",SYMLINK+="asm-diskf",OWNER="grid",GROUP="asmadmin",MODE="0660"[root@asm01 tmp]# /sbin/udevadm trigger --type=devices --action=change[root@asm01 tmp]# ls /dev/asm*/dev/asm-diskb /dev/asm-diskc /dev/asm-diskd /dev/asm-diske /dev/asm-diskf

安装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

[root@asm01 tmp]# su - grid[grid@asm01 ~]$ cd /u01/app/19.3.0/grid/[grid@asm01 grid]$ export DISPLAY=192.168.56.1:0.0[grid@asm01 grid]$ export CV_ASSUME_DISTID=RHEL7.9[grid@asm01 grid]$ ./gridSetup.sh

[root@asm01 ~]# /u01/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.[root@asm01 ~]# /u01/app/19.3.0/grid/root.shPerforming root user operation.The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/19.3.0/gridEnter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /u01/app/19.3.0/grid/crs/install/crsconfig_paramsThe log of current session can be found at: /u01/app/grid/crsdata/asm01/crsconfig/roothas_2022-01-09_10-10-18PM.logLOCAL ADD MODE Creating OCR keys for user 'grid', privgrp 'oinstall'..Operation successful.LOCAL ONLY MODE Successfully accumulated necessary OCR keys.Creating OCR keys for user 'root', privgrp 'root'..Operation successful.CRS-4664: Node asm01 successfully pinned.2022/01/09 22:10:35 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'asm01 2022/01/09 22:11:32 /u01/app/grid/crsdata/asm01/olr/backup_20220109_221132.olr 724960844 2022/01/09 22:11:33 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

安装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 oracle]$ export DISPLAY=192.168.56.1:0.0[oracle@asm01 oracle]$ export CV_ASSUME_DISTID=RHEL7.9[oracle@asm01 dbhome_1]$ ./runInstaller

[root@asm01 tmp]# /u01/app/oracle/product/19.3.0/dbhome_1/root.shPerforming root user operation.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/19.3.0/dbhome_1Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite.The contents of "oraenv" have not changed. No need to overwrite.The contents of "coraenv" have not changed. No need to overwrite.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Oracle Trace File Analyzer (TFA - Standalone Mode) is available at : /u01/app/oracle/product/19.3.0/dbhome_1/bin/tfactlNote :1. tfactl will use TFA Service if that service is running and user has been granted access2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed

[oracle@asm01 dbhome_1]$ dbca

Linux,oracle

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。