cancel
Showing results for 
Search instead for 
Did you mean: 

IDES login for SAP* and DDIC

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Johnny,

Try logging in with the below details in client 800 for your IDES CRM system

Username: IDADMIN

Password: ides

Regards,

Ravi.

s1252
Participant
0 Kudos

Thank you

Your solution helped me

Former Member
0 Kudos

Hi,

Thanks it's very Helpful.

Answers (6)

Answers (6)

Former Member

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

Former Member
0 Kudos

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>

v_veeramalla
Active Participant
0 Kudos

login with sidadm

commandpromt>sqlplus

commandpromt>/as sysdba

Former Member
0 Kudos

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>

0 Kudos

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

Former Member
0 Kudos

Thanks guys,

I used the recommendations and problem was solved !

Regards,

Johnny

Former Member
0 Kudos

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

Former Member
0 Kudos

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!!!!

Former Member
0 Kudos

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