Home » RDBMS Server » Server Administration » Account Locked (SQL Developer, 4.0, Windows 8)
Account Locked [message #635752] Wed, 08 April 2015 03:08 Go to next message
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
Re: Account Locked [message #635753 is a reply to message #635752] Wed, 08 April 2015 03:16 Go to previous messageGo to next message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
As SYSTEM:
SQL> ALTER USER HR ACCOUNT UNLOCK;
Re: Account Locked [message #635754 is a reply to message #635753] Wed, 08 April 2015 03:21 Go to previous messageGo to next message
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 ...'.

Re: Account Locked [message #635755 is a reply to message #635754] Wed, 08 April 2015 03:24 Go to previous messageGo to next message
Littlefoot
Messages: 21333
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you were told: connect as SYSTEM, then unlock the account.
Re: Account Locked [message #635756 is a reply to message #635754] Wed, 08 April 2015 03:25 Go to previous messageGo to next message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
No, you must log in with a privileged account, such as SYSTEM. Here is some documentation you could read.

Re: Account Locked [message #635757 is a reply to message #635756] Wed, 08 April 2015 03:43 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
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 Go to previous messageGo to next message
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 !
Re: Account Locked [message #635762 is a reply to message #635761] Wed, 08 April 2015 04:23 Go to previous messageGo to next message
Littlefoot
Messages: 21333
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).
Re: Account Locked [message #635764 is a reply to message #635761] Wed, 08 April 2015 04:32 Go to previous messageGo to next message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
You shouldn't be using SYSDBA user for general administration. Who is your DBA?
Re: Account Locked [message #635765 is a reply to message #635764] Wed, 08 April 2015 04:35 Go to previous messageGo to next message
OraGuy21
Messages: 5
Registered: April 2015
Location: India
Junior Member
Wanted to write some SQL queries and hence
wanted to log-in to SQL Developer.
Re: Account Locked [message #635767 is a reply to message #635764] Wed, 08 April 2015 04:36 Go to previous messageGo to next message
OraGuy21
Messages: 5
Registered: April 2015
Location: India
Junior Member
SYSTEM/MANAGER is not working.
Re: Account Locked [message #635769 is a reply to message #635767] Wed, 08 April 2015 04:42 Go to previous message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
"manager" is the default password so I'm glad it doesn't work! Again, who is your DBA?
Previous Topic: Upgrade oracle 11.2.0.1 to 11.2.0.4 on same windows server
Next Topic: ORA-27101: shared memory realm does not exist
Goto Forum:
  


Current Time: Sat Jan 20 19:57:53 CST 2018

Total time taken to generate the page: 0.19802 seconds