oracle11.2.0.1forwindows2012r2 standard打psu补丁

打补丁基本步骤:

• 1.检查+停应用+停库:     检查当前数据库相关信息等
• 2.备份
• 3.打补丁
• 4.更新数据库字典
• 5.起库
• 6.启动和检查应用

---------------------------------------

执行opatch时

报错1：

d:\psu\p12429529_112010_MSWIN-x86-64\12429529>D:\app\Administrator\product\11.2.0\dbhome_1\OPatch\opatch.bat apply
此时不应有 \Java\JDK1.7\lib\dt.jat。

处理办法:

将环境变量中的CLASSPATH去掉即可。

d:\psu\p12429529_112010_MSWIN-x86-64\12429529>set CLASSPATH=

报错2：

解决办法：

将oracle服务改为手动，重启操作系统。（在服务中虽然看到oracle所有服务都停了，但是还是不行，需要重启系统释放）

另外：

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following files are active :
D:\oracle\product\11.2.0\dbhome_1\bin\oci.dll
UtilSession 失败: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: D:\oracle\product\11.2.0\dbhome_1\cfgtoollogs\opatch\14223718_Aug_18_20
20_12_06_10\apply2020-08-18_12-06-09下午_1.log

tasklist /m oci.dll

根据pid结束进程

停止：Distributed Transaction Coordinator 服务

-------------------------以下为重启后操作-------------------------------------------------

Microsoft Windows [版本 6.3.9600]
(c) 2013 Microsoft Corporation。保留所有权利。

C:\Users\Administrator>set
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\Administrator\AppData\Roaming
CLASSPATH=.;C:\Program Files (x86)\Java\JDK1.7\lib\dt.jat;C:\Program Files (x86)
\Java\JDK1.7\lib\tools.jar
CLIENTNAME=XXZX-LB
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=WIN-PGN6S8OJN3H
ComSpec=C:\Windows\system32\cmd.exe
DB2INSTANCE=DB2
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\Administrator
INCLUDE=C:\PROGRA~1\IBM\SQLLIB\INCLUDE;C:\PROGRA~1\IBM\SQLLIB\LIB
JAVA_HOME=C:\Program Files (x86)\Java\JDK1.7
LIB=;C:\PROGRA~1\IBM\SQLLIB\LIB
LOCALAPPDATA=C:\Users\Administrator\AppData\Local
LOGONSERVER=\\WIN-PGN6S8OJN3H
NUMBER_OF_PROCESSORS=8
OS=Windows_NT
Path=C:\Program Files (x86)\Java\JDK1.7\bin;C:\Program Files (x86)\Java\JDK1.7\j
re\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\O
racle\Java\javapath;D:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Windows\
system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershe
ll\v1.0\;c:\program files\ibm\gsk8\lib64;C:\Program Files (x86)\ibm\gsk8\lib;C:\
PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\S
AMPLES\REPL
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 42 Stepping 1, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=2a01
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
SESSIONNAME=RDP-Tcp#1
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\ADMINI~1\AppData\Local\Temp\2
TMP=C:\Users\ADMINI~1\AppData\Local\Temp\2
TNS_ADMIN=D:\app\Administrator\product\instantclient_11_2
USERDOMAIN=WIN-PGN6S8OJN3H
USERDOMAIN_ROAMINGPROFILE=WIN-PGN6S8OJN3H
USERNAME=Administrator
USERPROFILE=C:\Users\Administrator
windir=C:\Windows

C:\Users\Administrator>set ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1

C:\Users\Administrator>cd D:\app\Administrator\product\11.2.0\dbhome_1

C:\Users\Administrator>d:

D:\app\Administrator\product\11.2.0\dbhome_1>cd OPatch

D:\app\Administrator\product\11.2.0\dbhome_1\OPatch>cd d:\psu

d:\psu>dir
 驱动器 D 中的卷是 新加卷
 卷的序列号是 70B9-9788

 d:\psu 的目录

2019/09/26  15:09    <DIR>          .
2019/09/26  15:09    <DIR>          ..
2019/09/26  15:09    <DIR>          p12429529_112010_MSWIN-x86-64
2019/09/26  14:13       164,195,671 p12429529_112010_MSWIN-x86-64.zip
2019/09/26  15:08    <DIR>          p6880880_112000_MSWIN-x86-64
2019/09/26  12:18       116,096,613 p6880880_112000_MSWIN-x86-64.zip
               2 个文件    280,292,284 字节
               4 个目录 1,934,941,741,056 可用字节

d:\psu>cd p12429529_112010_MSWIN-x86-64

d:\psu\p12429529_112010_MSWIN-x86-64>ls
'ls' 不是内部或外部命令，也不是可运行的程序
或批处理文件。

d:\psu\p12429529_112010_MSWIN-x86-64>dir
 驱动器 D 中的卷是 新加卷
 卷的序列号是 70B9-9788

 d:\psu\p12429529_112010_MSWIN-x86-64 的目录

2019/09/26  15:09    <DIR>          .
2019/09/26  15:09    <DIR>          ..
2019/09/26  15:09    <DIR>          12429529
               0 个文件              0 字节
               3 个目录 1,934,941,741,056 可用字节

d:\psu\p12429529_112010_MSWIN-x86-64>cd 12429529

d:\psu\p12429529_112010_MSWIN-x86-64\12429529>D:\app\Administrator\product\11.2.0\dbhome_1\OPatch\opatch.bat apply
此时不应有 \Java\JDK1.7\lib\dt.jat。
d:\psu\p12429529_112010_MSWIN-x86-64\12429529>set CLASSPATH=

d:\psu\p12429529_112010_MSWIN-x86-64\12429529>D:\app\Administrator\product\11.2.0\dbhome_1\OPatch\opatch.bat apply
Oracle 临时补丁程序安装程序版本 11.2.0.3.21
版权所有 (c) 2019, Oracle Corporation。保留所有权利。

Oracle 主目录       ：D:\app\Administrator\product\11.2.0\dbhome_1
主产品清单：C:\Program Files\Oracle\Inventory
   来自           ：
OPatch 版本    ：11.2.0.3.21
OUI 版本       ：11.2.0.1.0
日志文件位置：D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opatch\op
atch2019-09-26_15-34-21下午_1.log

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

是否继续? [y|n]
y
User Responded with: Y
All checks passed.
提供电子邮件地址以用于接收有关安全问题的通知, 安装 Oracle Configuration Manager 并启动它。
如果您使用 My Oracle
Support 电子邮件地址/用户名, 操作将更简单。
有关详细信息, 请访问 http://www.oracle.com/support/policies.html。
电子邮件地址/用户名:

尚未提供电子邮件地址以接收有关安全问题的通知。
是否不希望收到有关安全问题 (是 [Y], 否 [N]) [N] 的通知:  Y

请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = 'D:\app\Administrator\product\11.2.0\dbhome_1')

本地系统是否已准备打补丁? [y|n]
y
User Responded with: Y
Backing up files...
正在将临时补丁程序 '12429529' 应用于 OH 'D:\app\Administrator\product\11.2.0\dbhome_1'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.rdbms.ic, 11.2.0.1.0 ] , [ oracle.has
.crs, 11.2.0.1.0 ] , [ oracle.usm, 11.2.0.1.0 ] , 或找到更高版本。

正在为组件 oracle.rdbms.rsf, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.util, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.dbscripts, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.plsql, 11.2.0.1.0 打补丁...

正在为组件 oracle.xdk.rsf, 11.2.0.1.0 打补丁...

正在为组件 oracle.network.rsf, 11.2.0.1.0 打补丁...

正在为组件 oracle.oraolap, 11.2.0.1.0 打补丁...

正在为组件 oracle.ntoledb.odp_net_2, 11.2.0.1.0 打补丁...

正在为组件 oracle.has.db, 11.2.0.1.0 打补丁...

正在为组件 oracle.has.rsf, 11.2.0.1.0 打补丁...

正在为组件 oracle.javavm.server, 11.2.0.1.0 打补丁...

正在为组件 oracle.network.listener, 11.2.0.1.0 打补丁...

正在为组件 oracle.odbc.ic, 11.2.0.1.0 打补丁...

正在为组件 oracle.oraolap.api, 11.2.0.1.0 打补丁...

正在为组件 oracle.owb.rsf, 11.2.0.1.0 打补丁...

正在为组件 oracle.precomp.common, 11.2.0.1.0 打补丁...

正在为组件 oracle.ctx, 11.2.0.1.0 打补丁...

正在为组件 oracle.has.common, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.rsf.ic, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.oci, 11.2.0.1.0 打补丁...

正在为组件 oracle.has.common.cvu, 11.2.0.1.0 打补丁...

正在为组件 oracle.has.deconfig, 11.2.0.1.0 打补丁...

正在为组件 oracle.swd.oui.core, 11.2.0.1.0 打补丁...

正在为组件 oracle.ntoledb, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.deconfig, 11.2.0.1.0 打补丁...

正在为组件 oracle.sysman.agent, 10.2.0.4.2 打补丁...

正在为组件 oracle.precomp.rsf, 11.2.0.1.0 打补丁...

正在为组件 oracle.precomp.common, 11.2.0.1.0 打补丁...

正在为组件 oracle.sysman.console.db, 11.2.0.1.0 打补丁...

正在为组件 oracle.sysman.oms.core, 10.2.0.4.2 打补丁...

正在为组件 oracle.sysman.plugin.db.main.repository, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.dv.oc4j, 11.2.0.1.0 打补丁...

正在为组件 oracle.ldap.rsf, 11.2.0.1.0 打补丁...

正在为组件 oracle.ldap.rsf.ic, 11.2.0.1.0 打补丁...

正在为组件 oracle.rdbms.dv, 11.2.0.1.0 打补丁...

正在为组件 oracle.nlsrtl.rsf, 11.2.0.1.0 打补丁...
Patch 12429529 successfully applied.
Log file location: D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2
019-09-26_15-34-21下午_1.log

OPatch succeeded.

d:\psu\p12429529_112010_MSWIN-x86-64\12429529>

d:\psu\p12429529_112010_MSWIN-x86-64\12429529>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 9月 26 15:37:15 2019

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

SQL> conn /as sysdba
已连接。
SQL> show parameter name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      orcl
db_unique_name                       string      orcl
global_names                         boolean     FALSE
instance_name                        string      orcl
lock_name_space                      string
log_file_name_convert                string
service_names                        string      orcl
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

d:\psu\p12429529_112010_MSWIN-x86-64\12429529>cd %ORACLE_HOME%\Bundle\Patch13

D:\app\Administrator\product\11.2.0\dbhome_1\Bundle\Patch13>dir catcpu.sql
 驱动器 D 中的卷是 新加卷
 卷的序列号是 70B9-9788

 D:\app\Administrator\product\11.2.0\dbhome_1\Bundle\Patch13 的目录

2010/04/28  00:10             2,604 catcpu.sql
               1 个文件          2,604 字节
               0 个目录 1,934,637,465,600 可用字节

D:\app\Administrator\product\11.2.0\dbhome_1\Bundle\Patch13>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 9月 26 15:39:43 2019

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

SQL> conn /as sysdba
已连接。
SQL> @catcpu.sql

省略输出10分钟。。。。

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\catbundle\catbundle_WINBUNDLE_ORC
L_APPLY_2019Sep26_15_40_37.log
SQL>
SQL> select * from dba_registry_history;

ACTION_TIME
---------------------------------------------------------------------------
ACTION                         NAMESPACE
------------------------------ ------------------------------
VERSION                                ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
26-9月 -19 03.48.47.214000 下午
APPLY                          SERVER
11.2.0.1                               13 WINBUNDLE
Patch 13

已选择 1 行。

SQL>

SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

D:\app\Administrator\product\11.2.0\dbhome_1\Bundle\Patch13>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 9月 26 15:50:32 2019

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

SQL> conn /as sysdba
已连接。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area 1.3696E+10 bytes
Fixed Size                  2188768 bytes
Variable Size            1.0737E+10 bytes
Database Buffers         2919235584 bytes
Redo Buffers               37044224 bytes
数据库装载完毕。
数据库已经打开。
SQL> select * from dba_registry_history;

ACTION_TIME
---------------------------------------------------------------------------
ACTION                         NAMESPACE
------------------------------ ------------------------------
VERSION                                ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
26-9月 -19 03.48.47.214000 下午
APPLY                          SERVER
11.2.0.1                               13 WINBUNDLE
Patch 13

SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

D:\app\Administrator\product\11.2.0\dbhome_1\Bundle\Patch13>D:\app\Administrator\product\1
1.2.0\dbhome_1\OPatch\opatch.bat lsinventory
Oracle 临时补丁程序安装程序版本 11.2.0.3.21
版权所有 (c) 2019, Oracle Corporation。保留所有权利。

Oracle 主目录       ：D:\app\Administrator\product\11.2.0\dbhome_1
主产品清单：C:\Program Files\Oracle\Inventory
   来自           ：
OPatch 版本    ：11.2.0.3.21
OUI 版本       ：11.2.0.1.0
日志文件位置：D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2019-0
9-26_15-51-37下午_1.log

Lsinventory Output file location : D:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollog
s\opatch\lsinv\lsinventory2019-09-26_15-51-37下午.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: WIN-PGN6S8OJN3H
ARU platform id: 233
ARU platform description:: Microsoft Windows (64-bit AMD)

已安装的顶级产品 (1):

Oracle Database 11g                                                  11.2.0.1.0
此 Oracle 主目录中已安装 1 个产品。

临时补丁程序 (1) :

Patch  12429529     : applied on Thu Sep 26 15:36:24 CST 2019
Unique Patch ID:  13854432
   Created on 17 Jun 2011, 02:07:52 hrs PST8PDT
   Bugs fixed:
     12429529, 9554332, 12363485, 10625485, 9268192, 9935787, 10205230
     12412745, 12393432, 12341758, 10130392, 11853331, 6055658, 11723722
     11735927, 11772687, 9902590, 9871302, 10132870, 7365514, 10422748
     10180190, 9825461, 11731176, 9368502, 9705984, 10302581, 10130633
     8331063, 10237271, 10082277, 10054513, 9695366, 8889137, 10383833
     11076894, 10220194, 10401327, 9042035, 10235640, 9564886, 10104492
     9302054, 10374238, 9613016, 10432045, 8772524, 10357603, 9243068, 9448277
     8672862, 9725141, 9328390, 9275876, 9033671, 10154951, 9890701, 9628444
     10352692, 10086495, 10155684, 10156303, 10157313, 10201938, 10220033
     10278864, 8332021, 8771916, 8800514, 8874588, 8946311, 9003145, 9115829
     9131242, 9240305, 9398685, 9469117, 9569029, 9751158, 8446618, 10245351
     10052141, 10116578, 10134677, 10140809, 10157402, 10172454, 7662438
     8397251, 8499180, 8522654, 9090269, 9234660, 9255996, 9395237, 9461782
     9668086, 9703463, 9736701, 9795214, 9823660, 9826065, 9866728, 9916260
     9972680, 9524640, 8841699, 10216200, 10225758, 10155838, 10030675
     10080167, 10132342, 6866145, 8790561, 8984021, 9096076, 9137871, 9193873
     9277263, 9303326, 9457109, 9457492, 9472669, 9539440, 9659614, 9845644
     9903704, 9920616, 9930649, 10100101, 8780369, 8866808, 8883722, 9004242
     9021724, 9028780, 9049725, 9058865, 9212844, 9243912, 9306119, 9350527
     9387574, 9399991, 9413827, 9488247, 9498108, 9500147, 9532911, 9544104
     9548269, 9578533, 9593656, 9594372, 9706490, 9721013, 9734300, 9746699
     9764806, 9770451, 9778018, 9799342, 9828495, 9881328, 9932143, 10080735
     9901433, 9966926, 8574851, 8790837, 8802195, 8863249, 8981681, 8993052
     9198871, 9217088, 9300021, 9369183, 9442189, 9500046, 9648040, 9657283
     9685694, 9772171, 9847494, 9793452, 9888298, 9135679, 9495697, 9081430
     6855031, 8793567, 9286015, 9442015, 9504322, 9535951, 8684595, 9663844
     9539556, 7452759, 9196440, 8893949, 9011590, 9382101, 9775337, 9083671
     9324531, 8654177, 8569325, 8686932, 9271344, 8434467, 6086930, 9024737
     9047975, 9056912, 9069046, 9336476, 9355794, 9495669, 8467123, 8663644
     8855396, 8886819, 8951812, 8467825, 9187546, 9102860, 9109487, 8546356
     9170308, 8725282, 9308296, 9406607, 8720802, 9711859, 9531984, 9482399
     9471411, 9390484, 9362218, 9320786, 9320130, 9302343, 9290526, 9231605
     8554900, 9490054, 9389304, 8783690, 9577583, 9736229, 9259407, 8602840
     9469133, 8682102, 9693101, 9898160, 9669478, 9736865, 7327630, 8268775
     8505803, 8544696, 8565708, 8633358, 8664189, 8702535, 8755082, 8771556
     8783301, 8790767, 8799099, 8803762, 8839301, 8856478, 8865718, 8872096
     8909984, 8974548, 8981059, 8991997, 9023338, 9032717, 9057443, 9119194
     9145181, 9147830, 9165206, 9170608, 9216806, 9219338, 9227662, 9255542
     9275072, 9321701, 9341448, 9363145, 9363384, 9391025, 9399090, 9467635
     9488887, 9637033, 9711600, 9713537, 9714832, 9719541, 9736836, 7028305
     7519406, 8330783, 8431487, 8477973, 8496830, 8581792, 8607693, 8643160
     8650719, 8717461, 8730312, 8774868, 8813536, 8815639, 8822531, 8822832
     8834425, 8875671, 8879707, 8891929, 8914054, 8918433, 9001453, 9002336
     9007859, 9010222, 9011088, 9015983, 9027691, 9035113, 9041943, 9050716
     9053676, 9054253, 9057754, 9067282, 9068088, 9093300, 9120088, 9145541
     9167285, 9189070, 9202351, 9271246, 9272086, 9294110, 9298307, 9316329
     9378712, 9395500, 9408883, 9467727, 9504129, 9561609, 9584383, 9657157
     9661684, 9489422, 9595786, 8405205, 8543770, 8856467, 8998066, 8897784
     9004697, 9007836, 9036013, 9037724, 9047110, 9318214, 8328200, 8570322
     8629716, 8761974, 8857211, 8885539, 9035438, 8971021, 8685327, 8707506
     8866903, 8771297, 8772028, 8796511

--------------------------------------------------------------------------------

OPatch succeeded.

D:\app\Administrator\product\11.2.0\dbhome_1\Bundle\Patch13>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 9月 26 15:55:12 2019

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

SQL> conn /as sysdba
已连接。
SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
       206

SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2019-09-26 15:56:16

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL 过程已成功完成。

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2019-09-26 15:56:53

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0

PL/SQL 过程已成功完成。

PL/SQL 过程已成功完成。

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

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

SQL> conn /as sysdba
已连接。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area 1.3696E+10 bytes
Fixed Size                  2188768 bytes
Variable Size            1.0737E+10 bytes
Database Buffers         2919235584 bytes
Redo Buffers               37044224 bytes
数据库装载完毕。
数据库已经打开。
SQL>