Support Questions
Find answers, ask questions, and share your expertise

Cloudera CDH and Oracle Database Migration

Highlighted

Cloudera CDH and Oracle Database Migration

New Contributor

Hello,

we need to migrate the oracle databases used by cloudera from an oracle server 12.1 to an oracle server 19c.

Are there any guidelines or documentation explaining how to change the oracle server used by Cloudera CDH 5.15 and how to migrate the oracle databases used by Cloudera CDH?

Thank you all.

5 REPLIES 5
Highlighted

Re: Cloudera CDH and Oracle Database Migration

Master Collaborator

@Alex_IT All you need is a backup of the CM DB and then you have to create the CM DB on Oracle 19c and dump the old backup there. 

Then you have to point the db.properties file to the new DB server. This doc can give you a high level steps with respect to DB migration but at core the objective is same. 

https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_ag_migrate_postgres_db_to_oracle...


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Highlighted

Re: Cloudera CDH and Oracle Database Migration

New Contributor

Hi, thanks for the reply.
The link you suggested is a great guide to migrate the CM DB to the new oracle instance.
I also need to migrate the other databases e.g. Sentry DB, Hue DB and Hive DB.
Is there a procedure for this too?
Thanks in advance.

Highlighted

Re: Cloudera CDH and Oracle Database Migration

Master Collaborator

@Alex_IT Yes Almost the same but for you ease take a look of: 

1. Migrating Hue Database 

2. Migrate Sentry DB


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Highlighted

Re: Cloudera CDH and Oracle Database Migration

New Contributor
Hi, thank you for your reply, I have read the articles you suggested and I found them very useful. Since in our case, we are changing the oracle server 12 for an new oracle server 19, I thought to proceed like this: 1. Backup of oracle server 12 schemas 2. Restore the schemas on the new oracle server 19.3 3. From Cloudera Manager change the host database for cloudera services. Could this be a correct procedure? Thank you in advance.

Re: Cloudera CDH and Oracle Database Migration

Mentor

@Alex_IT 

From my Oracle knowledge, there are 2 options for migrating the same Oracle_home [DB] from 12C to 19C  if you are running 12.1.0.2 then you have the direct path see the attached matrix.

Oracle Upgrade.JPG

With this option, you won't need to change the hostname. 
The other option is to export your current schema CM ,oozie,hive,hue,Ranger etc schemas   install a fresh Oracle 19c box with an empty database, and import the old schemas this could be a challenge as you might have to rebuild indexes or recompile some database packages etc but bot are doable.

Hope that helps