how to unlock system account??
967764Oct 11 2012 — edited Aug 7 2013Hi 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
C:\WINDOWS>sqlplus
SQL*Plus: Release 10.2.0.3.0 - 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:
ERROR:
ORA-01031: insufficient privileges
Enter user-name: system
Enter password:
ERROR:
ORA-28000: the account is locked
Enter user-name:
Thanks in advance......
Edited by: sreeprasad on Oct 11, 2012 8:02 AM