Reset the password for DDIC

[Former Member]

Hi

Pls let me know the steps how to reset the password of DDIC from database level at oracle . ?

kindly send me the steps

selvan

[Former Member]

hi kanthi

right , in the services.msc , sapccmsr.00 service not running . what i will do ?

selvan

[Former Member]

Hi

am not able to logon from sap front end , it showing error . then sapccmsr service also not startted , kindly help me

selvan

[Former Member]

Hi,

<u><b>Start and stop of sapccmsr service</b></u>

Sidadm# sapccm4x -stop

We are getting lots of alerts..........

And start the agents when you bring the SAP up.

Sidadm# sapccm4x -DCCMS pf= /sapmnt/<SID>/profile/<instance profile>

Regards,

Kanthi

[Former Member]

You can reset SAP* password after that logging using SAP* password PASS you can reset DDIC password for the client .

Run this in SQL*Plus

DELETE FROM SAPSID.USR02 WHERE MANDT='<CLIENT>'

AND BNAME='SAP*';

You will require additional DBA skill set to reset DDIC password ( Which is not recommanded aslo )

The best option I would suggest .

1)Delete SAP* using above query .

2)Logon using SAP* password pass

3)Reset DDIC password.

Regards ,

Santosh Karadkar

[Former Member]

You can delete user SAP* in that specific client if you even dont know password of SAP*.

After you delete SAP, you still be able to login with user SAP & password = pass.

Once you logged in system, you can reset DDIC password.

P.S Award points if helpful