はじめに
ひとつ前の記事で AutoUpgrade Patching のRU自動DL機能を試しましたが、それ以外の部分で内部的に何がいつどう動いているのか気になったので、簡単な仕掛けの出力ファイルと AutoUpgrade の Summary report, ログを見ながら掘り下げていきます。
ひとつ前の記事はこちら↓
「簡単な仕掛け」とその出力ファイル
DBに接続できればその時刻と接続したDBのバージョンをファイルに追記、DBに接続できなければその時刻と固定文字列 (fail) をファイルに追記します。(10秒ごとにループ)
verlog.sh
#!/bin/bash
# Database connection settings
DB_USER="piyo"
DB_PASS="password"
DB_CONN_STR="//localhost:1521/orclpdb1"
# Log file path
LOG_FILE="/home/oracle/verlog.txt"
while true; do
# Get the current date/time (for error logging)
current_date=$(date '+%Y-%m-%d %H:%M:%S')
# Run SQL*Plus to get DB version info and write to log
sqlplus -L -s "${DB_USER}/${DB_PASS}@${DB_CONN_STR}" <<EOF
WHENEVER SQLERROR EXIT 1
SET HEADING OFF
SPOOL $LOG_FILE APPEND
SELECT
TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') || ',' || version_full AS one_line
FROM
product_component_version;
EXIT
EOF
# If SQL*Plus returned an error, log the failure with timestamp
if [ $? -ne 0 ]; then
echo "${current_date},fail" >> "${LOG_FILE}"
fi
# Wait 10 seconds before next check
sleep 10
done
出力ファイルは下記のようになりました。(16:10から実行)
verlog.txt
(snip)
2025-06-30 16:58:07,19.3.0.0.0
2025-06-30 16:58:18,19.3.0.0.0
2025-06-30 16:58:29,19.3.0.0.0
2025-06-30 16:58:40,19.3.0.0.0
2025-06-30 16:58:51,19.3.0.0.0
2025-06-30 16:59:02,19.3.0.0.0
2025-06-30 16:59:13,19.3.0.0.0
2025-06-30 16:59:24,19.3.0.0.0
2025-06-30 16:59:35,19.3.0.0.0
2025-06-30 16:59:46,fail
2025-06-30 16:59:56,fail
2025-06-30 17:00:06,fail
2025-06-30 17:00:16,fail
2025-06-30 17:00:27,fail
2025-06-30 17:00:37,fail
2025-06-30 17:00:47,19.27.0.0.0
2025-06-30 17:00:58,19.27.0.0.0
2025-06-30 17:01:09,19.27.0.0.0
2025-06-30 17:01:20,19.27.0.0.0
2025-06-30 17:01:31,19.27.0.0.0
2025-06-30 17:01:43,19.27.0.0.0
2025-06-30 17:01:54,19.27.0.0.0
2025-06-30 17:02:05,19.27.0.0.0
2025-06-30 17:02:16,19.27.0.0.0
2025-06-30 17:02:27,19.27.0.0.0
2025-06-30 17:02:38,19.27.0.0.0
2025-06-30 17:02:49,19.27.0.0.0
(snip)
参考：標準出力
(snip)
2025-06-30 16:59:02,19.3.0.0.0
2025-06-30 16:59:13,19.3.0.0.0
2025-06-30 16:59:24,19.3.0.0.0
2025-06-30 16:59:35,19.3.0.0.0
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
2025-06-30 17:00:47,19.27.0.0.0
2025-06-30 17:00:58,19.27.0.0.0
2025-06-30 17:01:09,19.27.0.0.0
2025-06-30 17:01:20,19.27.0.0.0
2025-06-30 17:01:31,19.27.0.0.0
2025-06-30 17:01:43,19.27.0.0.0
2025-06-30 17:01:54,19.27.0.0.0
(snip)
AutoUpgrade Patching の Summary report とログ
Summary report は下記のようになりました。(16:15から実行)
AutoUpgrade の各ステージの開始時刻・所要時間がわかったので、前述の仕掛けの出力ファイルと時系列を揃えて図にすると下記のようになります。
DB_PATCHINGステージで一時的に接続できなくなったこと、接続できなかったのは一分程度であることがわかります。また、特に切り替え操作などを行わなくても、新しいRUが適用されたDBに接続していたこともわかります。
ここからは、ステージごとに何が動いているか確認していきます。
(DB_PATCHINGステージが気になる方は、右のリストからジャンプしてください)
PRECHECKS
マニュアルの説明は下記の通り。(本記事作成時点では、日本語マニュアルは最新の AutoUpgrade に追いついていないようだったので、英語マニュアルを参照しています)
Runs the patching prechecks.
(翻訳) パッチ適用の事前チェックを実行します。
Summary report の Detail に Checks Report とあるので見てみます。
長いので折り畳み
opatch prereq CheckConflictAgainstOHWithDetailを実行しているだけかと思いきや、他にもいろいろとチェックしてそうです。
ログを Running check でフィルタすると下記のようになりました。(★は引っかかった項目)
prechecks_cdb_root.log (filter: Running check)
2025-06-30 16:19:21.531 INFO Running check ★DICTIONARY_STATS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.532 INFO Running check CTX_SHADOW_INDEX [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.532 INFO Running check INVALID_OBJECTS_EXIST [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.533 INFO Running check DICTIONARY_HEALTH [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.533 INFO Running check ★INVALID_ORA_OBJ_INFO [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.531 INFO Running check ★COMPONENT_INFO [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.533 INFO Running check DV_ENABLED [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.533 INFO Running check ARCHIVE_MODE_ON [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.535 INFO Running check MAX_EXTENTS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.535 INFO Running check JVM_MITIGATION_PATCH [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.535 INFO Running check NEW_TIME_ZONES_EXIST [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.535 INFO Running check MIN_RECOVERY_AREA_SIZE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.535 INFO Running check MIN_ARCHIVE_DEST_SIZE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.536 INFO Running check OLD_TIME_ZONES_EXIST [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.537 INFO Running check ORACLE_HOME_KEYSTORE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.537 INFO Running check PENDING_DST_SESSION [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.538 INFO Running check POST_JVM_MITIGAT_PATCH [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:21.538 INFO Running check ★POST_DICTIONARY [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.565 INFO Running check ★PRE_FIXED_OBJECTS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.565 INFO Running check ROLLBACK_SEGMENTS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.566 INFO Running check TABLESPACES [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.566 INFO Running check ★TABLESPACES_INFO [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.567 INFO Running check TEMPTS_ALLOFFLINE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.576 INFO Running check TEMPTS_NOTEMPFILE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.576 INFO Running check TS_FORUPG_STATUS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.588 INFO Running check CREATE_WINDOWS_SERVICE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.588 INFO Running check ★DATAPATCH_TIMEOUT_SETTINGS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.593 INFO Running check DEPLOY_JOB_VALIDATIONS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.594 INFO Running check DISK_SPACE_FOR_RECOVERY_AREA [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.594 INFO Running check FLASH_RECOVERY_AREA_SETUP [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.595 INFO Running check GATEWAY_SID_NAME_CONFLICT [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:22.607 INFO Running check INFORM_DROP_GRP [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.594 INFO Running check ISRAC_SWITCHEDON_TARGETHOME [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.594 INFO Running check MANDATORY_UPGRADE_CHANGES [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.594 INFO Running check NO_KEYSTORE_FILES [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.594 INFO Running check OS_AUTHENTICATION [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.594 INFO Running check ★POST_RECOMPILE_IN_CDB [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.594 INFO Running check ★POST_RECOMPILE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.597 INFO Running check STANDARD_EDITION [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.597 INFO Running check TARGET_GATEWAY_INSTALLED [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.599 INFO Running check TARGET_HOME_REGISTERED_INVENTORY [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.600 INFO Running check TDE_PASSWORDS_REQUIRED [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.600 INFO Running check UTLRP_RUN_SERIAL [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.600 INFO Running check AP_OPATCH_PREREQ [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.601 INFO Running check AP_DISK_SPACE_FOR_PATCHING [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.602 INFO Running check ★AP_PATCHES_INFORMATION [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.603 INFO Running check SC_BACKUP_JOBS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.614 INFO Running check SC_CENTRAL_INVENTORY [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.621 INFO Running check SC_DATAPUMP_RUNNING [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:23.634 INFO Running check SC_GG_LOGMINER_TRIGGERS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:24.623 INFO Running check SC_GG_INTEGRATED_ER [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:24.628 INFO Running check SC_GUARDIUM [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:24.646 INFO Running check SC_IMPERVA [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:24.661 INFO Running check SC_LOCALE [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:24.668 INFO Running check SC_OPTIM_UPGRADE_PARAM [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:24.680 INFO Running check SC_QI_CHECKS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:24.683 INFO Running check SC_SCHEDULE_JOBS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:25.648 INFO Running check SC_STATS_GATHERING [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:25.656 INFO Running check SC_SYS_PUBLIC_GRANTS [CDB$ROOT] - CheckTrigger.call#109
2025-06-30 16:19:25.696 INFO Running check ★UPDATE_SYS_DIRECTORIES [CDB$ROOT] - CheckTrigger.call#109
PREFIXUPS
マニュアルの説明は下記の通り。
Runs the fixups for any failing prechecks that have an automated fixup.
(翻訳) 自動修正がある失敗した事前チェックの修正を実行します。
Summary report の Detail に Fixup Report とあるので見てみます。
CDB\$ROOT では7つのチェックのうち3つが、PDB$SEED/ORCLPDB1 では9つのチェックのうち2つが自動修正されていました。
EXTRACT
マニュアルの説明は下記の通り。
Extracts the base image that will be used to create the new target Oracle home.
(翻訳) 新しいターゲット Oracle ホームの作成に使用されるベース イメージを抽出します。
ログを見ると、構成ファイルでfolderに指定したディレクトリに格納したベースイメージを unzip していました。
extract_baseimage.log
2025-06-30 16:33:57.846 INFO Starting - ExtractZipFiles.unzipGoldImage#95
2025-06-30 16:33:57.847 INFO No backup copy of /home/oracle/autoupg_wk/glogdir/ORCLCDB/100/extract/extract_baseimage.log was created - Utilities.backupFile#1185
2025-06-30 16:33:57.859 INFO The file /home/oracle/autoupg_wk/patches/LINUX.X64_193000_db_home.zip is being extracted to /opt/oracle/product/19c/dbhome_2 - ExtractZipFiles.unzipGoldImage#117
2025-06-30 16:33:57.860 INFO [3D1B09] Starting - ExecuteProcess.doCmds#859
2025-06-30 16:33:57.860 INFO [3D1B09] BeginOracle Home=/opt/oracle/product/19c/dbhome_2 Oracle Sid=ORCLCDB Run command =[/usr/bin/unzip, -o, /home/oracle/autoupg_wk/patches/LINUX.X64_193000_db_home.zip, -d, /opt/oracle/product/19c/dbhome_2] Command=None Filename=/home/oracle/autoupg_wk/glogdir/ORCLCDB/100/extract/extract_baseimage.log - ExecuteProcess.doCmds#860
(snip)
DBTOOLS
マニュアルの説明は下記の通り。
Installs a newer version of OPatch into the target Oracle home, if necessary.
(翻訳) 必要に応じて、新しいバージョンの OPatch をターゲットの Oracle ホームにインストールします。
ログを見ると、最新のRUと一緒に自動DLされた最新の opatch を unzip していました。
opatch_unzip.log
2025-06-30 16:37:11.874 INFO No backup copy of /home/oracle/autoupg_wk/glogdir/ORCLCDB/100/dbtools/opatch_unzip.log was created - Utilities.backupFile#1185
2025-06-30 16:37:11.874 INFO The file /home/oracle/autoupg_wk/patches/p6880880_190000_Linux-x86-64.zip is being extracted to /opt/oracle/product/19c/dbhome_2 - DBTools.extractOPatch#111
2025-06-30 16:37:11.875 INFO [F72FE0] Starting - ExecuteProcess.doCmds#859
2025-06-30 16:37:11.875 INFO [F72FE0] BeginOracle Home=/opt/oracle/product/19c/dbhome_2 Oracle Sid=ORCLCDB Run command =[/usr/bin/unzip, -o, /home/oracle/autoupg_wk/patches/p6880880_190000_Linux-x86-64.zip, -d, /opt/oracle/product/19c/dbhome_2] Command=None Filename=/home/oracle/autoupg_wk/glogdir/ORCLCDB/100/dbtools/opatch_unzip.log - ExecuteProcess.doCmds#860
(snip)
INSTALL
マニュアルの説明は下記の通り。
Installs the new target Oracle home by running runInstaller in silent mode.
(翻訳) サイレント モードで runInstaller を実行して、新しいターゲット Oracle ホームをインストールします。
ログを見ると、説明通りの内容で runInstaller を実行していました。
install.log
2025-06-30 16:37:19.220 INFO Waiting to acquire lock - RunInstaller.executePatchStage#83
2025-06-30 16:37:19.235 INFO Installing ORACLE_HOME - RunInstaller.runInstaller#91
2025-06-30 16:37:19.235 INFO The new ORACLE_HOME will be created in /opt/oracle/product/19c/dbhome_2 and will have the following edition: Enterprise Edition - RunInstaller.runInstaller#95
2025-06-30 16:37:19.236 INFO No backup copy of /home/oracle/autoupg_wk/glogdir/ORCLCDB/100/install/runinstaller.log was created - Utilities.backupFile#1185
2025-06-30 16:37:19.236 INFO Running runInstaller in the target ORACLE_HOME /opt/oracle/product/19c/dbhome_2 - RunInstaller.runInstaller#152
2025-06-30 16:37:19.237 INFO [1B3EC9] Starting - ExecuteProcess.doCmds#859
2025-06-30 16:37:19.237 INFO [1B3EC9] BeginOracle Home=/opt/oracle/product/19c/dbhome_2 Oracle Sid=ORCLCDB Run command =[/opt/oracle/product/19c/dbhome_2/runInstaller, -silent, ORACLE_HOME=/opt/oracle/product/19c/dbhome_2, ORACLE_BASE=/opt/oracle, oracle.install.option=INSTALL_DB_SWONLY, oracle.install.db.InstallEdition=EE, INVENTORY_LOCATION=/opt/oracle/oraInventory, UNIX_GROUP_NAME=oinstall, oracle.install.db.DBA_GROUP=dba, oracle.install.db.OPER_GROUP=oper, oracle.install.db.OSBACKUPDBA_GROUP=backupdba, oracle.install.db.OSDGDBA_GROUP=dgdba, oracle.install.db.OSKMDBA_GROUP=kmdba, oracle.install.db.OSRACDBA_GROUP=racdba] Command=None Filename=/home/oracle/autoupg_wk/glogdir/ORCLCDB/100/install/runinstaller.log - ExecuteProcess.doCmds#860
(snip)
OH_PATCHING
マニュアルの説明は下記の通り。
Installs each of the necessary patches into the Oracle home.
(翻訳) 必要な各パッチを Oracle ホームにインストールします。
ログを見ると、自動DLした最新のRU (37642901), DATAPUMP BUNDLE PATCH (37777295), OJVM RU (37499406) を dbhome_2 のバイナリに適用していました。
install_patch_37642901.log
Oracle Home : /opt/oracle/product/19c/dbhome_2
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/19c/dbhome_2/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.2.0.7.0
Log file location : /home/oracle/autoupg_wk/glogdir/ORCLCDB/100/opatch/opatch2025-06-30_16-38-34PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37642901
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
(snip)
install_patch_37777295.log
Oracle Home : /opt/oracle/product/19c/dbhome_2
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/19c/dbhome_2/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.2.0.7.0
Log file location : /home/oracle/autoupg_wk/glogdir/ORCLCDB/100/opatch/opatch2025-06-30_16-53-31PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37777295
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
(snip)
install_patch_37499406.log
Oracle Home : /opt/oracle/product/19c/dbhome_2
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/product/19c/dbhome_2/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.2.0.7.0
Log file location : /home/oracle/autoupg_wk/glogdir/ORCLCDB/100/opatch/opatch2025-06-30_16-54-10PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37499406
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
(snip)
DB_PATCHING ★
さて、本命 (？) の DB_PATCHINGステージです。
マニュアルの説明は下記の通り。
Runs a second copy of AutoUpgrade without the -patch option to move the database from the source Oracle home to the target Oracle home.
(翻訳) -patch オプションなしで AutoUpgrade の 2 番目のコピーを実行し、データベースをソース Oracle ホームからターゲット Oracle ホームに移動します。
DB_PATCHINGステージにはさらにステージが存在します。(ややこしい)
ここでは、DBに一時的に接続できなくなった DRAIN, DBUPGRADEステージに注目します。
DRAIN
DRAINステージには BackupSpfile といった9つのステップが存在します。
progress.json
{
"stage": "DRAIN",
"percentCompleted": "100",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 17:00:22",
"events": [
{
"Name": "BackupSpFile",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 16:59:36"
},
{
"Name": "TextFileList",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 16:59:38"
},
{
"Name": "SaveDBState",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 16:59:41"
},
{
"Name": "DrainCreateFinalSpfile",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 17:00:19"
},
{
"Name": "RACConfigForUpgrade",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 17:00:19"
},
{
"Name": "WalletCopy",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 17:00:19"
},
{
"Name": "PasswordFileCopy",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 17:00:19"
},
{
"Name": "PosixWork",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 17:00:22"
},
{
"Name": "DrainSystemUpdates",
"value": "FINISHED",
"additionalInfo": "",
"lastUpdateTime": "2025-06-30 17:00:22"
}
]
}
ログを見ると、各種設定ファイルを dbhome_1 から dbhome_2 にコピーしていることがわかります。
drain_orclcdb.log
(snip)
2025-06-30 17:00:19.641 INFO Executing drain step WalletCopy - AutoUpgDrainActions.runDrainActions#307
2025-06-30 17:00:19.645 INFO Starting - Wallet.modifySqlNetLocally#169
2025-06-30 17:00:19.645 INFO The possible sqlnet.ora directory for [/opt/oracle/product/19c/dbhome_1] is [/opt/oracle/product/19c/dbhome_1/network/admin] - Wallet.init#127
2025-06-30 17:00:19.645 INFO The possible sqlnet.ora directory for [/opt/oracle/product/19c/dbhome_2] is [/opt/oracle/product/19c/dbhome_2/network/admin] - Wallet.init#127
2025-06-30 17:00:19.647 INFO Starting - LocalFilesValidator.continueExecution#58
2025-06-30 17:00:19.647 INFO End - LocalFilesValidator.continueExecution#104
2025-06-30 17:00:19.647 INFO Starting - LocalTerraformer.continueExecution#52
2025-06-30 17:00:19.648 INFO Copy file /home/oracle/autoupg_wk/glogdir/ORCLCDB/100/db_patching/ORCLCDB/temp/ORCLCDB_src_sqlnet.ora to /opt/oracle/product/19c/dbhome_1/network/admin/sqlnet.ora, replace /opt/oracle/product/19c/dbhome_1/network/admin/sqlnet.ora if it already exists - PostUtils.copyReplaceFileAttributes#52
2025-06-30 17:00:19.649 INFO Copy/replace succeeds - PostUtils.copyReplaceFileAttributes#54
(snip)
DBUPGRADE
ログを見ると、DBUPGRADE では datapatch が実行されていることがわかります。
(snip)
2025-06-30 17:01:49.831 INFO ==========================================
Current AutoUpgrade Status
==========================================
[Date] Mon Jun 30 17:01:49 JST 2025
[Operating System] Linux
[Number of Jobs] 1
==========================================
[Job ID] 100
==========================================
[DB Name] ORCLCDB
[Stage] DBUPGRADE
[Operation] EXECUTING
[Status] RUNNING
[Details] [Patching] is [0%] completed for [orclcdb-cdb$root]
+---------+--------------+
|CONTAINER| PERCENTAGE|
+---------+--------------+
| CDB$ROOT|DATAPATCH [0%]|
| PDB$SEED| PATCH PENDING|
| ORCLPDB1| PATCH PENDING|
+---------+--------------+
------------------------------------------
(snip)
2025-06-30 17:34:48.162 INFO ==========================================
Current AutoUpgrade Status
==========================================
[Date] Mon Jun 30 17:34:48 JST 2025
[Operating System] Linux
[Number of Jobs] 1
==========================================
[Job ID] 100
==========================================
[DB Name] ORCLCDB
[Stage] DBUPGRADE
[Operation] EXECUTING
[Status] RUNNING
[Details] [Patching] is [100%] completed for [orclcdb-pdb$seed]
+---------+---------------------------------------+
|CONTAINER| PERCENTAGE|
+---------+---------------------------------------+
| CDB$ROOT|SUCCESSFULLY PATCHED [orclcdb-cdb$root]|
| PDB$SEED|SUCCESSFULLY PATCHED [orclcdb-pdb$seed]|
| ORCLPDB1|SUCCESSFULLY PATCHED [orclcdb-orclpdb1]|
+---------+---------------------------------------+
------------------------------------------
POSTCHECKS
マニュアルの説明は下記の通り。
Runs the patching postchecks.
(翻訳) パッチ適用後のチェックを実行します。
Summary report の Detail に Checks Report とあるので見てみます。
ログを見てみると下記のようなチェック項目がありました。(★は引っかかった項目)
PRECHECKS と比べると項目数は少ないです。
postchecks.log
(snip)
2025-06-30 17:36:42.114 INFO Check[OLD_TIME_ZONES_EXIST] Container[CDB$ROOT] - ChecksExecutor.execute#112
2025-06-30 17:36:42.114 INFO Check★[POST_DICTIONARY] Container[CDB$ROOT] - ChecksExecutor.execute#112
2025-06-30 17:36:42.117 INFO Check[POST_JVM_MITIGAT_PATCH] Container[CDB$ROOT] - ChecksExecutor.execute#112
2025-06-30 17:36:42.120 INFO Check[CREATE_WINDOWS_SERVICE] Container[CDB$ROOT] - ChecksExecutor.execute#112
2025-06-30 17:36:42.122 INFO Check[INFORM_DROP_GRP] Container[CDB$ROOT] - ChecksExecutor.execute#112
2025-06-30 17:36:42.127 INFO Check[POST_RECOMPILE_IN_CDB] Container[CDB$ROOT] - ChecksExecutor.execute#112
2025-06-30 17:36:42.129 INFO Check[POST_RECOMPILE] Container[CDB$ROOT] - ChecksExecutor.execute#112
2025-06-30 17:36:42.129 INFO Check[UPDATE_SYS_DIRECTORIES] Container[CDB$ROOT] - ChecksExecutor.execute#112
(snip)
POSTFIXUPS
マニュアルの説明は下記の通り。
Runs the fixups for any failing postchecks that have an automated fixup.
(翻訳) 自動修正がある失敗したポストチェックの修正を実行します。
Summary report の Detail に Fixup Report とあるので見てみます。
引っかかったすべてのチェックが自動修正されていました。