APTARE IT Analytics 安装和升级指南 (Linux)
安装 Oracle 修补程序
- 以 root 用户身份，使用以下命令将 Oracle 修补程序文件从
/tmp复制到/opt/aptare/oracle文件夹：mv p34133642_190000_Linux-x86-64.zip /opt/aptare/oracle - su – aptare
- 导航到
/opt/aptare/oracle文件夹并解压缩文件。cd /opt/aptare/oracle unzip p34133642_190000_Linux-x86-64.zip
上述命令将在
/opt/aptare/oracle文件夹中创建 34133642 文件夹在解压缩过程中，如果看到以下消息，请按如下所示输入 y。
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
- 设置 34133642 修补程序文件夹的权限
chown -R aptare:dba 34133642注意:
如果之前已安装 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 Home already exists at this location. Select another location 消息。请忽略此消息。
- 如果出现 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冲突。cd /opt/aptare/oracle/34133642 /opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
- 如果未检测到冲突，请执行以下命令以从
/opt/aptare/oracle/34133642文件夹应用修补程序。/opt/aptare/oracle/OPatch/opatch apply Verifying environment and performing prerequisite checks... OPatch continues with these patches: 34133642 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... Sub-set patch [33806152] has become inactive due to the application of a super-set patch [34133642]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2022-07-20_20-44-05PM_1.log OPatch succeeded.
- 使用以下命令验证
OPatch是否成功：/opt/aptare/oracle/OPatch/opatch lsinventory -detail - 使用以下命令连接到 SQL Plus：
-bash-4.2$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 20 20:55:30 2022
Version 19.16.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
- 运行 Datapatch，为安装的修补程序完成安装后 SQL 部署。
执行以下命令以将修补程序应用于可插拔数据库（这可能需要几分钟）
/opt/aptare/oracle/OPatch/datapatch -verbose Patch installation complete. Total patches installed: 3 Validating logfiles...done Patch 34133642 apply (pdb CDB$ROOT): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/ 34133642_apply_SCDBCNTR_CDBROOT_2022Jul20_20_58_00.log (no errors) Patch 34133642 apply (pdb PDB$SEED): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/ 34133642_apply_SCDBCNTR_PDBSEED_2022Jul20_20_59_00.log (no errors) Patch 34133642 apply (pdb SCDB): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/ 34133642_apply_SCDBCNTR_SCDB_2022Jul20_20_59_00.log (no errors) SQL Patching tool complete on Wed Jul 20 21:00:09 2022 - 检查
/opt/aptare/cfgtoollogs/sqlpatch/中的日志文件是否有错误。该日志文件名包括当前时间戳：示例：
/opt/aptare/cfgtoollogs/sqlpatch/ sqlpatch_17520_2022_07_20_20_57_17/sqlpatch_invocation.log
- 以 root 用户身份启动所有服务。
/opt/aptare/bin/aptare start