on 08-22-2011 10:39 PM
Hi all,
I got OS some level problem after fresh installation of Ehp4, so I re-installed OS & ecc6 ehp4 ready & restored the ehp4 backup.
OS is windows 2003 x64, DB is MaxDb 7.8.
After restore I am getting error to start sap instance.
dev_disp:
DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
NiWait: sleep (10000ms) ...
NiISelect: timeout 10000ms
NiISelect: maximum fd=321
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Tue Aug 23 01:43:30 2011
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Mon Aug 22 20:13:30 2011
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 4028 Ended no 1 0 0
1 DIA 4020 Ended no 1 0 0
2 DIA 540 Ended no 1 0 0
3 DIA 3616 Ended no 1 0 0
4 DIA 3648 Ended no 1 0 0
#############################################################################################
dev_w0:
-
trc file: "dev_w0", trc level: 1, release: "701"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 10
M sid EIP
M systemid 562 (PC with Windows NT)
M relno 7010
M patchlevel 0
M patchno 137
M intno 20020600
M make: multithreaded, Unicode, 64 bit, optimized
M pid 4028
M
M
M Tue Aug 23 01:42:39 2011
M kernel runs with dp version 245000(ext=110000) (@(#) DPLIB-INT-VERSION-245000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 4028) [dpxxdisp.c 1354]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M DpShMCreate: sizeof(wp_adm) 29792 (1752)
M DpShMCreate: sizeof(tm_adm) 5912704 (29416)
M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000B2E0050, size: 6614192)
M DpShMCreate: allocated sys_adm at 000000000B2E0050
M DpShMCreate: allocated wp_adm at 000000000B2E22A0
M DpShMCreate: allocated tm_adm_list at 000000000B2E9700
M DpShMCreate: allocated tm_adm at 000000000B2E9760
M DpShMCreate: allocated wp_ca_adm at 000000000B88CFE0
M DpShMCreate: allocated appc_ca_adm at 000000000B892DE0
M DpShMCreate: allocated comm_adm at 000000000B894D20
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000000B91B9B0
M DpShMCreate: allocated gw_adm at 000000000B91BA30
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 000000000B91BA60
M DpShMCreate: allocated wall_adm at 000000000B91BA70
M DpRqQInit: Parameter rdisp/queue_lock_level = 2
M
M Tue Aug 23 01:42:40 2011
M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
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 96 MB
M ThInit: rdisp/cleanup_after_crash = 1
M
M Tue Aug 23 01:42:41 2011
M ThInit: running on host emugeprod
M
M Tue Aug 23 01:42:42 2011
M calling db_connect ...
B Loading DB library 'D:\usr\sap\EIP\DVEBMGS10\exe\dbsdbslib.dll' ...
B Library 'D:\usr\sap\EIP\DVEBMGS10\exe\dbsdbslib.dll' loaded
B Version of 'D:\usr\sap\EIP\DVEBMGS10\exe\dbsdbslib.dll' is "700.08", patchlevel (0.111)
C
C DBSDBSLIB : version 700.08, patch 0.111 (Make PL 0.137)
C MAXDB shared library (dbsdbslib) patchlevels (last 10)
C (0.111) Empty string handling for NUMC, DATE and TIME (note 1509705)
C (0.101) MSSQL: database fingerprint (note 1405158)
C (0.099) ABAP: Return technical database PPMS information (note 1419552)
C (0.093) Unknown primary key (note 1459400)
C (0.093) Connection table corrected (note 1466271)
C (0.092) Improved overflow error handling (note 1463647)
C (0.084) Use SCHEMANAME instead of OWNER for MaxDB 7.8 (note 1353266)
C (0.082) Support of MaxDB 7.8 (note 1353266)
C (0.047) MVCC support for MaxDB (note 1332203)
C (0.037) NUMC conversion corrected (note 1288313)
C
C
C Loading SQLDBC client runtime ...
C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175
C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 009-123-191-997
C SQLDBC client runtime is MaxDB 7.6.5.009 CL 191997
C SQLDBC supports new DECIMAL interface : 0
C SQLDBC supports VARIABLE INPUT data : 1
C SQLDBC supports keepAlive indicator : 0
C INFO : SQLOPT= -I 0 -t 0 -S SAPR3
C Try to connect (DEFAULT) on connection 0 ...
C
C Tue Aug 23 01:42:44 2011
C *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)
[dbsdbsql.cpp 137]
B ***LOG BY2=> sql error -4008 performing CON [dbsh#2 @ 1208] [dbsh 1208 ]
B ***LOG BY0=> POS(1) Unknown user name/password combination [dbsh#2 @ 1208] [dbsh 1208 ]
B ***LOG BY2=> sql error -4008 performing CON [dblink#4 @ 433] [dblink 0433 ]
B ***LOG BY0=> POS(1) Unknown user name/password combination [dblink#4 @ 433] [dblink 0433 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1505]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10652]
M
M Info for wp 0
M
M pid = 4028
M severity = 0
M status = 0
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
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 *****************************************************************************
M *
M * LOCATION SAP-Server emugeprod_EIP_10 on host emugeprod (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Tue Aug 23 01:42:44 2011
M * RELEASE 701
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10917
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 262]
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 4028) [dpnttool.c 334]
############################################################################################
dev_ms:
-
trc file: "dev_ms", trc level: 1, release: "701"
-
[Thr 3940] Tue Aug 23 01:42:33 2011
[Thr 3940] MsSSetTrcLog: trc logging active, max size = 20971520 bytes
systemid 562 (PC with Windows NT)
relno 7010
patchlevel 0
patchno 135
intno 20020600
make: multithreaded, Unicode, 64 bit, optimized
pid 3932
[Thr 3940] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3932) [msxxserv.c 1853]
[Thr 3940] load acl file = D:\usr\sap\EIP\SYS\global\ms_acl_info.DAT
[Thr 3940] MsGetOwnIpAddr: my host addresses are :
[Thr 3940] 1 : [192.168.100.102] EMUGEPROD (HOSTNAME)
[Thr 3940] 2 : [127.0.0.1] emugeprod (LOCALHOST)
[Thr 3940] 3 : [169.254.95.120] emugeprod (NILIST)
[Thr 3940] MsHttpInit: full qualified hostname = emugeprod
[Thr 3940] HTTP logging is switch off
[Thr 3940] set HTTP state to LISTEN
[Thr 3940] ms/icf_info_server : deleted
[Thr 3940] *** I listen to port sapmsEIP (3610) ***
[Thr 3940] *** I listen to internal port 3910 (3910) ***
[Thr 3940] *** HTTP port 8110 state LISTEN ***
[Thr 3940] CUSTOMER KEY: >K1612826589<
[Thr 3940] build version=701.2009.12.02
[Thr 3940] Tue Aug 23 01:43:47 2011
[Thr 3940] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from emugeprod_EIP_10 [msxxserv.c 4731]
[Thr 3940] Tue Aug 23 01:54:08 2011
[Thr 3940] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.100.102) after 300 secs received [msxxserv.c 3217]
[Thr 3940] *** ERROR => MsSCheckConnections: disconnect now [192.168.100.102] [msxxserv.c 3221]
[Thr 3508] Tue Aug 23 02:20:58 2011
[Thr 3508] MsSExit: received SIGINT (2)
[Thr 3508] ***LOG Q02=> MsSHalt, MSStop (Msg Server 3932) [msxxserv.c 6041]
######################################################################################
I am using Maxdb Studio 7.8
How could I change the superdba password.
I found that after restore, I am not able to login to database in db studio with old password & able to log in by new password only.
Pls tell me the post restore steps.
Regardsm
DS
Hello,
1. u201CI found that after restore, I am not able to login to database in db studio with old password & able to log in by new password only.
Pls tell me the post restore steps.u201D
If you are SAP customer => Please see the SAP note 129352.
Please check that you run the steps as of c) < !> in target database.
2. Also the XUSER entries of the <SID>adm user on the application server need to be checked/adjusted with the correct user/password information. See SAP note 39439.
Regards, Natalia Khlopina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
at least you know it is user/password problem at DB level from dispatcher points of view.
ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)
how about SAP notes:
1015489 Connection problems after system copy
616555 liveCache >= 7.4: Password chan...
25591 Changing the DBM, SYSDBA and DBA user passwords
Regards,
Vincent
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.