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

what is transaction to acess the language utility?

2 Answers  

What is buffer synchronization?

6 Answers  

How to monitor user accessed transactions (T-code) on a given day?

2 Answers  

what r common transport errors u faced while transporting?

1 Answers  

How you will do that?

0 Answers  

How does SAP connect to Db?

2 Answers  

After Installation of the SAP software, its giving posting period 2004. I am not able to make it to 2009 financial year.. how we make it.. what are the activities we have to do ?

1 Answers  

what is the use of Zlayer and saplayer in tms

3 Answers   HCL,

1.What is memory management? 2. Define System Monitoring? 3.How many session's are there?

3 Answers   CA, IBM, Infosys,

Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.

2 Answers  

i am working with NBFC- MNC in personal loan dept. I applied for Internal Job Position in banking Division. My overall (10 years) experience in sales and People Management and in Internal Job Posting they require person for backend activity. There will be not repotees and its individual performance job. My Question is 1. If they will ask why you want to change your field form sales to backend job what should I answer? 2. The opening is in Chennai and since 10 year I am in Gujarat so if they ask why you want to change your home town location? Arpan Thakkar

0 Answers  

When you use DB02 Transaction, You see something called as Swaps, What are they, and how the increase in swaps does affect your SAP system Performance

3 Answers