복사되었습니다!
OS 환경 : Oracle Linux 10.2 (64bit)
DB 환경 : Oracle AI Database 23.26.3.0.0 ai
방법 : Oracle Linux 10.2에 Oracle 26ai 설치 가이드
본문에서는 Oracle Linux 10.2에 Oracle 26ai를 설치하는 방법을 설명함
OS 설치는 아래 게시물 참조
Oracle linux 10.2 설치 가이드( https://positivemh.tistory.com/1437 )
hostname : ora26
DB 설치파일(23.26.3 골드 이미지를 이용해 설치함)
p39581612_230000_Linux-x86-64_dbgoldimg.zip
설치파일은 MOS KA958에서 다운로드 받을 수 있음
오라클 설치 전 사전 설정
기존에 다른 hostname이라면 hostname 변경 후 재접속
|
1
2
|
# hostnamectl set-hostname ora26
# (세션 재접속)
|
기존에 다른 ip라면 ip 변경 후 진행(선택)
현재 ip 및 인터페이스 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# ifconfig
ens160: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.137.26 netmask 255.255.255.255 broadcast 0.0.0.0
inet6 fe80::250:56ff:fea8:5e35 prefixlen 64 scopeid 0x20<link>
ether 00:50:56:a8:5e:35 txqueuelen 1000 (Ethernet)
RX packets 3172665 bytes 199497870 (190.2 MiB)
RX errors 0 dropped 487 overruns 0 frame 0
TX packets 2736617 bytes 497506796 (474.4 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 1028036 bytes 121335865 (115.7 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 1028036 bytes 121335865 (115.7 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
|
위 인터페이스 이름을 이용해 ip를 192.168.137.26으로 변경 및 네트워크 재시작
|
1
2
|
# nmcli con mod "ens160" ipv4.addresses 192.168.137.26
# nmcli con up "ens160"
|
/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 ora26
|
preinstall rpm 설치
공식홈페이지에서 preinstall rpm 다운로드 후 서버에 업로드
또는 curl로 서버에 직접 다운로드
|
1
|
# curl -o oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL10/appstream/x86_64/getPackage/oracle-ai-database-preinstall-26ai-1.0-1.el10.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
|
# dnf -y localinstall oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64.rpm
Last metadata expiration check: 3:03:31 ago on Mon 31 Aug 2026 05:42:19 AM KST.
Dependencies resolved.
=====================================================================================================================================================================
Package Architecture Version Repository Size
=====================================================================================================================================================================
Installing:
oracle-ai-database-preinstall-26ai x86_64 1.0-1.el10 @commandline 35 k
Installing dependencies:
gssproxy x86_64 0.9.2-10.el10 ol10_baseos_latest 126 k
initscripts x86_64 10.26-2.0.1.el10 ol10_baseos_latest 290 k
ksh x86_64 3:1.0.10-9.0.1.el10 ol10_appstream 967 k
libev x86_64 4.33-15.el10 ol10_baseos_latest 64 k
libnfsidmap x86_64 1:2.8.3-5.0.1.el10_2 ol10_baseos_latest 139 k
libverto-libev x86_64 0.3.2-10.el10 ol10_baseos_latest 13 k
libxcrypt-compat x86_64 4.4.36-10.el10 ol10_appstream 90 k
lm_sensors-libs x86_64 3.6.0-20.el10 ol10_appstream 40 k
nfs-utils x86_64 1:2.8.3-5.0.1.el10_2 ol10_baseos_latest 615 k
pcp-conf x86_64 7.0.3-5.0.1.el10_2 ol10_appstream 42 k
pcp-libs x86_64 7.0.3-5.0.1.el10_2 ol10_appstream 804 k
rpcbind x86_64 1.2.7-3.el10 ol10_baseos_latest 69 k
sssd-nfs-idmap x86_64 2.12.0-3.0.1.el10_2 ol10_baseos_latest 122 k
sysstat x86_64 12.7.6-4.el10 ol10_appstream 600 k
xorg-x11-xauth x86_64 1:1.1.2-8.el10 ol10_appstream 38 k
Transaction Summary
=====================================================================================================================================================================
Install 16 Packages
Total size: 4.0 M
Total download size: 3.9 M
Installed size: 11 M
Downloading Packages:
(1/15): libev-4.33-15.el10.x86_64.rpm 104 kB/s | 64 kB 00:00
(2/15): gssproxy-0.9.2-10.el10.x86_64.rpm 186 kB/s | 126 kB 00:00
(3/15): libverto-libev-0.3.2-10.el10.x86_64.rpm 101 kB/s | 13 kB 00:00
(4/15): initscripts-10.26-2.0.1.el10.x86_64.rpm 345 kB/s | 290 kB 00:00
(5/15): libnfsidmap-2.8.3-5.0.1.el10_2.x86_64.rpm 487 kB/s | 139 kB 00:00
(6/15): rpcbind-1.2.7-3.el10.x86_64.rpm 504 kB/s | 69 kB 00:00
(7/15): sssd-nfs-idmap-2.12.0-3.0.1.el10_2.x86_64.rpm 568 kB/s | 122 kB 00:00
(8/15): nfs-utils-2.8.3-5.0.1.el10_2.x86_64.rpm 1.5 MB/s | 615 kB 00:00
(9/15): libxcrypt-compat-4.4.36-10.el10.x86_64.rpm 534 kB/s | 90 kB 00:00
(10/15): lm_sensors-libs-3.6.0-20.el10.x86_64.rpm 338 kB/s | 40 kB 00:00
(11/15): ksh-1.0.10-9.0.1.el10.x86_64.rpm 2.6 MB/s | 967 kB 00:00
(12/15): pcp-conf-7.0.3-5.0.1.el10_2.x86_64.rpm 302 kB/s | 42 kB 00:00
(13/15): sysstat-12.7.6-4.el10.x86_64.rpm 3.4 MB/s | 600 kB 00:00
(14/15): pcp-libs-7.0.3-5.0.1.el10_2.x86_64.rpm 3.3 MB/s | 804 kB 00:00
(15/15): xorg-x11-xauth-1.1.2-8.el10.x86_64.rpm 258 kB/s | 38 kB 00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 2.5 MB/s | 3.9 MB 00:01
Oracle Linux 10 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.8.3-5.0.1.el10_2.x86_64 1/16
Installing : xorg-x11-xauth-1:1.1.2-8.el10.x86_64 2/16
Installing : pcp-conf-7.0.3-5.0.1.el10_2.x86_64 3/16
Installing : pcp-libs-7.0.3-5.0.1.el10_2.x86_64 4/16
Installing : lm_sensors-libs-3.6.0-20.el10.x86_64 5/16
Installing : sysstat-12.7.6-4.el10.x86_64 6/16
Running scriptlet: sysstat-12.7.6-4.el10.x86_64 6/16
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'.
Created symlink '/etc/systemd/system/sysstat.service.wants/sysstat-rotate.timer' → '/usr/lib/systemd/system/sysstat-rotate.timer'.
Installing : libxcrypt-compat-4.4.36-10.el10.x86_64 7/16
Installing : ksh-3:1.0.10-9.0.1.el10.x86_64 8/16
Running scriptlet: ksh-3:1.0.10-9.0.1.el10.x86_64 8/16
Running scriptlet: rpcbind-1.2.7-3.el10.x86_64 9/16
Installing : rpcbind-1.2.7-3.el10.x86_64 9/16
Running scriptlet: rpcbind-1.2.7-3.el10.x86_64 9/16
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-15.el10.x86_64 10/16
Installing : libverto-libev-0.3.2-10.el10.x86_64 11/16
Running scriptlet: gssproxy-0.9.2-10.el10.x86_64 12/16
Installing : gssproxy-0.9.2-10.el10.x86_64 12/16
Running scriptlet: gssproxy-0.9.2-10.el10.x86_64 12/16
Running scriptlet: nfs-utils-1:2.8.3-5.0.1.el10_2.x86_64 13/16
Installing : nfs-utils-1:2.8.3-5.0.1.el10_2.x86_64 13/16
Running scriptlet: nfs-utils-1:2.8.3-5.0.1.el10_2.x86_64 13/16
Created symlink '/etc/systemd/system/multi-user.target.wants/nfs-client.target' → '/usr/lib/systemd/system/nfs-client.target'.
Created symlink '/etc/systemd/system/remote-fs.target.wants/nfs-client.target' → '/usr/lib/systemd/system/nfs-client.target'.
Installing : initscripts-10.26-2.0.1.el10.x86_64 14/16
Running scriptlet: initscripts-10.26-2.0.1.el10.x86_64 14/16
Created symlink '/etc/systemd/system/sysinit.target.wants/import-state.service' → '/usr/lib/systemd/system/import-state.service'.
Installing : oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64 15/16
Installing : sssd-nfs-idmap-2.12.0-3.0.1.el10_2.x86_64 16/16
Running scriptlet: oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64 16/16
Running scriptlet: sssd-nfs-idmap-2.12.0-3.0.1.el10_2.x86_64 16/16
Installed:
gssproxy-0.9.2-10.el10.x86_64 initscripts-10.26-2.0.1.el10.x86_64 ksh-3:1.0.10-9.0.1.el10.x86_64
libev-4.33-15.el10.x86_64 libnfsidmap-1:2.8.3-5.0.1.el10_2.x86_64 libverto-libev-0.3.2-10.el10.x86_64
libxcrypt-compat-4.4.36-10.el10.x86_64 lm_sensors-libs-3.6.0-20.el10.x86_64 nfs-utils-1:2.8.3-5.0.1.el10_2.x86_64
oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64 pcp-conf-7.0.3-5.0.1.el10_2.x86_64 pcp-libs-7.0.3-5.0.1.el10_2.x86_64
rpcbind-1.2.7-3.el10.x86_64 sssd-nfs-idmap-2.12.0-3.0.1.el10_2.x86_64 sysstat-12.7.6-4.el10.x86_64
xorg-x11-xauth-1:1.1.2-8.el10.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
|
# vi /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.
|
db 설치 경로 생성
|
1
2
3
4
5
|
# mkdir -p /app
# mkdir -p /app/media
# mkdir -p /app/oracle/product/26ai
# chown -R oracle:dba /app
# chmod -R 755 /app
|
FTP 툴을 이용해 서버로 설치 미디어 업로드(p39581612_230000_Linux-x86-64_dbgoldimg.zip)
|
1
2
3
4
5
|
# ls -al /app/media/
total 2434920
drwxr-xr-x. 2 oracle dba 57 Aug 31 08:51 .
drwxr-xr-x. 4 oracle dba 33 Aug 31 08:51 ..
-rw-r--r--. 1 oracle dba 2493354906 Aug 31 07:26 p39581612_230000_Linux-x86-64_dbgoldimg.zip
|
설치파일을 /app/media로 업로드 후 oracle:dba 권한 부여
|
1
2
|
# cd /app/media/
# chown oracle:dba p39581612_230000_Linux-x86-64_dbgoldimg.zip
|
오라클 유저 .bash_profile 설정
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
# su - oracle
$ vi .bash_profile
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/26ai;
export ORACLE_SID=ORACLE26
export DB_UNIQUE_NAME=ORACLE26
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export DISPLAY=192.168.137.1:0.0;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export CV_ASSUME_DISTID=OL9
stty erase ^H
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'
alias bdump="cd $ORACLE_BASE/diag/rdbms/${DB_UNIQUE_NAME,,}/$ORACLE_SID/trace"
alias alert='vi $ORACLE_BASE/diag/rdbms/${DB_UNIQUE_NAME,,}/$ORACLE_SID/trace/alert_$ORACLE_SID.log'
alias alertf='tail -300f $ORACLE_BASE/diag/rdbms/${DB_UNIQUE_NAME,,}/$ORACLE_SID/trace/alert_$ORACLE_SID.log'
alias listen="vi $ORACLE_BASE/diag/tnslsnr/$(hostname -s)/listener/trace/listener.log"
alias listenf="tail -300f $ORACLE_BASE/diag/tnslsnr/$(hostname -s)/listener/trace/listener.log"
|
적용
|
1
|
$ . ./.bash_profile
|
Oracle Software(엔진) 설치
오라클 26ai 엔진 압축 해제
|
1
2
|
$ cd $ORACLE_HOME
$ unzip -q /app/media/p39581612_230000_Linux-x86-64_dbgoldimg.zip
|
runInstaller 실행
|
1
|
$ ./runInstaller
|
만약 gui가 제대로 나오지 않는 경우 아래 게시글 참고하여 gui 실행
참고 : 오라클 19c 설치 시 gui 창 띄우는 방법 ( https://positivemh.tistory.com/1367 )
실행 창 확인
Set Up Software Only 선택
Single Instance database installation 선택
Enterprise Edition 선택(23.26.2까지는 이 화면이 없었지만 23.26.3에서 생김)
Next 선택
Inventory 확인 후 Next 선택
Yes 선택
그룹 확인 후 Next 선택
root 권한으로 자동 스크립트 실행을 위해 root 유저 패스워드 입력
사전 요구사항 확인중
Linux10에서 compat-openssl11-1.1.1 패키지 에러는 버그로 무시 가능함
참고 : https://docs.oracle.com/en/database/oracle/oracle-database/26/rnrdm/bug-37983922.html
Install 선택
설치중
root 권한으로 자동 스크립트 실행 Yes 선택
Close 선택
26ai 엔진 설치 완료됨
리스너 설정
netca 진행
|
1
|
$ netca
|
Listener configuration 선택
Add 선택
리스너 이름 설정
Next 선택
Next 선택
리스너 포트 선택
No 선택
Next 선택
Finish 선택
이 절차를 마치면 리스너가 자동으로 기동되어 있음
DB 생성
dbca 진행
|
1
|
$ dbca
|
Create a database 선택
Advanced configuration 선택
Custom Database 선택
oracle SID 입력(이제 CDB 아키텍쳐가 필수가 됨)
Use template for the database storage attributes 선택
Next 선택
리스너 선택
LISTENER의 Status가 Down으로 표시된다면 리스너 수동으로 기동 필요
새로운 세션을 열어 oracle 유저에서 lsnrctl start 입력 후 gui에서 Next 선택
컴포넌트 모두 체크 해제
참고. Select AI를 사용하기 위해선 Oracle Text 체크 필요, Include in PDBs까지 체크
Memory 설정
Choose from the list of character sets 는 KO16MSWIN949 선택(요즘은 기본값인 AL32UTF8도 많이 사용함)
또는 UTF8 선택 가능
EM 체크 해제
admin 계정 패스워드 설정
Yes 선택
Create database 선택
필요시 Save Response File 선택 후 Finish
설치중
설치 완료됨
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
|
$ sqlplus / as sysdba
SQL*Plus: Release 23.26.3.0.0 - Production on Mon Aug 31 10:26:32 2026
Version 23.26.3.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.3.0.0 - Production
Version 23.26.3.0.0
SQL> select instance_name, version, status from v$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
ORACLE26 23.0.0.0.0 OPEN
SQL> set lines 200 pages 1000
SQL> select * from v$version;
BANNER
---------------------------------------------------------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY CON_ID
--------------------------------------------------------------------------------------------------------------------------------- ----------
Oracle AI Database 26ai Enterprise Edition Release 23.26.3.0.0 - Production
Oracle AI Database 26ai Enterprise Edition Release 23.26.3.0.0 - Production
Version 23.26.3.0.0
Oracle AI Database 26ai Enterprise Edition Release 23.26.3.0.0 - Production 0
|
정상적으로 설치됨
cdb 접속 테스트
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
$ sqlplus sys/oracle@localhost:1521/ORACLE26 as sysdba
SQL*Plus: Release 23.26.3.0.0 - Production on Mon Aug 31 10:55:56 2026
Version 23.26.3.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.3.0.0 - Production
Version 23.26.3.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
|
정상적으로 접속됨
pdb 접속 테스트
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
$ sqlplus sys/oracle@localhost:1521/ORACLE26PDB1 as sysdba
SQL*Plus: Release 23.26.3.0.0 - Production on Mon Aug 31 10:56:22 2026
Version 23.26.3.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.3.0.0 - Production
Version 23.26.3.0.0
SQL> show con_name
CON_NAME
------------------------------
ORACLE26PDB1
|
정상적으로 접속됨
참조 :
오라클 26ai(23ai) 게시물 모음 ( https://positivemh.tistory.com/1103 )
https://yum.oracle.com/oracle-linux-9.html
https://www.oracle.com/kr/database/container-database/
https://docs.oracle.com/en/database/oracle/oracle-database/26/rnrdm/bug-37983922.html
'ORACLE > Install' 카테고리의 다른 글
| 오라클 19c 싱글 환경 opatchauto 이용 19.32 RU 패치 가이드 (0) | 2026.08.23 |
|---|---|
| 오라클 26ai DBCA 이용 패치 가이드 (0) | 2026.08.20 |
| 오라클 19c Restart 환경 opatchauto 이용 19.31 RU 패치 가이드 (0) | 2026.06.23 |
| 오라클 19c Restart(ASM) to 싱글(FS) ADG 구성 가이드 (0) | 2026.06.08 |
| 오라클 19c RAC 환경 opatchauto 이용 19.31 RU 패치 가이드 (0) | 2026.06.07 |