Oracledbacr, por simple pasión ...-Copyleft Miembro Comunidad Tecnológica de Oracle Latinoamérica

viernes, 15 de octubre de 2021

LAOUC Evento de Primera, se complace de contar con el apoyo de NOVACOMP, Tecnología de Información

Agradecimiento especial a NOVACOMP
https://crnova.com/

Por su valiosa participación y aporte como patrocinador en el 
LAOUC Evento de Primavera!, un honor contar con su apoyo 

No se lo pierdan!!
#Regístrate ya, elige la o las charlas en la que deseas participar! 
https://bit.ly/3vkGuT5

Evento #Gratuito
#LAOUCEventodePrimavera #eventodeprimavera #PrimaveraLive #primaveraLAOUC #eventoPrimaveraLAOUC

LAOUC EVENTO DE PRIMAVERA, llega a ustedes gracias al apoyo de CERTIFICATIC de México.

Agradecimiento especial a CERTIFICATIC
https://www.certificatic.org/
Por su valiosa participación y aporte como patrocinador en el 
LAOUC Evento de Primavera!, un honor contar con su apoyo 
No se lo pierdan!!

#Regístrate ya, elige la o las charlas en la que deseas participar! 

https://bit.ly/3vkGuT5
Evento #Gratuito
#LAOUCEventodePrimavera #eventodeprimavera #PrimaveraLive #primaveraLAOUC #eventoPrimaveraLAOUC

Ya es posible hacer las inscripciones al Evento de Primavera de @laouc, Noviembre 9 y 10 de 2021

https://www.laouc.org/2021/09/29/laouc-evento-de-primavera/

No te pierdas esta gran oportunidad...!!!

#oracle #java #primaveraLAOUC

miércoles, 13 de octubre de 2021

LAOUC Evento de Primavera Noviembre 9 y 10, 2021 - Victor Orozco

Mayor información en:

https://www.laouc.org/2021/09/29/laouc-evento-de-primavera/

LAOUC Evento de Primavera Noviembre 9 y 10, 2021 - Rita Nuñez

Mayor información en:
https://www.laouc.org/2021/09/29/laouc-evento-de-primavera/

LAOUC Evento de Primavera Noviembre 9 y 10, Javier Morales

Mayor información en:
https://www.laouc.org/2021/09/29/laouc-evento-de-primavera/

Read any good Java books lately? By Alan Zeichick Editor in Chief, Java Magazine

A collection of new books celebrate the arrival of Java 17 and other exciting technologies

Week of October 11, 2021

Visit Java Magazine

Sometimes a web search doesn’t provide the deep information that you need to help master a new language feature. It’s hard to be inspired by an API’s dry reference materials, and even a fabulous magazine article may not offer sufficient context.

That’s where books serve and delight.

To celebrate the release of Java 17, Java Magazine reached out to the book community and asked them to share their list of upcoming Java titles to be published by the end of 2021, more or less. Perhaps one is the exact book you’ve been looking for.

Take care,
Alan Zeichick
Editor in Chief, Java Magazine
@zeichick

martes, 12 de octubre de 2021

Aniversario #1 Podcast Oracledbacr #CitaACiegas

Hace un año oficialmente hice mi primera publicación del Podcast Oracledbacr #CitaACiegas con Sebastián D'Alessandro.

Desde entonces, se han públicado 38 programas más, con participantes de casi todos los países de Latinoamerica y España involucrados de alguna manera con la tecnología Oracle y Java.

Hoy 12 meses después, el podcast se encuentra disponible en 9 plataformas distintas, incluyendo #Spotify y #iTunes

Proceso lento de adopción del podcast, pero a paso seguro, con 1450 reproducciones y 665 en el canal de youtube https://www.youtube.com/channel/UC2dLFO6QcV3ExcY3QNZNx2w

Una gran experiencia y un gran aprendizaje.

LAOUC Evento de Primavera- Noviembre 9 y 10- Connor McDonald

Mayor información en:

https://www.laouc.org/2021/09/29/laouc-evento-de-primavera/

New Event: "OCI – Getting Started with OCI Language" - Oct 21, 2021

New Event: "OCI – Getting Started with OCI Language"

When: Oct 21, 2021, 8:00 AM - Oct 21, 2021, 9:00 AM (Pacific Time)

Location: Register for Event

Organizer: Kenna Kettrick-Oracle

Timezone Considerations:

Live virtual meeting - for other timezones, click here.

Please note that time displayed in Date and Time defaults to the timezone of your laptop/PC.

Description:

Join this webinar to discover OCI Language, an AI service that helps you with natural language processing tasks. See a demo of the OCI Language capabilities and learn how you can consume it.

Along with live Q&A with OCI Language experts, you'll see how you can use the service to perform tasks such as:

• Automatically detect the language of some text.

• Automatically tag your documents.

• Create a customer feedback analytics system.

• Extract named entities from content using state of the art deep learning models.

Presented by:

• Luis Cabrera-Cordon, Senior Director of Product Management, AI Services, OCI

The replay and slide deck will be available from this event posting within 24 hours following the live session.

Webcast:

We strongly recommend you register using your Cloud Customer Connect registered email ID.

Registration is required to attend this event. Once registered, you will receive a confirmation email with login details and an option to add to your calendar. This is a live webinar with an opportunity to get your questions answered.

Contact Email:

kenna.kettrick@oracle.com

domingo, 10 de octubre de 2021

Instalando MySQL Server Community 8.0 en Oracle Linux OCI

Primero que todo, la presente instalación se ha hecho sobre una VM creada en un ambiente OCI con el shape Standard E3.Flex, con 16GB de memoria RAM, con 1 (uno) AMD FLEXIBLE OCPU.

Antes de proceder con la instalación del motor de base de datos comunitario de MYSQL, primero que todo proceda a realizar una actualización de la máquina virtual de Oracle Linux con el comando:

Primero que todo necesitamos tener privilegios de root en el server

sudo -s /bin/bash

Luego podemos utilizar la herramienta YUM para realizar la actualización

[root@oracle-mysql-server opc]# yum update

Una vez que concluya la actualización del sistema operativo Oracle Linux procedemos a hacer la instalación de algunos paquetes ligados al software de MySQL.

[root@oracle-mysql-server opc]# yum install mysql*
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package mysql-connector-java.noarch 1:5.1.25-3.el7 will be installed
--> Processing Dependency: java >= 1:1.6.0
for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
--> Processing Dependency: jta >= 1.0
for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
--> Processing Dependency: jpackage-utils for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
--> Processing Dependency: slf4j
for package: 1:mysql-connector-java-5.1.25-3.el7.noarch
---> Package mysql-connector-odbc.x86_64 0:5.2.5-8.el7 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit)
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit)
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit)
or package: mysql-connector-odbc-5.2.5-8.el7.x86_64
---> Package mysql-release-el7.x86_64 0:1.0-5.el7 will be installed
--> Running transaction check
---> Package geronimo-jta.noarch 0:1.1.1-17.el7 will be installed
---> Package javapackages-tools.noarch 0:3.4.1-11.el7 will be installed
--> Processing Dependency: python-javapackages = 3.4.1-11.el7
for package: javapackages-tools-3.4.1-11.el7.noarch
--> Processing Dependency: libxslt
for package: javapackages-tools-3.4.1-11.el7.noarch
---> Package jre1.8.x86_64 0:1.8.0_301-fcs will be installed
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be installed
---> Package slf4j.noarch 0:1.7.4-4.el7_4 will be installed
--> Processing Dependency: mvn(ch.qos.cal10n:cal10n-api)
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(commons-lang:commons-lang)
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(commons-logging:commons-logging)
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(javassist:javassist)
for package: slf4j-1.7.4-4.el7_4.noarch
--> Processing Dependency: mvn(log4j:log4j)
for package: slf4j-1.7.4-4.el7_4.noarch
---> Package unixODBC.x86_64 0:2.3.1-14.0.1.el7 will be installed
--> Processing Dependency: libltdl.so.7()(64bit)
for package: unixODBC-2.3.1-14.0.1.el7.x86_64
--> Running transaction check
---> Package apache-commons-lang.noarch 0:2.6-15.el7 will be installed
---> Package apache-commons-logging.noarch 0:1.1.2-7.el7 will be installed
--> Processing Dependency: mvn(avalon-framework:avalon-framework-api)
for package: apache-commons-logging-1.1.2-7.el7.noarch
--> Processing Dependency: mvn(logkit:logkit)
for package: apache-commons-logging-1.1.2-7.el7.noarch
---> Package cal10n.noarch 0:0.7.7-4.el7 will be installed
---> Package javassist.noarch 0:3.16.1-10.el7 will be installed
---> Package libtool-ltdl.x86_64 0:2.4.2-22.el7_3 will be installed
---> Package libxslt.x86_64 0:1.1.28-6.0.1.el7 will be installed
---> Package log4j.noarch 0:1.2.17-16.el7_4 will be installed
--> Processing Dependency: mvn(javax.mail:mail)
for package: log4j-1.2.17-16.el7_4.noarch
--> Processing Dependency: mvn(org.apache.geronimo.specs:geronimo-jms_1.1_spec)
for package: log4j-1.2.17-16.el7_4.noarch
---> Package python-javapackages.noarch 0:3.4.1-11.el7 will be installed
--> Processing Dependency: python-lxml
for package: python-javapackages-3.4.1-11.el7.noarch
--> Running transaction check
---> Package avalon-framework.noarch 0:4.3-10.el7 will be installed
--> Processing Dependency: xalan-j2
for package: avalon-framework-4.3-10.el7.noarch
---> Package avalon-logkit.noarch 0:2.1-14.el7 will be installed
--> Processing Dependency: tomcat-servlet-3.0-api
for package: avalon-logkit-2.1-14.el7.noarch
---> Package geronimo-jms.noarch 0:1.1.1-19.el7 will be installed
---> Package javamail.noarch 0:1.4.6-8.el7 will be installed
---> Package python-lxml.x86_64 0:3.2.1-4.el7 will be installed
--> Running transaction check
---> Package tomcat-servlet-3.0-api.noarch 0:7.0.76-16.el7_9 will be installed
---> Package xalan-j2.noarch 0:2.7.1-23.el7 will be installed
--> Processing Dependency: osgi(org.apache.xerces)
for package: xalan-j2-2.7.1-23.el7.noarch
--> Processing Dependency: xerces-j2 for package: xalan-j2-2.7.1-23.el7.noarch
--> Running transaction check
---> Package rh-maven36-xerces-j2.noarch 0:2.12.0-3.2.el7 will be installed
--> Processing Dependency: rh-maven36-xalan-j2 >= 2.7.1
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-xml-commons-apis >= 1.4.01
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-xml-commons-resolver >= 1.2
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: java-headless
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: osgi(javax.xml)
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: osgi(org.apache.xml.resolver)
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-javapackages-tools
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-mvn(xml-apis:xml-apis)
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
--> Processing Dependency: rh-maven36-runtime
for package: rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
---> Package xerces-j2.noarch 0:2.11.0-17.el7_0 will be installed
--> Processing Dependency: xml-commons-apis >= 1.4.01
for package: xerces-j2-2.11.0-17.el7_0.noarch
--> Processing Dependency: xml-commons-resolver >= 1.2
for package: xerces-j2-2.11.0-17.el7_0.noarch
--> Running transaction check
---> Package java-1.8.0-openjdk-headless.x86_64 1:1.8.0.302.b08-0.el7_9 will be installed
--> Processing Dependency: copy-jdk-configs >= 3.3
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: tzdata-java >= 2021a
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: cups-libs(x86-64)
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: libjpeg.so.62(LIBJPEG_6.2)(64bit)
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: lksctp-tools(x86-64)
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: pcsc-lite-libs(x86-64)
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
--> Processing Dependency: libjpeg.so.62()(64bit)
for package: 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
---> Package rh-maven36-javapackages-tools.noarch 0:5.3.1-4.2.el7 will be installed
--> Processing Dependency: rh-maven36-javapackages-filesystem = 5.3.1-4.2.el7
for package: rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarc
---> Package rh-maven36-runtime.x86_64 0:1-1.el7 will be installed
---> Package rh-maven36-xalan-j2.noarch 0:2.7.2-1.2.el7 will be installed
---> Package rh-maven36-xml-commons-apis.noarch 0:1.4.01-26.2.el7 will be installed
---> Package rh-maven36-xml-commons-resolver.noarch 0:1.2-27.2.el7 will be installed
---> Package xml-commons-apis.noarch 0:1.4.01-16.el7 will be installed
---> Package xml-commons-resolver.noarch 0:1.2-15.el7 will be installed
--> Running transaction check
---> Package copy-jdk-configs.noarch 0:3.3-10.el7_5 will be installed
---> Package cups-libs.x86_64 1:1.6.3-51.el7 will be installed
---> Package libjpeg-turbo.x86_64 0:1.2.90-8.el7 will be installed
---> Package lksctp-tools.x86_64 0:1.0.17-2.el7 will be installed
---> Package pcsc-lite-libs.x86_64 0:1.8.8-8.el7 will be installed
---> Package rh-maven36-javapackages-filesystem.noarch 0:5.3.1-4.2.el7 will be installed
---> Package tzdata-java.noarch 0:2021a-1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=====================================================================
Package Arch Version Repository
=====================================================================
Installing:
mysql-connector-java noarch 1:5.1.25-3.el7 ol7_latest
mysql-connector-odbc x86_64 5.2.5-8.el7 ol7_latest
mysql-release-el7 x86_64 1.0-5.el7 ol7_latest
Installing for dependencies:
apache-commons-lang noarch 2.6-15.el7 ol7_latest
apache-commons-logging noarch 1.1.2-7.el7 ol7_latest
avalon-framework noarch 4.3-10.el7 ol7_latest
avalon-logkit noarch 2.1-14.el7 ol7_latest
cal10n noarch 0.7.7-4.el7 ol7_latest
copy-jdk-configs noarch 3.3-10.el7_5 ol7_latest
cups-libs x86_64 1:1.6.3-51.el7 ol7_latest
geronimo-jms noarch 1.1.1-19.el7 ol7_latest
geronimo-jta noarch 1.1.1-17.el7 ol7_latest
java-1.8.0-openjdk-headless x86_64 1:1.8.0.302.b08-0.el7_9 ol7_latest
javamail noarch 1.4.6-8.el7 ol7_latest
javapackages-tools noarch 3.4.1-11.el7 ol7_latest
javassist noarch 3.16.1-10.el7 ol7_latest
jre1.8 x86_64 1.8.0_301-fcs ol7_oci_included
libjpeg-turbo x86_64 1.2.90-8.el7 ol7_latest
libtool-ltdl x86_64 2.4.2-22.el7_3 ol7_latest
libxslt x86_64 1.1.28-6.0.1.el7 ol7_latest
lksctp-tools x86_64 1.0.17-2.el7 ol7_latest
log4j noarch 1.2.17-16.el7_4 ol7_latest
mariadb-libs x86_64 1:5.5.68-1.el7 ol7_latest
pcsc-lite-libs x86_64 1.8.8-8.el7 ol7_latest
python-javapackages noarch 3.4.1-11.el7 ol7_latest
python-lxml x86_64 3.2.1-4.el7 ol7_latest
rh-maven36-javapackages-filesystem noarch 5.3.1-4.2.el7 ol7_software_collect
rh-maven36-javapackages-tools noarch 5.3.1-4.2.el7 ol7_software_collect
rh-maven36-runtime x86_64 1-1.el7 ol7_software_collect
rh-maven36-xalan-j2 noarch 2.7.2-1.2.el7 ol7_software_collect
rh-maven36-xerces-j2 noarch 2.12.0-3.2.el7 ol7_software_collect
rh-maven36-xml-commons-apis noarch 1.4.01-26.2.el7 ol7_software_collect
rh-maven36-xml-commons-resolver noarch 1.2-27.2.el7 ol7_software_collect
slf4j noarch 1.7.4-4.el7_4 ol7_latest
tomcat-servlet-3.0-api noarch 7.0.76-16.el7_9 ol7_latest
tzdata-java noarch 2021a-1.el7 ol7_latest
unixODBC x86_64 2.3.1-14.0.1.el7 ol7_latest
xalan-j2 noarch 2.7.1-23.el7 ol7_latest
xerces-j2 noarch 2.11.0-17.el7_0 ol7_latest
xml-commons-apis noarch 1.4.01-16.el7 ol7_latest
xml-commons-resolver noarch 1.2-15.el7 ol7_latest
Transaction Summary
=====================================================================
Install 3 Packages (+38 Dependent packages)
Total download size: 106 M
Installed size: 313 M
Is this ok [y/d/N]: y
Downloading packages:
(1/41): apache-commons-logging-1.1.2-7.el7.noarch.rpm
(2/41): avalon-framework-4.3-10.el7.noarch.rpm
(3/41): avalon-logkit-2.1-14.el7.noarch.rpm
(4/41): cal10n-0.7.7-4.el7.noarch.rpm
(5/41): copy-jdk-configs-3.3-10.el7_5.noarch.rpm
(6/41): cups-libs-1.6.3-51.el7.x86_64.rpm
(7/41): geronimo-jms-1.1.1-19.el7.noarch.rpm
(8/41): geronimo-jta-1.1.1-17.el7.noarch.rpm
(9/41): apache-commons-lang-2.6-15.el7.noarch.rpm
(10/41): javamail-1.4.6-8.el7.noarch.rpm
(11/41): javapackages-tools-3.4.1-11.el7.noarch.rpm
(12/41): javassist-3.16.1-10.el7.noarch.rpm
(13/41): libjpeg-turbo-1.2.90-8.el7.x86_64.rpm
(14/41): libtool-ltdl-2.4.2-22.el7_3.x86_64.rpm
(15/41): libxslt-1.1.28-6.0.1.el7.x86_64.rpm
(16/41): lksctp-tools-1.0.17-2.el7.x86_64.rpm
(17/41): log4j-1.2.17-16.el7_4.noarch.rpm
(18/41): mariadb-libs-5.5.68-1.el7.x86_64.rpm
(19/41): mysql-connector-java-5.1.25-3.el7.noarch.rpm
(20/41): mysql-connector-odbc-5.2.5-8.el7.x86_64.rpm
(21/41): mysql-release-el7-1.0-5.el7.x86_64.rpm
(22/41): pcsc-lite-libs-1.8.8-8.el7.x86_64.rpm
(23/41): python-javapackages-3.4.1-11.el7.noarch.rpm
(24/41): rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarch.rpm
(25/41): python-lxml-3.2.1-4.el7.x86_64.rpm
(26/41): rh-maven36-javapackages-filesystem-5.3.1-4.2.el7.noarch.rpm
(27/41): rh-maven36-runtime-1-1.el7.x86_64.rpm
(28/41): rh-maven36-xalan-j2-2.7.2-1.2.el7.noarch.rpm
(29/41): rh-maven36-xml-commons-apis-1.4.01-26.2.el7.noarch.rpm
(30/41): rh-maven36-xml-commons-resolver-1.2-27.2.el7.noarch.rpm
(31/41): rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch.rpm
(32/41): slf4j-1.7.4-4.el7_4.noarch.rpm
(33/41): tomcat-servlet-3.0-api-7.0.76-16.el7_9.noarch.rpm
(34/41): tzdata-java-2021a-1.el7.noarch.rpm
(35/41): unixODBC-2.3.1-14.0.1.el7.x86_64.rpm
(36/41): xalan-j2-2.7.1-23.el7.noarch.rpm
(37/41): xerces-j2-2.11.0-17.el7_0.noarch.rpm
(38/41): xml-commons-apis-1.4.01-16.el7.noarch.rpm
(39/41): xml-commons-resolver-1.2-15.el7.noarch.rpm
(40/41): java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64.rpm
(41/41): jre-8u301-linux-x64.rpm
--------------------------------------------------------------------------------------------------------------------------------------Total 909
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : jre1.8-1.8.0_301-fcs.x86_64
Unpacking JAR files...
plugin.jar...
javaws.jar...
deploy.jar...
rt.jar...
jsse.jar...
charsets.jar...
localedata.jar...
Installing : libxslt-1.1.28-6.0.1.el7.x86_64
Installing : python-lxml-3.2.1-4.el7.x86_64
Installing : python-javapackages-3.4.1-11.el7.noarch
Installing : javapackages-tools-3.4.1-11.el7.noarch
Installing : xml-commons-apis-1.4.01-16.el7.noarch
Installing : xml-commons-resolver-1.2-15.el7.noarch
Installing : geronimo-jms-1.1.1-19.el7.noarch
Installing : tomcat-servlet-3.0-api-7.0.76-16.el7_9.noarch
Installing : javamail-1.4.6-8.el7.noarch
Installing : log4j-1.2.17-16.el7_4.noarch
Installing : apache-commons-lang-2.6-15.el7.noarch
Installing : cal10n-0.7.7-4.el7.noarch
Installing : javassist-3.16.1-10.el7.noarch
Installing : geronimo-jta-1.1.1-17.el7.noarch
Installing : copy-jdk-configs-3.3-10.el7_5.noarch
Installing : rh-maven36-javapackages-filesystem-5.3.1-4.2.el7.noarch
Installing : pcsc-lite-libs-1.8.8-8.el7.x86_64
Installing : 1:mariadb-libs-5.5.68-1.el7.x86_64
Installing : 1:cups-libs-1.6.3-51.el7.x86_64
Installing : lksctp-tools-1.0.17-2.el7.x86_64
Installing : libtool-ltdl-2.4.2-22.el7_3.x86_64
Installing : unixODBC-2.3.1-14.0.1.el7.x86_64
Installing : tzdata-java-2021a-1.el7.noarch
Installing : libjpeg-turbo-1.2.90-8.el7.x86_64
Installing : 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
Installing : rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarch
Installing : rh-maven36-runtime-1-1.el7.x86_64
Installing : rh-maven36-xml-commons-apis-1.4.01-26.2.el7.noarch
Installing : rh-maven36-xml-commons-resolver-1.2-27.2.el7.noarch
Installing : xalan-j2-2.7.1-23.el7.noarch
Installing : xerces-j2-2.11.0-17.el7_0.noarch
Installing : rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
Installing : rh-maven36-xalan-j2-2.7.2-1.2.el7.noarch
Installing : avalon-logkit-2.1-14.el7.noarch
Installing : apache-commons-logging-1.1.2-7.el7.noarch
Installing : avalon-framework-4.3-10.el7.noarch
Installing : slf4j-1.7.4-4.el7_4.noarch
Installing : 1:mysql-connector-java-5.1.25-3.el7.noarch
Installing : mysql-connector-odbc-5.2.5-8.el7.x86_64
Installing : mysql-release-el7-1.0-5.el7.x86_64
Verifying : rh-maven36-xalan-j2-2.7.2-1.2.el7.noarch
Verifying : libjpeg-turbo-1.2.90-8.el7.x86_64
Verifying : avalon-logkit-2.1-14.el7.noarch
Verifying : tomcat-servlet-3.0-api-7.0.76-16.el7_9.noarch
Verifying : javamail-1.4.6-8.el7.noarch
Verifying : libxslt-1.1.28-6.0.1.el7.x86_64
Verifying : xml-commons-resolver-1.2-15.el7.noarch
Verifying : unixODBC-2.3.1-14.0.1.el7.x86_64
Verifying : xml-commons-apis-1.4.01-16.el7.noarch
Verifying : log4j-1.2.17-16.el7_4.noarch
Verifying : apache-commons-lang-2.6-15.el7.noarch
Verifying : avalon-framework-4.3-10.el7.noarch
Verifying : python-javapackages-3.4.1-11.el7.noarch
Verifying : tzdata-java-2021a-1.el7.noarch
Verifying : libtool-ltdl-2.4.2-22.el7_3.x86_64
Verifying : xerces-j2-2.11.0-17.el7_0.noarch
Verifying : lksctp-tools-1.0.17-2.el7.x86_64
Verifying : 1:cups-libs-1.6.3-51.el7.x86_64
Verifying : geronimo-jms-1.1.1-19.el7.noarch
Verifying : 1:mariadb-libs-5.5.68-1.el7.x86_64
Verifying : mysql-connector-odbc-5.2.5-8.el7.x86_64
Verifying : rh-maven36-xml-commons-apis-1.4.01-26.2.el7.noarch
Verifying : cal10n-0.7.7-4.el7.noarch
Verifying : rh-maven36-runtime-1-1.el7.x86_64
Verifying : rh-maven36-xml-commons-resolver-1.2-27.2.el7.noarch
Verifying : apache-commons-logging-1.1.2-7.el7.noarch
Verifying : pcsc-lite-libs-1.8.8-8.el7.x86_64
Verifying : xalan-j2-2.7.1-23.el7.noarch
Verifying : javapackages-tools-3.4.1-11.el7.noarch
Verifying : jre1.8-1.8.0_301-fcs.x86_64
Verifying : mysql-release-el7-1.0-5.el7.x86_64
Verifying : rh-maven36-javapackages-filesystem-5.3.1-4.2.el7.noarch
Verifying : rh-maven36-javapackages-tools-5.3.1-4.2.el7.noarch
Verifying : 1:java-1.8.0-openjdk-headless-1.8.0.302.b08-0.el7_9.x86_64
Verifying : 1:mysql-connector-java-5.1.25-3.el7.noarch
Verifying : python-lxml-3.2.1-4.el7.x86_64
Verifying : rh-maven36-xerces-j2-2.12.0-3.2.el7.noarch
Verifying : slf4j-1.7.4-4.el7_4.noarch
Verifying : javassist-3.16.1-10.el7.noarch
Verifying : geronimo-jta-1.1.1-17.el7.noarch
Verifying : copy-jdk-configs-3.3-10.el7_5.noarch
Installed:
mysql-connector-java.noarch 1:5.1.25-3.el7
mysql-connector-odbc.x86_64 0:5.2.5-8.el7
mysql-release-el7.x86_6
Dependency Installed:
apache-commons-lang.noarch 0:2.6-15.el7
apache-commons-logging.noarch 0:1.1.2-7.el7
avalon-framework.noarch 0:4.3-10.el7
avalon-logkit.noarch 0:2.1-14.el7
cal10n.noarch 0:0.7.7-4.el7
copy-jdk-configs.noarch 0:3.3-10.el7_5
cups-libs.x86_64 1:1.6.3-51.el7
geronimo-jms.noarch 0:1.1.1-19.el7
geronimo-jta.noarch 0:1.1.1-17.el7
java-1.8.0-openjdk-headless.x86_64 1:1.8.0.302.b08-0.el7_9
javamail.noarch 0:1.4.6-8.el7
javapackages-tools.noarch 0:3.4.1-11.el7
javassist.noarch 0:3.16.1-10.el7
jre1.8.x86_64 0:1.8.0_301-fcs
libjpeg-turbo.x86_64 0:1.2.90-8.el7
libtool-ltdl.x86_64 0:2.4.2-22.el7_3
libxslt.x86_64 0:1.1.28-6.0.1.el7
lksctp-tools.x86_64 0:1.0.17-2.el7
log4j.noarch 0:1.2.17-16.el7_4
mariadb-libs.x86_64 1:5.5.68-1.el7
pcsc-lite-libs.x86_64 0:1.8.8-8.el7
python-javapackages.noarch 0:3.4.1-11.el7
python-lxml.x86_64 0:3.2.1-4.el7
rh-maven36-javapackages-filesystem.noarch 0:5.3.1-4.2.el7
rh-maven36-javapackages-tools.noarch 0:5.3.1-4.2.el7
rh-maven36-runtime.x86_64 0:1-1.el7
rh-maven36-xalan-j2.noarch 0:2.7.2-1.2.el7
rh-maven36-xerces-j2.noarch 0:2.12.0-3.2.el7
rh-maven36-xml-commons-apis.noarch 0:1.4.01-26.2.el7
h-maven36-xml-commons-resolver.noarch 0:1.2-27.2.el7
slf4j.noarch 0:1.7.4-4.el7_4
tomcat-servlet-3.0-api.noarch 0:7.0.76-16.el7_9
tzdata-java.noarch 0:2021a-1.el7
unixODBC.x86_64 0:2.3.1-14.0.1.el7
xalan-j2.noarch 0:2.7.1-23.el7
xerces-j2.noarch 0:2.11.0-17.el7_0
xml-commons-apis.noarch 0:1.4.01-16.el7
xml-commons-resolver.noarch 0:1.2-15.el7
Complete!

Los paquetes de MySQL están firmados con una llave pública GPG. Vamos a descargar las llaves públicas desde el sitio oficial, utilizando para ello la herramienta WGET

[root@oracle-mysql-server opc]# cd /etc/pki/rpm-gpg
[root@oracle-mysql-server rpm-gpg]# wget https://repo.mysql.com/RPM-GPG-KEY-mysq l
--2021-09-17 16:47:13-- https://repo.mysql.com/RPM-GPG-KEY-mysql
Resolving repo.mysql.com (repo.mysql.com)... 23.66.97.60
Connecting to repo.mysql.com (repo.mysql.com)|23.66.97.60|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 27824 (27K) [text/plain]
Saving to: ‘RPM-GPG-KEY-mysql’
100%[======================================>] 27,824 --.-K/s in 0.001s
2021-09-17 16:47:13 (28.9 MB/s) - ‘RPM-GPG-KEY-mysql’ saved [27824/27824]
[root@oracle-mysql-server rpm-gpg]# ls -la
total 52
drwxr-xr-x. 2 root root 4096 Sep 17 16:47 .
drwxr-xr-x. 10 root root 4096 Aug 18 17:24 ..
-rw-r--r--. 1 root root 1011 Sep 30 2020 RPM-GPG-KEY
-rw-r--r--. 1 root root 1519 Sep 30 2020 RPM-GPG-KEY-fedora
-rw-r--r--. 1 root root 1076 Sep 30 2020 RPM-GPG-KEY-fedora-test
-rw-r--r--. 1 root root 27824 Jan 18 2019 RPM-GPG-KEY-mysql
-rw-r--r--. 1 root root 1011 Sep 30 2020 RPM-GPG-KEY-oracle

En el directorio del repositorio de YUM, verifica que tengas el archivo mysql-community.repo. Si no es así, puedes copiar el siguiente contenido dentro de tu archivo de repo de facto.

[root@oracle-mysql-server rpm-gpg]# vi /etc/yum.repos.d/mysql-community.repo
==========================================
[ol7_optional_latest]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7Server
baseurl = https://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/optional/latest/x86_64/
cache = 0
cachedir = /var/cache/yum/x86_64/7Server/ol7_optional_latest
check_config_file_age = True
compare_providers_priority = 80
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage =
enabled = True
enablegroups = True
exclude =
failovermethod = priority
ftp_disable_epsv = False
gpgcadir = /var/lib/yum/repos/x86_64/7Server/ol7_optional_latest/gpgcadir
gpgcakey =
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7Server/ol7_optional_latest/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
hdrdir = /var/cache/yum/x86_64/7Server/ol7_optional_latest/headers
http_caching = all
includepkgs =
ip_resolve =
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid =
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink =
minrate = 0
mirrorlist =
mirrorlist_expire = 86400
name = Oracle Linux 7Server Optional Latest (x86_64)
old_base_cache_dir =
password =
persistdir = /var/lib/yum/repos/x86_64/7Server/ol7_optional_latest
pkgdir = /var/cache/yum/x86_64/7Server/ol7_optional_latest/packages
proxy = False
proxy_dict =
proxy_password =
proxy_username =
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert =
sslclientcert =
sslclientkey =
sslverify = True
throttle = 0
timeout = 30.0
ui_id = ol7_optional_latest/x86_64
ui_repoid_vars = releasever,
basearch
username =
====================================================================
repo: ol7_software_collections
[ol7_software_collections]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7Server
baseurl = https://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/SoftwareCollections/x86_64/
cache = 0
cachedir = /var/cache/yum/x86_64/7Server/ol7_software_collections
check_config_file_age = True
compare_providers_priority = 80
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage =
enabled = True
enablegroups = True
exclude =
failovermethod = priority
ftp_disable_epsv = False
gpgcadir = /var/lib/yum/repos/x86_64/7Server/ol7_software_collections/gpgcadir
gpgcakey =
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7Server/ol7_software_collections/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
hdrdir = /var/cache/yum/x86_64/7Server/ol7_software_collections/headers
http_caching = all
includepkgs =
ip_resolve =
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid =
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink =
minrate = 0
mirrorlist =
mirrorlist_expire = 86400
name = Software Collection Library release 3.0 packages for Oracle Linux 7 (x86_64)
old_base_cache_dir =
password =
persistdir = /var/lib/yum/repos/x86_64/7Server/ol7_software_collections
pkgdir = /var/cache/yum/x86_64/7Server/ol7_software_collections/packages
proxy = False
proxy_dict =
proxy_password =
proxy_username =
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert =
sslclientcert =
sslclientkey =
sslverify = True
throttle = 0
timeout = 30.0
ui_id = ol7_software_collections/x86_64
ui_repoid_vars = releasever,
basearch
username =

Iniciamos la instalación del motor de la base de datos MySQL

[root@oracle-mysql-server rpm-gpg]# yum install install mysql-community-server
Loaded plugins: langpacks, ulninfo
ol7_MySQL80
ol7_MySQL80_connectors_community
ol7_MySQL80_tools_community
ol7_UEKR6
ol7_addons
ol7_ksplice
ol7_latest
ol7_oci_included
ol7_optional_latest
ol7_software_collections
No package install available.
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.26-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.26-1.el7
for package: mysql-community-server-8.0.26-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11
for package: mysql-community-server-8.0.26-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.26-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.26-1.el7
for package: mysql-community-client-8.0.26-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11
for package: mysql-community-client-8.0.26-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.26-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit)
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit)
for package: mysql-connector-odbc-5.2.5-8.el7.x86_64
---> Package mysql-community-client-plugins.x86_64 0:8.0.26-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.26-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-connector-odbc.x86_64 0:5.2.5-8.el7 will be updated
---> Package mysql-connector-odbc.x86_64 0:8.0.26-1.el7 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
=====================================================================
Package Arch Version Repository
=====================================================================
Installing:
mysql-community-libs x86_64 8.0.26-1.el7 ol7_MySQL80
replacing mariadb-libs.x86_64 1:5.5.68-1.el7
mysql-community-server x86_64 8.0.26-1.el7 ol7_MySQL80
Installing for dependencies:
mysql-community-client x86_64 8.0.26-1.el7 ol7_MySQL80
mysql-community-client-plugins x86_64 8.0.26-1.el7 ol7_MySQL80
mysql-community-common x86_64 8.0.26-1.el7 ol7_MySQL80
Updating for dependencies:
mysql-connector-odbc x86_64 8.0.26-1.el7 ol7_MySQL80_connectors_communi
Transaction Summary
=====================================================================
Install 2 Packages (+3 Dependent packages)
Upgrade ( 1 Dependent package)
Total download size: 493 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/6): mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm
(2/6): mysql-community-common-8.0.26-1.el7.x86_64.rpm
(3/6): mysql-community-libs-8.0.26-1.el7.x86_64.rpm
(4/6): mysql-connector-odbc-8.0.26-1.el7.x86_64.rpm
(5/6): mysql-community-client-8.0.26-1.el7.x86_64.rpm
https://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/MySQL80_community/x86_64/getPackage/mysql-community-server-8.0.26-1.el7.x86_64.rpm:://yum-us-ashburn-1.oracle.com/repo/OracleLinux/OL7/MySQL80_community/x86_64/getPackage/mysql-community-server-8.0.26-1.el7.x86_64.rpm: (28,han 1000 bytes/sec transferred the last 30 seconds')
Trying other mirror.
(6/6): mysql-community-server-8.0.26-1.el7.x86_64.rpm
---------------------------------------------------------------------
Total 607
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-client-plugins-8.0.26-1.el7.x86_64
Installing : mysql-community-common-8.0.26-1.el7.x86_64
Installing : mysql-community-libs-8.0.26-1.el7.x86_64
Installing : mysql-community-client-8.0.26-1.el7.x86_64
Installing : mysql-community-server-8.0.26-1.el7.x86_64
Updating : mysql-connector-odbc-8.0.26-1.el7.x86_64
Success: Usage count is 1
Success: Usage count is 1
Cleanup : mysql-connector-odbc-5.2.5-8.el7.x86_64
Erasing : 1:mariadb-libs-5.5.68-1.el7.x86_64
Verifying : mysql-community-libs-8.0.26-1.el7.x86_64
Verifying : mysql-community-common-8.0.26-1.el7.x86_64
Verifying : mysql-community-server-8.0.26-1.el7.x86_64
Verifying : mysql-community-client-plugins-8.0.26-1.el7.x86_64
Verifying : mysql-connector-odbc-8.0.26-1.el7.x86_64
Verifying : mysql-community-client-8.0.26-1.el7.x86_64
Verifying : 1:mariadb-libs-5.5.68-1.el7.x86_64
Verifying : mysql-connector-odbc-5.2.5-8.el7.x86_64
Installed:
mysql-community-libs.x86_64 0:8.0.26-1.el7
mysql-community-server.x86_64 0:8.0.26-1.el7
Dependency Installed:
mysql-community-client.x86_64 0:8.0.26-1.el7
mysql-community-client-plugins.x86_64 0:8.0.26-1.el7
mysql-community-common.x
Dependency Updated:
mysql-connector-odbc.x86_64 0:8.0.26-1.el7
Replaced:
mariadb-libs.x86_64 1:5.5.68-1.el7
Complete!

Seguidamente, vamos a arrancar los servicios del motor de MySQL

[root@oracle-mysql-server rpm-gpg]# systemctl enable mysqld.service
[root@oracle-mysql-server rpm-gpg]# systemctl start mysqld.service

Verificamos el estado del servicio que se encuentre ejecutando.

[root@oracle-mysql-server rpm-gpg]# systemctl status mysqld.service
? mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2021-09-17 17:05:36 GMT; 6s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 23329 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 23492 (mysqld)
Status: "Server is operational"
Memory: 484.3M
CGroup: /system.slice/mysqld.service
+-23492 /usr/sbin/mysqld
Sep 17 17:05:28 oracle-mysql-server systemd[1]: Starting MySQL Server...
Sep 17 17:05:36 oracle-mysql-server systemd[1]: Started MySQL Server.

En el proceso de instalación de MySQL, se ha creado en el archivo de log, una línea con el password temporal de la cuenta administradora en la base de datos. Busca en el mismo con el siguiente comando:

[root@oracle-mysql-server rpm-gpg]# grep 'A temporary password is generated' /var/log/mysqld.log | tail -1
2021-09-17T17:05:32.078599Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ai.8Vo5OuaFO

Ahora procedemos a hacer el cambio de la clave del usuario root dentro de la base de datos MySQL llamanda a MYSQL_SECURE_INSTALLATION. También se configuran algunos atributos relacionados con la gestión del password.

[root@oracle-mysql-server rpm-gpg]# mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root:
The existing password for the user account root has expired. Please set a new password.
New password:
Re-enter new password:
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Using existing password for root.
Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : y
New password:
Re-enter new password:
Estimated strength of the password: 50
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
... Failed! Error: Your password does not satisfy the current policy requirements
New password:
Re-enter new password:
Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : yes
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.
Remove anonymous users? (Press y|Y for Yes, any other key for No) : yes
Success.

Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : yes
Success.
By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : no
... skipping.
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.
All done!

Una vez que recibamos el mensaje de que todo esta hecho, probamos conectarnos al motor de base de datos. Aquí utilizarás el password que recientemente haz creado.
[root@oracle-mysql-server rpm-gpg]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.26 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Ejecuta el siguiente comando para revisar las bases de datos creadas de facto.

Nos salimos de la línea de comando dentro de la consola de MySQL.
mysql> quit
Bye

Ahora bien, si es tu primer contacto con una base de datos MySQL, vamos a importar una base de datos, con objetos y registros que nos permitan servir de DEMO o LAB para iniciar nuestro proceso de aprendizaje.

En el navegador de tu computadora, anda a la dirección:

https://dev.mysql.com/doc/employee/en/employees-installation.html

Descarga del GitHUB, el archivo de la base de datos EMPLOYEES en tu máquina. Utiliza un cliente de SFTP para conectarte a tu VM en el OCI utilizando la IP Pública o la IP Privada si tienes configurado un VPN con el OCI de antemano.

Crea un directorio en el servidor y descarga ahí el archivo test_db-1.0.7.tar.gz

[root@oracle-mysql-server rpm-gpg]# mkdir /opt/testdb
[root@oracle-mysql-server rpm-gpg]# cd /opt/testdb
[root@oracle-mysql-server testdb]# ls -la
total 0
drwxr-xr-x. 2 root root 6 Sep 17 17:35 .
drwxr-xr-x. 5 root root 62 Sep 17 17:35 ..
[root@oracle-mysql-server testdb]# pwd
/opt/testdb
[root@oracle-mysql-server testdb]# cd /home/opc
[root@oracle-mysql-server opc]# ls -la
total 34796
drwx------. 5 opc opc 4096 Sep 17 17:36 .
drwxr-xr-x. 3 root root 17 Sep 17 16:14 ..
-rw-r--r--. 1 opc opc 18 Nov 22 2019 .bash_logout
-rw-r--r--. 1 opc opc 193 Nov 22 2019 .bash_profile
-rw-r--r--. 1 opc opc 231 Nov 22 2019 .bashrc
drwxrwxr-x. 3 opc opc 18 Sep 17 16:15 .cache
drwxrwxr-x. 3 opc opc 18 Sep 17 16:15 .config
-rw-r--r--. 1 opc opc 172 Apr 1 2020 .kshrc
drwx------. 2 opc opc 29 Sep 17 16:14 .ssh
-rw-rw-r--. 1 opc opc 35607473 Sep 17 17:33 test_db-1.0.7.tar.gz
[root@oracle-mysql-server opc]# mv test_db-1.0.7.tar.gz /opt/testdb/
[root@oracle-mysql-server opc]# cd /opt/testdb
[root@oracle-mysql-server testdb]# ls -la
total 34776
drwxr-xr-x. 2 root root 34 Sep 17 17:37 .
drwxr-xr-x. 5 root root 62 Sep 17 17:35 ..
-rw-rw-r--. 1 opc opc 35607473 Sep 17 17:33 test_db-1.0.7.tar.gz

Procede a desempacar el archivo de la base de datos de prueba.

[root@oracle-mysql-server testdb]# gunzip test_db-1.0.7.tar.gz
[root@oracle-mysql-server testdb]# ls -la
total 171740
drwxr-xr-x. 2 root root 31 Sep 17 17:37 .
drwxr-xr-x. 5 root root 62 Sep 17 17:35 ..
-rw-rw-r--. 1 opc opc 175861760 Sep 17 17:33 test_db-1.0.7.tar

El archivo que viene dentro del GZIP, es un archivo en formato TAR. Procede con el siguiente comando a descomprimir la carpeta.

[root@oracle-mysql-server testdb]# tar -xvf test_db-1.0.7.tar
test_db/Changelog
test_db/README.md
test_db/employees.sql
test_db/employees_partitioned.sql
test_db/employees_partitioned_5.1.sql
test_db/images/employees.gif
test_db/images/._employees.jpg
test_db/images/employees.jpg
test_db/images/employees.png
test_db/load_departments.dump
test_db/load_dept_emp.dump
test_db/load_dept_manager.dump
test_db/load_employees.dump
test_db/load_salaries1.dump
test_db/load_salaries2.dump
test_db/load_salaries3.dump
test_db/load_titles.dump
test_db/objects.sql
test_db/sakila/README.md
test_db/sakila/sakila-mv-data.sql
test_db/sakila/sakila-mv-schema.sql
test_db/show_elapsed.sql
test_db/sql_test.sh
test_db/test_employees_md5.sql
test_db/test_employees_sha.sql
test_db/test_versions.sh

Verifica el contenido descomprimido del archivo.
[root@oracle-mysql-server testdb]# ls -la
total 171744
drwxr-xr-x. 3 root root 46 Sep 17 17:37 .
drwxr-xr-x. 5 root root 62 Sep 17 17:35 ..
drwxr-xr-x. 4 root root 4096 Sep 17 17:37 test_db
-rw-rw-r--. 1 opc opc 175861760 Sep 17 17:33 test_db-1.0.7.tar

Como puedes observar, se ha creado un directorio con el nombre <test_db>. Ingresa al directorio y revisa el contenido del mismo.
[root@oracle-mysql-server testdb]# cd test_db

[root@oracle-mysql-server test_db]# ls -la
total 168344
drwxr-xr-x. 4 root root 4096 Sep 17 17:37 .
drwxr-xr-x. 3 root root 46 Sep 17 17:37 ..
-rw-r--r--. 1 501 games 964 Aug 30 2015 Changelog
-rw-r--r--. 1 501 games 7948 Sep 24 2015 employees_partitioned_5.1.sql
-rw-r--r--. 1 501 games 6276 Sep 24 2015 employees_partitioned.sql
-rw-r--r--. 1 501 games 4193 Sep 4 2020 employees.sql
drwxr-xr-x. 2 root root 92 Sep 17 17:37 images
-rw-r--r--. 1 501 games 250 May 29 2020 load_departments.dump
-rw-r--r--. 1 501 games 14159880 Aug 31 2015 load_dept_emp.dump
-rw-r--r--. 1 501 games 1090 Aug 31 2015 load_dept_manager.dump
-rw-r--r--. 1 501 games 17722832 Aug 31 2015 load_employees.dump
-rw-r--r--. 1 501 games 39806034 Aug 31 2015 load_salaries1.dump
-rw-r--r--. 1 501 games 39805981 Aug 31 2015 load_salaries2.dump
-rw-r--r--. 1 501 games 39080916 Aug 31 2015 load_salaries3.dump
-rw-r--r--. 1 501 games 21708736 Aug 31 2015 load_titles.dump
-rw-r--r--. 1 501 games 4568 Sep 19 2015 objects.sql
-rw-r--r--. 1 501 games 4325 May 29 2020 README.md
drwxr-xr-x. 2 root root 77 Sep 17 17:37 sakila
-rw-r--r--. 1 501 games 272 May 29 2020 show_elapsed.sql
-rwxr-xr-x. 1 501 games 1800 Aug 31 2015 sql_test.sh
-rw-r--r--. 1 501 games 4711 Sep 7 2020 test_employees_md5.sql
-rw-r--r--. 1 501 games 4715 Sep 7 2020 test_employees_sha.sql
-rwxr-xr-x. 1 501 games 2013 Sep 4 2020 test_versions.sh

ahora vamos a importar la base de datos.
[root@oracle-mysql-server test_db]# mysql -u root -p testdb < employees.sql
Enter password:
INFO
CREATING DATABASE STRUCTURE
INFO
storage engine: InnoDB
INFO
LOADING departments
INFO
LOADING employees
INFO
LOADING dept_emp
INFO
LOADING dept_manager
INFO
LOADING titles
INFO
LOADING salaries
data_load_time_diff
00:00:58

Con el siguiente procedimiento, podemos validar que la importación se encuentre consistente.

[root@oracle-mysql-server test_db]# time mysql -u root -p testdb -t < test_employees_md5.sql
Enter password:
+----------------------+
| INFO |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
+--------------+------------------+----------------------------------+
| table_name | expected_records | expected_crc |
+--------------+------------------+----------------------------------+
| departments | 9 | d1af5e170d2d1591d776d5638d71fc5f |
| dept_emp | 331603 | ccf6fe516f990bdaa49713fc478701b7 |
| dept_manager | 24 | 8720e2f0853ac9096b689c14664f847e |
| employees | 300024 | 4ec56ab5ba37218d187cf6ab09ce1aa1 |
| salaries | 2844047 | fd220654e95aea1b169624ffe3fca934 |
| titles | 443308 | bfa016c472df68e70a03facafa1bc0a8 |
+--------------+------------------+----------------------------------+
+--------------+------------------+----------------------------------+
| table_name | found_records | found_crc |
+--------------+------------------+----------------------------------+
| departments | 9 | d1af5e170d2d1591d776d5638d71fc5f |
| dept_emp | 331603 | ccf6fe516f990bdaa49713fc478701b7 |
| dept_manager | 24 | 8720e2f0853ac9096b689c14664f847e |
| employees | 300024 | 4ec56ab5ba37218d187cf6ab09ce1aa1 |
| salaries | 2844047 | fd220654e95aea1b169624ffe3fca934 |
| titles | 443308 | bfa016c472df68e70a03facafa1bc0a8 |
+--------------+------------------+----------------------------------+
+--------------+---------------+-----------+
| table_name | records_match | crc_match |
+--------------+---------------+-----------+
| departments | OK | ok |
| dept_emp | OK | ok |
| dept_manager | OK | ok |
| employees | OK | ok |
| salaries | OK | ok |
| titles | OK | ok |
+--------------+---------------+-----------+
+------------------+
| computation_time |
+------------------+
| 00:00:54 |
+------------------+
+---------+--------+
| summary | result |
+---------+--------+
| CRC | OK |
| count | OK |
+---------+--------+
real 1m3.014s
user 0m0.007s
sys 0m0.002s
[root@oracle-mysql-server test_db]#

Listo, ya puedes empezar a utilizar tu base de datos MySQL V8.0x.

Recuerda que la diferencia entre la versión EE y la versión Community, es que Oracle libera con un retraso aproximado de 6 meses, las nuevas versiones y características al motor Community.

Por otro lado, después de cierta cantidad de usuarios concurrentes, la versión Community deja de escalar y pierde rendimiento significativamente.

Adicionalmente, no cuentas con soporte del fabricante, sólo de la comunidad de usuarios.

¿Es usted un "Chef" de datos? 👨‍💻

By Javier de la Torre Medina: Ayer me estaba divirtiendo con DALL-E. Quería saber qué piensa la IA sobre la base de datos autónoma de Oracle y cómo podría ser una representación gráfica. ¡Me gustó mucho la descripción y quería compartirla con todos ustedes! Si consideramos que cada uno de los tipos de datos disponibles es un ingrediente diferente, Oracle Autónoma Database sería un Chef. Como tenemos todos los "ingredientes", siempre tendremos clientes contentos porque siempre encontrarás tu receta favorita.