This article is the second part of the series of articles about Oracle Autonomous Database and DevOps. For a better understanding, I recommend reading the article “Oracle Autonomous Database and DevOps: A Simple Usage Approach – Part 1” before proceeding with the steps in this article. As in the previous article the Docker configuration was handled, we will begin to provision the Oracle Autonomous Database version 18c in the Oracle Cloud. – Provisioning the Oracle Autonomous Database in the Cloud: Before provisioning the database it is necessary to create a…
Author: brunors
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)
Oracle Autonomous Database and DevOps: A simple usage approach – Part 1
This article explains the creation of an Oracle Autonomous Database instance in the Oracle Cloud for the usage of programmers(some tests examples with some programming languages and Oracle SQL Developer). Let’s build some concept to start: What is the Oracle Autonomous Database? According to Oracle Corp, it is “the first standalone cloud data manager that provides application for patches, upgrades and tuning, including performing maintenance tasks on the database without human intervention.”. In addition, Oracle itself explains 3 features of this new database model that are: According to the Oracle…
Collaborator for LUXOUG – Luxembourg Oracle User Group
Hello all, I have become a collaborator for the LUXOUG – Luxembourg Oracle User Group which is the first Oracle user community in Luxembourg, whose founding members are: Andre Luiz Dutra Ontalba, Fernando Simon, Leonardo Santos Lopes and Rodrigo Mufalani (OCM). This is a group for anyone interested in sharing knowledge about Oracle Technology, focused on database administration, engineered systems, cloud, development and more. The group will hold presentations mostly in English, French and Portuguese but as it is written in their website they “are welcome to propose sessions in…
AWS Summit Stockholm on Wednesday, May 22, 2019 in Stockholm.
Hello, I would like to inform you all that I will be attending the AWS Summit on Wednesday, May 22, 2019 in Stockholm, Sweden. The main reason for attending this event is to understand better the AWS Cloud architecture for databases such as Oracle, MongoDB and MySQL. Here are the details for the event: There are still some places left to register for this event, so feel free to join: https://pages.awscloud.com/Stockholm-Summit-Register.html brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am…
On the 4th of June 2019, SWEOUG (https://www.sweoug.se/) & ORACLE will host a database Meetup.
On the 4th of June 2019, SWEOUG (Swedish Oracle User Group) & ORACLE will host a database Meetup. This FREE event will be held in Stockholm, Vasagatan 7a Centralen, room Clara 1. 13.00 -17.00. Come and meet the Master Product Manager for the Oracle Database, Dominic Giles and the Product Manager for the Oracle Optimizer, Nigel Bayliss. Here are the twitters of the speakers: https://twitter.com/vldbb https://twitter.com/dominic_giles I really would like to join but I will be travelling to Poland due to some business activities. However, feel free to join! brunorsHi! I am Bruno, a…
Oracle Database 18c: Provisioning the Linux server
In the initial menu of the Oracle Cloud click on “Compute” and later on “Instances”: On the next tab, click the “Create Instance” button: In the Create Compute Instance tab, provide the requested information: Name: Choose a name for your instance. (In the example: VMLINUXmachine) Select an available domain for your instance: Choose the first available domain (In the example: ysjg: PHX-AD-1) Choose an operating system or image source: Keep the option available on Oracle. Image Operating System: Oracle Linux 7.6 Choose instance type: Choose “Virtual Machine” Shape: We will…
Oracle Database 18c: Creating the Virtual Network (Virtual Cloud Network)
In the Virtual Cloud Network tab click on the “Create Virtual Cloud Network” button: In the Virtual Cloud Networks tab click on the “Create Virtual Cloud Network” button: You will then be presented with the screen to create the Virtual Cloud Network, where it is necessary to specify all the information for the VNC configuration: In the Virtual Cloud Network tab choose the option “Create Virtual Cloud Network plus related resources” to create the VNC only with public subnets: Click the “Create Virtual Cloud Network” button and a screen with…
Oracle Database 18c: Provisioning the Oracle Autonomous Database in the Cloud
For this step you will need to create the account in the Oracle Cloud with this link, https://cloud.oracle.com/home . Before you provide the database you need to create a Compartment. If you have not yet created one click on “Identity” and later on “Compartments” under the “Governance and Administration” tab of the menu: Then click “Create Compartment” if there is none existing : The root compartment is the first compartment created. From it, it is possible to create other compartments by using them as an option in the “Parent Compartment”…
#7 DIÁRIO DE UM DBA – Oracle Code e jantar do programa Oracle ACE – Roma, Itália 2019
Fala galera! Como eu expliquei no post anterior : https://www.techdatabasket.com/oracle-code-and-oracle-ace-program-dinner-rome-italy-2019/ que estaria participando do Oracle Code e do jantar do programa Oracle Ace 2019, segue o vídeo que eu fiz sobre o evento no canal do DBA Brasil no You Tube: Segue a cobertura do site do DBA Brasil: brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science…
[OCM 12] Managing an encrypted tablespace
E.g: CREATE TABLESPACE securespace DATAFILE ‘/u01/app/oracle/oradata/techdatabasket/secure01.dbf’ SIZE 100M ENCRYPTION USING ‘AES256’ DEFAULT STORAGE(ENCRYPT); VIEWS: V$ENCRYPTED_TABLESPACE DBA_TABLESPACES USER_TABLESPACES Database Administration -> Database Administrator’s Guide -> 13.2.5 Encrypted Tablespaces Oracle Database Administrator’s Guide -> 20 Managing Tables -> 20.2.13 Consider Encrypting Columns That Contain Sensitive Data brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software…