1 2 Previous Next 17 Replies Latest reply: Aug 7, 2013 12:04 PM by EdStevens RSS

    how to unlock system account??

      Hi friends,
      please help me to solve this issue,

      How can i unlock the system account?
      when i am try to enter with sys account without passwords it shows the error :01031 :insufficient privileges.

      i cant enter to sqlplus using system and sys account.

      I can enter to sqlplus only with scott account. But I cant alter the system accont using scott account.

      How do i resolve this issue??

      command prompt window i am copied and pasted below . this will give u a correct picture:

      Microsoft Windows XP [Version 5.1.2600]
      (C) Copyright 1985-2001 Microsoft Corp.

      C:\WINDOWS>set oracle_sid=orcl


      SQL*Plus: Release - Production on Thu Oct 11 20:25:46 2012

      Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

      Enter user-name: sys as sysdba
      Enter password:
      ORA-01031: insufficient privileges

      Enter user-name: system
      Enter password:
      ORA-28000: the account is locked

      Enter user-name:

      Thanks in advance......

      Edited by: sreeprasad on Oct 11, 2012 8:02 AM
        1 2 Previous Next