https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-error-ORA-28000-the-account-is-locked/m-p/147222#M52642 <P>Hi everyone, i was trying to insert into Oracle 12c DB and i got the error "<EM><STRONG>cannot create PoolableConnectionFactory (ORA-28000: the account is locked)</STRONG></EM>". I have tried to run the insert statement generated manually and it worked fine but NiFi gives the <EM><STRONG>account is locked</STRONG></EM> error. What could possibly the cause of this error?</P> Thu, 26 Jan 2017 14:09:43 GMT joshua_adeleke 2017-01-26T14:09:43Z https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-error-ORA-28000-the-account-is-locked/m-p/147222#M52642 <P>Hi everyone, i was trying to insert into Oracle 12c DB and i got the error "<EM><STRONG>cannot create PoolableConnectionFactory (ORA-28000: the account is locked)</STRONG></EM>". I have tried to run the insert statement generated manually and it worked fine but NiFi gives the <EM><STRONG>account is locked</STRONG></EM> error. What could possibly the cause of this error?</P> Thu, 26 Jan 2017 14:09:43 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-error-ORA-28000-the-account-is-locked/m-p/147222#M52642 joshua_adeleke 2017-01-26T14:09:43Z https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-error-ORA-28000-the-account-is-locked/m-p/147223#M52643 <P>Issue resolved! It was due to an account lock that was only discovered when i disconnected and tried reconnecting with SQL developer. Account has been unlocked and all good!</P> Thu, 26 Jan 2017 16:42:32 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/PutSQL-error-ORA-28000-the-account-is-locked/m-p/147223#M52643 joshua_adeleke 2017-01-26T16:42:32Z