on 11-02-2006 11:43 AM
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..
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hello Sumanta,
You mean you had changed the password of SAP*/DDIC during installation ?
Regards.
Ruchit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SAP is: ECC 6.0
DB is: Oracle 10g
Os is: HP-UX 11.23
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.