Skip to Content
avatar image
Former Member

SAPSID User Locked

Hi ,

From oracle audit feature we came to know that sapsid user account was locked because someone entered the wrong password,from the audit file which is generated by Oracle we came to know the Server name,O/S user name who has entered the wrong password.

Now my question is Server name which is identify by thru oracle audit is an application server where no oracle binary is resided(only tnsping is there) means we can't run sqlplus thru application server then how can be sapsid user locked thru application server.

Regards

Tarun Mittal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 27, 2009 at 02:04 PM

    You need to know how an application server connects to the database in the first place. In short this is how:

    - when you start sap, it tries to connect to the db with the OPS$ user. sidadm is able to logon without password.

    - the OPS$ user has the password of the SAPSID account stored in the table SAPUSER

    - now SAP can logon with SAPSID/pw

    So in your case, i could be that you changed the password of SAPSID, but did not update the entry in the SAPUSER table. This way the application server gets the old password and the SAPSID user is locked.

    Remember, you should always use BR*Tools to change the SAPSID password, because it will take care of the SAPUSER table as well.

    Regards, Michael

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Michael,

      We have checked the last date of reset password as given below.

      NAME CTIME PTIME

      -


      -


      -


      SAPSID 26-MAY-04 26-MAY-04

      it means nobody has changed the password even there is no change in nls_lang parameter as well as nobody has authorization to run the DBCO transaction code.

      Then, How can be the account lock thru application server.

      Kindly suggest.

      Thanks,

      Tarun Mittal