Dispather is down

[Former Member]

Hi Basis Experts,

After windows update SAP Server is not starting

Its ECC6.0 with Oracle 10.2g on windows 2003 server

Its dev_ms file is as -

-

---

trc file: "dev_ms", trc level: 1, release: "700"

-

---

[Thr 3520] Mon Jun 09 15:16:23 2008

[Thr 3520] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 73

intno 20050900

make: multithreaded, Unicode, optimized

pid 3472

[Thr 3520] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3472) [msxxserv.c 1824]

[Thr 3520] Mon Jun 09 15:16:24 2008

[Thr 3520] load acl file = D:\usr\sap\SEP\SYS\global\ms_acl_info.DAT

[Thr 3520] MsGetOwnIpAddr: my host addresses are :

[Thr 3520] 1 : [192.168.0.226] SEILPRD (HOSTNAME)

[Thr 3520] 2 : [127.0.0.1] SEILPRD (LOCALHOST)

[Thr 3520] MsHttpInit: full qualified hostname = SEILPRD

[Thr 3520] HTTP logging is switch off

[Thr 3520] set HTTP state to LISTEN

[Thr 3520] ms/icf_info_server : deleted

[Thr 3520] *** I listen to port sapmsSEP (3600) ***

[Thr 3520] *** I listen to internal port 3900 (3900) ***

[Thr 3520] *** HTTP port 8100 state LISTEN ***

[Thr 3520] CUSTOMER KEY: >Z0882721566<

[Thr 3520] Mon Jun 09 15:17:37 2008

[Thr 3520] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from SEILPRD_SEP_00 [msxxserv.c 4679]

[Thr 3520] Mon Jun 09 15:27:58 2008

[Thr 3520] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.0.226) after 300 secs received [msxxserv.c 3165]

[Thr 3520] *** ERROR => MsSCheckConnections: disconnect now [192.168.0.226] [msxxserv.c 3169]

-

---

and dev_w0 fiel is as ---

M Mon Jun 09 15:16:32 2008

M calling db_connect ...

C Prepending D:\usr\sap\SEP\DVEBMGS00\exe to Path.

C

C Mon Jun 09 15:16:34 2008

C Oracle Client Version: '10.2.0.1.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@SEP on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0629B038 06B39A84 06B3930C

C Attaching to DB Server SEP (con_hdl=0,svchp=06B39258,svrhp=06B4A2E4)

C Starting user session (con_hdl=0,svchp=06B39258,srvhp=06B4A2E4,usrhp=06B5EBE8)

C

C Mon Jun 09 15:16:36 2008

C Now '/@SEP' is connected (con_hdl 0, nls_hdl 0).

C

C Mon Jun 09 15:16:37 2008

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06B39258,usrhp=06B5EBE8)

C Now I'm disconnected from ORACLE

C Connecting as SAPSR3/<pwd>@SEP on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0629B038 06B39A84 06B3930C

C Starting user session (con_hdl=0,svchp=06B39258,srvhp=06B4A2E4,usrhp=06B5EBE8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000

[dboci.c 4391]

C Detaching from DB Server (con_hdl=0,svchp=06B39258,srvhp=06B4A2E4)

C *** ERROR => CONNECT failed with sql error '28000'

[dbsloci.c 10933]

B ***LOG BY2=> sql error 28000 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 28000 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-28000: the account is locked [dblink#3 @ 431] [dblink 043

Plz advice.

Many Thanks in Advance

Mani

[markus_doehr2 · Accepted solution]

Please follow note 951167 - ORA-28000: the account is locked to unlock the account.

Markus

[Former Member]

Many Thanks to all.

Problem solved after unlocking A/C.

Thanks & Regards

Mani

[Former Member]

Hi,

Shall I write command as -

alter user sapr3 account unlock;

Many Thanks

[Former Member]

Hi

yes, did you check the link.

ALTER USER <username> ACCOUNT UNLOCK

regards,

kaushal

[Former Member]

To specify a bit more:

open a command prompt and give command

sqlplus /nolog
connect / as sysdba
alter user SAPSR3 account unlock;
exit;

Note that the trace-file shows that you are using

account SAPSR3, not account SAPR3.

[Former Member]

HI,

check Note 951167 - ORA-28000: the account is locked

also check similar thread

regards,

kaushal

Edited by: Kaushal Malavia on Jun 9, 2008 5:18 PM