Getting started with automation in Oracle Cloud Infrastructure

This session will help get you started in Oracle Cloud Infrastructure automation. Maybe you're just starting out in cloud infrastructure management or you just need an overview of the related technology I'll discuss the aims of automation and consider how to get the most value out of automation.  Using working code example in common tools including the OCI API, OCI CLI, Python and Terraform I aim to provide the audience with a platform for further learning of essential skills the world of OCI operational management.

This session was orginally included in the UKOUG Conference 2020 agenda but did not run as planned.
Register
This event is free for members of the UKOUG. If you are a guest that registered for the UKOUG Conference 2020, please contact us with your booking details to book for this session for free.
27-JAN-2021
MEMBER RATE
This event is already included with your membership
Included in your membership

Register

GUEST ATTENDEE
You can attend this event at the non-member rate but membership may be a more cost effective option, find out more here.
£25

Register

STUDENT
Students can attend for free
FREE

Register
Speaker

Graham Smith

Graham Smith, Cedar Consulting

Graham Smith leads the PeopleSoft Technology Practice at Cedar Consulting (Version 1). He is an experienced software engineer and cloud infrastructure analyst and is an Oracle Cloud Infrastructure Certified Architect.  He’s also an Oracle ACE Director and is a regular presenter at Oracle OpenWorld and User Group events around the world and enjoys the friendly and helpful community of Oracle users.

Cloud ERP & EPM Enhances Reporting & Tracking for Healthcare Service Provider

The value of Cloud implementation depends on the journey and desired outcome. In this session, attendees will hear from the finance leadership of Trilogy Health Services Inc. about their Oracle Cloud implementation journey. Learn from their experiences with leveraging various Reporting tools for effective Reporting and Tracking. Plus, hear how their journey helped them to meet the needs relevant to the healthcare industry.

Learning Objectives:
* Hear how they leveraged Oracle Cloud for Financial & Management Reporting both for internal and external stakeholders.
* Learn about the reporting tools Oracle Cloud provides and how to leverage Self-Service features for business user enablement.
* Get to know typical (business + system) challenges and ways to address them using best practices.

From: https://www.oatug.org/events/event-description?CalendarEventKey=7590598e-8cb4-4922-b527-ddcbdf531106&Home=%2feducation-events%2fevents

5 out of 6 OCI Certifications – Impressions and Experience

Hi all,

Not long ago the was a program by Oracle which gave access to PCI training and certification for free. As several people still wanted to take their chance on the exams, there were an extension on with more openings. I blogged about it here

During the last days studying for the OCI free certifications. Well, let´s say that I procrastinated a bit and along with moving countries with my family, COVID the lockdown and all that comes with it, I managed to pass on 5 out of the 6 OCI certifications that are available, I did not enroll on the Dev one once I knew that Kubernetes and OCI Functions were the type of beast that I was not planning to tackle.

Here are they in order:
oci_results

And yes I did the Architect Professional prior the Architect Associate, let´s call a miss on schedule from my part – to say the least.

I did all video trainings and some more than one time and read a lot of the documentation. Also asked to collegues and peers how the exams were as soon as I saw they passed in the exams that I was aamin to.

While not working with cloud nor with OCI every day I knew that I needed to put a few extra hours but it not that big of a deal. so if you dont work with cloud and want to get in the game, you sure can do it. Oracle has the free trial and the always free tier that you can levarage from. Mine expired in the middle of the studing so I needed to get creative with the demos that are avaliable and on the last day prior my last exam I was able to get access to my corp´s tenancy (thanks a lot guys) to resolve some cases which I still needed.

The demos from the trainings are not 100% specialy on the Database service side. I was expecting more, there are great demos from Rohit Rahi and Flávio Pereira and others. So I strong recommand that you follow along. My tip goes to increasing the video speed to 1.5x That really helped my to get focus and to move a bit faster to get all done prior each exam.

My scores ranged from 74% upt to 92% and in my opnion the Architect Associate was the most dificult due its questions type not the content it self. As most of the questions were specific to OCI features and services and not related to desing, some trick questions- To me these make the exams less enjoyable. I had no OCI CLI questions which I though It would be also covered.

I would like to thank my family to put up with me for the last week of testing and to Oracle and Oracle Cloud teams which providded the trainings and the exams vouchers.

 

Cheers

Elisson Almeida

Amazon RDS: How to perform RMAN operations?

Hi all,

Need to performa any RMAN Operation from Amazon RDS? Maybe something like validating backups?

Well, we have some options under by using RDSADMIN_RMAN_UTIL package. See below an example for validate backup:

BEGIN
 rdsadmin.rdsadmin_rman_util.validate_database(
 p_validation_type => 'PHYSICAL+LOGICAL',
 p_parallel => 4,
 p_section_size_mb => 10,
 p_rman_to_dbms_output => FALSE);
END;
/

More info about it: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.RMAN.html

Hope it helps, cheers!

CLOUG: Oracle Groundbreakers Tour Santiago 2019!

¡Hola! ¿Cómo estas?

Como ya sabes, los Grupos de Usuarios de Latinoamérica con el apoyo de OTN y LAOUC organizan por décimo año consecutivo el evento más grande de tecnología Oracle en la región. Este se llamado Oracle Groundbreakers Tour, donde reconocidos expertos en tecnologías Oracle recorren el mundo llevando su conocimiento a todas las latitudes.

Este año el tour abarca 10 países, y en Santiago será el lunes 2 de Agosto en la UNIVERSIDAD SAN SEBASTIÁN (Av Belavista 7, Recoleta, Santiago).

El motivo del presente es para invitarte a este evento, donde tendré el placer y la oportunidad de hablar sobre la tecnología Oracle y, especialmente su tecnologia en la nube.

Además, habrá presentaciones para diversas áreas de interés: Bases de Datos, Cloud Computing, DevOps, Linux y BI, así como hands-on labs.

Puedes ver la agenda completa aquí.
También, aquí para detalles de las charlas.

Es necesario registrarse aquí. Tarifas de acuerdo a la fecha:

  • Early Bird (hasta el 30 de junio 2019): 10.000 CLP
  • Precio Preferencial (1 de Julio al 15 de Julio): 15.000 CLP
  • Precio Normal: (16 de Julio al 1 de agosto): 20.000 CLP
  • Precio Dia del Evento: (2 de agosto): 25.000 CLP

Subscribe here!

Te veo allá!

Roundtable: How are Databases adapting to Cloud architectures? – THANKS!

Hi all!
I just need to thank you all for the attendance on yesterday’s Round Table event!

We had over 130 individuals in presence plus dozens following the live on YourTube. It was great to have the discussions and also to count on your questions and support.

I need also to thanks for SETREM space and support, specially Franzéli Kaspari and Prof. Valsênio Gaelzer for all the efforts on making it happen. Also for both other members of round table Simone Kosmalski, Cristiano Goelzer and Jonas Pacheco who attended physically and participated on discussions.

I’d also specially want to thank Ricardo Gonzalez for attending remotely from over 10kkm our event. Thanks Ricardo!


Hope to join you guys soon again in a second round.

Cheers!

Oracle New Visual Online Tools

Hi all,
So, after a long time of same old documentation style, Oracle started sharing some nice and visual pages for some specifics. Here are 2 examples:

1. Oracle Move to Cloud  (http://www.oracle.com/goto/move)
This one was shown to me by Ricardo Gonzalez, and it’s a GREAT tool if you are planning migrations to Oracle Cloud in general.

The part I like most is where you select the source and destination formats/versions you want and all recommended migration methods are suggested. Of course additional validation on database are required for each method, but it can potentially remind you of things you may be forgetting.

NewScreenshot 2019-05-08 às 16.56.46

Something else I like very much as well is the section with executive summaries of each migration tool. It’s basically ready for a print screen to put in the slides you are going to present to your boss… 🙂

NewScreenshot 2019-05-08 às 16.57.16.png

Also, you have handy some links to papers for the most different migration scenarios, as per:

NewScreenshot 2019-05-08 às 16.57.24

2. Oracle Database Features: (https://apex.oracle.com/database-features/

NewScreenshot 2019-05-08 às 16.52.14

And by selecting any of the features you can see more info in a very simple way, as per below. By the way, with one click you can be directed to the documentation (the old fashioned one):

NewScreenshot 2019-05-08 às 16.55.08

 

Hope you enjoy those as much as I did and hope Oracle continue providing those sort of interfaces to us!

Cheers!

Getting started with Oracle Cloud – OCI

Hi all, this one is a quick one 🙂
I’m starting the Oracle Cloud journey, a bit late but still have time right?

The Oracle cloud has being improving and adding new features lately.

To get started on it, you can, as I am :-), watching these youtube series

OCI Level 100 on YouTube
OCI Level 200 on YouTube

Hope it helps on the your Oracle cloud journey!

Elisson Almeida

RMAN Raise ORA-19913 ORA-28365 On Restore from Cloud Backup

First I think was some error with Database Backup To Cloud, when testing. Then I realized it was a simple mistake by myself.

Let me show you. First trying to restore datafile:

[oracle@mydbsrvr archivelogs]$ rman target /
RMAN> restore datafile 6;
Starting restore at 03-MAY-2016 20:00:30
using channel ORA_SBT_TAPE_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=178 device type=DISK
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00006 to /db/u1001/test/cloud_test/test_restore.dbf
channel ORA_SBT_TAPE_1: reading from backup piece 0sr4mdun_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/03/2016 20:00:34
ORA-19870: error while restoring backup piece 0sr4mdun_1_1
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open

Ok, it might happen because I forgot to set encryption password:

RMAN> SET ENCRYPTION ON IDENTIFIED BY "matheusdba" only;
executing command: SET encryption
RMAN> restore datafile 6;
Starting restore at 03-MAY-2016 20:00:30
using channel ORA_SBT_TAPE_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=178 device type=DISK
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00006 to /db/u1001/test/cloud_test/test_restore.dbf
channel ORA_SBT_TAPE_1: reading from backup piece 0sr4mdun_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/03/2016 20:00:34
ORA-19870: error while restoring backup piece 0sr4mdun_1_1
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open

It hapen again?
This point I suspect some kind of bug… But it was my mistake and is not related to Cloud, but to Encryption use. To undestand:
For Backup: Use ENCRYPTION
For Restore/Recover: Use DECRYPTION

Obviously, but take me a minute to realize…

Setting decryption, and problem solved:

RMAN> set DECRYPTION identified by "matheusdba";
executing command: SET decryption
RMAN> restore datafile 6;
Starting restore at 03-MAY-2016 20:00:58
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00006 to /db/u1001/test/cloud_test/test_restore.dbf
channel ORA_SBT_TAPE_1: reading from backup piece 0sr4mdun_1_1
channel ORA_SBT_TAPE_1: piece handle=0sr4mdun_1_1 tag=TAG20160503T193239
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:03
Finished restore at 03-MAY-2016 20:01:02

See ya!
Matheus.