一次打11.2.0.3 BP的糟糕经历

报错1：

[Aug 4, 2020 12:07:38 AM] [INFO] Running prerequisite checks...

[Aug 4, 2020 12:07:38 AM] [SEVERE] OUI-67073:UtilSession failed: Trailing char < > at index 51: E:\PATCH\22085001\files\rdbms\admin\catmacpatch.sql

[Aug 4, 2020 12:07:38 AM] [INFO] Finishing UtilSession at Tue Aug 04 00:07:38 CST 2020

[Aug 4, 2020 12:07:38 AM] [INFO] Log file location: E:\oracle\app\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2020-08-04_00-07-33AM_1.log

[Aug 4, 2020 12:07:38 AM] [INFO] Stack Description: java.lang.RuntimeException: Trailing char < > at index 51: E:\PATCH\22085001\files\rdbms\admin\catmacpatch.sql

数据库打补丁的时候出现如上报错，检查mos发现原因是因为补丁目录中的catmacpatch.sql 文件里面有空格

格式如下： 

<copy name="catmacpatch.sql " path="%ORACLE_HOME%/rdbms/admin" file_name="rdbms/admin/catmacpatch.sql "/>

解决办法： 去掉空格即可

相关mos文档：

Patch 22085001 failed with OUI-67073:UtilSession failed: Trailing char < > at index 51: E:\PATCH\22085001\files\rdbms\admin\catmacpatch.sql (Doc ID 2701490.1)

报错2：

2024-7-26 22:54:26] [INFO]         Following active files/executables/libs are used by ORACLE_HOME :D:\app\ADMINI~1\product\112~1.0\dbhome_1

                                    D:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oracommon11.dll

                                    D:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraclient11.dll

                                    D:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orageneric11.dll

                                    D:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orapls11.dll

.....

报错有部分文件是被别的软件用着，检查发现oracle相关的进程都已经被关闭了。

检查的两个方法：

1 通过性能查看器，cpu列查看文件句柄  --》这次没有发现

2 通过tasklist 查看

C:\soft\25632525>tasklist /M ora* --》查不出来

C:\soft\25632525>tasklist /M oci.dll 

映像名称                       PID 模块

========================= ======== ========

dllhost.exe                   2476 oci.dll

msdtc.exe                     1864 oci.dll

w3wp.exe                      3544 oci.dll

强制中止这个进程

C:\soft\25632525>taskkill /F /im omtsreco.exe

成功: 已终止进程 "omtsreco.exe"，其 PID 为 3724。

Patch 22085001 failed with OUI-67073:UtilSession failed: Trailing char < > at index 51: E:\PATCH\22085001\files\rdbms\admin\catmacpatch.sql (Doc ID 2701490.1)

mos内容：

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]

Microsoft Windows x64 (64-bit)

SYMPTOMS

Opatch apply of patch 22085001 failed with below error.

[Aug 4, 2020 12:07:38 AM] [INFO] Running prerequisite checks...

[Aug 4, 2020 12:07:38 AM] [SEVERE] OUI-67073:UtilSession failed: Trailing char < > at index 51: E:\PATCH\22085001\files\rdbms\admin\catmacpatch.sql

[Aug 4, 2020 12:07:38 AM] [INFO] Finishing UtilSession at Tue Aug 04 00:07:38 CST 2020

[Aug 4, 2020 12:07:38 AM] [INFO] Log file location: E:\oracle\app\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch2020-08-04_00-07-33AM_1.log

[Aug 4, 2020 12:07:38 AM] [INFO] Stack Description: java.lang.RuntimeException: Trailing char < > at index 51: E:\PATCH\22085001\files\rdbms\admin\catmacpatch.sql

CHANGES

 Apply Patch 22085001

CAUSE

 Extra space in file <Patch_lOCATION>\p22085001_112030_MSWIN-x86-64\22085001\etc\config\actions.xml

<copy name="catmacpatch.sql " path="%ORACLE_HOME%/rdbms/admin" file_name="rdbms/admin/catmacpatch.sql "/>

SOLUTION

Take backup of the file \tmp\p22085001_112030_MSWIN-x86-64\22085001\etc\config\actions.xml  === In this \tmp is the patch Download Location.

vi \tmp\p22085001_112030_MSWIN-x86-64\22085001\etc\config\actions.xml

Search for catmacpatch.sql

<copy name="catmacpatch.sql " path="%ORACLE_HOME%/rdbms/admin" file_name="rdbms/admin/catmacpatch.sql "/>

Remove the  "Extra space" in "catmacpatch.sql " before double quotes.