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…
Year: 2019
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…
ORACLE AND AWS RDS FOR ORACLE TIP: Archive log retention and switch log file in AWS RDS Oracle
I have an issue while I was migrating my Oracle database On-Prem to AWS RDS for Oracle. My archive area went 100% full and I wasn’t enable to connect in my database. When you create your database in AWS Cloud have in mind that you will also need to consider an additional space to your archive area. So the purpose of this post is to show to you how to check the retention of the archive logs in your RDS Oracle database plus to learn how to generate a new…
ORACLE AND AWS RDS FOR ORACLE TIP: Where is my alert log at AWS RDS?
Managing your Oracle database on AWS RDS has some differences comparing it with the management of your Oracle database On-Prem. One of these differences is the daily retention of 30 days for the alert log in text and 7 days for the XML type. Therefore, how can I find my alert log? You can use the Amazon CloudWatch Logs to export the logs of your database but if you aren’t using this service you can query alertlog view or a table-like format as below: When you query the alertlog view,…
ORACLE AND AWS RDS FOR ORACLE TIP: ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove any
I have started to migrate some database On-Prem to AWS RDS. I have been migration Oracle On-Prem to AWS Oracle RDS which means that it will be a Homogeneous migration process. Then as one of the steps to migrate this database, I have taken all the DDL of the tablespaces On-Prem and decided to create in my target RDS database. Therefore, in the creation process I stuck in this error: According to Amazon documentation “Amazon RDS only supports Oracle Managed Files (OMF) for data files, log files, and control files.…
ORA-38342: heat map not enabled
I have had the brilliant idea to perform a test to be able to track the modification of database blocks, read and write access in segments made by DMLs and DDLS in one of my databases. I knew already that to do this I had just to enable the parameter heat_map from OFF to ON. So I did : Well, I have done what I thought. Now let’s create a table to check my enabled parameter: What? What happened? Am I crazy? I am 100% sure that I have the…