ddic and sap*

[former_member829550]

hi all,

i have 2 questions to ask,

-

---

1) in the ides system , with client 000 the uesrs DDIC and SAP* passwords were changed and i forgot the password.*

also i don't know the passwords of any other users that exist in the client 000.

i tried to delete the user sap* from the sql command level by using the option ::

SQL> DELETE FROM EC6.USR02 WHERE BNAME='SAP*' AND MANDT='000';

SQL> ERROR at Line 1:

ORA--00942: Table or View doesnot exist.

but when i see the same table USR02 using tcode se11 it exists.

what could be the problem and how to unlock the sap* and ddic users.

-

---

2) my question is regarding ddic.

i forgot the password of ddic and suppose i unlocked it using the above statement.

but for ddic user there is no auto-generated password which exists for sap* (pass). (( i hope i am correct about this statement))

then how can i login into ddic user even when the user is unlocked and i don't have the standard or any other password.

-

---

regards,

bhupesh

[former_member829550]

thanks

[former_member1351727]

Hi ,

SAP* can be removed from USR02 table :

you need to use the schema before the table name .

As per you o/p for dbausers I undersatnd that you schema is sapr3.

So use this :

Delete from sapr3.usr02 where bname='SAP*' and mandt='000';

commit;

again try to diaply sap*

select bname from sapr3.usr02 where bname='sap*' and mandt='000';

This should not print any out put that means the sap* is removed.

Now you shouyld be able to loginto the client 000 using SAP* and pass.

if your parameter login/no_automatic_user_sap* is '0'

After this try to unlock the DDIC in client '000'.

Hope this helps.

Thanks.

[former_member829550]

hi vani,

i used the same script as what u have given as....

SQL> SELECT BNAME FROM SAPR3.USR02 WHERE BNAME='SAP*' AND MANDT='000';

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> DELETE FROM SAPR3.USR02 WHERE BNAME='SAP' AND MANDT='000';

ERROR at line 1:

ORA-00942: table or view does not exist

again the same error is occuring. this is really frustating.

regards,

bhupesh

[Former Member]

Please try this..

Schema id should be SAPSR3 not SAPR3.

Try the below command.

SQL> SELECT BNAME FROM SAPSR3.USR02 WHERE

BNAME='SAP*' AND MANDT='000';

Cheers

Deepu

[former_member829550]

hi deepu,

i was successful in deleting the sap* from sql command level.

but i got stuck with another problem.

when i am trying to login client 000 with user sap* and password pass , it is going into dump (ie., TIME_OUT) dump.

i tried it for 10 times.

but the problem persists.

help needed.

regards,

bhupesh

[Former Member]

Hi,

It think u havn't issue a commit command after executing

delete statement.have you ?

SQL> SELECT BNAME FROM SAPSR3.USR02 WHERE

BNAME='SAP*' AND MANDT='000';

SQL> COMMIT;

This shd solve the problem.

Cheers

Deepu

[Former Member]

Hi there,

Try using the below script with the same casing,

DELETE FROM <sid>.USR02

WHERE BNAME='DDIC' and MANDT='<CLIENT No>';

eg.

DELETE FROM dqg.USR02

WHERE BNAME='DDIC' AND MANDT='000';

The reseted password will be 'pass'.

Hope this helps,

Regards,

Pranay

[Former Member]

Hello,

Make sure that your system ID is EC6, because if its not then your script won't run. See script below for your reference

DELETE FROM <db name>.USR02

WHERE BNAME='SAP*' AND MANDT='000'

<db name> is your database name which is ussually same with your system id. Also take note that this is case sensitive.

[former_member829550]

hi richard,

DELETE FROM EC6.USR02 WHERE BNAME='SAP*' AND MANDT='000';

this is what i used.

when i checked the oracle directory for the <DB>sid , it has EC6.

ie., oracle -

---

EC6----

---

102, oraarch, origlogA, origlogB....

now the <DB>sid is also same and i executed the same query as above.

but still the same error occurs.

can u tell me where i went wrong and what is the excat problem i am facing.

regards,

bhupesh

Edited by: mudari bhupesh on Jul 13, 2008 2:56 PM

[Former Member]

Try using SQL PLUS and log-in as SYSDBA then run the script. I think your problem is you are using a wrong schema name. To view schema names, use the script below.

SELECT USERNAME FROM DBA_USERS

from the result of the script above, you could then select the appropriate schema to use.

Goodluck!

[Former Member]

Hi,

It's not Database id ..it is the Schema ID.Please get the exact Schema id from your database.

Regards

Deepu

[former_member829550]

hi richard,

when i used the script what u gave.the following options has been displyed.

SQL> SELECT USERNAME FROM DBA_USERS;

USERNAME

----

---

OPS$ECC6SERVER\EC6ADM

OPS$ECC6SERVER\SAPSERVICEEC6

SYS

SYSTEM

SAPSR3

OUTLN

TSMSYS

DIP

DBSNMP

Now in them which is the database id and which is the schema id.

i hope my Database id is EC6 and what is my schema id.

regards,

bhupesh

[former_member829550]

hi deepu,

what excatly is the database id and what is the schema id.

where can i find the database id and schema id in the my system.

regards,

bhupesh

[Former Member]

Hi,

what i ment is database id = DB<SID> (i.e database system id) i assume DBSID is EC6 and the schema id should be SAPSR3.

cheers

deepu

Edited by: Deepu Babu on Jul 14, 2008 8:25 AM

[former_member829550]

so should i use the schema id or the db<sid> for the above mentioned sql script.

regards,

bhupesh

[Former Member]

Hi,

Once you are done with unlocking sap* user you can later reset the ddic password from sap* user.

Please search the forum you will find number of similar questions. here is one [thread|] which i found.

Rakesh