9 Replies Latest reply: Apr 9, 2011 2:20 AM by 844366 RSS

    ORA-28000: the account is locked

    844366
      hello,

      i have Oracle 10R2 DB,

      environment is Development Database.

      i want to access the database Server as SYSTEM user...
      The database is located remotely.

      When i try to connect to db as SYSTEM user on client machine it gives me error
      ORA-28000: the account is locked
      but on the DB server Box i can see the account is not locked and and i can connect to DB on that Box with SYSTEM user,but not remotly

      it would be quit helpful if any help could be provided.


      thank you..
        • 1. Re: ORA-28000: the account is locked
          KG
          Since you connect from remote ,can you verify your tns setting that you are connecting to correct database.
          If account is not locked in database you should not get the error
          • 2. Re: ORA-28000: the account is locked
            Abdul Halim
            first Be sure, you are trying to connect correct database.

            regards
            Haim
            • 3. Re: ORA-28000: the account is locked
              844366
              hello,

              there is also another database & i am able to connect to that database as system user....but why that problem with this DB.


              thanks
              • 4. Re: ORA-28000: the account is locked
                Lubiez Jean-Valentin
                Hello,


                You may check on the Database the Status of the Users as follow:
                select username, account_status 
                from dba_users
                where account_status != 'OPEN';
                If the account is LOCKED then you have just to unlock it as below:
                alter user <username> account unlock;
                You may check also the password_life_time and the failed_login_attempts in the Profile of the User SYSTEM, it may explain why this User was locked.

                This link may guide you:

                http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/policies.htm#i1006575


                Hope this help.
                Best regards,
                Jean-Valentin

                Edited by: Lubiez Jean-Valentin on Apr 9, 2011 8:40 AM
                • 5. Re: ORA-28000: the account is locked
                  844366
                  hello lubiez,

                  the output of your query is
                  SQL> select username,account_status from dba_users where acCount_status!='OPEN'


                  USERNAME ACCOUNT_STATUS
                  ------------------------------ --------------------------------
                  SYSTEM LOCKED(TIMED)
                  OUTLN EXPIRED & LOCKED
                  WKSYS EXPIRED & LOCKED
                  OLAPSYS EXPIRED & LOCKED
                  SI_INFORMTN_SCHEMA EXPIRED & LOCKED
                  OWBSYS EXPIRED & LOCKED
                  FLOWS_030000 EXPIRED & LOCKED
                  ORDPLUGINS EXPIRED & LOCKED
                  WKPROXY EXPIRED & LOCKED
                  XDB EXPIRED & LOCKED
                  ANONYMOUS EXPIRED & LOCKED

                  USERNAME ACCOUNT_STATUS
                  ------------------------------ --------------------------------
                  CTXSYS EXPIRED & LOCKED
                  WK_TEST EXPIRED & LOCKED
                  WMSYS EXPIRED & LOCKED
                  DMSYS EXPIRED & LOCKED
                  EXFSYS EXPIRED & LOCKED
                  ORDSYS EXPIRED & LOCKED
                  MDSYS EXPIRED & LOCKED
                  FLOWS_FILES EXPIRED & LOCKED
                  SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED
                  SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED
                  HR EXPIRED & LOCKED

                  USERNAME ACCOUNT_STATUS
                  ------------------------------ --------------------------------
                  APEX_PUBLIC_USER EXPIRED & LOCKED
                  OE EXPIRED & LOCKED
                  DIP EXPIRED & LOCKED
                  SH EXPIRED & LOCKED
                  IX EXPIRED & LOCKED
                  MDDATA EXPIRED & LOCKED
                  PM EXPIRED & LOCKED
                  BI EXPIRED & LOCKED
                  TSMSYS EXPIRED & LOCKED
                  SCOTT EXPIRED & LOCKED

                  32 rows selected.
                  opps..
                  what to do now...
                  
                  thanks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                  • 6. Re: ORA-28000: the account is locked
                    Azar
                    then

                    alter user system account unlock;
                    • 7. Re: ORA-28000: the account is locked
                      Lubiez Jean-Valentin
                      Hello,


                      So you can see that the user SYSTEM is LOCKED:
                      SYSTEM LOCKED(TIMED)
                      So you have to UNLOCK it by using the following statement:
                      alter user system account unlock;
                      Afterwards you may check for the DEFAULT Profile:
                      SELECT resource_name,resource_type,limit 
                      FROM dba_profiles WHERE profile='DEFAULT';
                      It's often due to a limit in FAILED_LOGIN_ATTEMPTS. It may means that someone (or some batch program) tried to connect to SYSTEM several times with a wrong password (it's just an assumption).


                      Hope this help.
                      Best regards,
                      Jean-Valentin
                      • 8. Re: ORA-28000: the account is locked
                        Abdul Halim
                        Yes, Check SYSTEM user's profile for the cause of lock .

                        Regards
                        Halim
                        • 9. Re: ORA-28000: the account is locked
                          844366
                          thank you very much Lubiez...


                          now i am able to connect to DB...


                          thank you very much for your kind support