Login problem??

[Former Member]

Hello All,

After the Installation of ECC 6.0 I have forgotten my sap* & ddic password.I have deleted sap* from the database.But I need to login at least once to SAP syatem to make login/no_automatic_user_sapstar to 0 so that after restaring my server I can login with default password of sap* that is pass??Please help me how can I login to the system??

[JPReyes · Accepted solution]

You don't need to login, just change the parameter at OS level by editing the instance profile located at /usr/sap/<sid>/sys/profile/

Regards

Juan

[Former Member]

try the master password

[Former Member]

Dear Ashley,

As you have said that you have already deleted SAP* user ID from database I think the above solutions may not work. So my advice is if your's is Oracle database just login into the database level as shown below and delete the DDIC user's Password:-

1)connect to Oracle with the following command:

connect sqlplus u201C/ as sysdbau201D

This command will allow you to enter in to the oracle system and then

2) Delete the DDIC user's password in table level using the following : -

delete from sapr3.usr02 where bname='DDIC' and mandt='000';

commit;

This command will delete the DDIC user ID's password.

Now you can login through SAP GUI using DDIC and password as pass.

And you can change the profile param file as well as you can recreate the SAP* user ID in your system.

Regards,

Rahul M

Edited by: Rahul Mukka on Dec 9, 2008 1:19 PM

[Former Member]

Hi,

Login to the server.

Go to /usr/sap/sid/sys/<profile>. Open it and at last write login/no_automatic_user_sapstar = 0.

Save it then close it.

Restart the system. Its done.

Thanks,

Nitesh Jain

[Former Member]

Hi Ashley Scott ,

Exactly you dont need to login to system...

Follow these steps

1) Login to Server

2) Browse to /usr/sap/SID/SYS/profile/<Instance_profile>

3) Open with Note pad

4) At last add this line login/no_automatic_user_sapstar=0

5) Save and Close

6) Restart The Server now

It will do................

CHEERSSSSSSSSSSSSS

Regards,

Gagan Deep Kaushal