Answer / kondal reddy

here u have to delete sap* from database level.(usr02
table)
and log in to 800 client with sap* and password pass.

Answer / kondal reddy

HELLO FRIEND IN DATABASE LEVEL I MEAN
RUN SQLPLUS"/AS SYSDBA"
THEN IN SQL TYPE COMMAND(JUST TRY THIS)

delete sap* FROM SAPR3.USR02 where mandt=client(800)
bname=sap*
JUST TRY FOR THIS.

Answer / kondal reddy

hello friend just b4 i send answer to u in that
sql statement is like this
SQL> delete sapsr3.usr02 where mandt='800'and
bname='SAP*';
THIS ONE IS CORRECT U CAN GO FOR THIS.

Answer / zaheer

hi kondal,
but in client 000 is not allowed for any changes in
standard table usr02.

Answer / narendranath gogineni

Kindly requesting u all Don't delete any standard users.

To Unlock the SAP* or DDIC from DB Level following:

from Command prompt: SQLPLUS/nologin
connect SYSDBA
and execute the following command
UPDATE SAPSR3.usr02 SET uflag=0 WHERE bname=USERNAME(sap*)
AND mandt=CLIENT(800)

Answer / zaheer

i try in sqlplus directly .when i enter
user as :sysdba
but password i don't know .
is there any standard password for sysdba?
pls reply

Answer / niazi

svrmgrl is the password

Answer / sandy

Pls check whether the Env. variables are set for the OS user
you have logged in..

Answer / sanjay

check the profile parameter
login/no_automatic_user_sapstar= o or 1 if this is 1 make
the vaue 0
Restart instance

If this not works then try for

SQLPLUS "/AS SYSDBA"
SQL> delete sapsr3.usr02 where mandt='800'and bname='SAP*';

Answer / zaheer

thanks,

niazi

Users are complaining that the SAP system shows a hour glass for a long time at the time of logon and they aren't able to log on to the system and users logged on are complaining of long delays going from t-code to t-code. How can you troubleshoot this problem if you can�t get to SM50 or SM66 or even logon? Why is this?

6 Answers   XYZ,

IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE ARUN FROM SD

1 Answers   Wipro,

What is VMC and what is the use of it ?

1 Answers   L&T,

WHAT ARE THE STEP BY STEP PROCESS TO APPLY PATCHES ON SAP R/3 SYSTEM?

6 Answers   Accenture, Collabera,

How to increase tables space, resizing, backups and in what situation are these done?

1 Answers  

how to connect external mail server to sap?

1 Answers   TCS,

how to send an email from EP Portal.

2 Answers   IBM,

What settings we have to do in EEWC while using slandalone SAP-CRM system.

0 Answers  

Difference between adding a data file and resizing the data file?

3 Answers   Span Systems,

Explain checkpoint?

0 Answers  

What will you observe in System log (SM21)?

1 Answers  

are any other tools other than SAP used to manage transport ? if so please provide details .

1 Answers