本文档将指导您在 Linux 平台上使用 ASM 逐步安装 Oracle 19C RAC。版本步这里讨论每一步。安装我们将RAC安装与ASM配合并进行版本升级。使用升级
遵循的版本步步骤 :
“/etc/hosts”文件必须包含服务器的使用升级完全限定名称。请以 root 用户身份在“/etc/hostname”文件中设置正确的版本步主机名。
#Public IP
10.201.33.38 AUS-LNDBASMT-001.dbanalyser.com AUS-LNDBASMT-001
10.201.33.39 AUS-LNDBASMT-002.dbanalyser.com AUS-LNDBASMT-002
#Virtual IP
10.201.33.70 AUS-LNDBASMT-001-vip.dbanalyser.com AUS-LNDBASMT-001-vip
10.201.33.71 AUS-LNDBASMT-002-vip.dbanalyser.com AUS-LNDBASMT-002-vip
#Private IP
10.201.224.125 AUS-LNDBASMT-001-priv.dbanalyser.com AUS-LNDBASMT-001-priv
10.201.224.126 AUS-LNDBASMT-002-priv.dbanalyser.com AUS-LNDBASMT-002-priv
#Scan
10.201.33.72 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN
10.201.33.73 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN
10.201.33.74 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN
执行自动或手动设置以完成基本的使用升级先决步骤。所有安装都需要额外的版本步设置。
如果您使用的安装是 RHEL7 或 CentOS7,则可以从 OL7 存储库获取 PRM 并安装它。它将从您的普通存储库中提取依赖项。
# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
对于 RHEL8 或 CentOS8 –
curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c- 1.0-2.el8.x86_64.rpm yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
需要通过以下命令禁用服务器的防火墙。
systemctl stop firewalld systemctl disable firewalld
在“/etc/sysctl.conf”文件中添加或修改以下行。
fs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104kernel.panic_on_oops = 1net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576net.ipv4.conf.all.rp_filter = 2net.ipv4.conf.default.rp_filter = 2fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500
运行以下命令之一来更改当前内核参数。
/sbin/sysctl -p
将以下行添加到“/etc/security/limits.conf 文件”。
oracle soft nofile 1024oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768oracle hard memlock 134217728oracle soft memlock 134217728
创建用户和组。
groupadd -g 54321 oinstallgroupadd -g 54322 dbagroupadd -g 54323 oper groupadd -g 54324 backupdbagroupadd -g 54325 dgdbagroupadd -g 54326 kmdbagroupadd -g 54327 asmdbagroupadd -g 54328 asmopergroupadd -g 54329 asmadmingroupadd -g 54330 racdba useraddoracleusermod -g oinstall oracleusermod -G dba asmoper,asmadmin.asmdba,oper,oracle
安装以下 RPM 软件包。
yum install -y bc yum install -y binutils#yum install -y compat-libcap1yum install -y compat-libstdc++-33#yum install -y dtrace-modules#yum install -y dtrace-modules-headers#yum install -y dtrace-modules-provider-headers#yum install -y dtrace-utilsyum install -y elfutils-libelfyum install -y elfutils-libelf-develyum install -y fontconfig-develyum install -y glibcyum install -y glibc-develyum install -y kshyum install -y libaioyum install -y libaio-devel#yum install -y libdtrace-ctf-develyum install -y libXrenderyum install -y libXrender-develyum install -y libX11yum install -y libXauyum install -y libXiyum install -y libXtstyum install -y libgccyum install -y librdmacm-develyum install -y libstdc++yum install -y libstdc++-develyum install -y libxcbyum install -y makeyum install -y net-tools # Clusterwareyum install -y nfs-utils # ACFSyum install -y python # ACFSyum install -y python-configshell # ACFSyum install -y python-rtslib # ACFSyum install -y python-six # ACFSyum install -y targetcli # ACFSyum install -y smartmontoolsyum install -y sysstatyum install -y unixODBC # New for OL8yum install -y libnslyum install -y libnsl.i686yum install -y libnsl2yum install -y libnsl2.i686
网络配置。
vi /etc/sysconfig/network# Recommended value for NOZEROCONFNOZEROCONF=yes
kmod-oracleasm-2.0.8-17.el7.x86_64oracleasmlib-2.0.12-1.el7.x86_64.rpmoracleasm-support-2.1.8-3.el7.x86_64.rpm
oracleasm configure -i Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets (‘[]’). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.Default user to own the driver interface []: oracleDefault group to own the driver interface []: oinstallScan for Oracle ASM disks on boot (y/n) [y]: y Writing Oracle ASM library driver configuration: done
oracleasm start
fdisk /dev/sdf Welcome to fdisk (util-linux 2.23.2). Changes will remain in memory only, until you decide to write them. Be careful before using the write command. Command (m for help): n Partition type: p primary (1 primary, 0 extended, 3 free) e extended Select (default p): Using default response p Partition number (2-4, default 2): d Partition number (2-4, default 2): 2 No free sectors available Command (m for help): d Selected partition 1 Partition 1 is deleted Command (m for help): n Partition type:p primary (0 primary, 0 extended, 4 free) e extended Select (default p)Using default response partition number (1-4, default 1): First sector (2048-20971519, default 2048): Last sector, +sectors or +size{ K,M,G} (2048-20971519, default 20971519): Using default value 20971519 Partition 1 of type Linux and of size 10 GiB is set Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. /etc/init.d/oracleasm status Checking if ASM is loaded: yesChecking if /dev/oracleasm is mounted: yes /etc/init.d/oracleasm createdisk DATAVOL1 /dev/sdf1 Marking disk “DATAVOL1” as an ASM disk: [ OK ] /etc/init.d/oracleasm listdisks DATAVOL1
像这样我们需要根据需要创建其他磁盘。
oracleasm scandisksoracleasm listdisks
mkdir -p /d01/app/19c/grid mkdir -p /d01/app/oracle/product/19c/db_1chown -R oracle:oinstall /d01 chmod -R 775 /d01/
unzip /d01/app/19c/grid/LINUX.X64_193000_grid_home.zip cd $GRID_HOME/deinstall ./sshUserSetup.sh -user oracle -hosts " AUS-LNDBASMT-001 AUS-LNDBASMT-002" -noPromptPassphrase
使用 CLUVFY 命令检查集群安装准备情况并在出现任何问题时进行纠正。
cd $GRID_HOME ./runcluvfy.sh stage -pre crsinst -n AUS-LNDBASMT-001,AUS-LNDBASMT-002
cd /d01/app/19c/grid/ ./gridSetup.sh
GRID 设置向导已启动...
现在请按照如下所述的步骤操作 :
选择“为新集群配置 Oracle Grid Infrastructure”选项,然后单击“下一步”按钮。
单击“下一步”按钮,选择“配置 Oracle 独立集群”选项。
输入集群名称、SCAN 名称和 SCAN 端口,然后单击“下一步”按钮。
注意–集群名称长度应在 15 个字符以内,否则安装将失败。
在“集群节点信息”屏幕上,单击“添加”按钮。输入集群中第二个节点的详细信息,然后单击“确定”按钮。单击“SSH 连接...”按钮并输入“oracle”用户的密码。单击“设置”按钮配置 SSH 连接,完成后单击“测试”按钮进行测试。测试完成后,单击“下一步”按钮。
检查公共和专用网络是否指定正确。如果显示 NAT 接口,请记住将其标记为“请勿使用”。单击“下一步”按钮。
单击“下一步”按钮,选择“使用 Oracle Flex ASM 进行存储”选项。
选择“是”并单击下一步。
如果您希望为 GIMR 创建单独的磁盘,请选择“是”,然后单击“下一步”。否则单击“否”。
注意:如果您希望在单独的磁盘上创建 GIMR,则磁盘大小必须至少为 32G。
首先使用更改发现路径浏览路径 /dev/oracleasm/disks*。将冗余设置为“正常”,单击“5GB DISK”用于 OCR 和 Voting 磁盘配置,然后单击“下一步”按钮。
如果您需要创建 GIMR。请记住这不是强制性的。
输入凭据并单击“下一步”按钮。
单击“下一步”按钮接受默认 IPMI 选项。
不要在 EM 注册。单击“下一步”按钮。
我们使用单个用户和组管理 ASM 添加数据库,因此将组设置为“oinstall”并单击“下一步”按钮。单击“是”按钮接受后续对话框中的警告。
输入 Oracle Base 位置“/d01/app/oracle”,然后单击“下一步”按钮。我们已经为后面的数据库安装预先创建了目录,因此忽略随后有关Oracle Base不为空的警告,单击“是”按钮。
单击“下一步”按钮接受默认清单目录。
如果您希望根脚本自动运行,请输入相关凭据。单击“下一步”按钮。
等待先决条件检查完成。如果您有任何问题,请使用“修复并再次检查”按钮。完成可能的修复后,选中“全部忽略”复选框,然后单击“下一步”按钮。对于此类安装,“网络时间协议 (NTP)”测试可能会失败。还行吧。它可以被修复。
如果您对摘要信息感到满意,请单击“安装”按钮。
现在GRID安装完成了。
通过发出以下命令检查正在运行的进程。
ps -ef|grep d.bin $GRID_HOME/crsctl stat res -t –> 此命令将显示两个节点正在运行的服务
将软件文件解压到您的 DB 主目录中。
unzip LINUX.X64_193000_db_home.zip
运行以下命令来设置显示。
./runInstaller
选择仅安装软件选项,然后单击下一步按钮。
单击“下一步”按钮选择 Oracle Real Application Clusters 数据库安装选项。
确保选择了两个节点,然后单击“下一步”按钮。
选择企业版选项,然后单击下一步按钮。
输入 /u01/app/orabase 作为 Oracle 库,输入/u01/app/oracle/product/19c/db_1 作为软件位置,然后单击 Next 按钮。
自动运行配置脚本 - 将其留空。
然后单击安装按钮。出现提示时,为两个节点运行 root.sh。现在19C软件二进制安装已经完成。
由于我们已经创建了所需的磁盘组(例如 DATA 和 FRA),现在我们正在继续创建数据库。
cd $ORACLE_HOME/bin
./dbca
请按照屏幕截图进行操作。
选择创建数据库并点击“下一步”
选择高级配置,点击“下一步”。
选择通用或事务处理,然后单击“下一步”。
确保两个节点都被选中。
提供数据库名称、SID,然后单击“下一步”。
选择数据库文件位置 ,然后单击“下一步”。
选择 FRA 位置、大小 ,然后单击“下一步”。
分配适当的内存和其他必要的详细信息,然后单击“下一步”。
选择下方并点击“下一步”。
为所有用户提供相同的密码,然后单击“下一步”。
单击下一步,将创建数据库。
通过触发以下命令检查 RAC 的状态 –
$GRID_HOME/crsctl stat res -tsrvctl config database -d infra srvctl status database -d infra srvctl config scan
对于版本升级,我们需要在两个节点上一一打补丁。
srvctl stop instance -db POCDB -node aus-lndbasmt-001srvctl status database -db pocdb
Instance POCDB1 is not running on node aus-lndbasmt-001
Instance POCDB2 is running on node aus-lndbasmt-002
./Opatch versionOPatch Version: 12.2.0.1.17OPatch succeeded.[oracle@AUS-LNDBASMT-001 OPatch]$ ./Opatch lsinventory -oh /oracle/Oracle_Software/19cDBOracle Interim Patch Installer version 12.2.0.1.17Copyright (c) 2020, Oracle Corporation. All rights reserved.Oracle Home : /oracle/Oracle_Software/19cDBCentral Inventory : /oracle/u01/app/oraInventory from : /oracle/Oracle_Software/19cDB/oraInst.locOPatch version : 12.2.0.1.17OUI version : 12.2.0.7.0Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-19-31PM_1.logLsinventory Output file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/lsinv/lsinventory2020-07-31_12-19-31PM.txt——————————————————————————–Local Machine Information::Hostname: AUS-LNDBASMT-001.wiley.comARU platform id: 226ARU platform description:: Linux x86-64Installed Top-level Products (1):Oracle Database 19c 19.0.0.0.0There are 1 products installed in this Oracle Home.Interim patches (2) :Patch 29585399 : applied on Thu Apr 18 03:21:33 EDT 2019Unique Patch ID: 22840393Patch description: “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)” Created on 9 Apr 2019, 19:12:47 hrs PST8PDT Bugs fixed: 27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673 28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321 28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040 28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250 28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779 28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876 29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455 29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456 29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631 29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540 29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091 29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624 29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934 29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583 29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090 29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753 29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299 29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381 29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931 29413360, 29457319, 29465047Patch 29517242 : applied on Thu Apr 18 03:21:17 EDT 2019Unique Patch ID: 22862832Patch description: “Database Release Update : 19.3.0.0.190416 (29517242)” Created on 17 Apr 2019, 23:27:10 hrs PST8PDT Bugs fixed: 29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179 25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312 27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021 28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445 28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897 28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957 28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549 28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945 28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461 28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214 28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560 28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532 28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794 28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561 28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634 28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281 28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762 28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083 28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306 28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738 29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475 29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352 29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575 29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200 29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554 29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498 29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024 29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860 29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805 29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223 29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380 29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219 29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341 29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338 29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909 29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567 29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073 29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817 29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313 29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743 29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456 29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541 29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493 29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733 29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122 29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419 29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260 29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351 29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984 29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273 29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859 29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164 29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117 29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884 29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906 29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184 29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435 29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448 29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539 29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218 29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956 29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915 29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918 29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417 29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568 29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209 29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453 29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620 29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271 29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151 29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588 29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502 29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889 29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121 29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264 29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386 29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616 29521748, 29530812, 29531654, 29557336, 29558975, 29601461——————————————————————————–OPatch succeeded.cd /oracle/patch/30125133//oracle/Oracle_Software/19cDB/OPatch/opatch query -is_rolling_patchOracle Interim Patch Installer version 12.2.0.1.17Copyright (c) 2020, Oracle Corporation. All rights reserved.Oracle Home : /oracle/Oracle_Software/19cDBCentral Inventory : /oracle/u01/app/oraInventory from : /oracle/Oracle_Software/19cDB/oraInst.locOPatch version : 12.2.0.1.17OUI version : 12.2.0.7.0Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-21-23PM_1.log——————————————————————————– Patch is a rolling patch: true Patch is a FMW rolling patch: falseOPatch succeeded.
/oracle/Oracle_Software/19cDB/OPatch/opatch applyOracle Interim Patch Installer version 12.2.0.1.17Copyright (c) 2020, Oracle Corporation. All rights reserved.Oracle Home : /oracle/Oracle_Software/19cDBCentral Inventory : /oracle/u01/app/oraInventory from : /oracle/Oracle_Software/19cDB/oraInst.locOPatch version : 12.2.0.1.17OUI version : 12.2.0.7.0Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.logVerifying environment and performing prerequisite checks…OPatch continues with these patches: 30125133 Do you want to proceed? [y|n]yUser Responded with: YAll checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.(Oracle Home = ‘/oracle/Oracle_Software/19cDB’)Is the local system ready for patching? [y|n]yUser Responded with: YBacking up files…Applying interim patch ‘30125133’ to OH ‘/oracle/Oracle_Software/19cDB’ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.Patching component oracle.rdbms, 19.0.0.0.0…Patching component oracle.rdbms.rsf, 19.0.0.0.0…Patching component oracle.assistants.acf, 19.0.0.0.0…Patching component oracle.assistants.deconfig, 19.0.0.0.0…Patching component oracle.assistants.server, 19.0.0.0.0…Patching component oracle.buildtools.rsf, 19.0.0.0.0…Patching component oracle.ctx, 19.0.0.0.0…Patching component oracle.ldap.rsf, 19.0.0.0.0…Patching component oracle.network.rsf, 19.0.0.0.0…Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…Patching component oracle.sdo, 19.0.0.0.0…Patching component oracle.sqlplus, 19.0.0.0.0…Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…Patching component oracle.rdbms.rman, 19.0.0.0.0…Patching component oracle.ctx.atg, 19.0.0.0.0…Patching component oracle.rdbms.oci, 19.0.0.0.0…Patching component oracle.rdbms.util, 19.0.0.0.0…Patching component oracle.xdk, 19.0.0.0.0…Patching component oracle.ovm, 19.0.0.0.0…Patching component oracle.network.listener, 19.0.0.0.0…Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…Patching component oracle.dbjava.jdbc, 19.0.0.0.0…Patching component oracle.dbdev, 19.0.0.0.0…Patching component oracle.rdbms.deconfig, 19.0.0.0.0…Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…Patching component oracle.install.deinstalltool, 19.0.0.0.0…Patching component oracle.dbjava.ic, 19.0.0.0.0…Patching component oracle.sdo.locator, 19.0.0.0.0…Patching component oracle.rdbms.scheduler, 19.0.0.0.0…Patching component oracle.rdbms.dv, 19.0.0.0.0…Patching component oracle.ons, 19.0.0.0.0…Patching component oracle.ldap.security.osdt, 19.0.0.0.0…Patching component oracle.ctx.rsf, 19.0.0.0.0…Patching component oracle.duma, 19.0.0.0.0…Patching component oracle.ldap.owm, 19.0.0.0.0…Patching component oracle.oracore.rsf, 19.0.0.0.0…Patching component oracle.rdbms.install.seeddb, 19.0.0.0.0…Patching component oracle.odbc, 19.0.0.0.0…Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…Patching component oracle.network.client, 19.0.0.0.0…Patching component oracle.sqlplus.ic, 19.0.0.0.0…Patching component oracle.dbjava.ucp, 19.0.0.0.0…Patching component oracle.xdk.rsf, 19.0.0.0.0…Patching component oracle.marvel, 19.0.0.0.0…Patching component oracle.xdk.parser.java, 19.0.0.0.0…Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0…Patching component oracle.precomp.common, 19.0.0.0.0…Patching component oracle.precomp.lang, 19.0.0.0.0…Patch 30125133 successfully applied.Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30125133].Please refer to Doc ID 2161861.1 for any possible further required actions.Log file location: /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.logOPatch succeeded.
4、启动oracle实列并验证补丁
srvctl start instance -db POCDB -node aus-lndbasmt-001srvctl status database -db pocdbInstance POCDB1 is not running on node aus-lndbasmt-001Instance POCDB2 is not running on node aus-lndbasmt-002[oracle@AUS-LNDBASMT-001 30125133]$ sqlplus “/ as sysdba”SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jul 31 12:30:38 2020Version 19.5.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – ProductionVersion 19.5.0.0.0SQL> select * from v$version;BANNER——————————————————————————–BANNER_FULL—————————————————————————————————————————————————————-BANNER_LEGACY CON_ID——————————————————————————– ———-Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – ProductionOracle Database 19c Enterprise Edition Release 19.0.0.0.0 – ProductionVersion 19.5.0.0.0Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production 0SQL> exitDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – ProductionVersion 19.5.0.0.0
在两个节点中执行上述步骤后,如果发现任何无效对象,则应运行 utlrp.sql 来重新验证这些对象。
cd $ORACLE_HOME/rdbms/adminsqlplus /nologSQL> CONNECT / AS SYSDBASQL> @utlrp.sql
Oracle Database 19c 第 3 版 Linux x86-64软件下载链接 –
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html。
责任编辑:姜华 来源: 今日头条 ASMOracle(责任编辑:娱乐)
四川巴中恩阳机场新增航线直通18个城市 去年旅客吞吐量38.2万人次
广西壮族自治区发展改革委组织召开研究易地扶贫搬迁有关工作专题会议
数据显示:连吃14个月信贷“小灶” A股高端制造业“涨升”回应