복사되었습니다!
OS 환경 : Oracle Linux 8.7 (64bit)
DB 환경 : Oracle AI Database 23.26.2.0.0 ai
방법 : 오라클 26ai Autoupgrade를 이용해 엔진 설치 방법
autoupgrade 툴을 이용하면 업그레이드 및 패치파일을 다운로드 받을수도 있지만 엔진을 설치할 수도 있음
본문에서는 autoupgrade를 이용해 db 엔진을 설치하는 방법을 설명함
참고 : 오라클 19c autoupgrade를 이용해 패치 다운로드 방법 ( https://positivemh.tistory.com/1370 )
먼저 Autoupgrade 툴 최신 버전 다운로드
아래 링크 또는 AutoUpgrade Tool(KB123450)에서 다운로드 가능
https://www.oracle.com/database/upgrades
본문에서는 /home/oracle/autoupg 라는 폴더에서 autoupgrade.jar를 실행하여 패치를 다운로드 함
폴더 생성 후 autoupgrade.jar 파일 확인
|
1
2
3
4
5
6
|
$ mkdir -p /home/oracle/autoupg
$ ls -al
total 6868
drwxr-xr-x 4 oracle oinstall 95 May 9 18:52 .
drwx------. 19 oracle oinstall 4096 May 9 18:52 ..
-rw-r--r-- 1 oracle dba 7016621 May 4 22:24 autoupgrade.jar
|
AutoUpgrade 설정 파일(Config) 생성
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
$ vi install_newhome.cfg
global.global_log_dir=/home/oracle/autoupg/logs
global.keystore=/home/oracle/autoupg/keystore
install1.patch=RU,OPATCH,DPBP
install1.folder=/oraimsi/media
install1.target_home=/oraimsi/newapp/oracle/product/26ai/db1
install1.home_settings.oracle_base=/oraimsi/newapp/oracle
install1.home_settings.edition=EE
install1.home_settings.inventory_location=/oraimsi/newapp
install1.home_settings.inventory_group=dba
install1.home_settings.osdba_group=dba
install1.home_settings.osbackupdba_group=dba
install1.home_settings.oskmdba_group=dba
install1.home_settings.osracdba_group=dba
install1.home_settings.osdgdba_group=dba
install1.home_settings.osoper_group=dba
install1.download=yes
install1.home_settings.ru_apply=yes
install1.target_version=26
|
옵션 설명
global_log_dir : 로그가 저장될 경로
keystore : MOS 계정 정보를 저장할 암호화된 지갑 경로
folder : 패치가 저장될 디렉토리
target_home : 엔진이 설치될 경로
target_version : RU를 받을 대상 버전
home_settings : 엔진 설치시 설정하는 부분
download : 다운로드받을지 여부
patch :
- RECOMMENDED : 종합 패치 세트. RU, OPATCH, OJVM, DPBP를 모두 포함함
- RU : 최신 버전의 Release Update를 다운로드
- RU:x.y : 특정 버전의 RU를 지정(예: RU:19.24)
- OPATCH : 해당 버전에 맞는 최신 버전의 OPatch 도구를 다운로드
- OJVM : 지정한 RU 버전에 호환되는 Oracle Java VM 패치를 다운로드
- DPBP : Data Pump Bundle Patch를 해당 RU 버전에 맞춰 다운로드
- OCW : Grid Infrastructure 패치를 다운로드
- AHF : Autonomous Health Framework를 다운로드
- SQLCL : SQL Developer Command Line 툴을 다운로드
- patch-number(12345678) : one-off 패치를 다운로드
참고 : Autoupgrade : How to download patches with Autoupgrade ?(KB790461)
MOS 자격 증명 로드(Keystore 생성)
|
1
2
3
4
5
6
7
8
9
10
|
$ java -jar ./autoupgrade.jar -config ./install_newhome.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
|
$ java -jar autoupgrade.jar -config install_newhome.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용 패스워드 입력(Dhfkzmf1!)
AutoUpgrade Patching keystore is loaded
Connected to MOS - Searching for specified patches
-----------------------------------
Downloading files to /oraimsi/media
-----------------------------------
DATABASE RELEASE UPDATE 23.26.2.0.0
File: p39099680_230000_Linux-x86-64.zip - VALIDATED
OPatch 12.2.0.1.51 for DB 23.0.0.0.0 (Apr 2026)
File: p6880880_230000_Linux-x86-64.zip - VALIDATED
DATAPUMP BUNDLE PATCH 23.26.2.0.0
File: p39227161_2326200DBRU_Generic.zip - VALIDATED
-----------------------------------
|
AutoUpgrade 설정 파일(Config) 수정
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
$ vi install_newhome.cfg
global.global_log_dir=/home/oracle/autoupg/logs
global.keystore=/home/oracle/autoupg/keystore
install1.patch=RU,OPATCH,DPBP
install1.folder=/oraimsi/media
install1.target_home=/oraimsi/newapp/oracle/product/26ai/db1
install1.home_settings.oracle_base=/oraimsi/newapp/oracle
install1.home_settings.edition=EE
install1.home_settings.inventory_location=/oraimsi/newapp
install1.home_settings.inventory_group=dba
install1.home_settings.osdba_group=dba
install1.home_settings.osbackupdba_group=dba
install1.home_settings.oskmdba_group=dba
install1.home_settings.osracdba_group=dba
install1.home_settings.osdgdba_group=dba
install1.home_settings.osoper_group=dba
install1.download=no
install1.home_settings.ru_apply=yes
install1.target_version=26
|
필요한 설치파일은 다운로드 받았으니 download=no로 설정
autoupgrade create_home 모드 실행
|
1
2
3
4
5
6
7
8
9
10
11
|
$ java -jar autoupgrade.jar -config install_newhome.cfg -patch -mode create_home
Previous execution found loading latest data
Total jobs recovered: 1
Loading AutoUpgrade Patching keystore
Enter wallet password:
AutoUpgrade Patching keystore is loaded
+-----------------------------------------+
| Starting AutoUpgrade Patching execution |
+-----------------------------------------+
Type 'help' to list console commands
patch>
|
시작됨
30초 마다 상태 확인(lsj -a 30 명령 이용)
|
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
patch> lsj -a 30
patch> +----+-------------+-------+---------+-------+---------------+-------+--------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME|UPDATED| MESSAGE|
+----+-------------+-------+---------+-------+---------------+-------+--------------------------+
| 101|create_home_1|PENDING|PREPARING|RUNNING|May-10 16:43:24| |Scheduled, starts in 0 min|
+----+-------------+-------+---------+-------+---------------+-------+--------------------------+
Total jobs 1
The command lsj is running every 30 seconds. PRESS ENTER TO EXIT
+----+-------------+-------+---------+-------+----------+-------+---------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
| 101|create_home_1|EXTRACT|EXECUTING|RUNNING| 16:43:24| 9s ago|Extracting gold image|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
Total jobs 1
The command lsj is running every 30 seconds. PRESS ENTER TO EXIT
+----+-------------+-------+---------+-------+----------+-------+----------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------------+-------+---------+-------+----------+-------+----------------------+
| 101|create_home_1|INSTALL|EXECUTING|RUNNING| 16:43:24| 5s ago|Installing ORACLE_HOME|
+----+-------------+-------+---------+-------+----------+-------+----------------------+
Total jobs 1
The command lsj is running every 30 seconds. PRESS ENTER TO EXIT
+----+-------------+-------+---------+-------+----------+-------+----------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------------+-------+---------+-------+----------+-------+----------------------+
| 101|create_home_1|INSTALL|EXECUTING|RUNNING| 16:43:24|95s ago|Installing ORACLE_HOME|
+----+-------------+-------+---------+-------+----------+-------+----------------------+
Total jobs 1
The command lsj is running every 30 seconds. PRESS ENTER TO EXIT
+----+-------------+-----------+---------+-------+----------+-------+---------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------------+-----------+---------+-------+----------+-------+---------------------------------+
| 101|create_home_1|OH_PATCHING|EXECUTING|RUNNING| 16:43:24|24s ago|DATAPUMP BUNDLE PATCH 23.26.2.0.0|
+----+-------------+-----------+---------+-------+----------+-------+---------------------------------+
Total jobs 1
The command lsj is running every 30 seconds. PRESS ENTER TO EXIT
Job 101 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs restored [0]
Jobs pending [0]
# Run the root.sh script as root for the following jobs:
For create_home_1 -> /oraimsi/newapp/oracle/product/26ai/db1/root.sh
Please check the summary report at:
/home/oracle/autoupg/logs/cfgtoollogs/patch/auto/status/status.html
/home/oracle/autoupg/logs/cfgtoollogs/patch/auto/status/status.log
|
엔진 설치가 완료됨
(로그는 일부 생략함)
root 계정에서 root.sh 스크립트 수행
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# /oraimsi/newapp/oracle/product/26ai/db1/root.sh
Check /oraimsi/newapp/oracle/product/26ai/db1/install/root_ora19fs_2026-05-10_16-47-11-151658533.log for the output of root script
# cat /oraimsi/newapp/oracle/product/26ai/db1/install/root_ora19fs_2026-05-10_16-47-11-151658533.log
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oraimsi/newapp/oracle/product/26ai/db1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
|
완료됨
설치 status 파일 확인
|
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
$ cat /home/oracle/autoupg/logs/cfgtoollogs/patch/auto/status/status.log
==========================================
AutoUpgrade Patching Summary Report
==========================================
[Date] Sun May 10 16:46:17 KST 2026
[Number of Jobs] 1
==========================================
[Job ID] 101
==========================================
[DB Name] create_home_1
[Version Before AutoUpgrade Patching] 23.0.0.0.0
[Version After AutoUpgrade Patching] 23.26.2.0.0
------------------------------------------
[Stage Name] PENDING
[Status] SUCCESS
[Start Time] 2026-05-10 16:43:23
[Duration] 0:00:00
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/pending
------------------------------------------
[Stage Name] PREACTIONS
[Status] SUCCESS
[Start Time] 2026-05-10 16:43:23
[Duration] 0:00:00
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/preaction
------------------------------------------
[Stage Name] EXTRACT
[Status] SUCCESS
[Start Time] 2026-05-10 16:43:23
[Duration] 0:00:40
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/extract
------------------------------------------
[Stage Name] DBTOOLS
[Status] SUCCESS
[Start Time] 2026-05-10 16:44:04
[Duration] 0:00:00
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/dbtools
------------------------------------------
[Stage Name] INSTALL
[Status] SUCCESS
[Start Time] 2026-05-10 16:44:04
[Duration] 0:01:41
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/install
------------------------------------------
[Stage Name] OH_PATCHING
[Status] SUCCESS
[Start Time] 2026-05-10 16:45:46
[Duration] 0:00:29
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/opatch
------------------------------------------
[Stage Name] OPTIONS
[Status] SUCCESS
[Start Time] 2026-05-10 16:46:16
[Duration] 0:00:00
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/options
------------------------------------------
[Stage Name] ROOTSH
[Status] SUCCESS
[Start Time] 2026-05-10 16:46:16
[Duration] 0:00:00
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/rootsh
------------------------------------------
[Stage Name] DISPATCH
[Status] SUCCESS
[Start Time] 2026-05-10 16:46:17
[Duration] 0:00:00
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/dispatch
------------------------------------------
[Stage Name] POSTACTIONS
[Status] SUCCESS
[Start Time] 2026-05-10 16:46:17
[Duration] 0:00:00
[Log Directory] /home/oracle/autoupg/logs/create_home_1/101/postaction
------------------------------------------
|
모든 단계가 SUCCESS됨
패치 상태 확인
|
1
2
3
4
5
6
|
$ /oraimsi/newapp/oracle/product/26ai/db1/OPatch/opatch lspatches -oh /oraimsi/newapp/oracle/product/26ai/db1
39227161;DATAPUMP BUNDLE PATCH 23.26.2.0.0
39093738;OCW RELEASE UPDATE 23.26.2.0.0 (39093738) Gold Image
39093711;Database Release Update : 23.26.2.0.0 (39093711) Gold Image
OPatch succeeded.
|
정상임
참고로 이 서버에는 기존에 19c가 설치되어 있었는데 이 경우에는 install_newhome.cfg에 새로운 inventory 경로를 설정해줘도
기존 19c가 사용하는 인벤토리 경로에 정보가 들어감(/etc/oraInst.loc를 참고해서 그런것일수도 있음)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
$ pwd
/app/oraInventory/ContentsXML
$ cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2026, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.9.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDB19Home1" LOC="/app/oracle/product/19c" TYPE="O" IDX="1"/>
<HOME NAME="OraDB23Home1" LOC="/oraimsi/newapp/oracle/product/26ai/db1" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
|
이후 .bash_profile을 설정하고 리스너, db 엔진을 구성하면됨
.bash_profile 설정
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
$ cd /home/oracle
$ vi .bash_profile
export ORACLE_BASE=/oraimsi/newapp/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/26ai/db1;
export ORACLE_SID=ORACLE26;
export DB_UNIQUE_NAME=ORACLE26;
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
#export DISPLAY=localhost:0.0;
alias oh='cd $ORACLE_HOME;pwd'
alias ss='sqlplus / as sysdba'
alias sysc='sqlplus sys/oracle@localhost:1521/ORACLE26 as sysdba'
alias sysp='sqlplus sys/oracle@localhost:1521/ORACLE26PDB1 as sysdba'
stty erase ^H
|
리스너 설정
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
$ grep -vE '^\s*(#|$)' $ORACLE_HOME/assistants/netca/netca.rsp > ~oracle/netca.rsp
$ netca -silent -responsefile ~/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/oracle/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/oraimsi/newapp/oracle/product/26ai/db1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
|
리스너 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
$ lsnrctl status
LSNRCTL for Linux: Version 23.26.2.0.0 - Production on 10-MAY-2026 17:01:25
Copyright (c) 1991, 2026, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora19fs)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 23.26.2.0.0 - Production
Start Date 10-MAY-2026 17:01:21
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oraimsi/newapp/oracle/product/26ai/db1/network/admin/listener.ora
Listener Log File /oraimsi/newapp/oracle/diag/tnslsnr/ora19fs/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora19fs)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
|
db 구성
|
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
$ dbca -silent -createDatabase \
-gdbName ORACLE26 \
-templateName General_Purpose.dbc \
-scriptDest /oraimsi/newapp/oracle/admin/ORACLE26/script \
-databaseConfigType SINGLE \
-createAsContainerDatabase TRUE \
-numberOfPDBs 1 \
-pdbName ORACLE26PDB1 \
-datafileDestination /oraimsi/newapp/oracle/oradata \
-storageType FS \
-redoLogFileSize 200 \
-characterSet KO16MSWIN949 \
-nationalCharacterSet AL16UTF16 \
-listeners LISTENER \
-databaseType MULTIPURPOSE \
-memoryMgmtType AUTO_SGA \
-totalMemory 2000m \
-sysPassword "oracle" \
-systemPassword "oracle" \
-pdbAdminPassword "oracle"
[WARNING] [DBT-10331] Specified SID Name (ORACLE26) may have a potential conflict with an already existing database on the system.
CAUSE: The specified SID Name without the trailing numeric characters (ORACLE) may have a potential conflict with an already existing database on the system.
ACTION: Specify a different SID Name that does not conflict with existing databases on the system.
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
39% complete
42% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/oraimsi/newapp/oracle/cfgtoollogs/dbca/ORACLE26.
Database Information:
Global Database Name:ORACLE26
System Identifier(SID):ORACLE26
Look at the log file "/oraimsi/newapp/oracle/cfgtoollogs/dbca/ORACLE26/ORACLE26.log" for further details.
|
db 구성이 완료됨
확인
|
1
2
3
4
5
6
7
8
9
10
11
|
$ sqlplus / as sysdba
SQL>
set lines 200 pages 1000
col name for a20
select con_id, name, open_mode, dbid from v$containers;
CON_ID NAME OPEN_MODE DBID
---------- -------------------- ---------- ----------
1 CDB$ROOT READ WRITE 2080163384
2 PDB$SEED READ ONLY 1194900061
3 ORACLE26PDB1 READ WRITE 3568720800
|
잘 생성됨
컴포넌트 확인
|
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
SQL>
set lines 200 pages 1000
col comp_id for a20
col comp_name for a40
col name for a20
select (select name from v$containers where con_id = cr.con_id) name
, comp_id, comp_name, version, status
from cdb_registry cr;
NAME COMP_ID COMP_NAME VERSION STATUS
-------------------- -------------------- ---------------------------------------- ------------------------------ -----------
CDB$ROOT CATALOG Oracle Database Catalog Views 23.0.0.0.0 VALID
CDB$ROOT CATPROC Oracle Database Packages and Types 23.0.0.0.0 VALID
CDB$ROOT RAC Oracle Real Application Clusters 23.0.0.0.0 OPTION OFF
CDB$ROOT JAVAVM JServer JAVA Virtual Machine 23.0.0.0.0 VALID
CDB$ROOT XML Oracle XDK 23.0.0.0.0 VALID
CDB$ROOT CATJAVA Oracle Database Java Packages 23.0.0.0.0 VALID
CDB$ROOT APS OLAP Analytic Workspace 23.0.0.0.0 VALID
CDB$ROOT XDB Oracle XML Database 23.0.0.0.0 VALID
CDB$ROOT OWM Oracle Workspace Manager 23.0.0.0.0 VALID
CDB$ROOT CONTEXT Oracle Text 23.0.0.0.0 VALID
CDB$ROOT XOQ Oracle OLAP API 23.0.0.0.0 VALID
CDB$ROOT SDO Spatial 23.0.0.0.0 VALID
CDB$ROOT OLS Oracle Label Security 23.0.0.0.0 VALID
CDB$ROOT DV Oracle Database Vault 23.0.0.0.0 VALID
ORACLE26PDB1 CATALOG Oracle Database Catalog Views 23.0.0.0.0 VALID
ORACLE26PDB1 CATPROC Oracle Database Packages and Types 23.0.0.0.0 VALID
ORACLE26PDB1 RAC Oracle Real Application Clusters 23.0.0.0.0 OPTION OFF
ORACLE26PDB1 JAVAVM JServer JAVA Virtual Machine 23.0.0.0.0 VALID
ORACLE26PDB1 XML Oracle XDK 23.0.0.0.0 VALID
ORACLE26PDB1 CATJAVA Oracle Database Java Packages 23.0.0.0.0 VALID
ORACLE26PDB1 APS OLAP Analytic Workspace 23.0.0.0.0 VALID
ORACLE26PDB1 XDB Oracle XML Database 23.0.0.0.0 VALID
ORACLE26PDB1 OWM Oracle Workspace Manager 23.0.0.0.0 VALID
ORACLE26PDB1 CONTEXT Oracle Text 23.0.0.0.0 VALID
ORACLE26PDB1 XOQ Oracle OLAP API 23.0.0.0.0 VALID
ORACLE26PDB1 SDO Spatial 23.0.0.0.0 VALID
ORACLE26PDB1 OLS Oracle Label Security 23.0.0.0.0 VALID
ORACLE26PDB1 DV Oracle Database Vault 23.0.0.0.0 VALID
28 rows selected.
|
General_Purpose 템플릿으로 생성해서 컴포넌트도 대부분 설치됨
패치 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
SQL>
set lines 200 pages 1000
col con_name for a15
col action_time for a20
col action for a10
col status for a10
col description for a60
col version for a10
select (select name from v$containers where con_id = crs.con_id) con_name,
to_char(action_time, 'yyyy/mm/dd hh24:mi:ss') as action_time
,action ,status ,description, patch_id
from cdb_registry_sqlpatch crs
order by action_time;
CON_NAME ACTION_TIME ACTION STATUS DESCRIPTION PATCH_ID
--------------- -------------------- ---------- ---------- ------------------------------------------------------------ ----------
CDB$ROOT 2026/05/10 17:08:26 APPLY SUCCESS DATAPUMP BUNDLE PATCH 23.26.2.0.0 39227161
ORACLE26PDB1 2026/05/10 17:13:41 APPLY SUCCESS DATAPUMP BUNDLE PATCH 23.26.2.0.0 39227161
CDB$ROOT 2026/05/10 17:13:59 APPLY SUCCESS Database Release Update : 23.26.2.0.0 (39093711) Gold Image 39093711
ORACLE26PDB1 2026/05/10 17:13:59 APPLY SUCCESS Database Release Update : 23.26.2.0.0 (39093711) Gold Image 39093711
|
결론 :
autoupgrade를 이용해 업그레이드를 할수도 있지만 패치 파일을 다운로드 한다거나, db 엔진을 설치할수도 있어
사용법만 잘 알아두면 툴 하나로 여러가지 용도로 유용하게 사용할 수 있음
참조 :
Autoupgrade : How to install Oracle Home using Autoupgrade ?(KB753244)
오라클 19c autoupgrade를 이용해 패치 다운로드 방법 ( https://positivemh.tistory.com/1370 )
autoupgrade Download query failed ( https://positivemh.tistory.com/1372 )
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://www.dbarj.com.br/en/2026/02/downloading-and-using-gold-image-with-autoupgrade/
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
'ORACLE > Install' 카테고리의 다른 글
| Oracle Linux 7.6에 Oracle 11gR2 Silent 모드 설치 가이드 (0) | 2026.05.14 |
|---|---|
| Oracle 26ai Single DB RU(Release Update) 패치 가이드 (0) | 2026.05.01 |
| 오라클 19c 설치 시 gui 창 띄우는 방법 (0) | 2026.04.28 |
| VirtualBox에 Oracle 26ai Free 로드 가이드 (0) | 2026.04.06 |
| Oracle Linux 9.6에 Oracle 26ai Free RPM 설치 가이드 (0) | 2026.03.25 |