Reply from Kensai on Oct 2 at 10:53 AM Hi! Also after doing what Hans suggested, make sure the SID of the DB is identical to the SID of the System. BRs.
| | | ---------------Original Message--------------- From: Tapas Sent: Monday, October 02, 2017 9:20 AM Subject: Unable to Bring the SAP Server Online after Restoring the Database. Dear experts, I am not able to bring my SAP server online after doing a database restore. Environment:- SAP ECC 6.0 EHP4 DB:- MSSQL 2008 We have a PRD LIVE database which is working fine. I also have a PRD dummy which was a copy of PRD live. But our Dummy PRD was not uptodate as the copy was done a long back. Hence we restored our most recent PRD-LIVE Back up to make it upto date. Before restoring it, I increased and made the size equal to our PRD-LIVE server. Restore completed successfulley, but when I try to start SAP through SAP MMC, the Dispatcher gives and error and stops immidiately. Below is the Developer trace for DIspatcher:- ------------------- trc file: "dev_disp", trc level: 1, release: "701" ------------------- sysno 01 sid PRD systemid 562 (PC with Windows NT) relno 7010 patchlevel 0 patchno 194 intno 20020600 make: multithreaded, Unicode, 64 bit, optimized pid 3948 kernel runs with dp version 246000(ext=110000) (@(#) DPLIB-INT-VERSION-246000-UC) length of sys_adm_ext is 576 bytes *** SWITCH TRC-HIDE on *** ***LOG Q00=> DpSapEnvInit, DPStart (01 3948) [dpxxdisp.c 1361] shared lib "dw_xml.dll" version 194 successfully loaded shared lib "dw_xtc.dll" version 194 successfully loaded shared lib "dw_stl.dll" version 194 successfully loaded shared lib "dw_gui.dll" version 194 successfully loaded shared lib "dw_mdm.dll" version 194 successfully loaded rdisp/softcancel_sequence : -> 0,5,-1 use internal message server connection to port 3901 Thu Feb 10 12:16:41 2005 *** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds ***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5551] MtxInit: 30000 0 0 DpSysAdmExtInit: ABAP is active DpSysAdmExtInit: VMC (JAVA VM in WP) is not active DpIPCInit2: start server >FILSAPDR1_PRD_01 < DpShMCreate: sizeof(wp_adm) 24528 (1752) DpShMCreate: sizeof(tm_adm) 5912704 (29416) DpShMCreate: sizeof(wp_ca_adm) 24064 (80) DpShMCreate: sizeof(appc_ca_adm) 8000 (80) DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080 DpShMCreate: sizeof(comm_adm) 552080 (1088) DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0 DpShMCreate: sizeof(slock_adm) 0 (104) DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0 DpShMCreate: sizeof(file_adm) 0 (72) DpShMCreate: sizeof(vmc_adm) 0 (1864) DpShMCreate: sizeof(wall_adm) (41664/36752/64/192) DpShMCreate: sizeof(gw_adm) 48 DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000008A00050, size: 6609024) DpShMCreate: allocated sys_adm at 0000000008A00050 DpShMCreate: allocated wp_adm at 0000000008A022A0 DpShMCreate: allocated tm_adm_list at 0000000008A08270 DpShMCreate: allocated tm_adm at 0000000008A082D0 DpShMCreate: allocated wp_ca_adm at 0000000008FABB50 DpShMCreate: allocated appc_ca_adm at 0000000008FB1950 DpShMCreate: allocated comm_adm at 0000000008FB3890 DpShMCreate: system runs without slock table DpShMCreate: system runs without file table DpShMCreate: allocated vmc_adm_list at 000000000903A520 DpShMCreate: allocated gw_adm at 000000000903A5A0 DpShMCreate: system runs without vmc_adm DpShMCreate: allocated ca_info at 000000000903A5D0 DpShMCreate: allocated wall_adm at 000000000903A640 MBUF state OFF DpCommInitTable: init table for 500 entries DpRqQInit: Parameter rdisp/queue_lock_level = 2 rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80 ThTaskStatus: rdisp/reset_online_during_debug 0 EmInit: MmSetImplementation( 2 ). MM global diagnostic options set: 0 <ES> client 0 initializing .... <ES> EsILock: use spinlock for locking <ES> InitFreeList <ES> block size is 4096 kByte. <ES> Info: em/initial_size_MB( 3999MB) not multiple of em/blocksize_KB( 4096KB) <ES> Info: em/initial_size_MB rounded up to 4000MB Using implementation view <EsNT> Using memory model view. <EsNT> Memory Reset disabled as NT default <ES> 999 blocks reserved for free list. ES initialized. mm.dump: set maximum dump mem to 96 MB rdisp/http_min_wait_dia_wp : 1 -> 1 ***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1756] ***LOG Q0K=> DpMsAttach, mscon ( FILSAPDR1) [dpxxdisp.c 12872] DpStartStopMsg: send start message (myname is >FILSAPDR1_PRD_01 <) DpStartStopMsg: start msg sent CCMS: Initalizing shared memory of size 60000000 for monitoring segment. CCMS: Checking Downtime Configuration of Monitoring Segment. CCMS: start to initalize 3.X shared alert area (first segment). DpMsgAdmin: Set release to 7010, patchlevel 0 MBUF state PREPARED MBUF component UP DpMBufHwIdSet: set Hardware-ID ***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048] DpMsgAdmin: Set patchno for this platform to 194 Release check o.K. Thu Feb 10 12:17:21 2005 my types changed after wp death/restart 0xb7 --> 0xb6 my types changed after wp death/restart 0xb6 --> 0xb4 my types changed after wp death/restart 0xb4 --> 0xb0 my types changed after wp death/restart 0xb0 --> 0xa0 my types changed after wp death/restart 0xa0 --> 0x80 *** DP_FATAL_ERROR => DpWPCheck: no more work processes *** DISPATCHER EMERGENCY SHUTDOWN *** increase tracelevel of WPs NiWait: sleep (10000ms) ... NiISelect: timeout 10000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:31 2005 NiISelect: TIMEOUT occured (10000ms) dump system status Workprocess Table (long) Thu Feb 10 08:17:31 2005 ======================== No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table | | Reply to this email to post your response. __.____._ | _.____.__ |