After rebooting the HDP physical server hive metastore and hive server2 is throwing error

[#1]

Hi Dears,

After rebooting the HDP physical server hive metastore and hive server2 is starting but after couple of seconds throwing error "DB account locked" & going down.

HDP Version: 2.6.3

Ambari version: 2.6.0

Data base: Oracle 12c

Any help will be highly appreciated.

[#2]

@Ayush Garg

That's typical a database error, you might need a DBA to help you if you don't have DBA access to the underlying Oracle database. You should also investigate whether the {hive_user} password didn't expire

If you have DBA privileges then you need to login to the Oracle database to unlock the account. if your hive account user name is {hive} at the Oracle host CLI

$ connect sys /as sysdba

Once connected then run the below SQL

SQL> alter user hive account unlock;

That should do the magic, furthermore to get all the expired passwords run the below

SQL> select username,account_status from dba_users where account_status like '%EXPIRED%'
or account_status like '%LOCKED%';

If the password expired then do the following

SQL> alter user {hive_user} identified by new_password;

To avoid expiry of password like of the hive set the default profile limit to unlimited.

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; 
SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;

That should help

[#3]

@Ayush Garg

Please can you update on this thread. As stated the above error is due to the underlying oracle database user account getting locked.

If you found this answer addressed your question, please take a moment to log in and click the "accept" link on the answer. That would be a great help to Community users to find the solution quickly for these kinds of errors.

[#4]

@Ayush Garg

If you found this answer addressed your question, please take a moment to log in and click the "accept" link on the answer. That would be a great help to Community users to find the solution quickly for these kinds of errors.