Linux 用 NetBackup IT Analytics インストールとアップグレードガイド

        mv p34773489_190000_Linux-x86-64.zip /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 を入力します。

        chown -R aptare:dba 34773489
      

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

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

cd /opt/aptare/upgrade
cp oraInventory.zip /opt/
unzip oraInventory

cd /opt/
chown -R aptare:dba oraInventory

$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 ホームがすでにこの場所に存在します。別の場所を選択してください (Oracle Home already exists at this location. Select another location)」というメッセージが表示されます。このメッセージは無視してください。

cd /opt/aptare/oracle/bin/
touch fuser
Chmod 755 fuser

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

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

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.

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.

cd /opt/aptare/oracle/34773489
/opt/aptare/oracle/OPatch/opatch lsinventory -detail

-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

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> quit

次のコマンドを実行して、プラガブルデータベースにパッチを適用します (これには数分かかる場合があります)。

/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/sqlpatch_

32228_2023_02_06_15_57_52/sqlpatch_invocation.log

/opt/aptare/bin/aptare start