cancel
Showing results for 
Search instead for 
Did you mean: 

DB connect failed return code 000256 ---> disp_work ended

Former Member
0 Kudos

Hi Friends,

I have installed ides ECC 6 on oracle 10g on windows 2003 server.Now I am unable to start SAP console. While starting the disp+work getting ended. I found form the log that the DB connect failed return code 000256 in dev_disp.

snapshot is given below for the reference. Please advice with the resolution.Appreciate for an early response.

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Mon May 18 17:14:23 2009

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\ECC\DVEBMGS04\exe\dboraslib.dll' is "700.08", patchlevel (0.46)

B New connection 0 created

M sysno 04

M sid ECC

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 52

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 3096

M

M kernel runs with dp version 210000(ext=109000) (@(#) DPLIB-INT-VERSION-210000-UC)

M length of sys_adm_ext is 572 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3096) [dpxxdisp.c 1293]

I MtxInit: 30000 0 0

M

M Mon May 18 17:14:24 2009

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 18304 (1408)

M DpShMCreate: sizeof(tm_adm) 3954072 (19672)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1452)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 06510040, size: 4613144)

M DpShMCreate: allocated sys_adm at 06510040

M DpShMCreate: allocated wp_adm at 06511E28

M DpShMCreate: allocated tm_adm_list at 065165A8

M DpShMCreate: allocated tm_adm at 065165D8

M DpShMCreate: allocated wp_ca_adm at 068DBB70

M DpShMCreate: allocated appc_ca_adm at 068E1930

M DpShMCreate: allocated comm_adm at 068E3870

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 06964730

M DpShMCreate: allocated gw_adm at 06964770

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 069647A0

M DpShMCreate: allocated wall_adm at 069647A8

X EmInit: MmSetImplementation( 2 ).

X MM diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host ecc6

M

M Mon May 18 17:14:26 2009

M calling db_connect ...

C Prepending D:\usr\sap\ECC\DVEBMGS04\exe to Path.

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

C Connecting as /@C11 on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 06B2C998 0597F194 0597EA1C

C Attaching to DB Server C11 (con_hdl=0,svchp=0597E968,svrhp=06B41714)

C Starting user session (con_hdl=0,svchp=0597E968,srvhp=06B41714,usrhp=06B8CD88)

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

C Got SAPSR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=0597E968,usrhp=06B8CD88)

C Now I'm disconnected from ORACLE

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 06B2C998 0597F194 0597EA1C

C Starting user session (con_hdl=0,svchp=0597E968,srvhp=06B41714,usrhp=06B8CD88)

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

[dboci.c 4345]

C Detaching from DB Server (con_hdl=0,svchp=0597E968,srvhp=06B41714)

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

[dbsloci.c 10704]

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 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1403]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10019]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M vm = V-1

M

M *****************************************************************************

M *

M * LOCATION SAP-Server ecc6_ECC_04 on host ecc6 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Mon May 18 17:14:26 2009

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10204

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 720]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3096) [dpnttool.c 327]

Regard's

Shashi

Accepted Solutions (1)

Accepted Solutions (1)

JPReyes
Active Contributor
0 Kudos

Sounds like a porblem with the OPS$ user

Read,

SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

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

Regards

Juan

Answers (3)

Answers (3)

abhimanyu_pandey
Participant
0 Kudos

This message was moderated.

Former Member
0 Kudos

Yes !!

I Appreciate all your quick responses...Thanks a lot.

Its resolved now. DB was down, and the account was locked.

I started the DB and unlocked users form DB level....

Thanks again to all

markus_doehr2
Active Contributor
0 Kudos

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

> [dbsloci.c 10704]

> 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 0431 ]

> M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1403]

Read Note 951167 ORA-28000: the account is locked

Markus

Former Member
0 Kudos

Hi,

Just follow the note given by Markus for your Oracle User SAPSR3.

Once the account is unlocked, you should be able to connect to the DB.

Best regards.

Seb.