OS 환경 : Oracle Linux 9.6 (64bit)
DB 환경 : Oracle Database 23.26.1.0.0 ai Free
방법 : Oracle Linux 9.6에 Oracle 26ai Free RPM 설치 가이드
2025년 10월 14일 Oracle AI World에서 AI Database 26ai가 공개됨(오라클 23c -> 23ai -> 26ai)
이에 따라 26ai 설치 및 삭제 가이드를 신규로 작성함
Oracle Linux 9.6에 26ai Free 버전을 RPM 설치 방식을 통해 설치하는 방법과 삭제하는 방법을 설명함
26ai 는 기본적으로 non-cdb 방식 사용이 불가능하고, cdb 방식으로만 설치가 가능함
OS 설치는 아래 게시물 참조
Oracle Linux 9.6 설치 가이드 ( https://positivemh.tistory.com/1284 )
oracle 26ai rpm 설치파일 다운로드
공식홈페이지 접속(https://www.oracle.com/database/free/get-started/)
26ai Free on Linux RPM 파일 다운로드
설치파일 서버에 업로드
|
1
2
|
# ls -al oracle-ai-database-free-26ai-23.26.1-1.el9.x86_64.rpm
-rw-r--r--. 1 root root 1489765640 Jan 23 18:08 oracle-ai-database-free-26ai-23.26.1-1.el9.x86_64.rpm |
오라클 설치 전 사전 설정
/etc/hosts 에 ip hostname설정
|
1
2
3
4
|
# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.137.26 oel9
|
preinstall rpm 설치
공식홈페이지에서 preinstall rpm 다운로드 후 서버에 업로드
또는 curl로 서버에 직접 다운로드
|
1
|
# curl -o oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm
|
preinstall 패키지 설치
|
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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
# dnf -y localinstall oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm
Oracle Linux 9 BaseOS Latest (x86_64) 10 kB/s | 4.3 kB 00:00
Oracle Linux 9 BaseOS Latest (x86_64) 15 MB/s | 115 MB 00:07
Oracle Linux 9 Application Stream Packages (x86_64) 11 kB/s | 4.5 kB 00:00
Oracle Linux 9 Application Stream Packages (x86_64) 14 MB/s | 86 MB 00:06
Oracle Linux 9 UEK Release 8 (x86_64) 8.3 kB/s | 3.5 kB 00:00
Oracle Linux 9 UEK Release 8 (x86_64) 11 MB/s | 31 MB 00:02
Last metadata expiration check: 0:00:06 ago on Sun 22 Mar 2026 02:46:45 PM KST.
Dependencies resolved.
===============================================================================================================================================================
Package Architecture Version Repository Size
===============================================================================================================================================================
Installing:
oracle-ai-database-preinstall-26ai x86_64 1.0-1.el9 @commandline 34 k
Installing dependencies:
compat-openssl11 x86_64 1:1.1.1k-5.el9_7.1 ol9_appstream 1.5 M
gssproxy x86_64 0.8.4-7.el9 ol9_baseos_latest 120 k
initscripts x86_64 10.11.8-4.0.1.el9 ol9_baseos_latest 285 k
ksh x86_64 3:1.0.6-7.0.1.el9_6.2 ol9_appstream 889 k
libev x86_64 4.33-6.el9 ol9_baseos_latest 56 k
libnfsidmap x86_64 1:2.5.4-38.0.1.el9_7.3 ol9_baseos_latest 71 k
libverto-libev x86_64 0.3.2-3.el9 ol9_baseos_latest 14 k
lm_sensors-libs x86_64 3.6.0-10.el9 ol9_appstream 42 k
nfs-utils x86_64 1:2.5.4-38.0.1.el9 ol9_baseos_latest 518 k
pcp-conf x86_64 6.3.7-6.0.2.el9 ol9_appstream 41 k
pcp-libs x86_64 6.3.7-6.0.2.el9 ol9_appstream 653 k
rpcbind x86_64 1.2.6-7.el9 ol9_baseos_latest 69 k
sssd-nfs-idmap x86_64 2.9.6-4.0.1.el9 ol9_baseos_latest 45 k
sysstat x86_64 12.5.4-9.0.2.el9 ol9_appstream 541 k
Transaction Summary
===============================================================================================================================================================
Install 15 Packages
Total size: 4.8 M
Total download size: 4.7 M
Installed size: 13 M
Downloading Packages:
(1/14): libev-4.33-6.el9.x86_64.rpm 84 kB/s | 56 kB 00:00
(2/14): gssproxy-0.8.4-7.el9.x86_64.rpm 153 kB/s | 120 kB 00:00
(3/14): libnfsidmap-2.5.4-38.0.1.el9_7.3.x86_64.rpm 262 kB/s | 71 kB 00:00
(4/14): libverto-libev-0.3.2-3.el9.x86_64.rpm 95 kB/s | 14 kB 00:00
(5/14): initscripts-10.11.8-4.0.1.el9.x86_64.rpm 296 kB/s | 285 kB 00:00
(6/14): sssd-nfs-idmap-2.9.6-4.0.1.el9.x86_64.rpm 275 kB/s | 45 kB 00:00
(7/14): rpcbind-1.2.6-7.el9.x86_64.rpm 265 kB/s | 69 kB 00:00
(8/14): nfs-utils-2.5.4-38.0.1.el9.x86_64.rpm 1.1 MB/s | 518 kB 00:00
(9/14): lm_sensors-libs-3.6.0-10.el9.x86_64.rpm 297 kB/s | 42 kB 00:00
(10/14): compat-openssl11-1.1.1k-5.el9_7.1.x86_64.rpm 2.6 MB/s | 1.5 MB 00:00
(11/14): pcp-conf-6.3.7-6.0.2.el9.x86_64.rpm 298 kB/s | 41 kB 00:00
(12/14): ksh-1.0.6-7.0.1.el9_6.2.x86_64.rpm 1.3 MB/s | 889 kB 00:00
(13/14): pcp-libs-6.3.7-6.0.2.el9.x86_64.rpm 3.7 MB/s | 653 kB 00:00
(14/14): sysstat-12.5.4-9.0.2.el9.x86_64.rpm 2.4 MB/s | 541 kB 00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 2.5 MB/s | 4.7 MB 00:01
Oracle Linux 9 BaseOS Latest (x86_64) 6.1 MB/s | 6.2 kB 00:00
Importing GPG key 0x8D8B756F:
Userid : "Oracle Linux (release key 1) <secalert_us@oracle.com>"
Fingerprint: 3E6D 826D 3FBA B389 C2F3 8E34 BC4D 06A0 8D8B 756F
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Key imported successfully
Importing GPG key 0x8B4EFBE6:
Userid : "Oracle Linux (backup key 1) <secalert_us@oracle.com>"
Fingerprint: 9822 3175 9C74 6706 5D0C E9B2 A7DD 0708 8B4E FBE6
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : libnfsidmap-1:2.5.4-38.0.1.el9_7.3.x86_64 1/15
Installing : pcp-conf-6.3.7-6.0.2.el9.x86_64 2/15
Installing : pcp-libs-6.3.7-6.0.2.el9.x86_64 3/15
Installing : lm_sensors-libs-3.6.0-10.el9.x86_64 4/15
Installing : sysstat-12.5.4-9.0.2.el9.x86_64 5/15
Running scriptlet: sysstat-12.5.4-9.0.2.el9.x86_64 5/15
Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /usr/lib/systemd/system/sysstat.service.
Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-collect.timer → /usr/lib/systemd/system/sysstat-collect.timer.
Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-summary.timer → /usr/lib/systemd/system/sysstat-summary.timer.
Installing : ksh-3:1.0.6-7.0.1.el9_6.2.x86_64 6/15
Running scriptlet: ksh-3:1.0.6-7.0.1.el9_6.2.x86_64 6/15
Installing : compat-openssl11-1:1.1.1k-5.el9_7.1.x86_64 7/15
Running scriptlet: rpcbind-1.2.6-7.el9.x86_64 8/15
Installing : rpcbind-1.2.6-7.el9.x86_64 8/15
Running scriptlet: rpcbind-1.2.6-7.el9.x86_64 8/15
Created symlink /etc/systemd/system/multi-user.target.wants/rpcbind.service → /usr/lib/systemd/system/rpcbind.service.
Created symlink /etc/systemd/system/sockets.target.wants/rpcbind.socket → /usr/lib/systemd/system/rpcbind.socket.
Installing : libev-4.33-6.el9.x86_64 9/15
Installing : libverto-libev-0.3.2-3.el9.x86_64 10/15
Installing : gssproxy-0.8.4-7.el9.x86_64 11/15
Running scriptlet: gssproxy-0.8.4-7.el9.x86_64 11/15
Running scriptlet: nfs-utils-1:2.5.4-38.0.1.el9.x86_64 12/15
Installing : nfs-utils-1:2.5.4-38.0.1.el9.x86_64 12/15
Running scriptlet: nfs-utils-1:2.5.4-38.0.1.el9.x86_64 12/15
Installing : initscripts-10.11.8-4.0.1.el9.x86_64 13/15
Running scriptlet: initscripts-10.11.8-4.0.1.el9.x86_64 13/15
Created symlink /etc/systemd/system/sysinit.target.wants/import-state.service → /usr/lib/systemd/system/import-state.service.
Created symlink /etc/systemd/system/sysinit.target.wants/loadmodules.service → /usr/lib/systemd/system/loadmodules.service.
Installing : oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64 14/15
Installing : sssd-nfs-idmap-2.9.6-4.0.1.el9.x86_64 15/15
Running scriptlet: oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64 15/15
Running scriptlet: sssd-nfs-idmap-2.9.6-4.0.1.el9.x86_64 15/15
Verifying : gssproxy-0.8.4-7.el9.x86_64 1/15
Verifying : initscripts-10.11.8-4.0.1.el9.x86_64 2/15
Verifying : libev-4.33-6.el9.x86_64 3/15
Verifying : libnfsidmap-1:2.5.4-38.0.1.el9_7.3.x86_64 4/15
Verifying : libverto-libev-0.3.2-3.el9.x86_64 5/15
Verifying : nfs-utils-1:2.5.4-38.0.1.el9.x86_64 6/15
Verifying : rpcbind-1.2.6-7.el9.x86_64 7/15
Verifying : sssd-nfs-idmap-2.9.6-4.0.1.el9.x86_64 8/15
Verifying : compat-openssl11-1:1.1.1k-5.el9_7.1.x86_64 9/15
Verifying : ksh-3:1.0.6-7.0.1.el9_6.2.x86_64 10/15
Verifying : lm_sensors-libs-3.6.0-10.el9.x86_64 11/15
Verifying : pcp-conf-6.3.7-6.0.2.el9.x86_64 12/15
Verifying : pcp-libs-6.3.7-6.0.2.el9.x86_64 13/15
Verifying : sysstat-12.5.4-9.0.2.el9.x86_64 14/15
Verifying : oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64 15/15
Installed:
compat-openssl11-1:1.1.1k-5.el9_7.1.x86_64 gssproxy-0.8.4-7.el9.x86_64 initscripts-10.11.8-4.0.1.el9.x86_64
ksh-3:1.0.6-7.0.1.el9_6.2.x86_64 libev-4.33-6.el9.x86_64 libnfsidmap-1:2.5.4-38.0.1.el9_7.3.x86_64
libverto-libev-0.3.2-3.el9.x86_64 lm_sensors-libs-3.6.0-10.el9.x86_64 nfs-utils-1:2.5.4-38.0.1.el9.x86_64
oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64 pcp-conf-6.3.7-6.0.2.el9.x86_64 pcp-libs-6.3.7-6.0.2.el9.x86_64
rpcbind-1.2.6-7.el9.x86_64 sssd-nfs-idmap-2.9.6-4.0.1.el9.x86_64 sysstat-12.5.4-9.0.2.el9.x86_64
Complete!
|
자동 설정 후 수동설정 파일 확인필요
자동 설정 시 필수 rpm 설치 및 커널 파라미터가 설정되고 유저 및 그룹이 만들어짐
커널 파라미터 확인
|
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
|
# cat /etc/sysctl.conf
결과
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
# oracle-ai-database-preinstall-26ai setting for fs.file-max is 6815744
fs.file-max = 6815744
# oracle-ai-database-preinstall-26ai setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
# oracle-ai-database-preinstall-26ai setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# oracle-ai-database-preinstall-26ai setting for kernel.shmall is 1073741824 on x86_64
kernel.shmall = 1048576
# oracle-ai-database-preinstall-26ai setting for kernel.shmmax is 4398046511104 on x86_64
kernel.shmmax = 4294967296
# oracle-ai-database-preinstall-26ai setting for kernel.panic_on_oops is 1 per Orabug 19212317
kernel.panic_on_oops = 1
# oracle-ai-database-preinstall-26ai setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# oracle-ai-database-preinstall-26ai setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# oracle-ai-database-preinstall-26ai setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# oracle-ai-database-preinstall-26ai setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576
# oracle-ai-database-preinstall-26ai setting for net.ipv4.conf.all.rp_filter is 2
net.ipv4.conf.all.rp_filter = 2
# oracle-ai-database-preinstall-26ai setting for net.ipv4.conf.default.rp_filter is 2
net.ipv4.conf.default.rp_filter = 2
# oracle-ai-database-preinstall-26ai setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576
# oracle-ai-database-preinstall-26ai setting for vm.hugetlb_shm_group is gid of primary group of 'oracle' user
vm.hugetlb_shm_group = 54321
# oracle-ai-database-preinstall-26ai setting special parameters BEGIN
# oracle-ai-database-preinstall-26ai setting for kernel.panic is 10
kernel.panic = 10
# oracle-ai-database-preinstall-26ai setting for net.ipv4.ip_local_port_range is 9000 65535
net.ipv4.ip_local_port_range = 9000 65535
# oracle-ai-database-preinstall-26ai setting special parameters END
|
*kernel.shmall, kernel.shmmax 은 서버에 물리 메모리의 절반으로 설정 필요(byte 단위), shmall은 page(4k(4096)) 단위로 설정 필요
현재 서버의 물리 메모리를 8gb로 잡았기 때문에 shmmax는 물리메모리의 절반인 4gb를 byte로 변경해 적용함(4*1024*1024*1024)
두 커널값 변경 후 적용
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# sysctl -p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1048576
kernel.shmmax = 4294967296
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
vm.hugetlb_shm_group = 54321
kernel.panic = 10
net.ipv4.ip_local_port_range = 9000 65535
|
유저 및 그룹 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
유저
# tail -1 /etc/passwd
oracle:x:54321:54321::/home/oracle:/bin/bash
그룹
# tail -7 /etc/group
oinstall:x:54321:oracle
dba:x:54322:oracle
oper:x:54323:oracle
backupdba:x:54324:oracle
dgdba:x:54325:oracle
kmdba:x:54326:oracle
racdba:x:54330:oracle
|
selinux disable 설정
|
1
2
|
# vi /etc/selinux/config
SELINUX=disabled
|
불필요한 서비스 정지
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
#
systemctl stop firewalld
systemctl disable firewalld
systemctl stop bluetooth
systemctl disable bluetooth
systemctl stop chronyd
systemctl disable chronyd
mv /etc/chrony.conf /etc/chrony.conf.bak
systemctl stop ntpdate
systemctl disable ntpdate
systemctl stop avahi-daemon.socket
systemctl disable avahi-daemon.socket
systemctl stop avahi-daemon
systemctl disable avahi-daemon
systemctl stop libvirtd
systemctl disable libvirtd
|
oracle 유저 패스워드 설정
|
1
2
3
4
5
6
|
# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
|
Oracle Software 설치
oracle rpm 설치(root 계정)
|
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
|
# dnf -y localinstall oracle-ai-database-free-26ai-23.26.1-1.el9.x86_64.rpm
Last metadata expiration check: 0:02:16 ago on Sun 22 Mar 2026 03:26:02 PM KST.
Dependencies resolved.
===============================================================================================================================================================
Package Architecture Version Repository Size
===============================================================================================================================================================
Installing:
oracle-ai-database-free-26ai x86_64 23.26.1-1 @commandline 1.4 G
Transaction Summary
===============================================================================================================================================================
Install 1 Package
Total size: 1.4 G
Installed size: 3.8 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-ai-database-free-26ai-23.26.1-1.x86_64 1/1
Installing : oracle-ai-database-free-26ai-23.26.1-1.x86_64 1/1
Running scriptlet: oracle-ai-database-free-26ai-23.26.1-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle AI Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-26ai.conf' and then run '/etc/init.d/oracle-free-26ai configure' as root.
Verifying : oracle-ai-database-free-26ai-23.26.1-1.x86_64 1/1
Installed:
oracle-ai-database-free-26ai-23.26.1-1.x86_64
Complete!
|
db 엔진이 설치 완료됨
설치 기본값이 /opt/oracle/oradata 여서 다른 경로로 변경
폴더 생성
|
1
2
3
|
# mkdir -p /app/oracle/oradata
# chown -R oracle:dba /app
# chmod -R 755 /app/
|
설치 파라미터 파일 변경
|
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
|
# vi /etc/sysconfig/oracle-free-26ai.conf
#This is a configuration file to setup the Oracle AI Database.
#It is used when running '/etc/init.d/oracle-free-26ai configure'.
# LISTENER PORT used Database listener, Leave empty for automatic port assignment
LISTENER_PORT=
# Character set of the database
CHARSET=AL32UTF8
# Database file directory
# If not specified, database files are stored under Oracle base/oradata
DBFILE_DEST=/app/oracle/oradata
# DB Domain name
DB_DOMAIN=
# Configure TDE
CONFIGURE_TDE=false
# Encrypt Tablespaces list, Leave empty for user tablespace alone or provide ALL for encrypting all tablespaces
# For specific tablespaces use SYSTEM:true,SYSAUX:false
ENCRYPT_TABLESPACES=
# SKIP Validations, memory, space
SKIP_VALIDATIONS=false
|
다른부분은 그대로 두고 DBFILE_DEST만 수정함
Oracle 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
|
# /etc/init.d/oracle-free-26ai configure
Specify a password to be used for database accounts.
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]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: <-- SYS,SYSTEM, PDBADMIN 패스워드 입력
Confirm the password: <-- SYS,SYSTEM, PDBADMIN 패스워드 재입력
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle AI Database FREE. Enter SYS user password:
********
Enter SYSTEM user password:
*****
Enter PDBADMIN User Password:
******
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.
Connect to Oracle AI Database using one of the connect strings:
Pluggable database: oel9/FREEPDB1
Multitenant container database: oel9
|
db 구성 완료됨
db 구성 시 alert log 모니터링 하고 싶은 경우 확인
|
1
|
$ tail -300f /opt/oracle/diag/rdbms/free/FREE/trace/alert_FREE.log
|
설치 경로 확인
|
1
2
3
4
5
6
7
8
9
10
|
# ls -al /opt/oracle/
total 4
drwxr-xr-x. 8 oracle oinstall 98 Mar 22 15:34 .
drwxr-xr-x. 4 root root 36 Mar 22 15:31 ..
drwxr-x---. 3 oracle oinstall 18 Mar 22 15:34 admin
drwxr-x---. 3 oracle oinstall 18 Mar 22 15:34 audit
drwxr-xr-x. 4 oracle oinstall 31 Mar 22 15:34 cfgtoollogs
drwxrwx---. 25 oracle oinstall 4096 Mar 22 15:31 diag
drwxrwx---. 4 oracle oinstall 78 Mar 22 15:39 oraInventory
drwxr-xr-x. 3 oracle oinstall 18 Mar 22 15:28 product
|
/opt/oracle이 일반적으로 오라클 설치 후 보이는 $ORACLE_BASE가 됨
오라클, 리스너 프로세스 확인
|
1
2
3
4
5
6
7
8
9
10
|
db
# ps -ef | grep pmon
oracle 50508 1 0 15:39 ? 00:00:00 db_pmon_FREE
root 50988 2294 0 15:42 pts/0 00:00:00 grep --color=auto pmon
리스너
# ps -ef | grep tns
root 8 2 0 14:53 ? 00:00:00 [kworker/R-netns]
oracle 48658 1 0 15:34 ? 00:00:00 /opt/oracle/product/26ai/dbhomeFree/bin/tnslsnr LISTENER -inherit
root 50991 2294 0 15:42 pts/0 00:00:00 grep --color=auto tn
|
oracle 계정 .bash_profile 설정
|
1
2
3
4
5
6
7
8
9
|
# su - oracle
$ vi .bash_profile
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/26ai/dbhomeFree
export ORACLE_SID=FREE
export PATH=$PATH:$ORACLE_HOME/bin
alias ss='sqlplus / as sysdba'
alias sysc='sqlplus sys/oracle@localhost:1521/FREE as sysdba'
alias sysp='sqlplus sys/oracle@localhost:1521/FREEPDB1 as sysdba'
|
적용
|
1
|
$ . ./.bash_profile
|
sqlplus 접속 및 버전 확인(기존 방식으로 cdb 접속)
|
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
|
$ sqlplus / as sysdba
SQL*Plus: Release 23.26.1.0.0 - Production on Sun Mar 22 15:47:54 2026
Version 23.26.1.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> select instance_name, version, status from v$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
FREE 23.0.0.0.0 OPEN
SQL> select banner_full from v$version;
BANNER_FULL
--------------------------------------------------------------------------------
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for F
ree
Version 23.26.1.0.0
|
정상적으로 CDB 접속됨
db 버전도 23.26.1.0.0(26ai)로 확인됨
*참고 : db 재기동은 sqlplus 에서 shutdown, startup 을 할수도 있고,
root 유저에서 /etc/init.d/oracle-free-26ai stop, /etc/init.d/oracle-free-26ai start 명령으로 할수도 있음
sqlplus 접속 테스트(리스너 이용 cdb접속)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
$ sqlplus sys/oracle@localhost:1521/FREE as sysdba
SQL*Plus: Release 23.26.1.0.0 - Production on Sun Mar 22 15:52:23 2026
Version 23.26.1.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
|
정상적으로 CDB 접속됨
db 목록 확인
|
1
2
3
4
5
6
7
8
9
10
|
SQL>
set lines 200 pages 1000
col name for a20
select con_id, name, open_mode, dbid, con_uid, guid from v$containers;
CON_ID NAME OPEN_MODE DBID CON_UID GUID
---------- -------------------- ---------- ---------- ---------- --------------------------------
1 CDB$ROOT READ WRITE 1500634422 1 48945B67CF47C635E063399B5E647C67
2 PDB$SEED READ ONLY 39762043 39762043 48945B67CF48C635E063399B5E647C67
3 FREEPDB1 READ WRITE 1403095878 1403095878 4D982D9074E0C5F1E063A465460A5F19
|
cdb와 pdb seed, pdb1이 존재함
sqlplus 접속 테스트(리스너 이용 pdb접속)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
$ sqlplus sys/oracle@localhost:1521/FREEPDB1 as sysdba
SQL*Plus: Release 23.26.1.0.0 - Production on Sun Mar 22 15:52:37 2026
Version 23.26.1.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0
SQL> show con_name
CON_NAME
------------------------------
FREEPDB1
|
정상적으로 PDB 접속됨
cdb로 세션 스위칭
|
1
2
3
4
5
6
7
8
9
|
SQL> ALTER SESSION SET CONTAINER = CDB$ROOT;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
|
간단한 세션 변경 확인 테스트
|
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
|
#세션 PDB로 전환
SQL> alter session set container = FREEPDB1;
Session altered.
# 확인
SQL> show con_name
CON_NAME
------------------------------
FREEPDB1
#오브젝트 수 확인
SQL> select count(*) from dba_objects;
COUNT(*)
----------
71913
#세션 CDB로 전환
SQL> ALTER SESSION SET CONTAINER = CDB$ROOT;
Session altered.
# 확인
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
#오브젝트 수 확인
SQL> select count(*) from dba_objects;
COUNT(*)
----------
72053
|
cdb와 pdb의 오브젝트 수가 다름을 확인 가능
참고1. db 기동 종료
shutdown immediate, startup 도 사용가능하지만 아래와 같은 방법으로도 기동, 종료가 가능함(root 유저에서 수행)
|
1
2
3
4
5
6
7
8
9
10
11
|
# /etc/init.d/oracle-free-26ai stop
Shutting down Oracle Database instance FREE.
Oracle Database instance FREE shut down.
Stopping Oracle Net Listener.
Oracle Net Listener stopped.
# /etc/init.d/oracle-free-26ai start
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.
|
참고2. 패스워드 파일이 없는 경우 생성
|
1
2
3
4
|
$ cd $ORACLE_HOME/dbs
$ orapwd file=/opt/oracle/product/26ai/dbhomeFree/dbs/orapwFREE format=12 force=y
Enter password for SYS: <-- oracle 입력함
|
결론 : linux 9 환경에 26ai free 버전을 rpm을 이용해 설치해보았음
26ai free 버전에서도 대부분의 테스트가 가능하니 신기능을 테스트 하고 싶은 경우 간편하게 free 버전을 설치해보면 좋음
참조 :
https://blogs.oracle.com/database/post/oracle-26ai-now-generally-available
https://www.oracle.com/database/free/get-started/
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/toc.htm
https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/deinstalling-oracle-database-free-software-linux.html#GUID-3F29EE7C-4546-49EE-B894-027EE3E371BF
https://tuna.tistory.com/81
https://positivemh.tistory.com/1088
https://positivemh.tistory.com/1329
https://positivemh.tistory.com/1095
'ORACLE > Install' 카테고리의 다른 글
| Oracle Linux 9.6에 Oracle 26ai 설치 가이드 (2) | 2026.01.30 |
|---|---|
| 오라클 19c grid 골드 이미지 생성 및 배포 가이드 (0) | 2026.01.19 |
| Oracle Linux 9.6에 Oracle 19c RAC 설치 가이드 (0) | 2026.01.04 |
| Oracle Linux 9.6에 Oracle 19c Restart 설치 가이드 (0) | 2025.12.31 |
| 오라클 26ai 23.26 골드이미지 패치 가이드 (0) | 2025.10.15 |