on 04-09-2007 6:56 AM
Hi there,
I installed sap ides crm 5.0. I can login with client 000, or 001. But the client 800 (that has the sample data) does not accept any given password SAP* or DDIC and now locked.
It is not accepting any more login tries and giving error "Password logon no longer possible - too many failed attempts". I cannot login to client 800 at all as I do not have any users accounts that work and both SAP* and DDIC are locked.
1. Can you please help me unlocking the sap* user for client 800. I did set the profile parameter "login/no_automatic_user_sapstar" in RZ10 as '0', but in client 000, but that does not unlock 800 users.
2. For user 'SAP' in client 800 I used passwords (06071992, pwd given during installation, PASS) but none of them worked. Can you please suggest any password that I could use to login for SAP or DDIC.
Any suggestion will be really appreciated. Thanks.
Regards,
Johnny
Hi Johnny,
Try logging in with the below details in client 800 for your IDES CRM system
Username: IDADMIN
Password: ides
Regards,
Ravi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you havent changed the default password for DDIC and if DDIC isnt locked try the following password 19920706. Reverse of SAP* password.
If ddic is locked then u can unlock it from SQL command.
In the cmd prompt proceed as under:
SQLPLUS /NOLOG
CONN /AS SYSDBA.
SELECT BNAME, UFLAG FROM SAP<INSTANCE ID>.USR02 WHERE UNAME = 'DDIC'
If uflag is not 0 then ddic is locked.
Proceed as under to unlock it.
UPDATE SAP<INSTANCE ID>.USR02 SET UFLAG = 0 WHERE UNAME = 'DDIC' AND MANDT = '800';
COMMIT;
This will unlok the ddic user and login with the default password.
Dont forget to award points if resolved.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guys
I am trying to perform the following and I am getting this error
C:\>Sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 21 11:02:12 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> conn /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL> conn /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Asiam
same i have get this error. r u got any solution pls tell me.....
C:\>Sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 21 11:02:12 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> conn /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL> conn /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL>
Hi Asiam,
The above error clear says that system unable to find your oracle home location.
Make sure Oracle service is started and oracle is up and running
Navigate to your oracle home location and then try to connect to oracle as sqlplus "/as sysdba"
if you are able to connect to oracle then there is some problem in path environment variable.
Thanks,
hari.B
Thanks guys,
I used the recommendations and problem was solved !
Regards,
Johnny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can delete sap*
Go to <b>cmd</b> prompt.
Sqlplus /nolog
conn /as sysdba
<b>sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;</b>
after doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).
i hope it will help you.
kiran kumar.v
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
first of all give the entry login/no_automatic_user_sapstar = 0 in the instance profile.
restart the cluster and proceed.
then try login using sap* and pass it will work.
reward with points!!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try deleting the record for the entry corresponding to user SAP* from the table USR02 and then login into client 800 with default password.
Regards,
sowmya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.