搜索 <book_title>...

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

Last Published: 2023-03-01

Product(s): NetBackup IT Analytics (11.0)

安装 Oracle 修补程序

以 root 用户身份，使用以下命令将 Oracle 修补程序文件从 /tmp 复制到 /opt/aptare/oracle 文件夹：
```
        mv p34773489_190000_Linux-x86-64.zip /opt/aptare/oracle
      
```
运行 su - aptare 命令
导航到 /opt/aptare/oracle 文件夹并解压缩文件。
```
cd /opt/aptare/oracle
unzip p34773489_190000_Linux-x86-64.zip
```
上述命令将在 /opt/aptare/oracle 文件夹中创建名为 34773489 的文件夹。
如果解压缩文件时显示以下消息，请在文件响应中输入 y。
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: 显示时，输入 y。
设置 34773489 修补程序文件夹的权限。
```
        chown -R aptare:dba 34773489
      
```
注意:
如果 Oracle 修补程序不是 Veritas 提供的，并且已安装 Oracle 修补程序，请跳过以下步骤 5 到 11。

以 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 主目录已存在于此位置。请选择其他位置”。请忽略此消息。

如果出现 fuser 错误“缺少命令: fuser”，请按照以下步骤对 fuser 进行更改。
```
cd /opt/aptare/oracle/bin/
touch fuser
Chmod 755 fuser
```

设置 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/34773489
/opt/aptare/oracle/OPatch/opatch prereq 
CheckConflictAgainstOHWithDetail -ph ./
```

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

cd /opt/aptare/oracle/34773489/34765931
/opt/aptare/oracle/OPatch/opatch apply

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   34765931

Do you want to proceed? [y|n]
y

Is the local system ready for patching? [y|n]
y

Patching component oracle.jdk, 1.8.0.201.0...

Patch 34765931 successfully applied.

Sub-set patch [34419443] has become inactive due to the application of a 
super-set patch [34765931].

Please refer to Doc ID 2161861.1 for any possible 
further required actions.

Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/
opatch2023-02-06_15-44-28PM_1.log

 OPatch completed with warnings.

注意:

如果该警告消息与修补程序 30565805 回滚有关，请忽略该警告消息。未应用先前的 Oracle 安全修补程序时，将显示此消息。

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

cd /opt/aptare/oracle/34773489/34786990
/opt/aptare/oracle/OPatch/opatch apply
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   34786990
Do you want to proceed? [y|n]
y
Is the local system ready for patching? [y|n]
y
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
.
.
Patch 34786990 successfully applied.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/
opatch2023-02-06_15-50-55PM_1.log
OPatch succeeded.

使用以下命令验证 OPatch 是否成功：
注意:
这些命令将显示数据库修补程序和 OJVM 修补程序的 OPatch 应用情况。
```
cd /opt/aptare/oracle/34773489
/opt/aptare/oracle/OPatch/opatch lsinventory -detail
```

使用下列命令连接到 sqlplus：

-bash-4.2$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 6 15:56:17 2023
Version 19.18.0.0.0
Copyright (c) 1982, 2022, 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
```

运行数据库修补程序，为已安装的修补程序完成安装后 SQL 部署。

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

/opt/aptare/oracle/OPatch/datapatch -verbose
Patch installation complete.  Total patches installed: 9

Validating logfiles...done
Patch 34411846 rollback (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846
/24917919/34411846_rollback_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log 
(no errors)

Patch 34765931 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931
/25098466/34765931_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log 
(no errors)

Patch 34786990 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990
/25032666/34786990_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log 
(no errors)

Patch 34411846 rollback (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846
/24917919/34411846_rollback_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log 
(no errors)

Patch 34765931 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931
/25098466/34765931_apply_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log 
(no errors)

Patch 34786990 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990
/25032666/34786990_apply_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log 
(no errors)

Patch 34411846 rollback (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846
/24917919/34411846_rollback_SCDBCNTR_SCDB_2023Feb06_15_58_56.log 
(no errors)

Patch 34765931 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931
/25098466/34765931_apply_SCDBCNTR_SCDB_2023Feb06_15_58_56.log 
(no errors)

Patch 34786990 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990
/25032666/34786990_apply_SCDBCNTR_SCDB_2023Feb06_15_58_56.log 
(no errors)
.
.
SQL Patching tool complete on Mon Feb  6 15:59:32 2023

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