tag:blogger.com,1999:blog-54236177890658425642024-03-19T06:04:33.648+01:00su evaristo - -BlogEstudiante de 2º ASIR - Administración de Sistemas Informáticos en Red en IES Fernando Aguilar Quignon - CádizEvaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5423617789065842564.post-20079880224678104802019-06-28T06:10:00.001+02:002019-06-28T06:14:14.270+02:00Proyecto Integrado ASIR - Monitorización de red y análisis de logs en tiempo real<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij1GN8jtyX3gf6u6Bw3pf-v8gZJo478kWcSyd69mqHlkK2S61bglYmwowJ9cvSrNeeTzbQVpKEZtXT1pSktJjLn8JN5010xj9bzk8QLHYEtUD5sNyBBRmDuVi3s_1-AZqc1Fx9hUDfQLI_/s1600/Arquitectura+IES_F_A_Q_ELK+%25281%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="771" data-original-width="1175" height="419" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij1GN8jtyX3gf6u6Bw3pf-v8gZJo478kWcSyd69mqHlkK2S61bglYmwowJ9cvSrNeeTzbQVpKEZtXT1pSktJjLn8JN5010xj9bzk8QLHYEtUD5sNyBBRmDuVi3s_1-AZqc1Fx9hUDfQLI_/s640/Arquitectura+IES_F_A_Q_ELK+%25281%2529.png" width="640" /></a></div>
</div>
<div style="text-align: justify;">
Hace una semana que entregué y defendí mi proyecto integrado de ASIR, y con ésto, daba por finalizada una etapa, una que comenzó hace menos de dos años, con muchísima ilusión y que termina ahora con la satisfacción de haber cumplido todos los objetivos.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Dicho proyecto se titula "Implantación de un sistema de monitorización de red y análisis de logs</div>
<div style="text-align: justify;">
en tiempo real para el departamento de informática del <a href="http://iesfernandoaguilar.es/" target="_blank">IES Fernando Aguilar Quignon</a>", y es el resultado de tres meses de investigación compaginadas con las prácticas en empresa, concretamente en <a href="https://www.atsistemas.com/" target="_blank">atSistemas</a>, donde tuve la gran suerte de aterrizar, y desde donde ayer comenzaba una nueva etapa laboral. No puedo estar más contento y agradecido.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Esta entrada en realidad es la excusa para compartir mi trabajo, por lo que a continuación encontrarás los enlaces que espero, resulten de tú interés:</div>
<div style="text-align: justify;">
<br /></div>
<table bgcolor="#f4e3bc" border="1" cellpadding="5" style="text-align: justify; width: 100%;">
<tbody>
<tr><td><div class="separator" style="clear: both; text-align: center;">
<a href="https://github.com/evaristorivi/Proyecto_final-ELK-Stack-Opendistro/blob/master/Evaristo_R_Rivieccio_Vega-2ASIR-Proyecto_integrado_v2.pdf" target="_blank"><img border="0" data-original-height="64" data-original-width="64" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsOmos49cNf3ln6-ApajPgd1b1zsvlTEQNIN-_SGdAaCQILERb-l-_2WrnySI7vDMF0JCeFvRsv_Af6xDLZpxdbpJ7zRn_AhfcO1vhCWy65wyhCe40Un40GXamDp-xBP1DZxKTXsleuZwu/s1600/guide+%25282%2529.png" /></a></div>
</td><td style="text-align: center;"><a href="https://github.com/evaristorivi/Proyecto_final-ELK-Stack-Opendistro/blob/master/Evaristo_R_Rivieccio_Vega-2ASIR-Presentacion.pdf" target="_blank"><img border="0" data-original-height="64" data-original-width="64" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzkJL2A9QKW1BBCySpAN3Ess9prk0QrwdzMpY_2nJKgqGKbDKO5REYGY7IPNzpmDlwVI1v9axnM2-esEc2GULdg-gyGsCDC6pqs0TsbV0TFnwe8XgsPVNsLbkC7nAdFZJFB0tcyVLxRUdC/s1600/projector.png" /></a></td><td><div class="separator" style="clear: both; text-align: center;">
<a href="https://github.com/evaristorivi/Proyecto_final-ELK-Stack-Opendistro" target="_blank"><img border="0" data-original-height="64" data-original-width="64" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY2OQvnfUrDE3qjpYllDnynuDZRl-veAyfgLKBRCHg55ce4fpQSgGbhP8RXf0pYEQZyT23AJzDIewpVKzdCZ3CnRVnezEWz3HI_x9YwRnViBxQPMVK1_PI_ZIs2kYCB5KQlKtAYP6b1ctH/s1600/github.png" /></a><span id="goog_864626810"></span><a href="https://www.blogger.com/"></a><span id="goog_864626811"></span></div>
</td></tr>
</tbody>
</table>
<br />
<div>
Agradecimiento especial a todos mis profesores, por estar siempre ahí, por la paciencia y por prepararnos para el mundo real, en especial a Javier García Estévez, tutor y guía del proyecto integrado, que estuvo siempre atento y pendiente de mejorar el resultado final.</div>
Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com0tag:blogger.com,1999:blog-5423617789065842564.post-29774767424749026032019-05-17T20:24:00.002+02:002019-05-17T21:26:16.222+02:00"Monitorizando la monitorización" - CloudWatch - assume-role y plugin Check_MK<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWemB2i0r4KxURjCW14_hq9sjEriXHPXvGlTzQX0sHMKY_FCe1Zv1O2tF_tv1Jlvbu5FxgdY3WTtJgF9waKBvVUsFHHY-WmTqgb9UjlWp9QsRebKtgfokAt5WcMUZ7nuoG9H3VNaGcq0C0/s1600/alarm-list-aws.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="918" data-original-width="1501" height="391" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWemB2i0r4KxURjCW14_hq9sjEriXHPXvGlTzQX0sHMKY_FCe1Zv1O2tF_tv1Jlvbu5FxgdY3WTtJgF9waKBvVUsFHHY-WmTqgb9UjlWp9QsRebKtgfokAt5WcMUZ7nuoG9H3VNaGcq0C0/s640/alarm-list-aws.png" width="640" /></a></div>
<div style="text-align: justify;">
En el post de hoy, veremos como implantar un plugin personalizado en Check_MK, que monitorizará las alertas de CloudWatch, en un <a href="https://docs.aws.amazon.com/es_es/IAM/latest/UserGuide/tutorial_cross-account-with-roles.html" target="_blank">escenario en el que administramos más de una cuenta de AWS</a>, de una manera modular y escalable.<br />
<br />
Nos será útil para estar al tanto del estado de todas las alertas; por poner un ejemplo, en ocasiones puede ocurrir, que como resultado de un autoescalado, haya cambiado el id de una instancia, y el agente de CloudWatch no se esté ejecutando, lo que resultaría en un "Insufficient Data".<br />
<br />
<h2>
Funcionalidad</h2>
<div>
<ul>
<ul>
<li><b>Lambda</b> (Se ejecutará cada X tiempo)</li>
<li>Definimos una lista con los "Role Arn" de todas las cuentas de AWS que queremos monitorizar.</li>
<li>La lambda recorre dicha lista y mediante "<a href="https://docs.aws.amazon.com/cli/latest/reference/sts/assume-role.html" target="_blank">Assume-role</a>" obtiene las credenciales de seguridad temporales necesarias, para cada una de las cuentas definidas anteriormente:</li>
<ul>
<li>Una ID de clave de acceso</li>
<li>Una clave de acceso secreta</li>
<li>Un token de seguridad.</li>
</ul>
<li>Lo que le permitirá acceder a las alertas configuradas en CloudWatch y obtener los estados de dichas alertas.</li>
<li>Esta información la guardará en un bucket S3.</li>
</ul>
<li><b>Plugin Check_MK</b></li>
<ul>
<li>Carga periódicamente la información almacenada en el bucket S3.</li>
<li>Selecciona las alertas con estado "INSUFFICIENT_DATA" y "ALARM"</li>
<li>Calcula cuánto tiempo ha pasado desde la última actualización del estado de la alerta.</li>
<li>Sólo en el caso de que éste supere los 30 minutos, prestará atención a las métricas en estado de alerta y notificará a Check_Mk, con un "CRITICAL"</li>
<ul>
<li>en el caso de las alertas con el estado "ALARM"</li>
</ul>
<li>o con un "WARNING"</li>
<ul>
<li>en el caso de las alertas con el estado "INSUFFICIENT_DATA"</li>
</ul>
</ul>
</ul>
<div>
A continuación comentaré las políticas de IAM necesarias tanto para la Lambda como para el plugin de Check_MK (Para ver como se configuran tanto las políticas IAM como la Lambda, te recomiendo pasarte por los post anteriores <a href="https://suevaristo.blogspot.com/2019/04/lambda-mfa-checker-aws.html" target="_blank">Parte 1</a> y <a href="https://suevaristo.blogspot.com/2019/05/lambda-mfa-checker-aws-parte-2.html" target="_blank">Parte 2</a>)</div>
</div>
<h2>
Lambda</h2>
</div>
<div>
<div>
<h3 style="text-align: justify;">
Permisos necesarios</h3>
</div>
<div>
<div style="text-align: justify;">
Necesitamos crear un Rol, que asignaremos a nuestra Lambda, con las siguientes políticas:</div>
<h4 style="text-align: justify;">
AssumeRole-All</h4>
<div style="text-align: justify;">
Que tenga permiso de hacer sts:AssumeRole en todas las cuentas:<br />
<script src="https://gist.github.com/evaristorivi/967c69092e60fddcce5d10fb76e25fb5.js"></script></div>
<h4 style="text-align: justify;">
Put S3</h4>
<div style="text-align: justify;">
En cuanto al S3, que tenga acceso a él para depositar el fichero de datos.</div>
<div style="text-align: justify;">
s3:PutObject</div>
<h4 style="text-align: justify;">
Send email</h4>
<div>
<div style="text-align: justify;">
Para el control de errores de la Lambda, que pueda enviar emails:</div>
</div>
<div>
<script src="https://gist.github.com/evaristorivi/8a6acc34738cd67a264e517387386be9.js"></script></div>
<div style="text-align: justify;">
<br /></div>
<h4 style="text-align: justify;">
CloudWatch</h4>
<div style="text-align: justify;">
Para poder obtener las métricas:</div>
<div style="text-align: justify;">
CloudWatchReadOnlyAccess</div>
<div style="text-align: justify;">
<br /></div>
<h4 style="text-align: justify;">
Logs</h4>
<div>
<div style="text-align: justify;">
Y opcionalmente, para poder escribir los logs de la Lambda:</div>
</div>
<div style="text-align: justify;">
CloudWatchLogsFullAccess</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<h3 style="text-align: justify;">
Código:</h3>
</div>
</div>
<div>
<div style="text-align: justify;">
Con éste rol ya configurado, solo tendremos que crear nuestra Lambda:</div>
</div>
<div>
<div style="text-align: justify;">
<br /></div>
<script src="https://gist-it.appspot.com/github.com/evaristorivi/LAMBDA-alarms-multi-account-list/blob/master/LAMBDA_alarms-multi-account-list.py"> </script>
<br />
<div style="text-align: justify;">
<a href="https://github.com/evaristorivi/LAMBDA-alarms-multi-account-list/blob/master/LAMBDA_alarms-multi-account-list.py" target="_blank">LAMBDA_alertas-multi-account</a></div>
<div style="text-align: justify;">
<br /></div>
</div>
<div>
<h2 style="text-align: justify;">
Plugin Check_MK</h2>
<div>
<div style="text-align: justify;">
Permisos necesarios</div>
</div>
<div>
<h4 style="text-align: justify;">
Get S3</h4>
<div>
<div>
<div style="text-align: justify;">
s3:GetObject</div>
</div>
<h2 style="text-align: justify;">
Implantación en Check_MK</h2>
<div style="text-align: justify;">
Descargamos el código a continuación y lo depositaremos en el directorio correcto (más abajo lo detallo) de nuestro sitio Check_MK.</div>
</div>
</div>
<div>
<script src="https://gist-it.appspot.com/github.com/evaristorivi/CHECK_MK_list_alerts_AWS/blob/master/CHECK_MK_list_alerts_v2_multi_account_bucket_s3.py"> </script>
</div>
<div style="text-align: justify;">
<a href="https://github.com/evaristorivi/CHECK_MK_list_alerts_AWS/blob/master/CHECK_MK_list_alerts_v2_multi_account_bucket_s3.py" target="_blank">CHECK_MK_list_alerts_v2_multi_account_bucket_s3</a></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Puede ser uno de los siguientes:<br />
<br />
/opt/omd/sites/<sitename>/lib/nagios/plugins<br />
/opt/omd/sites/<sitename>/local/lib/nagios/plugins<br />
<b><br /></b>
<b>En mi caso es el segundo.</b><br />
<div>
<b><br /></b></div>
</div>
<div>
<div style="text-align: justify;">
Además debemos de asegurarnos de que el script tenga tanto los permisos de ejecución como el usuario correctos.</div>
</div>
<div>
<div style="text-align: justify;">
<br /></div>
</div>
<div>
<div style="text-align: justify;">
chmod +x script.py<br />
<br />
(en mi caso, usuario check_mk)</div>
</div>
<div>
<div style="text-align: justify;">
chown check_mk:check_mk script.py<br />
<h2>
<span style="font-size: 18.72px;">Configuración Check_MK</span></h2>
</div>
</div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTMISsNt91fwR9Y_pydoj6g7971H0JSPis-NqxL5iUSxeWJqBC4_07i-VZEZx4SYA8dW8HD8oUjFrq2X8gBRPBmmlzajbTtWAOxIW7iQrIEx2l7SjGJfZBbICSC7T_Yl1fQfsAG89Fv7A7/s1600/ksnip_20190515-210241.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="737" data-original-width="270" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTMISsNt91fwR9Y_pydoj6g7971H0JSPis-NqxL5iUSxeWJqBC4_07i-VZEZx4SYA8dW8HD8oUjFrq2X8gBRPBmmlzajbTtWAOxIW7iQrIEx2l7SjGJfZBbICSC7T_Yl1fQfsAG89Fv7A7/s640/ksnip_20190515-210241.png" width="233" /></a></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivnCgzgwnKUWwEVLyQXdEpFa7r8c5alvCvXZhT6Ac4nFSIcxeQTs6CCs7W_ZAuwt5vqGpj_L-ir9nXfUzMwKXlj9YAsR3OXxSko0uhVwtD7vdl_o3nD3lPwA1fIJarA60cqlYyE_k7pU23/s1600/ksnip_20190515-210321.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="583" data-original-width="1071" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivnCgzgwnKUWwEVLyQXdEpFa7r8c5alvCvXZhT6Ac4nFSIcxeQTs6CCs7W_ZAuwt5vqGpj_L-ir9nXfUzMwKXlj9YAsR3OXxSko0uhVwtD7vdl_o3nD3lPwA1fIJarA60cqlYyE_k7pU23/s640/ksnip_20190515-210321.png" width="640" /></a></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8jgJYv4UuEa86PZdER4pbXilt8C-MJ2rzWTn189bASnO2L1ztAUmVaGtTFQDwtfn1O5u-GVGyAjoGlOx1z8Cl88oHXyqvKXOkunHejeWuqiNBKCuuBnlVlzJOHCMNuHU6vVsycXrlxd77/s1600/ksnip_20190515-210355.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="262" data-original-width="1259" height="132" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8jgJYv4UuEa86PZdER4pbXilt8C-MJ2rzWTn189bASnO2L1ztAUmVaGtTFQDwtfn1O5u-GVGyAjoGlOx1z8Cl88oHXyqvKXOkunHejeWuqiNBKCuuBnlVlzJOHCMNuHU6vVsycXrlxd77/s640/ksnip_20190515-210355.png" width="640" /></a></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixUjsX3tEzVdRGTrLLqvgEekcFj3Y6uc0iBmVFksd6IcLxHa_74NZFNH-euuoCa6bvvhZqJYUwZJG6OAUEC-z6SX7ncyhvH4UDGX0E0qYNbkHhkd_pELwoKQTAz8sNFZUBVb_zGLUOTZxI/s1600/ksnip_20190515-210415.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="49" data-original-width="168" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixUjsX3tEzVdRGTrLLqvgEekcFj3Y6uc0iBmVFksd6IcLxHa_74NZFNH-euuoCa6bvvhZqJYUwZJG6OAUEC-z6SX7ncyhvH4UDGX0E0qYNbkHhkd_pELwoKQTAz8sNFZUBVb_zGLUOTZxI/s1600/ksnip_20190515-210415.png" /></a></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKYxWWKdqAvI0oI_B2YIZ6NrUNzC2hzAJykqARHuIH39S1D3KlF9q5_aia0iKpjirugDWINqL3u-hgrHGeZpDX5l-x_Cglb88wHEYje0nK5qR3ngHXTK4584QhVJHYRct6fSNs5UdDd_T7/s1600/ksnip_20190515-210545.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="544" data-original-width="1240" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKYxWWKdqAvI0oI_B2YIZ6NrUNzC2hzAJykqARHuIH39S1D3KlF9q5_aia0iKpjirugDWINqL3u-hgrHGeZpDX5l-x_Cglb88wHEYje0nK5qR3ngHXTK4584QhVJHYRct6fSNs5UdDd_T7/s640/ksnip_20190515-210545.png" width="640" /></a></div>
</div>
<div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
La variable que observamos antes del nombre del script, podría ser una de las siguientes, dependiendo de dónde ubicáramos el script:</div>
<div style="text-align: justify;">
<br /></div>
</div>
<div>
<div style="text-align: justify;">
$USER1$ = /opt/omd/sites/<sitename>/lib/nagios/plugins </div>
</div>
<div>
<div style="text-align: justify;">
$USER2$ = /opt/omd/sites/<sitename>/local/lib/nagios/plugins<br />
<br />
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_yXAvxxFBOTrYEMoRpJgs7eUsmDD6dRBi2wxO9dtpxmQLigwW5VrODE95FePur3YDXGnqQTZSN_9C7fCFJV6AXACY3dCsY24PUodmBuFV5ga1Xf0tAQZbS3v6Q8IryQoBYxXGbU_A-74u/s1600/ksnip_20190515-213003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="42" data-original-width="65" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_yXAvxxFBOTrYEMoRpJgs7eUsmDD6dRBi2wxO9dtpxmQLigwW5VrODE95FePur3YDXGnqQTZSN_9C7fCFJV6AXACY3dCsY24PUodmBuFV5ga1Xf0tAQZbS3v6Q8IryQoBYxXGbU_A-74u/s1600/ksnip_20190515-213003.png" /></a></div>
<br />
Guardamos, y confirmamos los cambios.<br />
<br />
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipL5dEquynchb9cjklIAk5BufIX94pKMBhTFcXL0NdoNSDg3liGuwHl-v2gzb1m6TGk3Ygws1NHpCWRmvMYmRgXnP_0wVxmpDlU1HDq753_hUM6qMNgAQ8xoY50ecymLb4nz_BKNA93m_y/s1600/ksnip_20190515-213026.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="394" data-original-width="546" height="287" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipL5dEquynchb9cjklIAk5BufIX94pKMBhTFcXL0NdoNSDg3liGuwHl-v2gzb1m6TGk3Ygws1NHpCWRmvMYmRgXnP_0wVxmpDlU1HDq753_hUM6qMNgAQ8xoY50ecymLb4nz_BKNA93m_y/s400/ksnip_20190515-213026.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH70tIJ8HIfBIWKvXp_GHH9x8gMLF0fImtM2zPcp9cLML-jbAAY_x7sRzatkwTrXfu5OWJy4JQYmSCVvGJpL31oH9YIqPiITk63bwryuCx02_kfBblOeNWM9483Eae_Xx8UJY2uX7sxz8w/s1600/ksnip_20190515-213043.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="173" data-original-width="894" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH70tIJ8HIfBIWKvXp_GHH9x8gMLF0fImtM2zPcp9cLML-jbAAY_x7sRzatkwTrXfu5OWJy4JQYmSCVvGJpL31oH9YIqPiITk63bwryuCx02_kfBblOeNWM9483Eae_Xx8UJY2uX7sxz8w/s640/ksnip_20190515-213043.png" width="640" /></a></div>
<br />
Y este sería el resultado, en este caso el código de salida del plugin es (1) por lo que veremos un Warning, al tener 4 alertas que llevan más de 30 minutos en estado de INSUFFICIENT_DATA.<br />
<br />
<div class="separator" style="clear: both; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2mRaZwQm7tscl9g9CmXH3T0SgmAH1YIC9rcTpI51jVNz40M8TQW532h9B8wlR444rt2J2oicCXO2Y3FMdkf0p16oc9_Q58R88gZ0U1WK-SaRfE7IKrUOB9okelh-PWhKu5yP9gyeLZM7p/s1600/ksnip_20190515-213109.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="67" data-original-width="1282" height="32" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2mRaZwQm7tscl9g9CmXH3T0SgmAH1YIC9rcTpI51jVNz40M8TQW532h9B8wlR444rt2J2oicCXO2Y3FMdkf0p16oc9_Q58R88gZ0U1WK-SaRfE7IKrUOB9okelh-PWhKu5yP9gyeLZM7p/s640/ksnip_20190515-213109.png" width="640" /></a></div>
<br />
Si le hacemos click, nos daría más información acerca de estas alertas (nombre ARN, etc..) pero no voy a mostrarlo, por ser información sensible de mis instancias.<br />
<br /></div>
</div>
<div>
<div style="text-align: justify;">
Aquí termina el post, esto solo es el punto de partida, a partir de aquí podríamos ampliar la funcionalidad todo lo que necesitásemos.<br />
<br />
Nos vemos en la próxima!!!</div>
</div>
Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com0tag:blogger.com,1999:blog-5423617789065842564.post-19630139580844723612019-05-02T20:52:00.001+02:002019-05-02T20:59:06.229+02:00Lambda MFA Checker - AWS - Parte 2<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkS566MdZLiTHmgmkk4cKMvCyUNOc7rsJOskhcbFrsPSWzMBj-22sMghGH88sdwJgQ6n5IdBB2ZqP3QrulytMDyrIO9z5D5c4V_LDfLAUQfR6V6jvoaaqMt2RPjP3rAEFxxpCT5dWnYGyO/s1600/Lambda_MFA_check_v2+%25286%2529.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="637" data-original-width="741" height="550" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkS566MdZLiTHmgmkk4cKMvCyUNOc7rsJOskhcbFrsPSWzMBj-22sMghGH88sdwJgQ6n5IdBB2ZqP3QrulytMDyrIO9z5D5c4V_LDfLAUQfR6V6jvoaaqMt2RPjP3rAEFxxpCT5dWnYGyO/s640/Lambda_MFA_check_v2+%25286%2529.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<h2 style="clear: both; text-align: left;">
Mejora de la funcionalidad de MFA_Check</h2>
<div>
Este post es la continuación de la <a href="https://suevaristo.blogspot.com/2019/04/lambda-mfa-checker-aws.html" target="_blank">parte 1</a>. He mejorado la funcionalidad del anterior script además de refactorizar el código. No soy ningún experto en Python, pero he intentado que esté más ordenado que antes, teniendo una sección de configuración, además de un switch para activar el modo DEBUG.</div>
<div>
<br /></div>
<h3>
¿Qué ha cambiado?</h3>
<div>
<ul>
<li>La función Lambda envía automáticamente el email con las instrucciones MFA a los usuarios que no tienen MFA activado. Al administrador le llega un e-mail con la lista de usuarios que no tienen MFA activado, precisando también, cuáles de éstos supera además "n" de días de antigüedad.</li>
<ul>
<li>Para ello ya no usaremos Amazon Simple Notification Service (<b>SNS</b>) sino Amazon Simple Email Service (<b>SES</b>)</li>
</ul>
<li>Ahora filtraremos a los usuarios cuyo nombre de usuario sea una dirección de correo electrónico de nuestra organización. (Está pensado para detectar solo a los usuarios cuyo nombre es: "user@example.com" descartando a los usuarios programáticos como: "test" </li>
<li>Tenemos un switch que activa el modo DEBUG. Cuando éste está activado, nos llegarán todos los emails que tengan que enviarse a una dirección que definamos para el modo DEBUG.</li>
</ul>
<div>
Pero primero, vamos a ver como automatizar la ejecución de la Lambda que ya tenemos del anterior post. Nos interesa que se ejecute cada mes, por ejemplo, así que vamos a crear una regla en CloudWatch.<br />
<br />
<h2>
CloudWatch</h2>
</div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQeOkuFAWqwKqZomrelp_XACr6eD6NdxnsXtnpewYUU1VICceqyVSFv0smnFuOXsIkeRcsM9tnZ_sp4_jvvTRRbhj2K9Z5bCfc2DD7zgS3nd6c11BU6IKjpq1pCPyYx8gqR6YJqKr8A-WO/s1600/ksnip_20190501-192908.png" imageanchor="1"><img border="0" height="304" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQeOkuFAWqwKqZomrelp_XACr6eD6NdxnsXtnpewYUU1VICceqyVSFv0smnFuOXsIkeRcsM9tnZ_sp4_jvvTRRbhj2K9Z5bCfc2DD7zgS3nd6c11BU6IKjpq1pCPyYx8gqR6YJqKr8A-WO/s640/ksnip_20190501-192908.png" width="640" /></a></div>
<div>
<br /></div>
</div>
<div>
<div style="text-align: center;">
<div style="text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt7i8R-dmJyDX41tSqcMkX01hPFnpPi2s8hjUQNyczbj0oMWGldcwZ3YaU0KSfa8QGDPwlhTHMfIUD4Fa3hwQn0n5ZrqiU_sOUB5tMzvBdKawnDBYpp-IJhYpwzG9dMVuKYoU6DIpIvdP5/s1600/ksnip_20190501-192956.png" imageanchor="1"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt7i8R-dmJyDX41tSqcMkX01hPFnpPi2s8hjUQNyczbj0oMWGldcwZ3YaU0KSfa8QGDPwlhTHMfIUD4Fa3hwQn0n5ZrqiU_sOUB5tMzvBdKawnDBYpp-IJhYpwzG9dMVuKYoU6DIpIvdP5/s400/ksnip_20190501-192956.png" width="198" /></a><br />
<br />
Creamos una regla:</div>
</div>
<div style="text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzNCfcY-YYPf72Ah4iBVNCKuml5Xvbl21C0GvfGzamnF_jrl6rO0YfwGXnUOcwx57SyD7vWPm1ce8dr3rbE3Tjc5WrkXel93cn5mtycTvHzhgwJ1qSfpBFVDlb3hQ7SpH5zWtok1aC5JnI/s1600/ksnip_20190501-193017.png" imageanchor="1"><img border="0" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzNCfcY-YYPf72Ah4iBVNCKuml5Xvbl21C0GvfGzamnF_jrl6rO0YfwGXnUOcwx57SyD7vWPm1ce8dr3rbE3Tjc5WrkXel93cn5mtycTvHzhgwJ1qSfpBFVDlb3hQ7SpH5zWtok1aC5JnI/s640/ksnip_20190501-193017.png" width="640" /></a><br />
<br />
Utilizaremos expresiones Cron, en este caso le indicamos que se ejecute el primer día de cada mes a las 08:00.<br />
<br /></div>
</div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirvvQVeHs_mMs9PUnvuiHMs6gnAEd6nmJ9wzQUZftLLimsc2zbf1OaRNYxVn5DUAOGb_4PfoAAIpxrLMG7kd-xamZRZ3o4I2UCN6mN6PY36bQqyXIIq8wlJcoFSxbw45Fsf8sKHvnwoW6c/s1600/ksnip_20190501-193140.png" imageanchor="1"><img border="0" height="259" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirvvQVeHs_mMs9PUnvuiHMs6gnAEd6nmJ9wzQUZftLLimsc2zbf1OaRNYxVn5DUAOGb_4PfoAAIpxrLMG7kd-xamZRZ3o4I2UCN6mN6PY36bQqyXIIq8wlJcoFSxbw45Fsf8sKHvnwoW6c/s640/ksnip_20190501-193140.png" width="640" /></a><br />
<br />
Solo nos falta asociar esta regla con nuestra Lambda:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyo43vTeViEjfiINiMFDL1dhvS-ARi4I0rNmBurEKh083yl0QtVL24Iunceenrj5WHIv3S1Q-QFpunQ9ZUVKp9cDd3N-QalexLQWvnspbT13oc9mwhXH4w8Ivs8RIFIWi7kieGEuzQwIbg/s1600/ksnip_20190501-193202.png" imageanchor="1"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyo43vTeViEjfiINiMFDL1dhvS-ARi4I0rNmBurEKh083yl0QtVL24Iunceenrj5WHIv3S1Q-QFpunQ9ZUVKp9cDd3N-QalexLQWvnspbT13oc9mwhXH4w8Ivs8RIFIWi7kieGEuzQwIbg/s640/ksnip_20190501-193202.png" width="640" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhJ9YImASZK5sSRNaztP4a1hp-TaQK2tF0HQlT3481wVupwZltmbTcHJbZOgYT2gvM2LlKNnQKUsXIMmQV4JCx0_34RsbUHda6ph7cipm68ffUI_si2a9J8SaLq5q9t7G7lCmxuk4G-yK_/s1600/ksnip_20190501-193222.png" imageanchor="1"><img border="0" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhJ9YImASZK5sSRNaztP4a1hp-TaQK2tF0HQlT3481wVupwZltmbTcHJbZOgYT2gvM2LlKNnQKUsXIMmQV4JCx0_34RsbUHda6ph7cipm68ffUI_si2a9J8SaLq5q9t7G7lCmxuk4G-yK_/s640/ksnip_20190501-193222.png" width="640" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3kpLHvuvkG-FIwlOO46xwg3rzSv-e7ZWuDJh4mI4BxAxsYJZ-XBlM1ovsjwFFhQwpcPcY3p-JIu6aV6l2LL8vjsfAKqo03TQcsba7VC6q4RGbHKlwlnIZeIlhfVWTnQIIBdqv2oQDrFDu/s1600/ksnip_20190501-193245.png" imageanchor="1"><img border="0" height="288" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3kpLHvuvkG-FIwlOO46xwg3rzSv-e7ZWuDJh4mI4BxAxsYJZ-XBlM1ovsjwFFhQwpcPcY3p-JIu6aV6l2LL8vjsfAKqo03TQcsba7VC6q4RGbHKlwlnIZeIlhfVWTnQIIBdqv2oQDrFDu/s640/ksnip_20190501-193245.png" width="640" /></a><br />
Todo listo, le ponemos un nombre y una descripción y ya tenemos la regla configurada.<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzZHrN3IZbtP8O1IorLR8B2yUojjb7Ni_OHenI32dVM4u2fe9X2Q4oAjyD_SKO9KKiP_qKk38-W2HQ_23TMPDLWszfO7rG1yydy7rLAuxvenNkK1lFR9Lb6-vbBagEyUuu6VUqdVe-PGtJ/s1600/ksnip_20190501-193356.png" imageanchor="1"><img border="0" height="144" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzZHrN3IZbtP8O1IorLR8B2yUojjb7Ni_OHenI32dVM4u2fe9X2Q4oAjyD_SKO9KKiP_qKk38-W2HQ_23TMPDLWszfO7rG1yydy7rLAuxvenNkK1lFR9Lb6-vbBagEyUuu6VUqdVe-PGtJ/s640/ksnip_20190501-193356.png" width="640" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiog7RBa9M3_bRFF0mGyFDdYa4eX2qMNmUNslV5IKnV8HxfJpIic1u-B543nOsJeGsGsbdCWg2YKNT8Fn-bwS51R4C8yThNYd22CLIYVggl7UkukiNchO08kgFHgxzVE1UeAs4cRWhNmxq/s1600/ksnip_20190501-193410.png" imageanchor="1"><img border="0" height="144" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiog7RBa9M3_bRFF0mGyFDdYa4eX2qMNmUNslV5IKnV8HxfJpIic1u-B543nOsJeGsGsbdCWg2YKNT8Fn-bwS51R4C8yThNYd22CLIYVggl7UkukiNchO08kgFHgxzVE1UeAs4cRWhNmxq/s640/ksnip_20190501-193410.png" width="640" /></a><br />
<h2>
Lambda</h2>
<div>
Si accedemos a la Lambda que creamos en el post anterior, veremos una novedad:</div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnuzXzqJXe5U7eLxrhEIa_il30vYNfFed0ck4gQtlkGOPRp_-XiboMt3kbmMz33b9JNBBvuyJHjMVd69YFJu4nU3hGrk7_H9dL02Fo4HeKKUnTBsXVd-N9fl6NsAdofX7g4aaBb9isAzAa/s1600/ksnip_20190501-193447.png" imageanchor="1"><img border="0" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnuzXzqJXe5U7eLxrhEIa_il30vYNfFed0ck4gQtlkGOPRp_-XiboMt3kbmMz33b9JNBBvuyJHjMVd69YFJu4nU3hGrk7_H9dL02Fo4HeKKUnTBsXVd-N9fl6NsAdofX7g4aaBb9isAzAa/s640/ksnip_20190501-193447.png" width="640" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN7AI7p5Ifb5JJzoECAa4LbzCe-1Roof0RXwQEzYfIekZ2rUYqQBNtfBUJLnLlINIyI73XbTMsnD2Q62AqPVhmBk-7iJFXiuFJ53uXaT6LGME1RVjks2ZdmU1Qi8gPRPC0JV1HIpeQ9ya8/s1600/ksnip_20190501-193600.png" imageanchor="1"><img border="0" height="104" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN7AI7p5Ifb5JJzoECAa4LbzCe-1Roof0RXwQEzYfIekZ2rUYqQBNtfBUJLnLlINIyI73XbTMsnD2Q62AqPVhmBk-7iJFXiuFJ53uXaT6LGME1RVjks2ZdmU1Qi8gPRPC0JV1HIpeQ9ya8/s640/ksnip_20190501-193600.png" width="640" /></a><br />
<br />
Observamos a la izquierda "CloudWatch Events", que es la regla que acabamos de crear. (También podríamos haber comenzado desde este panel, hubiese sido lo mismo solo que invirtiendo el orden, primero añadiendo el destino y luego la regla.)<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkztVSU40UPqOXjczu0xKc-ZOcGs-18fEBvP011l2CfJgtNrueSr7BkWeeuKWdvbyTotAohNWBpoJcjyicgxH-eW1O_HIpz1Eq4SQQtXl6yRbcCCqnXk9vT1xvLM1cdlHT2ncfPMJRJm62/s1600/ksnip_20190501-193706.png" imageanchor="1"><img border="0" height="234" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkztVSU40UPqOXjczu0xKc-ZOcGs-18fEBvP011l2CfJgtNrueSr7BkWeeuKWdvbyTotAohNWBpoJcjyicgxH-eW1O_HIpz1Eq4SQQtXl6yRbcCCqnXk9vT1xvLM1cdlHT2ncfPMJRJm62/s640/ksnip_20190501-193706.png" width="640" /></a><br />
<br />
Bien, como comentamos anteriormente, ya no vamos a usar SNS sino SES en su lugar. Necesitamos tocar un poco los permisos del rol con el que se ejecuta nuestra Lambda.<br />
<h2>
IAM</h2>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixYmtxZ6kR6-veCukSqxIL_tvEm0bqxem6XuqAmXYmbuluSwLprzbMqtsln_7SXzheiN9GiqApqYp2TZT8Gf_F9WBmiu-hBrDpYUW3YjBWJv7JlDV-kX1lomSD05bWZN1jXQQ1Mn08Q3ix/s1600/ksnip_20190501-193854.png" imageanchor="1"><img border="0" height="74" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixYmtxZ6kR6-veCukSqxIL_tvEm0bqxem6XuqAmXYmbuluSwLprzbMqtsln_7SXzheiN9GiqApqYp2TZT8Gf_F9WBmiu-hBrDpYUW3YjBWJv7JlDV-kX1lomSD05bWZN1jXQQ1Mn08Q3ix/s640/ksnip_20190501-193854.png" width="640" /></a><br />
<br />
Crearemos una política para poder enviar e-mails mediante SES<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhctCnNK5CEiQFNmaLFgluCUah3S-bG8RIt8LocxFanKjsAHSA8pkYlJKFZ60qnYYJ_fu5j3AY86VhyphenhyphenRHSMcNsWBNFXSiIOspEq5Jmncp-9SAZ-f9Rdf1iOwZwu2jkVk4xZLkdbqLV0bO0S/s1600/ksnip_20190501-193919.png" imageanchor="1"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhctCnNK5CEiQFNmaLFgluCUah3S-bG8RIt8LocxFanKjsAHSA8pkYlJKFZ60qnYYJ_fu5j3AY86VhyphenhyphenRHSMcNsWBNFXSiIOspEq5Jmncp-9SAZ-f9Rdf1iOwZwu2jkVk4xZLkdbqLV0bO0S/s400/ksnip_20190501-193919.png" width="175" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqleOEjQgTezr-p1DsSb0oW72E4LEyGB3zkp0kq4lM6lFkuMlnBrCO9sO2-trTREHRfxT1q8fPfPBeOY0fs-T_G2nicKIgjuC3IQdkH5mRfVm77FQqsIJPBab8KJU1nJKQ8Qid4QMMdyg8/s1600/ksnip_20190501-193946.png" imageanchor="1"><img border="0" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqleOEjQgTezr-p1DsSb0oW72E4LEyGB3zkp0kq4lM6lFkuMlnBrCO9sO2-trTREHRfxT1q8fPfPBeOY0fs-T_G2nicKIgjuC3IQdkH5mRfVm77FQqsIJPBab8KJU1nJKQ8Qid4QMMdyg8/s400/ksnip_20190501-193946.png" width="400" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpzYT9c2XZ732ceRVRsJXydy5D34akfY_UyAKmNYSGOuPuwxOnytU8lcAzaiOhyphenhyphenY3FJs4zY67FmCnqEVGw5k9t0p9Up0Tzk_VlOdRm8PGrw_WZLy10j53xrLD_C2rLDLUSkXgp5MUYK674/s1600/ksnip_20190501-194231.png" imageanchor="1"><img border="0" height="350" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpzYT9c2XZ732ceRVRsJXydy5D34akfY_UyAKmNYSGOuPuwxOnytU8lcAzaiOhyphenhyphenY3FJs4zY67FmCnqEVGw5k9t0p9Up0Tzk_VlOdRm8PGrw_WZLy10j53xrLD_C2rLDLUSkXgp5MUYK674/s640/ksnip_20190501-194231.png" width="640" /></a><br />
Personalizamos la política JSON<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4ORfUhYTxO94JSnv-w9HrlNTZjho1kIIv2836rxOTkKPwXrTmpBZ_9SuyrTe_WQ_ao3zlOn4QMkx9-TmC0ooCUfpAbctJBMioNHluJzcSF1foPBFQNIsShHg_QUjeAz9rAIREoILMzjaZ/s1600/ksnip_20190501-194357.png" imageanchor="1"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4ORfUhYTxO94JSnv-w9HrlNTZjho1kIIv2836rxOTkKPwXrTmpBZ_9SuyrTe_WQ_ao3zlOn4QMkx9-TmC0ooCUfpAbctJBMioNHluJzcSF1foPBFQNIsShHg_QUjeAz9rAIREoILMzjaZ/s640/ksnip_20190501-194357.png" width="640" /></a><br />
<br />
<script src="https://gist.github.com/evaristorivi/8a6acc34738cd67a264e517387386be9.js"></script><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD1wu7nkBzkpMnJYuqCg8F9vyqi6qG05pJOUMwU4zE1PwResOQEH3vLmIc2jrwwEHly3wc6qPPsiUFh3XZseRIYbeNB7cIx2uziC9Qru-O5bfnLgZFNpVxJKveyz72uaUj4z5aAfzSbgl4/s1600/ksnip_20190501-194517.png" imageanchor="1"><img border="0" height="450" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD1wu7nkBzkpMnJYuqCg8F9vyqi6qG05pJOUMwU4zE1PwResOQEH3vLmIc2jrwwEHly3wc6qPPsiUFh3XZseRIYbeNB7cIx2uziC9Qru-O5bfnLgZFNpVxJKveyz72uaUj4z5aAfzSbgl4/s640/ksnip_20190501-194517.png" width="640" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCxLk2LBFWLQRE5sbhLMcwYGrZIN5PewJVP7BBMR1MC7A8rBM4g_Kxz42h_AcbdFIFdOW8ntWLAEcwl65L4S2ovhvHW-aKKNz0OeFbVdj5BWt41tVWPSWfubVHZWIbMHLPbmKXiTt20jpT/s1600/ksnip_20190501-194620.png" imageanchor="1"><img border="0" height="450" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCxLk2LBFWLQRE5sbhLMcwYGrZIN5PewJVP7BBMR1MC7A8rBM4g_Kxz42h_AcbdFIFdOW8ntWLAEcwl65L4S2ovhvHW-aKKNz0OeFbVdj5BWt41tVWPSWfubVHZWIbMHLPbmKXiTt20jpT/s640/ksnip_20190501-194620.png" width="640" /></a><br />
<br />
Una vez creada la política vamos a:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg9_HzSDLPEHT_479Joa0upN9LwdmVpmbnWByJR3XtlH_oJqw4ooT7JjMCKOkPCQ0yYWqKDWiKvoojBQPzl-u1eOYipYz-8GZlzfd6bG9RJUkGp23kmgKAFblRJwe6MJxkwElAkNfVt6P8/s1600/ksnip_20190501-194648.png" imageanchor="1"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg9_HzSDLPEHT_479Joa0upN9LwdmVpmbnWByJR3XtlH_oJqw4ooT7JjMCKOkPCQ0yYWqKDWiKvoojBQPzl-u1eOYipYz-8GZlzfd6bG9RJUkGp23kmgKAFblRJwe6MJxkwElAkNfVt6P8/s400/ksnip_20190501-194648.png" width="171" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyyMbl8adICN3CohYDHSP-563t8dC7d2aPSomqWNJdahW78CIGtQV0LC0Q3Cfis_NXJavE9kPswvL_aDWehgj9CgrLz1r4mJevu5UOIhcvY7PV2x1xXLY4Tj0VphcyeGXtan_qsJwHAFBF/s1600/ksnip_20190501-194732.png" imageanchor="1"><img border="0" height="20" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyyMbl8adICN3CohYDHSP-563t8dC7d2aPSomqWNJdahW78CIGtQV0LC0Q3Cfis_NXJavE9kPswvL_aDWehgj9CgrLz1r4mJevu5UOIhcvY7PV2x1xXLY4Tj0VphcyeGXtan_qsJwHAFBF/s640/ksnip_20190501-194732.png" width="640" /></a><br />
<br />
Además eliminaremos la política del SNS, ya que ya no la necesitamos.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0K9MnLuC62aFJBatydoUF9KXT8q806U_pNnYkVFLpw_UGWu1JYVCEJQcyLhZ7FODZaxaCykMzjG4X9zc3UbE4nMTkQWoEfC7Sq7xr6pnkJaz-ZkEYz5BEF2W9RJVGKanRVhge7M7cRewD/s1600/ksnip_20190501-194802.png" imageanchor="1"><img border="0" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0K9MnLuC62aFJBatydoUF9KXT8q806U_pNnYkVFLpw_UGWu1JYVCEJQcyLhZ7FODZaxaCykMzjG4X9zc3UbE4nMTkQWoEfC7Sq7xr6pnkJaz-ZkEYz5BEF2W9RJVGKanRVhge7M7cRewD/s640/ksnip_20190501-194802.png" width="640" /></a><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNqFeaZFzjgx9Mx61RU876_VYEEoJxQpdpxydvx2cadZ1XP8nq97JBhy1o06r7Fvr624VFpll0J78CCUEEuM7T3SeW91hyXlbh6t2A1OUsDtITIVI_MN3PcGcSm2iZkkoCVjJ7XFeT9Em7/s1600/ksnip_20190501-194828.png" imageanchor="1"><img border="0" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNqFeaZFzjgx9Mx61RU876_VYEEoJxQpdpxydvx2cadZ1XP8nq97JBhy1o06r7Fvr624VFpll0J78CCUEEuM7T3SeW91hyXlbh6t2A1OUsDtITIVI_MN3PcGcSm2iZkkoCVjJ7XFeT9Em7/s640/ksnip_20190501-194828.png" width="640" /></a><br />
<br />
Y añadimos la nueva política creada anteriormente<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT8zJ20FnRpdQ-vbnw1102SEP48rahyT54sQcm7H4Uk6_bHed8Yz5OJ-PvIsxkDLzGBDr-OTX08YowBkAYDusfzmlTEgqRdKzRPCoRYQp_pM-ijvpTA4jyEyBatLZGCf9kqm00ig0alOlD/s1600/ksnip_20190501-194853.png" imageanchor="1"><img border="0" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT8zJ20FnRpdQ-vbnw1102SEP48rahyT54sQcm7H4Uk6_bHed8Yz5OJ-PvIsxkDLzGBDr-OTX08YowBkAYDusfzmlTEgqRdKzRPCoRYQp_pM-ijvpTA4jyEyBatLZGCf9kqm00ig0alOlD/s640/ksnip_20190501-194853.png" width="640" /></a><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij5GDUyJZovLU5VF0BgMrDRRJKqBan1bJjyGA22r76P4WDEcsstI2tqcupm-uzhrAXn9FRf41BtdMaiaX4kOD-jZlOljxXX6LtJgnkBU7mtgTPpc49jXxF94FDHDbGGALGA_1MA25Y-zDy/s1600/ksnip_20190501-194915.png" imageanchor="1"><img border="0" height="420" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij5GDUyJZovLU5VF0BgMrDRRJKqBan1bJjyGA22r76P4WDEcsstI2tqcupm-uzhrAXn9FRf41BtdMaiaX4kOD-jZlOljxXX6LtJgnkBU7mtgTPpc49jXxF94FDHDbGGALGA_1MA25Y-zDy/s640/ksnip_20190501-194915.png" width="640" /></a><br />
Muy bien! A continuación vamos a configurar SES:<br />
<h2>
SES</h2>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1u9euVt2LNW7XGpRxECX-cT5MxuBy7FMYdFuyGPNi82S-h8Hz4ILOYKmOfik9UJost8XtdfzzV_0hvwvV__juCsWGs9hLT4cEUaYzadwiEWErROIjGp5h7DcQH8k8VPLjtzeQUrOH8Rab/s1600/ksnip_20190501-194959.png" imageanchor="1"><img border="0" height="210" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1u9euVt2LNW7XGpRxECX-cT5MxuBy7FMYdFuyGPNi82S-h8Hz4ILOYKmOfik9UJost8XtdfzzV_0hvwvV__juCsWGs9hLT4cEUaYzadwiEWErROIjGp5h7DcQH8k8VPLjtzeQUrOH8Rab/s640/ksnip_20190501-194959.png" width="640" /></a><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3NfrUqmxOf6_cJgV4qyA75HsG6Y-x6DE0iSbiccdguCeWSBefo9CrrOMF1E3V6F1Hpuiao2VdbXw8xmvutCXuqWvDACmxRm1yOY94vKz6G5exLwUGn6UpIBVFlDY7gI52iMgfJPoRP2N5/s1600/ksnip_20190501-195041.png" imageanchor="1"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3NfrUqmxOf6_cJgV4qyA75HsG6Y-x6DE0iSbiccdguCeWSBefo9CrrOMF1E3V6F1Hpuiao2VdbXw8xmvutCXuqWvDACmxRm1yOY94vKz6G5exLwUGn6UpIBVFlDY7gI52iMgfJPoRP2N5/s400/ksnip_20190501-195041.png" width="121" /></a><br />
Necesitamos verificar un e-mail:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg88llLeqmfPK-bNCmtK77go_6_gKghLVWpgz49_zz6Dqs827BGtDkee8-0-PcsxZyIhs6D_r3StA6wI_FtY-46TTHSTlEtq8yx1tvHYhopW65S_4TUbZ5rTloIMjsc1ZXMcQwY3NtPjgM6/s1600/ksnip_20190501-195058.png" imageanchor="1"><img border="0" height="209" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg88llLeqmfPK-bNCmtK77go_6_gKghLVWpgz49_zz6Dqs827BGtDkee8-0-PcsxZyIhs6D_r3StA6wI_FtY-46TTHSTlEtq8yx1tvHYhopW65S_4TUbZ5rTloIMjsc1ZXMcQwY3NtPjgM6/s640/ksnip_20190501-195058.png" width="640" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhak2HDvwnuMNPcLg6IIsJIPiwCOA1rBnZoVdmlo_dYkuQnw3Lhyphenhyphen0zbqiI2UvjnNrncw97qHbUjCG0V1qkzptw5XE1PA5QJn7qy5Qa1baUThgHXztdGdKsh3vphA4sYSXGU-Ijot-BsYe5x/s1600/ksnip_20190501-195134.png" imageanchor="1"><img border="0" height="259" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhak2HDvwnuMNPcLg6IIsJIPiwCOA1rBnZoVdmlo_dYkuQnw3Lhyphenhyphen0zbqiI2UvjnNrncw97qHbUjCG0V1qkzptw5XE1PA5QJn7qy5Qa1baUThgHXztdGdKsh3vphA4sYSXGU-Ijot-BsYe5x/s640/ksnip_20190501-195134.png" width="640" /></a><br />
<br />
<u><b>Nos llegará un e-mail con un enlace al que deberemos de hacer click.</b></u><br />
<br />
<br />
Entonces veremos lo siguiente:<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifE6_87JT3BAb7D89zCjSYkIi2wGMyK5_H1eW1K9qJ6FkNyfQBxITay_KPowld0ws3_9oP00r5Kc2L9q_PIOojLxuLZKN1MhZVAA2ZMIJdOdxyEV-E4EkeTso591D-gTmbfI8nn4HR2G9X/s1600/ksnip_20190501-195317.png" imageanchor="1"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifE6_87JT3BAb7D89zCjSYkIi2wGMyK5_H1eW1K9qJ6FkNyfQBxITay_KPowld0ws3_9oP00r5Kc2L9q_PIOojLxuLZKN1MhZVAA2ZMIJdOdxyEV-E4EkeTso591D-gTmbfI8nn4HR2G9X/s640/ksnip_20190501-195317.png" width="640" /></a><br />
<br />
Y si actualizamos, podremos ver como cambia el estado a "verified"<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGYCb5oLtzHnJmMDcNYnXygLXkKp3wwNjHZ9Ma6EYagK6pXd_Kol8EbBTQ6N4F6yRsRP9ub80L2dKJXK2QWbjF2Wxe4pldjG47b24GSZh8EHkykubtpChR43hDaH3JBEv9ry136C0ib0XB/s1600/ksnip_20190502-204107.png" imageanchor="1"><img border="0" height="102" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGYCb5oLtzHnJmMDcNYnXygLXkKp3wwNjHZ9Ma6EYagK6pXd_Kol8EbBTQ6N4F6yRsRP9ub80L2dKJXK2QWbjF2Wxe4pldjG47b24GSZh8EHkykubtpChR43hDaH3JBEv9ry136C0ib0XB/s640/ksnip_20190502-204107.png" width="640" /></a><br />
<br />
<br />
Si vamos a nuestra Lambda de nuevo, veremos el cambio:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJrbZbq3LQTBuMtPbj7kNyN49XDM_u8TzUrRV4-pP0wN2fePNMnoJaFVSkZNF1U221trdz7anITe10d12zsczZ1rQiOdQF7O8GBVR0yfvtkf-GwFV6lcGHyP54QMs_tTklJFJyi82SpQtp/s1600/ksnip_20190501-195424.png" imageanchor="1"><img border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJrbZbq3LQTBuMtPbj7kNyN49XDM_u8TzUrRV4-pP0wN2fePNMnoJaFVSkZNF1U221trdz7anITe10d12zsczZ1rQiOdQF7O8GBVR0yfvtkf-GwFV6lcGHyP54QMs_tTklJFJyi82SpQtp/s640/ksnip_20190501-195424.png" width="640" /></a><br />
<br />
Pues ya solo queda actualizar el código, con la nueva versión:<br />
<br />
<h2>
Script V2</h2>
<div>
<script src="https://gist-it.appspot.com/github.com/evaristorivi/lambda-mfa-checker/blob/master/lambda_function_v2.py"> </script>
<br />
<br />
<a href="https://github.com/evaristorivi/lambda-mfa-checker/blob/master/lambda_function_v2.py" target="_blank">Script V2</a><br />
<br />
Atención, porque deberemos de configurarlo a nuestro gusto en la siguiente sección (eliminando los "<<>>":<br />
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvDmQETb2nInD8J1DjWVU3FbLmqsRdNbIAARGlAJdB65lS_UvGf2RbnBSuqnPfl3rhOxqdygMZxaR3ugMYoTvMiZQetLDUuJjjJbEOSEl_n5JbCNH-7EJTTV6ri2gT18geMUdLV4vc_BZA/s1600/ksnip_20190501-202102.png" imageanchor="1"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvDmQETb2nInD8J1DjWVU3FbLmqsRdNbIAARGlAJdB65lS_UvGf2RbnBSuqnPfl3rhOxqdygMZxaR3ugMYoTvMiZQetLDUuJjjJbEOSEl_n5JbCNH-7EJTTV6ri2gT18geMUdLV4vc_BZA/s640/ksnip_20190501-202102.png" width="640" /></a><br />
<br />
Una vez hecho esto, podremos darle a "Probar" y nos llegará el siguiente e-mail si todos los usuarios tienen habilitado MFA:<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi69w2LfwW1UawnWjezasj3CkaDHU0e2UIeRSctK112NNmr27Qj9QoBU8CwjwA5qRPJ9dy-59EDJ5mvfza3SRk1aI7k-NfkGdk9gZEcUd_06sb5p3s4UFhoe2jZL6rFgqJ5cZsO-RDDEOn3/s1600/ksnip_20190501-202717.png" imageanchor="1"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi69w2LfwW1UawnWjezasj3CkaDHU0e2UIeRSctK112NNmr27Qj9QoBU8CwjwA5qRPJ9dy-59EDJ5mvfza3SRk1aI7k-NfkGdk9gZEcUd_06sb5p3s4UFhoe2jZL6rFgqJ5cZsO-RDDEOn3/s640/ksnip_20190501-202717.png" width="640" /></a><br />
<br />
Y en el caso de que tengamos usuarios con el MFA no habilitado, nos llegará por un lado, el e-mail al administrador:<br />
<br />
Esta captura es con los usuarios recién creados:<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwSP6k_ltf5YY57IVHcK5HbZAlwT8nHa0gcGDoMz0GjuoNb3jksoeW6ix2cwTM0KAg6TKmGX-FCseIH54I5vT6J13gHdNgMi348ymQbI2s6I4NTBs-v0ouDHRnk0Cmo6D5HKR8P2qb9prW/s1600/ksnip_20190502-203738.png" imageanchor="1"><img border="0" height="214" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwSP6k_ltf5YY57IVHcK5HbZAlwT8nHa0gcGDoMz0GjuoNb3jksoeW6ix2cwTM0KAg6TKmGX-FCseIH54I5vT6J13gHdNgMi348ymQbI2s6I4NTBs-v0ouDHRnk0Cmo6D5HKR8P2qb9prW/s640/ksnip_20190502-203738.png" width="640" /></a><br />
<br />
Y esta pasado un día, (Habiendo configurado como tope máximo 0 días en vez de 120 para esta prueba):<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikzUCsWkyln239MS8qUtULJdS14c6r8SUhnr1OTGjtOGgYnNUJmm9upU-KbnHlfFzswX-MkcQgVq9uQrqtONN1HcB1ApeFsF3jeVm_uUECywDEBcEkC5XRTLnCwbJNKBUyNBP1VTdu07j1/s1600/ksnip_20190502-203828.png" imageanchor="1"><img border="0" height="374" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikzUCsWkyln239MS8qUtULJdS14c6r8SUhnr1OTGjtOGgYnNUJmm9upU-KbnHlfFzswX-MkcQgVq9uQrqtONN1HcB1ApeFsF3jeVm_uUECywDEBcEkC5XRTLnCwbJNKBUyNBP1VTdu07j1/s640/ksnip_20190502-203828.png" width="640" /></a><br />
<br />
Y como además tenemos activado el modo DEBUG, nos llegarán tres e-mails, uno por cada usuario al que le debería de llegar:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikpEt0KW7m_zLHvW160YnS7y8Pp3OtUNRLOtmMTiM7Vyaec2_5mt-vjwhl5vSMFNI1s5jiHqjc6YgVcLSU55A0qMBDxKyUfDPRdLbjW-ohM35t_4oqHXJGW06xp2IHY6uvGIVyQQKgZPCh/s1600/ksnip_20190502-203910.png" imageanchor="1"><img border="0" height="352" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikpEt0KW7m_zLHvW160YnS7y8Pp3OtUNRLOtmMTiM7Vyaec2_5mt-vjwhl5vSMFNI1s5jiHqjc6YgVcLSU55A0qMBDxKyUfDPRdLbjW-ohM35t_4oqHXJGW06xp2IHY6uvGIVyQQKgZPCh/s640/ksnip_20190502-203910.png" width="640" /></a><br />
<br />
Siendo estas, las instrucciones para el usuario, donde se le detallaría el procedimiento para habilitar MFA en su cuenta de AWS.<br />
<br />
En el momento en el que desactiváramos el modo DEBUG los mensajes se enviarían a su destinatario correspondiente.<br />
<br />
Recordar, si nos diera error por exceder el tiempo de procesamiento máximo , aumentaremos el tiempo de espera. En mi caso tarda 4 segundos, y si hay muchos usuarios 20 segundos.<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1W0DB-DJp4xJi2HSV_nK9KcRkd4UEVgV8csFFbU2Y_Ihz3RqgZPNwaCl8Jqz2ivo9wGWQorQV5Jrt54IeeVPlSTXSRIaFYO4fhuO71RTrtnMBrguwUd4hay-OH4_s_k4UXKHxL_9BwB5c/s1600/ksnip_20190501-202736.png" imageanchor="1"><img border="0" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1W0DB-DJp4xJi2HSV_nK9KcRkd4UEVgV8csFFbU2Y_Ihz3RqgZPNwaCl8Jqz2ivo9wGWQorQV5Jrt54IeeVPlSTXSRIaFYO4fhuO71RTrtnMBrguwUd4hay-OH4_s_k4UXKHxL_9BwB5c/s640/ksnip_20190501-202736.png" width="640" /></a><br />
<br />
Y esto es todo! Aquí concluye esta segunda parte. <a href="https://suevaristo.blogspot.com/2019/04/lambda-mfa-checker-aws.html" target="_blank">Si te perdiste la parte 1, puedes verla aquí.</a><br />
Ha sido una buena toma de contacto con IAM,SNS, SES, CloudWatch y por supuesto con AWS Lambda, y espero que te haya resultado interesante.<br />
<br />
Nos veremos en próximos post!</div>
Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com0tag:blogger.com,1999:blog-5423617789065842564.post-69658121156100875072019-04-24T06:00:00.000+02:002019-05-17T21:26:13.928+02:00Lambda MFA Checker - AWS - Parte 1<h2 style="text-align: center;">
</h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvyTwglr8g5pyVqZMtBgxPupCGUgFfB7j4m2nRRVImZW69f98Z4bULQHt9H-Zy_w4nEIG7SS0ZbqzOpgD0XI8pjALf0t18kKkxtc2Hy_8sP1qzXoxwfkalpKX6a2Gz7vGKh6r14nx1E8vw/s1600/Lambda_MFA_check.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="677" data-original-width="776" height="558" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvyTwglr8g5pyVqZMtBgxPupCGUgFfB7j4m2nRRVImZW69f98Z4bULQHt9H-Zy_w4nEIG7SS0ZbqzOpgD0XI8pjALf0t18kKkxtc2Hy_8sP1qzXoxwfkalpKX6a2Gz7vGKh6r14nx1E8vw/s640/Lambda_MFA_check.png" width="640" /></a></div>
<br />
<br />
<div style="text-align: justify;">
<div style="text-align: left;">
El uso de la <b>autenticación multi-factor (MFA)</b> se hace imprescindible en AWS, pues los daños/costes de un acceso no autorizado a nuestra consola de AWS podrían ser catastróficos, sobre todo si el usuario afectado tuviera permisos de administración.</div>
</div>
<div style="text-align: justify;">
<div style="text-align: left;">
<br /></div>
</div>
<div style="text-align: justify;">
<div style="text-align: left;">
Por tanto, la activación del MFA es el primer paso que todo usuario debería de seguir nada más tuviera acceso a la consola de AWS; pero no siempre se sigue esta buena práctica, siendo una problema de seguridad, más aún si hablamos de una organización grande, en la que se complica el seguimiento de: "qué usuarios tienen MFA activado y cuales no".</div>
</div>
<div style="text-align: justify;">
<div style="text-align: left;">
<br /></div>
</div>
<div style="text-align: justify;">
<div style="text-align: left;">
Como solución a este caso, en este post, detallaré la configuración en AWS, para poner en marcha una Lambda que:</div>
</div>
<div style="text-align: justify;">
<div style="text-align: left;">
<br /></div>
</div>
<ul>
<li style="text-align: left;">Liste los usuarios de IAM.</li>
<li style="text-align: left;">Haga un array de los usuarios que no tienen MFA, calculando además el tiempo de antigüedad de cada uno.</li>
<li style="text-align: left;">Envíe una notificación mediante SNS del todal de usuarios que no tienen MFA.</li>
<li style="text-align: left;">Envíe otra notificación mediante SNS de los usuarios que no tienen MFA y que además superen N días de antigüedad. (Para tomar las acciones que se estimen necesarias con dichos usuarios)</li>
</ul>
<br />
<br />
<h2>
Creación de un Rol</h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv0M8wJlF9SuF0_rhxjEymzLP1qr8YfGKtilRpu65P3snb5RWLxsMHzXbfrNy4vwRQJN4M0_7rKE2o2BY_2iEi0bhpaUVavigjP3eGZ1HhcOugPWhh8DGoN1_khMdutkdr7Flob5QoMZ_V/s1600/ksnip_20190423-203841.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="195" data-original-width="1251" height="98" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv0M8wJlF9SuF0_rhxjEymzLP1qr8YfGKtilRpu65P3snb5RWLxsMHzXbfrNy4vwRQJN4M0_7rKE2o2BY_2iEi0bhpaUVavigjP3eGZ1HhcOugPWhh8DGoN1_khMdutkdr7Flob5QoMZ_V/s640/ksnip_20190423-203841.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br />
<span id="goog_1291536395"></span><span id="goog_1291536396"></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioTov_oMb38IM2Ym2S4le-MEsqp_cuuuWQCutCQ5Jpq5Ph5_EAtOxgF41ZKXyYRf8qM0L8zuX4tH-lomTU65ft_2KAdCQ7VICc5seRiRs1N996t0UwiFBAbCK8VmjW5iXBGCVQb0n0TXdv/s1600/ksnip_20190423-203005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="591" data-original-width="533" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioTov_oMb38IM2Ym2S4le-MEsqp_cuuuWQCutCQ5Jpq5Ph5_EAtOxgF41ZKXyYRf8qM0L8zuX4tH-lomTU65ft_2KAdCQ7VICc5seRiRs1N996t0UwiFBAbCK8VmjW5iXBGCVQb0n0TXdv/s400/ksnip_20190423-203005.png" width="360" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7asjPvtSqfqtXIx05V5lVE3YMTJrGjmrWX7JZOLkqjx7sij_3GYv21bzE-RTq9ygmRfcFX8i5odgTxJf4TI9WnQz-0m2ZM5ezhtwKeh9sHLfihrxUojROBw0eQ_zLvgm1KICEo762DIUX/s1600/ksnip_20190423-203308.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="665" data-original-width="1032" height="412" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7asjPvtSqfqtXIx05V5lVE3YMTJrGjmrWX7JZOLkqjx7sij_3GYv21bzE-RTq9ygmRfcFX8i5odgTxJf4TI9WnQz-0m2ZM5ezhtwKeh9sHLfihrxUojROBw0eQ_zLvgm1KICEo762DIUX/s640/ksnip_20190423-203308.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<h3 style="clear: both; text-align: left;">
Políticas</h3>
<div class="separator" style="clear: both; text-align: left;">
Añadimos las siguientes políticas</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul>
<li>IAMReadOnlyAccess (Para poder listar los usuarios de IAM)</li>
<li>CloudWatchLogsFullAccess (Para poder escribir los logs)</li>
<li>AmazonSNSFullAccess (Para poder hacer uso de SNS)</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXwSBbO2hlRVRq2IsS-4cYGEU2ldtzL2zipzn2WjSat4eB-M69gWjTX172w8ooSNen-FRQOzDLrAOUIVyTYgYryUm2dY-_r8553tSn9n-c-7UUnQq5vNIWPEBgShzwguCUeTgCJAV4yZHT/s1600/ksnip_20190423-203545.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="678" data-original-width="1069" height="403" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXwSBbO2hlRVRq2IsS-4cYGEU2ldtzL2zipzn2WjSat4eB-M69gWjTX172w8ooSNen-FRQOzDLrAOUIVyTYgYryUm2dY-_r8553tSn9n-c-7UUnQq5vNIWPEBgShzwguCUeTgCJAV4yZHT/s640/ksnip_20190423-203545.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<h2 style="clear: both; text-align: left;">
Tema SNS</h2>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeIHXsQtPlRb9EV62X-8mfrKH_EqXV9pab4adFUCCeHlsC0Y1x7slArlTgi9P8XaewKYEsQRliTvRxbcVFCJPtz7nMOwE1YElOefxFM3bZtCE_ZdoPtaDSq3RgBQji2GUmIc2huPYIAitD/s1600/ksnip_20190423-203826.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="215" data-original-width="1261" height="108" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeIHXsQtPlRb9EV62X-8mfrKH_EqXV9pab4adFUCCeHlsC0Y1x7slArlTgi9P8XaewKYEsQRliTvRxbcVFCJPtz7nMOwE1YElOefxFM3bZtCE_ZdoPtaDSq3RgBQji2GUmIc2huPYIAitD/s640/ksnip_20190423-203826.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2vL_MhHMSFUSiw4Brq9KdzqVAQK3HxW_WGDTkvMmHo1_rgrT4uAhOPyEPOvgUWD8eTvNFyHB_GQdDoOUlBP5doI56gHQ5Amrh3EOg8BNExhs7FFwKN5b7YPCwrn7to9YN1IDF9Ow2h135/s1600/ksnip_20190423-204006.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="260" data-original-width="1547" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2vL_MhHMSFUSiw4Brq9KdzqVAQK3HxW_WGDTkvMmHo1_rgrT4uAhOPyEPOvgUWD8eTvNFyHB_GQdDoOUlBP5doI56gHQ5Amrh3EOg8BNExhs7FFwKN5b7YPCwrn7to9YN1IDF9Ow2h135/s640/ksnip_20190423-204006.png" width="640" /></a></div>
<br />
<br />
Le damos a "Crear un Tema", elegimos un nombre y completamos la operación dándole a "Crear un tema".<br />
<br />
Veremos el ARN, más tarde tendremos que acudir a él.<br />
<br />
Ahora crearemos una suscripción.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPUzRKsY-GwrIiJyACLDcRLaeqp9ouCzAuTRNu7nIm_P9XIgA5Q6ReJnzWQeWnBLkctA4KGfnNR5nagbHXlBnuua7S7YbGqqTPDncKbcoJAxw4Iu6AHGGto23tYEdn5MvZ_XT_SpUOxF36/s1600/ksnip_20190423-204415.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="687" data-original-width="1327" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPUzRKsY-GwrIiJyACLDcRLaeqp9ouCzAuTRNu7nIm_P9XIgA5Q6ReJnzWQeWnBLkctA4KGfnNR5nagbHXlBnuua7S7YbGqqTPDncKbcoJAxw4Iu6AHGGto23tYEdn5MvZ_XT_SpUOxF36/s640/ksnip_20190423-204415.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizpjq01ORB5HAo7tHr1TRymBg2IudMFc4PxR2hu5WMcywhnyCxZuY53S_wtOD1haZ_MWocY2Na8aPHuU3yV20ZVeYvyGJsetV4Qu5m7tOVoOYd4eBexagOdMmLKks1Lx_MMYwL4wEQZzlR/s1600/ksnip_20190423-204546.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="568" data-original-width="856" height="424" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizpjq01ORB5HAo7tHr1TRymBg2IudMFc4PxR2hu5WMcywhnyCxZuY53S_wtOD1haZ_MWocY2Na8aPHuU3yV20ZVeYvyGJsetV4Qu5m7tOVoOYd4eBexagOdMmLKks1Lx_MMYwL4wEQZzlR/s640/ksnip_20190423-204546.png" width="640" /></a></div>
<br />
Deberemos de confirmar la suscripción mediante el e-mail que nos llegará.<br />
<br />
Una vez hecho esto podríamos enviar un mensaje de prueba, para comprobar la correcta recepción de éste.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhewrJzOHO9a6I7-1TojxNPe1MMXCbrl12XCOe3B7Nti5Ka2SuHhmuzPKpl83dx97Rgt7godCifaHswgKBM6o5PP56x0q8wNBzzK-lNpctE8DVC9KR9GHpzhdTv7nwnwQB2un0VBS7H1rtH/s1600/ksnip_20190423-205035.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="138" data-original-width="1545" height="56" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhewrJzOHO9a6I7-1TojxNPe1MMXCbrl12XCOe3B7Nti5Ka2SuHhmuzPKpl83dx97Rgt7godCifaHswgKBM6o5PP56x0q8wNBzzK-lNpctE8DVC9KR9GHpzhdTv7nwnwQB2un0VBS7H1rtH/s640/ksnip_20190423-205035.png" width="640" /></a></div>
<br />
<br />
<h2>
Lambda</h2>
Ahora crearemos la función Lambda<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYSYQD34OEOspSDwoVWemc8uGRcLz4ar_OyE8DiAv-V6IcknCS1EE8QJZJbzvn6_C68N1A_z9Zcnu_kzKJ76SmVRbefBAFkcdEeoZhvhqAS1LpLOTAdnQ4wrKM03lfpo_g9SBnFJhyNDrV/s1600/ksnip_20190423-223017.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="356" data-original-width="1600" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYSYQD34OEOspSDwoVWemc8uGRcLz4ar_OyE8DiAv-V6IcknCS1EE8QJZJbzvn6_C68N1A_z9Zcnu_kzKJ76SmVRbefBAFkcdEeoZhvhqAS1LpLOTAdnQ4wrKM03lfpo_g9SBnFJhyNDrV/s640/ksnip_20190423-223017.png" width="640" /></a></div>
<br />
A la que le asignaremos el <b>Rol</b> que creamos en pasos anteriores<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiR7hirUiFsb-6mzGMqMTnzp92WqjebC2YpIjyKh_7A4rOfz0Qd3sshmfCp6s1BBdTbZI9i4XIDZb34ZFextpNxGsbh3xVFTUKn7HItC-__PAcolmS1e0-Vsous5Tai5ULdOZTnaEpXdOG8/s1600/Captura+de+pantalla+de+2019-04-23+22-28-06.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="727" data-original-width="1549" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiR7hirUiFsb-6mzGMqMTnzp92WqjebC2YpIjyKh_7A4rOfz0Qd3sshmfCp6s1BBdTbZI9i4XIDZb34ZFextpNxGsbh3xVFTUKn7HItC-__PAcolmS1e0-Vsous5Tai5ULdOZTnaEpXdOG8/s640/Captura+de+pantalla+de+2019-04-23+22-28-06.png" width="640" /></a></div>
<br />
<br />
Y aquí es donde copiaremos nuestro <b>script, borrando el código que ya hay</b>:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiREN-xNtdy3NfifHQFskznpeUyLGm1Ht0o7A4P8vljD02YEe403KqLzuV1BjLrDQ6XL90IgOqbGr-cV39Ypz7ZXvLPuuw05QHIrpMWmNKvgad1yLXTj8mFSp3U_JnWDfVA7LNNcyry9AzF/s1600/Captura+de+pantalla+de+2019-04-23+23-21-58.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="796" data-original-width="1600" height="318" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiREN-xNtdy3NfifHQFskznpeUyLGm1Ht0o7A4P8vljD02YEe403KqLzuV1BjLrDQ6XL90IgOqbGr-cV39Ypz7ZXvLPuuw05QHIrpMWmNKvgad1yLXTj8mFSp3U_JnWDfVA7LNNcyry9AzF/s640/Captura+de+pantalla+de+2019-04-23+23-21-58.png" width="640" /></a></div>
<br />
<script src="https://gist-it.appspot.com/github.com/evaristorivi/lambda-mfa-checker/blob/master/lambda_function.py"> </script>
<br />
<br />
<a href="https://github.com/evaristorivi/lambda-mfa-checker/blob/master/lambda_function.py" target="_blank">Script V1 (en el siguiente post V2)</a><br />
<br />
Sin olvidarnos de sustituir donde pone:<br />
<<TU ARN TOPIC SNS AQUÍ>>'<br />
sustituimos por el ARN del tema que creamos anteriormente en SNS.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4eIFFwNFJwtGN89hfjwBn0qaLEc7N2gNEHZoUicp-zhGG207r1HnmQ8ovaFljbucx_NBMIwaVrZoXL2sIIGwYOEkhKH0Gkqh8E7-7uUMO8D4qvRfH0d3zTKgbfepJM-rSmst1Kw7ISP6W/s1600/ksnip_20190424-011322.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="299" data-original-width="412" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4eIFFwNFJwtGN89hfjwBn0qaLEc7N2gNEHZoUicp-zhGG207r1HnmQ8ovaFljbucx_NBMIwaVrZoXL2sIIGwYOEkhKH0Gkqh8E7-7uUMO8D4qvRfH0d3zTKgbfepJM-rSmst1Kw7ISP6W/s400/ksnip_20190424-011322.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
Como en este caso concreto de ejemplo, tengo dos usuarios de prueba recién creados, el tiempo de ejecución del script no resultó ser un problema; pero en caso de tener gran cantidad de usuarios de IAM, deberíamos de ampliar el tiempo de espera, si nos encontrásemos con errores de "Tiempo de ejecución máximo excedido"<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQIgXeZ4WIVirjfzAboVWlqQlAG6fqX4HEjh2UrglL7N2FFFRrE7fsNd00fa6OH9aOkon4nllBUH1FS-bg-_uHUkOSiu1kwfpx7ptDgfi9QQC_0xgaVNsjRVngBBOs1kMGeiHNf4BU6zV4/s1600/ksnip_20190423-224547.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="345" data-original-width="800" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQIgXeZ4WIVirjfzAboVWlqQlAG6fqX4HEjh2UrglL7N2FFFRrE7fsNd00fa6OH9aOkon4nllBUH1FS-bg-_uHUkOSiu1kwfpx7ptDgfi9QQC_0xgaVNsjRVngBBOs1kMGeiHNf4BU6zV4/s640/ksnip_20190423-224547.png" width="640" /></a></div>
<br />
<br />
Si le damos a "Guardar" y luego a "Probar" nos aparecerá "Configurar un evento de prueba"<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkW8IHptwgXvInrJpBByuiB4Pqc44XGFO_dE6FvtklKL6cR6BQ8F8UCnm5UK6b5nMb5yBvi-A7qjKZ2u_hthUgOR6aEJsBd0ebu4WB9E416odepLdwCi0OgBcRTvWZbfqV43dcp-GZTmOF/s1600/ksnip_20190423-232530.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="77" data-original-width="885" height="55" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkW8IHptwgXvInrJpBByuiB4Pqc44XGFO_dE6FvtklKL6cR6BQ8F8UCnm5UK6b5nMb5yBvi-A7qjKZ2u_hthUgOR6aEJsBd0ebu4WB9E416odepLdwCi0OgBcRTvWZbfqV43dcp-GZTmOF/s640/ksnip_20190423-232530.png" width="640" /></a></div>
<br />
Yo lo dejé por defecto, y le dí a "Crear"<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFWigh-ww7shusYmWuSGMdecaYkOqFgLnkfGkrGxLUeD-9ZJvQsPhc3-0KCCpBwLAuB8v2EBYCDKCqeQNrobiM_byBjxdYCloxAXEgIKfrnfdubY-xYipptc8ANEsDIwReqocwrfC0fCyp/s1600/Captura+de+pantalla+de+2019-04-23+23-26-56.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="901" data-original-width="819" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFWigh-ww7shusYmWuSGMdecaYkOqFgLnkfGkrGxLUeD-9ZJvQsPhc3-0KCCpBwLAuB8v2EBYCDKCqeQNrobiM_byBjxdYCloxAXEgIKfrnfdubY-xYipptc8ANEsDIwReqocwrfC0fCyp/s320/Captura+de+pantalla+de+2019-04-23+23-26-56.png" width="290" /></a></div>
<br />
<div style="text-align: justify;">
Ahora sí, le damos a "Probar" y si hicimos todo bien, veremos como recibimos en el correo electrónico con el que nos suscribimos al tema SNS, el esperado mensaje:</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqFNe_zZk6FtV-TX8ljhndZ9TCGpgQAOEO1_hUf7XmCaCyU8oz7jD8YN7ibCh_eW6pv69jIgA3SPAlvoZhJnBRmaEHUJbnfNhbocsEOdaittzYtqUAg09enyIZ6FAnxtQRbUfhDYGtUxqd/s1600/Captura+de+pantalla+de+2019-04-23+22-41-01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="271" data-original-width="416" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqFNe_zZk6FtV-TX8ljhndZ9TCGpgQAOEO1_hUf7XmCaCyU8oz7jD8YN7ibCh_eW6pv69jIgA3SPAlvoZhJnBRmaEHUJbnfNhbocsEOdaittzYtqUAg09enyIZ6FAnxtQRbUfhDYGtUxqd/s320/Captura+de+pantalla+de+2019-04-23+22-41-01.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Nos ha llegado solo el mensaje del total de usuarios que no tienen activado MFA.</div>
<div class="separator" style="clear: both; text-align: left;">
Ahora configuraremos la lambda para que el Número máximo de días sea 10 días, en vez de 120 días</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1fQ3D8YmawFwYl5UT2OTFgtAOmWpNHkkKHo9aNcxkwjn_jEgJMehhQHlxnPiVrK_j4zm2Z0sP7CSqxL7zkvBg52Cmq433rNOMCtc_GlrmjAIK_nKPodRAOjQXxCm2-kW4QNCe-azPrQd8/s1600/ksnip_20190423-224209.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="273" data-original-width="375" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1fQ3D8YmawFwYl5UT2OTFgtAOmWpNHkkKHo9aNcxkwjn_jEgJMehhQHlxnPiVrK_j4zm2Z0sP7CSqxL7zkvBg52Cmq433rNOMCtc_GlrmjAIK_nKPodRAOjQXxCm2-kW4QNCe-azPrQd8/s400/ksnip_20190423-224209.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Volvemos a darle a "Probar", y ahora sí, recibimos el mensaje informándonos de los usuarios que han superado el límite de días y siguen con el MFA deshabilitado.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiXPFnqCpmQRPIvGtcBPcsMfrYipbp1gQGqUlfxSmZrh1aN0EMD9Q0hIDrbardAzH86b6wVN4KiRHcvD_IS5UutOBcU2_0S94F4VqYod61gOercCeGJKRLUOHT1_uXM7Dg-YZOVtG4GAGP/s1600/Captura+de+pantalla+de+2019-04-23+22-42-57.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="224" data-original-width="806" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiXPFnqCpmQRPIvGtcBPcsMfrYipbp1gQGqUlfxSmZrh1aN0EMD9Q0hIDrbardAzH86b6wVN4KiRHcvD_IS5UutOBcU2_0S94F4VqYod61gOercCeGJKRLUOHT1_uXM7Dg-YZOVtG4GAGP/s640/Captura+de+pantalla+de+2019-04-23+22-42-57.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<b><br /></b>
<b>y hasta aquí este post;</b> hemos entrado en calor! Espero que haya resultado de interés; en el próximo post, haremos que la Lambda actúe ante una acción desencadenante, y además mejoraremos el código. <a href="https://suevaristo.blogspot.com/2019/05/lambda-mfa-checker-aws-parte-2.html" target="_blank">Ir a Parte 2</a><br />
<br />
Saludos!!!<br />
<br />
<i>PD: en esta ocasión he utilizado <a href="https://www.draw.io/">https://www.draw.io/</a> para diseñar el diagrama. Buenas sensaciones, como <a href="https://www.lucidchart.com/" target="_blank">Lucidchart</a> e incluso mejores.</i><br />
<br />Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com2tag:blogger.com,1999:blog-5423617789065842564.post-49574252417851086412019-04-10T12:28:00.001+02:002019-04-15T13:07:44.056+02:00Bot Telegram para recibir notificaciones de Check_mk<br>
<h2>
Bot Telegram para recibir notificaciones de Check_mk</h2>
<br>
<br>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3XQ5xcHnWvU7WGFC_Hy3FABUsDrcvLTaby6AJ47NiqMuCTQjPFCKJeWv5T252i7IK27ri-miMIzL9LogRNnxbLXw6WFP55HDYbS78xdfXdidjDDAgx1gBeqc4keAKhFyKv7rcz7oPqR9i/s1600/check_mk+telegram.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="578" data-original-width="1131" height="324" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3XQ5xcHnWvU7WGFC_Hy3FABUsDrcvLTaby6AJ47NiqMuCTQjPFCKJeWv5T252i7IK27ri-miMIzL9LogRNnxbLXw6WFP55HDYbS78xdfXdidjDDAgx1gBeqc4keAKhFyKv7rcz7oPqR9i/s640/check_mk+telegram.png" width="640"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<br>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
En esta entrada voy a comentar el proceso de configuración de un bot de telegram que nos notifique de las alertas de nuestro Chek_mk.<br>
<h2>
Creación del bot-Telegram</h2>
<div>
Buscamos @BotFather el padre de todos los bots.</div>
<div>
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZTCBUR_yKgJyAwU_yCSWX03YCU2kDNRl7c4dAblAD8ynXRQ6n3Jhx6ggkda_pVGTm75nmEK-fet_3sxmUeOEVd6jFG658b_Qp8QXKqfdWfAPBMzMZ-v2-HoEJmk3PUVB4s41a-MMbWNaJ/s1600/Screenshot_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="216" data-original-width="397" height="174" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZTCBUR_yKgJyAwU_yCSWX03YCU2kDNRl7c4dAblAD8ynXRQ6n3Jhx6ggkda_pVGTm75nmEK-fet_3sxmUeOEVd6jFG658b_Qp8QXKqfdWfAPBMzMZ-v2-HoEJmk3PUVB4s41a-MMbWNaJ/s320/Screenshot_1.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
Introducimos /newbot o hacemos click en la opción /newbot</div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0MBThMrAbLwvsPNYFfPhpsklNTT7zoGsSYjxQaaZCYEZu0_3UWOv4PucKHW6dVzz7ngZNPZJBiVQE7Yu697jjUiH1CKmsCRqiwNjLQ4HUhFHNNIwZH3z8qFOk-xlERq_Ihm9k0u0tt_01/s1600/Screenshot_2.png" imageanchor="1"><img border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0MBThMrAbLwvsPNYFfPhpsklNTT7zoGsSYjxQaaZCYEZu0_3UWOv4PucKHW6dVzz7ngZNPZJBiVQE7Yu697jjUiH1CKmsCRqiwNjLQ4HUhFHNNIwZH3z8qFOk-xlERq_Ihm9k0u0tt_01/s320/Screenshot_2.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: left;">
Nos pedirá el nombre que queremos ponerle a nuestro bot</div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJr5C_dsNWXpIOkhCgJcrntNwsusaS-lv2sdIXP0fOpxyjM_pafWBxMPTpkHSHeu0xiiLLe8IxYeSMyUuHslbaO9RxDlOx6VzUgWwglJ6KpiikDhiJveREN10Yw26OPsqFMk4HoryNYaiF/s1600/Screenshot_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="609" data-original-width="789" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJr5C_dsNWXpIOkhCgJcrntNwsusaS-lv2sdIXP0fOpxyjM_pafWBxMPTpkHSHeu0xiiLLe8IxYeSMyUuHslbaO9RxDlOx6VzUgWwglJ6KpiikDhiJveREN10Yw26OPsqFMk4HoryNYaiF/s320/Screenshot_3.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<h4 style="clear: both; text-align: left;">
<span style="font-size: large;">Nos informará de cual es el<u> <b>token API</b> </u>de nuestro bot</span></h4>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8FUnMWM7WxxI0NZQ4QrogwZpF6i6BcUhHv8N8msRmGM-j9w7y0XMOvZXA18efVJiAl7myPKhCL8zrIQ39Q4SYzPNZjjaWvXNCFjFWsfmF_ZM0kIPbNr6xwG4UHg52vNt7eJiXrR0rEfac/s1600/Screenshot_4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="443" data-original-width="750" height="189" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8FUnMWM7WxxI0NZQ4QrogwZpF6i6BcUhHv8N8msRmGM-j9w7y0XMOvZXA18efVJiAl7myPKhCL8zrIQ39Q4SYzPNZjjaWvXNCFjFWsfmF_ZM0kIPbNr6xwG4UHg52vNt7eJiXrR0rEfac/s320/Screenshot_4.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: left;">
Si le decimos /mybots</div>
<div class="separator" style="clear: both; text-align: left;">
Podremos seleccionar uno de nuestros bots creados y modificar sus atributos, como por ejemplo, su imagen de avatar</div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTtgASJj2Ge_QH6P3wJs9GQKTxjrbnIx4PuWAU7lVVGTye-7MgcZypW5uHsUcRUrgaqozR7xm-oSlS5ubtmH521_h_wT3T513O33x6Q6zmryk3SSglEtM2PlOJ9jjigw_7ndkNx9StyRfj/s1600/Screenshot_8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="250" data-original-width="615" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTtgASJj2Ge_QH6P3wJs9GQKTxjrbnIx4PuWAU7lVVGTye-7MgcZypW5uHsUcRUrgaqozR7xm-oSlS5ubtmH521_h_wT3T513O33x6Q6zmryk3SSglEtM2PlOJ9jjigw_7ndkNx9StyRfj/s320/Screenshot_8.png" width="320"></a></div>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbmWPvy3dJ-Sro7NmzfD1g91Gvbs1-XrvL6oaiUnyHVottLcUe7fTvLkMF-gERbMHIT5o-oCbGSNIsu2KgWIVLLf94dVYhRiibils6xk87VXwjVdTcYl8BgKzOdOLSfjNyBFUs6982sJJu/s1600/Screenshot_9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="359" data-original-width="638" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbmWPvy3dJ-Sro7NmzfD1g91Gvbs1-XrvL6oaiUnyHVottLcUe7fTvLkMF-gERbMHIT5o-oCbGSNIsu2KgWIVLLf94dVYhRiibils6xk87VXwjVdTcYl8BgKzOdOLSfjNyBFUs6982sJJu/s320/Screenshot_9.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
Y le enviamos la imagen que queramos como avatar:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijEyxMq06PgWLDfgdRi6kDDWs1PYhX8tCOGbhhZZ6ugJ5Bp1a4MpGfKOL-oupRrTAxOQP774ySHu3ZBksr2EXg1yk3mDdzo__yrxOgck8efwTrrhi5P_NwXQIvIcyORhHu1BtRT7bql4KU/s1600/Screenshot_10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="495" data-original-width="758" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijEyxMq06PgWLDfgdRi6kDDWs1PYhX8tCOGbhhZZ6ugJ5Bp1a4MpGfKOL-oupRrTAxOQP774ySHu3ZBksr2EXg1yk3mDdzo__yrxOgck8efwTrrhi5P_NwXQIvIcyORhHu1BtRT7bql4KU/s320/Screenshot_10.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
Asegurarse de enviarlo como foto y no como archivo</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkJRKUsTabpLS2OayPjrrtPyf9BiZbQIJM1iyhZRICim51kiTt_IvRl5XSrrEE6f4lF9poj3uA7WVhTLdMArGa7BNirmg5Gu846Glgc3aW_nEsEhOJzTvO9dAxyIpucF7LpEp15_gq2MQF/s1600/Screenshot_15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="535" data-original-width="697" height="245" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkJRKUsTabpLS2OayPjrrtPyf9BiZbQIJM1iyhZRICim51kiTt_IvRl5XSrrEE6f4lF9poj3uA7WVhTLdMArGa7BNirmg5Gu846Glgc3aW_nEsEhOJzTvO9dAxyIpucF7LpEp15_gq2MQF/s320/Screenshot_15.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<h3 style="clear: both; text-align: left;">
ID Chat</h3>
<div>
Para conocer nuestro ID Chat, tenemos varios métodos. Uno muy sencillo sería hablar con cualquiera de los siguientes bots:</div>
<div>
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLKWuNU3R0AjirYadMrmcWMre0x0VkM7l29GNRZjhWtvlwY15qAhHiyd14M6vzukBy9NYUR8hxq1RiYZtgkX1yHqiqsSBWy8Z-K66UncTafeI8v7LTlKP_Ou7cRoXgdkrQ6F3G_zySHgi1/s1600/Screenshot_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="299" data-original-width="397" height="241" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLKWuNU3R0AjirYadMrmcWMre0x0VkM7l29GNRZjhWtvlwY15qAhHiyd14M6vzukBy9NYUR8hxq1RiYZtgkX1yHqiqsSBWy8Z-K66UncTafeI8v7LTlKP_Ou7cRoXgdkrQ6F3G_zySHgi1/s320/Screenshot_5.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
Diciéndole /start o /getid nos informará de nuestro ID de Chat.</div>
<div class="separator" style="clear: both; text-align: left;">
Mediante este ID luego podremos filtrar que sólo nosotros podamos usar nuestro bot.</div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<h2 style="clear: both; text-align: left;">
Script de notificación telegram - Check_mk</h2>
<div>
Descargamos el script, es una versión modificada del script de "mail"</div>
<div>
<a href="https://github.com/evaristorivi/checkmk_telegram/blob/master/telegram" target="_blank">Descargar script</a></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
Lo debemos de colocar en ~/local/share/check_mk/notifications</div>
<div class="separator" style="clear: both; text-align: left;">
y darle permisos de ejecución</div>
<div class="separator" style="clear: both; text-align: left;">
chmod +x telegram</div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
En nuestro caso, este directorio es:</div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitt7sikOHgh45riIlLslTWAzRiwQfWIISnlcsxu-oRAIvedE9Ff1Zvb3PQXvqeK8ez-ifrnXZwTKIWBsm8PK2WNvDM9dTAydusUHrRtq29SFuOGQSNuZ3QM6OPKmQbuiKclL7iWTFSkhbD/s1600/Screenshot_18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="347" data-original-width="675" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitt7sikOHgh45riIlLslTWAzRiwQfWIISnlcsxu-oRAIvedE9Ff1Zvb3PQXvqeK8ez-ifrnXZwTKIWBsm8PK2WNvDM9dTAydusUHrRtq29SFuOGQSNuZ3QM6OPKmQbuiKclL7iWTFSkhbD/s400/Screenshot_18.png" width="400"></a></div>
<div>
<br></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
Debemos editar las primeras líneas con el TOKEN API y nuestro IDCHAT</div>
<div style="background-color: #1e1e1e; color: #d4d4d4; font-family: Consolas, "Courier New", monospace; font-size: 14px; line-height: 19px; white-space: pre;">
<div>
<span style="color: #6a9955;">### EDITAR AQUI ###</span></div>
<div>
telegram_bot_token = <span style="color: #ce9178;">'EDITAR'</span></div>
<div>
idchat =<span style="color: #ce9178;">'EDITAR'</span></div>
</div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
Reiniciamos nuestro sitio check_mk</div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
omd su [sitio check_mk]</div>
<div class="separator" style="clear: both; text-align: left;">
omd restart</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSCtJ21jlJT44O-K7XiAe23a1-ROje9gfOfpTGpOlKp3ztaTNt79VlGSx3MyZXoAeAiIRvK8PuVDru_1U6hzR2tyoanZkQmGZeL-2wPHwym4tTtfJAnx7ejtniCDotGBeRPqQVcBL_I52M/s1600/Screenshot_11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="386" data-original-width="718" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSCtJ21jlJT44O-K7XiAe23a1-ROje9gfOfpTGpOlKp3ztaTNt79VlGSx3MyZXoAeAiIRvK8PuVDru_1U6hzR2tyoanZkQmGZeL-2wPHwym4tTtfJAnx7ejtniCDotGBeRPqQVcBL_I52M/s320/Screenshot_11.png" width="320"></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div>
<h2>
Configurar alerta</h2>
</div>
<div>
Ahora podemos ir a "Alertas"</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsyy-Xgvhf453aPD-THXl_dUzCJVmTJT9a09d6F4rVE4nhXapOfTYpSnDUA86v72w_wpGPiEGK0so20uzcjangRhOSfeHIJYPLjcPMUpTIFbdca86QopmToCdNZ5CScinTAY0QSmiAPt1d/s1600/Screenshot_12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="844" data-original-width="333" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsyy-Xgvhf453aPD-THXl_dUzCJVmTJT9a09d6F4rVE4nhXapOfTYpSnDUA86v72w_wpGPiEGK0so20uzcjangRhOSfeHIJYPLjcPMUpTIFbdca86QopmToCdNZ5CScinTAY0QSmiAPt1d/s320/Screenshot_12.png" width="126"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAtHdeU9J4P-vZhTEtHN8MHTHadr_X6zykNRjfYy12MC61LvgMnU85OhBzi3rywliJbaJQkSLpekvsyKT0oYmhRwTyBgxzceXlBHIBZ-yltESwODhO2MDDkNRdZo9JasCvCz0i87yk2kea/s1600/Screenshot_13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="180" data-original-width="1600" height="68" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAtHdeU9J4P-vZhTEtHN8MHTHadr_X6zykNRjfYy12MC61LvgMnU85OhBzi3rywliJbaJQkSLpekvsyKT0oYmhRwTyBgxzceXlBHIBZ-yltESwODhO2MDDkNRdZo9JasCvCz0i87yk2kea/s640/Screenshot_13.png" width="640"></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div>
<br></div>
<div>
Y si hicimos todo bien, nos aparecerá un nuevo método "telegram"</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjug5rjkng6X3sAEGUn1X5lfHFNxGwYC-VI5wdeZRqqxHKtihU7LlG5zYkALEhCZAMojsB5eXksEYrMwu3YoCMotwCWIDmBR87mcARHKGRiJsdYHYMsTeRh9IsV66ECEd5kDbhpuJWht2KI/s1600/Screenshot_14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="355" data-original-width="894" height="254" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjug5rjkng6X3sAEGUn1X5lfHFNxGwYC-VI5wdeZRqqxHKtihU7LlG5zYkALEhCZAMojsB5eXksEYrMwu3YoCMotwCWIDmBR87mcARHKGRiJsdYHYMsTeRh9IsV66ECEd5kDbhpuJWht2KI/s640/Screenshot_14.png" width="640"></a></div>
<div>
<br></div>
<div>
<br>
Las alertas comenzarán a llegarnos por Telegram<br>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQgDMYHAYvtDbxFKupZZnXQcWhpsRUmetyLSCF_jWjQym34ZjtYOHzxs29YYiBirZvQYXHVwLYRUar3gUpyDRwrxdESw18vvBSxt_fRhCuDZa1c2DYT2yJ4c-Fy_epMrIQ-pyr2oyuGj6E/s1600/Screenshot_17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="75" data-original-width="391" height="61" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQgDMYHAYvtDbxFKupZZnXQcWhpsRUmetyLSCF_jWjQym34ZjtYOHzxs29YYiBirZvQYXHVwLYRUar3gUpyDRwrxdESw18vvBSxt_fRhCuDZa1c2DYT2yJ4c-Fy_epMrIQ-pyr2oyuGj6E/s320/Screenshot_17.png" width="320"></a></div>
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAFoTgd281kDGJ-HpmNr2et1FAOic9X-bARnngKfoH65PAjm0qOssG1fBlVvYa0QYgcsz-JQ2dENyh4ciK5uN67Ydapm5V-qIfwtKBdxASkLOhNITqghyphenhyphen6G17TAsrN5o4Evms-69toTgDn/s1600/Screenshot_16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="811" data-original-width="876" height="370" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAFoTgd281kDGJ-HpmNr2et1FAOic9X-bARnngKfoH65PAjm0qOssG1fBlVvYa0QYgcsz-JQ2dENyh4ciK5uN67Ydapm5V-qIfwtKBdxASkLOhNITqghyphenhyphen6G17TAsrN5o4Evms-69toTgDn/s400/Screenshot_16.png" width="400"></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
En definitiva, una opción muy interesante como complemento a otros métodos de notificación en los que no dependamos de un servicio externo, como es Telegram.</div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<div class="separator" style="clear: both; text-align: left;">
<br></div>
<br>
<br></div>
Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com10tag:blogger.com,1999:blog-5423617789065842564.post-76384331419101756402019-03-29T14:15:00.003+01:002019-03-29T17:07:57.410+01:00Laboratorio de prueba en AWS<div style="text-align: justify;">
<br /></div>
<h2 style="text-align: justify;">
Laboratorio de prueba en AWS</h2>
<div style="text-align: justify;">
Para terminar el viernes, me propuse crear un pequeño laboratorio para ir cogiendo soltura en AWS.</div>
<div style="text-align: justify;">
De paso, estrenaba <a href="https://www.lucidchart.com/">https://www.lucidchart.com</a> magnífica herramienta; atrás quedaron "los días con DIA". (tengo que probar en otra ocasión <a href="https://www.draw.io/">https://www.draw.io/</a> y <a href="https://cloudcraft.co/">https://cloudcraft.co/</a> también muy recomendables)</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
El laboratorio en cuestión que se me ocurrió fue: probar la alta disponibilidad que proporciona "Auto Scaling" con cuatro instancias EC2 tras un balanceador, estando estas distribuidas en dos zonas de disponibilidad distintas, de la región de Irlanda.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: center;">
<div style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoNtjDhWWovygvGoNDqQWi9-6wa3sW8R89QFHfJveygwofPX9umClsLFaFd7VkvkqKcLm35aePUbOckbSMoitkH8s-8nhyFt7HjvSqbR4gWcnhk-zyRs194cdhjWu8ucTSxpGHdKK_gfpc/s1600/Laboratorio+con+balanceador+de+carga.png" imageanchor="1"><img border="0" height="552" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoNtjDhWWovygvGoNDqQWi9-6wa3sW8R89QFHfJveygwofPX9umClsLFaFd7VkvkqKcLm35aePUbOckbSMoitkH8s-8nhyFt7HjvSqbR4gWcnhk-zyRs194cdhjWu8ucTSxpGHdKK_gfpc/s640/Laboratorio+con+balanceador+de+carga.png" width="640" /></a></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
En definitiva muy divertido!!<br />
Tras haber completado el laboratorio, y aprovechando la infraestructura desplegada, probé el servicio EFS... la ostia.. 8 Exabytes.. 😆😆<br />
<br />
De aquí en adelante seguiré exprimiendo la capa gratuita de AWS y si procede, crearé alguna que otra guía para algún caso concreto.<br />
<br />
<br />
<br />
<br /></div>
</div>
Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com0tag:blogger.com,1999:blog-5423617789065842564.post-71991412682417953402019-01-29T13:08:00.000+01:002019-04-24T01:03:36.068+02:00Interfaces de red "puente" no tienen conectividad virt-manager Docker implicado<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="margin-left: 1em; margin-right: 1em;">
<img alt="Resultado de imagen de docker" src="https://www.docker.com/sites/default/files/social/docker_facebook_share.png" /><img alt="Resultado de imagen de logo virt manager" src="https://avatars3.githubusercontent.com/u/12552438?s=400&v=4" /></div>
<div style="margin-left: 1em; margin-right: 1em;">
<br /></div>
<h2 style="margin-left: 1em; margin-right: 1em;">
Las interfaces de tipo "puente" configuradas en Virt-manager no obtienen conectividad.</h2>
<div>
Teniendo una interfaz de tipo puente"br1" que siempre había tenido conexión con la que sale a internet "eno1", y tras instalar docker pude comprobar que perdió conectividad. Si cambiaba la configuración de las máquinas virtuales QUEMU/KVM de virt-manager para que usaran NAT no había ningún problema, pero con "br1" no obtenían IP.</div>
<div>
<br /></div>
<div style="text-align: left;">
No es lo normal, si tienes docker y virt-manager seguramente no tengas ningún problema.<br />
No se si tuvo que ver que instalé docker-engine un día probando.. no lo tengo claro.</div>
<div style="text-align: left;">
Por lo visto, según comentan <a href="https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=865975" target="_blank">aquí</a>:</div>
<div style="text-align: left;">
<div>
<i>"En Docker 1.12 y versiones anteriores, la política de cadena FORWARD predeterminada fue ACEPTAR. Cuando actualizas a Docker 1.13 o superior, este valor predeterminado se cambia automáticamente..."</i></div>
<div>
<br /></div>
</div>
<div style="text-align: left;">
<br /></div>
<div style="margin-left: 1em; margin-right: 1em;">
<b>Solución:</b></div>
<div style="margin-left: 1em; margin-right: 1em;">
<b><br /></b></div>
<div style="margin-left: 1em; margin-right: 1em;">
Si haces:</div>
<div style="margin-left: 1em; margin-right: 1em;">
iptables -L -v</div>
<div style="margin-left: 1em; margin-right: 1em;">
<br /></div>
<div style="margin-left: 1em; margin-right: 1em;">
y ciertamente la regla FORWARD está en DROP</div>
<div style="margin-left: 1em; margin-right: 1em;">
<br /></div>
<div style="margin-left: 1em; margin-right: 1em;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk9wyk-Vu_ZISYHcDQlhZO2wCl6hLRQ4_XaApMuoV4AkN8R4ZXxBWWBNHPXAWFZY1Ugr5lcPOIe7CXRUcXsngWLetgmt4DJeaRHmXubihQZZ2EqPIDMXvHk_LUZZqsWUHJ0WdixMOYvlQr/s1600/Captura+de+pantalla+de+2019-01-29+13-03-21.png" imageanchor="1"><img border="0" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk9wyk-Vu_ZISYHcDQlhZO2wCl6hLRQ4_XaApMuoV4AkN8R4ZXxBWWBNHPXAWFZY1Ugr5lcPOIe7CXRUcXsngWLetgmt4DJeaRHmXubihQZZ2EqPIDMXvHk_LUZZqsWUHJ0WdixMOYvlQr/s640/Captura+de+pantalla+de+2019-01-29+13-03-21.png" width="640" /></a></div>
<div style="margin-left: 1em; margin-right: 1em;">
<br /></div>
<br />
Cambiamos a ACCEPT<br />
<br />
iptables --policy FORWARD ACCEPT<br />
<div>
<br /></div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNspqWnWT83PMFDh1RgdNlCLoYBkwvJrJgsLw8JBErpoQVQBkpNPZlGH544UIz6xRyj9TOmNMXAlApu-ifTqJAzNdybPBmLgjp53lkgyK5T69Emb7aJAmjyI2uILoKkU5m0Fxwdu5e27C5/s1600/Captura+de+pantalla+de+2019-01-29+13-05-11.png" imageanchor="1"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNspqWnWT83PMFDh1RgdNlCLoYBkwvJrJgsLw8JBErpoQVQBkpNPZlGH544UIz6xRyj9TOmNMXAlApu-ifTqJAzNdybPBmLgjp53lkgyK5T69Emb7aJAmjyI2uILoKkU5m0Fxwdu5e27C5/s640/Captura+de+pantalla+de+2019-01-29+13-05-11.png" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Y todas tus máquinas que estuvieran usando las interfaces tipo puente volverán a tener conectividad.<br />
<br />
<br />
<b>Para hacerlo permanente:</b><br />
Creamos el fichero /etc/docker/daemon.jso si no lo tenemos ya<br />
y le añadimos:<br />
<br />
{<br />
"iptables": false<br />
}<br />
<br />
Eso sí, a partir de ahora tendrás que manipular las regla iptables para permitir el tráfico a tus contenedores.</div>
<div>
<br />
<b>ACTUALIZACIÓN</b></div>
Después de esto, probé a eliminar por completo docker, y volver a instalar docker CE.<br />
Y tras el primer reinicio, seguía en DROP la regla FORWARD pero tras los siguientes reinicios pude comprobar que FORWARD se mantenía en ACCEPT, docker ya solo me modifica las iptables para añadir sus reglas, pero no pone FORWARD en DROP... es decir, el comportamiento normal esperado.<br />
<br />
Así que, solucionado.. pero me queda la intriga de:¿Por qué afecta que esté en DROP, la regla FORWARD, a las MV de virt-manager que estén usando bridges?<br />
<br />
<br />Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com0tag:blogger.com,1999:blog-5423617789065842564.post-22018203683195550722018-11-18T19:23:00.000+01:002018-11-20T04:29:47.001+01:00<div class="separator" style="clear: both; text-align: center;">
<a href="https://lh5.googleusercontent.com/wKoz8XwEhTLzr1034p2eXMzEa8QC1iaV5xcTLyAiVojsy2OMrB8vqmtv9faY0rWA5bLKLeeFcOVgxTVCLW4kcPcD_siWOvKDApoNo20OaYaNJIgqPYZXYPjXuKiD6s3oEzUiC2eB" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="157" src="https://lh5.googleusercontent.com/wKoz8XwEhTLzr1034p2eXMzEa8QC1iaV5xcTLyAiVojsy2OMrB8vqmtv9faY0rWA5bLKLeeFcOVgxTVCLW4kcPcD_siWOvKDApoNo20OaYaNJIgqPYZXYPjXuKiD6s3oEzUiC2eB" style="border: none; transform: rotate(0rad);" width="157" /></a></div>
<b id="docs-internal-guid-aef51ef5-7fff-f307-55a9-006893ab2ba6" style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 24pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">XE - Oracle 18c en Ubuntu</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0R9zdILsyyNqksU845QBALbldymCXYD6wBIcsxL0PQvChWHtscaMeWaGSja8pCXtZwUAce_4tgvD12CRl_fnMPy7oW-xmmncEjar-yw-7dZ_tf23VOxw-5BCtQW0DESMMafjcMQ1DRYXi/s1600/175734-2-300x218.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="218" data-original-width="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0R9zdILsyyNqksU845QBALbldymCXYD6wBIcsxL0PQvChWHtscaMeWaGSja8pCXtZwUAce_4tgvD12CRl_fnMPy7oW-xmmncEjar-yw-7dZ_tf23VOxw-5BCtQW0DESMMafjcMQ1DRYXi/s1600/175734-2-300x218.png" /></a></div>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 13.999999999999998pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: underline; vertical-align: baseline; white-space: pre;">Oracle Database 18c Express Edition </span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://lh6.googleusercontent.com/aOkYjfp5y03UCe8nsbtVEiFzDnpuAeDegfhBIEHJXzbgXeQE84cNe60MX5SJ8TBYnbASOvPb9qnKHUw20t58M_vIfu_r6GRW_Z4TZKeCiHr9nT0PvVA8UZcFNtgUgYnpOg1fGOTA" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="100" src="https://lh6.googleusercontent.com/aOkYjfp5y03UCe8nsbtVEiFzDnpuAeDegfhBIEHJXzbgXeQE84cNe60MX5SJ8TBYnbASOvPb9qnKHUw20t58M_vIfu_r6GRW_Z4TZKeCiHr9nT0PvVA8UZcFNtgUgYnpOg1fGOTA" style="border: none; transform: rotate(0rad);" width="237" /></a></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="font-family: "arial"; font-size: 20pt; white-space: pre-wrap;">Requisitos</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">RAM</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Mínimo 1 gigabyte, recomendado 2 gigabytes.</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Espacio del disco</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Mínimo 10 gigabytes</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">SWAP</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">El espacio mínimo de intercambio recomendado para Oracle Database XE es de 2 GB</span><br />
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">o el doble del tamaño de RAM, lo que sea menor.</span></div>
<h1 dir="ltr" style="line-height: 1.38; margin-bottom: 6pt; margin-top: 20pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 20pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Instalación (en una MV QUEMU/KVM)</span></h1>
<b style="font-weight: normal;">Turorial basado en: </b><a href="https://www.youtube.com/watch?v=2ZCYkGHEwzw">https://www.youtube.com/watch?v=2ZCYkGHEwzw</a> con modificaciones para la versión XE 18c<br />
También me he apoyado en la respuesta de <a aria-describedby="jive-note-user-body" class="jiveTT-hover-user jive-username-link" data-avatarid="-1" data-externalid="" data-presence="null" data-userid="440678" data-username="Yves%20Moriceau-Oracle" href="https://community.oracle.com/people/Yves%20Moriceau-Oracle?customTheme=otn" id="jive-44067818878842530380260" style="border: 0px; box-sizing: content-box !important; color: #4a3f3d; font-family: inherit; font-size: 1.1em; font-style: inherit; font-weight: inherit; margin: 0px; padding: 0px 3px 0px 0px; text-decoration-line: none; vertical-align: baseline; white-space: nowrap;">Yves Moriceau-Oracle</a><span style="background-color: white; color: #999999; font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 12.6px; font-weight: 700; white-space: nowrap;"> </span> en <a href="https://community.oracle.com/thread/4180520?start=0&tstart=0">https://community.oracle.com/thread/4180520?start=0&tstart=0</a><br />
<br />
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: blue; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">[En el anfitrión]</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Dsecargar</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<a href="https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre;">https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html</span></a></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Oracle Database 18c Express Edition for Linux x64</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Convertir el paquete de formato RPM al formato DEB (Este formato es el usado por ubuntu) </span><br />
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">usando el comando alien</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: underline; vertical-align: baseline; white-space: pre;"> (Instalar previamente alien)</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo apt install alien</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo alien --scripts -d oracle-database-xe-18c-1.0-1.x86_64.rpm</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Tardará un GRAN rato, ¡</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: underline; vertical-align: baseline; white-space: pre;">Mucha paciencia!</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> (La razón de ejecutarlo en el anfitrión es para que tarde </span><br />
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">menos que si lo ejecutásemos en la MV, porque tira de bastantes recursos.)</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;"><img height="195" src="https://lh5.googleusercontent.com/YF3lif9bdh3BezshHFByAPSqbjvwlZAcVoeXkM-A3jKDJcSqarn9PYbBNIS5_S5-TeSYYC5Z0EpnJ6_w4jLHb2EARrkJuIf2aLw4ur094Q1dR7nnurJbsW2FoS_FlSqrAQfXMCFz" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="602" /></span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: blue; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Copiar el .deb resultante por SCP a nuestro servidor de Oracle XE en la MV</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: blue; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">scp oracle-database-xe-18c_1.0-2_amd64.deb </span><span style="background-color: transparent; color: blue; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre;">evaristo@192.168.1.27</span><span style="background-color: transparent; color: blue; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">:~</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;"> </span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">[En el servidor Oracle XE en nuestra MV]</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Instalar los paquetes necesarios con el comando:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo apt-get install libaio1 unixodbc</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Crear el script chkconfig requerido usando el comando:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo nano /sbin/chkconfig</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">El editor de texto nano se inició y los comandos se muestran en pantalla. Ahora, copiamos y</span><br />
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> pegamos lo siguiente dentro del fichero y guardamos:</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<br /></div>
<script src="https://gist.github.com/evaristorivi/ac36dcebc7492b3c801e6f1445c1def6.js"></script>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Cambiamos los permisos del fichero chkconfig usando el comando:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo chmod 755 /sbin/chkconfig</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Establecemos los parámetros del kernel.</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo nano /etc/sysctl.d/60-oracle.conf</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Copiamos lo siguiente dentro del fichero y guardamos:</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<br /></div>
<script src="https://gist.github.com/evaristorivi/4442308337c9bd2a68ec2b0443cac358.js"></script>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Verificamos el cambio usando el comando:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo cat /etc/sysctl.d/60-oracle.conf </span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;"><b>Deberíamos ver lo que escribimos anteriormente. Ahora cargamos los parámetros del núcleo:</b></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo service procps start</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Verificamos que los parámetros se cargaron mediante:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo sysctl -q fs.file-max</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Deberíamos poder observar el valor máximo del fichero que introducimos anteriormente.</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Configuramos un punto de montaje /dev/shm para Oracle. Creamos el siguiente fichero </span><br />
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">usando el comando:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo nano /etc/rc2.d/S01shm_load</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;"><b>Copiamos lo siguiente dentro del fichero y guardamos:</b></span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<br /></div>
<script src="https://gist.github.com/evaristorivi/f322fa2571527b123c1f0a32a2e059b0.js"></script>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;"><b>Cambiamos los permisos del fichero usando el comando:</b></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo chmod 755 /etc/rc2.d/S01shm_load</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: underline; vertical-align: baseline; white-space: pre;">*REINICIAMOS NUESTRA MÁQUINA VIRTUAL*</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> </span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">---AHORA SÍ, LA INSTALACIÓN DEL SISTEMA GESTOR---</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Instalamos el sistema gestor de oracle usando el comando:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo dpkg --install oracle-database-xe-18c_1.0-2_amd64.deb</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><img height="111" src="https://lh5.googleusercontent.com/ZPPH2Tw6Fgtlk4Nvx3rqdHgs3gaTGtj-_9nfx5Zz5R99fzqq1ok5pvw1y2yhal6Qov3f6jKBYSnZRfUM6jkaLFopX7md9qqZMXPbMQCm9TbSvwuJG5WLY1Oy8CM_iLg-qZRavlZi" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="602" /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Nos informa de que fichero debemos de editar y que scripts debemos ejecutar como root.</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> </span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Editamos pues el fichero, y añadimos el LISTENER_PORT</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo nano /etc/sysconfig/oracle-xe-18c.conf</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><img height="265" src="https://lh6.googleusercontent.com/sd1FDfbXz5SSmYwZFHoqP6AEkTiC9V5gcOynEIJ4B47E9yjePkXmDDdG97bW2aq3rUyMVQ3BZzZH940ESP060tyL6zINgVgJI7BefbbniNvGBtHCCEe_FRiBCSze5j6bmhMSi-0t" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="602" /></span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Arrancamos el script como root:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo /etc/init.d/oracle-xe-18c configure</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Establecemos la contraseña para SYS</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br class="kix-line-break" /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">La primera vez nos dará Listener configuration failed</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Volvemos a ejecutar el scrript:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo /etc/init.d/oracle-xe-18c configure</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><img height="145" src="https://lh5.googleusercontent.com/oCEIpF1SJyxTccREc07sN7rVfT2FW3jO69fFHMT5Z-iipNoXsfxd7joIUNJ5CBr-mdxnCNn-Lo1hXKIZyv8LjwQzER6jLqkNDa-V0tNsNroIqM3DIhiusLnIjNEIQV2UervEK4dA" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="602" /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span>
<br />
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"></span><br />
<div dir="ltr" style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
</div>
<br />
<div dir="ltr" style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Otro ERROR:</span></div>
<div style="margin: 0px;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></div>
</div>
</div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; clear: left; color: black; float: left; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; margin-bottom: 1em; margin-right: 1em; text-decoration: none; vertical-align: baseline; white-space: pre;"><img height="251" src="https://lh6.googleusercontent.com/QDsjy5reQODKlH_N889xvCjGhow7IVCOzH2jZf8YFUfwbWsma6h4MSV1KM-c6om8uE1EX5KQZKMMcr0QhmvgbRO8vpfzhLQ8Ql5DqrcIuP_OPRPFROHyDBtzpCmBqHPlL9m8YTe-" style="border: none; transform: rotate(0rad);" width="602" /></span><span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"></span><br />
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></span>
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></span>
</div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span>
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span>
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">El error de memoria no debe preocuparnos, optaremos por una ejecución manual.</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Configuramos las variables de entorno editando nuestro fichero .bashrc :</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">nano ~/.bashrc</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<br /></div>
<script src="https://gist.github.com/evaristorivi/08043185a141ffea6a20a5034b82fa26.js"></script>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Ejecutamos los cambios ejecutando nuestro perfil:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">. ~/.profile</span></div>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Agregamos un usuario USUARIO al grupo dba usando el comando:</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo usermod -a -G dba </span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre;">evaristo</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Asignamos password a oracle</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo passwd oracle</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Nos conectamos como oracle</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">su oracle</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Cargamos el .bashrc de nuestro anterior usuario</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">source /home/evaristo/.bashrc</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Creamos la tabla</span><br />
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span> <script src="https://gist.github.com/evaristorivi/c542ef2a15d43a3e90c3cfd44c4487ca.js"></script>
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<img height="193" src="https://lh4.googleusercontent.com/jLAjs0JW324qibu2W2YSBlYlp4sMFzIFL4VAivfnOG6CDr29eDV24OuNxoizo50eQwA2CdeS3VHw_FDqlfy36hiZFXRwYHTX9yrJDTETiPsIuLirfmLj-VhceI5but28OiGNEeUi" style="border: none; font-family: arial; font-size: 11pt; transform: rotate(0rad); white-space: pre;" width="602" /></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Creamos initXE.ora</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">exit</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo su</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">cp /opt/oracle/admin/ora18c/pfile/init.ora</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 9pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre;">.</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 9pt; font-style: italic; font-variant: normal; font-weight: bold; vertical-align: baseline; white-space: pre-wrap;">[xxxxxxx] </span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 9pt; font-variant: normal; vertical-align: baseline; white-space: pre-wrap;"><b style="font-style: italic; text-decoration-line: underline;">/</b>opt/oracle/product/18c/dbhomeXE/dbs/initXE.ora</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-variant: normal; vertical-align: baseline; white-space: pre-wrap;"> </span><br />
<span style="font-family: arial;"><span style="font-size: 14.6667px; white-space: pre-wrap;"><i><u>Esto quiere decir que en /opt/oracle/admin/ora18c/pfile/ se habrá generado un fichero con un nombre X, ese es el que debes de copiar.</u></i></span></span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">chown oracle:oinstall /opt/oracle/product/18c/dbhomeXE/dbs/initXE.ora</span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br class="kix-line-break" /></span><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">exit</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">(estamos en nuestro usuario normal)</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre;">Arrancamos la BD:</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sqlplus / as sysdba</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">startup</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"><br /></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<img height="240" src="https://lh4.googleusercontent.com/0F5DpDsflAeFI6emPPKKeEoSSlATk4pncbIQd3EQf0Tfi2_fX9sr13ecwmBbgfpMw78oFlUdkCORVQl43Cn6VQfI0qCBHwgu4o-aMeeGpzj5ea23Ewrhpuc6JNlaNlBkBndXi3aS" style="border: none; transform: rotate(0rad);" width="430" /></div>
<b style="font-weight: normal;"><br /></b><span style="color: red; font-family: "arial"; font-size: 10pt; font-weight: 700; white-space: pre-wrap;">ORA-00442: Oracle Database Express Edition (XE) single instance violation error</span><br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Si nos diera este error al hacer </span><span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre;">startup</span><span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">, entonces lo solucionamos de la siguiente manera:</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">ps -aux | grep pmon</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">sudo kill <PID oracle></span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre;">#(no el PID del grep)</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;">Y podríamos volver a hacer </span><span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre;">startup</span><span style="background-color: transparent; color: red; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre;"> sin problemas.</span></div>
<br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<br /></div>
<script src="https://raw.github.com/moski/gist-Blogger/master/public/gistLoader.js" type="text/javascript"></script>
Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com7tag:blogger.com,1999:blog-5423617789065842564.post-35366034055047241932018-11-07T05:47:00.003+01:002018-11-18T21:11:19.432+01:00<h2>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwaOKRdEdGTPF_DOdab2_LjQICdKToFgOGgiqg8eLzQ-uLyUJg9tCvmWPle7YtzMs5Nsyoiy0XurGONWPRyx6nojdu5DtxGhoUQHVoZw1oWOtv70oNWkMLPuKVd2KE3Buq2klzCLhJw9vS/s1600/oracleenubuntu.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-right: 1em;"><img alt="" border="0" data-original-height="607" data-original-width="964" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwaOKRdEdGTPF_DOdab2_LjQICdKToFgOGgiqg8eLzQ-uLyUJg9tCvmWPle7YtzMs5Nsyoiy0XurGONWPRyx6nojdu5DtxGhoUQHVoZw1oWOtv70oNWkMLPuKVd2KE3Buq2klzCLhJw9vS/s640/oracleenubuntu.png" title="Oracle 18c en Ubuntu" width="640" /></a></h2>
<div>
<br />
<br />
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
</div>
<br />
<h2 style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
Instalar Oracle Database 18c en Ubuntu 16</h2>
<div>
Oracle Database Enterprise Edition, Oracle Database Standard Edition 2</div>
<div>
<br />
<br />
<br /></div>
Instalar Oracle 18C en Oracle Linux es relativamente fácil, siguiendo guías como:</div>
<div>
<div>
<a href="http://o-dba.blogspot.com/2018/07/oracle-database-18c-on-premise.html">http://o-dba.blogspot.com/2018/07/oracle-database-18c-on-premise.html</a></div>
<div>
<a href="http://o-dba.blogspot.com/2018/07/oracle-database-18c-on-premise_24.html">http://o-dba.blogspot.com/2018/07/oracle-database-18c-on-premise_24.html</a></div>
<div>
</div>
</div>
<div>
<br />
<br /></div>
<div>
Pero si te propones instalar Oracle 18C en Ubuntu, encontrarás guías como:</div>
<div>
<a href="https://soajp.blogspot.com/2016/06/instalar-base-de-datos-oracle-12c-en.html">https://soajp.blogspot.com/2016/06/instalar-base-de-datos-oracle-12c-en.html</a></div>
<div>
<a href="http://informaticadantesca.blogspot.com/2018/02/oracle-12.html">http://informaticadantesca.blogspot.com/2018/02/oracle-12.html</a></div>
<div>
<a href="http://codigo61.blogspot.com/2018/01/como-instalar-oracle-12c-en-linux_12.html">http://codigo61.blogspot.com/2018/01/como-instalar-oracle-12c-en-linux_12.html</a></div>
<div>
<br /></div>
<div>
Instalar dependencias, grupos, usuario oracle, enlaces simbólicos, parchear algunos ficheros... pero siempre se estropea todo con los .mk en mitad de la instalación de Oracle (realmente en mitad no, al 11% siempre)</div>
<div>
Tras muchos cabezazos... con un post u otro logré resolver algunos errores (aunque son para la 12c, casi valen para la 18c) Pero siempre se quedaba colgado en el error:</div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8CVv03yypAuFJYH7cD8atLRxqLPKaw47xy3HJ58Omd2x-zX4y1usvfbN2iDuJcYkUEsFUwIQ637rhR-5mgBHVsNTQYKB2ueTkJpra20UyjudahGphlwWBfS-qaRTUwdnq7Ct1tq32fru1/s1600/WhatsApp+Image+2018-11-05+at+21.43.25+%25282%2529.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="605" data-original-width="776" height="249" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8CVv03yypAuFJYH7cD8atLRxqLPKaw47xy3HJ58Omd2x-zX4y1usvfbN2iDuJcYkUEsFUwIQ637rhR-5mgBHVsNTQYKB2ueTkJpra20UyjudahGphlwWBfS-qaRTUwdnq7Ct1tq32fru1/s320/WhatsApp+Image+2018-11-05+at+21.43.25+%25282%2529.jpeg" width="320" /></a></div>
</div>
<div>
<br /></div>
<div style="text-align: center;">
<b>Problemas con la contrucción de ORAPWD </b></div>
<div style="text-align: center;">
<br /></div>
<div>
La guía que más se aproximaba a casi solucionar el error fue: </div>
<div>
<a href="https://gemsofprogramming.wordpress.com/2013/09/19/installing-oracle-12c-on-ubuntu-12-04-64-bit-a-hard-journey-but-its-worth-it/">https://gemsofprogramming.wordpress.com/2013/09/19/installing-oracle-12c-on-ubuntu-12-04-64-bit-a-hard-journey-but-its-worth-it/</a><br />
<br />
Pero seguíamos igual...el mismo error siempre..<br />
Por suerte, entre los comentarios del post se encontraba el comentario <a class="url" href="http://gravatar.com/olaaronsson" rel="external nofollow" style="background: rgb(255, 255, 255); border: 0px; color: #ff4b33; font-family: Georgia, "Bitstream Charter", serif; font-size: 16px; font-weight: 700; margin: 0px; padding: 0px; vertical-align: baseline;">Ola Aronsson</a> - La solución, un script maravilloso, que comentaremos más adelante en la guía.<br />
<br />
El Script por si solo no es la solución, pero si combinándolo con todo lo aprendido en las anteriores guías.<br />
<br />
Este post pretende ser una guía práctica para Instalar Oracle 18C en Ubuntu, paso por paso.</div>
<div>
<br /></div>
<div>
<h2>
Requisitos:</h2>
<div>
<table border="1" cellpadding="4" cellspacing="0" class="Formal" frame="hsides" rules="rows" style="background-color: white; border-collapse: collapse; border-spacing: 0px; box-sizing: border-box; color: #333333; font-family: "Helvetica Neue", "Segoe UI", Roboto, sans-serif-regular, sans-serif; font-size: 14px; min-width: 420px; table-layout: fixed; width: 100%px;" summary="This 2-column table shows Server hardware checklist for Oracle Database installations. Column 1 is the checklist item, column 2 describes the tasks for that item." title="Lista de comprobación del hardware del servidor para la instalación de la base de datos Oracle"><tbody style="box-sizing: border-box;">
<tr align="left" style="border-bottom: 2px solid rgb(63, 63, 63); box-sizing: border-box; padding: 8px 6px; vertical-align: top;" valign="top"><td align="left" headers="d3653e28 " id="d3653e56" style="box-sizing: border-box; overflow-wrap: break-word; padding: 8px;" valign="top" width="20%"><span style="box-sizing: border-box; vertical-align: inherit;"><span style="box-sizing: border-box; vertical-align: inherit;"><b>Memoria RAM mínima</b></span></span></td><td align="left" headers="d3653e56 d3653e30 " style="box-sizing: border-box; overflow-wrap: break-word; padding: 8px;" valign="top" width="20%"><ul style="box-sizing: border-box; margin-bottom: 10px; margin-top: 0px;">
<li style="box-sizing: border-box;"><div style="box-sizing: border-box; margin-bottom: 14px;">
<span style="box-sizing: border-box;"><span style="box-sizing: border-box; vertical-align: inherit;"><b><span style="box-sizing: border-box; vertical-align: inherit;">Al menos 1 GB de RAM para las instalaciones de la base de datos Oracle. </span><span style="box-sizing: border-box; vertical-align: inherit;">Se recomienda 2 GB de RAM.</span></b></span></span></div>
</li>
<li style="box-sizing: border-box;"><div style="box-sizing: border-box; margin-bottom: 14px;">
<span style="box-sizing: border-box;"><b>Al menos 8 GB de RAM para las instalaciones de Oracle Grid Infrastructure.</b></span></div>
</li>
</ul>
</td></tr>
</tbody></table>
</div>
<h2>
<table border="1" cellpadding="4" cellspacing="0" class="Formal" frame="hsides" rules="rows" style="background-color: white; border-collapse: collapse; border-spacing: 0px; box-sizing: border-box; color: #333333; font-family: "Helvetica Neue", "Segoe UI", Roboto, sans-serif-regular, sans-serif; font-size: 14px; min-width: 420px; table-layout: fixed; width: 100%px;" summary="This 2-column table shows the server configuration checklist for Oracle Database installations. Column 1 is the checklist item, column 2 describes the tasks for that item." title="Lista de verificación de la configuración del servidor para la base de datos Oracle"><tbody style="box-sizing: border-box;">
<tr align="left" style="border-bottom: 1px solid rgb(63, 63, 63); box-sizing: border-box; padding: 8px 6px; vertical-align: top;" valign="top"><td align="left" headers="d4322e48 " id="d4322e67" style="box-sizing: border-box; overflow-wrap: break-word; padding: 8px;" valign="top" width="20%"><div style="box-sizing: border-box;">
<span style="box-sizing: border-box; vertical-align: inherit;"><b>Asignación de espacio de intercambio relativa a la RAM (base de datos Oracle)</b></span></div>
</td><td align="left" headers="d4322e67 d4322e50 " style="box-sizing: border-box; overflow-wrap: break-word; padding: 8px;" valign="top" width="20%"><div style="box-sizing: border-box;">
<span style="box-sizing: border-box; vertical-align: inherit;"><b>Entre 1 GB y 2 GB: 1.5 veces el tamaño de la RAM </b></span><br />
<span style="box-sizing: border-box; vertical-align: inherit;"><b>Entre 2 GB y 16 GB: Igual al tamaño de la RAM </b></span><br />
<span style="box-sizing: border-box; vertical-align: inherit;"><b>Más de 16 GB: 16 GB </b></span></div>
</td></tr>
</tbody></table>
</h2>
<h2>
<table border="1" cellpadding="4" cellspacing="0" class="Formal" frame="hsides" rules="rows" style="background-color: white; border-collapse: collapse; border-spacing: 0px; box-sizing: border-box; color: #333333; font-family: "Helvetica Neue", "Segoe UI", Roboto, sans-serif-regular, sans-serif; font-size: 14px; min-width: 420px; table-layout: fixed; width: 100%px;" summary="This 2-column checklist shows the minimum storage requirements and the configuration planning checklist for Oracle Database. Column 1 is the checklist item, column 2 describes the tasks for that item." title="Lista de verificación de almacenamiento para la base de datos Oracle"><tbody style="box-sizing: border-box;">
<tr align="left" style="border-bottom: 1px solid rgb(63, 63, 63); box-sizing: border-box; padding: 8px 6px; vertical-align: top;" valign="top"><td align="left" headers="d5338e17 " id="d5338e23" style="box-sizing: border-box; overflow-wrap: break-word; padding: 8px;" valign="top" width="20%"><span style="box-sizing: border-box; vertical-align: inherit;"><span style="box-sizing: border-box; vertical-align: inherit;"><b>Espacio mínimo de almacenamiento en disco local para el software Oracle</b></span></span></td><td align="left" headers="d5338e23 d5338e19 " style="box-sizing: border-box; overflow-wrap: break-word; padding: 8px;" valign="top" width="20%"><div style="box-sizing: border-box; margin-bottom: 14px;">
<span style="box-sizing: border-box; vertical-align: inherit;"><b>Para Linux x86-64: </b></span><br />
<span style="box-sizing: border-box; vertical-align: inherit;"><b>al menos 6.8 GB para una infraestructura de Oracle Grid para una instalación de servidor independiente. </b></span><br />
<span style="box-sizing: border-box; vertical-align: inherit;"><b>Al menos 7.5 GB para Oracle Database Enterprise Edition. </b></span><br />
<span style="box-sizing: border-box; vertical-align: inherit;"><b>Al menos 7.5 GB para Oracle Database Standard Edition 2. </b></span></div>
</td></tr>
</tbody></table>
</h2>
<h2>
Comenzamos:</h2>
<br />
Tenemos en una MV con QUEMU/KVM un Ubuntu Server 16.04 donde instalaremos Oracle 18c<br />
<br />
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="color: blue;">[En equipo anfitrión:]</span></div>
</div>
</div>
<div>
Descargamos el ZIP: <a href="https://www.oracle.com/technetwork/es/database/enterprise-edition/downloads/index.html">https://www.oracle.com/technetwork/es/database/enterprise-edition/downloads/index.html</a></div>
<div>
<span id="goog_1330012806"></span><span id="goog_1330012807"></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0-5ENgvGh7wpDVmLPGdSOj-o66D8WoXM8CdnKEjkNmgZyE4S3U_cEoDcFlwfako1tLA8_BiSLYTpfLQmshnTMtSv0vKFD6XsI6S2WZ0oDWtRqwSRttYii9duv0kNfK_dzy57Od6BdzvrX/s1600/Captura+de+pantalla+de+2018-11-07+01-56-56.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="331" data-original-width="523" height="251" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0-5ENgvGh7wpDVmLPGdSOj-o66D8WoXM8CdnKEjkNmgZyE4S3U_cEoDcFlwfako1tLA8_BiSLYTpfLQmshnTMtSv0vKFD6XsI6S2WZ0oDWtRqwSRttYii9duv0kNfK_dzy57Od6BdzvrX/s400/Captura+de+pantalla+de+2018-11-07+01-56-56.png" width="400" /></a></div>
<br />
<br /></div>
<div>
<span style="color: red;">[Servidor:]</span><br />
sudo apt update</div>
<div>
sudo apt upgrade</div>
<div>
<br />
Instalamos ssh para acceder de manera más cómoda mediante nuestra terminal</div>
<div>
sudo apt install ssh</div>
<div>
<br /></div>
<div>
Vemos con ifconfig que ip tenemos en el servidor y la apuntamos para conectarnos por ssh</div>
<div>
<span style="color: blue;"><br /></span>
<span style="color: blue;">[En equipo anfitrión:]</span></div>
<div>
ssh evaristo@192.168.1.21</div>
<div>
<br /></div>
<div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
</div>
<br />
<div style="text-indent: 0px;">
<div style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="color: red;">[Servidor:]</span><br />
<span style="color: red;"></span><br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<div style="margin: 0px;">
Ya estamos en el Servidor mediante ssh, y podremos copiar y pegar los siguientes comandos:<br />
<br />
sudo su<br />
<div>
<br /></div>
</div>
</div>
</div>
<div style="margin: 0px;">
<div style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
Dependencias:</div>
<h4 style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
</h4>
<script src="https://gist.github.com/evaristorivi/8456b2f79c4eb5fff828a407ffd5ff92.js"></script>
<br />
<div style="color: black; font-family: "Times New Roman"; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<div style="margin: 0px;">
apt update</div>
</div>
</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<div style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
</div>
<script src="https://gist.github.com/evaristorivi/b27e2634d47ef1add1e8e826a48586ed.js"></script>
<br />
<div style="color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />
<br /></div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
Como a veces, al copiar y pegar de páginas, se producen errores por caracteres invisibles, los códigos que se que darían fallo están incrustados en cajas de GitHubGist, por lo que no tendrás problemas.</div>
<div style="color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
</div>
</div>
</div>
<div>
<h4>
Creación de grupos y usuario oracle</h4>
</div>
<div>
groupadd -g 502 oinstall</div>
<div>
groupadd -g 503 dba</div>
<div>
groupadd -g 504 oper</div>
<div>
groupadd -g 505 asmadmin</div>
<div>
useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle</div>
<div>
passwd oracle</div>
<div>
<h4>
<span style="font-family: "times new roman";">Ficheros de instalación:</span></h4>
<div style="orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; widows: 2;">
<h4>
<div>
<h4>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<div>
</div>
</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<div>
<span style="color: blue;">[En equipo anfitrión:]</span></div>
Copiamos mediante ssh el ZIP que descargamos antes al servidor:</div>
<div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
scp LINUX.X64_180000_db_home.zip oracle@192.168.1.21:~</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<div>
<div style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
Descargamos el Script: <a href="https://mega.nz/#!SGZWBIxb!TP0jDgfKeihZ1q-ZE8YOggiSDNF4xWN2lir6ErIk_LQ">https://mega.nz/#!SGZWBIxb!TP0jDgfKeihZ1q-ZE8YOggiSDNF4xWN2lir6ErIk_LQ</a></div>
<div style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<div style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="font-weight: 400;">y también lo copiamos al servidor, </span>pero a nuestro usuario,<span style="font-weight: 400;"> no al de oracle:</span></div>
<span style="font-family: "times new roman";"><span style="font-weight: 400;">scp prepareToInstallOracle18.sh evaristo@192.168.1.21:~</span></span><br />
<span style="font-family: "times new roman";"><span style="font-weight: 400;"><br /></span></span></div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<blockquote class="tr_bq" style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<i> (El script de Ola Aronsson original: <a href="https://www.nollettnoll.net/oracle/prepareToInstallOracle.sh">https://www.nollettnoll.net/oracle/prepareToInstallOracle.sh</a></i></blockquote>
<blockquote class="tr_bq" style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<i>Sacado de este post: <a href="https://gemsofprogramming.wordpress.com/2013/09/19/installing-oracle-12c-on-ubuntu-12-04-64-bit-a-hard-journey-but-its-worth-it/#comment-1038">https://gemsofprogramming.wordpress.com/2013/09/19/installing-oracle-12c-on-ubuntu-12-04-64-bit-a-hard-journey-but-its-worth-it/#comment-1038</a></i></blockquote>
<blockquote class="tr_bq" style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<i>Está hecho para Oracle 12c pero funciona </i>con 18C </blockquote>
<blockquote class="tr_bq" style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
En el de mi enlace de mega le he comentado una línea que creaba directorios que no me interesaban. </blockquote>
<blockquote class="tr_bq" style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<i>La línea en cuestión es:</i> </blockquote>
<blockquote class="tr_bq" style="color: black; font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="font-weight: 400;"><i>Línea 77: #export ORACLE_HOME=/opt/oracle/app/oracle/product/12.1.0/dbhome_1\n\</i></span><i>)</i></blockquote>
</div>
</h4>
</div>
</h4>
</div>
</div>
<h4>
</h4>
<h4>
Variables y directorios
</h4>
<div>
mkdir /u01<br />
<div style="orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; widows: 2;">
<div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
chown oracle:oinstall /u01</div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
Instalamos unzip<br />
apt install unzip</div>
<div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
Fichero .bashrc de oracle: </div>
<span style="font-family: "times new roman";">nano /home/oracle/.bashrc</span><br />
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
y copiamos al final del todo, el contenido el siguiente fichero:</div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
<a href="https://mega.nz/#!WOgxDK7T!_2P4FnY3MSB3dRRzvA9LV9oG8F2TRnHzCd7g5KLB_gg">https://mega.nz/#!WOgxDK7T!_2P4FnY3MSB3dRRzvA9LV9oG8F2TRnHzCd7g5KLB_gg</a><br />
<span style="font-family: "times new roman";"><br /></span>
<br />
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
Guardamos y cerramos.</div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
</div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br />
Nos conectamos como Oracle</div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
su oracle</div>
</div>
<div style="font-family: "times new roman"; font-size: medium; font-style: normal; font-weight: 400; letter-spacing: normal; margin: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
mkdir -p /u01/app/oracle/product/183/dbhome_1</div>
</div>
</div>
<div>
<br />
<b>El destino de la descompresión será el directorio creado anteriormente:</b><br />
unzip LINUX.X64_180000_db_home.zip -d /u01/app/oracle/product/183/dbhome_1/<br />
<br />
Volvemos a nuestro usuario con el que estábamos antes de conectarnos como oracle<br />
exit<br />
<br />
<h4>
Preparando el sistema:</h4>
(Necesitamos ser root para ejecutar el siguiente script)<br />
sudo su<br />
<br />
Cargamos el .bashrc de Oracle<br />
source /home/oracle/.bashrc<br />
<br />
chmod +x prepareToInstallOracle18.sh<br />
./prepareToInstallOracle18.sh<br />
<br />
Nos preguntará cuántos GBs podrá aprovechar Oracle<br />
El script comenzará a preparar el sistema para hacer compatible la instalación de Oracle 18c<br />
Algunos de los pasos ya los hemos hecho nosotros, Dependencias...los grupos, el usuario oracle... (que de hecho nos volverá a pedir una nueva clave para oracle) [Pero por ejemplo el grupo oper que nosotros hemos creado no lo contemplaría el script, ni tampoco la creación de los directorios que queríamos]<br />
<br />
Creará enlaces simbólicos necesarios...<br />
Luego parcheará los ficheros sysctl.cnf y limits.conf<br />
<br />
El script comprobará si nos faltase alguna dependencia, y posteriormente, parcheará los ficheros de configuración .mk (si, los famosos .mk que tantos dolores de cabeza dan cuando comienzan a saltar en la instalación de Oracle, los errores tipo: "Error al llamar al destino..." y aquí está lo mejor de este script, pues en numerosas pruebas intentando conseguir esta instalación, habiendo hecho todo manualmente, siempre me quedaba atascado en esta parte de parchear los ficheros .mk<br />
Son muchas líneas a parchear y siempre lo hacía mal... Gracias a este Script.. RESUELTO! (gracias de nuevo al señor Ola Aronsson)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8MZLWftSbJhJU5dtDgejFiqhn5EEOWp-Ph4S-99eTJAdkJHy9xp4gybx48rAYJF51zvOVnQ3nOkQERDcC7DEq4w0Uw1uGTQftzaVQlq-knvr22lgkNpnwZNEBjOZDx61-vkJVLghpfI6I/s1600/Captura+de+pantalla+de+2018-11-07+03-06-25.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black;"><img border="0" data-original-height="739" data-original-width="708" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8MZLWftSbJhJU5dtDgejFiqhn5EEOWp-Ph4S-99eTJAdkJHy9xp4gybx48rAYJF51zvOVnQ3nOkQERDcC7DEq4w0Uw1uGTQftzaVQlq-knvr22lgkNpnwZNEBjOZDx61-vkJVLghpfI6I/s1600/Captura+de+pantalla+de+2018-11-07+03-06-25.png" /></span></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
Cuando termine, pondrá<br />
You are done.<br />
<div>
<br /></div>
<h4>
Instalación Oracle 18C</h4>
Salimos de la sesión ssh (Importante)<br />
exit<br />
exit<br />
<br /></div>
<div>
Volvemos a entrar pero de la siguiente manera (Habilita el reenvío X11):<br />
<br /></div>
<div>
ssh -X oracle@192.168.1.21<br />
<br /></div>
<div>
/u01/app/oracle/product/183/dbhome_1/runInstaller<br />
<br />
<br />
Paciencia, tardará unos segundos en aparecer la ventana:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqiruo00wQRW7btNJyLa3DwDUrZCIurBWdTg9_8UUNQIGRWIIL9umqVC2n-lm9oyDh3sdda2dUG4AuZGYk15XbZhUKZCmUH9ggpx76a9Z-8K0m_GT-I6tPB7Ljy9HT6CX5Cq0iq3RqcUs2/s1600/Captura+de+pantalla+de+2018-11-07+04-36-51.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="269" data-original-width="464" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqiruo00wQRW7btNJyLa3DwDUrZCIurBWdTg9_8UUNQIGRWIIL9umqVC2n-lm9oyDh3sdda2dUG4AuZGYk15XbZhUKZCmUH9ggpx76a9Z-8K0m_GT-I6tPB7Ljy9HT6CX5Cq0iq3RqcUs2/s1600/Captura+de+pantalla+de+2018-11-07+04-36-51.png" /></a></div>
<br /></div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgYyPyUT0odyAYYT7qwF-yiQkrYXCdYQP2amuIG5uUWBjg7Mv8hq2aHu-FXw7j8pbFAFPW_VBcpJDXjw4CR89pHW6sbcfyJZxkpnNevKM90VOkV1QhyphenhyphenWHQth79eUkhpC7Hll0CzX6P_zl_/s1600/Captura+de+pantalla+de+2018-11-07+04-37-21.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="191" data-original-width="505" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgYyPyUT0odyAYYT7qwF-yiQkrYXCdYQP2amuIG5uUWBjg7Mv8hq2aHu-FXw7j8pbFAFPW_VBcpJDXjw4CR89pHW6sbcfyJZxkpnNevKM90VOkV1QhyphenhyphenWHQth79eUkhpC7Hll0CzX6P_zl_/s1600/Captura+de+pantalla+de+2018-11-07+04-37-21.png" /></a></div>
<br />
<br />
Le decimos que Sí<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIWs4gpLmqSpfGi-cYlmkduaf-GHEh77DrgbYw5aIKFam-6WBH794DOP4pBk1DvmSzxlEDGd2ap9Jmfy1mZOdKV4ULBAoHicq9YwBiGgoGnazlvoRxdzqYHjSN1Kcr3Dvl4xZy8-MfCkfU/s1600/Captura+de+pantalla+de+2018-11-07+04-37-48.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="597" data-original-width="799" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIWs4gpLmqSpfGi-cYlmkduaf-GHEh77DrgbYw5aIKFam-6WBH794DOP4pBk1DvmSzxlEDGd2ap9Jmfy1mZOdKV4ULBAoHicq9YwBiGgoGnazlvoRxdzqYHjSN1Kcr3Dvl4xZy8-MfCkfU/s640/Captura+de+pantalla+de+2018-11-07+04-37-48.png" width="640" /></a></div>
<br /></div>
<div>
<br /></div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOB6cgwpqgq3PhO5TVS5KS41l4ouzPmqzVcfZzGflmP4OcYgl4YmAOUENyvObT2zKa8SIZz8p6qmJjw03zwa9lg6YpkQl9ekquY_v0Iz04Pcgki2ruxn8TsQ5pUdsHPP-9UPsfg2Ww1DGi/s1600/Captura+de+pantalla+de+2018-11-07+04-37-57.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="592" data-original-width="802" height="472" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOB6cgwpqgq3PhO5TVS5KS41l4ouzPmqzVcfZzGflmP4OcYgl4YmAOUENyvObT2zKa8SIZz8p6qmJjw03zwa9lg6YpkQl9ekquY_v0Iz04Pcgki2ruxn8TsQ5pUdsHPP-9UPsfg2Ww1DGi/s640/Captura+de+pantalla+de+2018-11-07+04-37-57.png" width="640" /></a></div>
<br />
<h2>
¿18c o 18c Enterprise?</h2>
</div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBBUzNwLT-CH-4F7rCT-NQ0vbR3eRfOt5OCqfZXkLVvCLnFGw8SfZLRGI0zIE3AYz6xhli5nC6H0bRyZsD3uL_BF8-kIHD_HBJaNbR_fRit8M7g1aHce0lF-hxq45WqwNm0IyaeV02Ed8N/s1600/Captura+de+pantalla+de+2018-11-07+04-38-04.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="597" data-original-width="800" height="476" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBBUzNwLT-CH-4F7rCT-NQ0vbR3eRfOt5OCqfZXkLVvCLnFGw8SfZLRGI0zIE3AYz6xhli5nC6H0bRyZsD3uL_BF8-kIHD_HBJaNbR_fRit8M7g1aHce0lF-hxq45WqwNm0IyaeV02Ed8N/s640/Captura+de+pantalla+de+2018-11-07+04-38-04.png" width="640" /></a></div>
<br /></div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiWo6_p3jXmyGDRMczlnZSLM2b22J8wYXIdvV6vNnWT_uKQTmYTq2fLgYbiOP30erL58vj76ueze0AUzkbW0zpGxRgCP2ID4dbtwy7IVVIsOtdcZZsNfd2nevzEm5TJs6ahzk-vtQ9fdzV/s1600/Captura+de+pantalla+de+2018-11-07+04-38-11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="601" data-original-width="792" height="485" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiWo6_p3jXmyGDRMczlnZSLM2b22J8wYXIdvV6vNnWT_uKQTmYTq2fLgYbiOP30erL58vj76ueze0AUzkbW0zpGxRgCP2ID4dbtwy7IVVIsOtdcZZsNfd2nevzEm5TJs6ahzk-vtQ9fdzV/s640/Captura+de+pantalla+de+2018-11-07+04-38-11.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXshO_HWK495qfkwdORuy_o9VGtyQ-ofY_w26b8P66cnr1mhwwBLE1iMROYiJ2I6C0GmdAAKuvTEIzTO0KGnRXMXDb9EVZMMIK_bs0RpL96EebROLBxixebng-T4RQ-pJfAkNypN_96i41/s1600/Captura+de+pantalla+de+2018-11-07+04-38-19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="600" data-original-width="800" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXshO_HWK495qfkwdORuy_o9VGtyQ-ofY_w26b8P66cnr1mhwwBLE1iMROYiJ2I6C0GmdAAKuvTEIzTO0KGnRXMXDb9EVZMMIK_bs0RpL96EebROLBxixebng-T4RQ-pJfAkNypN_96i41/s640/Captura+de+pantalla+de+2018-11-07+04-38-19.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfeE_V_zpIvwFxdm_LgFld-m8T067pCLacma8_TXpCZLw4jXAvyLA6-6G_cOiSnkebXn5EnkXwxfIbXMuf_-XRShOdQTgPdNfh6FmFjoLUmYBx0ozstLlOx29dc8NpDxh8EqSuUMXSGRzq/s1600/Captura+de+pantalla+de+2018-11-07+04-38-26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="597" data-original-width="803" height="474" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfeE_V_zpIvwFxdm_LgFld-m8T067pCLacma8_TXpCZLw4jXAvyLA6-6G_cOiSnkebXn5EnkXwxfIbXMuf_-XRShOdQTgPdNfh6FmFjoLUmYBx0ozstLlOx29dc8NpDxh8EqSuUMXSGRzq/s640/Captura+de+pantalla+de+2018-11-07+04-38-26.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8oL5Cj0hEDkfFUXzBteqR-CAioF4vtaBhlldQDLkb1hbaRmXnujsC-7q3TQ81Ab5COhUi93hQLDn99lWmjLoxlBItoHtpANMfmAZrYViC7r0JzNSdOXtLoa3jgMXoH_jlw0fh5cu4XnTw/s1600/Captura+de+pantalla+de+2018-11-07+04-38-36.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="598" data-original-width="808" height="472" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8oL5Cj0hEDkfFUXzBteqR-CAioF4vtaBhlldQDLkb1hbaRmXnujsC-7q3TQ81Ab5COhUi93hQLDn99lWmjLoxlBItoHtpANMfmAZrYViC7r0JzNSdOXtLoa3jgMXoH_jlw0fh5cu4XnTw/s640/Captura+de+pantalla+de+2018-11-07+04-38-36.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoTSoloBN-ipnmpISl9bh8pusMd_rmi0d9OUL_Qe24_1QX3JWt86LNiFf5g6M4g6x2bsYteyhMkUFPdriLFU3Q12KAmnuMvDQ0RX9bfc753qu06wmkysLU2HiANoe1rkwMcNVF2RAK4GTL/s1600/Captura+de+pantalla+de+2018-11-07+04-41-43.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="800" height="474" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoTSoloBN-ipnmpISl9bh8pusMd_rmi0d9OUL_Qe24_1QX3JWt86LNiFf5g6M4g6x2bsYteyhMkUFPdriLFU3Q12KAmnuMvDQ0RX9bfc753qu06wmkysLU2HiANoe1rkwMcNVF2RAK4GTL/s640/Captura+de+pantalla+de+2018-11-07+04-41-43.png" width="640" /></a></div>
<br />
Para los que vengan de darse cabezazos con los .mk, respirar tranquilos, la barra no se detendrá, se instalará sin sobresaltos.<br />
<br />
Luego saldrá esta ventana:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNBWGBUggvyMx6Qr6KMHeaUmS2cMAE7-0dwG2HgDIf5rsmwPi4KpFOMulxYl2NMZcdOE1BVK9GJ2gyGp6j-Ay-cE5ErKQha3Ev25oN_jJQGDWjI_Yul8CLhqhwcxUp7yXG9ANqrMmtER4b/s1600/Captura+de+pantalla+de+2018-11-07+04-43-00.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="486" data-original-width="678" height="458" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNBWGBUggvyMx6Qr6KMHeaUmS2cMAE7-0dwG2HgDIf5rsmwPi4KpFOMulxYl2NMZcdOE1BVK9GJ2gyGp6j-Ay-cE5ErKQha3Ev25oN_jJQGDWjI_Yul8CLhqhwcxUp7yXG9ANqrMmtER4b/s640/Captura+de+pantalla+de+2018-11-07+04-43-00.png" width="640" /></a></div>
<br />
Le hacemos caso:<br />
<br />
Con una nueva terminal, hacemos un nuevo ssh (sin cerrar la otra)<br />
ssh evaristo@192.168.1.21<br />
<br />
sudo su<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp2gvpvD2tRzKeEaZT5uywxMsFaw4dp19RmU5Qb2mYnniTsMBgEH4m_FllFMQtF2RKSJb6ONDJ7ErvY4mHiuY0M6E4ZBqI_oCYTAP9rCtcx1DbtdwXP1Ap16i5XxKgPPIhc0auaMcqpm3C/s1600/Captura+de+pantalla+de+2018-11-07+04-44-34.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="145" data-original-width="688" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp2gvpvD2tRzKeEaZT5uywxMsFaw4dp19RmU5Qb2mYnniTsMBgEH4m_FllFMQtF2RKSJb6ONDJ7ErvY4mHiuY0M6E4ZBqI_oCYTAP9rCtcx1DbtdwXP1Ap16i5XxKgPPIhc0auaMcqpm3C/s1600/Captura+de+pantalla+de+2018-11-07+04-44-34.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJNlqMwg-g-TFK2I6jsOkamx3uA7LP_nTzMCRjBORmblc9aES9b329d_R5L8DrXrwaUu10xZEdq0LZpvKOHUi-5DyyZocvQLsAP5p7mAUHV-S4wjcZLjc8SYU6wxwxSDIBvPvEN3aKD92s/s1600/Captura+de+pantalla+de+2018-11-07+04-45-29.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="434" data-original-width="922" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJNlqMwg-g-TFK2I6jsOkamx3uA7LP_nTzMCRjBORmblc9aES9b329d_R5L8DrXrwaUu10xZEdq0LZpvKOHUi-5DyyZocvQLsAP5p7mAUHV-S4wjcZLjc8SYU6wxwxSDIBvPvEN3aKD92s/s1600/Captura+de+pantalla+de+2018-11-07+04-45-29.png" /></a></div>
<br />
Pulsamos en Aceptar en la ventana anterior<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7YZqUMEXBIsXa9-GA9KFDAgwlOMiTYOn3qhdtlpQRqk3xacyGCmMdLanU0u4DynA_lwEsEvKXH7Zfxg0cYCbW91kXUaa_cLGALvNU8jHTr4Js9WTE8bGvy_HfD6VOKSbJ-8T-EWfNXfTZ/s1600/Captura+de+pantalla+de+2018-11-07+04-46-37.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="600" data-original-width="808" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7YZqUMEXBIsXa9-GA9KFDAgwlOMiTYOn3qhdtlpQRqk3xacyGCmMdLanU0u4DynA_lwEsEvKXH7Zfxg0cYCbW91kXUaa_cLGALvNU8jHTr4Js9WTE8bGvy_HfD6VOKSbJ-8T-EWfNXfTZ/s1600/Captura+de+pantalla+de+2018-11-07+04-46-37.png" /></a></div>
<br />
y finalizamos.<br />
<br />
Ahora desde la terminal donde estamos conectamos como oracle (importante):<br />
Ejecutamos:<br />
dbca<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilMORE71SyIth5OdgzMfnW-b1WfNOPF36PDOcu-7KLjMbwqkzuVOwmgZq5x3VVHJ47pFq8xwl9vK1aZrFn4a1f-whNmDCNTgvQf78f_JgJDd29EoHCgcVbfyqO5StVeswwtyg7e-D7ZN3x/s1600/Captura+de+pantalla+de+2018-11-07+04-48-05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="267" data-original-width="469" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilMORE71SyIth5OdgzMfnW-b1WfNOPF36PDOcu-7KLjMbwqkzuVOwmgZq5x3VVHJ47pFq8xwl9vK1aZrFn4a1f-whNmDCNTgvQf78f_JgJDd29EoHCgcVbfyqO5StVeswwtyg7e-D7ZN3x/s320/Captura+de+pantalla+de+2018-11-07+04-48-05.png" width="320" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTxkzlYGX4l3-6WG5WtQx2jDjWvXphiuAd33lqmwTsBjHvNqeqJGqKz-MG7QsOur-vB8OKFedr-sLyIwM6ksCxQ-cTZOK4raw02-his8H3jd_lQdyeBY5aTLbcBP70yH_wnpJ5P10s5xh6/s1600/Captura+de+pantalla+de+2018-11-07+04-48-28.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="793" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTxkzlYGX4l3-6WG5WtQx2jDjWvXphiuAd33lqmwTsBjHvNqeqJGqKz-MG7QsOur-vB8OKFedr-sLyIwM6ksCxQ-cTZOK4raw02-his8H3jd_lQdyeBY5aTLbcBP70yH_wnpJ5P10s5xh6/s640/Captura+de+pantalla+de+2018-11-07+04-48-28.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDk8mxGNkrh6WOR9XmmywTznBYrKxU3SlxysskZjUyy1JXBde_UtuhSSE9QMDxGsIPIi3zL_5jJ-rmBbYTNQ79-IzE8b8RVR4g0fx6oC9YeY0OZnpZqVFCgYgIF9_EuSnqvypBhS3mHyDI/s1600/Captura+de+pantalla+de+2018-11-07+04-48-51.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="797" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDk8mxGNkrh6WOR9XmmywTznBYrKxU3SlxysskZjUyy1JXBde_UtuhSSE9QMDxGsIPIi3zL_5jJ-rmBbYTNQ79-IzE8b8RVR4g0fx6oC9YeY0OZnpZqVFCgYgIF9_EuSnqvypBhS3mHyDI/s640/Captura+de+pantalla+de+2018-11-07+04-48-51.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqI1MXWKtyA6Z4Taisy4f9j61AuMcFgEdkaNQehipl8o6qjJRF9ZO-mSvgU8FhMqIW0-ZCK2CMzdl0iNiMeR46JAd5lbWm7ja0eKMDmMHNJth5gigkfJqKPdUZHRTfjepAjnlJW9fqxNKm/s1600/Captura+de+pantalla+de+2018-11-07+04-48-58.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="801" height="474" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqI1MXWKtyA6Z4Taisy4f9j61AuMcFgEdkaNQehipl8o6qjJRF9ZO-mSvgU8FhMqIW0-ZCK2CMzdl0iNiMeR46JAd5lbWm7ja0eKMDmMHNJth5gigkfJqKPdUZHRTfjepAjnlJW9fqxNKm/s640/Captura+de+pantalla+de+2018-11-07+04-48-58.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga-HOqOV5Tz_mlR_4Od8BpIIfBgAqV-zb0u1vI7WXlmp64bZBaxmnoJ_0rclHf3H8Ol7fxmi_8ieTxmfezibG2YjVNYcir9DexUxlOYv44m0YscWw_B9GCQ5UXTjHnUEkxmA5nT0TDe-o6/s1600/Captura+de+pantalla+de+2018-11-07+04-49-10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="597" data-original-width="799" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga-HOqOV5Tz_mlR_4Od8BpIIfBgAqV-zb0u1vI7WXlmp64bZBaxmnoJ_0rclHf3H8Ol7fxmi_8ieTxmfezibG2YjVNYcir9DexUxlOYv44m0YscWw_B9GCQ5UXTjHnUEkxmA5nT0TDe-o6/s640/Captura+de+pantalla+de+2018-11-07+04-49-10.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnlxC6JqQGvyYu9mGK424gg1WshEWnnmEM7UyXN7nCZgX1PG0apl3xeQBrFohJ2xeR95Y-qyduYvAPOcKYqPHp0x0c9TT4pPoIKW70PvIyJhawB_9RsREigkEmvqYTb73JZH3qe-cATybq/s1600/Captura+de+pantalla+de+2018-11-07+04-49-45.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="602" data-original-width="795" height="484" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnlxC6JqQGvyYu9mGK424gg1WshEWnnmEM7UyXN7nCZgX1PG0apl3xeQBrFohJ2xeR95Y-qyduYvAPOcKYqPHp0x0c9TT4pPoIKW70PvIyJhawB_9RsREigkEmvqYTb73JZH3qe-cATybq/s640/Captura+de+pantalla+de+2018-11-07+04-49-45.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_xUlHxeRGv8ctyMZZpz4pq_LocdGgOb8Xg27kxlooCsg30Q5L1pMtG8OICo7dVtjHK4XEowPaVji6fpSXyy0JMoO1bvscTXKHwq4dA74aESdehrLLK1pX1UUSOSGRAMaT8IXZihSY56fw/s1600/Captura+de+pantalla+de+2018-11-07+04-49-53.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="798" height="476" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_xUlHxeRGv8ctyMZZpz4pq_LocdGgOb8Xg27kxlooCsg30Q5L1pMtG8OICo7dVtjHK4XEowPaVji6fpSXyy0JMoO1bvscTXKHwq4dA74aESdehrLLK1pX1UUSOSGRAMaT8IXZihSY56fw/s640/Captura+de+pantalla+de+2018-11-07+04-49-53.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNrA_bMhN-EQvUSuxEZvjNO9y1crnebgBWQsze271qXBA0unQkSObGaB2ZIMvspZVrD_vgJcdTh0QJ6CozO3q_mDVQx-5d5s_ZdY07Y8ewSsqC3XGdwxpXFW6SeXP5PH2hGkLLaFoYowv5/s1600/Captura+de+pantalla+de+2018-11-07+04-50-01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="801" height="476" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNrA_bMhN-EQvUSuxEZvjNO9y1crnebgBWQsze271qXBA0unQkSObGaB2ZIMvspZVrD_vgJcdTh0QJ6CozO3q_mDVQx-5d5s_ZdY07Y8ewSsqC3XGdwxpXFW6SeXP5PH2hGkLLaFoYowv5/s640/Captura+de+pantalla+de+2018-11-07+04-50-01.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Si creamos un Listener recibiremos un error. Tiene problemas para recibir la IP del host.. esto sigo investigándolo, pero no nos afecta ahora en principio.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp4RZZk8usDyWcZJ7WpE9Hvvw00YD900hs44ZT5uGwKI3j3bThnZJDNKWQRLK3GGhNrHjSI3LP505D8hmgRaqeXxKmFRPDy59U2rJHvEbEYGNAU01I4RareXO1u5zpwE8phm7nDttMct3P/s1600/Captura+de+pantalla+de+2018-11-07+04-50-54.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="790" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp4RZZk8usDyWcZJ7WpE9Hvvw00YD900hs44ZT5uGwKI3j3bThnZJDNKWQRLK3GGhNrHjSI3LP505D8hmgRaqeXxKmFRPDy59U2rJHvEbEYGNAU01I4RareXO1u5zpwE8phm7nDttMct3P/s640/Captura+de+pantalla+de+2018-11-07+04-50-54.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOE52_BSA1e09VyrwNiUvvhY1mUSbAsACdeI1zW47XcwM4LxgQ5z2NrblegvbUVUOQw6T8TUYRXeypVmE1TVkAyLth24ZfTtWg9WKGpKzwc2kxtkOY-erHaLc27DjaaoE-02y3ye1SX92g/s1600/Captura+de+pantalla+de+2018-11-07+04-52-22.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="802" height="474" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOE52_BSA1e09VyrwNiUvvhY1mUSbAsACdeI1zW47XcwM4LxgQ5z2NrblegvbUVUOQw6T8TUYRXeypVmE1TVkAyLth24ZfTtWg9WKGpKzwc2kxtkOY-erHaLc27DjaaoE-02y3ye1SX92g/s640/Captura+de+pantalla+de+2018-11-07+04-52-22.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiouZH913yJUF5u_4_mA8bV2PikQm2iQGH5eNV2VUlpHt8I33aXnMaP_tuSfZwSgWod1od4nzELWZb9Z-uyhVu0n7TNNXXFusrdjgaFQmJyx5Eyuo2Cah_EmJcwBaNF-heH-1Jj_NgwMf1U/s1600/Captura+de+pantalla+de+2018-11-07+04-52-35.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="795" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiouZH913yJUF5u_4_mA8bV2PikQm2iQGH5eNV2VUlpHt8I33aXnMaP_tuSfZwSgWod1od4nzELWZb9Z-uyhVu0n7TNNXXFusrdjgaFQmJyx5Eyuo2Cah_EmJcwBaNF-heH-1Jj_NgwMf1U/s640/Captura+de+pantalla+de+2018-11-07+04-52-35.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLFZnaJMGb459pLAxb5_n08mVfkZes7PuRmW2CZRQwohCaaaE7_5J4_SYKKcCc2-0-br8gsmF0dQItZK4Uw7-SoKKVi56KmKB4CdLSYPhaHxE-qzf9B-TsIkQq-_IrOCfuh5dBi7rsR6zG/s1600/Captura+de+pantalla+de+2018-11-07+04-52-40.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="792" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLFZnaJMGb459pLAxb5_n08mVfkZes7PuRmW2CZRQwohCaaaE7_5J4_SYKKcCc2-0-br8gsmF0dQItZK4Uw7-SoKKVi56KmKB4CdLSYPhaHxE-qzf9B-TsIkQq-_IrOCfuh5dBi7rsR6zG/s640/Captura+de+pantalla+de+2018-11-07+04-52-40.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWwHAxJ0l-9q90U7vbvXJvmgqi6i0fP-Sh9j8K7XIMRpLSYEg2SNj_oSu9xM23nI7WM49b4M72zhCde2QiKK2JEPSl3DOHtMYxkUyvvJBnByzeFP6GvMYY1JobHh4B5T3qWwGZM8XB1zpZ/s1600/Captura+de+pantalla+de+2018-11-07+04-52-46.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="598" data-original-width="802" height="476" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWwHAxJ0l-9q90U7vbvXJvmgqi6i0fP-Sh9j8K7XIMRpLSYEg2SNj_oSu9xM23nI7WM49b4M72zhCde2QiKK2JEPSl3DOHtMYxkUyvvJBnByzeFP6GvMYY1JobHh4B5T3qWwGZM8XB1zpZ/s640/Captura+de+pantalla+de+2018-11-07+04-52-46.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6ije-lbu0ZJYuhsw84fZfBi3jiBSWvMkpDzTsDawfM48M8gepPV9dg6qmYaxExmAqa8zdJDpI0r3VsQhHGZxu1q3tRmAY3LsTBmOVh_dsAWc-uzyLCQJM-WhzuqLRpc2yhdmmKqIUUlUf/s1600/Captura+de+pantalla+de+2018-11-07+04-52-51.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="601" data-original-width="805" height="476" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6ije-lbu0ZJYuhsw84fZfBi3jiBSWvMkpDzTsDawfM48M8gepPV9dg6qmYaxExmAqa8zdJDpI0r3VsQhHGZxu1q3tRmAY3LsTBmOVh_dsAWc-uzyLCQJM-WhzuqLRpc2yhdmmKqIUUlUf/s640/Captura+de+pantalla+de+2018-11-07+04-52-51.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1IHVXGfRopnff-BgMe2KLkC7KOP5VHvQavw64uvE8wHuFc9LkoQT7AaJYSunateVjtSx8nF1VCEXk_lsg23JLstX-DSZrxxMpNoNw1ZLGHECHuotgSXs5X4S2DlTb1cQyJGto70z94a47/s1600/Captura+de+pantalla+de+2018-11-07+04-53-01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="588" data-original-width="798" height="470" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1IHVXGfRopnff-BgMe2KLkC7KOP5VHvQavw64uvE8wHuFc9LkoQT7AaJYSunateVjtSx8nF1VCEXk_lsg23JLstX-DSZrxxMpNoNw1ZLGHECHuotgSXs5X4S2DlTb1cQyJGto70z94a47/s640/Captura+de+pantalla+de+2018-11-07+04-53-01.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirqEkqjTIbyBtC2vWw9mAdPYKEMrmCZaEm35RqrnakUoOHs1jsWeS_6fRkmfrg2O7GQwua5h3LODXURA4qCnF52dcSdIP9Ha8OU7lS4GpsPGqNS6wVrQQX2w43lCDmZiSiq9p3T308vO4c/s1600/Captura+de+pantalla+de+2018-11-07+04-53-09.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="591" data-original-width="794" height="476" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirqEkqjTIbyBtC2vWw9mAdPYKEMrmCZaEm35RqrnakUoOHs1jsWeS_6fRkmfrg2O7GQwua5h3LODXURA4qCnF52dcSdIP9Ha8OU7lS4GpsPGqNS6wVrQQX2w43lCDmZiSiq9p3T308vO4c/s640/Captura+de+pantalla+de+2018-11-07+04-53-09.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfvf7siod2I-7x3kxMdxLV7avttnFrI1FVSKd32olzsbBl8k6nsY6B711krKHROomWitQvFCHVEoGjm7IttKnVsY4tMLgUYA9RZVFBD5WRmM5yFzDe-uwZBDMSdwuQ9Cu1cSdtUINHyjlB/s1600/Captura+de+pantalla+de+2018-11-07+04-53-15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="172" data-original-width="515" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfvf7siod2I-7x3kxMdxLV7avttnFrI1FVSKd32olzsbBl8k6nsY6B711krKHROomWitQvFCHVEoGjm7IttKnVsY4tMLgUYA9RZVFBD5WRmM5yFzDe-uwZBDMSdwuQ9Cu1cSdtUINHyjlB/s400/Captura+de+pantalla+de+2018-11-07+04-53-15.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeEOifI0aZrxyRFktVIRaNfr-IuHBG86mPVytg3IY2CjWwoisbqqWUKuIWgft9kI6L3LD4oogx2bW4y01GEk-9AADOnUdUDOEK4ohKhEtPbd4RWtdIqI4Nq-x1vYtxJSEvg4ZpTdMCDAnr/s1600/Captura+de+pantalla+de+2018-11-07+04-53-29.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="597" data-original-width="792" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeEOifI0aZrxyRFktVIRaNfr-IuHBG86mPVytg3IY2CjWwoisbqqWUKuIWgft9kI6L3LD4oogx2bW4y01GEk-9AADOnUdUDOEK4ohKhEtPbd4RWtdIqI4Nq-x1vYtxJSEvg4ZpTdMCDAnr/s640/Captura+de+pantalla+de+2018-11-07+04-53-29.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD9u9VJqH_gurQYacJIy8XyjyK1B5LvDO5s1KDuIPuCiV5pZqaMt18l-9F4v7nSbYqPLZweQaXsnKYvt93jfp57Ndm-QFdJpu7yhACtJ7kBkLcK_3pFyQBPVaWB0qV2F2SHcI4y7et0N_6/s1600/Captura+de+pantalla+de+2018-11-07+04-53-37.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="803" height="472" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD9u9VJqH_gurQYacJIy8XyjyK1B5LvDO5s1KDuIPuCiV5pZqaMt18l-9F4v7nSbYqPLZweQaXsnKYvt93jfp57Ndm-QFdJpu7yhACtJ7kBkLcK_3pFyQBPVaWB0qV2F2SHcI4y7et0N_6/s640/Captura+de+pantalla+de+2018-11-07+04-53-37.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_xz9IXHHLlseX69tfEMS70HX845CZlq31n5KKitEZsPGWf8t6qdKnQU5IwTfQXBufKZMozl7BQJ9zCXRrnS8KItQ76K3L2jpWbOYoSEkd6QLnjZFxB3HBDMZdpvg5aRF1vNG3bFEL1EaG/s1600/Captura+de+pantalla+de+2018-11-07+04-53-45.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="594" data-original-width="805" height="472" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_xz9IXHHLlseX69tfEMS70HX845CZlq31n5KKitEZsPGWf8t6qdKnQU5IwTfQXBufKZMozl7BQJ9zCXRrnS8KItQ76K3L2jpWbOYoSEkd6QLnjZFxB3HBDMZdpvg5aRF1vNG3bFEL1EaG/s640/Captura+de+pantalla+de+2018-11-07+04-53-45.png" width="640" /></a></div>
<br />
Paciencia, mucha paciencia, si queremos ver como va la instalación siempre podemos hacer, (en una nueva terminal o en la de antes que abrimos, si no la habíamos cerrado ya):<br />
<br />
tail -f /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFH2fsBeRZ8bcw182y6nVcI6aDSuSFijUaBb98dY7QBkkhYpayp5JB98Cqa3EjxqxivNVpK9E2s0_K-3hhSAqymyFAOYRNd2fB5fQiUfiW0xNcQEVooJ8h0B2NR557GOj6zCWMUemVWgEq/s1600/Captura+de+pantalla+de+2018-11-07+05-01-26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="286" data-original-width="890" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFH2fsBeRZ8bcw182y6nVcI6aDSuSFijUaBb98dY7QBkkhYpayp5JB98Cqa3EjxqxivNVpK9E2s0_K-3hhSAqymyFAOYRNd2fB5fQiUfiW0xNcQEVooJ8h0B2NR557GOj6zCWMUemVWgEq/s1600/Captura+de+pantalla+de+2018-11-07+05-01-26.png" /></a></div>
<br />
y tras una larga espera...<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyM3WBnXScwELdmmh15tS9LbCibNCTIbq3k2Q8bvjlLBt7Hyhcipu053bBArNy2bkCkaOqMFCT6H55drLsS9LOw7kQzhDDWkTZJUW41_1rSsQfMG-kBBnXehNLJUX-Xsug4jKmBil1IgQY/s1600/Captura+de+pantalla+de+2018-11-07+05-40-41.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="601" data-original-width="798" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyM3WBnXScwELdmmh15tS9LbCibNCTIbq3k2Q8bvjlLBt7Hyhcipu053bBArNy2bkCkaOqMFCT6H55drLsS9LOw7kQzhDDWkTZJUW41_1rSsQfMG-kBBnXehNLJUX-Xsug4jKmBil1IgQY/s640/Captura+de+pantalla+de+2018-11-07+05-40-41.png" width="640" /></a></div>
<br />
<b>Instalación Finalizada!!</b><br />
No hace falta hacer startup ya está iniciada, montada y abierta<br />
Si reiniciamos, entonces sí.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0rEmSapXH7FaZoztLogHkg_frqWkHT21QYDV0huejxRjY2MVywET7yYfdXeMIWJv55IRAmZ_8epta5In46fBrxe6I8WDiXzATidi0B-Lez2xd7uxxZp6_iIE7nSba0TFsYUJmI-EjvQn3/s1600/Captura+de+pantalla+de+2018-11-07+05-42-18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="282" data-original-width="666" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0rEmSapXH7FaZoztLogHkg_frqWkHT21QYDV0huejxRjY2MVywET7yYfdXeMIWJv55IRAmZ_8epta5In46fBrxe6I8WDiXzATidi0B-Lez2xd7uxxZp6_iIE7nSba0TFsYUJmI-EjvQn3/s320/Captura+de+pantalla+de+2018-11-07+05-42-18.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Espero que a alguien le sirva de ayuda!!</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<b><br /></b></div>
<script src="https://raw.github.com/moski/gist-Blogger/master/public/gistLoader.js" type="text/javascript"></script>
Evaristohttp://www.blogger.com/profile/07265542416313494803noreply@blogger.com0