on 05-18-2009 1:31 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.