My Oracle Support Banner

After Upgrade to BDA V4.4 the MySQL Password for the BDA_ODI_REPO User is Lost, Resetting Raises:"Password hash should be a 16-digit hexadecimal number" (Doc ID 2115366.1)

Last updated on JANUARY 02, 2020

Applies to:

Big Data Appliance Integrated Software - Version 4.4.0 and later
Linux x86-64


NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.


Note when the BDA is upgraded to 4.4 MySQL is upgraded to 5.6.26 from 5.5.35.  In the scenario here, after upgrade to BDA V4.4 the MySQL password for the BDA_ODI_REPO user is lost by the user.

Trying to reset the password raises the error "Password hash should be a 16-digit hexadecimal number".



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.