Programa #9, Podcast Oracledbacr #CitaACigas, Alexis López de Colombia, Disponible ya en su plataforma favorita.

Alexis López es consultor independiente. Ha sido profesor universitario de cursos relacionados con tecnologías Java y conferencista en congresos reconocidos como: Oracle Open World, CodeOne, JavaOne y Oracle Groundbreakers Tour, cuenta con un título de ingeniero de sistemas y las siguientes certificaciones:

• AWS Certified Developer - Associate
• AWS Certified Cloud Practitioner
• Oracle Cloud Infrastructure Developer Associate
• Oracle Cloud Infrastructure Foundations Associate
• Especialista de implementación de Oracle Application Development Framework (ADF)
• Oracle Certified Professional Java 8
• Oracle Certified Professional Web Component Developer (OCPWCD)
• Oracle Certified Professional Java Mobile Application Development (OCPMAD)

Fue organizador del grupo de usuarios Java de Cali-Colombia (www.clojug.org) y miembro del comité organizador de JEspañol (www.jespanol.org). Su trabajo con estas comunidades tecnológicas le permitieron obtener los siguientes reconocimientos:

• Oracle Ace (alumni)
• Java Champion
• Oracle Groundbreaker Ambassador
• Duke Choice Award 2016 y 2017
• Oracle ACE, julio 2017

 

Tormenta tropical IOTA, se forma sobre el Caribe

 Se forma la tormenta tropical IOTA. NOAA, informa que los vientos máximos sostenidos han aumentado a cerca de 40 mph (65 km / h) con rachas más fuertes. Es probable que haya terminado el fortalecimiento de estable a rápido el fin de semana, y se pronostica que el sistema será un gran huracán cuando se acerca a Centroamérica.

Aquí la nota interesante:

IOTA es una tecnología de contabilidad distribuida de código abierto, cuyo objetivo es permitir de forma segura el intercambio de información y valor en el Internet de las Cosas.

Webinar Upgrade/Migrate/Consolidate to Oracle 19c with Mike Dietrich

 How to technically migrate to Oracle Database 19c ? 🤓

Learn with 𝐓𝐇𝐄 𝐄𝐱𝐩𝐞𝐫𝐭 Mike Dietrich during a technical webinar.
More info ⬇️

📆 November 25th
⏰ From 10:00am to 12:00pm

We are glad to announce that Mike Dietrich, uncontested expert for everything related to Oracle Database Upgrades and author of a dedicated blog, will present this 2-hour webinar “Upgrade/Migrate/Consolidate to Oracle 19c”.

Agenda :
📌 10:00am - Introduction
📌 Release Strategy
📌 Database Upgrade with AutoUpgrade
📌 5-minute break
📌 Ensure Performance Stability
📌 Move to Oracle Multitenant
📌 12:00pm - Conclusion

✅ Register here : https://lnkd.in/dxY6E-h

#oracle #19c #database

Modernización de Oracle Froms a Oracle APEX - APEX en español Offie Hours

En el próximo APEX En Español, Mónica Godoy invitará a expertos en proyectos de modernización y hablará sobre los retos, mejores prácticas y herramientas propias que han desarrollado para agilizar la modernización. 

Suscríbete: bit.ly/APEXenEspañol 

#oracle #orclapex #LowCode

Podcast: #CitaaCiegas - Año1 - Entrega 4, con Felipe Manríquez, Chile

 

Podcast: #CitaaCiegas - Año1 - Entrega 3, con Francisco Muñoz, Australia

 

Podcast: #CitaaCiegas - Año1 - Entrega 2, con Sebastián D'Alessandro de Argentina

 

Próximo 05 de octubre arracamos este nuevo proyecto: Podcast "CitaaCiegas"

 

Charlas Gratuitas del 22 al 25 de setiembre FB Live, NIC CR

NIC CR

Todos los eventos son en hora de Costa Rica (UTC-6) y se transmitirán a través de Facebook Live en la página de NIC Costa Rica (

https://www.facebook.com/NICCostaRica/

)

Miércoles 23 de setiembre

9:30 am a 11:30 am IV Edición del Diálogo de Gobernanza de Internet: ¿Cómo aportar al fortalecimiento de la Gobernanza de internet en época de pandemia?

-Miguel Ignacio Estrada, Gerente General LACTLD

-Christian O´ Flaherty, Vicepresidente Regional para América Latina

y el Caribe ISOC.

-Lía Hernández, Directora Ejecutiva IPANDETEC

2:30 pm a 4:30 pm SD-WAN: ¿Qué es y qué necesito para implementar esta tecnología?

-Jeffrey Handal, Ingeniero Consultor de Sistemas Cisco

Moderador: Daniel Mongrágon, NIC Costa Rica.

Jueves 24 de Setiembre

9:30 am a 11:30 am - La ciberseguridad en época de pandemia

-Roberto Lamaitre, coordinador CSIRT-CR

-Erick Lewis, Jefe Sección de Delitos Informáticos OIJ

- Moderador: Sergio Tenorio, NIC Costa Rica

2:30 pm a 4:30 pm - ¿Por qué implementar DNSSEC?

-Guillermo Cicileo, Responsable de Programa de Seguridad y Estabilidad de Internet LACNIC

-Amenazas técnicas y de mitigación en temas de abusos de DNS

Carlos Álvarez, Gerente Sénior, Security Engagement ICANN

José Urzúa, Gerente de Desarrollo de Sistemas NIC Chile

Moderador: Sergio Tenorio, NIC Costa Rica.

Viernes 25 de setiembre

9:30 am a 11:30 am Ceremonia de Clausura 30 Aniversario NIC Costa Rica.

Oscar Robles, Director Ejecutivo LACNIC

Rodrigo de la Parra, Vicepresidente para América Latina y Caribe ICANN.

Steven Huter, Director for the Network Startup Resource Center NSRC

Guy de Téramond, NIC Costa Rica.

Oracle Cloud- Como solucionar el "Sudo" a la cuenta root, devuelve mensaje "This account is currently not available"

Problema:

[opc@webimp01-wls-0 ~]$ sudo su - root
Last login: Tue Sep 22 16:00:54 GMT 2020 on pts/3

This account is currently not available.

Esto se resuelve con lo siguiente:

[opc@webimp01-wls-0 ~]$
[opc@webimp01-wls-0 ~]$ sudo -s /bin/bash

[root@webimp01-wls-0 opc]# id

uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

Fuente: 

Sudo Error: "This account is currently not available." (Doc ID 2696102.1)

---

Modified: Aug 4, 2020

Podcast #385: Avi Miller on Linux, Open Source, Legos, and Development in 2020

 If you've never heard Oracle's Avi Miller riff around on Linux and Open Source you're going to really enjoy this podcast. Avi is passionate about Open Source and his energy flows through quite clearly. I've interviewed Avi on two previous occasions (Singapore, San Francisco), and I think I'm just going to make this exercise a habit. It's fun. And I learn. I learn a lot about Oracle's growing number of Open Source projects, how many engineers at Oracle are actively engaged in upstream projects, and interesting new ways people are contributing to projects. 

Listen to the podcast on Podbean.

 Photo: Jim Grisanzio (left) and Avi Miller (right) at Oracle Open World in Singapore. March 2019. The image at top is from Code One in San Francisco in September 2019.

In the conversation, which was recorded on September 8th, 2020, Avi touches on a variety of projects including Oracle Linux, GraalVM, Java, Virtual Box, Oracle Cloud, file systems, kernel scheduling, and more. Avi contributes to the team that manages Oracle's GitHub program, which now has more than 1,500 engineers working on 300 source repositories. Regarding Oracle's contributions to the Linux community, Avi points out that Oracle's involvement goes way back to the original work to get Oracle Database on Linux. That early kernel work later led to Oracle's Linux distribution. In fact, today, Oracle now has two Linux teams -- one involved in mainline Linux development, and the other to productize and sustain Oracle's Linux distribution. And that history in Open Source development continues right up through today.

There are many Open Source projects emerging at Oracle, and there are many ways for developers and community members generally to contribute. Avi offers many such suggestions. Oh, also, Avi is an avid Lego builder, which fits well with his development mindset.

You can find Avi Miller on Twitter and LinkedIn. He's based in Melbourne, Australia. He's a Senior Manager for Oracle Linux and VM Product Management. 

Ver artículo...

Oracle habilita la opción de alta disponibilidad en 19c RAC en SE2

 

ACLARACION: Nota 25 de setiembre de 2020, 8:35AM

**********************************************************************************

Markus Michalewicz
DIRECTOR SÉNIOR DE GESTIÓN DE PRODUCTOS

Markus Michalewicz ha trabajado en Oracle durante casi 20 años en varios puestos. Actualmente es director senior de Oracle America y gestiona el equipo de gestión de productos (PM) de alta disponibilidad (HA), escalabilidad, arquitectura de máxima disponibilidad (MAA) y migración a la nube de Oracle Database, que forma parte del desarrollo de Oracle Database.

So, the short answer to your question (“exist or no any RAC in 19c for Standard edition?“) is: “NO.”

"Hemos tenido varias consultas, porque por un lado teníamos que el RAC volvía a estar disponible en 19c en 19.7, pero al final de cuentas NO."

Como trabaja 19c HA 19.7?

Es una configuración de cluster "ACTIVO/PASIVO". No es una solución ACTIVA/ACTIVA.

Gracias a José Ordoñez de Oracle, quién "toco la puerta", sobre el tema.

Ahora tenemos un tema comercial: Es necesario licenciar ambos nodos ...?

Se esta haciendo la pregunta a la parte comercial, para tener una respuesta.

  

**********************************************************************************

Ya en el mes de marzo de este año, Markus Michalewicz, Director Senior de Gestión de Productos había adelantado en un artículo que Oracle tenía planeado incluir una opción de alta disponibilidad, para la versión de base de datos 19c en la edición Standard Edition.

Eso si, Markus nos recordaba, que la versión SE2, tiene algunas limitantes importantes, con respecto a la totalidad de hilos de procesamiento que se pueden utilizar. Esta limitación expresa, que sólo es posible utilizar hasta 16 hilos de procesador, por cada instacia de base de datos.

En el caso de la solución de HA de base de datos edición estandar, - RAC -, esto quiere decir, que cada nodo puede llegar a tener un máximo 8 hilos por instancia, ya que el número de nodos esta limitado desde hace muchos años, a 2 por configuración en SE2.

Pasaba los meses y no sabíamos nada de la promesa informal realizada.

Y es que ha estado bastante callado el tema. Sin embargo, en las últimas semanas, hemos tenido noticias excelentes en torno a la edición estandar de base de datos.

Hagamos un listado de las más relevantes:

1. Hasta 3 instancias PDB en arquitectura Multi-Tenant, sin requerir licenciamiento.
2. Oracle Spatial and Graph
3. Oracle Machine Learning
4. RAC

Si la última en rojo. A pesar que aún no se visualiza en la información de licenciaimiento de opcionales disponibles para SE2, la documentación ya lo menciona.

En este link, podrán validar que a partir del Release Update 19.7, Patch 30869156: DATABASE RELEASE UPDATE 19.7.0.0.0, que tiene como prerequisito mínimo 19c RU 3 19.3, es posible contar ya con RAC en SE2, con las limitantes antes indicadas.

Así que ya es oficial, aunque la cantidad de hilos de procesamiento, puede ser una limitante importante.

Otro tema relevante, desprendido del análisis de la documentación, Multitenant en RAC para SE2 no esta disponible. Sólo es posible tener RAC en una instancia simple.

Que más podemos esperar.?

Bueno a finales del mes de julio, Mike Dietrichde, publicó un artículo en donde nos hablaba del nuevo concepto BASE_LEVEL a partir de 19.8 y disponible de facto en la versión 20c.

En el nos habla, que ahora en versión E.E. es posible tener IN-MEMORY Database, sin costo alguno, hasta la cantidad de 16GB en un Contenedor de Base de Datos CDB.

Que podríamos esperar, pues como soñar no cuesta nada; que la versión 20c SE2, contenga al menos 4GB de IN-MEMORY Database. Esto aportaría mucho al rendimiento, con las características sumadas de ML y Spatial.

Esperemos a ver, si se nos cristaliza el deseo.

Oracle Magazine cumplirá pronto 34 años, pero cuál fué el contenido del primer número?

En 1987, un boletín se convirtió en una revista. La revista Oracle , Volumen 1, Número 1, fue publicada y distribuida a los suscriptores del boletín que reemplazó. Sin embargo, ese primer número seguía siendo un boletín en el fondo; eran 12 páginas impresas, incluidas las portadas y contraportadas, en blanco y negro (y varios tonos de verde). Y no hubo anuncios.

Lo que sucedió después fue aún más dramático: el segundo número de la revista Oracle. Oracle Magazine , Volumen 1, Número 2, también podría haberse llamado Oracle Magazine 2.0 .

El primer número de la revista Oracle había informado la noticia del lanzamiento de ORACLE RDBMS 5.1, pero el segundo número no tenía una primicia similar. Lo que sí tuvo el segundo número fue 48 páginas impresas. Hubo noticias. Hubo historias sobre clientes de Oracle. Hubo historias sobre los socios de Oracle. Había información sobre cómo usar la tecnología Oracle. Hubo anuncios. Hubo distribución a nuevos lectores y posibles suscriptores. Y había tarjetas de suscripción, para ayudar a convertir oficialmente a los lectores en suscriptores.

A partir de ese segundo número, la comunidad de contribuyentes de Oracle Magazine, clientes de Oracle, socios, expertos en la materia y suscriptores estaba en su lugar, y ha permanecido durante 34 años,

Fuente: Por Tom Haunert, edición diciembre 2011 ( Versión Actualizada )

Instalando SQL Server 2019 en Ubuntu 18.04.4 LTS

Sigue los siguientes pasos para instalar Microsoft SQL Server en un servidor de Ubuntu Linux. Es realmente sencillo.

1. Conectarse al servidor Ubuntu con el usuario que tengas configurado.

login as: capacitacion

capacitacion@192.168.0.15's password:

Welcome to Ubuntu 18.04.4 LTS (GNU/Linux 5.3.0-28-generic x86_64)

 * Documentation:  https://help.ubuntu.com

 * Management:     https://landscape.canonical.com

 * Support:        https://ubuntu.com/advantage

 * Canonical Livepatch is available for installation.

   - Reduce system reboots and improve kernel security. Activate at:

     https://ubuntu.com/livepatch

222 packages can be updated.

163 updates are security updates.

Your Hardware Enablement Stack (HWE) is supported until April 2023.

The programs included with the Ubuntu system are free software;

the exact distribution terms for each program are described in the

individual files in /usr/share/doc/*/copyright.

Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by

applicable law.

2. Ejecutar el siguiente comando

root@capacitacion-VirtualBox:~# wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

OK

3. Actualizar el repositorio con los paquetes de la última versión de SQL SERVER disponible

root@capacitacion-VirtualBox:~# sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"

Hit:1 http://cr.archive.ubuntu.com/ubuntu bionic InRelease

Hit:2 http://cr.archive.ubuntu.com/ubuntu bionic-updates InRelease

Hit:3 http://cr.archive.ubuntu.com/ubuntu bionic-backports InRelease

Hit:4 http://security.ubuntu.com/ubuntu bionic-security InRelease

Get:5 https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 bionic InRelease [10,5 kB]

Get:6 https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 bionic/main amd64 Packages [6?808 B]

Get:7 https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 bionic/main armhf Packages [1?521 B]

Get:8 https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 bionic/main arm64 Packages [1?521 B]

Fetched 20,3 kB in 1s (19,5 kB/s)

Reading package lists... Done

root@capacitacion-VirtualBox:~# apt-get updte

E: Invalid operation updte

root@capacitacion-VirtualBox:~# apt-get update

Hit:1 http://cr.archive.ubuntu.com/ubuntu bionic InRelease

Hit:2 http://cr.archive.ubuntu.com/ubuntu bionic-updates InRelease

Hit:3 http://cr.archive.ubuntu.com/ubuntu bionic-backports InRelease

Hit:4 https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 bionic InRelease

Hit:5 http://security.ubuntu.com/ubuntu bionic-security InRelease

Reading package lists... Done

4. Instalar la paquetería de SQL SERVER

root@capacitacion-VirtualBox:~# apt-get install -y mssql-server

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following additional packages will be installed:

  gawk libc++1 libc++abi1 libpython-stdlib libpython2.7 libpython2.7-minimal libpython2.7-stdlib libsasl2-modules-gssapi-mit libsigsegv2

  libsss-nss-idmap0 python python-minimal python2.7 python2.7-minimal

Suggested packages:

  gawk-doc clang python-doc python-tk python2.7-doc binfmt-support

The following NEW packages will be installed:

  gawk libc++1 libc++abi1 libpython-stdlib libsasl2-modules-gssapi-mit libsigsegv2 libsss-nss-idmap0 mssql-server python python-minimal python2.7

  python2.7-minimal

The following packages will be upgraded:

  libpython2.7 libpython2.7-minimal libpython2.7-stdlib

3 upgraded, 12 newly installed, 0 to remove and 214 not upgraded.

Need to get 232 MB of archives.

After this operation, 1?077 MB of additional disk space will be used.

Get:1 http://cr.archive.ubuntu.com/ubuntu bionic/main amd64 libsigsegv2 amd64 2.12-1 [14,7 kB]

Get:2 http://cr.archive.ubuntu.com/ubuntu bionic/main amd64 gawk amd64 1:4.1.4+dfsg-1build1 [401 kB]

Get:3 https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 bionic/main amd64 mssql-server amd64 15.0.4033.1-2 [227 MB]

Get:4 http://cr.archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython2.7 amd64 2.7.17-1~18.04ubuntu1 [1?053 kB]

Get:5 http://cr.archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython2.7-stdlib amd64 2.7.17-1~18.04ubuntu1 [1?915 kB]

Get:6 http://cr.archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython2.7-minimal amd64 2.7.17-1~18.04ubuntu1 [335 kB]

Get:7 http://cr.archive.ubuntu.com/ubuntu bionic-updates/main amd64 python2.7-minimal amd64 2.7.17-1~18.04ubuntu1 [1?294 kB]

Get:8 http://cr.archive.ubuntu.com/ubuntu bionic/main amd64 python-minimal amd64 2.7.15~rc1-1 [28,1 kB]

Get:9 http://cr.archive.ubuntu.com/ubuntu bionic-updates/main amd64 python2.7 amd64 2.7.17-1~18.04ubuntu1 [248 kB]

Get:10 http://cr.archive.ubuntu.com/ubuntu bionic/main amd64 libpython-stdlib amd64 2.7.15~rc1-1 [7?620 B]

Get:11 http://cr.archive.ubuntu.com/ubuntu bionic/main amd64 python amd64 2.7.15~rc1-1 [140 kB]

Get:12 http://cr.archive.ubuntu.com/ubuntu bionic-updates/main amd64 libsasl2-modules-gssapi-mit amd64 2.1.27~101-g0780600+dfsg-3ubuntu2.1 [35,5 kB]

Get:13 http://cr.archive.ubuntu.com/ubuntu bionic/universe amd64 libc++abi1 amd64 6.0-2 [56,7 kB]

Get:14 http://cr.archive.ubuntu.com/ubuntu bionic/universe amd64 libc++1 amd64 6.0-2 [183 kB]

Get:15 http://cr.archive.ubuntu.com/ubuntu bionic-updates/main amd64 libsss-nss-idmap0 amd64 1.16.1-1ubuntu1.6 [20,1 kB]

Fetched 232 MB in 23s (10,1 MB/s)

Preconfiguring packages ...

Selecting previously unselected package libsigsegv2:amd64.

(Reading database ... 129918 files and directories currently installed.)

Preparing to unpack .../libsigsegv2_2.12-1_amd64.deb ...

Unpacking libsigsegv2:amd64 (2.12-1) ...

Setting up libsigsegv2:amd64 (2.12-1) ...

Selecting previously unselected package gawk.

(Reading database ... 129925 files and directories currently installed.)

Preparing to unpack .../0-gawk_1%3a4.1.4+dfsg-1build1_amd64.deb ...

Unpacking gawk (1:4.1.4+dfsg-1build1) ...

Preparing to unpack .../1-libpython2.7_2.7.17-1~18.04ubuntu1_amd64.deb ...

Unpacking libpython2.7:amd64 (2.7.17-1~18.04ubuntu1) over (2.7.17-1~18.04) ...

Preparing to unpack .../2-libpython2.7-stdlib_2.7.17-1~18.04ubuntu1_amd64.deb ...

Unpacking libpython2.7-stdlib:amd64 (2.7.17-1~18.04ubuntu1) over (2.7.17-1~18.04) ...

Preparing to unpack .../3-libpython2.7-minimal_2.7.17-1~18.04ubuntu1_amd64.deb ...

Unpacking libpython2.7-minimal:amd64 (2.7.17-1~18.04ubuntu1) over (2.7.17-1~18.04) ...

Selecting previously unselected package python2.7-minimal.

Preparing to unpack .../4-python2.7-minimal_2.7.17-1~18.04ubuntu1_amd64.deb ...

Unpacking python2.7-minimal (2.7.17-1~18.04ubuntu1) ...

Selecting previously unselected package python-minimal.

Preparing to unpack .../5-python-minimal_2.7.15~rc1-1_amd64.deb ...

Unpacking python-minimal (2.7.15~rc1-1) ...

Selecting previously unselected package python2.7.

Preparing to unpack .../6-python2.7_2.7.17-1~18.04ubuntu1_amd64.deb ...

Unpacking python2.7 (2.7.17-1~18.04ubuntu1) ...

Selecting previously unselected package libpython-stdlib:amd64.

Preparing to unpack .../7-libpython-stdlib_2.7.15~rc1-1_amd64.deb ...

Unpacking libpython-stdlib:amd64 (2.7.15~rc1-1) ...

Setting up libpython2.7-minimal:amd64 (2.7.17-1~18.04ubuntu1) ...

Setting up python2.7-minimal (2.7.17-1~18.04ubuntu1) ...

Linking and byte-compiling packages for runtime python2.7...

Setting up python-minimal (2.7.15~rc1-1) ...

Selecting previously unselected package python.

(Reading database ... 130129 files and directories currently installed.)

Preparing to unpack .../0-python_2.7.15~rc1-1_amd64.deb ...

Unpacking python (2.7.15~rc1-1) ...

Selecting previously unselected package libsasl2-modules-gssapi-mit:amd64.

Preparing to unpack .../1-libsasl2-modules-gssapi-mit_2.1.27~101-g0780600+dfsg-3ubuntu2.1_amd64.deb ...

Unpacking libsasl2-modules-gssapi-mit:amd64 (2.1.27~101-g0780600+dfsg-3ubuntu2.1) ...

Selecting previously unselected package libc++abi1:amd64.

Preparing to unpack .../2-libc++abi1_6.0-2_amd64.deb ...

Unpacking libc++abi1:amd64 (6.0-2) ...

Selecting previously unselected package libc++1:amd64.

Preparing to unpack .../3-libc++1_6.0-2_amd64.deb ...

Unpacking libc++1:amd64 (6.0-2) ...

Selecting previously unselected package libsss-nss-idmap0.

Preparing to unpack .../4-libsss-nss-idmap0_1.16.1-1ubuntu1.6_amd64.deb ...

Unpacking libsss-nss-idmap0 (1.16.1-1ubuntu1.6) ...

Selecting previously unselected package mssql-server.

Preparing to unpack .../5-mssql-server_15.0.4033.1-2_amd64.deb ...

Unpacking mssql-server (15.0.4033.1-2) ...

Setting up libc++abi1:amd64 (6.0-2) ...

Setting up libsss-nss-idmap0 (1.16.1-1ubuntu1.6) ...

Setting up gawk (1:4.1.4+dfsg-1build1) ...

Setting up libsasl2-modules-gssapi-mit:amd64 (2.1.27~101-g0780600+dfsg-3ubuntu2.1) ...

Setting up libpython2.7-stdlib:amd64 (2.7.17-1~18.04ubuntu1) ...

Setting up libc++1:amd64 (6.0-2) ...

Setting up python2.7 (2.7.17-1~18.04ubuntu1) ...

Setting up libpython-stdlib:amd64 (2.7.15~rc1-1) ...

Setting up libpython2.7:amd64 (2.7.17-1~18.04ubuntu1) ...

Setting up python (2.7.15~rc1-1) ...

Setting up mssql-server (15.0.4033.1-2) ...

+--------------------------------------------------------------+

Please run 'sudo /opt/mssql/bin/mssql-conf setup'

to complete the setup of Microsoft SQL Server

+--------------------------------------------------------------+

Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ...

Processing triggers for mime-support (3.60ubuntu1) ...

Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ...

Processing triggers for libc-bin (2.27-3ubuntu1) ...

Processing triggers for man-db (2.8.3-2ubuntu0.1) ...

5. Configuración versión del SQL SERVER, habilitación del servicio y definición password para usuario SA.

root@capacitacion-VirtualBox:~# /opt/mssql/bin/mssql-conf setup

usermod: no changes

Choose an edition of SQL Server:

  1) Evaluation (free, no production use rights, 180-day limit)

  2) Developer (free, no production use rights)

  3) Express (free)

  4) Web (PAID)

  5) Standard (PAID)

  6) Enterprise (PAID) - CPU Core utilization restricted to 20 physical/40 hyperthreaded

  7) Enterprise Core (PAID) - CPU Core utilization up to Operating System Maximum

  8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at

https://go.microsoft.com/fwlink/?LinkId=2109348&clcid=0x409

Use of PAID editions of this software requires separate licensing through a

Microsoft Volume Licensing program.

By choosing a PAID edition, you are verifying that you have the appropriate

number of licenses in place to install and run this software.

Enter your edition(1-8): 3

The license terms for this product can be found in

/usr/share/doc/mssql-server or downloaded from:

https://go.microsoft.com/fwlink/?LinkId=2104294&clcid=0x409

The privacy statement can be viewed at:

https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Do you accept the license terms? [Yes/No]:yes

Enter the SQL Server system administrator password:

Confirm the SQL Server system administrator password:

Configuring SQL Server...

The licensing PID was successfully processed. The new edition is [Express Edition].

ForceFlush is enabled for this instance.

ForceFlush feature is enabled for log durability.

Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service ? /lib/systemd/system/mssql-server.service.

Setup has completed successfully. SQL Server is now starting.

6. Validar que el servicio este corriendo

root@capacitacion-VirtualBox:~# systemctl status mssql-server --no-pager

? mssql-server.service - Microsoft SQL Server Database Engine

   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)

   Active: active (running) since Fri 2020-06-12 09:26:06 CST; 47s ago

     Docs: https://docs.microsoft.com/en-us/sql/linux

 Main PID: 6082 (sqlservr)

    Tasks: 119

   CGroup: /system.slice/mssql-server.service

           +-6082 /opt/mssql/bin/sqlservr

           +-6104 /opt/mssql/bin/sqlservr

jun 12 09:26:10 capacitacion-VirtualBox sqlservr[6082]: [318B blob data]

jun 12 09:26:10 capacitacion-VirtualBox sqlservr[6082]: [78B blob data]

jun 12 09:26:10 capacitacion-VirtualBox sqlservr[6082]: [84B blob data]

jun 12 09:26:10 capacitacion-VirtualBox sqlservr[6082]: [145B blob data]

jun 12 09:26:11 capacitacion-VirtualBox sqlservr[6082]: [96B blob data]

jun 12 09:26:11 capacitacion-VirtualBox sqlservr[6082]: [66B blob data]

jun 12 09:26:11 capacitacion-VirtualBox sqlservr[6082]: [96B blob data]

jun 12 09:26:11 capacitacion-VirtualBox sqlservr[6082]: [100B blob data]

jun 12 09:26:11 capacitacion-VirtualBox sqlservr[6082]: [71B blob data]

jun 12 09:26:11 capacitacion-VirtualBox sqlservr[6082]: [124B blob data]

Ahora puedes instalar el Microsoft SQL Management Studio 18 en tu ambiente de sistema operativo Windows y logear en la dirección del servidor con la autenticación de servidor.

La lógica de negocio, en la aplicación o en el lado de los datos.?

A ver, que opinan ustedes.?

¿A dónde pertenece la lógica para mostrar un montón de números en un gráfico circular?

En la aplicación.

¿Dónde está la lógica para asegurar que si "X" = 0, entonces "Y" debe ser >= 0?

Eso pertenece justo al lado de los datos.

Tom Kyte - ASKTOM- escribió hace unos años atrás:

"Piense en esto: el año es 1996, las aplicaciones web son completamente nuevas, nunca antes existieron. Completamente nueva forma de abordar las cosas. La gente quería acceso web a sus datos.

Lástima que las aplicaciones heredadas se escribieran como transacciones CICS en un mainframe, con un panel frontal de pantalla verde ISPF.

OBSERVACIÓN: nunca deja de divertirme cuán muertas son las transacciones CICS similares a las aplicaciones de nivel medio y cuán similar es el panel de pantalla verde ISPF a un navegador web. Están casi muertos en el mismo

Entonces, cuando intentaron moverse a la web, fue realmente muy difícil,

¿por qué? Debido a que la lógica de los datos, las reglas de integridad de los datos, la seguridad, todo, estaba vinculado a las transacciones CICS (escritas principalmente en Cobol, por ejemplo) y la construcción de una aplicación que accedía a los datos directamente estaba PROHIBIDA, por la sencilla razón de que no podía hacerlo con seguridad.

Oracle Autonomous Database Now Available in Customer Datacenters

Press Release

Addresses data sovereignty, security, and performance concerns that prevent some enterprise workloads from moving to the public cloud

Crédit Agricole, Entel, and Samsung SDS welcome Autonomous Database on Exadata Cloud@Customer

Redwood Shores, Calif.—Jul 8, 2020

Building on the success of Oracle’s Exadata Cloud@Customer service over the last three years, Oracle announced the availability of Oracle Autonomous Database on Exadata Cloud@Customer. This new offering combines the latest Oracle Database with the fastest Oracle Database platform—Exadata—delivered as a cloud service in customer datacenters. It eliminates database management and capital expend

itures while enabling pay-per-use and elastic consumption of database cloud resources. Now, Autonomous Database is available to run in customer data centers both as a standalone offering and as part of Oracle Dedicated Region Cloud@Customer, the industry’s first on-premises cloud region, which was also announced today. Get started here.

Oracle Autonomous Database on Exadata Cloud@Customer is the simplest and fastest transition to a cloud model with typical deployments taking less than a week. Existing applications in a datacenter can simply connect and run without requiring any application changes—while data never leaves the customer’s datacenter. This is ideal for enterprises that find it challenging to move their mission-critical database workloads to the public cloud due to data sovereignty and regulatory requirements, security and performance concerns, or because their on-premises applications and databases are tightly coupled. 

“Exadata Cloud@Customer has been successfully deployed at hundreds of customers, including large financial services companies, telecoms, healthcare providers, insurers, and pharmaceutical companies worldwide to modernize their infrastructure and lower costs by up to 50 percent,” said Juan Loaiza, executive vice president, mission-critical database technologies, Oracle. “We are now bringing Oracle Autonomous 

Database to customer datacenters—freeing DBAs and developers from mundane maintenance tasks and enabling them to innovate and create more business value.”

Oracle Autonomous Database on Exadata Cloud@Customer enables organizations to move to an environment where everything is automated and managed by Oracle. Autonomous operations include: database provisioning, tuning, clustering, disaster protection, elastic scaling, securing and patching, which eliminates manual processes and human error while reducing costs and increasing performance, security and availability. The serverless architecture automatically scales to match changing workloads, providing true pay-per-use.

“Oracle Autonomous Database on Exadata Cloud@Customer combines the game changing capabilities of the revolutionary Exadata X8M platform with Oracle’s most advanced machine-learning-powered database and its second-generation cloud control plane for a true enterprise-grade database cloud experience on-premises,” said Carl Olofson, Research Vice President, Data Management Software, IDC. “Ev

ery business has a set of ISV and home grown applications that they depend on to run all aspects of their business from finance to manufacturing, HR, orders, procurement, and operations. For companies serious about running these types of critical Oracle-based applications in an on-premises enterprise database cloud, Oracle Autonomous Database on Exadata Cloud@Customer is currently the most advanced offering in the market today.”

Customers can leverage Oracle Autonomous Database on Exadata Cloud@Customer to consolidate thousands of databases and run the converged, open Oracle Database for multiple data types and workloads including Machine Learning, JSON, Graph, spatial, IOT and In-Memory, instead of deploying fragmented special-purpose databases. With Oracle Autonomous Database on Oracle Exadata Cloud@Customer, organizations can work with up to 7x larger databases, achieve greater database consolidation, and improve performance with up to 12x more SQL IOPS, 10x more SQL throughput, and 98 percent lower SQL latency than RDS on AWS Outposts. Oracle Autonomous Database on Exadata Cloud@Customer reduces customers’ infrastructure and database management by up to 90 percent because they only h

ave to focus on the schemas and data inside their databases, not on running the underlying database infrastructure.

In addition to the new Cloud@Customer offerings, Oracle continues to enhance the capabilities of the Autonomous Database. Oracle today announced the certification of Oracle’s Siebel, PeopleSoft, and JD Edwards running on Oracle Autonomous Database. By using Autonomous Database, Oracle’s Siebel, PeopleSoft, and JD Edwards customers will lower their costs while improving security, performance, and availability. The company also announced Oracle Autonomous Data Guard which delivers an autonomously managed high availability and disaster recovery solution protecting against database and site failures. Oracle Autonomous Data Guard provides near zero data loss (RPO) and recovery time (RTO) objectives in the face of catastrophic failures.

Global Organizations Welcome New Cloud@Customer Offerings

Samsung SDS is the largest enterprise cloud solutions provider in Korea, delivering data-driven digital innovations to customers in 41 countries worldwide. “Back in 2010, we adopted the first Exadata platform to improve a display manufacturing system,” said Dr. WP Hong, CEO, Samsung SDS. “Now 10 years later, we have implemented nearly 300 Exadata systems for our customers in manufacturing, financial services, construct

ion and engineering, and public and private sector services. Aligning with our digital innovation strategy and our journey to enterprise cloud, we have now adopted the first Exadata Cloud@Customer in one of our datacenters and look forward to deploying Autonomous Database.”

NTT DoCoMo is the number one mobile carrier in Japan with the largest customer base. “Oracle Exadata is implemented as our core engine to process the call, communication, and billing information of 80M users in real-time,”

 said Taku Hasegawa, Senior Vice President, General Manager of Information Systems Department, NTT DoCoMo. “Thanks to Exadata, we could cut operation and maintenance costs in half, while realizing 10x performance. As the core infrastructure for DoCoMo’s digital transformation and further business growth, I look forward to the continuous evolution of Oracle Exadata and the novel technology innovation driven by Autonomous Database on Exadata Cloud@Customer.”

Crédit Agricole CIB is the Corporate and Investment Banking arm of the Crédit Agricole Group, one of the world’s largest banks. “Moving to Exadata Cloud@Customer has significantly improved our accounting information systems performance, which has enabled us to carry out our accounting closing process with much greater agility and to reduce our operational costs,” said Pierre-Yves Bollard, Global Head of Finance IT, Crédit Agricole Corporate & Investment Bank. “The high value provided by the Exadata Cloud@Customer infrastructure has been recognized by all IT and business teams.”

Entel is the largest te

lecom provider in Chile and the third largest in Peru. “We have used Exadata systems for the past five years to support many applications across dozens of lines of business, including crucial billing and network management systems,” said Helder Branco, Head of IT Operations, Entel. “By using Exadata, we improved mission-critical Oracle Database performance by up to 3x, and reduced our security exposure. We are taking our digital transformations to the next level by moving over 30 databases to Oracle Autonomous Database on Exadata Cloud@Customer and improving their security with its self-securing capabilities.”

RKK Computer Service is an IT consultancy based in Japan, focusing on local governments and financial institutions. “RKK Computer Service selected Oracle Exadata Cloud@Customer to host our shared platform that runs core business systems for 100 municipalities,” said Chihiro Sato, Deputy General Manager, Public Sector Planning and Development Division, RKK Computer Service. “Compared to our previous on-premises solution, we have 24 percent cost savings and more than 70 percent IO performance improvement, which enables us to run concurrent batch processes for multiple municipalities. High availability is achieved with RAC and Data Guard. We believe that Oracle’s second-generation Exadata Cloud@Customer is a promising cloud platform for municipalities. RKKCS will continuously enhance our cloud infrastructure for municipalities by exploring Autonomous Database on Exadata Cloud@Customer to improve operational efficiency.”

The State of Queretaro is located 

in central Mexico. “Based on a directive from the state governor and state secretary to address the COVID-19 crisis, we were asked to develop an application that would allow the citizens and patients of the State of Querétaro, Mexico, to carry out a self-diagnosis to help avoid the spread of infections,” said Pedro Gonzalez, Director CIAS, Queretaro State Government, Mexico. “With Oracle Database on Exadata Cloud@Customer, we were able to react quickly and develop a mobile application in less than three weeks — plus we were able to adhere to state regulations to maintain the sensitive data of citizens and patients in our facilities. We look forward to investing in Oracle Autonomous Database this year, which will free up our staff and resources to focus on developing new business applications without spending any time on patching, tuning, and maintaining the database.” 

Siav is an enterprise content management software and IT services company based in Italy. “We chose Oracle Exadata Cloud@Customer to help us manage the constant growth of our business in cloud services and solutions,” said Nicola Voltan, CEO, Siav S.p.A. “Exadata Cloud@Customer provides the performance, scalability and security we need to offer the highest quality service to our customers. It’s managed by Oracle in our datacenter, enabling us to comply with the Italian legislation related to the geographical location of the service provided.”

New Exadata Cloud@Customer Enhancements

In addition to the Autonomous Database, Oracle is announcing the following Exadata Cloud@Customer enhancements:

• Oracle Exadata Database Machine X8M Technology, which combines Intel® Optane™ DC Persistent Memory and 100 gigabit remote direct memory access (RDMA) over Converged Ethernet (RoCE) to remove storage bottlenecks and dramatically increase performance for the most demanding workloads such as Online Transaction Processing (OLTP), IoT, fraud detection, and high frequency trading. Direct database access to shared persistent memory increases peak performance to 12 million SQL read IOPS, 2.5X greater than the prior generation offering powered by Exadata Database Machine X8. Additionally, Exadata X8M dramatically reduces the latency of critical database IOs by enabling remote IO latencies below 19 microseconds—more than 10X faster than the prior generation offering. These ultra-low latencies are achieved even for workloads requiring millions of IOs per second.
• Multiple VM Clusters per Exadata Rack, which enables organizations to share an Exadata system for production, DR and dev/test and provide isolation across departments and use cases.
• PCI-DSS Certification: Exadata Cloud@Customer now supports and meets Payment Card Industry Data Security Standard requirements and can be implemented as part of a highly secure financial processing environment.

Additional Resources

Learn more about Oracle Autonomous Database on Exadata Cloud@Customer

See what customers and industry analysts are saying

Learn more about Exadata Cloud@Customer

Learn more about Cloud@Customer

Contact Info

Nicole Maloney

Oracle PR

+1.650.506.0806

nicole.maloney@oracle.com