Oracle Password gets lock

[Former Member]

Dear Friends

We are on ECC6 Oracle 10g.Our oracle password gets locked frequently , could not transport request , tp connect problem ......and other problems also. everytime I am unlocking the passowrd.

Is there any parameter in oracle init file for expiry of password? or how it gets locked?

please help

regards

Vijay

[Former Member]

problem solved with New SAP license

[sunny_pahuja2]

Hi Vijay,

One of the reason for this might be password of this user is wrong in secure store and because of that it is getting locked frequently.

You can check this in default trace files and for this error is ora-28000

Thanks

Sunny

[Former Member]

Hi Sunny

How to set default password? which we gave at the time of installation or any default password for SAPSR3 and SYSTEM users?

regards

Vijay

[Former Member]

Check SAP Note : Problems with OPS$ or SAPR3 connect to Oracle

SAP note : 620540 Authentication Troubleshooting Guide

Looks like SAPSID user is getting locked, reset the SAPSID password.

SAP Note 361641, To change the password for the SAPR3 or SAP<SID> user you have to use the following command:

brconnect -u system/<syst_pwd> -f chpass -o SAPR3 -p <new_sap_pwd>

Thanks,

Govind

[Former Member]

Dear Friends

My problem is solved , it was a oracle license issue , after installtion of new SAP license problem solved

Thanks

regards

Vijay

[Former Member]

You can manage user security through user profiles. Can set parameters like

FAILED_LOGIN_ATTEMPTS - failed login attempts before the account is locked

PASSWORD_LIFE_TIME - limits the number of days the same password can be used for authentication

PASSWORD_REUSE_TIME - number of days before a password can be reused

PASSWORD_REUSE_MAX - number of password changes required before the current password can be reused

PASSWORD_LOCK_TIME - number of days an account will be locked after maximum failed login attempts

PASSWORD_GRACE_TIME - number of days after the grace period begins during which a warning is issued and login is allowed

PASSWORD_VERIFY_FUNCTION - password complexity verification script

...but there is no generic parameters for orainit file.

P.D.:This is SolMan forum. There is specific forum for Oracle questions.

Good luck.