martes, 25 de abril de 2023

Ampliando la partición "/" root en una instancia OCI de manera sencilla.

Si ya haz creado un servicio en OCI de tipo IaaS, es posible que te halla pasado esto.
A ver, haces un despliegue de un servicio con Oracle Linux 8 y a la hora de definir el área de almacenamiento, cambias los 50Gb de facto por otro tamaño, por ejemplo por 200Gb.

Cuando arranca el servicio y verificas el espacio disponible, te das cuenta, que no está el espacio que querías tener.

Aquí no hay error, eso es lo normal.

Puedes ampliar la partición del disco "/" root, instalando el OCI-UTILS en caso de que no lo tengas, o bien tan sólo llamándolo.


[root@oracle-database-server-free-for-developers opc]#
login as: opc
Authenticating with public key "rsa-key-20200507"
Passphrase for key "rsa-key-20200507":
Activate the web console with: systemctl enable --now cockpit.socket

Last login: Tue Apr 18 02:59:46 2023 from 201.198.177.118
*************************************************************************
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash
[root@oracle-database-server-free-for-developers opc]# df -Th
Filesystem                 Type      Size  Used Avail Use% Mounted on
devtmpfs                   devtmpfs   16G     0   16G   0% /dev
tmpfs                      tmpfs      16G     0   16G   0% /dev/shm
tmpfs                      tmpfs      16G  8.7M   16G   1% /run
tmpfs                      tmpfs      16G     0   16G   0% /sys/fs/cgroup
/dev/mapper/ocivolume-root xfs        36G   13G   24G  35% /
/dev/mapper/ocivolume-oled xfs        10G  105M  9.9G   2% /var/oled
/dev/sda2                  xfs      1014M  323M  692M  32% /boot
/dev/sda1                  vfat      100M  5.1M   95M   6% /boot/efi
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/0
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/988
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/1000
Como puedes verificar los volúmenes lógicos están con los tamaños de facto.
[root@oracle-database-server-free-for-developers opc]# lvs
  LV   VG        Attr       LSize  Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  oled ocivolume -wi-ao---- 10.00g
  root ocivolume -wi-ao---- 35.47g
[root@oracle-database-server-free-for-developers opc]# pvs
  PV         VG        Fmt  Attr PSize  PFree
  /dev/sda3  ocivolume lvm2 a--  45.47g    0
[root@oracle-database-server-free-for-developers opc]# dnf -y install oci-utils
Ksplice for Oracle Linux 8 (x86_64)                                                         25 MB/s | 2.2 MB     00:00
MySQL 8.0 for Oracle Linux 8 (x86_64)                                                       40 MB/s | 3.0 MB     00:00
MySQL 8.0 Tools Community for Oracle Linux 8 (x86_64)                                      7.8 MB/s | 491 kB     00:00
MySQL 8.0 Connectors Community for Oracle Linux 8 (x86_64)                                 532 kB/s |  30 kB     00:00
Oracle Software for OCI users on Oracle Linux 8 (x86_64)                                   109 MB/s |  75 MB     00:00
Oracle Linux 8 BaseOS Latest (x86_64)                                                      105 MB/s |  57 MB     00:00
Oracle Linux 8 Application Stream (x86_64)                                                 103 MB/s |  44 MB     00:00
Oracle Linux 8 Addons (x86_64)                                                              64 MB/s | 6.9 MB     00:00
Latest Unbreakable Enterprise Kernel Release 7 for Oracle Linux 8 (x86_64)                  85 MB/s |  14 MB     00:00
Package oci-utils-0.14.0-2.el8.noarch is already installed.
Dependencies resolved.
Nothing to do.
Complete!
Corremos el utilitario y hacemos la magia de manera simple y rápida. En este caso sólo tenemos una partición y lo que nos va a solicitar el comando, es que si queremos aumentar dicha partición al máximo de espacio disponible.
[root@oracle-database-server-free-for-developers opc]# oci-growfs
bash: oci-growfs: command not found
[root@oracle-database-server-free-for-developers opc]# /usr/libexec/oci-growfs
Volume Group: ocivolume
Volume Path: /dev/ocivolume/root
Mountpoint Data
---------------
          mountpoint: /
              source: /dev/mapper/ocivolume-root
     filesystem type: xfs
         source size: 35.5G
                type: lvm
                size: 35.5G
    physical devices: ['/dev/sda3']
    physical volumes: ['/dev/sda', '/dev/sda']
    partition number: ['3']
   volume group name: ocivolume
   volume group path: /dev/ocivolume/root

Partition dry run expansion "/dev/sda3" succeeded.
CHANGE: partition=3 start=2304000 old: size=95371264 end=97675264 new: 
size=417126367 end=419430367

Expanding partition /dev/sda3: Confirm?   [y/N] y

Partition expand expansion "/dev/sda3" succeeded.
update-partition set to true
resizing 3 on /dev/sda using resize_sfdisk_gpt
419430400 sectors of 512. total size=214748364800 bytes
## sfdisk --unit=S --dump /dev/sda
label: gpt
label-id: 812F8A56-E8ED-417C-BD3D-661E60705756
device: /dev/sda
unit: sectors
first-lba: 34
last-lba: 419430366

/dev/sda1 : start=        2048, size=      204800, type=C12A7328-F81F-11D2-BA4B-00A0C93EC93B, 
uuid=E673AE28-BA2F-401D-B02B-695892283475, 
name="EFI System Partition"
/dev/sda2 : start=      206848, size=     2097152, type=0FC63DAF-8483-4772-8E79-3D69D8477DE4, 
uuid=3840F016-52AC-4561-835A-02DFA72AF0E8
/dev/sda3 : start=     2304000, size=    95371264, type=E6D6D379-F507-44C2-A23C-238F2A3DF928, 
uuid=66916148-C5F5-4833-8FAE-8A4DE95421FD
padding 33 sectors for gpt secondary header
max_end=419430367 tot=419430400 pt_end=97675264 pt_start=2304000 pt_size=95371264
resize of /dev/sda returned 0.

CHANGED: partition=3 start=2304000 old: size=95371264 end=97675264 new: size=417126367 end=419430367

Extending /dev/sda3 succeeded.
Device /dev/sda3 extended successfully.
Logical volume /dev/ocivolume/root extended successfully.
Validamos una vez terminada la acción del comando y listo. Ya tenemos nuestros 200GB asociados en el disco.
[root@oracle-database-server-free-for-developers opc]# df -Th
Filesystem                 Type      Size  Used Avail Use% Mounted on
devtmpfs                   devtmpfs   16G     0   16G   0% /dev
tmpfs                      tmpfs      16G     0   16G   0% /dev/shm
tmpfs                      tmpfs      16G  8.7M   16G   1% /run
tmpfs                      tmpfs      16G     0   16G   0% /sys/fs/cgroup
/dev/mapper/ocivolume-root xfs       189G   14G  176G   8% /
/dev/mapper/ocivolume-oled xfs        10G  105M  9.9G   2% /var/oled
/dev/sda2                  xfs      1014M  323M  692M  32% /boot
/dev/sda1                  vfat      100M  5.1M   95M   6% /boot/efi
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/0
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/988
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/1000
[root@oracle-database-server-free-for-developers opc]#

Taller Gratuito Oracle Database 23c Free for Developers - Contenido del Taller

El siguiente es el código utilizado en el taller desplegado en el video del canal de Youtube de creación de una instancia en OCI con Oracle Linux 8, Oracle Database 23c Free for Developers e instalación y configuración de APEX22.2

Dirección del video: https://youtu.be/P1oVkn6Op6Q



[root@oracle-database-server-free-for-developers opc]#
login as: opc
Authenticating with public key "rsa-key-20200507"
Passphrase for key "rsa-key-20200507":
Activate the web console with: systemctl enable --now cockpit.socket

Last login: Tue Apr 18 02:59:46 2023 from 201.198.177.118
*************************************************************************
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash
[root@oracle-database-server-free-for-developers opc]# df -Th
Filesystem                 Type      Size  Used Avail Use% Mounted on
devtmpfs                   devtmpfs   16G     0   16G   0% /dev
tmpfs                      tmpfs      16G     0   16G   0% /dev/shm
tmpfs                      tmpfs      16G  8.7M   16G   1% /run
tmpfs                      tmpfs      16G     0   16G   0% /sys/fs/cgroup
/dev/mapper/ocivolume-root xfs        36G   13G   24G  35% /
/dev/mapper/ocivolume-oled xfs        10G  105M  9.9G   2% /var/oled
/dev/sda2                  xfs      1014M  323M  692M  32% /boot
/dev/sda1                  vfat      100M  5.1M   95M   6% /boot/efi
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/0
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/988
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/1000
[root@oracle-database-server-free-for-developers opc]# lvs
  LV   VG        Attr       LSize  Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  oled ocivolume -wi-ao---- 10.00g
  root ocivolume -wi-ao---- 35.47g
[root@oracle-database-server-free-for-developers opc]# pvs
  PV         VG        Fmt  Attr PSize  PFree
  /dev/sda3  ocivolume lvm2 a--  45.47g    0
[root@oracle-database-server-free-for-developers opc]# dnf -y install oci-utils
Ksplice for Oracle Linux 8 (x86_64)                                                         25 MB/s | 2.2 MB     00:00
MySQL 8.0 for Oracle Linux 8 (x86_64)                                                       40 MB/s | 3.0 MB     00:00
MySQL 8.0 Tools Community for Oracle Linux 8 (x86_64)                                      7.8 MB/s | 491 kB     00:00
MySQL 8.0 Connectors Community for Oracle Linux 8 (x86_64)                                 532 kB/s |  30 kB     00:00
Oracle Software for OCI users on Oracle Linux 8 (x86_64)                                   109 MB/s |  75 MB     00:00
Oracle Linux 8 BaseOS Latest (x86_64)                                                      105 MB/s |  57 MB     00:00
Oracle Linux 8 Application Stream (x86_64)                                                 103 MB/s |  44 MB     00:00
Oracle Linux 8 Addons (x86_64)                                                              64 MB/s | 6.9 MB     00:00
Latest Unbreakable Enterprise Kernel Release 7 for Oracle Linux 8 (x86_64)                  85 MB/s |  14 MB     00:00
Package oci-utils-0.14.0-2.el8.noarch is already installed.
Dependencies resolved.
Nothing to do.
Complete!
[root@oracle-database-server-free-for-developers opc]# oci-growfs
bash: oci-growfs: command not found
[root@oracle-database-server-free-for-developers opc]# /usr/libexec/oci-growfs
Volume Group: ocivolume
Volume Path: /dev/ocivolume/root
Mountpoint Data
---------------
          mountpoint: /
              source: /dev/mapper/ocivolume-root
     filesystem type: xfs
         source size: 35.5G
                type: lvm
                size: 35.5G
    physical devices: ['/dev/sda3']
    physical volumes: ['/dev/sda', '/dev/sda']
    partition number: ['3']
   volume group name: ocivolume
   volume group path: /dev/ocivolume/root

Partition dry run expansion "/dev/sda3" succeeded.
CHANGE: partition=3 start=2304000 old: size=95371264 end=97675264 new: size=417126367 end=419430367

Expanding partition /dev/sda3: Confirm?   [y/N] y

Partition expand expansion "/dev/sda3" succeeded.
update-partition set to true
resizing 3 on /dev/sda using resize_sfdisk_gpt
419430400 sectors of 512. total size=214748364800 bytes
## sfdisk --unit=S --dump /dev/sda
label: gpt
label-id: 812F8A56-E8ED-417C-BD3D-661E60705756
device: /dev/sda
unit: sectors
first-lba: 34
last-lba: 419430366

/dev/sda1 : start=        2048, size=      204800, type=C12A7328-F81F-11D2-BA4B-00A0C93EC93B, uuid=E673AE28-BA2F-401D-B02B-695892283475, name="EFI System Partition"
/dev/sda2 : start=      206848, size=     2097152, type=0FC63DAF-8483-4772-8E79-3D69D8477DE4, uuid=3840F016-52AC-4561-835A-02DFA72AF0E8
/dev/sda3 : start=     2304000, size=    95371264, type=E6D6D379-F507-44C2-A23C-238F2A3DF928, uuid=66916148-C5F5-4833-8FAE-8A4DE95421FD
padding 33 sectors for gpt secondary header
max_end=419430367 tot=419430400 pt_end=97675264 pt_start=2304000 pt_size=95371264
resize of /dev/sda returned 0.

CHANGED: partition=3 start=2304000 old: size=95371264 end=97675264 new: size=417126367 end=419430367

Extending /dev/sda3 succeeded.
Device /dev/sda3 extended successfully.
Logical volume /dev/ocivolume/root extended successfully.
[root@oracle-database-server-free-for-developers opc]# df -Th
Filesystem                 Type      Size  Used Avail Use% Mounted on
devtmpfs                   devtmpfs   16G     0   16G   0% /dev
tmpfs                      tmpfs      16G     0   16G   0% /dev/shm
tmpfs                      tmpfs      16G  8.7M   16G   1% /run
tmpfs                      tmpfs      16G     0   16G   0% /sys/fs/cgroup
/dev/mapper/ocivolume-root xfs       189G   14G  176G   8% /
/dev/mapper/ocivolume-oled xfs        10G  105M  9.9G   2% /var/oled
/dev/sda2                  xfs      1014M  323M  692M  32% /boot
/dev/sda1                  vfat      100M  5.1M   95M   6% /boot/efi
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/0
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/988
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/1000
[root@oracle-database-server-free-for-developers opc]#


*************************************************************************
[opc@oracle-database-server-free-for-developers ~]$ df -Th
Filesystem                 Type      Size  Used Avail Use% Mounted on
devtmpfs                   devtmpfs   16G     0   16G   0% /dev
tmpfs                      tmpfs      16G     0   16G   0% /dev/shm
tmpfs                      tmpfs      16G  8.7M   16G   1% /run
tmpfs                      tmpfs      16G     0   16G   0% /sys/fs/cgroup
/dev/mapper/ocivolume-root xfs        89G   13G   77G  15% /
/dev/sda2                  xfs      1014M  323M  692M  32% /boot
/dev/sda1                  vfat      100M  5.0M   95M   6% /boot/efi
/dev/mapper/ocivolume-oled xfs        10G  107M  9.9G   2% /var/oled
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/0
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/988
tmpfs                      tmpfs     3.2G     0  3.2G   0% /run/user/1000
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash

[root@oracle-database-server-free-for-developers opc]# dnf install *oracle-database*
Last metadata expiration check: 0:00:59 ago on Tue 18 Apr 2023 03:23:23 AM GMT.
Dependencies resolved.
====================================================================================================
 Package                              Architecture   Version                Repository         Size
====================================================================================================
Installing:
 oracle-database-preinstall-19c       x86_64         1.0-2.el8              ol8_appstream      31 k
 oracle-database-preinstall-21c       x86_64         1.0-1.el8              ol8_appstream      30 k
Installing dependencies:
 compat-openssl10                     x86_64         1:1.0.2o-4.el8_6       ol8_appstream     1.1 M
 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-xcb                           x86_64         1.6.8-5.el8            ol8_appstream      14 k
 libXcomposite                        x86_64         0.4.4-14.el8           ol8_appstream      28 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
 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
 libaio-devel                         x86_64         0.3.112-1.el8          ol8_baseos_lates   19 k
 libdmx                               x86_64         1.1.4-3.el8            ol8_appstream      22 k
 libnsl                               x86_64         2.28-211.0.1.el8       ol8_baseos_lates  105 k
 libstdc++-devel                      x86_64         8.5.0-16.0.1.el8_7     ol8_appstream     2.1 M
 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

Transaction Summary
====================================================================================================
Install  24 Packages

Total download size: 5.1 M
Installed size: 19 M
Is this ok [y/N]: y
Downloading Packages:
(1/24): libaio-devel-0.3.112-1.el8.x86_64.rpm                           792 kB/s |  19 kB     00:00
(2/24): ksh-20120801-257.0.1.el8.x86_64.rpm                              42 MB/s | 929 kB     00:00
(3/24): libnsl-2.28-211.0.1.el8.x86_64.rpm                              993 kB/s | 105 kB     00:00
(4/24): libICE-1.0.9-15.el8.x86_64.rpm                                  945 kB/s |  74 kB     00:00
(5/24): libX11-xcb-1.6.8-5.el8.x86_64.rpm                               2.1 MB/s |  14 kB     00:00
(6/24): libXcomposite-0.4.4-14.el8.x86_64.rpm                           2.2 MB/s |  28 kB     00:00
(7/24): libXi-1.7.10-1.el8.x86_64.rpm                                   4.4 MB/s |  49 kB     00:00
(8/24): libXinerama-1.1.4-1.el8.x86_64.rpm                              1.2 MB/s |  15 kB     00:00
(9/24): libSM-1.2.3-1.el8.x86_64.rpm                                    522 kB/s |  47 kB     00:00
(10/24): libXrandr-1.5.2-1.el8.x86_64.rpm                               5.0 MB/s |  34 kB     00:00
(11/24): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm                     4.5 MB/s | 1.1 MB     00:00
(12/24): libXtst-1.2.3-7.el8.x86_64.rpm                                 2.4 MB/s |  22 kB     00:00
(13/24): libXt-1.1.5-12.el8.x86_64.rpm                                  2.4 MB/s | 185 kB     00:00
(14/24): libXv-1.0.11-7.el8.x86_64.rpm                                  262 kB/s |  20 kB     00:00
(15/24): libXxf86dga-1.1.5-1.el8.x86_64.rpm                             308 kB/s |  26 kB     00:00
(16/24): libXxf86vm-1.1.4-9.el8.x86_64.rpm                              1.9 MB/s |  19 kB     00:00
(17/24): libXmu-1.1.3-1.el8.x86_64.rpm                                  337 kB/s |  75 kB     00:00
(18/24): libdmx-1.1.4-3.el8.x86_64.rpm                                  191 kB/s |  22 kB     00:00
(19/24): libXxf86misc-1.0.4-1.el8.x86_64.rpm                            123 kB/s |  23 kB     00:00
(20/24): oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm            627 kB/s |  31 kB     00:00
(21/24): xorg-x11-utils-7.5-28.el8.x86_64.rpm                            24 MB/s | 136 kB     00:00
(22/24): libstdc++-devel-8.5.0-16.0.1.el8_7.x86_64.rpm                  9.8 MB/s | 2.1 MB     00:00
(23/24): oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm             91 kB/s |  30 kB     00:00
(24/24): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm                         117 kB/s |  39 kB     00:00
--------------------------------------------------------------------------------------------------------
Total                                                                   5.7 MB/s | 5.1 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                 1/1
  Installing       : libXi-1.7.10-1.el8.x86_64                                      1/24
  Installing       : libICE-1.0.9-15.el8.x86_64                                     2/24
  Installing       : ksh-20120801-257.0.1.el8.x86_64                                3/24
  Running scriptlet: ksh-20120801-257.0.1.el8.x86_64                                3/24
  Installing       : libnsl-2.28-211.0.1.el8.x86_64                                 4/24
  Installing       : libSM-1.2.3-1.el8.x86_64                                       5/24
  Installing       : libXt-1.1.5-12.el8.x86_64                                      6/24
  Installing       : libXmu-1.1.3-1.el8.x86_64                                      7/24
  Installing       : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                           8/24
  Installing       : libXtst-1.2.3-7.el8.x86_64                                     9/24
  Installing       : libstdc++-devel-8.5.0-16.0.1.el8_7.x86_64                     10/24
  Installing       : libdmx-1.1.4-3.el8.x86_64                                     11/24
  Installing       : libXxf86vm-1.1.4-9.el8.x86_64                                 12/24
  Installing       : libXxf86misc-1.0.4-1.el8.x86_64                               13/24
  Installing       : libXxf86dga-1.1.5-1.el8.x86_64                                14/24
  Installing       : libXv-1.0.11-7.el8.x86_64                                     15/24
  Installing       : libXrandr-1.5.2-1.el8.x86_64                                  16/24
  Installing       : libXinerama-1.1.4-1.el8.x86_64                                17/24
  Installing       : libXcomposite-0.4.4-14.el8.x86_64                             18/24
  Installing       : libX11-xcb-1.6.8-5.el8.x86_64                                 19/24
  Installing       : xorg-x11-utils-7.5-28.el8.x86_64                              20/24
  Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                      21/24
  Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64                      21/24
  Installing       : libaio-devel-0.3.112-1.el8.x86_64                             22/24
  Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64               23/24
  Installing       : oracle-database-preinstall-19c-1.0-2.el8.x86_64               23/24
  Installing       : oracle-database-preinstall-21c-1.0-1.el8.x86_64               24/24
  Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64               24/24
  Running scriptlet: oracle-database-preinstall-21c-1.0-1.el8.x86_64               24/24
  Verifying        : libaio-devel-0.3.112-1.el8.x86_64                              1/24
  Verifying        : libnsl-2.28-211.0.1.el8.x86_64                                 2/24
  Verifying        : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                       3/24
  Verifying        : ksh-20120801-257.0.1.el8.x86_64                                4/24
  Verifying        : libICE-1.0.9-15.el8.x86_64                                     5/24
  Verifying        : libSM-1.2.3-1.el8.x86_64                                       6/24
  Verifying        : libX11-xcb-1.6.8-5.el8.x86_64                                  7/24
  Verifying        : libXcomposite-0.4.4-14.el8.x86_64                              8/24
  Verifying        : libXi-1.7.10-1.el8.x86_64                                      9/24
  Verifying        : libXinerama-1.1.4-1.el8.x86_64                                10/24
  Verifying        : libXmu-1.1.3-1.el8.x86_64                                     11/24
  Verifying        : libXrandr-1.5.2-1.el8.x86_64                                  12/24
  Verifying        : libXt-1.1.5-12.el8.x86_64                                     13/24
  Verifying        : libXtst-1.2.3-7.el8.x86_64                                    14/24
  Verifying        : libXv-1.0.11-7.el8.x86_64                                     15/24
  Verifying        : libXxf86dga-1.1.5-1.el8.x86_64                                16/24
  Verifying        : libXxf86misc-1.0.4-1.el8.x86_64                               17/24
  Verifying        : libXxf86vm-1.1.4-9.el8.x86_64                                 18/24
  Verifying        : libdmx-1.1.4-3.el8.x86_64                                     19/24
  Verifying        : libstdc++-devel-8.5.0-16.0.1.el8_7.x86_64                     20/24
  Verifying        : oracle-database-preinstall-19c-1.0-2.el8.x86_64               21/24
  Verifying        : oracle-database-preinstall-21c-1.0-1.el8.x86_64               22/24
  Verifying        : xorg-x11-utils-7.5-28.el8.x86_64                              23/24
  Verifying        : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                          24/24

Installed:
  compat-openssl10-1:1.0.2o-4.el8_6.x86_64       
  libSM-1.2.3-1.el8.x86_64                       
  libXi-1.7.10-1.el8.x86_64                      
  libXrandr-1.5.2-1.el8.x86_64                   
  libXv-1.0.11-7.el8.x86_64                      
  libXxf86vm-1.1.4-9.el8.x86_64                  
  libnsl-2.28-211.0.1.el8.x86_64                 
  oracle-database-preinstall-21c-1.0-1.el8.x86_64
  ksh-20120801-257.0.1.el8.x86_64                
  libX11-xcb-1.6.8-5.el8.x86_64                  
  libXinerama-1.1.4-1.el8.x86_64                 
  rlibXt-1.1.5-12.el8.x86_64                     
  ChlibXxf86dga-1.1.5-1.el8.x86_64               
  Relibaio-devel-0.3.112-1.el8.x86_64            
  palibstdc++-devel-8.5.0-16.0.1.el8_7.x86_64    
  xorg-x11-utils-7.5-28.el8.x86_64 
  libICE-1.0.9-15.el8.x86_64
  libXcomposite-0.4.4-14.el8.x86_64
  libXmu-1.1.3-1.el8.x86_64
  complete!
  
[root@oracle-database-server-free-for-developers opc]# passwd oracleoot@oracle-database-server-free-for-developers opc]# mkdir /opt/oracle
[root@oracle-database-server-free-for-developers opc]# wget  --load-cookies="$COOKIE_FILE" "https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm" -O "/opt/oracle-database-free-23c-1.0-1.el8.x86_64.rpm"
passwd: all authentication tokens updated successfully.2023-04-18 03:25:13--  https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Rsolving download.oracle.com (download.oracle.com)... 23.204.253.27
Connecting to download.oracle.com (download.oracle.com)|23.204.253.27|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://edelivery.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm [following]
--2023-04-18 03:25:13--  https://edelivery.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Resolving edelivery.oracle.com (edelivery.oracle.com)... 104.69.221.219, 2600:1408:c400:1886::366, 2600:1408:c400:1889::366
Connecting to edelivery.oracle.com (edelivery.oracle.com)|104.69.221.219|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm?AuthParam=1681788433_6cdcaf2c35648a5164a9f29cece306ec [following]
--2023-04-18 03:25:13--  https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm?AuthParam=1681788433_6cdcaf2c35648a5164a9f29cece306ec
Connecting to download.oracle.com (download.oracle.com)|23.204.253.27|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1758776440 (1.6G) [application/x-redhat-package-manager]
Saving to: ‘/opt/oracle-database-free-23c-1.0-1.el8.x86_64.rpm’

                            /opt/oracle-d   9%[=======>        ] 158.00M  5.94MB/s    eta 4m 37s

[root@oracle-database-server-free-for-developers opt]# dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:07:01 ago on Tue 18 Apr 2023 03:23:23 AM GMT.
Error:
 Problem: conflicting requests
  - nothing provides oracle-database-preinstall-23c needed by oracle-database-free-23c-1.0-1.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)


[root@oracle-database-server-free-for-developers opt]# curl -L -o /opt/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  13904      0  0:00:02  0:00:02 --:--:-- 13911
[root@oracle-database-server-free-for-developers opt]# ls -la
total 1717588
drwxr-xr-x.  5 root root        176 Apr 18 03:32 .
dr-xr-xr-x. 17 root root        241 Apr 18 03:24 ..
drwxr-xr-x.  2 root root          6 Apr 18 03:25 oracle
-rw-r--r--.  1 root root 1758776440 Mar 31 14:17 oracle-database-free-23c-1.0-1.el8.x86_64.rpm
-rw-r--r--.  1 root root      30688 Apr 18 03:32 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
drwxr-xr-x.  4 root root         50 Jan 17 19:52 rh
drwxrwxr-x.  5 root root        148 Apr 18 03:06 unified-monitoring-agent
[root@oracle-database-server-free-for-developers opt]# dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Last metadata expiration check: 0:01:43 ago on Tue 18 Apr 2023 03:31:16 AM GMT.
Dependencies resolved.
=========================================================================================
 Package                            Architecture   Version          Repository      Size
=========================================================================================
Installing:
 oracle-database-preinstall-23c     x86_64         1.0-0.5.el8      @commandline    30 k

Transaction Summary
=========================================================================================
Install  1 Package

Total size: 30 k
Installed size: 77 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Installing       : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64      1/1
  Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64      1/1
  Verifying        : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64      1/1

Installed:
  oracle-database-preinstall-23c-1.0-0.5.el8.x86_64

Complete!

[root@oracle-database-server-free-for-developers opt]# chown -R oracle:oinstall /opt
[root@oracle-database-server-free-for-developers opt]# dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:02:51 ago on Tue 18 Apr 2023 03:31:16 AM GMT.
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@oracle-database-server-free-for-developers opt]# more /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
[root@oracle-database-server-free-for-developers opt]# /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.
InstEnter SYS user password:     ************
Enter SYSTEM user password:
**************
Enter PDBADMIN User Password:
*************
laPrepare 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: oracle-database-server-free-for-developers/FREEPDB1
     Multitenant container database: oracle-database-server-free-for-developers
[root@oracle-database-server-free-for-developers opt]#

[opc@oracle-database-server-free-for-developers ~]$ sudo su - oracle
Last login: Tue Apr 18 03:38:52 GMT 2023 on pts/0
[oracle@oracle-database-server-free-for-developers ~]$ lsnrctl status
-bash: lsnrctl: command not found
[oracle@oracle-database-server-free-for-developers ~]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base has been set to /opt/oracle
[oracle@oracle-database-server-free-for-developers ~]$ lsnrctl status

LSNRCTL for Linux: Version 23.0.0.0.0 - Developer-Release on 18-APR-2023 03:44:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 23.0.0.0.0 - Developer-Release
Start Date                18-APR-2023 03:38:52
Uptime                    0 days 0 hr. 5 min. 19 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/oracle-database-server-free-for-developers/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
  (HOST=oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)(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 "f99518bb1dfbd9ace053280a000ae947" 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@oracle-database-server-free-for-developers ~]$


[oracle@oracle-database-server-free-for-developers ~]$ cd $ORACLE_HOME
[oracle@oracle-database-server-free-for-developers dbhomeFree]$ cd network/admin
[oracle@oracle-database-server-free-for-developers admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/23c/dbhomeFree/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

FREE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = FREE)
    )
  )

LISTENER_FREE =
  (ADDRESS = (PROTOCOL = TCP)
  (HOST = oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)(PORT = 1521))


[oracle@oracle-database-server-free-for-developers admin]$ vi tnsnames.ora
[oracle@oracle-database-server-free-for-developers admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/23c/dbhomeFree/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

FREE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = FREE)
    )
  )

LISTENER_FREE =
  (ADDRESS = (PROTOCOL = TCP)
  (HOST = oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)(PORT = 1521))


pdb1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = freepdb1)
    )
  )
[oracle@oracle-database-server-free-for-developers admin]$ tnsping pdb1

TNS Ping Utility for Linux: Version 23.0.0.0.0 - Developer-Release on 18-APR-2023 03:46:04

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

Used parameter files:
/opt/oracle/product/23c/dbhomeFree/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = oracle-database-server-free-for-developers.vcnlandb.vcntestinglab.oraclevcn.com)
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = freepdb1)))
OK (0 msec)
[oracle@oracle-database-server-free-for-developers admin]$ sqlplus system@pdb1

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 18 03:46:10 2023
Version 23.2.0.0.0

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

Enter password:
Last Successful login time: Tue Apr 18 2023 03:41:49 +00:00

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

SQL> show user
USER is "SYSTEM"
SQL>

SQL> col owner format a40

SQL> select count(*), owner from dba_objects
  2  group by owner;

  COUNT(*) OWNER
---------- ----------------------------------------
     56759 SYS
     12781 PUBLIC
        10 OUTLN
        89 SYSTEM
       285 GSMADMIN_INTERNAL
         8 DBSFWUSER
        47 AUDSYS
         2 GGSHAREDCAP
        29 DBSNMP
         6 APPQOSSYS
        13 REMOTE_SCHEDULER_AGENT
      1021 XDB
       423 WMSYS
        33 OJVMSYS
       416 CTXSYS
        25 OLAPSYS
      4649 MDSYS
       239 LBACSYS
        22 DVF
       417 DVSYS

20 rows selected.

SQL>


[oracle@oracle-database-server-free-for-developers install]$ cd ..
[oracle@oracle-database-server-free-for-developers dbhomeFree]$ pwd
/opt/oracle/product/23c/dbhomeFree
[oracle@oracle-database-server-free-for-developers dbhomeFree]$ cd /opt
[oracle@oracle-database-server-free-for-developers opt]$ ls -la
total 1717588
drwxr-xr-x.  6 oracle oinstall        192 Apr 18 03:36 .
dr-xr-xr-x. 17 root   root            241 Apr 18 03:33 ..
drwxr-xr-x.  9 oracle oinstall        113 Apr 18 03:38 oracle
-rw-r--r--.  1 oracle oinstall 1758776440 Mar 31 14:17 oracle-database-free-23c-1.0-1.el8.x86_64.rpm
-rw-r--r--.  1 oracle oinstall      30688 Apr 18 03:32 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
drwxr-xr-x.  3 root   root             22 Apr 18 03:36 ORCLfmap
drwxr-xr-x.  4 oracle oinstall         50 Jan 17 19:52 rh
drwxrwxr-x.  5 oracle oinstall        148 Apr 18 03:06 unified-monitoring-agent
[oracle@oracle-database-server-free-for-developers opt]$ mkdir schemas_demo
[oracle@oracle-database-server-free-for-developers opt]$ cd schemas_demo/
[oracle@oracle-database-server-free-for-developers schemas_demo]$ git clone https://github.com/oracle/db-sample-schemas.git
-bash: git: command not found
[oracle@oracle-database-server-free-for-developers schemas_demo]$ exit
logout
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash
[root@oracle-database-server-free-for-developers opc]# dnf -y install git
Last metadata expiration check: 0:24:08 ago on Tue 18 Apr 2023 03:31:16 AM GMT.
Dependencies resolved.
===============================================================================================
 Package                      Architecture     Version               Repository           Size
===============================================================================================
Installing:
 git                          x86_64           2.31.1-3.el8_7        ol8_appstream       162 k
Installing dependencies:
 git-core                     x86_64           2.31.1-3.el8_7        ol8_appstream       4.8 M
 git-core-doc                 noarch           2.31.1-3.el8_7        ol8_appstream       2.6 M
 perl-Error                   noarch           1:0.17025-2.el8       ol8_appstream        46 k
 perl-Git                     noarch           2.31.1-3.el8_7        ol8_appstream        78 k
 perl-TermReadKey             x86_64           2.37-7.el8            ol8_appstream        40 k

Transaction Summary
===============================================================================================
Install  6 Packages

Total download size: 7.7 M
Installed size: 38 M
Downloading Packages:
(1/6): git-2.31.1-3.el8_7.x86_64.rpm                 4.4 MB/s | 162 kB     00:00
(2/6): perl-Error-0.17025-2.el8.noarch.rpm           4.5 MB/s |  46 kB     00:00
(3/6): git-core-doc-2.31.1-3.el8_7.noarch.rpm         46 MB/s | 2.6 MB     00:00
(4/6): perl-Git-2.31.1-3.el8_7.noarch.rpm            5.3 MB/s |  78 kB     00:00
(5/6): perl-TermReadKey-2.37-7.el8.x86_64.rpm        8.2 MB/s |  40 kB     00:00
(6/6): git-core-2.31.1-3.el8_7.x86_64.rpm             52 MB/s | 4.8 MB     00:00
-------------------------------------------------------------------------------------
Total                                                 80 MB/s | 7.7 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                            1/1
  Installing       : git-core-2.31.1-3.el8_7.x86_64             1/6
  Installing       : git-core-doc-2.31.1-3.el8_7.noarch         2/6
  Installing       : perl-TermReadKey-2.37-7.el8.x86_64         3/6
  Installing       : perl-Error-1:0.17025-2.el8.noarch          4/6
  Installing       : perl-Git-2.31.1-3.el8_7.noarch             5/6
  Installing       : git-2.31.1-3.el8_7.x86_64                  6/6
  Running scriptlet: git-2.31.1-3.el8_7.x86_64                  6/6
  Verifying        : git-2.31.1-3.el8_7.x86_64                  1/6
  Verifying        : git-core-2.31.1-3.el8_7.x86_64             2/6
  Verifying        : git-core-doc-2.31.1-3.el8_7.noarch         3/6
  Verifying        : perl-Error-1:0.17025-2.el8.noarch          4/6
  Verifying        : perl-Git-2.31.1-3.el8_7.noarch             5/6
  Verifying        : perl-TermReadKey-2.37-7.el8.x86_64         6/6

Installed:
  git-2.31.1-3.el8_7.x86_64          git-core-2.31.1-3.el8_7.x86_64 git-core-doc-2.31.1-3.el8_7.noarch 
  perl-Error-1:0.17025-2.el8.noarch perl-Git-2.31.1-3.el8_7.noarch
  perl-TermReadKey-2.37-7.el8.x86_64

Complete!
[root@oracle-database-server-free-for-developers opc]# exit
exit
[opc@oracle-database-server-free-for-developers ~]$ sudo su - oracle
Last login: Tue Apr 18 03:44:02 GMT 2023 on pts/0
[oracle@oracle-database-server-free-for-developers ~]$ cd /opt/schemas_demo/
[oracle@oracle-database-server-free-for-developers schemas_demo]$ git clone https://github.com/oracle/db-sample-schemas.git
Cloning into 'db-sample-schemas'...
remote: Enumerating objects: 973, done.
remote: Counting objects: 100% (123/123), done.
remote: Compressing objects: 100% (57/57), done.
remote: Total 973 (delta 110), reused 68 (delta 66), pack-reused 850
Receiving objects: 100% (973/973), 42.87 MiB | 26.72 MiB/s, done.
Resolving deltas: 100% (586/586), done.
[oracle@oracle-database-server-free-for-developers schemas_demo]$ ls -la
total 8
drwxr-xr-x.  3 oracle oinstall   31 Apr 18 03:55 .
drwxr-xr-x.  7 oracle oinstall 4096 Apr 18 03:55 ..
drwxr-xr-x. 11 oracle oinstall 4096 Apr 18 03:55 db-sample-schemas
[oracle@oracle-database-server-free-for-developers schemas_demo]$


[oracle@oracle-database-server-free-for-developers db-sample-schemas]$ pwd
/opt/schemas_demo/db-sample-schemas
[oracle@oracle-database-server-free-for-developers db-sample-schemas]$ perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat
[oracle@oracle-database-server-free-for-developers db-sample-schemas]$ ls -la
total 184
drwxr-xr-x. 11 oracle oinstall  4096 Apr 18 04:02 .
drwxr-xr-x.  3 oracle oinstall    31 Apr 18 03:55 ..
drwxr-xr-x.  2 oracle oinstall   180 Apr 18 04:02 bus_intelligence
-rw-r--r--.  1 oracle oinstall   117 Apr 18 03:55 CONTRIBUTING.md
drwxr-xr-x.  2 oracle oinstall  4096 Apr 18 04:02 customer_orders
-rw-r--r--.  1 oracle oinstall  3633 Apr 18 04:02 drop_sch.sql
-rw-r--r--.  1 oracle oinstall  3633 Apr 18 03:55 drop_sch.sql.bak
drwxr-xr-x.  8 oracle oinstall   163 Apr 18 03:55 .git
drwxr-xr-x.  2 oracle oinstall  4096 Apr 18 04:02 human_resources
drwxr-xr-x.  2 oracle oinstall   168 Apr 18 04:02 info_exchange
-rw-r--r--.  1 oracle oinstall  1050 Apr 18 03:55 LICENSE.txt
-rw-r--r--.  1 oracle oinstall  2809 Apr 18 04:02 mk_dir.sql
-rw-r--r--.  1 oracle oinstall  2740 Apr 18 03:55 mk_dir.sql.bak
-rw-r--r--.  1 oracle oinstall 27940 Apr 18 04:02 mkplug.sql
-rw-r--r--.  1 oracle oinstall 27756 Apr 18 03:55 mkplug.sql.bak
-rw-r--r--.  1 oracle oinstall  7419 Apr 18 04:02 mksample.sql
-rw-r--r--.  1 oracle oinstall  7166 Apr 18 03:55 mksample.sql.bak
-rw-r--r--.  1 oracle oinstall  6592 Apr 18 04:02 mkunplug.sql
-rw-r--r--.  1 oracle oinstall  6592 Apr 18 03:55 mkunplug.sql.bak
-rw-r--r--.  1 oracle oinstall  6123 Apr 18 04:02 mkverify.sql
-rw-r--r--.  1 oracle oinstall  6123 Apr 18 03:55 mkverify.sql.bak
drwxr-xr-x.  3 oracle oinstall  8192 Apr 18 04:02 order_entry
drwxr-xr-x.  2 oracle oinstall  4096 Apr 18 04:02 product_media
-rw-r--r--.  1 oracle oinstall  6294 Apr 18 03:55 README.md
-rw-r--r--.  1 oracle oinstall  5263 Apr 18 03:55 README.txt
drwxr-xr-x.  2 oracle oinstall  4096 Apr 18 04:02 sales_history
-rw-r--r--.  1 oracle oinstall  1742 Apr 18 03:55 SECURITY.md
drwxr-xr-x.  2 oracle oinstall  4096 Apr 18 04:02 shipping
[oracle@oracle-database-server-free-for-developers db-sample-schemas]$ more mksample.sql
Rem
Rem $Header: rdbms/demo/schema/mksample.sql.sbs /main/12 2015/03/19 10:23:26 smtaylor Exp $
Rem
Rem mksample.sql
Rem
Rem Copyright (c) 2001, 2016, Oracle and/or its affiliates.  All rights reserved.
.....

SET SHOWMODE OFF

@/opt/schemas_demo/db-sample-schemas/human_resources/hr_main.sql &&password_hr &&default_ts &&temp_ts &&password_sys &&logfile_dir &&connect_string

CONNECT system/&&password_system@&&connect_string
SET SHOWMODE OFF

@/opt/schemas_demo/db-sample-schemas/order_entry/oe_main.sql &&password_oe &&default_ts &&temp_ts &&password_hr &&password_sys /opt/schemas_demo/db-sample-schemas/order
_entry/ &&logfile_dir &vrs &&connect_string

CONNECT system/&&password_system@&&connect_string

SET SHOWMODE OFF

[oracle@oracle-database-server-free-for-developers db-sample-schemas]$


SQL> @/opt/schemas_demo/db-sample-schemas/mksample.sql Mexico$2023 Mexico$2023 hrPassword1 oePassword1 pmPassword1 ixPassword1 shPassword1 biPassword1 users temp /opt/schemas_demo/db-sample-schemas/ localhost:1521/freepdb1

specify password for SYSTEM as parameter 1:

specify password for SYS as parameter 2:

specify password for HR as parameter 3:

specify password for OE as parameter 4:

specify password for PM as parameter 5:

specify password for IX as parameter 6:

specify password for  SH as parameter 7:

specify password for  BI as parameter 8:

specify default tablespace as parameter 9:

specify temporary tablespace as parameter 10:

specify log file directory (including trailing delimiter) as parameter 11:

specify connect string as parameter 12:

Sample Schemas are being created ...

mkdir: cannot create directory ‘/opt/schemas_demo/db-sample-schemas/’: File exists

Connected.
DROP USER hr CASCADE
          *
ERROR at line 1:
ORA-01918: user 'HR' does not exist


DROP USER oe CASCADE
          *
ERROR at line 1:
ORA-01918: user 'OE' does not exist


DROP USER pm CASCADE
          *
ERROR at line 1:
ORA-01918: user 'PM' does not exist


DROP USER ix CASCADE
          *
ERROR at line 1:
ORA-01918: user 'IX' does not exist


DROP USER sh CASCADE
          *
ERROR at line 1:
ORA-01918: user 'SH' does not exist

DROP USER bi CASCADE
          *
ERROR at line 1:
ORA-01918: user 'BI' does not exist


Connected.
specify password for HR as parameter 1:
specify default tablespeace for HR as parameter 2:
specify temporary tablespace for HR as parameter 3:
specify password for SYS as parameter 4:
specify log path as parameter 5:
specify connect string as parameter 6:

DROP USER hr CASCADE
          *
ERROR at line 1:
ORA-01918: user 'HR' does not exist

User created.
User altered.
User altered.
Grant succeeded.
...
Table cardinality relational and object tables

OWNER  TABLE_NAME                       NUM_ROWS
------ ------------------------------ ----------
HR     COUNTRIES                              25
HR     DEPARTMENTS                            27
HR     EMPLOYEES                             107
HR     JOBS                                   19
HR     JOB_HISTORY                            10
HR     LOCATIONS                              23
HR     REGIONS                                 4
IX     AQ$_ORDERS_QUEUETABLE_G                 0
IX     AQ$_ORDERS_QUEUETABLE_H                 2
IX     AQ$_ORDERS_QUEUETABLE_I                 2
IX     AQ$_ORDERS_QUEUETABLE_L                 2
IX     AQ$_ORDERS_QUEUETABLE_S                 4
IX     AQ$_ORDERS_QUEUETABLE_T                 0
IX     AQ$_STREAMS_QUEUE_TABLE_C               0
IX     AQ$_STREAMS_QUEUE_TABLE_G               0
IX     AQ$_STREAMS_QUEUE_TABLE_H               0
IX     AQ$_STREAMS_QUEUE_TABLE_I               0
IX     AQ$_STREAMS_QUEUE_TABLE_L               0
IX     AQ$_STREAMS_QUEUE_TABLE_S               1
IX     AQ$_STREAMS_QUEUE_TABLE_T               0
IX     ORDERS_QUEUETABLE                       1
IX     STREAMS_QUEUE_TABLE                     0
IX     SYS_IOT_OVER_78101                      0
IX     SYS_IOT_OVER_78130                      0
OE     ACTION_TABLE                          132
OE     CATEGORIES_TAB                         22
OE     CUSTOMERS                             319
OE     INVENTORIES                          1112
OE     LINEITEM_TABLE                       2232
OE     ORDERS                                105
OE     ORDER_ITEMS                           665
OE     PRODUCT_DESCRIPTIONS                 8640
OE     PRODUCT_INFORMATION                   288
OE     PRODUCT_REF_LIST_NESTEDTAB            288
OE     PROMOTIONS                              2
OE     PURCHASEORDER                         132
OE     SUBCATEGORY_REF_LIST_NESTEDTAB         21
OE     WAREHOUSES                              9
PM     PRINT_MEDIA                             4
PM     TEXTDOCS_NESTEDTAB                     12
SH     CAL_MONTH_SALES_MV                     48
SH     CHANNELS                                5
SH     COSTS                               82112
SH     COUNTRIES                              23
SH     CUSTOMERS                           55500
SH     DR$SUP_TEXT_IDX$B
SH     DR$SUP_TEXT_IDX$C
SH     DR$SUP_TEXT_IDX$I
SH     DR$SUP_TEXT_IDX$K
SH     DR$SUP_TEXT_IDX$N
SH     DR$SUP_TEXT_IDX$Q
SH     DR$SUP_TEXT_IDX$U
SH     FWEEK_PSCAT_SALES_MV                11266
SH     PRODUCTS                               72
SH     PROMOTIONS                            503
SH     SALES                              918843
SH     SALES_TRANSACTIONS_EXT             916039
SH     SUPPLEMENTARY_DEMOGRAPHICS           4500
SH     TIMES                                1826

59 rows selected.


Index cardinality (without  LOB indexes)

OWNER  INDEX_NAME                DISTINCT_KEYS   NUM_ROWS
------ ------------------------- ------------- ----------
HR     COUNTRY_C_ID_PK                      25         25
HR     DEPT_ID_PK                           27         27
HR     DEPT_LOCATION_IX                      7         27
HR     EMP_DEPARTMENT_IX                    11        106
HR     EMP_EMAIL_UK                        107        107
HR     EMP_EMP_ID_PK                       107        107
HR     EMP_JOB_IX                           19        107
HR     EMP_MANAGER_IX                       18        106
HR     EMP_NAME_IX                         107        107
HR     JHIST_DEPARTMENT_IX                   6         10
HR     JHIST_EMPLOYEE_IX                     7         10
HR     JHIST_EMP_ID_ST_DATE_PK              10         10
HR     JHIST_JOB_IX                          8         10
HR     JOB_ID_PK                            19         19
HR     LOC_CITY_IX                          23         23
HR     LOC_COUNTRY_IX                       14         23
HR     LOC_ID_PK                            23         23
HR     LOC_STATE_PROVINCE_IX                17         17
HR     REG_ID_PK                             4          4
IX     AQ$_STREAMS_QUEUE_TABLE_Y             0          0
OE     ACTION_TABLE_MEMBERS                132        132
OE     CUSTOMERS_PK                        319        319
OE     CUST_ACCOUNT_MANAGER_IX               4        319
OE     CUST_EMAIL_IX                       319        319
OE     CUST_LNAME_IX                       176        319
OE     CUST_UPPER_NAME_IX                  319        319
OE     INVENTORY_IX                       1112       1112
OE     INV_PRODUCT_IX                      208       1112
OE     ITEM_ORDER_IX                       105        665
OE     ITEM_PRODUCT_IX                     185        665
OE     LINEITEM_TABLE_MEMBERS              132        132
OE     ORDER_ITEMS_PK                      665        665
OE     ORDER_ITEMS_UK                      665        665
OE     ORDER_PK                            105        105
OE     ORD_CUSTOMER_IX                      47        105
OE     ORD_ORDER_DATE_IX                   105        105
OE     ORD_SALES_REP_IX                      9         70
OE     PRD_DESC_PK                        8640       8640
OE     PRODUCT_INFORMATION_PK              288        288
OE     PROD_NAME_IX                       3727       8640
OE     PROD_SUPPLIER_IX                     62        288
OE     PROMO_ID_PK                           2          2
OE     WAREHOUSES_PK                         9          9
OE     WHS_LOCATION_IX                       9          9
PM     PRINTMEDIA_PK                         4          4
SH     CHANNELS_PK                           5          5
SH     COSTS_PROD_BIX                       72       1068
SH     COSTS_TIME_BIX                     1460       1460
SH     COUNTRIES_PK                         23         23
SH     CUSTOMERS_GENDER_BIX                  2          5
SH     CUSTOMERS_MARITAL_BIX                11         18
SH     CUSTOMERS_PK                      55500      55500
SH     CUSTOMERS_YOB_BIX                    75         75
SH     DR$SUP_TEXT_IDX$KD                    0          0
SH     DR$SUP_TEXT_IDX$KR                    0          0
SH     DR$SUP_TEXT_IDX$X                     0          0
SH     FW_PSC_S_MV_CHAN_BIX                  4          4
SH     FW_PSC_S_MV_PROMO_BIX                 4          4
SH     FW_PSC_S_MV_SUBCAT_BIX               21         21
SH     FW_PSC_S_MV_WD_BIX                  210        210
SH     PRODUCTS_PK                          72         72
SH     PRODUCTS_PROD_CAT_IX                  5         72
SH     PRODUCTS_PROD_STATUS_BIX              1          1
SH     PRODUCTS_PROD_SUBCAT_IX              21         72
SH     PROMO_PK                            503        503
SH     SALES_CHANNEL_BIX                     4         92
SH     SALES_CUST_BIX                     7059      35808
SH     SALES_PROD_BIX                       72       1074
SH     SALES_PROMO_BIX                       4         54
SH     SALES_TIME_BIX                     1460       1460
SH     SUP_TEXT_IDX
SH     TIMES_PK                           1826       1826

72 rows selected.

SQL>

[oracle@oracle-database-server-free-for-developers dbhomeFree]$ cd /opt

[oracle@oracle-database-server-free-for-developers dbhomeFree]$ wget https://download.oracle.com/otn_software/apex/apex-latest.zip

[oracle@oracle-database-server-free-for-developers dbhomeFree]$ cp apex-latest.zip $ORACLE_HOME/

[oracle@oracle-database-server-free-for-developers dbhomeFree]$ cd $ORACLE_HOME

[oracle@oracle-database-server-free-for-developers dbhomeFree]$ unzip apex-latest.zip


  inflating: apex/utilities/reset_image_prefix_core.sql
  inflating: apex/utilities/apxpart.sql
  inflating: apex/utilities/reset_image_prefix.sql
  inflating: apex/utilities/readme.txt
  inflating: apex/utilities/apxrekey.sql
  inflating: apex/apexins_cdb.sql
[oracle@oracle-database-server-free-for-developers dbhomeFree]$ cd apex
[oracle@oracle-database-server-free-for-developers apex]$ ls -la
total 480
drwxr-xr-x.  6 oracle oinstall  4096 Nov 11 19:38 .
drwxrwxr-x. 64 oracle oinstall  4096 Apr 22 15:15 ..
-rw-r--r--.  1 oracle oinstall  1257 Feb  7  2022 apexins1.sql
-rw-r--r--.  1 oracle oinstall  1259 Feb  7  2022 apexins2.sql
-rw-r--r--.  1 oracle oinstall  1258 Feb  7  2022 apexins3.sql
-rw-r--r--.  1 oracle oinstall  4089 Feb  7  2022 apexins_adb.sql
-rw-r--r--.  1 oracle oinstall  2081 Feb  7  2022 apexins_cdb.sql
-rw-r--r--.  1 oracle oinstall  4876 Feb  7  2022 apexins_cdb_upg.sql
-rw-r--r--.  1 oracle oinstall  8463 Feb  7  2022 apexins_nocdb.sql
-rw-r--r--.  1 oracle oinstall  5558 Feb  7  2022 apexins.sql
-rw-r--r--.  1 oracle oinstall  3034 Jul 13  2018 apex_rest_config_cdb.sql
-rw-r--r--.  1 oracle oinstall 12948 Sep 19  2022 apex_rest_config_core.sql
-rw-r--r--.  1 oracle oinstall  5312 Jul 13  2018 apex_rest_config_nocdb.sql
-rw-r--r--.  1 oracle oinstall  5054 Jan 19  2018 apex_rest_config.sql
-rw-r--r--.  1 oracle oinstall  3355 Feb  7  2022 appins.sql
-rw-r--r--.  1 oracle oinstall  4390 Feb  7  2022 apxappcon.sql
-rw-r--r--.  1 oracle oinstall  4400 Feb  7  2022 apxchpwd.sql
-rw-r--r--.  1 oracle oinstall  1733 Feb  7  2022 apxdevrm_cdb.sql
-rw-r--r--.  1 oracle oinstall 15058 Aug 29  2022 apxdevrm_nocdb.sql
-rw-r--r--.  1 oracle oinstall   947 Feb  7  2022 apxdevrm.sql
-rw-r--r--.  1 oracle oinstall  1732 Dec  4  2014 apxdvins_cdb.sql
-rw-r--r--.  1 oracle oinstall  6578 Feb  7  2022 apxdvins_nocdb.sql
-rw-r--r--.  1 oracle oinstall  2707 Jan 19  2018 apxdvins.sql
-rw-r--r--.  1 oracle oinstall  2695 Feb  7  2022 apxdwngrd.sql
-rw-r--r--.  1 oracle oinstall  2553 Jul 13  2018 apxpatch_cdb.sql
-rw-r--r--.  1 oracle oinstall   840 Jul 13  2018 apxpatch_nocdb.sql
-rw-r--r--.  1 oracle oinstall   910 Feb  7  2022 apxpatch.sql
-rw-r--r--.  1 oracle oinstall  1676 Feb  7  2022 apxremov1.sql
-rw-r--r--.  1 oracle oinstall  2960 Feb  7  2022 apxremov2.sql
-rw-r--r--.  1 oracle oinstall  2416 Feb  7  2022 apxremov_cdb.sql
-rw-r--r--.  1 oracle oinstall  2384 Feb  7  2022 apxremov_nocdb.sql
-rw-r--r--.  1 oracle oinstall  2987 Feb  7  2022 apxremov.sql
-rw-r--r--.  1 oracle oinstall  1269 Feb  7  2022 apxrtins1.sql
-rw-r--r--.  1 oracle oinstall  1271 Feb  7  2022 apxrtins2.sql
-rw-r--r--.  1 oracle oinstall  1270 Feb  7  2022 apxrtins3.sql
-rw-r--r--.  1 oracle oinstall  2105 Feb  7  2022 apxrtins_cdb.sql
-rw-r--r--.  1 oracle oinstall  5044 Feb  7  2022 apxrtins_cdb_upg.sql
-rw-r--r--.  1 oracle oinstall  7280 Feb  7  2022 apxrtins_nocdb.sql
-rw-r--r--.  1 oracle oinstall  4220 Feb  7  2022 apxrtins.sql
-rw-r--r--.  1 oracle oinstall  5888 Feb  7  2022 apxsilentins.sql
drwxr-xr-x. 33 oracle oinstall  4096 Nov 11 19:38 builder
drwxr-xr-x.  6 oracle oinstall 32768 Nov 11 19:38 core
-rw-r--r--.  1 oracle oinstall  5236 Sep  8  2020 coreins2.sql
-rw-r--r--.  1 oracle oinstall 14211 Jan 31  2022 coreins3.sql
-rw-r--r--.  1 oracle oinstall  2501 Jun 19  2020 coreins4.sql
-rw-r--r--.  1 oracle oinstall 15244 Oct  3  2022 coreins5.sql
-rw-r--r--.  1 oracle oinstall 60119 Oct  3  2022 coreins.sql
-rw-r--r--.  1 oracle oinstall  7026 Mar 28  2022 dbcsconf.sql
-rw-r--r--.  1 oracle oinstall  1253 Mar 28  2022 dbcsins.sql
-rw-r--r--.  1 oracle oinstall 12424 Aug 29  2022 devins.sql
drwxr-xr-x. 30 oracle oinstall 28672 Nov 11 19:38 images
-rw-r--r--.  1 oracle oinstall  5777 Jun 21  2021 LICENSE.txt
-rw-r--r--.  1 oracle oinstall  3665 Feb  7  2022 load_trans.sql
drwxr-xr-x.  5 oracle oinstall  4096 Nov 11 19:38 utilities

[oracle@oracle-database-server-free-for-developers apex]$ sqlplus /nolog

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Sat Apr 22 15:16:55 2023
Version 23.2.0.0.0

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

SQL> connect / as sysdba
Connected.
SQL> alter user sys identified by oracle continaer=all;
alter user sys identified by oracle continaer=all
                                    *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> alter user sys identified by oracle container=all;

User altered.

SQL> exit
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
[oracle@oracle-database-server-free-for-developers apex]$ sqlplus sys/oracle@pdb1 as sysdba

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Sat Apr 22 15:17:26 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> @apexins.sql SYSAUX SYSAUX TEMP /i/
...set_appun.sql

PL/SQL procedure successfully completed.













...set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.






Session altered.


FOO3
------------------------------
install2023-04-22_15-17-42.log

. ORACLE
.
. Oracle APEX Installation.
..........................................
.
...set_appun.sql
... Checking prerequisites (MANUAL)
.
. SYSDBA Privilege
.   pass - Connection with SYSDBA privilege.
. Database rolling upgrade
.   pass - No rolling upgrade.
. DB components
.   pass - CATPROC: version=23.0.0.0.0
.   pass - XDB: version=23.0.0.0.0
. XDB
.   pass - is valid
. DB parameters
.   pass - workarea_size_policy is AUTO
. PL/SQL Web Toolkit
.   pass - version 20.0.0.0.1
. Tablespaces
.   pass - found SYSAUX
.   pass - found SYSAUX
.   pass - found TEMP
. PHASES (1,2,3)...

PL/SQL procedure successfully completed.

.
... Prerequisite checks passed.
.
...gen_adm_pwd.sql
Phase 1 (Installation)
#
# Bootstrapping
#
...apxsqler_exit.sql
...setting session environment
...Creating users
...create user APEX_220200
...create user FLOWS_FILES
...create user APEX_PUBLIC_USER
Installing SYS views
...sys_core_views.sql
...core_grants.sql
...grant APEX owner core privileges
...done grant APEX owner core privileges
...Creating APEX_220200 Install Objects
...wwv_flows_release
...wwv_install_api.sql
No errors.
...wwv_install_tabs.sql
...wwv_install_seq
...wwv_install$
...wwv_install_action$
...wwv_install_error$
...wwv_flow_install_errors
No errors.
...wwv_install_api.plb
No errors.
...wwv_install_error$_bi
No errors.
# Proceeding with new installation.

timing for: Bootstrapping
Elapsed: 00:00:01.54
#
# Creating APEX_GRANTS_FOR_NEW_USERS_ROLE
#

timing for: Creating APEX_GRANTS_FOR_NEW_USERS_ROLE
Elapsed: 00:00:00.51
#
# Creating SYS Objects
#
...Create validate procedure in SYS schema and start registration
...validate_apex
No errors.
...sys.wwv_flow_val



No errors.
...wwv_flow_val_wrap18.sql
No errors.
No errors.
...wwv_util_APEX_220200
No errors.
...wwv_util_APEX_220200
No errors.
... Key created.
... created package wwv_flow_key
... created package body wwv_flow_key
...CONNECT as the Oracle user who will own the Oracle APEX engine

timing for: Creating SYS Objects
Elapsed: 00:00:00.18
#
# Creating APEX Tables
#
...create flows_files
... create wwv_flow_file_objects
...create flow objects
GENERIC OBJECTS
WORKSPACE
SESSION STATE MANAGEMENT
PROPERTY EDITOR
APPLICATION > SHARED COMPONENTS > CREDENTIALS
APPLICATION > SHARED COMPONENTS > REMOTE SERVERS
APPLICATION
...
timing for: Recompiling APEX_220200
Elapsed: 00:00:01.32
#
# Installing APEX REST Config
#
...gen_adm_pwd.sql
...null1.sql

timing for: Installing APEX REST Config
Elapsed: 00:00:00.03
#
# Set Loaded/Upgraded in Registry
#

timing for: Set Loaded/Upgraded in Registry
Elapsed: 00:00:00.05
#
# Removing Unused SYS Objects and Public Privs
#

timing for: Removing Unused SYS Objects and Public Privs
Elapsed: 00:00:00.01
#
# Validating Installation
#
...(15:22:26) Starting validate_apex for APEX_220200
...(15:22:27) Checking missing sys privileges
...(15:22:27) Re-generating APEX_220200.wwv_flow_db_version
... wwv_flow_db_version is up to date
...(15:22:27) Checking invalid public synonyms
...(15:22:27) Key object existence check
...(15:22:27) Setting DBMS Registry for APEX to valid
...(15:22:27) Exiting validate_apex
JOB_QUEUE_PROCESSES: 40
timing for: Validating Installation
Elapsed: 00:00:01.40
#
# Actions in Phase 3:
#
    ok 1 - BEGIN                                                        |   0.00
    ok 2 - Updating DBA_REGISTRY                                        |   0.00
    ok 3 - Computing Pub Syn Dependents                                 |   0.00
    ok 4 - Upgrade Hot Metadata and Switch Schemas                      |   0.00
    ok 5 - Removing Jobs                                                |   0.00
    ok 6 - Creating Public Synonyms                                     |   0.02
    ok 7 - Granting Public Synonyms                                     |   0.07
    ok 8 - Granting to FLOWS_FILES                                      |   0.00
    ok 9 - Creating FLOWS_FILES grants and synonyms                     |   0.00
    ok 10 - Syncing ORDS Gateway Allow List                             |   0.00
    ok 11 - Creating Jobs                                               |   0.00
    ok 12 - Creating Dev Jobs                                           |   0.00
    ok 13 - Installing FLOWS_FILES Objects                              |   0.02
    ok 14 - Installing APEX$SESSION Context                             |   0.00
    ok 15 - Recompiling APEX_220200                                     |   0.02
    ok 16 - Installing APEX REST Config                                 |   0.00
    ok 17 - Set Loaded/Upgraded in Registry                             |   0.00
    ok 18 - Removing Unused SYS Objects and Public Privs                |   0.00
    ok 19 - Validating Installation                                     |   0.02
ok 3 - 19 actions passed, 0 actions failed                              |   0.13



Thank you for installing Oracle APEX 22.2.0

Oracle APEX is installed in the APEX_220200 schema.

The structure of the link to the Oracle APEX administration services is as follows:
http://host:port/ords/apex_admin

The structure of the link to the Oracle APEX development interface is as follows:
http://host:port/ords

timing for: Phase 3 (Switch)
Elapsed: 00:00:08.91
timing for: Complete Installation
Elapsed: 00:04:45.63
SYS>


SYS> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Oracle APEX
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" does not yet exist and will be created.
Enter ADMIN's email [ADMIN] ronald.vargas.quesada@gmail.com
Enter ADMIN's password []
Created instance administrator ADMIN.

SYS> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
SYS> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Free23c$2023;
SYS> @apex_rest_config.sql

Enter a password for the APEX_LISTENER user              []
Enter a password for the APEX_REST_PUBLIC_USER user              []
...set_appun.sql
...setting session environment
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users
...grants for APEX_LISTENER and ORDS_METADATA user
SYS>
SYS> exit
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0


[oracle@oracle-database-server-free-for-developers apex]$ java -version
-bash: java: command not found
[oracle@oracle-database-server-free-for-developers apex]$ exit
logout
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash
[root@oracle-database-server-free-for-developers opc]# java -version
bash: java: command not found
[root@oracle-database-server-free-for-developers opc]# cd /opt
[root@oracle-database-server-free-for-developers opt]# ls -la
total 1955104
drwxr-xr-x.  8 oracle oinstall       4096 Apr 22 15:15 .
dr-xr-xr-x. 17 root   root            241 Apr 18 03:33 ..
-rw-r--r--.  1 oracle oinstall  243211508 Nov 14 09:30 apex-latest.zip
drwxr-xr-x.  2 oracle oinstall         64 Apr 22 15:14 META-INF
drwxr-xr-x.  9 oracle oinstall        113 Apr 18 03:38 oracle
-rw-r--r--.  1 oracle oinstall 1758776440 Mar 31 14:17 oracle-database-free-23c-1.0-1.el8.x86_64.rpm
-rw-r--r--.  1 oracle oinstall      30688 Apr 18 03:32 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
drwxr-xr-x.  3 root   root             22 Apr 18 03:36 ORCLfmap
drwxr-xr-x.  4 oracle oinstall         50 Jan 17 19:52 rh
drwxr-xr-x.  3 oracle oinstall         31 Apr 18 03:55 schemas_demo
drwxrwxr-x.  5 oracle oinstall        148 Apr 18 03:06 unified-monitoring-agent
[root@oracle-database-server-free-for-developers opt]# wget https://download.oracle.com/java/17/archive/jdk-17.0.6_linux-x64_bin.rpm
--2023-04-22 15:31:42--  https://download.oracle.com/java/17/archive/jdk-17.0.6_linux-x64_bin.rpm
Resolving download.oracle.com (download.oracle.com)... 104.96.235.20
Connecting to download.oracle.com (download.oracle.com)|104.96.235.20|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 181343596 (173M) [application/x-redhat-package-manager]
Saving to: ‘jdk-17.0.6_linux-x64_bin.rpm’

jdk-17.0.6_linux-x64_bin.rpm              100%[===================>] 172.94M  5.84MB/s    in 30s

2023-04-22 15:32:12 (5.82 MB/s) - ‘jdk-17.0.6_linux-x64_bin.rpm’ saved [181343596/181343596]

[root@oracle-database-server-free-for-developers opt]# ls -la
total 2132200
drwxr-xr-x.  8 oracle oinstall       4096 Apr 22 15:31 .
dr-xr-xr-x. 17 root   root            241 Apr 18 03:33 ..
-rw-r--r--.  1 oracle oinstall  243211508 Nov 14 09:30 apex-latest.zip
-rw-r--r--.  1 root   root      181343596 Dec  7 23:34 jdk-17.0.6_linux-x64_bin.rpm
drwxr-xr-x.  2 oracle oinstall         64 Apr 22 15:14 META-INF
drwxr-xr-x.  9 oracle oinstall        113 Apr 18 03:38 oracle
-rw-r--r--.  1 oracle oinstall 1758776440 Mar 31 14:17 oracle-database-free-23c-1.0-1.el8.x86_64.rpm
-rw-r--r--.  1 oracle oinstall      30688 Apr 18 03:32 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
drwxr-xr-x.  3 root   root             22 Apr 18 03:36 ORCLfmap
drwxr-xr-x.  4 oracle oinstall         50 Jan 17 19:52 rh
drwxr-xr-x.  3 oracle oinstall         31 Apr 18 03:55 schemas_demo
drwxrwxr-x.  5 oracle oinstall        148 Apr 18 03:06 unified-monitoring-agent
[root@oracle-database-server-free-for-developers opt]# dnf -y install jdk-17.0.6_linux-x64_bin.rpm
Ksplice for Oracle Linux 8 (x86_64)                             194 kB/s | 3.0 kB     00:00
Ksplice for Oracle Linux 8 (x86_64)                              28 MB/s | 2.2 MB     00:00
MySQL 8.0 for Oracle Linux 8 (x86_64)                           130 kB/s | 3.0 kB     00:00
MySQL 8.0 for Oracle Linux 8 (x86_64)                            37 MB/s | 3.0 MB     00:00
MySQL 8.0 Tools Community for Oracle Linux 8 (x86_64)           172 kB/s | 2.9 kB     00:00
MySQL 8.0 Tools Community for Oracle Linux 8 (x86_64)           7.8 MB/s | 491 kB     00:00
MySQL 8.0 Connectors Community for Oracle Linux 8 (x86_64)      200 kB/s | 2.9 kB     00:00
MySQL 8.0 Connectors Community for Oracle Linux 8 (x86_64)      560 kB/s |  30 kB     00:00
Oracle Software for OCI users on Oracle Linux 8 (x86_64)        137 kB/s | 2.9 kB     00:00
Oracle Software for OCI users on Oracle Linux 8 (x86_64)        120 MB/s |  75 MB     00:00
Oracle Linux 8 BaseOS Latest (x86_64)                           167 kB/s | 3.6 kB     00:00
Oracle Linux 8 BaseOS Latest (x86_64)                           107 MB/s |  57 MB     00:00
Oracle Linux 8 Application Stream (x86_64)                      174 kB/s | 3.9 kB     00:00
Oracle Linux 8 Application Stream (x86_64)                      104 MB/s |  44 MB     00:00
Oracle Linux 8 Addons (x86_64)                                  116 kB/s | 3.0 kB     00:00
Latest Unbreakable Enterprise Kernel Release 7 for Oracle Linux 8 (x86_64)  213 kB/s | 3.0 kB     00:00
Dependencies resolved.
================================================================================================
 Package                              Architecture   Version             Repository        Size
================================================================================================
Installing:
 jdk-17                               x86_64         2000:17.0.6-9       @commandline     173 M

Transaction Summary
================================================================================================
Install  1 Package

Total size: 173 M
Installed size: 302 M
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                1/1
  Installing       : jdk-17-2000:17.0.6-9.x86_64         1/1
  Running scriptlet: jdk-17-2000:17.0.6-9.x86_64         1/1
  Verifying        : jdk-17-2000:17.0.6-9.x86_64         1/1

Installed:
  jdk-17-2000:17.0.6-9.x86_64

Complete!
[root@oracle-database-server-free-for-developers opt]# java -version
java version "17.0.6" 2023-01-17 LTS
Java(TM) SE Runtime Environment (build 17.0.6+9-LTS-190)
Java HotSpot(TM) 64-Bit Server VM (build 17.0.6+9-LTS-190, mixed mode, sharing)

[opc@oracle-database-server-free-for-developers ~]$ sudo su - oracle
Last login: Sat Apr 22 15:12:52 GMT 2023 on pts/0

[oracle@oracle-database-server-free-for-developers ~]$ java -version
java version "17.0.6" 2023-01-17 LTS
Java(TM) SE Runtime Environment (build 17.0.6+9-LTS-190)
Java HotSpot(TM) 64-Bit Server VM (build 17.0.6+9-LTS-190, mixed mode, sharing)
[oracle@oracle-database-server-free-for-developers ~]$

[oracle@oracle-database-server-free-for-developers ~]$ exit
logout
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash
[root@oracle-database-server-free-for-developers opc]# dnf install ords -y
Last metadata expiration check: 0:03:29 ago on Sat 22 Apr 2023 03:33:10 PM GMT.
Dependencies resolved.
==================================================================================
 Package            Architecture     Version          Repository             Size
==================================================================================
Installing:
 ords               noarch           23.1.1-4.el8     ol8_oci_included       91 M

Transaction Summary
=====================================================================
Install  1 Package

Total download size: 91 M
Installed size: 96 M
Downloading Packages:
ords-23.1.1-4.el8.noarch.rpm         113 MB/s |  91 MB     00:00
---------------------------------------------------------------------
Total                                113 MB/s |  91 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                           1/1
  Running scriptlet: ords-23.1.1-4.el8.noarch                                  1/1
  Installing       : ords-23.1.1-4.el8.noarch                                  1/1
  Running scriptlet: ords-23.1.1-4.el8.noarch                                  1/1
INFO: Before starting ORDS service, run the below command as user oracle:
         ords --config /etc/ords/config install
INFO: To enable the ORDS service during startup, run the below command:
         sudo  systemctl enable ords

  Verifying        : ords-23.1.1-4.el8.noarch                                  1/1

Installed:
  ords-23.1.1-4.el8.noarch

Complete!
[root@oracle-database-server-free-for-developers opc]#

[oracle@oracle-database-server-free-for-developers ~]$ exit
logout
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash
[root@oracle-database-server-free-for-developers opc]# dnf install ords -y
Last metadata expiration check: 0:03:29 ago on Sat 22 Apr 2023 03:33:10 PM GMT.
Dependencies resolved.
=======================================================================================================
 Package                           Architecture        Version            Repository              Size
=======================================================================================================
Installing:
 ords                              noarch              23.1.1-4.el8       ol8_oci_included        91 M

Transaction Summary
===============================================================
Install  1 Package

Total download size: 91 M
Installed size: 96 M
Downloading Packages:
ords-23.1.1-4.el8.noarch.rpm       113 MB/s |  91 MB     00:00
-------------------------------------------------------------------
Total                              113 MB/s |  91 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                1/1
  Running scriptlet: ords-23.1.1-4.el8.noarch                                                                                                                       1/1
  Installing       : ords-23.1.1-4.el8.noarch                                                                                                                       1/1
  Running scriptlet: ords-23.1.1-4.el8.noarch                                                                                                                       1/1
INFO: Before starting ORDS service, run the below command as user oracle:
         ords --config /etc/ords/config install
INFO: To enable the ORDS service during startup, run the below command:
         sudo  systemctl enable ords

  Verifying        : ords-23.1.1-4.el8.noarch                                                                                                                       1/1

Installed:
  ords-23.1.1-4.el8.noarch

Complete!
[root@oracle-database-server-free-for-developers opc]# exit
exit
[opc@oracle-database-server-free-for-developers ~]$ sudo su - oracle
Last login: Sat Apr 22 15:33:41 GMT 2023 on pts/0
[oracle@oracle-database-server-free-for-developers ~]$ pwd
/home/oracle


[oracle@oracle-database-server-free-for-developers ORDS]$ pwd
/opt/ORDS
[oracle@oracle-database-server-free-for-developers ORDS]$ ords --config /etc/ords/config install

ORDS: Release 23.1 Production on Sat Apr 22 15:39:41 2023

Copyright (c) 2010, 2023, Oracle.

Configuration:
  /etc/ords/config/

The configuration folder /etc/ords/config does not contain any configuration files.

Oracle REST Data Services - Interactive Install

  Enter a number to select the type of installation
    [1] Install or upgrade ORDS in the database only
    [2] Create or update a database pool and install/upgrade ORDS in the database
    [3] Create or update a database pool only
  Choose [2]: 2
  Enter a number to select the database connection type to use
    [1] Basic (host name, port, service name)
    [2] TNS (TNS alias, TNS directory)
    [3] Custom database URL
  Choose [1]: 1
  Enter the database host name [localhost]:
  Enter the database listen port [1521]:
  Enter the database service name [orcl]: FREEPDB1
  Provide database user name with administrator privileges.
    Enter the administrator username: sys
  Enter the database password for SYS AS SYSDBA:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//localhost:1521/FREEPDB1

Retrieving information.
  Enter the default tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [SYSAUX]:
  Enter the temporary tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [TEMP]:
  Enter a number to select additional feature(s) to enable:
    [1] Database Actions  (Enables all features)
    [2] REST Enabled SQL and Database API
    [3] REST Enabled SQL
    [4] Database API
    [5] None
  Choose [1]: 1
  Enter a number to configure and start ORDS in standalone mode
    [1] Configure and start ORDS in standalone mode
    [2] Skip
  Choose [1]:
  Enter a number to select the protocol
    [1] HTTP
    [2] HTTPS
  Choose [1]:
  Enter the HTTP port [8080]:
  Enter the APEX static resources location [/opt/ORDS/$ORACLE_HOME/apex/images]: /opt/oracle/product/23c/dbhomeFree/apex/images
The global setting named: standalone.static.path was set to: /opt/oracle/product/23c/dbhomeFree/apex/images/

...
db.servicename=FREEPDB1
standalone.context.path=/ords
db.hostname=localhost
db.password=******
conf.use.wallet=true
security.requestValidationFunction=ords_util.authorize_plsql_gateway
standalone.static.context.path=/i
database.api.enabled=true
db.username=ORDS_PUBLIC_USER
standalone.http.port=8080
standalone.static.path=/opt/oracle/product/23c/dbhomeFree/apex/images/
restEnabledSql.active=true
resource.templates.enabled=false
plsql.gateway.mode=proxied
db.port=1521
feature.sdw=true
config.required=true
db.connectionType=basic
standalone.doc.root=/etc/ords/config/global/doc_root

2023-04-22T15:54:13.243Z WARNING     *** jdbc.MaxLimit in configuration |default|lo| is using a value of 20, 
this setting may not be sized adequately for a production environment ***
2023-04-22T15:54:13.244Z WARNING     *** jdbc.InitialLimit in configuration |default|lo| is using a value of 3, 
this setting may not be sized adequately for a production environment ***
2023-04-22T15:54:18.143Z INFO

Mapped local pools from /etc/ords/config/databases:
  /ords/                              => default                        => VALID


2023-04-22T15:42:21.938Z INFO        Installing Oracle REST Data Services version 23.1.1.r1091003 in FREEPDB1
------------------------------------------------------------
Date       : 22 Apr 2023 15:42:21
Release    : Oracle REST Data Services 23.1.1.r1091003
Type       : ORDS Install
Database   : Oracle Database 23c Free,
DB Version : 23.2.0.0.0
------------------------------------------------------------
Container Name: FREEPDB1
Executing scripts for core
------------------------------------------------------------

[*** script: ords_prereq_env.sql]

INFO: Checking prerequisites for Oracle REST Data Services

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

INFO: Prerequisites verified.

2023-04-22T15:42:23.369Z INFO        ... Verified database prerequisites
[*** script: ords_verify_tablespace.sql]

PL/SQL procedure successfully completed.

[*** script: ords_alter_session_script.sql]

PL/SQL procedure successfully completed.

[*** script: ords_create_rest_users.sql]

PL/SQL procedure successfully completed.

2023-04-22T15:42:24.863Z INFO        ... Created Oracle REST Data Services proxy user
[*** script: ords_alter_session_script.sql]

PL/SQL procedure successfully completed.

[*** script: ords_create_schema.sql]
INFO: Creating schema for Oracle REST Data Services

PL/SQL procedure successfully completed.

INFO: Created schema ORDS_METADATA
2023-04-22T15:42:25.716Z INFO        ... Created Oracle REST Data Services schema
[*** script: ords_grant_privs.sql]
INFO: Grant object and system privileges to ORDS owner
GRANT READ ON SYS.DBA_OBJECTS TO "ORDS_METADATA"
GRANT READ ON SYS.DBA_ROLE_PRIVS TO "ORDS_METADATA"
GRANT READ ON SYS.DBA_TAB_COLUMNS TO "ORDS_METADATA"
GRANT READ ON SYS.DBA_USERS TO "ORDS_METADATA"
GRANT READ ON SYS.DBA_REGISTRY TO "ORDS_METADATA"
...
2023-04-22T15:54:09.785Z INFO        Oracle REST Data Services schema version 23.1.1.r1091003 is installed.
2023-04-22T15:54:09.937Z INFO        HTTP and HTTP/2 cleartext listening on host: 0.0.0.0 port: 8080
2023-04-22T15:54:09.953Z INFO        Disabling document root because the specified folder does not exist: /etc/ords/config/global/doc_root
2023-04-22T15:54:13.242Z INFO        Configuration properties for: |default|lo|
db.servicename=FREEPDB1
standalone.context.path=/ords
db.hostname=localhost
db.password=******
conf.use.wallet=true
security.requestValidationFunction=ords_util.authorize_plsql_gateway
standalone.static.context.path=/i
database.api.enabled=true
db.username=ORDS_PUBLIC_USER
standalone.http.port=8080
standalone.static.path=/opt/oracle/product/23c/dbhomeFree/apex/images/
restEnabledSql.active=true
resource.templates.enabled=false
plsql.gateway.mode=proxied
db.port=1521
feature.sdw=true
config.required=true
db.connectionType=basic
standalone.doc.root=/etc/ords/config/global/doc_root

2023-04-22T15:54:13.243Z WARNING     *** jdbc.MaxLimit in configuration |default|lo| is using a value of 20, 
this setting may not be sized adequately for a production environment ***
2023-04-22T15:54:13.244Z WARNING     *** jdbc.InitialLimit in configuration |default|lo| is using a value of 3, 
this setting may not be sized adequately for a production environment ***
2023-04-22T15:54:18.143Z INFO

Mapped local pools from /etc/ords/config/databases:
  /ords/                              => default                        => VALID


2023-04-22T15:54:18.266Z INFO        Oracle REST Data Services initialized
Oracle REST Data Services version : 23.1.1.r1091003
Oracle REST Data Services server info: jetty/10.0.12
Oracle REST Data Services java info: Java HotSpot(TM) 64-Bit Server VM 17.0.6+9-LTS-190



login as: opc
Authenticating with public key "rsa-key-20200507"
Passphrase for key "rsa-key-20200507":
Activate the web console with: systemctl enable --now cockpit.socket

Last login: Sat Apr 22 15:12:49 2023 from 201.198.177.118
[opc@oracle-database-server-free-for-developers ~]$ sudo -s /bin/bash
[root@oracle-database-server-free-for-developers opc]# firewall-cmd --permanent --zone=public --add-port=1521/tcp
success
[root@oracle-database-server-free-for-developers opc]# firewall-cmd --permanent --zone=public --add-port=8080/tcp
success
[root@oracle-database-server-free-for-developers opc]# firewall-cmd --reload
success
[root@oracle-database-server-free-for-developers opc]#

[root@oracle-database-server-free-for-developers opc]# /etc/init.d/ords start
INFO: Starting Oracle REST Data Services...
WARNING: Oracle REST Data Services is already running with PID 11902 and bounded to ports 8080
[root@oracle-database-server-free-for-developers opc]# /etc/init.d/ords restart
INFO: Stopping Oracle REST Data Services...
WARNING: Oracle REST Data Services is not running
INFO: Starting Oracle REST Data Services...
INFO: Oracle REST Data Services started with PID 15187
INFO: Obtaining the port binding information...
INFO: Oracle REST Data Services is bounded to ports 8080
[root@oracle-database-server-free-for-developers opc]# /etc/init.d/ords start
INFO: Starting Oracle REST Data Services...
INFO: Oracle REST Data Services started with PID 18460
INFO: Obtaining the port binding information...
INFO: Oracle REST Data Services is bounded to ports 8080
[root@oracle-database-server-free-for-developers opc]#


http://*******:8080/ords

http://***********:8080/ords/sql-developer



SQL> connect hr/hr@pdb1
Connected.
begin
ords.enable_schema(
p_enabled =>TRUE,
 p_schema => 'HR',
 p_url_mapping_type =>'BASE_PATH',
 p_url_mapping_pattern => 'HR',
p_auto_rest_auth =>FALSE
);
COMMIT;
END;
/
SQL> alter user hr identified by oracle;
SQL>


Referencias: https://chronicler.tech/apex-ords-installation/

miércoles, 19 de abril de 2023

Nueva Edición OraWorld Magazine

 

Te invitamos a leer la nueva edición de OraWorld Magazine, donde descubrirás artículos de Mirela Ardelean, Andrea Kennel, Dani Schnider, Mohit Jain, Jasmin Fluri, Rishin Mitra.

Si está interesado en aparecer en la futura edición de la revista, puede comunicarse con el equipo editorial que incluye a Mirela Ardelean y Heli Helskyaho.

https://lnkd.in/dYpFyFzR

sábado, 8 de abril de 2023

Oracle: Que sucede cuando se borra un punto de restauración de la base de datos.

En muchas ocasiones ejecutamos cosas, pero no nos preguntamos que es lo que la base de datos realiza cuando envíamos un comando a correr.

He dejando algunas publicaciones sobre los puntos de restauración por acá y quiero que observen que es lo que sucede cuando uno borra un RESTORE POINT.

Es suficiente que cuando ejecutemos el comando, procedamos a ejecutar el ADRCI - Interpretador de comandos del repositorio de diagnóstio automático- y revisemos que es lo que la base de datos hace por debajo a la hora de hacer un "DROP RESTORE POINT ".

Para los contenedores de base de datos que utilizando un UNDO compartido, una operación de Flasback Database a un punto de restauración, es más rápido que un operación de Flashback Database a un SCN.

Los puntos de restauración de PDB pueden ser puntos de restauración normales o puntos de restauración garantizados. Un punto de restauración de PDB garantizado garantiza que puede realizar una operación de flashback para el PDB en ese punto de restauración.

Las principales diferencias entre el registro de flashback normal y el registro para puntos de restauración garantizados están relacionados con cuándo se registran los bloques y si los registros se pueden eliminar en respuesta a la presión del espacio en el área de recuperación rápida. Estas diferencias afectan el uso del espacio para los registros y el rendimiento de la base de datos.

Documentación oficial: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/using-flasback-database-restore-points.html#GUID-34C48821-B29D-4A2E-94DE-CD97CFA7784E

Veamos como queda registrado el "DROP RESTORE POINT" en la bitácora de la base de datos.

SQL> @ver_restore_point.sql

SCN GUA TIME_FMT NAME PDB GB_SIZE PDB_NAME
-------------- --- -------------------- -------------------------------------------------- --- ---------- 
91126983012 YES 03/03/2023 17:19 RESTORE_POINT_PDB1_PRE_EOD_POINT_03032023_1719 YES 34.1796875 PDB1
91098657483 YES 02/03/2023 15:33 RESTORE_POINT_PDB1_PRE_EOD_POINT_02032023_1533 YES 13.1835938 PDB1

SQL> drop restore point RESTORE_POINT_PDB1_PRE_EOD_POINT_02032023_1533 for pluggable database pdb1;

Restore point dropped.

SQL> @ver_restore_point.sql

SCN GUA TIME_FMT NAME PDB GB_SIZE PDB_NAME
-------------- --- -------------------- ------------------------------------------------- 
91126983012 YES 03/03/2023 17:19 RESTORE_POINT_PDB1_PRE_EOD_POINT_03032023_1719 YES 34.1796875 PDB1

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

[oracle@serverdb_01_prod scripts]$ adrci

ADRCI: Release 19.0.0.0.0 - Production on Mon Mar 6 10:49:49 2023
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

ADR base = "/opt/app/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/cdb/cdb
diag/clients/user_oracle/host_3013543445_110
diag/clients/user_oracle/host_667749374_110
diag/clients/user_oracle/host_667749374_82
diag/tnslsnr/serverdb_01_prod/listener
adrci> set home diag/rdbms/cdb/cdb
adrci> show alert

ADR Home = /opt/app/oracle/diag/rdbms/cdb/cdb:
*************************************************************************

Output the results to file: /tmp/alert_3682_14022_cdb_1.ado

Current log# 3 seq# 9679 mem# 0: /opt/app/oracle/oradata/CDB/REDO_MEMBER_02/redo1a.rdo

Current log# 3 seq# 9679 mem# 1: /opt/app/oracle/oradata/CDB/REDO_MEMBER_01/redo1b.rdo

2023-03-06 10:40:54.109000 -06:00

ARC0 (PID:10954): Archived Log entry 9666 added for T-1.S-9678 ID 0x84c72c70 LAD:1

2023-03-06 10:42:13.062000 -06:00

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/foreign_archivelog/PDB1/2023_03_06/o1_mf_1_9679_l0d5z1n9_.arc

2023-03-06 10:44:11.159000 -06:00

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/foreign_archivelog/PDB1/2023_03_06/o1_mf_1_9679_l0d62t17_.arc

2023-03-06 10:46:11.909000 -06:00

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/foreign_archivelog/PDB1/2023_03_06/o1_mf_1_9679_l0d66lh9_.arc

2023-03-06 10:46:52.760000 -06:00

Drop guaranteed restore point RESTORE_POINT_PDB1_PRE_EOD_POINT_02032023_1533

Guaranteed restore point RESTORE_POINT_PDB1_PRE_EOD_POINT_02032023_1533 dropped

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzw5hsb5_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzw9soc7_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzwgskb5_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzwlkgsw_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzwlntgw_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzzlq5qb_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzwn9ccn_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzwqy2lw_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzx03lbw_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzt6wq0o_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kztbooh8_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kztjt9y5_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kztphpqw_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kztvn926_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_l00hr3ho_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kztw3dpf_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kztw82lw_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kztxsmcn_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzv1ndpf_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzv7lc5n_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzvf50ml_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzvlxg9w_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzyf3b4x_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzvqpkl7_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzvqqwon_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzvs2os4_.flb

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/flashback/o1_mf_kzvzdy7x_.flb

2023-03-06 10:48:12.689000 -06:00

Deleted Oracle managed file /opt/app/oracle/oradata/CDB/fast_recovery_area/CDB/foreign_archivelog/PDB1/2023_03_06/o1_mf_1_9679_l0d6bc40_.arc

Todos los Sábados a las 8:00PM

Optimismo para una vida Mejor

Optimismo para una vida Mejor
Noticias buenas que comentar