Ontem dia 03/04/2023 foi disponibilizado a versão free do Oracle Database para desenvolvedores, pensando nos desenvolvedores e nas empresas, a Oracle lançou a edição Developer da versão 23c totalmente gratuita.
Funcionalidades incluídas na edição Developer:
JSON Relational Duality
JavaScript Stored Procedures (powered by GraalVM)
JSON Schema
Operational Property Graphs
Oracle Kafka APIs
SQL Domains
Annotations
Link sobre as funcionalidades:
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/introduction.htmlLimitações da Edição Developer 23c:
12 GB de dados do usuário
2 GB de RAM
2 threads de CPU
Máximo de 252 PDBs
Requer Oracle Linux 8 ou RHE8
INSTALAÇÃO
Link para download:
#Linux RPM file
https://www.oracle.com/database/technologies/free-downloads.html
#VirtualBox VM
https://www.oracle.com/database/technologies/databaseappdev-vm.html
#Docker Image (docker pull container-registry.oracle.com/database/free)
https://container-registry.oracle.com/Versão do SO que iremos instalar o Oracle Database 23c Developer Edition:
[root@srv23dev ~]# cat /etc/*-release | grep PRETTY
PRETTY_NAME="Oracle Linux Server 8.7"Pacotes e configurações do SO:
dnf config-manager --enable ol8_codeready_builder
dnf install xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps -y
dnf install wget zip unzip rsync -y
dnf install net-tools -y
dnf install NetworkManager-tui -y
dnf update -ysystemctl stop firewalld
systemctl status firewalld
systemctl disable --now firewalld
systemctl mask --now firewalld
cat /etc/selinux/config
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
cat >> /etc/hosts << EOF
192.168.13.135 srv23dev srv23dev
EOF
cat /etc/hostsInstalação dos pacotes necessários:
curl -L -o oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
[root@srv23dev ~]# curl -L -o oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 30688 100 30688 0 0 30657 0 0:00:01 0:00:01 --:--:-- 30657
[root@srv23dev ~]# dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Last metadata expiration check: 0:02:51 ago on Tue 04 Apr 2023 09:29:48 AM -03.
Dependencies resolved.
========================================================================================================================================================================================================================================
Package Architecture Version Repository Size
========================================================================================================================================================================================================================================
Installing:
oracle-database-preinstall-23c x86_64 1.0-0.5.el8 @commandline 30 k
Installing dependencies:
bc x86_64 1.07.1-5.el8 ol8_baseos_latest 129 k
bind-libs x86_64 32:9.11.36-5.el8_7.2 ol8_appstream 175 k
bind-libs-lite x86_64 32:9.11.36-5.el8_7.2 ol8_appstream 1.2 M
bind-license noarch 32:9.11.36-5.el8_7.2 ol8_appstream 104 k
bind-utils x86_64 32:9.11.36-5.el8_7.2 ol8_appstream 452 k
checkpolicy x86_64 2.9-1.el8 ol8_baseos_latest 346 k
compat-openssl10 x86_64 1:1.0.2o-4.el8_6 ol8_appstream 1.1 M
fstrm x86_64 0.6.1-3.el8 ol8_appstream 29 k
gssproxy x86_64 0.8.0-21.el8 ol8_baseos_latest 119 k
ksh x86_64 20120801-257.0.1.el8 ol8_appstream 929 k
libev x86_64 4.24-6.el8 ol8_appstream 52 k
libmaxminddb x86_64 1.2.0-10.el8 ol8_appstream 33 k
libnsl x86_64 2.28-211.0.1.el8 ol8_baseos_latest 105 k
libverto-libev x86_64 0.3.2-2.el8 ol8_appstream 16 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k
nfs-utils x86_64 1:2.3.3-57.el8_7.1 ol8_baseos_latest 515 k
policycoreutils-python-utils noarch 2.9-20.0.1.el8 ol8_baseos_latest 253 k
protobuf-c x86_64 1.3.0-6.el8 ol8_appstream 37 k
python3-audit x86_64 3.0.7-4.el8 ol8_baseos_latest 87 k
python3-bind noarch 32:9.11.36-5.el8_7.2 ol8_appstream 151 k
python3-libsemanage x86_64 2.9-9.el8_6 ol8_baseos_latest 128 k
python3-policycoreutils noarch 2.9-20.0.1.el8 ol8_baseos_latest 2.2 M
python3-pyyaml x86_64 3.12-12.el8 ol8_baseos_latest 193 k
python3-setools x86_64 4.3.0-3.el8 ol8_baseos_latest 624 k
quota x86_64 1:4.04-14.el8 ol8_baseos_latest 214 k
quota-nls noarch 1:4.04-14.el8 ol8_baseos_latest 95 k
rpcbind x86_64 1.2.5-10.el8 ol8_baseos_latest 70 k
smartmontools x86_64 1:7.1-1.el8 ol8_baseos_latest 544 k
sysstat x86_64 11.7.3-7.0.1.el8_7.1 ol8_appstream 426 k
Installing weak dependencies:
geolite2-city noarch 20180605-1.el8 ol8_appstream 19 M
geolite2-country noarch 20180605-1.el8 ol8_appstream 1.0 M
Transaction Summary
========================================================================================================================================================================================================================================
Install 32 Packages
Total size: 30 M
Total download size: 30 M
Installed size: 86 M
Downloading Packages:
(1/31): bc-1.07.1-5.el8.x86_64.rpm 257 kB/s | 129 kB 00:00
(2/31): gssproxy-0.8.0-21.el8.x86_64.rpm 227 kB/s | 119 kB 00:00
(3/31): checkpolicy-2.9-1.el8.x86_64.rpm 576 kB/s | 346 kB 00:00
(4/31): libnsl-2.28-211.0.1.el8.x86_64.rpm 1.0 MB/s | 105 kB 00:00
(5/31): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 522 kB/s | 59 kB 00:00
(6/31): policycoreutils-python-utils-2.9-20.0.1.el8.noarch.rpm 1.8 MB/s | 253 kB 00:00
(7/31): python3-audit-3.0.7-4.el8.x86_64.rpm 865 kB/s | 87 kB 00:00
(8/31): nfs-utils-2.3.3-57.el8_7.1.x86_64.rpm 2.6 MB/s | 515 kB 00:00
(9/31): python3-libsemanage-2.9-9.el8_6.x86_64.rpm 1.4 MB/s | 128 kB 00:00
(10/31): python3-pyyaml-3.12-12.el8.x86_64.rpm 1.4 MB/s | 193 kB 00:00
(11/31): python3-setools-4.3.0-3.el8.x86_64.rpm 3.8 MB/s | 624 kB 00:00
(12/31): quota-4.04-14.el8.x86_64.rpm 1.1 MB/s | 214 kB 00:00
(13/31): rpcbind-1.2.5-10.el8.x86_64.rpm 951 kB/s | 70 kB 00:00
(14/31): smartmontools-7.1-1.el8.x86_64.rpm 2.9 MB/s | 544 kB 00:00
(15/31): quota-nls-4.04-14.el8.noarch.rpm 195 kB/s | 95 kB 00:00
(16/31): bind-libs-9.11.36-5.el8_7.2.x86_64.rpm 1.2 MB/s | 175 kB 00:00
(17/31): bind-license-9.11.36-5.el8_7.2.noarch.rpm 602 kB/s | 104 kB 00:00
(18/31): python3-policycoreutils-2.9-20.0.1.el8.noarch.rpm 2.2 MB/s | 2.2 MB 00:01
(19/31): bind-utils-9.11.36-5.el8_7.2.x86_64.rpm 2.3 MB/s | 452 kB 00:00
(20/31): fstrm-0.6.1-3.el8.x86_64.rpm 497 kB/s | 29 kB 00:00
(21/31): bind-libs-lite-9.11.36-5.el8_7.2.x86_64.rpm 761 kB/s | 1.2 MB 00:01
(22/31): geolite2-country-20180605-1.el8.noarch.rpm 3.3 MB/s | 1.0 MB 00:00
(23/31): ksh-20120801-257.0.1.el8.x86_64.rpm 2.4 MB/s | 929 kB 00:00
(24/31): geolite2-city-20180605-1.el8.noarch.rpm 9.4 MB/s | 19 MB 00:02
(25/31): libmaxminddb-1.2.0-10.el8.x86_64.rpm 497 kB/s | 33 kB 00:00
(26/31): libverto-libev-0.3.2-2.el8.x86_64.rpm 206 kB/s | 16 kB 00:00
(27/31): protobuf-c-1.3.0-6.el8.x86_64.rpm 625 kB/s | 37 kB 00:00
(28/31): libev-4.24-6.el8.x86_64.rpm 109 kB/s | 52 kB 00:00
(29/31): python3-bind-9.11.36-5.el8_7.2.noarch.rpm 2.1 MB/s | 151 kB 00:00
(30/31): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm 441 kB/s | 1.1 MB 00:02
(31/31): sysstat-11.7.3-7.0.1.el8_7.1.x86_64.rpm 1.7 MB/s | 426 kB 00:00
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 6.7 MB/s | 30 MB 00:04
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : protobuf-c-1.3.0-6.el8.x86_64 1/32
Installing : fstrm-0.6.1-3.el8.x86_64 2/32
Installing : bind-license-32:9.11.36-5.el8_7.2.noarch 3/32
Installing : python3-bind-32:9.11.36-5.el8_7.2.noarch 4/32
Installing : libev-4.24-6.el8.x86_64 5/32
Installing : libverto-libev-0.3.2-2.el8.x86_64 6/32
Installing : gssproxy-0.8.0-21.el8.x86_64 7/32
Running scriptlet: gssproxy-0.8.0-21.el8.x86_64 7/32
Installing : ksh-20120801-257.0.1.el8.x86_64 8/32
Running scriptlet: ksh-20120801-257.0.1.el8.x86_64 8/32
Installing : geolite2-country-20180605-1.el8.noarch 9/32
Installing : geolite2-city-20180605-1.el8.noarch 10/32
Installing : libmaxminddb-1.2.0-10.el8.x86_64 11/32
Running scriptlet: libmaxminddb-1.2.0-10.el8.x86_64 11/32
Installing : bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64 12/32
Installing : bind-libs-32:9.11.36-5.el8_7.2.x86_64 13/32
Installing : bind-utils-32:9.11.36-5.el8_7.2.x86_64 14/32
Installing : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 15/32
Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64 15/32
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 16/32
Installing : smartmontools-1:7.1-1.el8.x86_64 16/32
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 16/32
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 17/32
Installing : rpcbind-1.2.5-10.el8.x86_64 17/32
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 17/32
Installing : quota-nls-1:4.04-14.el8.noarch 18/32
Installing : quota-1:4.04-14.el8.x86_64 19/32
Installing : python3-setools-4.3.0-3.el8.x86_64 20/32
Installing : python3-pyyaml-3.12-12.el8.x86_64 21/32
Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64 22/32
Installing : nfs-utils-1:2.3.3-57.el8_7.1.x86_64 22/32
Running scriptlet: nfs-utils-1:2.3.3-57.el8_7.1.x86_64 22/32
Installing : python3-libsemanage-2.9-9.el8_6.x86_64 23/32
Installing : python3-audit-3.0.7-4.el8.x86_64 24/32
Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 25/32
Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 25/32
Installing : sysstat-11.7.3-7.0.1.el8_7.1.x86_64 26/32
Running scriptlet: sysstat-11.7.3-7.0.1.el8_7.1.x86_64 26/32
Installing : libnsl-2.28-211.0.1.el8.x86_64 27/32
Installing : checkpolicy-2.9-1.el8.x86_64 28/32
Installing : python3-policycoreutils-2.9-20.0.1.el8.noarch 29/32
Installing : policycoreutils-python-utils-2.9-20.0.1.el8.noarch 30/32
Installing : bc-1.07.1-5.el8.x86_64 31/32
Running scriptlet: bc-1.07.1-5.el8.x86_64 31/32
Installing : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 32/32
Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 32/32
Verifying : bc-1.07.1-5.el8.x86_64 1/32
Verifying : checkpolicy-2.9-1.el8.x86_64 2/32
Verifying : gssproxy-0.8.0-21.el8.x86_64 3/32
Verifying : libnsl-2.28-211.0.1.el8.x86_64 4/32
Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 5/32
Verifying : nfs-utils-1:2.3.3-57.el8_7.1.x86_64 6/32
Verifying : policycoreutils-python-utils-2.9-20.0.1.el8.noarch 7/32
Verifying : python3-audit-3.0.7-4.el8.x86_64 8/32
Verifying : python3-libsemanage-2.9-9.el8_6.x86_64 9/32
Verifying : python3-policycoreutils-2.9-20.0.1.el8.noarch 10/32
Verifying : python3-pyyaml-3.12-12.el8.x86_64 11/32
Verifying : python3-setools-4.3.0-3.el8.x86_64 12/32
Verifying : quota-1:4.04-14.el8.x86_64 13/32
Verifying : quota-nls-1:4.04-14.el8.noarch 14/32
Verifying : rpcbind-1.2.5-10.el8.x86_64 15/32
Verifying : smartmontools-1:7.1-1.el8.x86_64 16/32
Verifying : bind-libs-32:9.11.36-5.el8_7.2.x86_64 17/32
Verifying : bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64 18/32
Verifying : bind-license-32:9.11.36-5.el8_7.2.noarch 19/32
Verifying : bind-utils-32:9.11.36-5.el8_7.2.x86_64 20/32
Verifying : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 21/32
Verifying : fstrm-0.6.1-3.el8.x86_64 22/32
Verifying : geolite2-city-20180605-1.el8.noarch 23/32
Verifying : geolite2-country-20180605-1.el8.noarch 24/32
Verifying : ksh-20120801-257.0.1.el8.x86_64 25/32
Verifying : libev-4.24-6.el8.x86_64 26/32
Verifying : libmaxminddb-1.2.0-10.el8.x86_64 27/32
Verifying : libverto-libev-0.3.2-2.el8.x86_64 28/32
Verifying : protobuf-c-1.3.0-6.el8.x86_64 29/32
Verifying : python3-bind-32:9.11.36-5.el8_7.2.noarch 30/32
Verifying : sysstat-11.7.3-7.0.1.el8_7.1.x86_64 31/32
Verifying : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 32/32
Installed:
bc-1.07.1-5.el8.x86_64 bind-libs-32:9.11.36-5.el8_7.2.x86_64 bind-libs-lite-32:9.11.36-5.el8_7.2.x86_64 bind-license-32:9.11.36-5.el8_7.2.noarch
bind-utils-32:9.11.36-5.el8_7.2.x86_64 checkpolicy-2.9-1.el8.x86_64 compat-openssl10-1:1.0.2o-4.el8_6.x86_64 fstrm-0.6.1-3.el8.x86_64
geolite2-city-20180605-1.el8.noarch geolite2-country-20180605-1.el8.noarch gssproxy-0.8.0-21.el8.x86_64 ksh-20120801-257.0.1.el8.x86_64
libev-4.24-6.el8.x86_64 libmaxminddb-1.2.0-10.el8.x86_64 libnsl-2.28-211.0.1.el8.x86_64 libverto-libev-0.3.2-2.el8.x86_64
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 nfs-utils-1:2.3.3-57.el8_7.1.x86_64 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 policycoreutils-python-utils-2.9-20.0.1.el8.noarch
protobuf-c-1.3.0-6.el8.x86_64 python3-audit-3.0.7-4.el8.x86_64 python3-bind-32:9.11.36-5.el8_7.2.noarch python3-libsemanage-2.9-9.el8_6.x86_64
python3-policycoreutils-2.9-20.0.1.el8.noarch python3-pyyaml-3.12-12.el8.x86_64 python3-setools-4.3.0-3.el8.x86_64 quota-1:4.04-14.el8.x86_64
quota-nls-1:4.04-14.el8.noarch rpcbind-1.2.5-10.el8.x86_64 smartmontools-1:7.1-1.el8.x86_64 sysstat-11.7.3-7.0.1.el8_7.1.x86_64
Complete!
[root@srv23dev ~]# dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Last metadata expiration check: 0:07:33 ago on Tue 04 Apr 2023 09:29:48 AM -03.
Package oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 is already installed.
Dependencies resolved.
Nothing to do.
Complete!Instalação do Database 23c Developer Edition:
[root@srv23dev ~]# dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:10:02 ago on Tue 04 Apr 2023 09:29:48 AM -03.
Dependencies resolved.
========================================================================================================================================================================================================================================
Package Architecture Version Repository Size
========================================================================================================================================================================================================================================
Installing:
oracle-database-free-23c x86_64 1.0-1 @commandline 1.6 G
Transaction Summary
========================================================================================================================================================================================================================================
Install 1 Package
Total size: 1.6 G
Installed size: 5.2 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1
Installing : oracle-database-free-23c-1.0-1.x86_64 1/1
Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23c.conf' and then run '/etc/init.d/oracle-free-23c configure' as root.
Verifying : oracle-database-free-23c-1.0-1.x86_64 1/1
Installed:
oracle-database-free-23c-1.0-1.x86_64
Complete!
[root@srv23dev ~]# /etc/init.d/oracle-free-23c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password:
*****
Enter SYSTEM user password:
*********
Enter PDBADMIN User Password:
*******
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.
Connect to Oracle Database using one of the connect strings:
Pluggable database: srv23dev/FREEPDB1
Multitenant container database: srv23dev
#Password oracle user
[root@srv23dev ~]# passwd oracleDiretórios usados após a instalação:
[oracle@srv23dev ~]$ ls -lat /opt/oracle/
total 4
drwxrwx---. 4 oracle oinstall 78 Apr 4 09:48 oraInventory
drwxr-x---. 3 oracle oinstall 18 Apr 4 09:43 audit
drwxr-xr-x. 9 oracle oinstall 113 Apr 4 09:43 .
drwxr-x---. 3 oracle oinstall 18 Apr 4 09:43 oradata
drwxr-x---. 3 oracle oinstall 18 Apr 4 09:43 admin
drwxr-xr-x. 4 oracle oinstall 31 Apr 4 09:43 cfgtoollogs
drwxrwxr-x. 25 oracle oinstall 4096 Apr 4 09:41 diag
drwxr-xr-x. 4 root root 36 Apr 4 09:41 ..
drwxr-xr-x. 3 oracle oinstall 17 Apr 4 09:40 product
#Oracle base.
/opt/oracle
#Oracle home
/opt/oracle/product/23c/dbhomeFree
#Database files
/opt/oracle/oradata/FREE
#Diagnostic logs
/opt/oracle/diag subdirectories
#Database creation logs.
/opt/oracle/cfgtoollogs/dbca/FREE
#Configuration default parameters.
/etc/sysconfig/oracle-free-23c.conf
#Configuration and services script.
/etc/init.d/oracle-free-23cConfigurações do Database para setup customizado:
#Configuration default parameters.
[oracle@srv23dev ~]$ strings /etc/sysconfig/oracle-free-23c.conf
#This is a configuration file to setup the Oracle Database.
#It is used when running '/etc/init.d/oracle-free-23c configure'.
# LISTENER PORT used Database listener, Leave empty for automatic port assignment
LISTENER_PORT=
# Character set of the database
CHARSET=AL32UTF8
# Database file directory
# If not specified, database files are stored under Oracle base/oradata
DBFILE_DEST=
# DB Domain name
DB_DOMAIN=
# SKIP Validations, memory, space
SKIP_VALIDATIONS=falseInformações do Database:
[oracle@srv23dev ~]$ ps aux | grep smon
oracle 53423 0.0 2.4 1502036 68344 ? Ss 09:48 0:00 db_smon_FREE
oracle 53904 0.0 0.0 12144 1196 pts/0 S+ 09:50 0:00 grep --color=auto smon
[oracle@srv23dev ~]$
[oracle@srv23dev ~]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base has been set to /opt/oracle
[oracle@srv23dev ~]$ lsnrctl status
LSNRCTL for Linux: Version 23.0.0.0.0 - Developer-Release on 04-APR-2023 10:05:38
Copyright (c) 1991, 2023, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srv23dev)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 23.0.0.0.0 - Developer-Release
Start Date 04-APR-2023 09:43:43
Uptime 0 days 0 hr. 21 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service FREE
Listener Parameter File /opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/srv23dev/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv23dev)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "FREE" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "FREEXDB" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "f8831750e283d1a4e053870da8c0083a" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "freepdb1" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@srv23dev ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Tue Apr 4 09:55:56 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> set lines 200
col DATABASE_HOST for a25;
col DB_UNIQUE_NAME for a25
col HOST_NAME for a15;
col DATABASE_ROLE for a10
col OPEN_MODE for a10
col STARTUP_TIME for a20
alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS';
SELECT i.HOST_NAME "DATABASE_HOST" ,
i.INSTANCE_NAME "DB_NAME",
d.db_unique_name "DB_UNIQUE_NAME" ,
d.DATABASE_ROLE " DATABASE_ROLE",
i.VERSION,
d.OPEN_MODE " OPEN_MODE ",
d.LOG_MODE
,STARTUSQL> SQL> SQL> SQL> SQL> SQL> SQL> P_TIME
from GV$DATABASE d, gv$instance i
where i.INST_ID=d.INST_ID;
Session altered.
SQL> 2 3 4 5 6 7 8 9 10
DATABASE_HOST DB_NAME DB_UNIQUE_NAME DATABASE_ROLE VERSION OPEN_MODE LOG_MODE STARTUP_TIME
------------------------- ---------------- ------------------------- ---------------- ----------------- -------------------- ------------ --------------------
srv23dev FREE FREE PRIMARY 23.0.0.0.0 READ WRITE NOARCHIVELOG 03/04/2023 22:48:19
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> set lines 200
SQL> select BANNER_FULL from gv$version;
BANNER_FULL
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL>
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show PDBS;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
Link para documentação:
https://www.oracle.com/news/announcement/oracle-database-23c-free-developer-release-2023-04-03/?source=:so:fb:or:awr:odb:::RC_WWMK220913P00038:&SC=:so:fb:or:awr:odb:::RC_WWMK220913P00038:&pcode=WWMK220913P00038
https://blogs.oracle.com/database/post/oracle-database-23c-free
https://docs.oracle.com/en/database/oracle/oracle-database/23/index.html
https://www.oracle.com/database/free/
https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/index.html
https://www.oracle.com/database/free/?source=:so:tw:or:awr:odb:::RC_WWMK220913P00038:
https://docs.oracle.com/en/database/oracle/oracle-database/23/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87