Oracle Database 23c Free Developer Edition disponível

Ontem dia 03/04/2023 foi disponibilizado a versão free do Oracle Database para desenvolvedores, pensando nos desenvolvedores e nas empresas, a Oracle lançou a edição Developer da versão 23c totalmente gratuita.

Funcionalidades incluídas na edição Developer:

JSON Relational Duality
JavaScript Stored Procedures (powered by GraalVM)
JSON Schema
Operational Property Graphs
Oracle Kafka APIs
SQL Domains
Annotations

Link sobre as funcionalidades:

https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/introduction.html

Limitações da Edição Developer 23c:

12 GB de dados do usuário
2 GB de RAM
2 threads de CPU
Máximo de 252 PDBs
Requer Oracle Linux 8 ou RHE8

INSTALAÇÃO

Link para download:

#Linux RPM file
https://www.oracle.com/database/technologies/free-downloads.html
#VirtualBox VM
https://www.oracle.com/database/technologies/databaseappdev-vm.html
#Docker Image (docker pull container-registry.oracle.com/database/free)
https://container-registry.oracle.com/

Versão do SO que iremos instalar o Oracle Database 23c Developer Edition:

[root@srv23dev ~]# cat /etc/*-release | grep PRETTY
PRETTY_NAME="Oracle Linux Server 8.7"

Pacotes e configurações do SO:

dnf config-manager --enable ol8_codeready_builder
dnf install xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps -y
dnf install wget zip unzip rsync -y
dnf install net-tools -y
dnf install NetworkManager-tui -y
dnf update -y
systemctl stop firewalld
systemctl status firewalld
systemctl disable --now firewalld
systemctl mask --now firewalld

cat /etc/selinux/config
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

cat >> /etc/hosts << EOF
192.168.13.135 srv23dev srv23dev
EOF

cat /etc/hosts

Instalação dos pacotes necessários:

curl -L -o oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm 
[root@srv23dev ~]# curl -L -o oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 30688  100 30688    0     0  30657      0  0:00:01  0:00:01 --:--:-- 30657


[root@srv23dev ~]# dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Last metadata expiration check: 0:02:51 ago on Tue 04 Apr 2023 09:29:48 AM -03.
Dependencies resolved.
========================================================================================================================================================================================================================================
 Package                                                          Architecture                             Version                                                            Repository                                           Size
========================================================================================================================================================================================================================================
Installing:
 oracle-database-preinstall-23c                                   x86_64                                   1.0-0.5.el8                                                        @commandline                                         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
 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
 gssproxy                                                         x86_64                                   0.8.0-21.el8                                                       ol8_baseos_latest                                   119 k
 ksh                                                              x86_64                                   20120801-257.0.1.el8                                               ol8_appstream                                       929 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
 libverto-libev                                                   x86_64                                   0.3.2-2.el8                                                        ol8_appstream                                        16 k
 lm_sensors-libs                                                  x86_64                                   3.4.0-23.20180522git70f7e08.el8                                    ol8_baseos_latest                                    59 k
 nfs-utils                                                        x86_64                                   1:2.3.3-57.el8_7.1                                                 ol8_baseos_latest                                   515 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_6                                                        ol8_baseos_latest                                   128 k
 python3-policycoreutils                                          noarch                                   2.9-20.0.1.el8                                                     ol8_baseos_latest                                   2.2 M
 python3-pyyaml                                                   x86_64                                   3.12-12.el8                                                        ol8_baseos_latest                                   193 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
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  32 Packages

Total size: 30 M
Total download size: 30 M
Installed size: 86 M
Downloading Packages:
(1/31): bc-1.07.1-5.el8.x86_64.rpm                                                                                                                                                                      257 kB/s | 129 kB     00:00
(2/31): gssproxy-0.8.0-21.el8.x86_64.rpm                                                                                                                                                                227 kB/s | 119 kB     00:00
(3/31): checkpolicy-2.9-1.el8.x86_64.rpm                                                                                                                                                                576 kB/s | 346 kB     00:00
(4/31): libnsl-2.28-211.0.1.el8.x86_64.rpm                                                                                                                                                              1.0 MB/s | 105 kB     00:00
(5/31): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm                                                                                                                                      522 kB/s |  59 kB     00:00
(6/31): policycoreutils-python-utils-2.9-20.0.1.el8.noarch.rpm                                                                                                                                          1.8 MB/s | 253 kB     00:00
(7/31): python3-audit-3.0.7-4.el8.x86_64.rpm                                                                                                                                                            865 kB/s |  87 kB     00:00
(8/31): nfs-utils-2.3.3-57.el8_7.1.x86_64.rpm                                                                                                                                                           2.6 MB/s | 515 kB     00:00
(9/31): python3-libsemanage-2.9-9.el8_6.x86_64.rpm                                                                                                                                                      1.4 MB/s | 128 kB     00:00
(10/31): python3-pyyaml-3.12-12.el8.x86_64.rpm                                                                                                                                                          1.4 MB/s | 193 kB     00:00
(11/31): python3-setools-4.3.0-3.el8.x86_64.rpm                                                                                                                                                         3.8 MB/s | 624 kB     00:00
(12/31): quota-4.04-14.el8.x86_64.rpm                                                                                                                                                                   1.1 MB/s | 214 kB     00:00
(13/31): rpcbind-1.2.5-10.el8.x86_64.rpm                                                                                                                                                                951 kB/s |  70 kB     00:00
(14/31): smartmontools-7.1-1.el8.x86_64.rpm                                                                                                                                                             2.9 MB/s | 544 kB     00:00
(15/31): quota-nls-4.04-14.el8.noarch.rpm                                                                                                                                                               195 kB/s |  95 kB     00:00
(16/31): bind-libs-9.11.36-5.el8_7.2.x86_64.rpm                                                                                                                                                         1.2 MB/s | 175 kB     00:00
(17/31): bind-license-9.11.36-5.el8_7.2.noarch.rpm                                                                                                                                                      602 kB/s | 104 kB     00:00
(18/31): python3-policycoreutils-2.9-20.0.1.el8.noarch.rpm                                                                                                                                              2.2 MB/s | 2.2 MB     00:01
(19/31): bind-utils-9.11.36-5.el8_7.2.x86_64.rpm                                                                                                                                                        2.3 MB/s | 452 kB     00:00
(20/31): fstrm-0.6.1-3.el8.x86_64.rpm                                                                                                                                                                   497 kB/s |  29 kB     00:00
(21/31): bind-libs-lite-9.11.36-5.el8_7.2.x86_64.rpm                                                                                                                                                    761 kB/s | 1.2 MB     00:01
(22/31): geolite2-country-20180605-1.el8.noarch.rpm                                                                                                                                                     3.3 MB/s | 1.0 MB     00:00
(23/31): ksh-20120801-257.0.1.el8.x86_64.rpm                                                                                                                                                            2.4 MB/s | 929 kB     00:00
(24/31): geolite2-city-20180605-1.el8.noarch.rpm                                                                                                                                                        9.4 MB/s |  19 MB     00:02
(25/31): libmaxminddb-1.2.0-10.el8.x86_64.rpm                                                                                                                                                           497 kB/s |  33 kB     00:00
(26/31): libverto-libev-0.3.2-2.el8.x86_64.rpm                                                                                                                                                          206 kB/s |  16 kB     00:00
(27/31): protobuf-c-1.3.0-6.el8.x86_64.rpm                                                                                                                                                              625 kB/s |  37 kB     00:00
(28/31): libev-4.24-6.el8.x86_64.rpm                                                                                                                                                                    109 kB/s |  52 kB     00:00
(29/31): python3-bind-9.11.36-5.el8_7.2.noarch.rpm                                                                                                                                                      2.1 MB/s | 151 kB     00:00
(30/31): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm                                                                                                                                                     441 kB/s | 1.1 MB     00:02
(31/31): sysstat-11.7.3-7.0.1.el8_7.1.x86_64.rpm                                                                                                                                                        1.7 MB/s | 426 kB     00:00
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                                   6.7 MB/s |  30 MB     00:04
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/32
  Installing       : fstrm-0.6.1-3.el8.x86_64                                                                                                                                                                                      2/32
  Installing       : bind-license-32:9.11.36-5.el8_7.2.noarch                                                                                                                                                                      3/32
  Installing       : python3-bind-32:9.11.36-5.el8_7.2.noarch                                                                                                                                                                      4/32
  Installing       : libev-4.24-6.el8.x86_64                                                                                                                                                                                       5/32
  Installing       : libverto-libev-0.3.2-2.el8.x86_64                                                                                                                                                                             6/32
  Installing       : gssproxy-0.8.0-21.el8.x86_64                                                                                                                                                                                  7/32
  Running scriptlet: gssproxy-0.8.0-21.el8.x86_64                                                                                                                                                                                  7/32
  Installing       : ksh-20120801-257.0.1.el8.x86_64                                                                                                                                                                               8/32
  Running scriptlet: ksh-20120801-257.0.1.el8.x86_64                                                                                                                                                                               8/32
  Installing       : geolite2-country-20180605-1.el8.noarch                                                                                                                                                                        9/32
  Installing       : geolite2-city-20180605-1.el8.noarch                                                                                                                                                                          10/32
  Installing       : libmaxminddb-1.2.0-10.el8.x86_64                                                                                                                                                                             11/32
  Running scriptlet: libmaxminddb-1.2.0-10.el8.x86_64                                                                                                                                                                             11/32
  Installing       : bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64                                                                                                                                                                   12/32
  Installing       : bind-libs-32:9.11.36-5.el8_7.2.x86_64                                                                                                                                                                        13/32
  Installing       : bind-utils-32:9.11.36-5.el8_7.2.x86_64                                                                                                                                                                       14/32
  Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                                                                                                     15/32
  Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                                                                                                     15/32
  Running scriptlet: smartmontools-1:7.1-1.el8.x86_64                                                                                                                                                                             16/32
  Installing       : smartmontools-1:7.1-1.el8.x86_64                                                                                                                                                                             16/32
  Running scriptlet: smartmontools-1:7.1-1.el8.x86_64                                                                                                                                                                             16/32
  Running scriptlet: rpcbind-1.2.5-10.el8.x86_64                                                                                                                                                                                  17/32
  Installing       : rpcbind-1.2.5-10.el8.x86_64                                                                                                                                                                                  17/32
  Running scriptlet: rpcbind-1.2.5-10.el8.x86_64                                                                                                                                                                                  17/32
  Installing       : quota-nls-1:4.04-14.el8.noarch                                                                                                                                                                               18/32
  Installing       : quota-1:4.04-14.el8.x86_64                                                                                                                                                                                   19/32
  Installing       : python3-setools-4.3.0-3.el8.x86_64                                                                                                                                                                           20/32
  Installing       : python3-pyyaml-3.12-12.el8.x86_64                                                                                                                                                                            21/32
  Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64                                                                                                                                                                          22/32
  Installing       : nfs-utils-1:2.3.3-57.el8_7.1.x86_64                                                                                                                                                                          22/32
  Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64                                                                                                                                                                          22/32
  Installing       : python3-libsemanage-2.9-9.el8_6.x86_64                                                                                                                                                                       23/32
  Installing       : python3-audit-3.0.7-4.el8.x86_64                                                                                                                                                                             24/32
  Installing       : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                                                                                                       25/32
  Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                                                                                                       25/32
  Installing       : sysstat-11.7.3-7.0.1.el8_7.1.x86_64                                                                                                                                                                          26/32
  Running scriptlet: sysstat-11.7.3-7.0.1.el8_7.1.x86_64                                                                                                                                                                          26/32
  Installing       : libnsl-2.28-211.0.1.el8.x86_64                                                                                                                                                                               27/32
  Installing       : checkpolicy-2.9-1.el8.x86_64                                                                                                                                                                                 28/32
  Installing       : python3-policycoreutils-2.9-20.0.1.el8.noarch                                                                                                                                                                29/32
  Installing       : policycoreutils-python-utils-2.9-20.0.1.el8.noarch                                                                                                                                                           30/32
  Installing       : bc-1.07.1-5.el8.x86_64                                                                                                                                                                                       31/32
  Running scriptlet: bc-1.07.1-5.el8.x86_64                                                                                                                                                                                       31/32
  Installing       : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64                                                                                                                                                            32/32
  Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64                                                                                                                                                            32/32
  Verifying        : bc-1.07.1-5.el8.x86_64                                                                                                                                                                                        1/32
  Verifying        : checkpolicy-2.9-1.el8.x86_64                                                                                                                                                                                  2/32
  Verifying        : gssproxy-0.8.0-21.el8.x86_64                                                                                                                                                                                  3/32
  Verifying        : libnsl-2.28-211.0.1.el8.x86_64                                                                                                                                                                                4/32
  Verifying        : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                                                                                                        5/32
  Verifying        : nfs-utils-1:2.3.3-57.el8_7.1.x86_64                                                                                                                                                                           6/32
  Verifying        : policycoreutils-python-utils-2.9-20.0.1.el8.noarch                                                                                                                                                            7/32
  Verifying        : python3-audit-3.0.7-4.el8.x86_64                                                                                                                                                                              8/32
  Verifying        : python3-libsemanage-2.9-9.el8_6.x86_64                                                                                                                                                                        9/32
  Verifying        : python3-policycoreutils-2.9-20.0.1.el8.noarch                                                                                                                                                                10/32
  Verifying        : python3-pyyaml-3.12-12.el8.x86_64                                                                                                                                                                            11/32
  Verifying        : python3-setools-4.3.0-3.el8.x86_64                                                                                                                                                                           12/32
  Verifying        : quota-1:4.04-14.el8.x86_64                                                                                                                                                                                   13/32
  Verifying        : quota-nls-1:4.04-14.el8.noarch                                                                                                                                                                               14/32
  Verifying        : rpcbind-1.2.5-10.el8.x86_64                                                                                                                                                                                  15/32
  Verifying        : smartmontools-1:7.1-1.el8.x86_64                                                                                                                                                                             16/32
  Verifying        : bind-libs-32:9.11.36-5.el8_7.2.x86_64                                                                                                                                                                        17/32
  Verifying        : bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64                                                                                                                                                                   18/32
  Verifying        : bind-license-32:9.11.36-5.el8_7.2.noarch                                                                                                                                                                     19/32
  Verifying        : bind-utils-32:9.11.36-5.el8_7.2.x86_64                                                                                                                                                                       20/32
  Verifying        : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                                                                                                     21/32
  Verifying        : fstrm-0.6.1-3.el8.x86_64                                                                                                                                                                                     22/32
  Verifying        : geolite2-city-20180605-1.el8.noarch                                                                                                                                                                          23/32
  Verifying        : geolite2-country-20180605-1.el8.noarch                                                                                                                                                                       24/32
  Verifying        : ksh-20120801-257.0.1.el8.x86_64                                                                                                                                                                              25/32
  Verifying        : libev-4.24-6.el8.x86_64                                                                                                                                                                                      26/32
  Verifying        : libmaxminddb-1.2.0-10.el8.x86_64                                                                                                                                                                             27/32
  Verifying        : libverto-libev-0.3.2-2.el8.x86_64                                                                                                                                                                            28/32
  Verifying        : protobuf-c-1.3.0-6.el8.x86_64                                                                                                                                                                                29/32
  Verifying        : python3-bind-32:9.11.36-5.el8_7.2.noarch                                                                                                                                                                     30/32
  Verifying        : sysstat-11.7.3-7.0.1.el8_7.1.x86_64                                                                                                                                                                          31/32
  Verifying        : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64                                                                                                                                                            32/32

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                          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          gssproxy-0.8.0-21.el8.x86_64                               ksh-20120801-257.0.1.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                             libverto-libev-0.3.2-2.el8.x86_64
  lm_sensors-libs-3.4.0-23.20180522git70f7e08.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          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_6.x86_64
  python3-policycoreutils-2.9-20.0.1.el8.noarch                   python3-pyyaml-3.12-12.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

Complete!


[root@srv23dev ~]# dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Last metadata expiration check: 0:07:33 ago on Tue 04 Apr 2023 09:29:48 AM -03.
Package oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 is already installed.
Dependencies resolved.
Nothing to do.
Complete!

Instalação do Database 23c Developer Edition:

[root@srv23dev ~]# dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:10:02 ago on Tue 04 Apr 2023 09:29:48 AM -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@srv23dev ~]# /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.
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: srv23dev/FREEPDB1
     Multitenant container database: srv23dev
#Password oracle user
[root@srv23dev ~]# passwd oracle

Diretórios usados após a instalação:

[oracle@srv23dev ~]$ ls -lat /opt/oracle/
total 4
drwxrwx---.  4 oracle oinstall   78 Apr  4 09:48 oraInventory
drwxr-x---.  3 oracle oinstall   18 Apr  4 09:43 audit
drwxr-xr-x.  9 oracle oinstall  113 Apr  4 09:43 .
drwxr-x---.  3 oracle oinstall   18 Apr  4 09:43 oradata
drwxr-x---.  3 oracle oinstall   18 Apr  4 09:43 admin
drwxr-xr-x.  4 oracle oinstall   31 Apr  4 09:43 cfgtoollogs
drwxrwxr-x. 25 oracle oinstall 4096 Apr  4 09:41 diag
drwxr-xr-x.  4 root   root       36 Apr  4 09:41 ..
drwxr-xr-x.  3 oracle oinstall   17 Apr  4 09:40 product


#Oracle base.
/opt/oracle
#Oracle home
/opt/oracle/product/23c/dbhomeFree
#Database files
/opt/oracle/oradata/FREE
#Diagnostic logs
/opt/oracle/diag subdirectories
#Database creation logs.
/opt/oracle/cfgtoollogs/dbca/FREE
#Configuration default parameters.
/etc/sysconfig/oracle-free-23c.conf
#Configuration and services script.
/etc/init.d/oracle-free-23c

Configurações do Database para setup customizado:

#Configuration default parameters.
[oracle@srv23dev ~]$ strings /etc/sysconfig/oracle-free-23c.conf
#This is a configuration file to setup the Oracle Database.
#It is used when running '/etc/init.d/oracle-free-23c 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=
# DB Domain name
DB_DOMAIN=
# SKIP Validations, memory, space
SKIP_VALIDATIONS=false

Informações do Database:

[oracle@srv23dev ~]$ ps aux | grep smon
oracle     53423  0.0  2.4 1502036 68344 ?       Ss   09:48   0:00 db_smon_FREE
oracle     53904  0.0  0.0  12144  1196 pts/0    S+   09:50   0:00 grep --color=auto smon
[oracle@srv23dev ~]$
[oracle@srv23dev ~]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base has been set to /opt/oracle

[oracle@srv23dev ~]$ lsnrctl status

LSNRCTL for Linux: Version 23.0.0.0.0 - Developer-Release on 04-APR-2023 10:05:38

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srv23dev)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 23.0.0.0.0 - Developer-Release
Start Date                04-APR-2023 09:43:43
Uptime                    0 days 0 hr. 21 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           FREE
Listener Parameter File   /opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/srv23dev/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv23dev)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
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 "f8831750e283d1a4e053870da8c0083a" 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@srv23dev ~]$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 4 09:55:56 2023
Version 23.2.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.


Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

SQL> set lines 200
col DATABASE_HOST for a25;
col DB_UNIQUE_NAME for a25
col HOST_NAME for a15;
col DATABASE_ROLE for a10
col OPEN_MODE for a10
col STARTUP_TIME for a20
alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS';
SELECT i.HOST_NAME "DATABASE_HOST" ,
i.INSTANCE_NAME "DB_NAME",
d.db_unique_name "DB_UNIQUE_NAME" ,
d.DATABASE_ROLE " DATABASE_ROLE",
i.VERSION,
d.OPEN_MODE " OPEN_MODE ",
d.LOG_MODE
,STARTUSQL> SQL> SQL> SQL> SQL> SQL> SQL> P_TIME
from GV$DATABASE d, gv$instance i
where i.INST_ID=d.INST_ID;
Session altered.

SQL>   2    3    4    5    6    7    8    9   10

DATABASE_HOST             DB_NAME          DB_UNIQUE_NAME             DATABASE_ROLE   VERSION            OPEN_MODE           LOG_MODE     STARTUP_TIME
------------------------- ---------------- ------------------------- ---------------- ----------------- -------------------- ------------ --------------------
srv23dev                  FREE             FREE                      PRIMARY          23.0.0.0.0        READ WRITE           NOARCHIVELOG 03/04/2023 22:48:19


Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

SQL> set lines 200
SQL> select BANNER_FULL from gv$version;

BANNER_FULL
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0


SQL>

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show PDBS;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 FREEPDB1                       READ WRITE NO

Link para documentação:

https://www.oracle.com/news/announcement/oracle-database-23c-free-developer-release-2023-04-03/?source=:so:fb:or:awr:odb:::RC_WWMK220913P00038:&SC=:so:fb:or:awr:odb:::RC_WWMK220913P00038:&pcode=WWMK220913P00038
https://blogs.oracle.com/database/post/oracle-database-23c-free
https://docs.oracle.com/en/database/oracle/oracle-database/23/index.html
https://www.oracle.com/database/free/
https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/index.html
https://www.oracle.com/database/free/?source=:so:tw:or:awr:odb:::RC_WWMK220913P00038:
https://docs.oracle.com/en/database/oracle/oracle-database/23/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87

Leave a Reply

Your email address will not be published. Required fields are marked *

search previous next tag category expand menu location phone mail time cart zoom edit close