1 Reply Latest reply on Jan 10, 2011 1:26 PM by varun4dba

    unable to connect sql state = s1000

      unable to connect sql state = s1000
      oracle - odbc - ora 28000 : account is locked

      this was happened while connecting a user for test connection.
      can anyone resolve this issue?
        • 1. Re: unable to connect sql state = s1000
          Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account

          Action: Wait for PASSWORD_LOCK_TIME or contact DBA



          if you are having sysdba priviledge:--

          connect /as sysdba

          alter user username account unlock;

          where username will be the username who was trying to connect for test.

          Edited by: varun4dba on Jan 10, 2011 6:53 PM