Skip to Content
avatar image
Former Member

Oracle Password gets lock

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 21, 2009 at 10:38 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2009 at 10:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Aug 07, 2009 at 05:53 AM

    problem solved with New SAP license

    Add comment
    10|10000 characters needed characters exceeded