I was managing a database that had a temporary tablespace which was having problems to hold the results of a sort. Then I solved this problem by creating a temporary tablespace group. And according to Oracle Corporation, “… enables parallel execution servers in a single parallel operation to use multiple temporary tablespaces.”. So how can I do that? If you are managing a multitenant database you must have in mind what problem is occurring in one of your PDB or the CDB. Let’s see if we are going to create…
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)
Presentation LUXOUG: Oracle Database on Oracle AWS RDS
“Oracle Database on AWS RDS “ to the LUXOUG (Luxembourg Oracle User Group) 🇱🇺 on February . Here are the details: – Oracle Database on AWS RDS. – How to migrate the On-prem Oracle to AWS RDS (Oracle LogMiner) – Pros x Cons of using DMS tool (According to my experience) Link: https://lnkd.in/dyEjvrd Speaker: Bruno Reis – 02/13/2020 19:00 (CEST) Please subscribe to the portal for free. Youtube link : https://www.youtube.com/watch?v=Ud3CGT4B1Io Pdf of the presentation below: brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a…
Warning: PDB altered with errors. How PDB_PLUG_IN_VIOLATIONS view can help you?
I was cloning a PDB from another PDB when I faced this error: Then I was wondering what shall I do now once the command is “show errors” but replied “No errors.”, and it didn’t give any clear message that was different from “Warning: PDB altered with errors.”. I came to a realization after doing some research and I found that the view pdb_plug_in_violations and found out the reason of the warning and it was because my database has Transparent Data Encryption configured and was missing the keys from the…
Palestra: Oracle Database on AWS RDS
Hello, I will be giving a presentation in Brazil. The lecture topic will be, the Oracle Database on AWS RDS at IBM Brazil and on Tuesday, January 14th, 2020, for IBM employees and the language of the presentation will be Portuguese.The lecture will be presented in Portuguese at 10 am. Topics of the session: – How to migrate your Oracle Database on-prem to AWS RDS – DMS limitation and my experience (Pros X Cons) to migrate your Oracle database On-prem to AWS RDS Bruno Reis is an Oracle Database Administrator…
ORACLE AND AWS RDS FOR ORACLE TIP 4: DMS limitation and my experience (Pros X Cons) to migrate your Oracle database On-prem to AWS RDS
So this is the fourth and final article about how to migrate your Oracle database On-Prem to AWS. You can check the previous articles here : 1- ORACLE AND AWS RDS FOR ORACLE TIP 1: HOW TO CONFIGURE YOUR ORACLE ON-PREM TO BE MIGRATED TO AWS RDS ORACLE? A guide to use Amazon Data Migration Service (DMS). 2- ORACLE AND AWS RDS FOR ORACLE TIP 2: HOW TO CONFIGURE YOUR ORACLE AWS RDS TO RECEIVE DATA FROM AN ORACLE ON-PREM? A guide to use Amazon Data Migration Service (DMS). 3-ORACLE…
ORACLE AND AWS RDS FOR ORACLE TIP 3: HOW TO CREATE A TASK AT DMS AND START YOUR MIGRATION
This post is part of the first post “ORACLE AND AWS RDS FOR ORACLE TIP: HOW TO CONFIGURE YOUR ORACLE ON-PREM TO BE MIGRATED TO AWS RDS ORACLE? A GUIDE TO USE AMAZON DATA MIGRATION SERVICE (DMS)” where I briefly explained how to configure your Oracle database On-Prem to be migrated to an AWS RDS Oracle and second post “ORACLE AND AWS RDS FOR ORACLE TIP: HOW TO CONFIGURE YOUR ORACLE AWS RDS TO RECEIVE DATA FROM AN ORACLE ON-PREM? A GUIDE TO USE AMAZON DATA MIGRATION SERVICE (DMS)” where…
Oracle Modern Cloud Day Stockholm | 5 December 2019
Oracle Corporation has prepared a full day to talk about Cloud and AI.To attend this event you have to register yourself at the following link : https://eventreg.oracle.com/profile/form/index.cfm?PKformID=0x7465538abcd&source=:ow:evp:cpo::RC_EMMK190614P00010:OER10081496 Here you can check the full Agenda and also register for some speeches that will happen before the Oracle Cloud Day : https://www.oracle.com/se/a/evt/docs/se-mcd-agenda.pdf?source=:ow:evp:cpo::RC_EMMK190614P00010:OER100814969 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…
ORACLE AND AWS RDS FOR ORACLE TIP 2: HOW TO CONFIGURE YOUR ORACLE AWS RDS TO RECEIVE DATA FROM AN ORACLE ON-PREM? A guide to use Amazon Data Migration Service (DMS).
On my last article, I wrote about how to configure your Oracle On-Prem database to be migrated to an AWS RDS Amazon (If you didn’t see this post check it out : https://www.techdatabasket.com/oracle-and-aws-rds-for-oracle-tip-how-to-configure-your-oracle-on-prem-to-be-migrated-to-aws-rds-oracle-a-guide-do-use-amazon-data-migration-service-dms/). Some people may ask the version of my Oracle On-Prem or even the class or version of my AWS RDS instance but the fact is if you are going to perform a Homogeneous migration as it is in this example (From Oracle to AWS Oracle RDS) the steps are the same. However, as it is in all…
ORACLE AND AWS RDS FOR ORACLE TIP 1: HOW TO CONFIGURE YOUR ORACLE ON-PREM TO BE MIGRATED TO AWS RDS ORACLE? A guide to use Amazon Data Migration Service (DMS).
For those who attended the Oracle Open World 2019 in San Francisco, California in the USA (if you didn’t check out my compilation video about the event : https://www.youtube.com/watch?v=8bOLbXOJHmAh ) and have had the experience to also attend the KeyNotes probably would prefer to migrate their Oracle database On-Prem to Oracle Cloud Ed2 instead of AWS Amazon EC2 or RDS. However, as an IT professional, we have to do our best to deliver a high quality of service independently of the provider . So the purpose of this post is…
ORACLE AND AWS RDS FOR ORACLE TIP: How to configure your public Database Link in AWS RDS ORACLE. What happened with my TNSNAMES.ORA?
AWS RDS Oracle is a managed service. Hence, there are some functions associated with the database that are managed by AWS instead of the customer and the tnsnames.ora file is one of those items managed by AWS. So the question is: how to create and configure my public Database Link to use a service configured on my previous On-Prem database? So this is my Service configured in my TNSNAMES.ORA in my On-Prem database: To create your public Database Link in the AWS RDS Oracle , it has to be used…