on 10-11-2014 9:54 AM
We have just noe upgrade the kernel and unable to start disp+work process.
We are in the middle of upgrade. Quick help is really appreciated.
The dev_w0 log is as below....
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "720"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 20
M sid CHQ
M systemid 562 (PC with Windows NT)
M relno 7200
M patchlevel 0
M patchno 500
M intno 20020600
M make multithreaded, Unicode, 64 bit, optimized
M profile D:\usr\sap\CHQ\SYS\profile\CHQ_DVEBMGS20_ABTMSSDQ01
M pid 4020
M
M kernel runs with dp version 139000(ext=120000) (@(#) DPLIB-INT-VERSION-139000-UC)
M length of sys_adm_ext is 588 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 4020) [dpxxdisp.c 1381]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M DpIPCInit2: read dp-profile-values from sys_adm_ext
M DpShMCreate: sizeof(wp_adm) 42864 (2256)
M DpShMCreate: sizeof(tm_adm) 5517056 (27448)
M DpShMCreate: sizeof(wp_ca_adm) 64000 (64)
M DpShMCreate: sizeof(appc_ca_adm) 64000 (64)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1384064/1384080
M DpShMCreate: sizeof(comm_adm) 1384080 (2744)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (296)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (80)
M DpShMCreate: sizeof(vmc_adm) 0 (2160)
M DpShMCreate: sizeof(wall_adm) (41664/42896/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: sizeof(j2ee_adm) 3952
M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000FBC0050, size: 7174832)
M DpShMCreate: allocated sys_adm at 000000000FBC0060
M DpShMCreate: allocated wp_adm_list at 000000000FBC30B0
M DpShMCreate: allocated wp_adm at 000000000FBC32A0
M DpShMCreate: allocated tm_adm_list at 000000000FBCDA20
M DpShMCreate: allocated tm_adm at 000000000FBCDA70
M DpShMCreate: allocated wp_ca_adm at 0000000010110980
M DpShMCreate: allocated appc_ca_adm at 0000000010120390
M DpShMCreate: allocated comm_adm at 000000001012FDA0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 0000000010281C40
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated gw_adm at 0000000010281CF0
M DpShMCreate: allocated j2ee_adm at 0000000010281D30
M DpShMCreate: allocated ca_info at 0000000010282CB0
M DpShMCreate: allocated wall_adm at 0000000010282D40
M DpCommAttachTable: attached comm table (header=000000001012FDA0/ft=000000001012FDB0)
M DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm
M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X <ES> EsILock: use spinlock for locking
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
X mm.dump: set maximum dump mem to 192 MB
X mm.dump: set global maximum dump mem to 192 MB
X EsRegisterEmCheck: Register EmGetEsHandles at 0000000141915AD0
M DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE
M
M Sat Oct 11 14:07:16 2014
M ThStart: taskhandler started
M ThInit: initializing DIA work process W0
M
M Sat Oct 11 14:07:20 2014
M ThInit: running on host ABTMSSDQ01
M
M Sat Oct 11 14:07:24 2014
M calling db_connect ...
B Loading DB library 'D:\usr\sap\CHQ\DVEBMGS20\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\CHQ\DVEBMGS20\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\CHQ\DVEBMGS20\exe\dboraslib.dll' is "720.00", patchlevel (0.425)
C Prepending D:\usr\sap\CHQ\DVEBMGS20\exe to Path.
C Register application info.
C Oracle client version: 10.2.0.4.0, (dbsl 720 090813, UNICODE[2])
C Detailed Oracle client (patch) info not available.
C Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@CHQ on connection 0 (nls 0) ... (dbsl 720 090813, UNICODE[2])
C Attaching to database server CHQ (con=0, svchp=07826198, srvhp=078271B8)
C
C Sat Oct 11 14:07:25 2014
C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12541:
C ORA-12541: TNS:no listener
C *** ERROR => CONNECT failed with sql error '12541'
[dbsloci.c 15455]
C SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12541.
B ***LOG BY2=> sql error 12541 performing CON [dbsh 1246]
B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh 1246]
B ***LOG BY2=> sql error 12541 performing CON [dblink 544]
B ***LOG BY0=> ORA-12541: TNS:no listener [dblink 544]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1513]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11422]
M
M Info for wp 0
M
M pid = 4020
M severity = 0
M status = 0
M stat = WP_NEW
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M req.req_info =
M req.tid = -1
M req.uid = 4294967295
M req.mode = 255
M req.len = 0
M req.rq_id = 65535
M req.rq_source =
M last_tid = 0
M last_uid = 0
M last_mode = 0
M locked semaphores (), locking ()
M act_cs_count = 1
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 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 attachedVm = no VM
M
M ThIErrHandle: current request:
M
M -IN-- sender_id ? tid -1 wp_ca_blk -1 wp_id -1
M -IN-- action - uid -1 appc_ca_blk -1 type -
M -IN-- new_stat NO_CHANGE mode 255 len 0 rq_id -1
M
M *****************************************************************************
M *
M * LOCATION SAP-Server ABTMSSDQ01_CHQ_20 on host ABTMSSDQ01 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Sat Oct 11 14:07:25 2014
M * RELEASE 720
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 11703
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: hook >ThrBtcCallLgCl< o.k.
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 867]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 303]
M ThIErrHandle: 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 (Workp. 0 4020) [dpnttool.c 339]
Hello,
B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh 1246]
Is the listener started?
regards,
pavan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suman,
You need to start listener of database.
check the below error
SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12541.
B ***LOG BY2=> sql error 12541 performing CON [dbsh 1246]
B ***LOG BY0=> ORA-12541: TNS:no listener [dbsh 1246]
B ***LOG BY2=> sql error 12541 performing CON [dblink 544]
B ***LOG BY0=> ORA-12541: TNS:no listener [dblink 544]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1513]
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raju
Oracle database services are running? Could you check the r3trans -d
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Could you refer the SAP KBA
1860519 - SAP fails to connect to the database
1800071 - ORA-12545 when connecting to the database in Fail Safe environments
BR
SS
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.