oracle19.8 rac打补丁(4)-job-bug补丁

job-bug问题Delete On SYS.SCHEDULER$_DBMSJOB_MAP Causing Row Locks (Doc ID 2645984.1)查看:https://blog.csdn.net/jycjyc/article/details/107659227

[root@rac1 ~]# cd /patch
[root@rac1 patch]# ll
total 236
drwxrwxrwx 3 grid oinstall     45 Jul 22 15:26 31326369
-rw-r--r-- 1 root root     239935 Jul 29 11:18 p30835853_198000DBRU_Linux-x86-64.zip
[root@rac1 patch]# chown oracle:oinstall p30835853_198000DBRU_Linux-x86-64.zip 
[root@rac1 patch]# su - oracle
Last login: Tue Jul 28 22:35:15 CST 2020 on pts/0
[oracle@rac1 ~]$ cd /patch/
[oracle@rac1 patch]$ ls
31326369  p30835853_198000DBRU_Linux-x86-64.zip
[oracle@rac1 patch]$ unzip p30835853_198000DBRU_Linux-x86-64.zip 
Archive:  p30835853_198000DBRU_Linux-x86-64.zip
   creating: 30835853/
   creating: 30835853/etc/
   creating: 30835853/etc/config/
  inflating: 30835853/etc/config/actions.xml  
  inflating: 30835853/etc/config/inventory.xml  
  inflating: 30835853/README.txt     
   creating: 30835853/files/
   creating: 30835853/files/lib/
   creating: 30835853/files/lib/libserver19.a/
  inflating: 30835853/files/lib/libserver19.a/jskc.o  
   creating: 30835853/files/sqlpatch/
   creating: 30835853/files/sqlpatch/30835853/
   creating: 30835853/files/sqlpatch/30835853/23614142/
  inflating: 30835853/files/sqlpatch/30835853/23614142/30835853_apply.sql  
   creating: 30835853/files/sqlpatch/30835853/23614142/rollback_files/
   creating: 30835853/files/sqlpatch/30835853/23614142/rollback_files/19.8.0.0.0-RU-Release_Update-200614105333/
   creating: 30835853/files/sqlpatch/30835853/23614142/rollback_files/19.8.0.0.0-RU-Release_Update-200614105333/rdbms/
   creating: 30835853/files/sqlpatch/30835853/23614142/rollback_files/19.8.0.0.0-RU-Release_Update-200614105333/rdbms/admin/
  inflating: 30835853/files/sqlpatch/30835853/23614142/rollback_files/19.8.0.0.0-RU-Release_Update-200614105333/rdbms/admin/prvtbsch.plb  
  inflating: 30835853/files/sqlpatch/30835853/23614142/30835853_rollback.sql  
  inflating: 30835853/files/sqlpatch/30835853/23614142/30835853.xml  
   creating: 30835853/files/rdbms/
   creating: 30835853/files/rdbms/admin/
  inflating: 30835853/files/rdbms/admin/prvtbsch.plb  
  inflating: PatchSearch.xml         
[oracle@rac1 patch]$ ll
total 240
drwxr-xr-x 4 oracle oinstall     48 Jun 22 04:34 30835853
drwxrwxrwx 3 grid   oinstall     45 Jul 22 15:26 31326369
-rw-r--r-- 1 oracle oinstall 239935 Jul 29 11:18 p30835853_198000DBRU_Linux-x86-64.zip
-rw-rw-r-- 1 oracle oinstall   2956 Jun 22 19:34 PatchSearch.xml
[oracle@rac1 patch]$ pwd
/patch
[oracle@rac1 patch]$ scp -rp 30835853 rac2:/patch/
actions.xml                                                                                                                                                                                                100% 1776     1.8MB/s   00:00    
inventory.xml                                                                                                                                                                                              100% 1991     2.9MB/s   00:00    
README.txt                                                                                                                                                                                                 100% 6825    10.2MB/s   00:00    
jskc.o                                                                                                                                                                                                     100%  186KB  69.8MB/s   00:00    
30835853_apply.sql                                                                                                                                                                                         100% 1370     2.4MB/s   00:00    
prvtbsch.plb                                                                                                                                                                                               100%  111KB  59.4MB/s   00:00    
30835853_rollback.sql                                                                                                                                                                                      100% 1379     1.9MB/s   00:00    
30835853.xml                                                                                                                                                                                               100%  916     1.4MB/s   00:00    
prvtbsch.plb                                                                                                                                                                                               100%  111KB  22.0MB/s   00:00    
[oracle@rac1 patch]$ opatch lspatches
31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.
[oracle@rac1 patch]$ pwd
/patch
[oracle@rac1 patch]$ ls
30835853  31326369  p30835853_198000DBRU_Linux-x86-64.zip  PatchSearch.xml
[oracle@rac1 patch]$ cd 30835853/
[oracle@rac1 30835853]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oracle/app/oracle/product/19c/dbhome_1
Central Inventory : /oracle/app/oraInventory
   from           : /oracle/app/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-07-29_12-27-45PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@rac1 30835853]$ srvctl stop database -d orcl
[oracle@rac1 30835853]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/app/oracle/product/19c/dbhome_1
Central Inventory : /oracle/app/oraInventory
   from           : /oracle/app/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-07-29_12-28-51PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30835853  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/oracle/product/19c/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30835853' to OH '/oracle/app/oracle/product/19c/dbhome_1'

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...
Patch 30835853 successfully applied.
Log file location: /oracle/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-07-29_12-28-51PM_1.log

OPatch succeeded.
[oracle@rac1 30835853]$ ssh rac2
Last login: Tue Jul 28 22:02:25 2020 from rac1
[oracle@rac2 ~]$ cd /patch
[oracle@rac2 patch]$ ls
30835853  31326369
[oracle@rac2 patch]$ cd 30835853/
[oracle@rac2 30835853]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/app/oracle/product/19c/dbhome_1
Central Inventory : /oracle/app/oraInventory
   from           : /oracle/app/oracle/product/19c/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-07-29_12-30-05PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30835853  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/oracle/product/19c/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30835853' to OH '/oracle/app/oracle/product/19c/dbhome_1'

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...
Patch 30835853 successfully applied.
Log file location: /oracle/app/oracle/product/19c/dbhome_1/cfgtoollogs/opatch/opatch2020-07-29_12-30-05PM_1.log

OPatch succeeded.
[oracle@rac2 30835853]$ opatch lspatches
30835853;DBMS_JOB.SUBMIT PROCEDURE BEHAVIOR CHANGE IN 19C
31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.
[oracle@rac2 30835853]$ exit
logout
Connection to rac2 closed.
[oracle@rac1 30835853]$ opatch lspatches
30835853;DBMS_JOB.SUBMIT PROCEDURE BEHAVIOR CHANGE IN 19C
31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.
[oracle@rac1 30835853]$ srvctl start database -d orcl
[oracle@rac1 30835853]$ cd $ORACLE_HOME/OPatch
[oracle@rac1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.8.0.0.0 Production on Wed Jul 29 12:33:00 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_16347_2020_07_29_12_33_00/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
Interim patch 30835853 (DBMS_JOB.SUBMIT PROCEDURE BEHAVIOR CHANGE IN 19C):
  Binary registry: Installed
  PDB CDB$ROOT: Not installed
  PDB PDB: Not installed
  PDB PDB$SEED: Not installed
Interim patch 31219897 (OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)):
  Binary registry: Installed
  PDB CDB$ROOT: Applied successfully on 28-JUL-20 10.15.21.672220 PM
  PDB PDB: Applied successfully on 28-JUL-20 10.15.21.705940 PM
  PDB PDB$SEED: Applied successfully on 28-JUL-20 10.15.21.687311 PM

Current state of release update SQL patches:
  Binary registry:
    19.8.0.0.0 Release_Update 200703031501: Installed
  PDB CDB$ROOT:
    Applied 19.8.0.0.0 Release_Update 200703031501 successfully on 27-JUL-20 09.52.49.305000 PM
  PDB PDB:
    Applied 19.8.0.0.0 Release_Update 200703031501 successfully on 27-JUL-20 09.52.52.237480 PM
  PDB PDB$SEED:
    Applied 19.8.0.0.0 Release_Update 200703031501 successfully on 27-JUL-20 09.52.53.065046 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB
    No interim patches need to be rolled back
    No release update patches need to be installed
    The following interim patches will be applied:
      30835853 (DBMS_JOB.SUBMIT PROCEDURE BEHAVIOR CHANGE IN 19C)

Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 30835853 apply (pdb CDB$ROOT): SUCCESS
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/30835853/23614142/30835853_apply_ORCL_CDBROOT_2020Jul29_12_33_40.log (no errors)
Patch 30835853 apply (pdb PDB$SEED): SUCCESS
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/30835853/23614142/30835853_apply_ORCL_PDBSEED_2020Jul29_12_33_44.log (no errors)
Patch 30835853 apply (pdb PDB): SUCCESS
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/30835853/23614142/30835853_apply_ORCL_PDB_2020Jul29_12_33_44.log (no errors)
SQL Patching tool complete on Wed Jul 29 12:49:35 2020
[oracle@rac1 OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 29 12:50:05 2020
Version 19.8.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
SQL> set line 160
SQL> set wrap off
SQL>  select patch_id,action,status,ACTION_TIME from dba_registry_sqlpatch;

  PATCH_ID ACTION          STATUS                    ACTION_TIME
---------- --------------- ------------------------- ---------------------------------------------------------------------------
  29517242 APPLY           SUCCESS                   26-JUL-20 12.14.21.091505 PM
  31281355 APPLY           SUCCESS                   27-JUL-20 09.52.49.305000 PM
  31219897 APPLY           SUCCESS                   28-JUL-20 10.15.21.672220 PM
  30835853 APPLY           SUCCESS                   29-JUL-20 12.49.27.769237 PM

SQL> alter session set container=pdb;

Session altered.

SQL>  select patch_id,action,status,ACTION_TIME from dba_registry_sqlpatch;

  PATCH_ID ACTION          STATUS                    ACTION_TIME
---------- --------------- ------------------------- ---------------------------------------------------------------------------
  29517242 APPLY           SUCCESS                   26-JUL-20 12.21.57.588343 PM
  31281355 APPLY           SUCCESS                   27-JUL-20 09.52.52.237480 PM
  31219897 APPLY           SUCCESS                   28-JUL-20 10.15.21.705940 PM
  30835853 APPLY           SUCCESS                   29-JUL-20 12.49.27.810132 PM

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
         0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 PDB                            READ WRITE NO
SQL> conn /as sysdba
Connected.
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
         0

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
 

在本地自己的操作系统上,完全模拟生产环境,让学员跟着视频一步一步搭建一套在RHEL7操作系统上面的oracle19c的rac环境。同时学员还会学会DNS服务器,DNS客户端,NTP服务器,NTP客户端等操作系统知识。让学员在短时间内,oracle和操作系统知识,有一定的提升。让学员可以独自轻松安装一套oracle rac环境。 一课程主题 模拟生产环境,用多路径共享存储,用虚拟软件安装一套RHEL7.5+oracle19c+rac+打补丁 二课程特色 完成模拟生产环境,用openfiler软件模拟生产惠普的3par存储,用2个虚拟网卡模拟数据库服务器的2个HBA卡。 课程以实践为主,从头到尾一步一步教学员怎样操作,实践性强 模拟生产需求,完全可以把这套环境拿到生产环境安装 三课程内容 1.课程结束成果演示    1.1 用workstation,安装一套rhel7+oracle19c+rac+multipath+共享存储+DNS服务器+DNS客户端+NTP服务器+NTP客户端的生产环境    1.2 怎样打oracle19c的rac补丁(包括GI补丁oracle补丁,数据库补丁,OJVM补丁,bug补丁) 2.安装openfiler软件,模拟共享存储+配置多路径访问    2.1安装openfiler软件    2.2配置openfiler软件(配置2个虚拟网卡,模拟服务器的2个HBA卡)    2.3创建ocr磁盘    2.4创建mgmt磁盘    2.5创建数据文件磁盘    2.6创建归档日志磁盘 3.安装2台数据库服务器    3.1安装2台数据库服务器RHEL7.5    3.2配置服务器双网卡绑定+配置服务器心跳线 4.安装多路径软件识别共享存储中的磁盘     4.1安装服务器本地yum源     4.2安装iscsi软件,配置多路径配置文件,识别共享存储中的磁盘     4.3识别ocr磁盘     4.4识别mgmt磁盘     4.5识别数据文件磁盘     4.6识别归档日志磁盘 5.oracle19c的rac环境系统参数官方说明     5.1如何配置oracle19c的rac的系统参数(我们参考官方说明)     5.2oracle19c+rac环境Best Practices 官方说明文档 6.安装oracle19c+rac之前的准备工作     6.1修改/etc/hosts文件     6.2配置DNS服务器+DNS客户端+NTP服务器+NTP客户端     6.3创建用户和组     6.4创建目录     6.5修改用户环境变量     6.6安装相关软件包     6.7配置ssh互信     6.9禁用服务器透明大页 7.安装oracle+19c+rac软件    7.1安装GI软件    7.2创建ASM磁盘,主要是数据文件磁盘和归档日志磁盘    7.3安装数据库软件    7.4创建数据库实例    7.5日常常用维护集群命令(启停数据库,启停集群,查看监听,教同学们怎样不死记命令,而且命令还正确) 8.打补丁   8.1打GI和ORACLE的操作系统补丁   8.2打OJVM补丁   8.3打ORA600的bug补丁 9.课程总结和成果演示  9.1课程总结和成果演示 四学习必要工具 安装workstation软件   官网下载openfiler,rhel7.5软件 下载oracle软件(包括19.3的rac安装包,19.4补丁) 以上软件我都已经在视频里面做了下载地址说明
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页