Home » SQL & PL/SQL » SQL & PL/SQL » ERROR - ORA-28000: the account is locked
ERROR - ORA-28000: the account is locked [message #251302] Thu, 12 July 2007 17:09 Go to next message
lamusah
Messages: 5
Registered: March 2005
Location: Ghana
Junior Member

Hello All,

I just installed Oracle 10g.

I wanted to log into the HR database and I got the error message ERROR - ORA-28000: the account is locked.

How do I unlock the database?

Regards
Re: ERROR - ORA-28000: the account is locked [message #251305 is a reply to message #251302] Thu, 12 July 2007 17:26 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
connect as sysdba and type the command

alter user hr identified by hr account unlock;
Re: ERROR - ORA-28000: the account is locked [message #251307 is a reply to message #251305] Thu, 12 July 2007 18:11 Go to previous messageGo to next message
lamusah
Messages: 5
Registered: March 2005
Location: Ghana
Junior Member

i cannot remember the user name and password
Re: ERROR - ORA-28000: the account is locked [message #251308 is a reply to message #251307] Thu, 12 July 2007 18:42 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
just in sqlplus plus type


sys as sydba

or

'/ as sysdba'

and press return twice
Previous Topic: Syntax error
Next Topic: Database level DML triggers
Goto Forum:
  


Current Time: Sat Dec 10 03:04:42 CST 2016

Total time taken to generate the page: 0.09955 seconds