搜索 <book_title>...

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

Last Published: 2024-09-18

Product(s): NetBackup IT Analytics (11.3)

安装 Oracle 修补程序

以 root 用户身份，使用以下命令将 Oracle 数据库组合修补程序和 JDK 捆绑包修补程序文件从 /tmp 复制到 /opt/aptare/oracle 文件夹：
```
        mv p36522340_190000_Linux-x86-64.zip /opt/aptare/oracle
mv p36538667_190000_Linux-x86-64.zip /opt/aptare/oracle
      
```
导航到 /opt/aptare/oracle 文件夹并解压缩文件。
```
cd /opt/aptare/oracle
unzip p36522340_190000_Linux-x86-64.zip
```
上述命令将在 /opt/aptare/oracle 文件夹中创建名为“36522340”的文件夹。
unzip p36538667_190000_Linux-x86-64.zip
上述命令将在 /opt/aptare/oracle 中创建名为“p36538667”的文件夹。
在解压缩过程中，如果看到以下消息，请按如下所示输入 y。
```
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
```
设置修补程序文件夹 36522340 和 36538667 的权限
```
chown -R aptare:dba 36522340
chown -R aptare:dba 36538667
```
注意:
如果之前安装过 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/36522340
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
```

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

cd /opt/aptare/oracle/36522340/36582781
   
/opt/aptare/oracle/OPatch/opatch apply

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:36582781
Do you want to proceed? [y|n]
y
Is the local system ready for patching? [y|n]
y
Backing up files...
Applying interim patch '36582781' to OH '/opt/aptare/oracle'
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.assistants.deconfig, 19.0.0.0.0...
Patch 36582781 successfully applied.
Sub-set patch [36233263] has become inactive due to the application of a super-set patch [36582781].
Sub-set patch [36195566] has become inactive due to the application of a super-set patch [36582781].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2024-07-17_02-13-01AM_1.log
OPatch succeeded.

注意:

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

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

cd /opt/aptare/oracle/36522340/36414915
    /opt/aptare/oracle/OPatch/opatch apply
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:36414915
Do you want to proceed? [y|n]
y
Is the local system ready for patching? [y|n]
y
Backing up files...
Applying interim patch '36414915' 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 36414915 successfully applied.
Sub-set patch [36199232] has become inactive due to the application of a super-set patch [36414915].
Refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2024-07-17_02-26-35AM_1.log
OPatch succeeded.

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

cd /opt/aptare/oracle/36538667
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

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

cd /opt/aptare/oracle/36538667
   
/opt/aptare/oracle/OPatch/opatch apply
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 36538667
Do you want to proceed? [y|n]
y

All checks passed.
Backing up files...
Applying interim patch '36538667' to OH

ApplySession: Optional component(s) [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.” .
Patching component oracle.jdk, 1.8.0.201.0...
Patch 36538667 successfully applied.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2024-07-17_02-50-23AM_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 Wed Jul 17 13:09:16 2024
Version 19.24.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 的消息，如需重新进行验证，请运行该命令

-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
Session altered.
:
:

Installing patches...
Patch installation complete.  Total patches installed: 9
Validating logfiles...done

Patch 36199232 rollback (pdb CDB$ROOT): SUCCESS
logfile: /opt/aptare/cfgtoollogs/sqlpatch/36199232/
25601966/36199232_rollback_SCDBCNTR_CDBROOT_2024Jul17_13_14_32.log (no errors)

Patch 36582781 apply (pdb CDB$ROOT): SUCCESS

logfile: /opt/aptare/cfgtoollogs/sqlpatch/36582781
/25751445/36582781_apply_SCDBCNTR_CDBROOT_2024Jul17_13_14_33.log (no errors)

Patch 36414915 apply (pdb CDB$ROOT): SUCCESS

logfile: /opt/aptare/cfgtoollogs/sqlpatch/36414915
/25700138/36414915_apply_SCDBCNTR_CDBROOT_2024Jul17_13_14_33.log (no errors)  

Patch 36199232 rollback (pdb PDB$SEED): SUCCESS

logfile: /opt/aptare/cfgtoollogs/sqlpatch/36199232
/25601966/36199232_rollback_SCDBCNTR_PDBSEED_2024Jul17_13_15_33.log (no errors)

Patch 36582781 apply (pdb PDB$SEED): SUCCESS

logfile: /opt/aptare/cfgtoollogs/sqlpatch/36582781
/25751445/36582781_apply_SCDBCNTR_PDBSEED_2024Jul17_13_15_34.log (no errors)

Patch 36414915 apply (pdb PDB$SEED): SUCCESS


logfile: /opt/aptare/cfgtoollogs/sqlpatch/36414915
/25700138/36414915_apply_SCDBCNTR_PDBSEED_2024Jul17_13_15_33.log (no errors)

Patch 36199232 rollback (pdb SCDB): SUCCESS

logfile: /opt/aptare/cfgtoollogs/sqlpatch/36199232
/25601966/36199232_rollback_SCDBCNTR_SCDB_2024Jul17_13_15_33.log (no errors)

Patch 36582781 apply (pdb SCDB): SUCCESS

logfile: /opt/aptare/cfgtoollogs/sqlpatch/36582781
/25751445/36582781_apply_SCDBCNTR_SCDB_2024Jul17_13_15_33.log (no errors)

Patch 36414915 apply (pdb SCDB): SUCCESS

logfile: /opt/aptare/cfgtoollogs/sqlpatch/36414915
/25700138/36414915_apply_SCDBCNTR_SCDB_2024Jul17_13_15_33.log (no errors)

SQL Patching tool complete on Wed Jul 17 13:16:33 2024

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