Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

PutSQL error: ORA-28000: the account is locked

avatar
Expert Contributor

Hi everyone, i was trying to insert into Oracle 12c DB and i got the error "cannot create PoolableConnectionFactory (ORA-28000: the account is locked)". I have tried to run the insert statement generated manually and it worked fine but NiFi gives the account is locked error. What could possibly the cause of this error?

1 ACCEPTED SOLUTION

avatar
Expert Contributor

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!

View solution in original post

1 REPLY 1

avatar
Expert Contributor

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!