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 Hour Glass state? and how does it be resolved

2 Answers  

What is SAPS?

7 Answers  

How to find SAP up or not in Unix? What is the command?

2 Answers  

what are the current support stack levels at market place?

0 Answers   iGate, Oasis,

How u will assign Logon Groups?where u find logo.ini

2 Answers   Infosys,

Table space creation

2 Answers  

While applying support packages, the error Table space overflow is occured? What could be done?

3 Answers  

How to find expensive SQL statement, if found, what should be done?

3 Answers   Wipro,

How to see the t able entry values?

1 Answers  

How can you view locked transactions?

0 Answers  

What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?

0 Answers   IBM,

What is JVM switch. Why JVM switch is required ?

0 Answers   L&T,