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

To check if oracle processes are running?

2 Answers  

an user schedules a background job.If you monitor in sm37 that job is shown as being run by a different user.how do you find out the actual user who is responsible for it?

3 Answers   iGate,

Advantage of central instance on application server

4 Answers   IBM,

how to know whether a user in sap system is DIALOG or SERVICE user?

4 Answers   IBM, TCS, Wipro,

How to install multiple Central Instances on the same physical machine?

9 Answers   IBM, Siemens,

How to handle the situation where-in SAP isn't available?

1 Answers  

Archive Strcuk

2 Answers   Infosys,

What is the deference between JSPM and SDM??

2 Answers   ABC,

Background jobs scheduling possible for operating system level in SAP Basis. discribe the details

6 Answers  

You want to transport users between different clients. How would you do that?

1 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  

How to take a sap backup using BRTOOLS explain the procedure? When using BRTOOLS, which backup device, you are used (Drive/tape)?

1 Answers   IBM, Terrenos,