Home » RDBMS Server » Security » Oracle Login Fail
Oracle Login Fail [message #542941] Sat, 11 February 2012 01:54 Go to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Please guide how to unlock the account
ORA-28000 :the account is locked.


Thanks in advance.

Re: Oracle Login Fail [message #542942 is a reply to message #542941] Sat, 11 February 2012 01:58 Go to previous messageGo to next message
John Watson
Messages: 4686
Registered: January 2010
Location: Global Village
Senior Member
ALTER USER,
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_4003.htm#i2058207
Re: Oracle Login Fail [message #542945 is a reply to message #542942] Sat, 11 February 2012 02:06 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Link is not opening.
Re: Oracle Login Fail [message #542946 is a reply to message #542945] Sat, 11 February 2012 02:07 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

its opening now. thanks . I will check it out.
Re: Oracle Login Fail [message #542947 is a reply to message #542946] Sat, 11 February 2012 02:11 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

its asking username and password when try to open it through SQLplus
Re: Oracle Login Fail [message #542948 is a reply to message #542947] Sat, 11 February 2012 02:15 Go to previous messageGo to next message
John Watson
Messages: 4686
Registered: January 2010
Location: Global Village
Senior Member
You need to show us what you are doing. Use copy/paste to copy your SQL*Plus session here. And format it with [code] tags, How to use [code] tags and make your code easier to read or I won't look at it. like this:
c:\users\john\home>sqlplus scott/tiger

SQL*Plus: Release 11.2.0.3.0 Production on Sat Feb 11 08:14:03 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options


Session altered.

orcl>

Re: Oracle Login Fail [message #542949 is a reply to message #542948] Sat, 11 February 2012 02:27 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Below error massage is coming up.

C:\Users\Administrator>sqlplus scott/tiger

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Feb 11 13:52:27 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
Re: Oracle Login Fail [message #542950 is a reply to message #542949] Sat, 11 February 2012 02:30 Go to previous messageGo to next message
John Watson
Messages: 4686
Registered: January 2010
Location: Global Village
Senior Member
What does this have to do with the ORA-28000 ? If you have fixed that, please say so (with a description of how) and open a new topic for this issue.
Re: Oracle Login Fail [message #542952 is a reply to message #542949] Sat, 11 February 2012 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Show us how you get the first error using SQL*Plus.

In the end, better ask your DBA as, most likely, you will not have the privilege to unlock the account.

Regards
Michel

[Updated on: Sat, 11 February 2012 02:51]

Report message to a moderator

Re: Oracle Login Fail [message #542956 is a reply to message #542952] Sat, 11 February 2012 03:08 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

When I try to connect from Toad to database.
I am not able to connect the database from net Manager also.

[Updated on: Sat, 11 February 2012 03:10]

Report message to a moderator

Re: Oracle Login Fail [message #542958 is a reply to message #542952] Sat, 11 February 2012 03:17 Go to previous message
oracle@learner
Messages: 67
Registered: October 2011
Member

When I try to open the application, there was database connection fail.
WHen I try to connect database one massage pop New password and Verification
I entered new password:tiger verification:tiger. After I was able to open the database. But after restart the server. And try to connect database it say Account is locked.
Previous Topic: I want to get the user login/logout information for past 30 days
Next Topic: How check the Audit is enabled for particular schema
Goto Forum:
  


Current Time: Thu Oct 23 17:25:22 CDT 2014

Total time taken to generate the page: 0.10056 seconds