大菜狗の博客 - 安装类
type: channel
link: https://auxos.cn/category/installer/
items: Oracle11g单节点库通过搭建DG RAC的方式迁移至集群环境
items: 龙析系统安装Oracle19c
items: Centos7 安装Oracle19c环境准备
items: Oracle 11g集群Rac安装 Centos7
items: WindowsServer配置Oracle11g DG
items: Oracle 19c 集群环境安装 Centos7
items: Oracle 12c升级 Oracle 19c
items: Oracle 19c 单实例DG搭建最终版本
items: Oracle 19c 集群环境RU补丁安装
items: OracleLinux_R7_U9安装Oracle19c集群

Oracle11g单节点库通过搭建DG RAC的方式迁移至集群环境
type: item
date: 2024-08-14T16:31:00+08:00
description: 一、环境配置1.1、安装软件包1.1.1、配置本地源注:能通过公网安装软件包的情况下跳过该项mv /etc/yum.repos.d/* /tmp/ echo "[local_yum]" >> /etc/yum.repos.d/henry.repo echo "name = henry_repo" >> /etc/yum.repos.d/henry.repo echo "baseurl = file:///mnt/" >> /etc/yum.repos.d/henry.repo echo "enabled = 1" >> /etc/yum.repos.d/henry.repo echo "gpgcheck = 0" >> /etc/yum.repos.d/henry.repo mount /dev/cdrom /mnt/1.1.2、安装软件包yum -y install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXtst libX11 libXau libxcb libXi libXrender make smartmontools sysstat kmod* sysstat unixODBC unixODBC-devel libnsl lm_sensors-libs ksh make glibc-devel libaio-devel libstdc++-devel nano需要单独安装的软件包yum -y localinstall https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libcap1-1.10-7.el7.x86_64.rpm yum -y localinstall https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/sysstat-10.1.5-20.0.3.el7_9.x86_64.rpm yum -y localinstall https://mirrors.aliyun.com/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm yum -y localinstall http://vault.centos.org/5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm1.2、内核参数调整,执行以下代码块自动完成export shmall=$(echo "`cat /proc/meminfo | grep "MemTotal" | awk '{print $2}'` / (`getconf PAGESIZE` / 1024)" | bc) export shmax=$(echo "`cat /proc/meminfo | grep "MemTotal" | awk '{print $2}'` * 1024 * 0.8" | bc | sed 's#\..*$##') echo """kernel.shmall = $shmall kernel.shmmax = $shmax kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 1048576 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 = 104857 vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 net.ipv6.conf.all.disable_ipv6 = 1 net.ipv6.conf.default.disable_ipv6 = 1 net.ipv6.c…

龙析系统安装Oracle19c
type: item
date: 2024-01-25T10:09:00+08:00
description: 龙析系统安装 Oracle19c1.安装背景本次教程使用VMware workstation Pro 17 创建虚拟机完成安装测试1.1 系统选择os版本信息:AnolisOS-8.8-x86_64-dvd.iso数据库版本信息:LINUX.X64_193000_db_home.zip1.2 硬件配置信息参数值核心1 H 2 G内存2048 M存储60 G虚拟机个数2 个1.3 分区配置分区大小/boot1024 M/boot/efi1024 Mswap2048 M/all2. 环境配置2.1 内核参数调整执行以下内容export shmall=$(echo "`cat /proc/meminfo | grep "MemTotal" | awk '{print $2}'` / (`getconf PAGESIZE` / 1024)" | bc) export shmax=$(echo "`cat /proc/meminfo | grep "MemTotal" | awk '{print $2}'` * 1024 * 0.8" | bc | sed 's#\..*$##') echo """kernel.shmall = $shmall kernel.shmmax = $shmax kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 1048576 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 = 104857 vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100""" >> /etc/sysctl.conf sysctl -p2.2 关闭 Selinux 及防火墙执行以下内容sed -i 's/enforcing/disabled/g' /etc/selinux/config setenforce 0 service firewalld stop chkconfig firewalld off # 龙析8.8 系统没有network服务 关闭NetworkManager后重启无法联网 # service NetworkManager stop # chkconfig NetworkManager off2.3 用户组相关设置执行以下内容groupadd -g 1003 oinstall groupadd -g 1001 dba groupadd -g 1002 oper useradd -u 1001 -g oinstall -G dba,oper oracle echo oracle |passwd --stdin oracle2.4 创建目录赋予权限mkdir -p /u01/app/oracle/product/19c/db_1 chown -R oracle:oinstall /u01/ chmod -R 775 /u01/2.5 修改Oracle用户下变量echo """export ORACLE_SID=orcl export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=\${ORACLE_BASE}/product/19c/db_1 export NLS_DATE_FORMAT="YYYY:MM:DDHH24:MI:SS" export NLS_LANG=american_america.ZHS16GBK export TNS_ADMIN=\$ORACLE_HOME/network/admin export ORA_NLS11=\$ORACLE_HOME/nls/data export PATH=.:\${PATH}:\$ORACLE_HOME/bin:/usr/bin:/usr/bin/X11:/usr/local/bin: export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:\$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib # export CLASSPATH=\$ORACLE_HOME/…

Centos7 安装Oracle19c环境准备
type: item
date: 2024-01-25T10:06:00+08:00
description: CentOS_7 Install Oracle 19c configuration1.安装操作系统系统磁盘分配：/boot 200M/boot/efi 300Mswap 16384M/ all系统版本：CentOS-7-x86_64-DVD-2009.isoOracle版本：LINUX.X64_193000_db_home.zip2.系统准备2.1内核参数调整vi /etc/sysctl.conf kernel.shmall = 264060061 #填入命令echo "`cat /proc/meminfo | grep "MemTotal" | awk '{print $2}'` / (`getconf PAGESIZE` / 1024)" | bc 的运行结果 kernel.shmmax = 865272007884 #填入命令echo "`cat /proc/meminfo | grep "MemTotal" | awk '{print $2}'` * 1024 * 0.8" | bc | sed 's#\..*$##' 的运行结果 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 1048576 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 = 104857 vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 sysctl -p #使参数生效2.2.关闭selinux及防火墙sed -i 's/enforcing/disabled/g' /etc/selinux/config setenforce 0 service firewalld stop chkconfig firewalld off service NetworkManager stop chkconfig NetworkManager off2.3.用户组相关设置groupadd -g 1003 oinstall groupadd -g 1001 dba groupadd -g 1002 oper useradd -u 1001 -g oinstall -G dba,oper oracle echo oracle |passwd --stdin oracle2.4.创建目录赋予权限mkdir -p /u01/app/oracle/product/19c/db_1 chown -R oracle:oinstall /u01/ chmod -R 775 /u01/2.5.修改Oracle变量(oracle用户下执行)vi .bash_profile ORACLE_SID=; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=${ORACLE_BASE}/product/19c/db_1; export ORACLE_HOME 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:/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_…

Oracle 11g集群Rac安装 Centos7
type: item
date: 2024-01-25T10:05:00+08:00
description: Oracle 11g RAC 双节点一、规划1.1、系统规划磁盘名称磁盘大小作用/dev/sda20GOS 操作系统1.2、网络规划主机名称rac1rac2public ip172.16.130.200172.16.130.210private ip10.0.80.20010.0.80.210vip172.16.130.201172.16.130.211scan ip172.16.130.220172.16.130.2201.3、磁盘规划采用Free NAS 的 iSCSI 块共享存储磁盘名称磁盘大小ASM磁盘名称作用/dev/sdb2Gasm-ocr1OCR/Voting File/dev/sdc2Gasm-ocr2OCR/Voting File/dev/sdd2Gasm-ocr3OCR/Voting File/dev/sde20Gasm-dataData Files二、系统环境及参数设置2.1、YUM仓库配置（双节点）mv /etc/yum.repos.d/* /tmp/ echo "[local_yum]" >> /etc/yum.repos.d/henry.repo echo "name = henry_repo" >> /etc/yum.repos.d/henry.repo echo "baseurl = file:///mnt/" >> /etc/yum.repos.d/henry.repo echo "enabled = 1" >> /etc/yum.repos.d/henry.repo echo "gpgcheck = 0" >> /etc/yum.repos.d/henry.repo mount /dev/cdrom /mnt/ yum -y install autoconf automake binutils binutils-devel bison cpp dos2unix ftp gcc gcc-c++ lrzsz python-devel compat-libcap1 compat-libstdc* libXpm-*.i686 libXext libXext.i686 libX11 libX11.i686 libxcb libxcb.i686 libaio* libaio-devel libaio-devel.i686 ksh libXp libaio-devel numactl numactl-devel make sysstat unixODBC unixODBC-devel elfutils-libelf-devel redhat-lsb-core unzip libXrender libXrender-devel nfs-utils smartmontools tigervnc* libvirt* e2fsprogs.x86_64 libXau* libXi* libXtst* libstdc* glibc* libgcc* ksh gcc-c++*2.2、编辑HOSTS文件（双节点）vim /etc/hosts # 添加内容 #scanip 172.16.130.220 racscan #rac1 172.16.130.200 rac1 10.0.80.200 rac1pri 172.16.130.201 rac1vip #rac2 172.16.130.210 rac2 10.0.80.210 rac2pri 172.16.130.211 rac2vip2.3、创建用户和组（双节点）/usr/sbin/groupadd -g 5001 oinstall /usr/sbin/groupadd -g 5002 dba /usr/sbin/groupadd -g 5003 oper /usr/sbin/groupadd -g 5004 asmadmin /usr/sbin/groupadd -g 5005 asmoper /usr/sbin/groupadd -g 5006 asmdba /usr/sbin/useradd -g oinstall -G dba,asmdba,oper -d /home/oracle -m oracle /usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid -m grid # 修改用户 oracle 及 grid 密码 echo "oracle" | passwd --stdin oracle echo "grid" | passwd --stdin grid2.4、创建文件夹及授权（双节点）mkdir -p /u01/app/{grid,11g/grid,oracle…

WindowsServer配置Oracle11g DG
type: item
date: 2024-01-25T10:05:00+08:00
description: Oracle 11g DG服务器环境操作系统 Server 2012 R2数据库版本 Oracle 11G 11.2.0.4.0配置准备主库安装数据库，备库只需要安装数据库软件安装路径主备库的路径要一致DG配置主库开启强制归档和闪回恢复sqlplus / as sysdba shutdown immediate startup mount alter database archivelog; alter database force logging; alter database flashback on;主库为备库创建日志文件set wrap off; select * from v$logfile order by group#; #查询日志组 GROUP# STATUS TYPE MEMBER ---------- -------------- -------------------- --------------- 1 ONLINE D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG 2 ONLINE D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG 3 ONLINE D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG # 当前在线日志共有3组，为备库创建的日志建议比在线日志多一组，即4组 alter database add standby logfile group 4 ('D:\APP\ADMINISTRATOR\ORADATA\ORCL\stdredo004.log') size 50m; alter database add standby logfile group 5 ('D:\APP\ADMINISTRATOR\ORADATA\ORCL\stdredo005.log') size 50m; alter database add standby logfile group 6 ('D:\APP\ADMINISTRATOR\ORADATA\ORCL\stdredo006.log') size 50m; alter database add standby logfile group 7 ('D:\APP\ADMINISTRATOR\ORADATA\ORCL\stdredo007.log') size 50m; select * from v$logfile order by group#; #查询日志组 GROUP# STATUS TYPE MEMBER ---------- -------------- -------------------- ---------------------------------------------------- 1 ONLINE D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG 2 ONLINE D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG 3 ONLINE D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG 4 STANDBY D:\APP\ADMINISTRATOR\ORADATA\ORCL\STDREDO004.LOG 5 STANDBY D:\APP\ADMINISTRATOR\ORADATA\ORCL\STDREDO005.LOG 6 STANDBY D:\APP\ADMINISTRATOR\ORADATA\ORCL\STDREDO006.LOG 7 STANDBY D:\APP\ADMINISTRATOR\ORADATA\ORCL\STDREDO007.LOG主库修改系统参数#设置db_unique_name alter system set db_unique_name='primary' scope=spfile; #设置日志归档配置，用于限制日志传输的目标，只能在这两个指定的数据库进行，该配置中的顺序可以调换 alter system set log_archive_config='DG_CONFIG=(primary,standby)' scope=spfile; #设置日志归档路径1 alter system set log_archive_dest_1='location=D:\app\Administrator\archivelog\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary' scope=spfile; #设置日志归档路径2 alte…

Oracle 19c 集群环境安装 Centos7
type: item
date: 2024-01-25T10:04:00+08:00
description: Oracle 19c Rac Install测试环境，Vmware + CentOS 7x64 + Oracle 11g，本次测试安装系统采用最小安装一，规划1.1，IP规划主机名public IPPrivate IPVIPScanner IPrac_110.10.10.1011.11.11.1010.10.10.810.10.10.7rac_210.10.10.1111.11.11.1110.10.10.910.10.10.71.2，磁盘规划进入Windows CMD命令行窗口到VMware安装位置执行命令创建cd C:\Program Files (x86)\VMware\VMware Workstation vmware-vdiskmanager.exe -c -s 2Gb -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\shareDisk\OCR01.vmdk" vmware-vdiskmanager.exe -c -s 2Gb -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\shareDisk\OCR02.vmdk" vmware-vdiskmanager.exe -c -s 2Gb -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\shareDisk\OCR03.vmdk" vmware-vdiskmanager.exe -c -s 20Gb -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\shareDisk\DATA.vmdk" vmware-vdiskmanager.exe -c -s 5Gb -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\shareDisk\ARCH.vmdk"二，系统配置2.1，系统配置(所有节点)进入虚拟机配置界面，添加两个网卡，一个nat，一个仅主机，IP段按照规划来配置进入系统，挂载光盘，修改yum仓库为光驱mv /etc/yum.repos.d/* /tmp/ echo "[local_yum]" >> /etc/yum.repos.d/henry.repo echo "name = henry_repo" >> /etc/yum.repos.d/henry.repo echo "baseurl = file:///mnt/" >> /etc/yum.repos.d/henry.repo echo "enabled = 1" >> /etc/yum.repos.d/henry.repo echo "gpgcheck = 0" >> /etc/yum.repos.d/henry.repo mount /dev/cdrom /mnt/2.2，添加硬盘(所有节点)将上边的硬盘添加到虚拟机，然后点击高级-勾选独立-永久-确定，集群中虚拟机都需要添加创建的几个磁盘，模式都设置成独立永久然后关闭虚拟机，打开虚拟机保存目录修改所有虚拟机的文件Oracle_Rac_1.vmx#添加以下代码 disk.locking="FALSE" disk.EnableUUID = "TRUE"修改完成后开机2.3，网络(所有节点)rac中所有服务器按照规划中的IP划分做好，两张网卡，一张public IP，一张private IP2.4，检查系统依赖(所有节点)vi /etc/yum.repos.d/iso.repo [iso] name=iso baseurl=file:///mnt enabled=1 gpgcheck=0 mount /dev/cdrom /mnt yum -y install binutils compat-libstdc++-33 glibc ksh libaio libgcc libstdc++ make compat-libcap1 gcc gcc-c++ glibc-devel libaio-devel libstdc++-devel sysstat autoconf automake binutils binutils-devel bison cpp dos2unix ftp gcc gcc-c++ lrzsz python-devel compat-libcap1 compat-libstdc* libXpm-*.i686 libXext libXext.i686 libX11 libX11.i686 libxcb libx…

Oracle 12c升级 Oracle 19c
type: item
date: 2024-01-25T10:04:00+08:00
description: Oracle 12c 升级 Oracle 19c本次升级是以原库备份，恢复到目标数据库修改配置后执行dbua升级备份脚本run { allocate channel ch1 device type disk; allocate channel ch2 device type disk; sql 'alter system archive log current'; backup as compressed backupset database format '/u03/backup/fullbackup_%U_%T_%D'; release channel ch1; release channel ch2; allocate channel ch1 device type disk; allocate channel ch2 device type disk; backup as compressed backupset archivelog all format '/u03/backup/archive_%U_%T_%D'; release channel ch1; release channel ch2; allocate channel ch1 device type disk; backup format '/u03/backup/control_%U_%T_%D' current controlfile; release channel ch1; allocate channel ch1 device type disk; backup spfile format '/u03/backup/spfile_%U_%T_%D'; release channel ch1; }恢复脚本## dafafile 和 数据文件编号查询 ## select file#,name from v$datafile; ## 查询出的原数据文件编号，恢复到指定的目标位置 SQL> shutdown immediate; SQL> startup nomount; SQL> set dbid XXXXXXXXXX; SQL> restore controlfile from "xxxxxxxxx"; SQL> alter database mount; RMAN> run { allocate channel c1 device type disk; allocate channel c2 device type disk; set newname for datafile x to "xxxxxxxx.dbf"; restore database; switch datafile all; release channel c1; release channel c2; }备份归档日志##创建指定归档日志目录 mkdir /u03/backup/archivelog ##创建一张测试表 create table testtable (id number(10)); insert into testtable values(1); insert into testtable values(2); insert into testtable values(3); ##执行检查点 alter system chekpoint; ##切换日志 alter system switch logfile; ##备份全部归档日志 backup archivelog all format '/u03/backup/archivelog/rman_arch_%T_%u';恢复新的归档日志##注册归档日志 RMAN> catalog start with '/u03/backup/archivelog/'; ##恢复归档日志 RMAN> restore archivelog all; RMAN> restore archivelog from logseq 78574; RMAN> recover database until scn 86327108973; ##设置输出格式 SQL> set pagesize 1000 linesize 1000; SQL> col member for a50; ##查看redolog SQL> select a.group#,a.member,b.status from v$logfile a left join v$log b on a.group#=b.group#; ##重命名redolog SQL> alter database rename file '/u02/oradata/xxx/redo04.log' t…

Oracle 19c 单实例DG搭建最终版本
type: item
date: 2024-01-25T10:03:00+08:00
description: Oracle 19c 单实例DG搭建1.数据库配置1.1.关闭数据库sqlplus / as sysdba shutdown immediate1.2.启动到mount模式startup mount;1.3.修改archivelog#oracle用户下创建新的闪回路径（主库和备库同时创建） mkdir -p /u01/app/oracle/arch_risdb #sqlplus下修改archive log 日志路径 alter system set log_archive_dest_1='location=/u01/app/oracle/arch_risdb'; alter database archivelog;1.4.开启闪回模式#创建闪回目录 mkdir -p /u01/app/oracle/flashback_area#修改闪回路径 show parameter db_recovery_file_dest; alter system set db_recovery_file_dest='/u01/app/oracle/flashback_area' scope=spfile; alter system set db_recovery_file_dest_size=16G; alter database flashback on;1.5.为备库创建日志文件set wrap off; select * from v$logfile order by group#; #查询日志组 GROUP# STATUS TYPE MEMBER ---------- -------------- -------------------- --------------- 1 ONLINE /u01/app/oracle/oradata/RISDB/redo01.log 2 ONLINE /u01/app/oracle/oradata/RISDB/redo02.log 3 ONLINE /u01/app/oracle/oradata/RISDB/redo03.log # 当前在线日志共有3组，为备库创建的日志建议比在线日志多一组，即4组 alter database add standby logfile group 4 ('/u01/app/oracle/oradata/SPECTRA/sredo04.log') size 200m; alter database add standby logfile group 5 ('/u01/app/oracle/oradata/SPECTRA/sredo05.log') size 200m; alter database add standby logfile group 6 ('/u01/app/oracle/oradata/SPECTRA/sredo06.log') size 200m; alter database add standby logfile group 7 ('/u01/app/oracle/oradata/SPECTRA/sredo07.log') size 200m; select * from v$logfile order by group#; #查询日志组 GROUP# STATUS TYPE MEMBER ---------- -------------- -------------------- ---------------------------------------------------- 1 ONLINE /u01/app/oracle/oradata/RISDB/redo01.log 2 ONLINE /u01/app/oracle/oradata/RISDB/redo02.log 3 ONLINE /u01/app/oracle/oradata/RISDB/redo03.log 4 STANDBY /u01/app/oracle/oradata/RISDB/redo04.log 5 STANDBY /u01/app/oracle/oradata/RISDB/redo05.log 6 STANDBY /u01/app/oracle/oradata/RISDB/redo06.log 7 STANDBY /u01/app/oracle/oradata/RISDB/redo07.log1.6.主库修改系统参数#设置db_unique_name alter system set db_unique_name='master' scope=spfile; #设置日志归档配置，用于限制日志传输的目标，只能在这两个指定的数据库进行，该配置中的顺序可以调换 alte…

Oracle 19c 集群环境RU补丁安装
type: item
date: 2024-01-25T10:03:00+08:00
description: 1 补丁背景此环境为新装的Oracle19c 版本，未安装补丁。提前将所需的软件包上传到各节点的opt目录下包功能p35642822_190000_Linux-x86-64.zipGrid Updatesp35643107_190000_Linux-x86-64.zipDatabase Updatesp35648110_190000_Linux-x86-64.zipJAVAVMp6880880_190000_Linux-x86-64.zipOPatch1.1 解压补丁包# root用户执行 cd /opt/ unzip p35642822_190000_Linux-x86-64.zip -d gi/ unzip p35643107_190000_Linux-x86-64.zip -d db/ unzip p35648110_190000_Linux-x86-64.zip -d javavm/ chown -R grid:oinstall /opt/*1.2 打补丁注意事项为保障业务的连续性，先取其中一个节点安装gi，db，javavm补丁。安装完成后，启动节点接管业务后再执行其他节点的安装。2 GI补丁注：GI 补丁在grid用户下执行检查。更新补丁在root用户下执行2.1 生产库GI版本-双节点[grid@rac01:/home/grid]$ crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [19.0.0.0.0] [grid@rac01:/home/grid]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0]2.2 生产库GI OPATH版本-双节点[grid@rac01:/home/grid]$ opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded.2.3 grid opatch更新-双节点# root用户执行 mv /u01/app/19.3.0.0/grid/OPatch /u01/app/19.3.0/grid/OPatch.bak unzip -q /opt/p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0/grid/ chmod -R 755 /u01/app/19.3.0/grid/OPatch chown -R grid:oinstall /u01/app/19.3.0/grid/OPatch su - grid opatch version2.4 GI补丁检查-双节点2.4.1 安装前补丁版本检查[grid@rac01:/u01/app/19.3.0/grid]$ opatch lspatches 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399) 29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247) 29517242;Database Release Update : 19.3.0.0.190416 (29517242) 29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763) OPatch succeeded.2.4.2 补丁冲突检查$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/gi/35642822/33575402/ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/gi/35642822/35553096/ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/gi/35642822/35643107/ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/gi/35642822/35652062/ $ORACLE_HOME/OPatch/opatch prereq CheckConfl…

OracleLinux_R7_U9安装Oracle19c集群
type: item
date: 2024-01-25T10:02:00+08:00
description: 1 安装计划1.1 测试环境规划模块软件虚拟化VMware® Workstation 17 Pro 17.0.0 build-20800274操作系统OracleLinux-R7-U9-Server-x86_64-dvd.isoOracle GILINUX.X64_193000_grid_home.zipOracle DBLINUX.X64_193000_db_home.zip1.2 虚拟机规划硬件规划模块配置处理器2 Core内存4 GB磁盘40 GB网卡两个网卡镜像-1.3 网络规划节点名Public IPPrivate IPVirtual IPScan IPrac-01192.168.110.22110.10.10.221192.168.110.223192.168.110.220rac-02192.168.110.22210.10.10.222192.168.110.224192.168.110.2201.4 系统分区规划分区大小功能/boot1 G引导分区/boot/efi1 GEFI 分区swap4 G虚拟内存(对标内存大小)/剩下的空间根分区1.5 共享存储规划虚拟磁盘大小OCR11 GOCR21 GOCR31 GFRA10 GDATA40 G1.6 用户,组规划GroupNameGroupID说明oinstall54421Oracle清单和软件所有者dba54322数据库管理员oper54323DBA操作员组backupdba54324备份管理员dgdba54325DG管理员kmdba54326KM管理员asmdba54327ASM数据库管理员组asmoper54328ASM操作员组asmadmin54329Oracle自动存储管理组racdba54330RAC管理员1.7 软件目录规划目录名称路径说明ORACLE_BASE （oracle）/u01/app/oracleoracle基目录ORACLE_HOME （oracle）/u01/app/oracle/product/19.3.0/dbhome_1oracle用户HOME目录ORACLE_BASE （grid）/u01/app/gridgrid基目录ORACLE_HOME （grid）/u01/app/19.3.0/gridgrid用户HOME目录2 系统安装注：安装步骤省略3 共享存储配置3.1 创建虚拟磁盘(Windows宿主机)# VMware 安装目录运行CMD 执行下边的命令创建vmdk文件 vmware-vdiskmanager.exe -c -s 1g -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\ShareDisk\ocr1.vmdk" vmware-vdiskmanager.exe -c -s 1g -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\ShareDisk\ocr2.vmdk" vmware-vdiskmanager.exe -c -s 1g -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\ShareDisk\ocr3.vmdk" vmware-vdiskmanager.exe -c -s 10GB -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\ShareDisk\fra.vmdk" vmware-vdiskmanager.exe -c -s 40GB -a lsilogic -t 2 "C:\Users\syspn\Documents\Virtual Machines\ShareDisk\data.vmdk"3.2 修改VMX文件(Windows宿主机)注：关闭两个虚拟机后，打开两个虚拟机目录的vmx文件，将下边的内容添加到文件中，将下边的路径改为实际创建的路径和名称。修改完成后重新打开虚拟机#shared disks configure diskLib.dataCacheMaxSize=0 diskLib.dataCacheMaxReadAheadSize=0 diskLib.dataCacheMinReadAheadSize=0 diskLib.dataCachePageSize=4096 diskLib.maxUnsyncedWrites = "0" disk.locking = "FALSE" scsi1.sharedBus = "virtual" scsi1.present = "TRUE" scsi1.virtualDev =…