Help - Search - Members - Calendar
Full Version: ERROR ORA-28000
Oracle DBA Forums > Oracle > Oracle Forum
CHANDRASEKAR
Sir,

Our database server is loaded with ORACLE 10g. Yesterday all our user reported that they could not loggin and it is throwing error ora-28000. Then we found that the particular ORACLE USER ACCOUNT GOT LOCKED. The account was unlocked using the cmd sql>alter system <user> account unlock; the user altered and the system came to normal. I want to find out why the account is locked. Where can i find reasons for this incident.please guide.

chandrasekar
Florin Aparaschivei
On Oracle site:
http://download.oracle.com/docs/cd/B19306_...es.htm#i1012688
burleson
Hi Chandrasekar,

>> I want to find out why the account is locked.

It's based on whatever rules that you have defined, usually failed login attempts.


********************************************************************************
*****
>>Yesterday all our user reported that they could not loggin and it is throwing error ora-28000

See here: http://www.dba-oracle.com/sf_ora_28000_the...t_is_locked.htm

ORA-28000: the account is locked

Cause: The user has entered wrong password consequently for maximum number of times specified by the user"s profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account

Action: Wait for PASSWORD_LOCK_TIME or contact DBA

Oracle MetaLink offers information regarding ORA-28000: "The DBSNMP Account Becomes Locked And Database Shows A Status Of Down With A Metric Collection Error Of 'Ora-28000' " occurring in Enterprise Manager Grid Control 10.1-10.2. ORA-28000 in DBSNMP is shown when DBSNMP is locked when trying to navigate to Database Monitoring Configuration page with the error:

error java.sql.SQLException: ORA-28000: the account is locked

This can also be shown when as the console is running, yet the database shows a down status with this error:

ORA-28000: the account
is locked (DBD ERROR: OCISessionBegin).

Sporadic at first, if the password is reset, the DBSNMP is locked daily.

Stored in the targets.xml file, if the the dbsnmp password is not in sync with the reset DBSNMP password, ORA-28000 will be thrown. If this happens, the Agent account will be locked because it has attempted to logon to the database incorrectly a certain amount of times, and ORA-28000 will become a problem.
CHANDRASEKAR
Sir,

Failed login attempts is set to 10 in the profiles. It may be due to an user attempting to login without knowing the passwd.How to find out who attempted and at what time the user has attempted.Is there any way to find out.please guide.

chandrasekar





QUOTE (burleson @ Jun 27 2008, 12:35 PM) *
Hi Chandrasekar,

>> I want to find out why the account is locked.

It's based on whatever rules that you have defined, usually failed login attempts.
********************************************************************************
*****
>>Yesterday all our user reported that they could not loggin and it is throwing error ora-28000

See here: http://www.dba-oracle.com/sf_ora_28000_the...t_is_locked.htm

ORA-28000: the account is locked

Cause: The user has entered wrong password consequently for maximum number of times specified by the user"s profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account

Action: Wait for PASSWORD_LOCK_TIME or contact DBA

Oracle MetaLink offers information regarding ORA-28000: "The DBSNMP Account Becomes Locked And Database Shows A Status Of Down With A Metric Collection Error Of 'Ora-28000' " occurring in Enterprise Manager Grid Control 10.1-10.2. ORA-28000 in DBSNMP is shown when DBSNMP is locked when trying to navigate to Database Monitoring Configuration page with the error:

error java.sql.SQLException: ORA-28000: the account is locked

This can also be shown when as the console is running, yet the database shows a down status with this error:

ORA-28000: the account
is locked (DBD ERROR: OCISessionBegin).

Sporadic at first, if the password is reset, the DBSNMP is locked daily.

Stored in the targets.xml file, if the the dbsnmp password is not in sync with the reset DBSNMP password, ORA-28000 will be thrown. If this happens, the Agent account will be locked because it has attempted to logon to the database incorrectly a certain amount of times, and ORA-28000 will become a problem.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.