on 08-02-2011 2:15 AM
While starting my SCM7 env I am getting given below error
[Thr 2736] Mon Aug 01 17:37:31 2011
[Thr 2736] load acl file = D:\usr\sap\SC7\SYS\global\ms_acl_info.DAT
[Thr 2736] MsGetOwnIpAddr: my host addresses are :
[Thr 2736] 1 : [192.168.157.128] micascm7.localdomain (HOSTNAME)
[Thr 2736] 2 : [127.0.0.1] micascm7 (LOCALHOST)
[Thr 2736] 3 : [200.200.200.22] micascm7 (NILIST)
[Thr 2736] MsHttpInit: full qualified hostname = micascm7
[Thr 2736] HTTP logging is switch off
[Thr 2736] set HTTP state to LISTEN
[Thr 2736] ms/icf_info_server : deleted
[Thr 2736] *** I listen to port sapmsSC7 (3603) ***
[Thr 2736] *** I listen to internal port 3903 (3903) ***
[Thr 2736] *** HTTP port 8103 state LISTEN ***
[Thr 2736] CUSTOMER KEY: >G1052791226<
[Thr 2736] build version=701.2008.03.06
[Thr 2736] Mon Aug 01 17:38:47 2011
[Thr 2736] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from micascm7_SC7_03 [msxxserv.c 4711]
[Thr 1552] Mon Aug 01 18:04:08 2011
[Thr 1552] MsSExit: received SIGINT (2)
[Thr 1552] ***LOG Q02=> MsSHalt, MSStop (Msg Server 2744) [msxxserv.c 6021]
Any idea what went wrong here.
Windows 2003,oracle
Thanks
Sukrut
Hi,
First of all, is your system working fine before OR the system was just being refreshed?
If this is a system refresh, please ensure all your restore & recovery are done properly and all post refresh steps are follow accordingly. Do let me know if you need any assistance on the system refresh.
Cheers,
Thanks,
Nicholas Chang.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
system was working before.
When I am trying to fix the datablock as per SAP Note 365481 I am geting given below output
select segment_name, partition_name, segment_type, block_id, blocks from dba_extents where '246412' between
'D:\ORACLE\SC7\SAPDATA4\SR3_8\SR3.DATA8' and (246412+ blocks - 1))
and file_id = 11 and rownum < 2;
no rows selected
Actuall error message
"dev trc ,00000] DbSlRead(): table='DDNTT' 78 8.870804
4 ETW000 [dev trc ,00000] bind_type_and_length(): 0 input variables given 21 8.870825
4 ETW000 [dev trc ,00000] bind_type_and_length(): 2 output variables given
4 ETW000 22 8.870847
4 ETW000 [dev trc ,00000] Thu Sep 08 21:44:05 2011 339780 9.210627
4 ETW000 [dev trc ,00000] OCI-call failed with -1=OCI_ERROR 42 9.210669
4 ETW000 [dev trc ,00000] SQL error 1578: 'ORA-01578: ORACLE data block corrupted (file # 11, block # 246412)
4 ETW000 ORA-01110: data file 11: 'D:\ORACLE\SC7\SAPDATA4\SR3_8\SR3.DATA8''
4 ETW000 95 9.210764
4 ETW000 [dbsloci. ,00000] *** ERROR => Error 1578 in stmt_fetch() from oci_execute_stmt(), orpc=0
4 ETW000 4409 9.215173
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1578 occurred when executing SQL stmt (parse error offset=31)
4 ETW000 35 9.215208
4 ETW000 [dev trc ,00000] sc_p=0000000003ADBB38,no=1,idc_p=0000000000000000,con=0,act=1,slen=62,smax=256,#vars=0,stmt=0000000003A87180,table=DDNTT
4 ETW000 37 9.215245
4 ETW000 [dev trc ,00000] SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS';
4 ETW000 22 9.215267
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1578 17 9.215284
4 ETW000 [dev trc ,00000] sc_p=0000000003ADBB38,no=1,idc_p=0000000000000000,con=0,act=1,slen=62,smax=256,#vars=0,stmt=0000000003A87180,table=DDNTT"
Thanks
Sukrut
Hi Sukret,
What is the Kernel version in your system. This problem generally comes through low kernel version. Please provide your system kernel details and upgrade it to highest patch.
Regards
Pranay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kernel level
-
disp+work information
-
kernel release 701
kernel make variant 701_REL
DBMS client library
compiled on NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00
compiled for 64 BIT
compilation mode UNICODE
compile time Feb 24 2009 23:27:20
update level 0
patch number 32
source id 0.032
-
supported environment
-
database (SAP, table SVERS) 700
701
Hi,
Please rename the file D:\usr\sap\SC7\SYS\global\ms_acl_info.DAT
to D:\usr\sap\SC7\SYS\global\ms_acl_info_old.DAT
Run the command CLEANIPC <Sy.no> SID
Start the SAP system. it will work.
Thanks and Regards,
Jibin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I have checked for ENQ WP and I can see ENQ settings are there on profiles
Actually,Messages server and Dispatcher are coming up properly but after some time it is getting shutdown.
***********
Tue Aug 02 18:03:21 2011
SWITCH TRC-HIDE on ***
***
work process W12 died => ThInit: ThIPCInit
***
work process W14 died => ThInit: ThIPCInit
***
work process W13 died => ThInit: ThIPCInit
***
work process W2 died => ThInit: ThIPCInit
***
work process W6 died => ThInit: ThIPCInit
***
work process W7 died => ThInit: ThIPCInit
***
work process W8 died => ThInit: ThIPCInit
***
work process W1 died => ThInit: ThIPCInit
***
work process W16 died => ThInit: ThIPCInit
***
work process W5 died => ThInit: ThIPCInit
***
work process W4 died => ThInit: ThIPCInit
***
work process W9 died => ThInit: ThIPCInit
***
work process W3 died => ThInit: ThIPCInit
***
work process W11 died => ThInit: ThIPCInit
***
work process W15 died => ThInit: ThIPCInit
***
work process W10 died => ThInit: ThIPCInit
***
work process W0 died => ThInit: ThIPCInit
ICM up and operational (pid: 2716) ***
Shutdown ICM server ................
ICM shutdown completed (pid: 2716) ***
***
DISPATCHER EMERGENCY SHUTDOWN => DpWPCheck: no more work processes
*****************************************************
NiBufSend starting
NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server
MsIDetach: call exit function
DpMsShutdownHook called
NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0
SiSelNSet: set events of sock 388 to: ---
NiBufISelRemove: remove hdl 2 from set0
SiSelNRemove: removed sock 388 (pos=2)
SiSelNRemove: removed sock 388
NiSelIRemove: removed hdl 2
MBUF state OFF
AdGetSelfIdentRecord: > <
AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0
blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/17
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)
MBUF component DOWN
NiICloseHandle: shutdown and close hdl 2 / sock 388
NiBufIClose: clear extension for hdl 2
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 2680) [dpxxdisp.c 11045]
Good Bye .....
**********************************
Thr 2672] Tue Aug 02 18:03:10 2011
[Thr 2672] MsSSetTrcLog: trc logging active, max size = 20971520 bytes
systemid 562 (PC with Windows NT)
relno 7010
patchlevel 0
patchno 11
intno 20020600
make: multithreaded, Unicode, 64 bit, optimized
pid 2692
[Thr 2672] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 2692) [msxxserv.c 1853]
[Thr 2672] Tue Aug 02 18:03:11 2011
[Thr 2672] load acl file = D:\usr\sap\SC7\SYS\global\ms_acl_info.DAT
[Thr 2672] MsGetOwnIpAddr: my host addresses are :
[Thr 2672] 1 : [192.168.157.128] micascm7.localdomain (HOSTNAME)
[Thr 2672] 2 : [127.0.0.1] micascm7 (LOCALHOST)
[Thr 2672] 3 : [200.200.200.22] micascm7 (NILIST)
[Thr 2672] MsHttpInit: full qualified hostname = micascm7
[Thr 2672] HTTP logging is switch off
[Thr 2672] set HTTP state to LISTEN
[Thr 2672] ms/icf_info_server : deleted
[Thr 2672] *** I listen to port sapmsSC7 (3603) ***
[Thr 2672] *** I listen to internal port 3903 (3903) ***
[Thr 2672] *** HTTP port 8103 state LISTEN ***
[Thr 2672] CUSTOMER KEY: >G1052791226<
[Thr 2672] build version=701.2008.03.06
[Thr 2672] Tue Aug 02 18:04:28 2011
[Thr 2672] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from micascm7_SC7_03 [msxxserv.c 4711]
[Thr 2672] Tue Aug 02 18:14:49 2011
[Thr 2672] *** ERROR => MsSCheckConnections: no response from client C0 (192.168.157.128) after 300 secs received [msxxserv.c 3205]
[Thr 2672] *** ERROR => MsSCheckConnections: disconnect now [192.168.157.128] [msxxserv.c 3209]
***********************
I have performed cleanIPC -> saposcol -d
I have changed the IP address as per SAP Notes
R3trans -d is throwing some error
D:\usr\sap\SC7\DVEBMGS03\exe>R3trans -d
This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).
unicode enabled version
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
R3trans finished (0012).
Any help would be appreciated.
Thansk
Sukrut
Hi,
The work process are not able to connect to the database.
This is what the R3trans -d said. So, there are something wrong with the database or the library to connect.
After you call the R3trans -d it will create a trans.log trace file in the same folder. Try to check it.
is it a standalone database or CI&DB on same host?
Check the note 556232 if the enviroment variable are correct.
Cheers,
Clébio
I have modified the env variables and now R3trans is showing diff error
4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 11.08.2011 - 20:14:49
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Thu Aug 11 20:14:53 2011 0 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0, addr 0000000186B40000
4 ETW000 10716 0.010716
4 ETW000 [dev trc ,00000] using "D:\usr\sap\SC7\DVEBMGS03\exe\dboraslib.dll"
4 ETW000 20 0.010736
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 19 0.010755
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 26 0.010781
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.25)
4 ETW000 257 0.011038
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 21 0.011059
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 34 0.011093
4 ETW000 [dev trc ,00000] New connection 0 created 80 0.011173
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 46 0.011219
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 33 0.011252
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 21 0.011273
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 32 0.011305
4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or
4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 539 0.011844
4 ETW000 [dev trc ,00000] Thu Aug 11 20:14:54 2011 788696 0.800540
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0' 39 0.800579
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 38 0.800617
4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 464074 1.264691
4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'
4 ETW000 48 1.264739
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 19 1.264758
4 ETW000 [dev trc ,00000] Connecting as /@SC7 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 104 1.264862
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 61 1.264923
4 ETW000 [dev trc ,00000] 0 UTF8 0 0000000003B09B50 0000000003B11D80 0000000003B13548
4 ETW000 34 1.264957
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 25810 1.290767
4 ETW000 [dev trc ,00000] Allocating server context handle 45 1.290812
4 ETW000 [dev trc ,00000] Attaching to DB Server SC7 (con_hdl=0,svchp=0000000003B13408,srvhp=0000000003B13C88)
4 ETW000 22714 1.313526
4 ETW000 [dev trc ,00000] Thu Aug 11 20:14:55 2011 414024 1.727550
4 ETW000 [dev trc ,00000] Assigning server context 0000000003B13C88 to service context 0000000003B13408
4 ETW000 38 1.727588
4 ETW000 [dev trc ,00000] Allocating user session handle 10355 1.737943
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000003B13408, srvhp=0000000003B13C88, usrhp=0000000003B225E0)
4 ETW000 103 1.738046
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
4 ETW000 324958 2.063004
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 15808 2.078812
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 31 2.078843
4 ETW000 [dev trc ,00000] Try to connect with default password 92 2.078935
4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@SC7 on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 29 2.078964
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 55 2.079019
4 ETW000 [dev trc ,00000] 0 UTF8 0 0000000003B09B50 0000000003B11D80 0000000003B13548
4 ETW000 34 2.079053
4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0000000003B225E0
4 ETW000 27 2.079080
4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0000000003B225E0
4 ETW000 13708 2.092788
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3/<pwd>, svchp=0000000003B13408, srvhp=0000000003B13C88, usrhp=0000000003B225E0)
4 ETW000 122518 2.215306
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
4 ETW000 30526 2.245832
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 44 2.245876
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 27 2.245903
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]
4 ETW000 17447 2.263350
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]
4 ETW000 31 2.263381
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SC7'"
Any idea how to reset the passwd for database.
Hi
I am getting given below error on Trans.log.
4 ETW000 [dev trc ,00000] SELECT COMPCNT, UNICODELG FROM
"DDNTT" WHERE TABNAME = 'SVERS'
4 ETW000
94 40.279825
4 ETW000 [dev trc ,00000] DbSlRead(): table='DDNTT'
69 40.279894
4 ETW000 [dev trc ,00000] bind_type_and_length(): 0 input
variables given 21 40.279915
4 ETW000 [dev trc ,00000] bind_type_and_length(): 2 output variables given
4 ETW000
22 40.279937
4 ETW000 [dev trc ,00000] OCI-call failed with -1=OCI_ERROR
273457 40.553394
4 ETW000 [dev trc ,00000] SQL error 1578: 'ORA-01578: ORACLE
data block corrupted (file # 11, block # 246412)
4 ETW000 ORA-01110: data file 11:
'D:\ORACLE\SC7\SAPDATA4\SR3_8\SR3.DATA8''
4 ETW000
61 40.553455
*4 ETW000 [dbsloci. ,00000] *** ERROR => Error 1578* in
stmt_fetch() from oci_execute_stmt(), orpc=0
4 ETW000
51 40.553506
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1578 occurred when
executing SQL stmt (parse error offset=31)
4 ETW000
33 40.553539
4 ETW000 [dev trc ,00000]
sc_p=0000000003ADA958,no=1,idc_p=0000000000000000,con=0,act=1,slen=62,smax=256,#vars=0,stmt=0000000003A87180,table=DDNTT
4 ETW000
24 40.553563
4 ETW000 [dev trc ,00000] SELECT COMPCNT, UNICODELG FROM "DDNTT"
WHERE TABNAME = 'SVERS';
4 ETW000
Do I need to restore entire backup to fiix the issue ?
Plese help me in fixing this issue.
I am still not able to login to SCM system.
Is there any other way to check what is wrong with message server..
Thanks
Sukrut
Edited by: sukrut sardeshpande on Aug 29, 2011 4:29 PM
Hi,
> [Thr 2736] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from micascm7_SC7_03 [msxxserv.c 4711]
>
Please check that Enqueue process should be there in your system. As per the error message, there is not enqueue process available.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
26 | |
10 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.