搜索 <book_title>...

NetBackup IT Analytics 安装和升级指南 (Linux)

Last Published: 2025-03-24

Product(s): NetBackup IT Analytics (11.6)

安装 Oracle 修补程序

以 root 用户身份，使用以下命令将 Oracle 数据库组合修补程序和 JDK 捆绑包修补程序文件从 /tmp 复制到 /opt/aptare/oracle 文件夹：
```
        mv p37262172_190000_Linux-x86-64.zip /opt/aptare/oracle
mv p37213431_190000_Linux-x86-64.zip /opt/aptare/oracle
      
```
导航到 /opt/aptare/oracle 文件夹并解压缩文件。
```
cd /opt/aptare/oracle
unzip p37262172_190000_Linux-x86-64.zip
```
上述命令将在 /opt/aptare/oracle 文件夹中创建名为“36866623”的文件夹。
unzip p37213431_190000_Linux-x86-64.zip
上述命令将在 /opt/aptare/oracle 中创建名为“36866578”的文件夹。
在解压缩过程中，如果看到以下消息，请按如下所示输入 y。
```
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
```
设置修补程序文件夹 37262172 和 37213431 的权限
```
chown -R aptare:dba 37262172
chown -R aptare:dba 37213431
```
注意:
如果之前安装过 Oracle 修补程序，请跳过以下步骤中的步骤 4 至步骤 10。

以 root 用户身份，将两个 jar 文件从 /tmp 复制到 /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib 文件夹。

mv xdb6.jar /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
mv xmlparserv2-sans-jaxp-services.jar 
/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib

更改 jar 文件和 perl 的权限

cd /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
chown -R aptare:dba xdb6.jar
chown -R aptare:dba xmlparserv2-sans-jaxp-services.jar
cd /opt/aptare/oracle
chown -R aptare:dba perl
chmod -R 775 perl

检查 /opt/ 下是否提供 oraInventory 文件夹。如果未提供该文件夹，则
```
cd /opt/aptare/upgrade
cp oraInventory.zip /opt/
unzip oraInventory
```
检查 /opt/oraInventory 文件夹的权限是否为 aptare:dba，否则请更改权限
```
cd /opt/
chown -R aptare:dba oraInventory
```
运行 su - aptare 命令。

运行以下命令以附加 Oracle 主目录

$ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/opt/aptare/oracle/oraInst.loc" -attachHome ORACLE_HOME="/opt/aptare/oracle" ORACLE_HOME_NAME="OraDB19c_home" INVENTORY_LOCATION="/opt/oraInventory"

注意:

如果已附加 Oracle 主目录，则会显示 Oracle Home already exists at this location. Select another location 消息。请忽略此消息。

如果出现 fuser 错误“缺少命令: fuser”，请按照以下步骤对 fuser 进行更改
```
cd /opt/aptare/oracle/bin/
touch fuser
chmod 755 fuser
```
如果从步骤 3 继续，请以 aptare 用户身份使用以下命令进行连接，否则请继续执行下一步。
su - aptare

设置 PATH。确保已设置所有路径，否则修补程序可能会失败。

export PATH=$PATH:/opt/aptare/oracle/OPatch
export PATH=$PATH:/usr/ccs/bin
PATH=$PATH:/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib

检查是否存在任何 OPatch 冲突。

此操作将检查数据库 RU 修补程序和 OJVM 修补程序是否存在冲突。

cd /opt/aptare/oracle/37262172
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
from              : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_13-48-23PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

如果未检测到冲突，请运行以下命令以从 /opt/aptare/oracle/37262172/37260974 文件夹应用数据库 RU 修补程序。

cd /opt/aptare/oracle/37262172/37260974
   
/opt/aptare/oracle/OPatch/opatch apply

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37260974
Do you want to proceed? [y|n]
y    
User Responded with: Y
All checks passed.
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch 37260974 to OH '/opt/aptare/oracle'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.util, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.assistants.acf, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.ic, 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...
Patching component oracle.jdk, 1.8.0.201.0...

Patch 37260974 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [37260974].

Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_13-59-13PM_1.log
OPatch succeeded.

注意:

忽略与修补程序的回滚相关的任何警告。未应用先前的 Oracle 安全修补程序时，将显示此消息。

运行以下命令以从 /opt/aptare/oracle/37262172/37102264 文件夹应用 OJVM 修补程序。

cd /opt/aptare/oracle/37262172/37102264 
    /opt/aptare/oracle/OPatch/opatch apply
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:37102264
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 = '/opt/aptare/oracle')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37102264' to OH '/opt/aptare/oracle'
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 37102264 successfully applied.
Sub-set patch [36414915] has become inactive due to the application of a super-set patch [36878697].
Refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-08-56PM_1.log
OPatch succeeded.

导航到 /opt/aptare/oracle/37213431 并检查 JDK 捆绑包修补程序是否存在任何 OPatch 冲突。

cd /opt/aptare/oracle/37213431
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
   from           : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-19-28PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

如果未检测到冲突，请执行以下命令以从 /opt/aptare/oracle/37213431 文件夹应用 JDK 修补程序。

cd /opt/aptare/oracle/37213431
   
/opt/aptare/oracle/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
   from           : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-20-58PM_1.log


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

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

All checks passed.
Backing up files...
Applying interim patch '37213431' to OH '/opt/aptare/oracle'

ApplySession: Optional component(s) [ oracle.jdk, 1.8.0.191.0 ], [ oracle.jdk, 1.8.0.391.11]
not present in the Oracle Home or a higher version is found.
Patching component oracle.jdk, 1.8.0.201.0...
Patch 36866578 successfully applied.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-20-58PM_1.log

OPatch succeeded.

忽略有关 JDK 不存在或存在更高版本的任何消息：“ApplySession: 可选组件 [ oracle.jdk, 1.8.0.191.0 ] 在 Oracle 主目录中不存在或发现更高版本。”

使用以下命令验证 OPatch 是否成功，这些命令将显示数据库、OJVM 和 JDK 捆绑包修补程序的 OPatch 应用结果：
```
/opt/aptare/oracle/OPatch/opatch lsinventory -detail
    .
    .
    .
OPatch succeeded.
```
使用以下命令连接到 SQL Plus：
-bash-4.2$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 7 14:23:49 2025
Version 19.26.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
以 sysdba 身份连接
SQL> connect / as sysdba
Connected to an idle instance.
启动数据库。
SQL> startup
ORACLE instance started.
:
:
Database mounted.
Database opened.
打开所有可插拔数据库。
SQL> alter pluggable database all open;
Pluggable database altered.
退出 SQL 提示符。
SQL> quit

运行 Datapatch，为安装的修补程序完成安装后 SQL 部署。

运行以下命令以将修补程序应用于可插拔数据库（这可能需要几分钟）

/opt/aptare/oracle/OPatch/datapatch -verbose

注意:

如果显示有关运行 utlrp.sql 的消息，如需重新进行验证，请运行该命令

SQL Patching tool version 19.26.0.0.0 Production on Fri Feb  7 14:26:04 2025
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_17246_2025_02_07_14_26_04/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 37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)):
  Binary registry: Installed
  PDB CDB$ROOT: Not installed
  PDB PDB$SEED: Not installed
  PDB SCDB: Not installed

Current state of release update SQL patches:
  Binary registry:
    19.26.0.0.0 Release_Update 250118124854: Installed
  PDB CDB$ROOT:
    No release update patches installed
  PDB PDB$SEED:
    No release update patches installed
  PDB SCDB:
    No release update patches installed

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED SCDB
    No interim patches need to be rolled back
    Patch 37260974 (Database Release Update : 19.26.0.0.250121 (37260974)):
      Apply from 19.1.0.0.0 Feature Release to 19.26.0.0.0 Release_Update 250118124854
    The following interim patches will be applied:
      37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))

Installing patches...
Patch installation complete.  Total patches installed: 6
Validating logfiles...
done
Patch 37260974 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_CDBROOT_2025Feb07_14_26_53.log (no errors)
Patch 37102264 apply (pdb CDB$ROOT): SUCCESS

  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_SCDBCNTR_CDBROOT_2025Feb07_14_26_53.log (no errors)
Patch 37260974 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_PDBSEED_2025Feb07_14_30_39.log (no errors)
Patch 37102264 apply (pdb PDB$SEED): SUCCESS

  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_SCDBCNTR_PDBSEED_2025Feb07_14_30_39.log (no errors)
Patch 37260974 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_SCDB_2025Feb07_14_30_39.log (no errors)
Patch 37102264 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/
37102264_apply_SCDBCNTR_SCDB_2025Feb07_14_30_39.log (no errors)

Automatic recompilation incomplete; run utlrp.sql to revalidate.
PDBs: PDB$SEED

SQL Patching tool complete 

-bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 17 13:09:16 2024
.
Version 19.24.0.0.0

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

Connected to:

Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

Version 19.24.0.0.0

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

检查 /opt/aptare/cfgtoollogs/sqlpatch/ 中的日志文件是否有错误。该日志文件名包括当前时间戳：
示例：
```
Log file for this invocation: 
/opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_20899_2024_10_26_01_55_09/sqlpatch_invocation.log
```
以 root 用户身份启动所有服务。
```
/opt/aptare/bin/aptare start
```