SAPMMC / disp + work.exe is Yellow

[Former Member]

Hi,

SAPMMC / disp + work.exe is Yellow :

Windows Server 2012

MS SQL Server 2012

I am trying to take client copy, but unable to login 001 by using sap*

Note : I can login into 000 by using sap*

Observed in SAP Management Console - disp+work.EXE is yellow.

Help me please.

[former_member182657]

You could follow SCN doc at

Hope this will help you.

Regards,

[former_member182657]

Hi,

after that I noticed, SAPMMC / disp + work.exe is Yellow 

If possible share the snapshot of SAP MMC with dev_disp log file.

Regards,

[Former Member]

Mr. Gaurav Rana, thanks for your good explanation.

Screen shot and dev log file attached. Please look into this.

SAP MMC with dev_disp log file.

https://drive.google.com/a/nbtc-kuwait.com/file/d/0BwwmzJdG60Geb202UXA3Y3NQckE/view?usp=sharing

[former_member182657]

Hi Eswar,

I logged in

as OS user <SID>adm
goto command prompt type sqlplus "/as sysdba"


I am getting the following error :

C:\Users\soladm>sqlplus "/as sysdba"
'sqlplus' is not recognized as an internal or external command,
operable program or batch file.

To execute sqlplus "/as sysdba" your OS user should be ora<sid> not <SID>adm.Suggest you to execute sqlplus through ora<sid> instead of <sid>adm.

Tried with DDIC also, same error.

I suppose on repeatedly worng password your user has already been locked.Try to unlock it through OS and check again (Follow steps from Anand to unlock).

Good luck !!

[Former Member]

Hi Eswar,

Can you share what error you are getting while logging in client 001, did you entered the correct password,

Also you can try to login with DDIC and change the SAP* password and then relogin.

Regards,

Jaskirat Singh

[Former Member]

Dear Jaskirat,

I entered correct password. Tried with DDIC also, same error.

Before I was logged in, with sap* and ddic also.

I tried to do client copy, from that time onwards I am unable to login.

after that I noticed, SAPMMC / disp + work.exe is Yellow

so, my doubt is bcz of this, i am unable to login.

[Former Member]

Hi Eswar,

Disp+work warning will not cause any issue here as you are able to login in 000 client.

Please find the below links to unlock SAP* in MS SQL database.

How to unlock SAP* at MS-SQL database level | SCN

Regards,

Jaskirat Singh

[Former Member]

Eswar,

Please refer following discussion.

Client 001 : sap* and DDIC locked | SCN

Regards

Anand

[Former Member]

Anand Thanks for your reply....

I logged in

as OS user <SID>adm

goto command prompt type sqlplus "/as sysdba"

I am getting the following error :

C:\Users\soladm>sqlplus "/as sysdba"

'sqlplus' is not recognized as an internal or external command,

operable program or batch file.

[Former Member]

Eswar,

reset the password through sql server management studio too if you have issues with sqlplus command.

- start sql server management studio

- press "Connect"

- press "New Query"

- enter this commands and press F5 afterwards:

use <SID>

go

setuser '<sid>'

go

update table USR02 set UFLAG=0 where MANDT='<your_client>' and BNAME='DDIC'

- if you want to unlock another user, you can use the same query window,

  but then the following is enough as commands:

update table USR02 set UFLAG=0 where MANDT='<your_client>' and BNAME='<your_user_name>'

Regards

Anand