Exception while loading the AutoUpgrade Patching keystore - CommonException [Loading auto-login keystore failed]

OS 환경 : Oracle Linux 8.7 (64bit)

 

DB 환경 : Oracle Database 19.27.0.0

 

에러 : Exception while loading the AutoUpgrade Patching keystore - CommonException [Loading auto-login keystore failed]

autoupgrade를 이용해 패치를 다운로드 하려할 때 발생한 에러

 

 

AutoUpgrade 설정 파일(Config) 생성

1 2 3 4 5 6 7 8

$ cd /home/oracle/autoupg $ vi oracle.cfg global.global_log_dir=/home/oracle/autoupg/logs global.keystore=/home/oracle/autoupg/keystore patch1.patch=RECOMMENDED patch1.folder=/oraimsi/media patch1.target_version=19 patch1.download=yes

 

 

MOS 자격 증명 로드(Keystore 생성)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

$ java -jar ./autoupgrade.jar -config ./oracle.cfg -patch -load_password Processing config file ...   Starting AutoUpgrade Patching Password Loader - Type help for available options Creating new AutoUpgrade Patching keystore - Password required Enter password: Enter password again: AutoUpgrade Patching keystore was successfully created   MOS> add -user test@mos_account.com Enter your secret/Password: Re-enter your secret/Password: MOS> list My Oracle Support (MOS) - Credentials Loaded - Connection Successful   Oracle Update Advisor service - No CSI loaded MOS> save Convert the AutoUpgrade Patching keystore to auto-login [YES|NO] ? YES Irrecoverable error while running the AutoUpgrade Patching Password Loader - CommonException [Saving keystore failed]

save시에도 에러 발생함

 

 

이후 download 시도시

1 2 3 4 5

$ java -jar autoupgrade.jar -config oracle.cfg -patch -mode download AutoUpgrade Patching 26.3.260401 launched with default internal options Processing config file ... Loading AutoUpgrade Patching keystore Exception while loading the AutoUpgrade Patching keystore - CommonException [Loading auto-login keystore failed]

Exception while loading~ 에러 발생함

 

 

해결 방법 : keystore 제거 후 auto-login은 NO로 설정

keystore 제거

1	$ rm -rf /home/oracle/autoupg/keystore/

 

 

MOS 자격 증명 재로드(Keystore 생성)

1 2 3 4 5 6 7 8 9 10

$ java -jar ./autoupgrade.jar -config ./oracle.cfg -patch -load_password Processing config file ...   Starting AutoUpgrade Patching Password Loader - Type help for available options Creating new AutoUpgrade Patching keystore - Password required Enter password:    PKI-01002: Invalid password. Passwords must have a minimum length of eight characters and contain alphabetic characters combined with numbers or special characters.  Enter password:   <-- Keystore용 패스워드 지정 Enter password again:   <-- Keystore용 패스워드 재입력 AutoUpgrade Patching keystore was successfully created

본문에서는 임시로 Dhfkzmf1! 입력함

 

 

MOS 계정명/패스워드 입력

1 2 3 4 5 6 7 8

MOS> add -user test@mos_account.com Enter your secret/Password:   <-- MOS 패스워드 입력 Re-enter your secret/Password:   <-- MOS 패스워드 재입력 MOS> exit Save the AutoUpgrade Patching keystore before exiting [YES|NO] ? YES  <<--키를 저장할지 묻는 옵션 YES 입력 Convert the AutoUpgrade Patching keystore to auto-login [YES|NO] ? NO  <<-- Patch 다운로드시 Auto-login 묻는 옵션 NO 입력   AutoUpgrade Patching Password Loader finished - Exiting AutoUpgrade Patching

 

 

다시 패치 다운로드 실행(download 옵션 사용)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

$ java -jar autoupgrade.jar -config oracle.cfg -patch -mode download AutoUpgrade Patching 26.3.260401 launched with default internal options Processing config file ... Loading AutoUpgrade Patching keystore Enter wallet password:  <<-- Keystore용 패스워드 입력 AutoUpgrade Patching keystore is loaded   Connected to MOS - Searching for specified patches   ----------------------------------- Downloading files to /oraimsi/media ----------------------------------- DATABASE RELEASE UPDATE 19.31.0.0.0     File: p39034528_190000_Linux-x86-64.zip - VALIDATED   OPatch 12.2.0.1.51 for DB 19.0.0.0.0 (Apr 2026)     File: p6880880_190000_Linux-x86-64.zip - VALIDATED   DATAPUMP BUNDLE PATCH 19.31.0.0.0     File: p39196236_1931000DBRU_Generic.zip - VALIDATED   OJVM RELEASE UPDATE 19.31.0.0.0     File: p38906621_190000_Linux-x86-64.zip - VALIDATED   autoupgrade.jar 26.3 (April 2026)     File: autoupgrade.jar - VALIDATED -----------------------------------

정상적으로 다운로드됨

 

 

원인 : 원인 불명

원인 불명

 

참조 : 

오라클 19c autoupgrade로 패치 다운로드 방법 ( https://positivemh.tistory.com/1370 )

autoupgrade Download query failed ( https://positivemh.tistory.com/1372 )

Autoupgrade : How to download patches with Autoupgrade ?(KB790461)
AutoUpgrade Tool(KB123450)
Autoupgrade : How to install Oracle Home using Autoupgrade ?(KB753244)
https://dohdatabase.com/2024/10/30/how-to-patch-oracle-database-with-one-command/
https://oracle-base.com/articles/misc/autoupgrade-download-and-install-oracle-database-software
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/autoupgrade-patching.html#GUID-291AF989-ACB9-42CE-8FC5-617A70D57A4E
https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/autoupgrade-patching.html#GUID-B4169A36-FA3F-430E-B5FE-E72082D0B6AD
https://docs.oracle.com/en/database/oracle/oracle-database/26/upgrd/autoupgrade-patching.html#GUID-B4169A36-FA3F-430E-B5FE-E72082D0B6AD