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/
No hay comentarios:
Publicar un comentario
Te agradezco tus comentarios. Te esperamos de vuelta.