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

Explain the method of making client copy, how can we do it when the SAP user is not there in the system?

1 Answers  

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,

what are the pros and cons of auto extend of table spaces?

0 Answers   AT&T,

What should be the approach for writing a BDC program?

3 Answers  

What are the regular activities u do in solution manager and how

0 Answers  

Can SAP patches be installed when other users are online?

8 Answers   TCS,

what's the advantage of st03g over st03n?

7 Answers   Satyam,

i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?

1 Answers   HCL, Pyrotech Odyssey,

How to do client copy?

1 Answers  

What are the different types of transport requests in sap basis?

1 Answers  

What is the use of account id in logon tab?

0 Answers   Terrenos,

What is ERP?

10 Answers