Friday, June 4, 2010

Shared memory error in java

If Java engine doesn't start and there is shared memory error and the java logs says that ORA-28000 Account is locked, then check by command desc dba_users and fire query
-) select username, account_status from dba_users;

to find out the status for sapsr3db user; If it is locked then unlock the same with command;
-) Alter user sapsr3db account unlock; ( Here sapsr3db is for Java alternatively sapsr3 will be for ABAP)
After the same gets unlocked there is a SAP Note 951167- ORA-28000; the account is locked you can prevent the same from unlocking again;
To check FAILED_LOGIN_ATTEMPTS profile ;

Select limit from dba_profiles where profile='DEFAULT' and resource_name ='FAILED_LOGIN_ATTEMPTS';

If the limit is not set to unlimited, you may set the same with the following command;
Alter profile DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
:)

No comments: