准确的说,是Oracle 23ai Free Developer版,因为企业版目前只在云上(OCI和Azure)和ECC上提供。
方法包括3种,本文介绍第2种:
- Virtual Appliance
- RPM安装
- Docker
RPM安装支持Linux 8和Linux 9。由于官方的Virtualbox用的是8,所以我也使用Linux 8。
首先用Vagrant创建一个Oracle Linux 8的虚机,这个也就几分钟就自动安装成功了。
然后下载Linux 8版本的RPM文件:oracle-database-free-23ai-1.0-1.el8.x86_64.rpm,不到1.4GB。
然后就是安装和配置:
# 安装
dnf install -y oracle-database-free*
# 配置
/etc/init.d/oracle-free-23ai configure
下面是详细过程。
首先是安装,耗时5分多钟:
# time dnf install -y /vagrant/oracle-database-free*
Last metadata expiration check: 21:25:14 ago on Mon 06 May 2024 08:04:14 AM UTC.
Dependencies resolved.
=====================================================================================================================================
Package Architecture Version Repository Size
=====================================================================================================================================
Installing:
oracle-database-free-23ai x86_64 1.0-1 @commandline 1.3 G
Installing dependencies:
bc x86_64 1.07.1-5.el8 ol8_baseos_latest 129 k
bind-libs x86_64 32:9.11.36-11.el8_9.1 ol8_appstream 175 k
bind-libs-lite x86_64 32:9.11.36-11.el8_9.1 ol8_appstream 1.2 M
bind-license noarch 32:9.11.36-11.el8_9.1 ol8_appstream 103 k
bind-utils x86_64 32:9.11.36-11.el8_9.1 ol8_appstream 452 k
compat-openssl10 x86_64 1:1.0.2o-4.el8_6 ol8_appstream 1.1 M
dejavu-fonts-common noarch 2.35-7.el8 ol8_baseos_latest 74 k
dejavu-sans-fonts noarch 2.35-7.el8 ol8_baseos_latest 1.5 M
fontconfig x86_64 2.13.1-4.el8 ol8_baseos_latest 274 k
fontpackages-filesystem noarch 1.44-22.el8 ol8_baseos_latest 16 k
fstrm x86_64 0.6.1-3.el8 ol8_appstream 29 k
gssproxy x86_64 0.8.0-21.el8 ol8_baseos_latest 119 k
keyutils x86_64 1.5.10-9.el8 ol8_baseos_latest 66 k
ksh x86_64 20120801-259.0.1.el8 ol8_appstream 923 k
libICE x86_64 1.0.9-15.el8 ol8_appstream 74 k
libSM x86_64 1.2.3-1.el8 ol8_appstream 47 k
libX11 x86_64 1.6.8-6.el8 ol8_appstream 611 k
libX11-common noarch 1.6.8-6.el8 ol8_appstream 158 k
libX11-xcb x86_64 1.6.8-6.el8 ol8_appstream 14 k
libXau x86_64 1.0.9-3.el8 ol8_appstream 37 k
libXcomposite x86_64 0.4.4-14.el8 ol8_appstream 28 k
libXext x86_64 1.3.4-1.el8 ol8_appstream 45 k
libXi x86_64 1.7.10-1.el8 ol8_appstream 49 k
libXinerama x86_64 1.1.4-1.el8 ol8_appstream 15 k
libXmu x86_64 1.1.3-1.el8 ol8_appstream 75 k
libXrandr x86_64 1.5.2-1.el8 ol8_appstream 34 k
libXrender x86_64 0.9.10-7.el8 ol8_appstream 33 k
libXt x86_64 1.1.5-12.el8 ol8_appstream 185 k
libXtst x86_64 1.2.3-7.el8 ol8_appstream 22 k
libXv x86_64 1.0.11-7.el8 ol8_appstream 20 k
libXxf86dga x86_64 1.1.5-1.el8 ol8_appstream 26 k
libXxf86misc x86_64 1.0.4-1.el8 ol8_appstream 23 k
libXxf86vm x86_64 1.1.4-9.el8 ol8_appstream 19 k
libbasicobjects x86_64 0.1.1-40.el8 ol8_baseos_latest 31 k
libcollection x86_64 0.7.0-40.el8 ol8_baseos_latest 48 k
libdmx x86_64 1.1.4-3.el8 ol8_appstream 22 k
libev x86_64 4.24-6.el8 ol8_appstream 52 k
libini_config x86_64 1.3.1-40.el8 ol8_baseos_latest 70 k
libmaxminddb x86_64 1.2.0-10.el8_9.1 ol8_appstream 32 k
libnfsidmap x86_64 1:2.3.3-59.0.1.el8 ol8_baseos_latest 121 k
libpath_utils x86_64 0.2.1-40.el8 ol8_baseos_latest 34 k
libref_array x86_64 0.1.5-40.el8 ol8_baseos_latest 33 k
libverto-libev x86_64 0.3.2-2.el8 ol8_appstream 16 k
libxcb x86_64 1.13.1-1.el8 ol8_appstream 231 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k
net-tools x86_64 2.0-0.52.20160912git.el8 ol8_baseos_latest 322 k
nfs-utils x86_64 1:2.3.3-59.0.1.el8 ol8_baseos_latest 514 k
oracle-database-preinstall-23ai x86_64 1.0-2.el8 ol8_appstream 30 k
protobuf-c x86_64 1.3.0-8.el8 ol8_appstream 37 k
python3-bind noarch 32:9.11.36-11.el8_9.1 ol8_appstream 151 k
python3-ply noarch 3.9-9.el8 ol8_baseos_latest 111 k
python3-pyyaml x86_64 3.12-12.el8 ol8_baseos_latest 193 k
quota x86_64 1:4.04-14.el8 ol8_baseos_latest 214 k
quota-nls noarch 1:4.04-14.el8 ol8_baseos_latest 95 k
rpcbind x86_64 1.2.5-10.el8 ol8_baseos_latest 70 k
smartmontools x86_64 1:7.1-2.el8 ol8_baseos_latest 553 k
sysstat x86_64 11.7.3-11.0.1.el8 ol8_appstream 427 k
xorg-x11-utils x86_64 7.5-28.el8 ol8_appstream 136 k
xorg-x11-xauth x86_64 1:1.0.9-12.el8 ol8_appstream 39 k
Installing weak dependencies:
geolite2-city noarch 20180605-1.el8 ol8_appstream 19 M
geolite2-country noarch 20180605-1.el8 ol8_appstream 1.0 M
Transaction Summary
=====================================================================================================================================
Install 62 Packages
Total size: 1.3 G
Total download size: 31 M
Installed size: 3.6 G
Downloading Packages:
(1/61): dejavu-fonts-common-2.35-7.el8.noarch.rpm 178 kB/s | 74 kB 00:00
(2/61): bc-1.07.1-5.el8.x86_64.rpm 254 kB/s | 129 kB 00:00
(3/61): fontpackages-filesystem-1.44-22.el8.noarch.rpm 200 kB/s | 16 kB 00:00
(4/61): fontconfig-2.13.1-4.el8.x86_64.rpm 1.4 MB/s | 274 kB 00:00
(5/61): gssproxy-0.8.0-21.el8.x86_64.rpm 1.6 MB/s | 119 kB 00:00
(6/61): keyutils-1.5.10-9.el8.x86_64.rpm 788 kB/s | 66 kB 00:00
(7/61): libbasicobjects-0.1.1-40.el8.x86_64.rpm 458 kB/s | 31 kB 00:00
(8/61): dejavu-sans-fonts-2.35-7.el8.noarch.rpm 1.9 MB/s | 1.5 MB 00:00
(9/61): libcollection-0.7.0-40.el8.x86_64.rpm 486 kB/s | 48 kB 00:00
(10/61): libini_config-1.3.1-40.el8.x86_64.rpm 567 kB/s | 70 kB 00:00
(11/61): libnfsidmap-2.3.3-59.0.1.el8.x86_64.rpm 1.6 MB/s | 121 kB 00:00
(12/61): libpath_utils-0.2.1-40.el8.x86_64.rpm 456 kB/s | 34 kB 00:00
(13/61): libref_array-0.1.5-40.el8.x86_64.rpm 488 kB/s | 33 kB 00:00
(14/61): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 803 kB/s | 59 kB 00:00
(15/61): python3-ply-3.9-9.el8.noarch.rpm 1.5 MB/s | 111 kB 00:00
(16/61): net-tools-2.0-0.52.20160912git.el8.x86_64.rpm 2.1 MB/s | 322 kB 00:00
(17/61): nfs-utils-2.3.3-59.0.1.el8.x86_64.rpm 3.5 MB/s | 514 kB 00:00
(18/61): python3-pyyaml-3.12-12.el8.x86_64.rpm 2.5 MB/s | 193 kB 00:00
(19/61): quota-4.04-14.el8.x86_64.rpm 2.8 MB/s | 214 kB 00:00
(20/61): quota-nls-4.04-14.el8.noarch.rpm 1.3 MB/s | 95 kB 00:00
(21/61): rpcbind-1.2.5-10.el8.x86_64.rpm 953 kB/s | 70 kB 00:00
(22/61): bind-libs-9.11.36-11.el8_9.1.x86_64.rpm 2.3 MB/s | 175 kB 00:00
(23/61): smartmontools-7.1-2.el8.x86_64.rpm 3.9 MB/s | 553 kB 00:00
(24/61): bind-license-9.11.36-11.el8_9.1.noarch.rpm 1.3 MB/s | 103 kB 00:00
(25/61): bind-libs-lite-9.11.36-11.el8_9.1.x86_64.rpm 6.5 MB/s | 1.2 MB 00:00
(26/61): bind-utils-9.11.36-11.el8_9.1.x86_64.rpm 3.3 MB/s | 452 kB 00:00
(27/61): fstrm-0.6.1-3.el8.x86_64.rpm 421 kB/s | 29 kB 00:00
(28/61): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm 6.5 MB/s | 1.1 MB 00:00
(29/61): geolite2-country-20180605-1.el8.noarch.rpm 9.1 MB/s | 1.0 MB 00:00
(30/61): ksh-20120801-259.0.1.el8.x86_64.rpm 6.3 MB/s | 923 kB 00:00
(31/61): libICE-1.0.9-15.el8.x86_64.rpm 965 kB/s | 74 kB 00:00
(32/61): libSM-1.2.3-1.el8.x86_64.rpm 580 kB/s | 47 kB 00:00
(33/61): libX11-1.6.8-6.el8.x86_64.rpm 5.9 MB/s | 611 kB 00:00
(34/61): libX11-common-1.6.8-6.el8.noarch.rpm 1.5 MB/s | 158 kB 00:00
(35/61): libX11-xcb-1.6.8-6.el8.x86_64.rpm 175 kB/s | 14 kB 00:00
(36/61): libXau-1.0.9-3.el8.x86_64.rpm 358 kB/s | 37 kB 00:00
(37/61): libXcomposite-0.4.4-14.el8.x86_64.rpm 255 kB/s | 28 kB 00:00
(38/61): libXext-1.3.4-1.el8.x86_64.rpm 387 kB/s | 45 kB 00:00
(39/61): libXi-1.7.10-1.el8.x86_64.rpm 441 kB/s | 49 kB 00:00
(40/61): libXinerama-1.1.4-1.el8.x86_64.rpm 122 kB/s | 15 kB 00:00
(41/61): libXmu-1.1.3-1.el8.x86_64.rpm 594 kB/s | 75 kB 00:00
(42/61): libXrender-0.9.10-7.el8.x86_64.rpm 380 kB/s | 33 kB 00:00
(43/61): libXrandr-1.5.2-1.el8.x86_64.rpm 373 kB/s | 34 kB 00:00
(44/61): libXtst-1.2.3-7.el8.x86_64.rpm 208 kB/s | 22 kB 00:00
(45/61): libXt-1.1.5-12.el8.x86_64.rpm 1.6 MB/s | 185 kB 00:00
(46/61): geolite2-city-20180605-1.el8.noarch.rpm 18 MB/s | 19 MB 00:01
(47/61): libXv-1.0.11-7.el8.x86_64.rpm 225 kB/s | 20 kB 00:00
(48/61): libXxf86dga-1.1.5-1.el8.x86_64.rpm 304 kB/s | 26 kB 00:00
(49/61): libXxf86misc-1.0.4-1.el8.x86_64.rpm 328 kB/s | 23 kB 00:00
(50/61): libXxf86vm-1.1.4-9.el8.x86_64.rpm 267 kB/s | 19 kB 00:00
(51/61): libdmx-1.1.4-3.el8.x86_64.rpm 311 kB/s | 22 kB 00:00
(52/61): libev-4.24-6.el8.x86_64.rpm 779 kB/s | 52 kB 00:00
(53/61): libverto-libev-0.3.2-2.el8.x86_64.rpm 245 kB/s | 16 kB 00:00
(54/61): libmaxminddb-1.2.0-10.el8_9.1.x86_64.rpm 472 kB/s | 32 kB 00:00
(55/61): oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm 422 kB/s | 30 kB 00:00
(56/61): protobuf-c-1.3.0-8.el8.x86_64.rpm 514 kB/s | 37 kB 00:00
(57/61): libxcb-1.13.1-1.el8.x86_64.rpm 2.8 MB/s | 231 kB 00:00
(58/61): python3-bind-9.11.36-11.el8_9.1.noarch.rpm 1.9 MB/s | 151 kB 00:00
(59/61): xorg-x11-utils-7.5-28.el8.x86_64.rpm 1.5 MB/s | 136 kB 00:00
(60/61): sysstat-11.7.3-11.0.1.el8.x86_64.rpm 4.5 MB/s | 427 kB 00:00
(61/61): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 514 kB/s | 39 kB 00:00
-------------------------------------------------------------------------------------------------------------------------------------
Total 11 MB/s | 31 MB 00:02
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : protobuf-c-1.3.0-8.el8.x86_64 1/62
Installing : fstrm-0.6.1-3.el8.x86_64 2/62
Installing : bind-license-32:9.11.36-11.el8_9.1.noarch 3/62
Installing : libXau-1.0.9-3.el8.x86_64 4/62
Installing : libxcb-1.13.1-1.el8.x86_64 5/62
Installing : libICE-1.0.9-15.el8.x86_64 6/62
Installing : net-tools-2.0-0.52.20160912git.el8.x86_64 7/62
Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64 7/62
Installing : libref_array-0.1.5-40.el8.x86_64 8/62
Installing : libcollection-0.7.0-40.el8.x86_64 9/62
Installing : libbasicobjects-0.1.1-40.el8.x86_64 10/62
Installing : fontpackages-filesystem-1.44-22.el8.noarch 11/62
Installing : dejavu-fonts-common-2.35-7.el8.noarch 12/62
Installing : dejavu-sans-fonts-2.35-7.el8.noarch 13/62
Installing : fontconfig-2.13.1-4.el8.x86_64 14/62
Running scriptlet: fontconfig-2.13.1-4.el8.x86_64 14/62
Installing : libSM-1.2.3-1.el8.x86_64 15/62
Installing : libev-4.24-6.el8.x86_64 16/62
Installing : libverto-libev-0.3.2-2.el8.x86_64 17/62
Installing : libX11-xcb-1.6.8-6.el8.x86_64 18/62
Installing : libX11-common-1.6.8-6.el8.noarch 19/62
Installing : libX11-1.6.8-6.el8.x86_64 20/62
Installing : libXext-1.3.4-1.el8.x86_64 21/62
Installing : libXi-1.7.10-1.el8.x86_64 22/62
Installing : libXrender-0.9.10-7.el8.x86_64 23/62
Installing : libXrandr-1.5.2-1.el8.x86_64 24/62
Installing : libXtst-1.2.3-7.el8.x86_64 25/62
Installing : libXinerama-1.1.4-1.el8.x86_64 26/62
Installing : libXv-1.0.11-7.el8.x86_64 27/62
Installing : libXxf86dga-1.1.5-1.el8.x86_64 28/62
Installing : libXxf86misc-1.0.4-1.el8.x86_64 29/62
Installing : libXxf86vm-1.1.4-9.el8.x86_64 30/62
Installing : libdmx-1.1.4-3.el8.x86_64 31/62
Installing : libXcomposite-0.4.4-14.el8.x86_64 32/62
Installing : xorg-x11-utils-7.5-28.el8.x86_64 33/62
Installing : libXt-1.1.5-12.el8.x86_64 34/62
Installing : libXmu-1.1.3-1.el8.x86_64 35/62
Installing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 36/62
Installing : ksh-20120801-259.0.1.el8.x86_64 37/62
Running scriptlet: ksh-20120801-259.0.1.el8.x86_64 37/62
Installing : geolite2-country-20180605-1.el8.noarch 38/62
Installing : geolite2-city-20180605-1.el8.noarch 39/62
Installing : libmaxminddb-1.2.0-10.el8_9.1.x86_64 40/62
Running scriptlet: libmaxminddb-1.2.0-10.el8_9.1.x86_64 40/62
Installing : bind-libs-lite-32:9.11.36-11.el8_9.1.x86_64 41/62
Installing : bind-libs-32:9.11.36-11.el8_9.1.x86_64 42/62
Installing : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 43/62
Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64 43/62
Running scriptlet: smartmontools-1:7.1-2.el8.x86_64 44/62
Installing : smartmontools-1:7.1-2.el8.x86_64 44/62
Running scriptlet: smartmontools-1:7.1-2.el8.x86_64 44/62
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 45/62
Installing : rpcbind-1.2.5-10.el8.x86_64 45/62
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 45/62
Installing : quota-nls-1:4.04-14.el8.noarch 46/62
Installing : quota-1:4.04-14.el8.x86_64 47/62
Installing : python3-pyyaml-3.12-12.el8.x86_64 48/62
Installing : python3-ply-3.9-9.el8.noarch 49/62
Installing : python3-bind-32:9.11.36-11.el8_9.1.noarch 50/62
Installing : bind-utils-32:9.11.36-11.el8_9.1.x86_64 51/62
Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 52/62
Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 52/62
Installing : sysstat-11.7.3-11.0.1.el8.x86_64 53/62
Running scriptlet: sysstat-11.7.3-11.0.1.el8.x86_64 53/62
Installing : libpath_utils-0.2.1-40.el8.x86_64 54/62
Installing : libini_config-1.3.1-40.el8.x86_64 55/62
Installing : gssproxy-0.8.0-21.el8.x86_64 56/62
Running scriptlet: gssproxy-0.8.0-21.el8.x86_64 56/62
Installing : libnfsidmap-1:2.3.3-59.0.1.el8.x86_64 57/62
Installing : keyutils-1.5.10-9.el8.x86_64 58/62
Running scriptlet: nfs-utils-1:2.3.3-59.0.1.el8.x86_64 59/62
Installing : nfs-utils-1:2.3.3-59.0.1.el8.x86_64 59/62
Running scriptlet: nfs-utils-1:2.3.3-59.0.1.el8.x86_64 59/62
Installing : bc-1.07.1-5.el8.x86_64 60/62
Running scriptlet: bc-1.07.1-5.el8.x86_64 60/62
Installing : oracle-database-preinstall-23ai-1.0-2.el8.x86_64 61/62
Running scriptlet: oracle-database-free-23ai-1.0-1.x86_64 62/62
Installing : oracle-database-free-23ai-1.0-1.x86_64 62/62
Running scriptlet: oracle-database-free-23ai-1.0-1.x86_64 62/62
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23ai.conf' and then run '/etc/init.d/oracle-free-23ai configure' as root.
Running scriptlet: oracle-database-preinstall-23ai-1.0-2.el8.x86_64 62/62
Running scriptlet: oracle-database-free-23ai-1.0-1.x86_64 62/62
Running scriptlet: fontconfig-2.13.1-4.el8.x86_64 62/62
Verifying : bc-1.07.1-5.el8.x86_64 1/62
Verifying : dejavu-fonts-common-2.35-7.el8.noarch 2/62
Verifying : dejavu-sans-fonts-2.35-7.el8.noarch 3/62
Verifying : fontconfig-2.13.1-4.el8.x86_64 4/62
Verifying : fontpackages-filesystem-1.44-22.el8.noarch 5/62
Verifying : gssproxy-0.8.0-21.el8.x86_64 6/62
Verifying : keyutils-1.5.10-9.el8.x86_64 7/62
Verifying : libbasicobjects-0.1.1-40.el8.x86_64 8/62
Verifying : libcollection-0.7.0-40.el8.x86_64 9/62
Verifying : libini_config-1.3.1-40.el8.x86_64 10/62
Verifying : libnfsidmap-1:2.3.3-59.0.1.el8.x86_64 11/62
Verifying : libpath_utils-0.2.1-40.el8.x86_64 12/62
Verifying : libref_array-0.1.5-40.el8.x86_64 13/62
Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 14/62
Verifying : net-tools-2.0-0.52.20160912git.el8.x86_64 15/62
Verifying : nfs-utils-1:2.3.3-59.0.1.el8.x86_64 16/62
Verifying : python3-ply-3.9-9.el8.noarch 17/62
Verifying : python3-pyyaml-3.12-12.el8.x86_64 18/62
Verifying : quota-1:4.04-14.el8.x86_64 19/62
Verifying : quota-nls-1:4.04-14.el8.noarch 20/62
Verifying : rpcbind-1.2.5-10.el8.x86_64 21/62
Verifying : smartmontools-1:7.1-2.el8.x86_64 22/62
Verifying : bind-libs-32:9.11.36-11.el8_9.1.x86_64 23/62
Verifying : bind-libs-lite-32:9.11.36-11.el8_9.1.x86_64 24/62
Verifying : bind-license-32:9.11.36-11.el8_9.1.noarch 25/62
Verifying : bind-utils-32:9.11.36-11.el8_9.1.x86_64 26/62
Verifying : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 27/62
Verifying : fstrm-0.6.1-3.el8.x86_64 28/62
Verifying : geolite2-city-20180605-1.el8.noarch 29/62
Verifying : geolite2-country-20180605-1.el8.noarch 30/62
Verifying : ksh-20120801-259.0.1.el8.x86_64 31/62
Verifying : libICE-1.0.9-15.el8.x86_64 32/62
Verifying : libSM-1.2.3-1.el8.x86_64 33/62
Verifying : libX11-1.6.8-6.el8.x86_64 34/62
Verifying : libX11-common-1.6.8-6.el8.noarch 35/62
Verifying : libX11-xcb-1.6.8-6.el8.x86_64 36/62
Verifying : libXau-1.0.9-3.el8.x86_64 37/62
Verifying : libXcomposite-0.4.4-14.el8.x86_64 38/62
Verifying : libXext-1.3.4-1.el8.x86_64 39/62
Verifying : libXi-1.7.10-1.el8.x86_64 40/62
Verifying : libXinerama-1.1.4-1.el8.x86_64 41/62
Verifying : libXmu-1.1.3-1.el8.x86_64 42/62
Verifying : libXrandr-1.5.2-1.el8.x86_64 43/62
Verifying : libXrender-0.9.10-7.el8.x86_64 44/62
Verifying : libXt-1.1.5-12.el8.x86_64 45/62
Verifying : libXtst-1.2.3-7.el8.x86_64 46/62
Verifying : libXv-1.0.11-7.el8.x86_64 47/62
Verifying : libXxf86dga-1.1.5-1.el8.x86_64 48/62
Verifying : libXxf86misc-1.0.4-1.el8.x86_64 49/62
Verifying : libXxf86vm-1.1.4-9.el8.x86_64 50/62
Verifying : libdmx-1.1.4-3.el8.x86_64 51/62
Verifying : libev-4.24-6.el8.x86_64 52/62
Verifying : libmaxminddb-1.2.0-10.el8_9.1.x86_64 53/62
Verifying : libverto-libev-0.3.2-2.el8.x86_64 54/62
Verifying : libxcb-1.13.1-1.el8.x86_64 55/62
Verifying : oracle-database-preinstall-23ai-1.0-2.el8.x86_64 56/62
Verifying : protobuf-c-1.3.0-8.el8.x86_64 57/62
Verifying : python3-bind-32:9.11.36-11.el8_9.1.noarch 58/62
Verifying : sysstat-11.7.3-11.0.1.el8.x86_64 59/62
Verifying : xorg-x11-utils-7.5-28.el8.x86_64 60/62
Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 61/62
Verifying : oracle-database-free-23ai-1.0-1.x86_64 62/62
Installed:
bc-1.07.1-5.el8.x86_64 bind-libs-32:9.11.36-11.el8_9.1.x86_64
bind-libs-lite-32:9.11.36-11.el8_9.1.x86_64 bind-license-32:9.11.36-11.el8_9.1.noarch
bind-utils-32:9.11.36-11.el8_9.1.x86_64 compat-openssl10-1:1.0.2o-4.el8_6.x86_64
dejavu-fonts-common-2.35-7.el8.noarch dejavu-sans-fonts-2.35-7.el8.noarch
fontconfig-2.13.1-4.el8.x86_64 fontpackages-filesystem-1.44-22.el8.noarch
fstrm-0.6.1-3.el8.x86_64 geolite2-city-20180605-1.el8.noarch
geolite2-country-20180605-1.el8.noarch gssproxy-0.8.0-21.el8.x86_64
keyutils-1.5.10-9.el8.x86_64 ksh-20120801-259.0.1.el8.x86_64
libICE-1.0.9-15.el8.x86_64 libSM-1.2.3-1.el8.x86_64
libX11-1.6.8-6.el8.x86_64 libX11-common-1.6.8-6.el8.noarch
libX11-xcb-1.6.8-6.el8.x86_64 libXau-1.0.9-3.el8.x86_64
libXcomposite-0.4.4-14.el8.x86_64 libXext-1.3.4-1.el8.x86_64
libXi-1.7.10-1.el8.x86_64 libXinerama-1.1.4-1.el8.x86_64
libXmu-1.1.3-1.el8.x86_64 libXrandr-1.5.2-1.el8.x86_64
libXrender-0.9.10-7.el8.x86_64 libXt-1.1.5-12.el8.x86_64
libXtst-1.2.3-7.el8.x86_64 libXv-1.0.11-7.el8.x86_64
libXxf86dga-1.1.5-1.el8.x86_64 libXxf86misc-1.0.4-1.el8.x86_64
libXxf86vm-1.1.4-9.el8.x86_64 libbasicobjects-0.1.1-40.el8.x86_64
libcollection-0.7.0-40.el8.x86_64 libdmx-1.1.4-3.el8.x86_64
libev-4.24-6.el8.x86_64 libini_config-1.3.1-40.el8.x86_64
libmaxminddb-1.2.0-10.el8_9.1.x86_64 libnfsidmap-1:2.3.3-59.0.1.el8.x86_64
libpath_utils-0.2.1-40.el8.x86_64 libref_array-0.1.5-40.el8.x86_64
libverto-libev-0.3.2-2.el8.x86_64 libxcb-1.13.1-1.el8.x86_64
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 net-tools-2.0-0.52.20160912git.el8.x86_64
nfs-utils-1:2.3.3-59.0.1.el8.x86_64 oracle-database-free-23ai-1.0-1.x86_64
oracle-database-preinstall-23ai-1.0-2.el8.x86_64 protobuf-c-1.3.0-8.el8.x86_64
python3-bind-32:9.11.36-11.el8_9.1.noarch python3-ply-3.9-9.el8.noarch
python3-pyyaml-3.12-12.el8.x86_64 quota-1:4.04-14.el8.x86_64
quota-nls-1:4.04-14.el8.noarch rpcbind-1.2.5-10.el8.x86_64
smartmontools-1:7.1-2.el8.x86_64 sysstat-11.7.3-11.0.1.el8.x86_64
xorg-x11-utils-7.5-28.el8.x86_64 xorg-x11-xauth-1:1.0.9-12.el8.x86_64
Complete!
real 5m22.969s
user 3m44.503s
sys 1m13.053s
然后是配置,第一次失败了:
# time /etc/init.d/oracle-free-23ai 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:
Confirm the password:
Configuring Oracle Listener.
Listener configuration failed. Check log '/opt/oracle/cfgtoollogs/netca/netca_configure_out.log' for more details.
real 0m14.323s
user 0m6.033s
sys 0m0.765s
[root@ol8-vagrant vagrant]# echo $?
1
原因为No valid IP Address returned for the host ol8-vagrant.
:
# cat /opt/oracle/cfgtoollogs/netca/netca_configure_out.log
Netca configuration log
Parsing command line arguments:
Parameter "orahome" = /opt/oracle/product/23ai/dbhomeFree
Parameter "instype" = typical
Parameter "inscomp" = client,oraclenet,javavm,server,ano
Parameter "insprtcl" = tcp
Parameter "cfg" = local
Parameter "authadp" = NO_VALUE
Parameter "responsefile" = /opt/oracle/product/23ai/dbhomeFree/network/install/netca_typ.rsp
Parameter "silent" = true
Parameter "orahnam" = OraHomeFree
Parameter "listenerparameters" = DEFAULT_SERVICE=FREE
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
No valid IP Address returned for the host ol8-vagrant.
Check the trace file for details: /opt/oracle/cfgtoollogs/netca/trace_OraDBHome23aiFree-2405077AM1647.log
Oracle Net Services configuration failed. The exit code is 1
设一下主机名就好了,然后配置花了近9分钟:
[root@ol8-vagrant vagrant]# hostname ol8-vagrant
[root@ol8-vagrant vagrant]# hostname
ol8-vagrant
# time /etc/init.d/oracle-free-23ai 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:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle 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 Database using one of the connect strings:
Pluggable database: ol8-vagrant:1539/FREEPDB1
Multitenant container database: ol8-vagrant:1539
real 8m46.779s
user 0m36.732s
sys 0m5.915s
还需要设置环境变量,才能登录数据库。如何设?我抄了VIrtual Appliance(第1种方法)的作业。
export ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree
export ORACLE_SID=FREE
export PATH=/home/oracle/bin:/home/oracle/LDLIB:/opt/oracle/product/23ai/dbhomeFree/bin:/usr/sbin:/home/oracle/java/jdk-11.0.20/bin:/home/oracle/bin:/home/oracle/sqlcl/bin:/home/oracle/sqldeveloper:/home/oracle/datamodeler:/home/oracle/.local/bin:/home/oracle/bin:/usr/share/Modules/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/home/oracle/sqlcl/bin:/home/oracle/sqldeveloper:/home/oracle/bin
然后数据库就可以登录了:
$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Production on Tue May 7 08:14:26 2024
Version 23.4.0.24.05
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
SQL> select current_timestamp;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
07-MAY-24 08.16.49.195280 AM +00:00
注意
一个注意事项是监听端口为1539,而非默认的1521。
$ lsnrctl status
LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 07-MAY-2024 14:58:01
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol8-vagrant)(PORT=1539)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 23.0.0.0.0 - Production
Start Date 07-MAY-2024 14:56:40
Uptime 0 days 0 hr. 1 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service FREE
Listener Parameter File /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/ol8-vagrant/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ol8-vagrant)(PORT=1539)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "17d923f8233d5239e0630101007f7eef" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "FREE" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "FREEXDB" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "freepdb1" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
The command completed successfully
所以登录数据库要改端口,系统口令为oracle:
-- 登录PDB
sqlplus sys@localhost:1539/FREEPDB1 as sysdba
-- 登录CDB
sqlplus sys@localhost:1539/FREE as sysdba
问题
第一个问题是oracle的根目录没有建立:
[root@ol8-vagrant vagrant]# su - oracle
su: warning: cannot change directory to /home/oracle: No such file or directory
虽然你也可以补建一个,但原因不明:
mkdir /home/oracle
chown oracle:oinstall /home/oracle
第二个问题是第一次配置失败的原因还不清楚。
这2个问题需要再做一次实验看看。
存照留念:
参考链接
- Oracle Database Free Get Started
- 23ai Virtual Appliance下载地址