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

If one background process took long time to run other than the usual time , what are the areas you will investigate other than SM37 ?

3 Answers  

what r errors u faced while appling patches

1 Answers  

How do you do the transports?

4 Answers  

What are common background jobs that will run in your system?

0 Answers  

How to find sap transaction codes?

2 Answers  

i have t-code su01 in crm and r3 in a financial org.i can create sap ids , unlock /lock sap ids , assign t-code, roles & assignment to users . what else can be done ? more importantly am i eligible for a job in sap basis since i am doing this job for last 2 years ?

4 Answers  

hey all, I am trying to install SAP 4.6C on a Windows 2003 server Enterprise edition. well at the time of the installation of Oracle 9.0, am I also suppose to create a database. well, If I do, then it gives me an error at the time of the installation of Database Instance at a stage where the SAP database creation takes place, If I don't then SAP database creation succeeds, all the tablespaces are created successfully, however the post oracle configuration stage gives an error, stating that an SQL statement exec failed... what should I do, Please Help....

3 Answers  

If have 5 years of experience with JD Edwards (ERP), would it be like starting from scratch to learn SAP (ERP)? I have been told that my experience with JDE is not relative to working with SAP.

2 Answers  

What do you mean by Transport domain?

2 Answers  

At o.s level where to check for system logs of sap application?

0 Answers  

What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?

0 Answers  

Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance

0 Answers