OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Account Locked (SQL Developer, 4.0, Windows 8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Account Locked [message #635752]

Wed, 08 April 2015 03:08

OraGuy21
Messages: 5
Registered: April 2015
Location: India

Junior Member

Hi Everyone,

While logging into SQL Developer,
am getting the message
'Account Locked'.
Am using hr/hr and how do
I resolve it ?

Thanks and regards,

OraGuy21

Report message to a moderator

Re: Account Locked [message #635753 is a reply to message #635752]

Wed, 08 April 2015 03:16

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

As SYSTEM:

SQL> ALTER USER HR ACCOUNT UNLOCK;

Report message to a moderator

Re: Account Locked [message #635754 is a reply to message #635753]

Wed, 08 April 2015 03:21

OraGuy21
Messages: 5
Registered: April 2015
Location: India

Junior Member

Am unable to log-in as hr/hr.
So, am NOT able to give the
commannd 'ALTER USER ...'.

Report message to a moderator

Re: Account Locked [message #635755 is a reply to message #635754]

Wed, 08 April 2015 03:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As you were told: connect as SYSTEM, then unlock the account.

Report message to a moderator

Re: Account Locked [message #635756 is a reply to message #635754]

Wed, 08 April 2015 03:25

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

No, you must log in with a privileged account, such as SYSTEM. Here is some documentation you could read.

Report message to a moderator

Re: Account Locked [message #635757 is a reply to message #635756]

Wed, 08 April 2015 03:43

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

SQL> alter user hr account lock;

User altered.

SQL> conn hr@pdborcl/hr
ERROR:
ORA-28000: the account is locked


Warning: You are no longer connected to ORACLE.

SQL> conn system@pdborcl
Enter password:
Connected.
SQL> show user
USER is "SYSTEM"
SQL> alter user hr account unlock;

User altered.

SQL> conn hr@pdborcl/hr
Connected.
SQL> show user
USER is "HR"
SQL>

[Updated on: Wed, 08 April 2015 03:54]

Report message to a moderator

Re: Account Locked [message #635761 is a reply to message #635757]

Wed, 08 April 2015 04:16

OraGuy21
Messages: 5
Registered: April 2015
Location: India

Junior Member

Don't have the SQL> prompt where
to type 'Conn SYS .. As SYSDBA'.

Could you let me know the Username
and Password separately ?

Thanks and regards !

Report message to a moderator

Re: Account Locked [message #635762 is a reply to message #635761]

Wed, 08 April 2015 04:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SQL Developer? Create a new connection (as SYSTEM). If you don't know SYSTEM's password, contact your DBA (or the one who installed a database you are using).

Report message to a moderator