Thanks a lot for the nice review. Please do like, subscribe and share. You can find more videos in the Playlist. Link is provided in the video description
how about the complex dbswhere the challenges are in primary key, indexes, etc.? I was reading some articles and find its complex. Simple table migration is straight forward but where the triggers, primary key, indexes, etc. are little bit overwhelming. Your thoughts?
Yes it totally depends from case to case. This is a simple test to show the steps involved. But with Complex databases, it needs more involvement and needs to be checked with test replica databases before actual production migration
very nice and well explained . is it possible to add 1 slide with end to end architecture source , rds , target scripts and permissions etc .. that would help everything in glance for learners
Thanks a lot for the nice comments. Please refer to infraxpertzz.com/migrating-on-premise-oracle-database-to-aws-rds-oracle/ for detailed steps and permissions involved for the migration. Hope it helps
Hi I am successfully migrated my database but in my ddl i have default value 0 which not migrated. Can you please help me. On how to migrate with ddl in ful load
Hi, I have an error like this: Last Error Endpoint initialization failed. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2859] [1020401] Cannot retrieve Oracle archived Redo log destination ids; Can you help me?
Is your backup on? If your backup retention is set to 0, then your backup is off, thus disabling your archive logs. Please check whether the archive log is enabled at target or not
Hi bro I want to use source db from virtual box on windows , can u tell me how I configure dns server name in virtual box and put it in source end point ? Thanks.
I don't think it's possible until u register ur domain. Simply setting up the dns won't help. That dns should be visible to the outer world which is only possible after buying the domain
Thank you very much for the detailed walk though. Quick question: Is on-premise Oracle DB version matter for such migrations? Does the same process work if my on-premise Oracle DB is running on 8i/9i?
Thanks for the nice comments. Please like,share and subscribe to support us. AWS Database Migration Service (AWS DMS) doesn't support Oracle 8i or 9i as a source. You need to upgrade your database to atleast oracle 10g version which is supported by AWS DMS
Hello thank you for the amazing video. Since we migrated database from EC2 to aws, we already had a network connection in this case. What prerequisites need to be fulfilled if we are migrating actual client database to aws?
Hi Sukesh. Thanks for the overwhelming comments. Hope ur doubts r cleared now. The process would be the same, just the DNS name of ur on-premise server needs to be provided and u need to check whether AWS is able to reach out to the server and vice versa
Sorry to be off topic but does anyone know a way to get back into an instagram account? I somehow forgot my password. I love any assistance you can give me
Thanks for the nice comments. There's no step by step document prepared for the same. If you need the privileges required for the schemas, please provide your email id, will send the same
Hi Yegavalli, Thanks for your patience. We have uploaded the steps in our blog. You can refer our blog for more details: infraxpertzz.com/migrating-on-premise-oracle-database-to-aws-rds-oracle/
Hi Kranthipalle, Sorry for the delayed response. We were busy in building our blog. You can now check the details at : infraxpertzz.com/migrating-on-premise-oracle-database-to-aws-rds-oracle/
Hi if I not have password for schema migrate can be use user system instead ? for only 1 user to migrate other schemas ot limit for user schema for import.
this error occurred when create source endpoint and test connection. Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to connect Network error has occurred, Application-Detailed-Message: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
Thanks for the comments. As mentioned in the video, the steps from EC2 Oracle to RDS and On-prem Oracle db to RDS are same. The source endpoint needs to updated with the on-prem server name and test the connection before u proceed. There's no extra steps to be taken from db perspective other than having the respective ports open
@@InfraXpertzz But connecting to my onprem db to aws need some vpn connection share if you have such documents or video I tried using openvpn but this is only one way that will not work plse share some documents so that I can test this thing on my home setup
From ur home setup u need to build a DNS server and host the dns entries of ur server, which is beyond scope of a DBA. So, EC2 instance has been used in this case. Once incoming connections from internet reach ur virtual machine through the dns name, the connections would work. Try connecting from another laptop from SQL developer to ur VM. If that works, then AWS can also reach
Request you to go through the video. Obviously firewall port opening is needed from onpremise side. From aws, you need to open the inbound connections as given in the video for your on premise host ip
@@InfraXpertzz thank you. Got that. With respect to Aws billing. I could see u accepted 350+ dollars a month. Will you be able to delete instance on same day to ensure u dont get any cost?
Please select burstable instance. The instance which was selected had different storage class. So the amount was high. Selecting burstable instance, would cost you a lesser amount. Please keep in mind that dms service isn't free
Thansk bhai! Good job! I am watching your AWS RDS videos..Please upload as much as possible....
Tha ks a lot for the nice comments. Please do like, share and subscribe
Requesting you to let us know if you have anything in specific too. We will try checking on the same and if possible, will upload the same
Thanks you Sir, Please upload more and more, your hard work is highly appreciated
Thanks a lot for the nice review. Please do like, subscribe and share. You can find more videos in the Playlist. Link is provided in the video description
Nicely represented.. Very good.. It will be definitely help us doing migration.
Thanks a lot for the nice reviews which motivates us to deliver more
how about the complex dbswhere the challenges are in primary key, indexes, etc.? I was reading some articles and find its complex. Simple table migration is straight forward but where the triggers, primary key, indexes, etc. are little bit overwhelming. Your thoughts?
Yes it totally depends from case to case. This is a simple test to show the steps involved. But with Complex databases, it needs more involvement and needs to be checked with test replica databases before actual production migration
Why give so much privileges ,grant only dba .still not able to understand data have migrated or not from premises.which method used?
now since 11g is no more supported, can the target be 19c with the source as 11g when using DMS?
Yes why not. You can
Thanks for your efforts of sharing your knowledge. . Keep rocking
Thanks a lot for your kind words. You can also get the details from the blog mentioned in the description
very nice and well explained . is it possible to add 1 slide with end to end architecture source , rds , target scripts and permissions etc .. that would help everything in glance for learners
Thanks a lot for the nice comments. Please refer to
infraxpertzz.com/migrating-on-premise-oracle-database-to-aws-rds-oracle/
for detailed steps and permissions involved for the migration. Hope it helps
Hi I am successfully migrated my database but in my ddl i have default value 0 which not migrated. Can you please help me. On how to migrate with ddl in ful load
Hi bro ,, i have an error during migration , can u help me plz ?
This is the error: Test Endpoint failed: Application-Status: 1020912, Application-Message: ORA-12543: TNS:destination host unreachable OCI error.
Hi, I have an error like this:
Last Error Endpoint initialization failed. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2859] [1020401] Cannot retrieve Oracle archived Redo log destination ids;
Can you help me?
Is your backup on? If your backup retention is set to 0, then your backup is off, thus disabling your archive logs. Please check whether the archive log is enabled at target or not
Hi bro
I want to use source db from virtual box on windows , can u tell me how I configure dns server name in virtual box and put it in source end point ?
Thanks.
I don't think it's possible until u register ur domain. Simply setting up the dns won't help. That dns should be visible to the outer world which is only possible after buying the domain
@@InfraXpertzz Thanks for ur quick respond bro.
Excellent!!
Thanks for the nice comments
Thank you very much for the detailed walk though.
Quick question: Is on-premise Oracle DB version matter for such migrations? Does the same process work if my on-premise Oracle DB is running on 8i/9i?
Thanks for the nice comments. Please like,share and subscribe to support us.
AWS Database Migration Service (AWS DMS) doesn't support Oracle 8i or 9i as a source. You need to upgrade your database to atleast oracle 10g version which is supported by AWS DMS
@@InfraXpertzz Thanks for your response, much appreciated.
Hello thank you for the amazing video. Since we migrated database from EC2 to aws, we already had a network connection in this case. What prerequisites need to be fulfilled if we are migrating actual client database to aws?
Hi Sukesh. Thanks for the overwhelming comments. Hope ur doubts r cleared now. The process would be the same, just the DNS name of ur on-premise server needs to be provided and u need to check whether AWS is able to reach out to the server and vice versa
Sorry to be off topic but does anyone know a way to get back into an instagram account?
I somehow forgot my password. I love any assistance you can give me
@Thomas Ray instablaster :)
Sir i need all privileges please help or post pls
Awesome badly looking this
Please let me know ur concern 😊
great work...
Glad you liked it
Thanks for your Video, it helpful for me in migration project..Please share the steps which you are following..
Thanks for the nice comments. There's no step by step document prepared for the same. If you need the privileges required for the schemas, please provide your email id, will send the same
Hi Yegavalli,
Thanks for your patience. We have uploaded the steps in our blog. You can refer our blog for more details:
infraxpertzz.com/migrating-on-premise-oracle-database-to-aws-rds-oracle/
Nice Video , But waiting for on-prem/local Database migration as per video subject. Thank You
Nice and very informative Video
Thanks for the nice review. Please do check our AWS RDS playlist for more videos. Also request you to subscribe and share our channel to support us
Provide complete document on this migration
Check the description please
Thanks you. .
Please share the document
Please share ur mail id. Will try sending soon. Down with fever. So it may take some time
Hi Kranthipalle,
Sorry for the delayed response. We were busy in building our blog. You can now check the details at :
infraxpertzz.com/migrating-on-premise-oracle-database-to-aws-rds-oracle/
Hi if I not have password for schema migrate can be use user system instead ? for only 1 user to migrate other schemas ot limit for user schema for import.
The dms user needs to migrate the data. So, there's no need to know other passwords
Please share the document if passible
Hello. Plz check the video description for link to the blog. Please like, subscribe and share
this error occurred when create source endpoint and test connection.
Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to connect Network error has occurred, Application-Detailed-Message: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
What is the db engine and version of the database u r using? Where is the db hosted?
@@InfraXpertzz ms sql rds, version 14.00.3281.6.v1
@@qaisarali9935 sorry. We donot have expertise in SQL Server database
Request if you show onprem to rds then it will be more helpful
Thanks for the comments. As mentioned in the video, the steps from EC2 Oracle to RDS and On-prem Oracle db to RDS are same. The source endpoint needs to updated with the on-prem server name and test the connection before u proceed. There's no extra steps to be taken from db perspective other than having the respective ports open
@@InfraXpertzz But connecting to my onprem db to aws need some vpn connection share if you have such documents or video I tried using openvpn but this is only one way that will not work plse share some documents so that I can test this thing on my home setup
From ur home setup u need to build a DNS server and host the dns entries of ur server, which is beyond scope of a DBA. So, EC2 instance has been used in this case. Once incoming connections from internet reach ur virtual machine through the dns name, the connections would work. Try connecting from another laptop from SQL developer to ur VM. If that works, then AWS can also reach
Rest in vpc u need to open the ports for a successful action later on
How will you enable connectivity from onpremise source to aws?
The process is same from on premise or ec2. The ports needs to be opened in SG.
@@InfraXpertzz so port opening is required from firewall to aws sg?
Request you to go through the video. Obviously firewall port opening is needed from onpremise side. From aws, you need to open the inbound connections as given in the video for your on premise host ip
@@InfraXpertzz thank you. Got that. With respect to Aws billing. I could see u accepted 350+ dollars a month. Will you be able to delete instance on same day to ensure u dont get any cost?
Please select burstable instance. The instance which was selected had different storage class. So the amount was high. Selecting burstable instance, would cost you a lesser amount. Please keep in mind that dms service isn't free
👍👍👍
Please for doc
Please find the link in the video description
Hi bro
On premises not on premise. Premises = a property whereas premise = a suggested idea