Neste artigo será mostrado apenas a etapa de instalação do Oracle Database 23c, não sendo abordada a etapa de instalação do sistema operacional. Caso necessário, é possível utilizar como base para instalação do sistema operacional, o artigo Instalação básica do Oracle Linux.
Recurso utilizado: Maquina virtual (criada no virtual box) com Oracle Linux 8.7, 2GB de RAM, 50GB de disco e 2 cores.
O primeiro passo necessário é efetuar o download do Oracle 23c, que encontra-se no link: download do Oracle Database 23c Free (Developer-Release).
Neste exemplo o arquivo foi baixado e enviado ao diretório /tmp do servidor onde será instalado.
[root@oracle23c tmp]# [root@oracle23c tmp]# ls -ltr oracle-database-free-23c-1.0-1.el8.x86_64.rpm -rw-r--r--. 1 root root 1758776440 May 6 18:14 oracle-database-free-23c-1.0-1.el8.x86_64.rpm [root@oracle23c tmp]#
Feito download, podemos instalar os pre requisitos, executando com o root o oraclelinux-developer-release-el8 e o oracle-database-preinstall-23c.
dnf install -y oraclelinux-developer-release-el8
[root@oracle23c tmp]# dnf install -y oraclelinux-developer-release-el8 Last metadata expiration check: 2:25:00 ago on Sun 07 May 2023 03:47:12 PM -03. Dependencies resolved. ============================================================================================================================================================================================= Package Architecture Version Repository Size ============================================================================================================================================================================================= Installing: oraclelinux-developer-release-el8 x86_64 1.0-7.el8 ol8_baseos_latest 16 k Transaction Summary ============================================================================================================================================================================================= Install 1 Package Total download size: 16 k Installed size: 18 k Downloading Packages: oraclelinux-developer-release-el8-1.0-7.el8.x86_64.rpm 24 kB/s | 16 kB 00:00 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 24 kB/s | 16 kB 00:00 Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : oraclelinux-developer-release-el8-1.0-7.el8.x86_64 1/1 Verifying : oraclelinux-developer-release-el8-1.0-7.el8.x86_64 1/1 Installed: oraclelinux-developer-release-el8-1.0-7.el8.x86_64 Complete! [root@oracle23c tmp]#
dnf install -y oracle-database-preinstall-23c
[root@oracle23c tmp]# [root@oracle23c tmp]# dnf install -y oracle-database-preinstall-23c Last metadata expiration check: 0:02:16 ago on Sun 07 May 2023 06:12:28 PM -03. Dependencies resolved. ============================================================================================================================================================================================= Package Architecture Version Repository Size ============================================================================================================================================================================================= Installing: oracle-database-preinstall-23c x86_64 1.0-0.5.el8 ol8_developer 30 k Installing dependencies: bc x86_64 1.07.1-5.el8 ol8_baseos_latest 129 k bind-libs x86_64 32:9.11.36-5.el8_7.2 ol8_appstream 175 k bind-libs-lite x86_64 32:9.11.36-5.el8_7.2 ol8_appstream 1.2 M bind-license noarch 32:9.11.36-5.el8_7.2 ol8_appstream 104 k bind-utils x86_64 32:9.11.36-5.el8_7.2 ol8_appstream 452 k binutils x86_64 2.30-117.0.3.el8 ol8_baseos_latest 5.9 M checkpolicy x86_64 2.9-1.el8 ol8_baseos_latest 346 k compat-openssl10 x86_64 1:1.0.2o-4.el8_6 ol8_appstream 1.1 M fstrm x86_64 0.6.1-3.el8 ol8_appstream 29 k glibc-devel x86_64 2.28-211.0.1.el8 ol8_baseos_latest 83 k glibc-headers x86_64 2.28-211.0.1.el8 ol8_baseos_latest 488 k gssproxy x86_64 0.8.0-21.el8 ol8_baseos_latest 119 k kernel-headers x86_64 4.18.0-425.19.2.el8_7 ol8_baseos_latest 10 M keyutils x86_64 1.5.10-9.el8 ol8_baseos_latest 66 k ksh x86_64 20120801-257.0.1.el8 ol8_appstream 929 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-5.el8 ol8_appstream 611 k libX11-common noarch 1.6.8-5.el8 ol8_appstream 158 k libX11-xcb x86_64 1.6.8-5.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 libdmx x86_64 1.1.4-3.el8 ol8_appstream 22 k libev x86_64 4.24-6.el8 ol8_appstream 52 k libmaxminddb x86_64 1.2.0-10.el8 ol8_appstream 33 k libnsl x86_64 2.28-211.0.1.el8 ol8_baseos_latest 105 k libpkgconf x86_64 1.4.2-1.el8 ol8_baseos_latest 35 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 libxcrypt-devel x86_64 4.1.1-6.el8 ol8_baseos_latest 25 k lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k make x86_64 1:4.2.1-11.el8 ol8_baseos_latest 498 k net-tools x86_64 2.0-0.52.20160912git.el8 ol8_baseos_latest 322 k nfs-utils x86_64 1:2.3.3-57.el8_7.1 ol8_baseos_latest 515 k pkgconf x86_64 1.4.2-1.el8 ol8_baseos_latest 38 k pkgconf-m4 noarch 1.4.2-1.el8 ol8_baseos_latest 17 k pkgconf-pkg-config x86_64 1.4.2-1.el8 ol8_baseos_latest 15 k policycoreutils-python-utils noarch 2.9-20.0.1.el8 ol8_baseos_latest 253 k protobuf-c x86_64 1.3.0-6.el8 ol8_appstream 37 k python3-audit x86_64 3.0.7-4.el8 ol8_baseos_latest 87 k python3-bind noarch 32:9.11.36-5.el8_7.2 ol8_appstream 151 k python3-libsemanage x86_64 2.9-9.el8 ol8_baseos_latest 128 k python3-policycoreutils noarch 2.9-20.0.1.el8 ol8_baseos_latest 2.2 M python3-pyyaml x86_64 5.4.1-1.0.1.el8 ol8_developer 205 k python3-setools x86_64 4.3.0-3.el8 ol8_baseos_latest 624 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-1.el8 ol8_baseos_latest 544 k sysstat x86_64 11.7.3-7.0.1.el8_7.1 ol8_appstream 426 k tar x86_64 2:1.30-6.el8_7.1 ol8_baseos_latest 838 k unzip x86_64 6.0-46.0.1.el8 ol8_baseos_latest 196 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 69 Packages Total download size: 51 M Installed size: 129 M Downloading Packages: (1/69): bc-1.07.1-5.el8.x86_64.rpm 179 kB/s | 129 kB 00:00 (2/69): checkpolicy-2.9-1.el8.x86_64.rpm 477 kB/s | 346 kB 00:00 (3/69): glibc-devel-2.28-211.0.1.el8.x86_64.rpm 952 kB/s | 83 kB 00:00 (4/69): glibc-headers-2.28-211.0.1.el8.x86_64.rpm 2.2 MB/s | 488 kB 00:00 (5/69): gssproxy-0.8.0-21.el8.x86_64.rpm 827 kB/s | 119 kB 00:00 (6/69): keyutils-1.5.10-9.el8.x86_64.rpm 846 kB/s | 66 kB 00:00 (7/69): libnsl-2.28-211.0.1.el8.x86_64.rpm 1.0 MB/s | 105 kB 00:00 (8/69): libpkgconf-1.4.2-1.el8.x86_64.rpm 458 kB/s | 35 kB 00:00 (9/69): libxcrypt-devel-4.1.1-6.el8.x86_64.rpm 314 kB/s | 25 kB 00:00 (10/69): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 784 kB/s | 59 kB 00:00 (11/69): make-4.2.1-11.el8.x86_64.rpm 1.5 MB/s | 498 kB 00:00 (12/69): net-tools-2.0-0.52.20160912git.el8.x86_64.rpm 1.4 MB/s | 322 kB 00:00 (13/69): nfs-utils-2.3.3-57.el8_7.1.x86_64.rpm 1.5 MB/s | 515 kB 00:00 (14/69): pkgconf-1.4.2-1.el8.x86_64.rpm 423 kB/s | 38 kB 00:00 (15/69): binutils-2.30-117.0.3.el8.x86_64.rpm 2.4 MB/s | 5.9 MB 00:02 (16/69): pkgconf-m4-1.4.2-1.el8.noarch.rpm 182 kB/s | 17 kB 00:00 (17/69): pkgconf-pkg-config-1.4.2-1.el8.x86_64.rpm 609 kB/s | 15 kB 00:00 (18/69): python3-audit-3.0.7-4.el8.x86_64.rpm 1.5 MB/s | 87 kB 00:00 (19/69): policycoreutils-python-utils-2.9-20.0.1.el8.noarch.rpm 1.7 MB/s | 253 kB 00:00 (20/69): python3-libsemanage-2.9-9.el8.x86_64.rpm 1.9 MB/s | 128 kB 00:00 (21/69): python3-setools-4.3.0-3.el8.x86_64.rpm 1.1 MB/s | 624 kB 00:00 (22/69): kernel-headers-4.18.0-425.19.2.el8_7.x86_64.rpm 4.5 MB/s | 10 MB 00:02 (23/69): quota-4.04-14.el8.x86_64.rpm 2.3 MB/s | 214 kB 00:00 (24/69): quota-nls-4.04-14.el8.noarch.rpm 2.8 MB/s | 95 kB 00:00 (25/69): rpcbind-1.2.5-10.el8.x86_64.rpm 1.7 MB/s | 70 kB 00:00 (26/69): smartmontools-7.1-1.el8.x86_64.rpm 5.6 MB/s | 544 kB 00:00 (27/69): unzip-6.0-46.0.1.el8.x86_64.rpm 4.5 MB/s | 196 kB 00:00 (28/69): bind-libs-9.11.36-5.el8_7.2.x86_64.rpm 3.1 MB/s | 175 kB 00:00 (29/69): tar-1.30-6.el8_7.1.x86_64.rpm 1.7 MB/s | 838 kB 00:00 (30/69): bind-libs-lite-9.11.36-5.el8_7.2.x86_64.rpm 3.1 MB/s | 1.2 MB 00:00 (31/69): bind-license-9.11.36-5.el8_7.2.noarch.rpm 1.9 MB/s | 104 kB 00:00 (32/69): bind-utils-9.11.36-5.el8_7.2.x86_64.rpm 2.3 MB/s | 452 kB 00:00 (33/69): fstrm-0.6.1-3.el8.x86_64.rpm 268 kB/s | 29 kB 00:00 (34/69): python3-policycoreutils-2.9-20.0.1.el8.noarch.rpm 1.4 MB/s | 2.2 MB 00:01 (35/69): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm 1.7 MB/s | 1.1 MB 00:00 (36/69): geolite2-country-20180605-1.el8.noarch.rpm 1.6 MB/s | 1.0 MB 00:00 (37/69): libICE-1.0.9-15.el8.x86_64.rpm 811 kB/s | 74 kB 00:00 (38/69): ksh-20120801-257.0.1.el8.x86_64.rpm 2.0 MB/s | 929 kB 00:00 (39/69): libSM-1.2.3-1.el8.x86_64.rpm 806 kB/s | 47 kB 00:00 (40/69): libX11-common-1.6.8-5.el8.noarch.rpm 852 kB/s | 158 kB 00:00 (41/69): libX11-xcb-1.6.8-5.el8.x86_64.rpm 97 kB/s | 14 kB 00:00 (42/69): libX11-1.6.8-5.el8.x86_64.rpm 1.7 MB/s | 611 kB 00:00 (43/69): libXcomposite-0.4.4-14.el8.x86_64.rpm 569 kB/s | 28 kB 00:00 (44/69): libXau-1.0.9-3.el8.x86_64.rpm 666 kB/s | 37 kB 00:00 (45/69): libXi-1.7.10-1.el8.x86_64.rpm 414 kB/s | 49 kB 00:00 (46/69): libXext-1.3.4-1.el8.x86_64.rpm 359 kB/s | 45 kB 00:00 (47/69): libXinerama-1.1.4-1.el8.x86_64.rpm 272 kB/s | 15 kB 00:00 (48/69): libXrandr-1.5.2-1.el8.x86_64.rpm 569 kB/s | 34 kB 00:00 (49/69): libXmu-1.1.3-1.el8.x86_64.rpm 575 kB/s | 75 kB 00:00 (50/69): libXrender-0.9.10-7.el8.x86_64.rpm 769 kB/s | 33 kB 00:00 (51/69): libXtst-1.2.3-7.el8.x86_64.rpm 148 kB/s | 22 kB 00:00 (52/69): libXv-1.0.11-7.el8.x86_64.rpm 131 kB/s | 20 kB 00:00 (53/69): libXt-1.1.5-12.el8.x86_64.rpm 576 kB/s | 185 kB 00:00 (54/69): libXxf86misc-1.0.4-1.el8.x86_64.rpm 125 kB/s | 23 kB 00:00 (55/69): libXxf86dga-1.1.5-1.el8.x86_64.rpm 137 kB/s | 26 kB 00:00 (56/69): libXxf86vm-1.1.4-9.el8.x86_64.rpm 234 kB/s | 19 kB 00:00 (57/69): libdmx-1.1.4-3.el8.x86_64.rpm 271 kB/s | 22 kB 00:00 (58/69): libev-4.24-6.el8.x86_64.rpm 928 kB/s | 52 kB 00:00 (59/69): libmaxminddb-1.2.0-10.el8.x86_64.rpm 526 kB/s | 33 kB 00:00 (60/69): libverto-libev-0.3.2-2.el8.x86_64.rpm 509 kB/s | 16 kB 00:00 (61/69): protobuf-c-1.3.0-6.el8.x86_64.rpm 1.0 MB/s | 37 kB 00:00 (62/69): libxcb-1.13.1-1.el8.x86_64.rpm 2.0 MB/s | 231 kB 00:00 (63/69): python3-bind-9.11.36-5.el8_7.2.noarch.rpm 1.7 MB/s | 151 kB 00:00 (64/69): xorg-x11-utils-7.5-28.el8.x86_64.rpm 1.6 MB/s | 136 kB 00:00 (65/69): sysstat-11.7.3-7.0.1.el8_7.1.x86_64.rpm 2.1 MB/s | 426 kB 00:00 (66/69): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 490 kB/s | 39 kB 00:00 (67/69): oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm 674 kB/s | 30 kB 00:00 (68/69): python3-pyyaml-5.4.1-1.0.1.el8.x86_64.rpm 1.4 MB/s | 205 kB 00:00 (69/69): geolite2-city-20180605-1.el8.noarch.rpm 6.0 MB/s | 19 MB 00:03 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 7.0 MB/s | 51 MB 00:07 Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : protobuf-c-1.3.0-6.el8.x86_64 1/69 Installing : fstrm-0.6.1-3.el8.x86_64 2/69 Installing : bind-license-32:9.11.36-5.el8_7.2.noarch 3/69 Installing : libXau-1.0.9-3.el8.x86_64 4/69 Installing : libxcb-1.13.1-1.el8.x86_64 5/69 Installing : libICE-1.0.9-15.el8.x86_64 6/69 Installing : make-1:4.2.1-11.el8.x86_64 7/69 Running scriptlet: make-1:4.2.1-11.el8.x86_64 7/69 Installing : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 8/69 Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64 8/69 Installing : libSM-1.2.3-1.el8.x86_64 9/69 Installing : python3-bind-32:9.11.36-5.el8_7.2.noarch 10/69 Installing : python3-pyyaml-5.4.1-1.0.1.el8.x86_64 11/69 Installing : libev-4.24-6.el8.x86_64 12/69 Installing : libverto-libev-0.3.2-2.el8.x86_64 13/69 Installing : gssproxy-0.8.0-21.el8.x86_64 14/69 Running scriptlet: gssproxy-0.8.0-21.el8.x86_64 14/69 Installing : libX11-xcb-1.6.8-5.el8.x86_64 15/69 Installing : libX11-common-1.6.8-5.el8.noarch 16/69 Installing : libX11-1.6.8-5.el8.x86_64 17/69 Installing : libXext-1.3.4-1.el8.x86_64 18/69 Installing : libXi-1.7.10-1.el8.x86_64 19/69 Installing : libXrender-0.9.10-7.el8.x86_64 20/69 Installing : libXrandr-1.5.2-1.el8.x86_64 21/69 Installing : libXtst-1.2.3-7.el8.x86_64 22/69 Installing : libXinerama-1.1.4-1.el8.x86_64 23/69 Installing : libXv-1.0.11-7.el8.x86_64 24/69 Installing : libXxf86dga-1.1.5-1.el8.x86_64 25/69 Installing : libXxf86misc-1.0.4-1.el8.x86_64 26/69 Installing : libXxf86vm-1.1.4-9.el8.x86_64 27/69 Installing : libdmx-1.1.4-3.el8.x86_64 28/69 Installing : libXcomposite-0.4.4-14.el8.x86_64 29/69 Installing : xorg-x11-utils-7.5-28.el8.x86_64 30/69 Installing : libXt-1.1.5-12.el8.x86_64 31/69 Installing : libXmu-1.1.3-1.el8.x86_64 32/69 Installing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 33/69 Installing : ksh-20120801-257.0.1.el8.x86_64 34/69 Running scriptlet: ksh-20120801-257.0.1.el8.x86_64 34/69 Installing : geolite2-country-20180605-1.el8.noarch 35/69 Installing : geolite2-city-20180605-1.el8.noarch 36/69 Installing : libmaxminddb-1.2.0-10.el8.x86_64 37/69 Running scriptlet: libmaxminddb-1.2.0-10.el8.x86_64 37/69 Installing : bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64 38/69 Installing : bind-libs-32:9.11.36-5.el8_7.2.x86_64 39/69 Installing : bind-utils-32:9.11.36-5.el8_7.2.x86_64 40/69 Installing : unzip-6.0-46.0.1.el8.x86_64 41/69 Installing : tar-2:1.30-6.el8_7.1.x86_64 42/69 Running scriptlet: tar-2:1.30-6.el8_7.1.x86_64 42/69 Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 43/69 Installing : smartmontools-1:7.1-1.el8.x86_64 43/69 Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 43/69 Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 44/69 Installing : rpcbind-1.2.5-10.el8.x86_64 44/69 Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 44/69 Installing : quota-nls-1:4.04-14.el8.noarch 45/69 Installing : quota-1:4.04-14.el8.x86_64 46/69 Installing : python3-setools-4.3.0-3.el8.x86_64 47/69 Installing : python3-libsemanage-2.9-9.el8.x86_64 48/69 Installing : python3-audit-3.0.7-4.el8.x86_64 49/69 Installing : pkgconf-m4-1.4.2-1.el8.noarch 50/69 Installing : net-tools-2.0-0.52.20160912git.el8.x86_64 51/69 Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64 51/69 Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 52/69 Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 52/69 Installing : sysstat-11.7.3-7.0.1.el8_7.1.x86_64 53/69 Running scriptlet: sysstat-11.7.3-7.0.1.el8_7.1.x86_64 53/69 Installing : libpkgconf-1.4.2-1.el8.x86_64 54/69 Installing : pkgconf-1.4.2-1.el8.x86_64 55/69 Installing : pkgconf-pkg-config-1.4.2-1.el8.x86_64 56/69 Installing : libnsl-2.28-211.0.1.el8.x86_64 57/69 Installing : keyutils-1.5.10-9.el8.x86_64 58/69 Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64 59/69 Installing : nfs-utils-1:2.3.3-57.el8_7.1.x86_64 59/69 Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64 59/69 Installing : kernel-headers-4.18.0-425.19.2.el8_7.x86_64 60/69 Running scriptlet: glibc-headers-2.28-211.0.1.el8.x86_64 61/69 Installing : glibc-headers-2.28-211.0.1.el8.x86_64 61/69 Installing : libxcrypt-devel-4.1.1-6.el8.x86_64 62/69 Installing : glibc-devel-2.28-211.0.1.el8.x86_64 63/69 Running scriptlet: glibc-devel-2.28-211.0.1.el8.x86_64 63/69 Installing : checkpolicy-2.9-1.el8.x86_64 64/69 Installing : python3-policycoreutils-2.9-20.0.1.el8.noarch 65/69 Installing : policycoreutils-python-utils-2.9-20.0.1.el8.noarch 66/69 Installing : binutils-2.30-117.0.3.el8.x86_64 67/69 Running scriptlet: binutils-2.30-117.0.3.el8.x86_64 67/69 Installing : bc-1.07.1-5.el8.x86_64 68/69 Running scriptlet: bc-1.07.1-5.el8.x86_64 68/69 Installing : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 69/69 Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 69/69 Verifying : bc-1.07.1-5.el8.x86_64 1/69 Verifying : binutils-2.30-117.0.3.el8.x86_64 2/69 Verifying : checkpolicy-2.9-1.el8.x86_64 3/69 Verifying : glibc-devel-2.28-211.0.1.el8.x86_64 4/69 Verifying : glibc-headers-2.28-211.0.1.el8.x86_64 5/69 Verifying : gssproxy-0.8.0-21.el8.x86_64 6/69 Verifying : kernel-headers-4.18.0-425.19.2.el8_7.x86_64 7/69 Verifying : keyutils-1.5.10-9.el8.x86_64 8/69 Verifying : libnsl-2.28-211.0.1.el8.x86_64 9/69 Verifying : libpkgconf-1.4.2-1.el8.x86_64 10/69 Verifying : libxcrypt-devel-4.1.1-6.el8.x86_64 11/69 Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 12/69 Verifying : make-1:4.2.1-11.el8.x86_64 13/69 Verifying : net-tools-2.0-0.52.20160912git.el8.x86_64 14/69 Verifying : nfs-utils-1:2.3.3-57.el8_7.1.x86_64 15/69 Verifying : pkgconf-1.4.2-1.el8.x86_64 16/69 Verifying : pkgconf-m4-1.4.2-1.el8.noarch 17/69 Verifying : pkgconf-pkg-config-1.4.2-1.el8.x86_64 18/69 Verifying : policycoreutils-python-utils-2.9-20.0.1.el8.noarch 19/69 Verifying : python3-audit-3.0.7-4.el8.x86_64 20/69 Verifying : python3-libsemanage-2.9-9.el8.x86_64 21/69 Verifying : python3-policycoreutils-2.9-20.0.1.el8.noarch 22/69 Verifying : python3-setools-4.3.0-3.el8.x86_64 23/69 Verifying : quota-1:4.04-14.el8.x86_64 24/69 Verifying : quota-nls-1:4.04-14.el8.noarch 25/69 Verifying : rpcbind-1.2.5-10.el8.x86_64 26/69 Verifying : smartmontools-1:7.1-1.el8.x86_64 27/69 Verifying : tar-2:1.30-6.el8_7.1.x86_64 28/69 Verifying : unzip-6.0-46.0.1.el8.x86_64 29/69 Verifying : bind-libs-32:9.11.36-5.el8_7.2.x86_64 30/69 Verifying : bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64 31/69 Verifying : bind-license-32:9.11.36-5.el8_7.2.noarch 32/69 Verifying : bind-utils-32:9.11.36-5.el8_7.2.x86_64 33/69 Verifying : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 34/69 Verifying : fstrm-0.6.1-3.el8.x86_64 35/69 Verifying : geolite2-city-20180605-1.el8.noarch 36/69 Verifying : geolite2-country-20180605-1.el8.noarch 37/69 Verifying : ksh-20120801-257.0.1.el8.x86_64 38/69 Verifying : libICE-1.0.9-15.el8.x86_64 39/69 Verifying : libSM-1.2.3-1.el8.x86_64 40/69 Verifying : libX11-1.6.8-5.el8.x86_64 41/69 Verifying : libX11-common-1.6.8-5.el8.noarch 42/69 Verifying : libX11-xcb-1.6.8-5.el8.x86_64 43/69 Verifying : libXau-1.0.9-3.el8.x86_64 44/69 Verifying : libXcomposite-0.4.4-14.el8.x86_64 45/69 Verifying : libXext-1.3.4-1.el8.x86_64 46/69 Verifying : libXi-1.7.10-1.el8.x86_64 47/69 Verifying : libXinerama-1.1.4-1.el8.x86_64 48/69 Verifying : libXmu-1.1.3-1.el8.x86_64 49/69 Verifying : libXrandr-1.5.2-1.el8.x86_64 50/69 Verifying : libXrender-0.9.10-7.el8.x86_64 51/69 Verifying : libXt-1.1.5-12.el8.x86_64 52/69 Verifying : libXtst-1.2.3-7.el8.x86_64 53/69 Verifying : libXv-1.0.11-7.el8.x86_64 54/69 Verifying : libXxf86dga-1.1.5-1.el8.x86_64 55/69 Verifying : libXxf86misc-1.0.4-1.el8.x86_64 56/69 Verifying : libXxf86vm-1.1.4-9.el8.x86_64 57/69 Verifying : libdmx-1.1.4-3.el8.x86_64 58/69 Verifying : libev-4.24-6.el8.x86_64 59/69 Verifying : libmaxminddb-1.2.0-10.el8.x86_64 60/69 Verifying : libverto-libev-0.3.2-2.el8.x86_64 61/69 Verifying : libxcb-1.13.1-1.el8.x86_64 62/69 Verifying : protobuf-c-1.3.0-6.el8.x86_64 63/69 Verifying : python3-bind-32:9.11.36-5.el8_7.2.noarch 64/69 Verifying : sysstat-11.7.3-7.0.1.el8_7.1.x86_64 65/69 Verifying : xorg-x11-utils-7.5-28.el8.x86_64 66/69 Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 67/69 Verifying : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 68/69 Verifying : python3-pyyaml-5.4.1-1.0.1.el8.x86_64 69/69 Installed: bc-1.07.1-5.el8.x86_64 bind-libs-32:9.11.36-5.el8_7.2.x86_64 bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64 bind-license-32:9.11.36-5.el8_7.2.noarch bind-utils-32:9.11.36-5.el8_7.2.x86_64 binutils-2.30-117.0.3.el8.x86_64 checkpolicy-2.9-1.el8.x86_64 compat-openssl10-1:1.0.2o-4.el8_6.x86_64 fstrm-0.6.1-3.el8.x86_64 geolite2-city-20180605-1.el8.noarch geolite2-country-20180605-1.el8.noarch glibc-devel-2.28-211.0.1.el8.x86_64 glibc-headers-2.28-211.0.1.el8.x86_64 gssproxy-0.8.0-21.el8.x86_64 kernel-headers-4.18.0-425.19.2.el8_7.x86_64 keyutils-1.5.10-9.el8.x86_64 ksh-20120801-257.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-5.el8.x86_64 libX11-common-1.6.8-5.el8.noarch libX11-xcb-1.6.8-5.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 libdmx-1.1.4-3.el8.x86_64 libev-4.24-6.el8.x86_64 libmaxminddb-1.2.0-10.el8.x86_64 libnsl-2.28-211.0.1.el8.x86_64 libpkgconf-1.4.2-1.el8.x86_64 libverto-libev-0.3.2-2.el8.x86_64 libxcb-1.13.1-1.el8.x86_64 libxcrypt-devel-4.1.1-6.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 make-1:4.2.1-11.el8.x86_64 net-tools-2.0-0.52.20160912git.el8.x86_64 nfs-utils-1:2.3.3-57.el8_7.1.x86_64 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 pkgconf-1.4.2-1.el8.x86_64 pkgconf-m4-1.4.2-1.el8.noarch pkgconf-pkg-config-1.4.2-1.el8.x86_64 policycoreutils-python-utils-2.9-20.0.1.el8.noarch protobuf-c-1.3.0-6.el8.x86_64 python3-audit-3.0.7-4.el8.x86_64 python3-bind-32:9.11.36-5.el8_7.2.noarch python3-libsemanage-2.9-9.el8.x86_64 python3-policycoreutils-2.9-20.0.1.el8.noarch python3-pyyaml-5.4.1-1.0.1.el8.x86_64 python3-setools-4.3.0-3.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-1.el8.x86_64 sysstat-11.7.3-7.0.1.el8_7.1.x86_64 tar-2:1.30-6.el8_7.1.x86_64 unzip-6.0-46.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! [root@oracle23c tmp]#
Após a instalação dos pre requisitos, podemos seguir com a instalação do Oracle 23c, lembrando que neste exemplo o arquivo de instalação está no diretório /tmp.
dnf -y localinstall /tmp/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
[root@oracle23c tmp]# [root@oracle23c tmp]# dnf -y localinstall /tmp/oracle-database-free-23c-1.0-1.el8.x86_64.rpm Last metadata expiration check: 0:05:18 ago on Sun 07 May 2023 06:12:28 PM -03. Dependencies resolved. ============================================================================================================================================================================================= Package Architecture Version Repository Size ============================================================================================================================================================================================= Installing: oracle-database-free-23c x86_64 1.0-1 @commandline 1.6 G Transaction Summary ============================================================================================================================================================================================= Install 1 Package Total size: 1.6 G Installed size: 5.2 G Downloading Packages: Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1 Installing : oracle-database-free-23c-1.0-1.x86_64 1/1 Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1 [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-23c.conf' and then run '/etc/init.d/oracle-free-23c configure' as root. Verifying : oracle-database-free-23c-1.0-1.x86_64 1/1 Installed: oracle-database-free-23c-1.0-1.x86_64 Complete! [root@oracle23c tmp]#
A instalação padrão desta versão ocorre no diretório /opt/oracle/product/23c/dbhomeFree, sendo este o OORACLE_HOME do nosso Oracle 23c. Via service oracle-free-23c status é possivel consultar o status do nosso Oralce 23c.
[root@oracle23c tmp]# [root@oracle23c tmp]# service oracle-free-23c status Status of the Oracle FREE 23c service: LISTENER status: NOT CONFIGURED FREE Database status: NOT CONFIGURED [root@oracle23c tmp]#
Conforme consta no resultado do comando de status, ainda não temos um listener, nem um database configurados, uma vez que foi feita apenas a instalação do produto. Para criar nosso banco de dados 23c o processo de instalação já cria um script pré configurado para esse processo e vai criar um banco de dados chamado "FREE" contendo um pdb chamado FREEPDB1.
O comando para executar o processo de criação deve-se executar o comando service oracle-free-23c configure. Durante a execução será necessário fornecer uma senha, que será usada para as contas administrativas SYS, SYSTEM e PDBADMIN. Esta senha deve conter ao menos 8 caracteres, sendo ao menos 1 letra maiúscula, 1 letra minúscula e 1 numérico.
[root@oracle23c tmp]# [root@oracle23c tmp]# service oracle-free-23c 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: Passwords do not match. Enter the password: [root@oracle23c tmp]# [root@oracle23c tmp]# [root@oracle23c tmp]# /etc/init.d/oracle-free-23c 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. [WARNING] [DBT-11205] Specified shared pool size does not meet the recommended minimum size requirement. This might cause database creation to fail. ACTION: Specify at least (531 MB) for shared pool size. 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: oracle23c/FREEPDB1 Multitenant container database: oracle23c [root@oracle23c tmp]# [root@oracle23c tmp]#
Se executarmos um service oracle-free-23c status, podemos observar que agora o listener e database estão com status running.
[root@oracle23c tmp]# [root@oracle23c tmp]# service oracle-free-23c status Status of the Oracle FREE 23c service: LISTENER status: RUNNING FREE Database status: RUNNING [root@oracle23c tmp]#
Além do status, stop e configure, ainda é possível realizar o restart e também o delete usando o service oracle-free-23c.
[root@oracle23c tmp]# [root@oracle23c tmp]# service oracle-free-23c Usage: /etc/init.d/oracle-free-23c {start|stop|restart|configure|delete|status} [root@oracle23c tmp]#
Concluído o processo de instalação e criação do banco dedados, vamos realizar uma conexão ao mesmo. Para realizar a conexão, deve-se mudar para o usuário oracle e realizar a exportação das váriaveis de ambiente, que faremos via oraenv.
Desta forma, podemos realizar a conexão ao database 23c que acabamos de criar.
[oracle@oracle23c ~]$ [oracle@oracle23c ~]$ . oraenv ORACLE_SID = [oracle] ? FREE The Oracle base has been set to /opt/oracle [oracle@oracle23c ~]$ sqlplus sys@FREE as sysdba SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Sun May 7 19:12:22 2023 Version 23.2.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release Version 23.2.0.0.0 SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FREEPDB1 READ WRITE NO SQL> SQL>
Na tabela abaixo estão listados os diretórios criados na estrutura padrão do Oracle database 23c Free e para que são utilizados.
https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/installing-oracle-database-free.html
Comentários
Postar um comentário