OS 환경 : Oracle Linux 8.7 (64bit)
DB 환경 : Oracle Database 19.27.0.0
에러 : autoupgrade Download query 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
|
$ 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
|
$ java -jar autoupgrade.jar -config oracle19.cfg -patch -mode download
AutoUpgrade Patching 26.3.260401 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded
There were conditions found preventing AutoUpgrade Patching from successfully running
*Downloading files
Download query failed
*login-ext.identity.oraclecloud.com*
|
failed 메세지가 나면서 실패함
해결 방법 : dns 연결 정보 정상화
/etc/resolv.conf 파일 확인
|
1
2
3
4
|
$ vi /etc/resolv.conf
# Generated by NetworkManager
#nameserver 8.8.8.8
#nameserver 8.8.4.4
|
모든 nameserver가 주석처리 되어있음
주석 해제
|
1
2
3
4
|
$ vi /etc/resolv.conf
# Generated by NetworkManager
nameserver 8.8.8.8
nameserver 8.8.4.4
|
모든 nameserver를 주석 해제함
다시 패치 다운로드 실행(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
-----------------------------------
|
정상적으로 다운로드됨
원인 : dns 미설정으로 인한 통신 문제
dns가 설정되어있지않아 목적지인 login-ext.identity.oraclecloud.com을 못찾아 발생한 문제
참조 :
오라클 19c autoupgrade로 패치 다운로드 방법 ( https://positivemh.tistory.com/1370 )
Exception while loading the AutoUpgrade Patching keystore - CommonException [Loading auto-login keystore failed] ( https://positivemh.tistory.com/1371 )
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