cancel
Showing results for 
Search instead for 
Did you mean: 

1st time login problem.. on ECC 6.0 on AS ABAP

Former Member
0 Kudos

Dear Friends,

After installing successfully ECC 6.0 on HP-Ux11.23 itanium server i am unable to log on server.

the default password of SAP* [06071992]& DDIC [19920706] is not working..

please advice:

i ahave also tried:

<b><b><b>connect / as sysdba;

sql> delete from sap<sid>.usr02

where bname='sap*'</b></b> </b>

and mandt='000';

but giving errors...

please help..

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Sumanta,

Couple of points. During installation did you supply any password for users DDIC /SAP* other than the default ones? IF yes then try those passwords.

Also for user SAP* try password PASS.

Also set the value of profile parameter login/no_automatic_user_sapstar to 0 in your profile file. Normally I would advise doing it through RZ10 but in case your not able to logon into the system you will have to do it on OS level.

Please award points for useful answers

Regards.

Ruchit.

Message was edited by: Ruchit Khushu

JPReyes
Active Contributor
0 Kudos

Hi Sumanta,

If you deleted SAP* from the DB try login with password PASS as suggested by Ruchit

Edit the profile directly from the OS, go to <drive>:\usr\sap\<sid>\sys\profile\ -> edit the profile with notepad or vi and insert the two new parameters, save it and restart the system.

Regards

Juan

Please reward with points if helpful

Answers (6)

Answers (6)

Former Member
0 Kudos

Hello Sumanta,

You mean you had changed the password of SAP*/DDIC during installation ?

Regards.

Ruchit.

Former Member
0 Kudos

<b>Problem Resolved:</b>

For ECC 6.0

When I had run Installation Master CD,

I had given the password for different user.

And after installation it takes password for SAP* & DDIC

that password what i had given for master-password.

Thanks...

Now,I will do post installation activities..

Nice to get quick reply..

Former Member
0 Kudos

hello sumantha

u mentioned about a different user apart from sap*/ddic can you let us know which user it was that you got to make changes to while performing the installation.

my point is that could any other user be existing prior to installation other than sap* & ddic.

regards,

sri srirangam

Former Member
0 Kudos

SAP is: ECC 6.0

DB is: Oracle 10g

Os is: HP-UX 11.23

JPReyes
Active Contributor
0 Kudos

HI Sumanta,

That command should work!... are you sure you installed java+abap? or just java?

Are you logged on to OS as db admin, when running the command?

Follow steps on this thread!

Dont forget the points.

Regards

Juan

Former Member
0 Kudos

I have inserted the parameter in <b>default.pfl</b> file

login/no_automatic_user_sapstar = 0;

Now I am trying to delete SAP* from *SQL prompt but.. SAP<SID>.usr02 is not taking ..

suggest what should be schema name, i have tried..

<b>SQL> delete from SAPJMD.usr02 where bname = 'SAP*' and mandt = '000';</b>

but its throwing error.. table not found...

JPReyes
Active Contributor
0 Kudos

DB IS MSSQL or ORACLE???

Procedure is different for MSSQL

Regards

Juan

Former Member
0 Kudos

hello Sumanta,

Did you try password PASS for SAP*?Also please try to set value of profile parameter login/no_automatic_user_sapstar to 0.

Regards.

Ruchit.

Former Member
0 Kudos

<b>Dear Friends,

I did not change any password during installation.

:

I did not delete sap* from database level also..!

Plese send some info.

If any chance reseting UFLAG field.... with compelte sql command...

Thanks..</b>

JPReyes
Active Contributor
0 Kudos

Hi Sumanta,

<b>connect / as sysdba;

sql> delete from sap<sid>.usr02

where bname='sap*'

and mandt='000';</b>

This is deleting SAP* from the table usr02 in the oracle DB.

You have to change the system profile parameter login/no_automatic_user_sapstar is set to 0 (and the system restarted after that)

You should be able to login to using SAP* to client 000 with the default password SAP/PASS or SAP/06071992

Regards

Juan