Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Updating/Changing External Db for Cloudera Manager and Hive

Updating/Changing External Db for Cloudera Manager and Hive

Explorer

Hello Team,

 

Require your help for below.

 

1. We have Cloudera Cluster running with External DB as Oracle used by Cloudera Manager, Hive, Navigator, Sentry, Oozie, Hue, etc.

 

There are some issues at existing Oracle DB due to which we planning to migrate to another External Oracle Instance as DB for services mentioned in step 1.

 

Oracle DBA helping us to Clone Data from Original Oracle DB to new Oracle DB.

 

I just wanted to verify steps which i mentioned below.

 

1. Stop the Cluster, Stop the cloudera Manager and Agent(all Nodes)

2. Ask Oracle DBA to clone the DB

3. Oracle DBA will provide new Oracle DB details

4. Will update Oracle DB details from command line to Cloudera Manager DB.properties

5. Start the Cloudera Manager and agent(all Nodes)

6. All ok, then update configs for HIVE, Sentry, Hue, Oozie with new Oracle DB details

7. Start each service 1 by 1.

 

Kindly confirm if i am missing any steps.

 

- Vijay 

1 REPLY 1
Highlighted

Re: Updating/Changing External Db for Cloudera Manager and Hive

Contributor
I have done similar for myself . The steps you mentioned above looks fine.
Don't have an account?
Coming from Hortonworks? Activate your account here