Skip to Content
author's profile photo Former Member
Former Member

After Solution manager 4.0, cant log in with sap* or ddic

I have installed SolMan 4.0 with Java+Abap stack. I am not able to log in with sap* nor ddic. I need to delete sap* from the Oracle table but I cant find the table.

I am attempting the following statement to no avail.

DELETE from SAPR3.USR02 where mandt='000'

and bname = 'SAP*';

ERROR at line 1:

ORA-00942: table or view does not exist

Please help me!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 22, 2007 at 03:44 AM

    Hi, excellent and thanks, I had the same problem and I resolve with this comments. You must do:

    1) Erase sap* row from your DBMS

    2) Update parameters file with values indicate.

    3) Enter sap* and pass as password.

    Regards,

    Jose

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2006 at 10:58 PM

    Ok. I have figured out that the schema is different in NW04s. Its sapsr3.usr02 instead of sapr3.usr02. I deleted the sap* row from 000 and 001. When I try to login via sap* it still says

    Password logon no longer possible - too many failed attempts

    Any help is appreciated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 07:16 AM

    Hi,

    Logon to your database with orasid as user id and run this sql

    delete from sapSID.usr02 where bname='SAP*' and mandt='001';

    commit;

    After you do this you will be able to login using SAP* with password PASS.

    Please check whether no_automatic_login_ sap*(not the exact name of the parameter) is enabled.incase if it is change that.

    Regards,

    Anwer Waseem

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2008 at 04:47 PM

    First try to log in with SAP* or DDIC onto clients 000 or 001 with the master installation password.

    If those users are now locked that you will have to follow the instructions, as suggested above and log in with SAP* and password pass.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.