This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Aug 7, 2013 10:04 AM by EdStevens RSS

how to unlock system account??

967764 Newbie
Currently Being Moderated
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

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
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points