on 10-06-2015 3:35 AM
Hi Experts,
I have encountered an error and an unexpected shutdown of our SAP System, were unable to start it again. Our database is not corrupted and fine. Please alert.log below:
Tue Oct 06 10:21:29 2015
ERROR: Shared memory area is accessible to instance startup process
prior to instance startup operation.
Additional Information:
OS: Window Server 2012 R2 Standard
DB: Oracle 12c 12.1.0.2
System: SAP ECC 6.0
Please help
Thanks,
James Elvin
Hi James,
TNS-01190: The user is not authorized to execute the requested listener command
For the issue you need to refer SAP Note 1915317 - Migrating Software Owner to 'oracle'
Point no.10 .Issue here as because of the correct database software owner.
You must use the same user to start and stop the listener. Otherwise you will get the following error:
TNS-01190: The user is not authorized to execute the requested listener command
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sir,
I have two servers[Test Servers for GO Live], One is DR and Prod Server. Since I destroyed the DR server our Prod Server got an error which is
ERROR: Shared memory area is accessible to instance startup process
prior to instance startup operation.
is it possible that is the cause of the error?
Thanks!
Hi SS,
1. Your DR & Prod server kernel & DBSL patch levels are same?
1. Yes they are the same.
2. Have you enable the firewall or UAC at Windows OS level? or Your system behind the firewall?
2. Yes, I have turned off the firewall.
3. If possible do the full restart and then check..
3. I did a full restart still i am unable to start the system using SAPMMC
Thanks!
dev_disp
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "721"
---------------------------------------------------
sysno 00
sid PRD
systemid 562 (PC with Windows NT)
relno 7210
patchlevel 0
patchno 402
intno 20020600
make multithreaded, Unicode, 64 bit, optimized
profile \\SAP-PRD-POC\sapmnt\PRD\SYS\profile\PRD_DVEBMGS00_SAP-PRD-POC
pid 4032
kernel runs with dp version 139000(ext=121000) (@(#) DPLIB-INT-VERSION-139000-UC)
length of sys_adm_ext is 592 bytes
*** SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 4032) [dpxxdisp.c 1323]
shared lib "dw_xml.dll" version 402 successfully loaded
shared lib "dw_xtc.dll" version 402 successfully loaded
shared lib "dw_stl.dll" version 402 successfully loaded
shared lib "dw_gui.dll" version 402 successfully loaded
shared lib "dw_mdm.dll" version 402 successfully loaded
shared lib "dw_rndrt.dll" version 402 successfully loaded
shared lib "dw_abp.dll" version 402 successfully loaded
shared lib "dw_sym.dll" version 402 successfully loaded
shared lib "dw_aci.dll" version 402 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3901
rdisp/dynamic_wp_check : 1
rdisp/calculateLoadAverage : 1
Mon Oct 05 16:08:08 2015
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 6525]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
display_tcp_ip: 0
Set Check Logoff Flags to 0x0
DpIPCInit2: write dp-profile-values into sys_adm_ext
DpIPCInit2: start server >SAP-PRD-POC_PRD_00 <
DpShMCreate: sizeof(wp_adm) 40608 (2256)
DpShMCreate: sizeof(tm_adm) 5517056 (27448)
DpShMCreate: sizeof(wp_ca_adm) 64000 (64)
DpShMCreate: sizeof(appc_ca_adm) 64000 (64)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1392064/1392080
DpShMCreate: sizeof(comm_adm) 1392080 (2768)
DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
DpShMCreate: sizeof(slock_adm) 0 (296)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (80)
DpShMCreate: sizeof(vmc_adm) 0 (2160)
DpShMCreate: sizeof(wall_adm) (41664/42896/64/192)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: sizeof(j2ee_adm) 3952
DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000033D0050, size: 7180576)
DpShMCreate: allocated sys_adm at 00000000033D0060
DpShMCreate: allocated wp_adm_list at 00000000033D30B0
DpShMCreate: allocated wp_adm at 00000000033D32A0
DpShMCreate: allocated tm_adm_list at 00000000033DD150
DpShMCreate: allocated tm_adm at 00000000033DD1A0
DpShMCreate: allocated wp_ca_adm at 00000000039200B0
DpShMCreate: allocated appc_ca_adm at 000000000392FAC0
DpShMCreate: allocated comm_adm at 000000000393F4D0
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 0000000003A932B0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated gw_adm at 0000000003A93360
DpShMCreate: allocated j2ee_adm at 0000000003A933A0
DpShMCreate: allocated ca_info at 0000000003A94320
DpShMCreate: allocated wall_adm at 0000000003A943B0
DpCommAttachTable: attached comm table (header=000000000393F4D0/ft=000000000393F4E0)
DpSysAdmIntInit: initialize sys_adm
rdisp/test_roll : roll strategy is DP_NORMAL_ROLL
dia token check not active (10 token)
MBUF state OFF
DpCommInitTable: init table for 500 entries
DpRqQInit: keep protect_queue / slots_per_queue 0 / 2001 in sys_adm
rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 0 initializing ....
<ES> EsILock: use Mutex for locking
<ES> InitFreeList
<ES> block size is 4096 kByte.
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 32740 blocks reserved for free list.
ES initialized.
mm.dump: set maximum dump mem to 192 MB
mm.dump: set global maximum dump mem to 192 MB
EsRegisterEmCheck: Register EmGetEsHandles at 00000001419AF6D0
DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE
MPI: dynamic quotas disabled.
MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.4 3.4 4.1) [dpxxdisp.c 1709]
***LOG Q0K=> DpMsAttach, mscon ( SAP-PRD-POC) [dpxxdisp.c 12944]
MBUF state LOADING
DpStartStopMsg: send start message (myname is >SAP-PRD-POC_PRD_00 <)
DpStartStopMsg: start msg sent to message server o.k.
CCMS: Initialized monitoring segment of size 60000000.
CCMS: Initialized CCMS Headers in the shared monitoring segment.
CCMS: Checking Downtime Configuration of Monitoring Segment.
CCMS: AlMsUpload called by wp 1024.
CCMS: AlMsUpload successful for D:\usr\sap\PRD\DVEBMGS00\log\ALMTTREE.DAT (639 MTEs).
CCMS: start to initalize 3.X shared alert area (first segment).
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1296]
MBUF state ACTIVE
DpWpBlksLow: max wp blocks in queue is 800 (80 %)
MBUF component UP
DpMsgProcess: 1 server in MBUF
DpAppcBlksLow: max appc blocks in queue is 500 (50 %)
Mon Oct 05 16:08:12 2015
DpModState: change server state from STARTING to ACTIVE
Mon Oct 05 16:08:48 2015
*** ERROR => DpHdlDeadWp: W12 (pid 5736) died (severity=0, status=0) [dpxxwp.c 1746]
Mon Oct 05 17:31:22 2015
DpSigInt: caught signal 2
DpHalt: shutdown server >SAP-PRD-POC_PRD_00 < (normal)
DpModState: change server state from ACTIVE to SHUTDOWN
DpHalt: stop work processes
Mon Oct 05 17:31:24 2015
DpHalt: stop gateway
DpHalt: stop icman
DpHalt: terminate gui connections
DpHalt: wait for end of work processes
DpHalt: wait for end of gateway
DpHalt: waiting for termination of gateway ...
Mon Oct 05 17:31:25 2015
*** ERROR => [DpProcDied] Process died (PID:5840 HANDLE:1264 rc:0x0) [dpnttool2.c 147]
DpHalt: wait for end of icman
DpHalt: waiting for termination of icman ...
Mon Oct 05 17:31:26 2015
DpHalt: waiting for termination of icman ...
Mon Oct 05 17:31:27 2015
DpHalt: waiting for termination of icman ...
Mon Oct 05 17:31:28 2015
DpHalt: waiting for termination of icman ...
Mon Oct 05 17:31:29 2015
DpHalt: waiting for termination of icman ...
Mon Oct 05 17:31:30 2015
DpHalt: waiting for termination of icman ...
Mon Oct 05 17:31:31 2015
*** ERROR => [DpProcDied] Process died (PID:4236 HANDLE:1272 rc:0x0) [dpnttool2.c 147]
DpStartStopMsg: send stop message (myname is >SAP-PRD-POC_PRD_00 <)
DpStartStopMsg: stop msg sent to message server o.k.
Mon Oct 05 17:31:32 2015
DpHalt: sync with message server o.k.
DpHalt: detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 13344]
MBUF state OFF
MBUF component DOWN
DpHalt: cleanup EM
***LOG Q05=> DpHalt, DPStop ( 4032) [dpxxdisp.c 11819]
dev_ms
---------------------------------------------------
trc file: "dev_ms", trc level: 1, release: "721"
---------------------------------------------------
[Thr 5800] Tue Oct 06 15:44:30 2015
[Thr 5800] ms/http_max_clients = 500 -> 500
[Thr 5800] MsSSetTrcLog: trc logging active, max size = 52428800 bytes
systemid 562 (PC with Windows NT)
relno 7210
patchlevel 0
patchno 327
intno 20020600
make multithreaded, Unicode, 64 bit, optimized
pid 5796
[Thr 5800] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 5796) [msxxserv.c 2305]
[Thr 5800] Tue Oct 06 15:44:31 2015
[Thr 5800] load acl file = D:\usr\sap\PRD\SYS\global\ms_acl_info.DAT
[Thr 5800] MsGetOwnIpAddr: my host addresses are :
[Thr 5800] 1 : [10.0.0.161] SAP-PRD-POC (HOSTNAME)
[Thr 5800] 2 : [127.0.0.1] SAP-PRD-POC (LOCALHOST)
[Thr 5800] Tue Oct 06 15:44:40 2015
[Thr 5800] 3 : [169.254.113.44] 169.254.113.44 (NILIST)
[Thr 5800] MsHttpInit: full qualified hostname = SAP-PRD-POC
[Thr 5800] HTTP logging is switch off
[Thr 5800] set HTTP state to LISTEN
[Thr 5800] *** HTTP port 8101 state LISTEN ***
[Thr 5800] *** I listen to port sapmsPRD (3601) ***
[Thr 5800] *** I listen to internal port 3901 (3901) ***
[Thr 5800] *** HTTP port 8101 state LISTEN ***
[Thr 5800] CUSTOMER KEY: >A0221057954<
[Thr 5800] build version=721.2014.07.17
[Thr 5860] Tue Oct 06 15:51:42 2015
[Thr 5860] MsSExit: received SIGINT (2)
[Thr 5860] set HTTP state to CLOSED
[Thr 5860] *** HTTP port 8101 state CLOSED ***
[Thr 5860] ***LOG Q02=> MsSHalt, MSStop (Msg Server 5796) [msxxserv.c 7804]
Hello,
The dev_disp and dev_ms have a similar timestamp of the dev_w0 shared earlier.
It seems that no "dev_*" trace file is being updated when you try to start the instance.
Is this correct?
Is there any "dev_disp.new" trace file? Please share it, if it exists.
Please also share all the "std*" traces.
You should have an option to attach the traces to this thread instead of having to copy/past their contents .
Regards,
Isaías
PS: Do you have any other system running at this server? Is it also running with instance number 00? This could be the root cause. You cannot have two SAP systems running at the same server, at the same time, using the same instance number.
Hi James,
If you've already performed the re-activation of old profile from OS level,then the issue is not related with the changes of profile parameter settings under RZ10.
Suggest you to re-share updated dev_w0 log file for further analysis & also recommends to open a support ticket with SAP in parallel with this thread.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi James,
I tried to reinstall SAP SYSTEM again
There's no need to reinstall it again n again.From the file shared getting info
ORA-03114: not connected to ORACLE
***LOG BYM=> severe DB error 3114; work process in reconnect status
For the issue have a look with SAP KBA 2064591 - work processes reconnect to Oracle database with error ORA-03135
Hope this will help you.
Regards,
Hi James,
To be sure for the parameter issue,could you try to revert the parameter modification which you've performed recently by modifying all at OS level or by activating the previous version of profile to check again by a restart.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi James,
Are you getting same error
ERROR: Shared memory area is accessible to instance startup process
prior to instance startup operation.
which you're experiencing in previous ? Please confirm.Addition to it share complete hardware details.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
I have solved the error; I don't know if my solution is correct and the bad part was I didn't found out the reason behind this error. Please advise if my solution is not good.
I have reinstall the SAP SYSTEM ONLY; It takes 1hour to reinstall it.
THANKS FOR YOUR USUAL SUPPORT.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi James,
when I add parameters in Tx rz10 and activated the profile after the restart of instance i get this error again.
Could you share the parameter which you activated recently.
please help again.
If still issue persisting after activating the parameter,try to disable the parameter at OS level & check again.
Regards,
Hi Sir Gaurav,
Please check the parameters below
Under > PRD_DVEBMGS00_SAP-PRD-POC
ztta/roll_first = 1024
ztta/roll_extension = 2000683008
ztta/roll_area = 4000000
zcsa/table_buffer_area = 100000768
zcsa/presentation_buffer_area = 20579328
rsdb/obj/buffersize = 16384
rsdb/ntab/sntabsize = 30000
rsdb/ntab/irbdsize = 60000
rsdb/ntab/ftabsize = 200000
rsdb/ntab/entrycount = 200000
rsdb/cua/buffersize = 10000
rdisp/max_wprun_time = 1200
rdisp/ROLL_SHM = 32768
rdisp/PG_SHM = 32768
rdisp/ROLL_MAXFS = 32768
rdisp/PG_MAXFS = 32768
abap/swap_reserve = 20971520
abap/heaplimit = 40894464
em/initial_size_MB = 10240
abap/heap_area_total = 2000000000
abap/heap_area_nondia = 2000000000
abap/buffersize = 900000
abap/heap_area_dia = 2000683008
Hi James,
ERROR: Shared memory area is accessible to instance startup process
prior to instance startup operation.
Have a look with SAP Note 2209313 - 12c: ERROR: Shared memory area is accessible to instance startup process prior to instance...
Hope this will help you in resolution.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Luke.
Hi Sir Gaurav,
Please see
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "721"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 00
M sid PRD
M systemid 562 (PC with Windows NT)
M relno 7210
M patchlevel 0
M patchno 402
M intno 20020600
M make multithreaded, Unicode, 64 bit, optimized
M profile \\SAP-PRD-POC\sapmnt\PRD\SYS\profile\PRD_DVEBMGS00_SAP-PRD-POC
M pid 5528
M
M kernel runs with dp version 139000(ext=121000) (@(#) DPLIB-INT-VERSION-139000-UC)
M length of sys_adm_ext is 592 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 5528) [dpxxdisp.c 1385]
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) 40608 (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/1392064/1392080
M DpShMCreate: sizeof(comm_adm) 1392080 (2768)
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: 000000000B870050, size: 7180576)
M DpShMCreate: allocated sys_adm at 000000000B870060
M DpShMCreate: allocated wp_adm_list at 000000000B8730B0
M DpShMCreate: allocated wp_adm at 000000000B8732A0
M DpShMCreate: allocated tm_adm_list at 000000000B87D150
M DpShMCreate: allocated tm_adm at 000000000B87D1A0
M DpShMCreate: allocated wp_ca_adm at 000000000BDC00B0
M DpShMCreate: allocated appc_ca_adm at 000000000BDCFAC0
M DpShMCreate: allocated comm_adm at 000000000BDDF4D0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000000BF332B0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated gw_adm at 000000000BF33360
M DpShMCreate: allocated j2ee_adm at 000000000BF333A0
M DpShMCreate: allocated ca_info at 000000000BF34320
M DpShMCreate: allocated wall_adm at 000000000BF343B0
M DpCommAttachTable: attached comm table (header=000000000BDDF4D0/ft=000000000BDDF4E0)
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 Mutex 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 00000001419AF6D0
M DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE
M
M Mon Oct 05 16:08:09 2015
M ThStart: taskhandler started
M ThTHPInit: thp initialized
M ThInit: initializing DIA work process W0
M
M Mon Oct 05 16:08:10 2015
M ThInit: running on host SAP-PRD-POC
M
M Mon Oct 05 16:08:11 2015
M calling db_connect ...
B Loading DB library 'D:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'D:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'D:\usr\sap\PRD\DVEBMGS00\exe\dboraslib.dll' is "721.02", patchlevel (0.419)
B con_info_ext_support(): DBSL supports extended connect protocol
B ==> connect info for default DB will be read from ssfs
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [rsecssfs.c 4666]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [rsecssfs.c 4675]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [rsecssfs.c 4685]
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [rsecssfs.c 4666]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [rsecssfs.c 4675]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [rsecssfs.c 4685]
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [rsecssfs.c 4666]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [rsecssfs.c 4675]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [rsecssfs.c 4685]
C dbs/ora/stmt_cache_size = 250
C Register application info.
C Oracle client version: 12.1.0.2.0, (dbsl 721 030315, UNICODE[2])
C Detailed Oracle client (patch) info not available.
C Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
C Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls 0) ... (dbsl 721 030315, UNICODE[2])
C OCIHandleAlloc(con=0): Service svc=03675A08 created, rc=0
C OCIServerAttach(con=0, svc=03675A08): New server hdl. srv=03676360 attached to 'PRD'
C OCISessionBegin(con=0, svc=03675A08, srv=03676360='PRD'): start session usr=03685A40='SAPSR3', rc=0
C Now 'SAPSR3/<pwd>@PRD' is connected: con=0, nls=0, session=156, time='2015-10-05 16:08:11'
C DB instance PRD is running on SAP-PRD-POC with ORACLE version 12.1.0.2.0 since OCT 04, 2015, 10:18:16.
C con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8
C # CharacterSet NCharSet envhp errhp er2hp bathp
C 0 UTF16 AL16UTF16 03665370 036719D0 03672AB0 03673B90
B Connection 0 opened (DBSL handle 0)
C DbSlControl(DBSL_CMD_SAPRELEASE_SET,abap='700')
M ThInit: db_connect o.k.
M ICT: exclude compression: *.zip,*.rar,*.arj,*.z,*.gz,*.tar,*.lzh,*.cab,*.hqx,*.ace,*.jar,*.ear,*.war,*.jpg,*.pdf,*.gzip,*.uue,*.bz2,*.iso,*.sda,*.sar,*.gif,*.png,*.swc,*.swf
I
I Mon Oct 05 16:08:17 2015
I MtxInit: 0 0 0
M SHM_PRES_BUF (addr: 0000000014600050, size: 4400000)
M SHM_ROLL_AREA (addr: 00007FFFDDAB0050, size: 268435456)
M SHM_PAGING_AREA (addr: 0000000014A40050, size: 134217728)
M SHM_ROLL_ADM (addr: 000000001CA50050, size: 2767448)
M SHM_PAGING_ADM (addr: 0000000011EB0050, size: 787488)
M ThCreateNoBuffer allocated 548152 bytes for 1000 entries at 0000000002DE0050
M ThCreateNoBuffer index size: 3000 elems
M ThCreateVBAdm allocated 31056 bytes (50 server) at 0000000002F80050
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
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 00000001419AF6D0
B db_con_shm_ini: WP_ID = 0, WP_CNT = 18, CON_ID = -1
B dbtbxbuf: Buffer TABL (addr: 0000000037010160, size: 30000000, end: 0000000038CAC4E0)
B dbtbxbuf: Buffer TABLP (addr: 0000000038CB0160, size: 10240000, end: 0000000039674160)
B dbsync[db_syinit]: successfully attached to shared memory, sync_adm_p = 0000000002F90050
B dbsync[db_syinit]: Buffer synchronisation started with
B sync_concept = SEQ_NR
B sendon = 1
B bufreftime = 120
B max_gap_wait_time = 60
B ddlog_del_time = 60
B last_counter = -2128034589
B oldest_gap = (2147483647,19700101000000)
B time_of_last_sync = 20151005160812
B MySysId = 'SAP-PRD-POC 00'
B dbexpbuf[EXP_SHB]: buffer EIBUF installed with
B semkey = 35
B shmkey = 54
B wp_n = 18
B sclass = 0
B block_length = 512
B max_objects = 2000
B max_obj_size = 1896512
B pref_obj_size = 0
B est_large_obj_size = 512000
B free_vec_lg = 1001
B hash_vec_size = 4001
B buffer_l = 8388608
B max_blocks = 14818
B free_blocks = 14764
B mutex_n = 4001
B max_mtx_wait_time = 17000
B recovery_delay = 500000
B tracing = 0
B force_checks = 0
B protect_shm = 0
B dbexpbuf[EXP_SHM]: buffer ESM installed with
B semkey = 56
B shmkey = 65
B wp_n = 18
B sclass = 0
B block_length = 512
B max_objects = 2000
B max_obj_size = 851904
B pref_obj_size = 0
B est_large_obj_size = 8192
B free_vec_lg = 17
B hash_vec_size = 4001
B buffer_l = 4194304
B max_blocks = 6657
B free_blocks = 6657
B mutex_n = 4001
B max_mtx_wait_time = 17000
B recovery_delay = 500000
B tracing = 0
B force_checks = 0
B protect_shm = 0
B dbexpbuf[EXP_CUA]: buffer CUA installed with
B semkey = 30
B shmkey = 47
B wp_n = 18
B sclass = 10
B block_length = 512
B max_objects = 1500
B max_obj_size = 619584
B pref_obj_size = 0
B est_large_obj_size = 98304
B free_vec_lg = 193
B hash_vec_size = 3001
B buffer_l = 3072000
B max_blocks = 4842
B free_blocks = 4567
B mutex_n = 3001
B max_mtx_wait_time = 17000
B recovery_delay = 500000
B tracing = 0
B force_checks = 0
B protect_shm = 0
B dbexpbuf[EXP_OTR]: buffer OTR installed with
B semkey = 55
B shmkey = 64
B wp_n = 18
B sclass = 13
B block_length = 256
B max_objects = 2000
B max_obj_size = 851648
B pref_obj_size = 0
B est_large_obj_size = 20480
B free_vec_lg = 81
B hash_vec_size = 4001
B buffer_l = 4194304
B max_blocks = 13310
B free_blocks = 13310
B mutex_n = 4001
B max_mtx_wait_time = 17000
B recovery_delay = 500000
B tracing = 0
B force_checks = 0
B protect_shm = 0
B NTAB: version is VERS_B, UNICODELG=2, SAP_UC_LN=2
I MPI: dynamic quotas disabled.
I MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%
M Semaphore recovery: keep semaphore data.
M logoff_check: set cancel flag during logoff.
M PfInitMemory: version = 1
M PfInitMemory: stat/recex/memory_check = 0
M PfInitMemory: stat/rfcrec = 5, distinct = 0, depth = 5
M CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.
M CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.
G RelWritePermissionForShm( pLocation = 120, pEnforce = 0 )
G GetWritePermissionForShm( pLocation = 99, pEnforce = 1 )
G RelWritePermissionForShm( pLocation = 100, pEnforce = 1 )
S *** init spool environment
S TSPEVJOB updates outside critical section: event_update_nocsec = 1
S initialize debug system
T Stack direction is downwards.
T debug control: prepare exclude for printer trace
T new memory block 000000003AAF7EA0
S spool kernel/ddic check: Ok
S using table TSP02FX for frontend printing
S 1 spool work process(es) found
S frontend print via spool service enabled
S printer list size is 150
S printer type list size is 50
S queue size (profile) = 300
S hostspool list size = 3000
S option list size is 30
S found processing queue enabled
S found spool memory service RSPO-RCLOCKS at 00000000440900D0
S doing lock recovery
S setting server cache root
S found spool memory service RSPO-SERVERCACHE at 0000000044090650
S using messages for server info
S size of spec char cache entry: 297032 bytes (timeout 100 sec)
S size of open spool request entry: 2512 bytes
S immediate print option for implicitely closed spool requests is disabled
A ***GENER* Trace switched on ***
A
A ---PXA-------------------------------------------
A PXA INITIALIZATION
A PXA: Locked PXA-Semaphore.
A System page size: 4kb, total admin_size: 23044kb, dir_size: 22236kb.
A Attached to PXA (address 00007FFFEDAE0050, size 300000K, 1 fragments of 276956K )
A PXA allocated (address 00007FFFEDAE0050, size 300000K)
A abap/pxa = shared protect gen_remote
A PXA: checking structure sizes: 888|272|16
A PXA INITIALIZATION FINISHED
A ---PXA-------------------------------------------
A
A ATRA: pfclock execution time = 0
A abap/force_local_update_task=0
A ABAP ShmAdm attached (addr=000007DFDEDDD000 leng=20955136 end=000007DFE01D9000)
A >> Shm MMADM area (addr=000007DFDF2D4B60 leng=242240 end=000007DFDF30FDA0)
A >> Shm MMDAT area (addr=000007DFDF310000 leng=15503360 end=000007DFE01D9000)
A RFC Destination> destination SAP-PRD-POC_PRD_00 host SAP-PRD-POC system PRD systnr 0 (SAP-PRD-POC_PRD_00)
A RFC Options> H=SAP-PRD-POC,S=00,d=2,
A RFC FRFC> fallback activ but this is not a central instance.
A
A RFC rfc/signon_error_log = -1
A RFC rfc/dump_connection_info = 0
A RFC rfc/dump_client_info = 0
A RFC rfc/cp_convert/ignore_error = 1
A RFC rfc/cp_convert/conversion_char = 23
A RFC rfc/wan_compress/threshold = 251
A RFC rfc/recorder_pcs not set, use defaule value: 2
A RFC rfc/delta_trc_level not set, use default value: 0
A RFC rfc/no_uuid_check not set, use default value: 0
H HTTP> Parameter icf/ssocookie_mandatory set to 0
B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:721.02]):
B max_blocking_factor = 5, min_blocking_factor = 5,
B max_in_blocking_factor = 5, min_in_blocking_factor = 5,
B max_union_blocking_factor = 5, min_union_blocking_factor = 5,
B prefer_union_all = 0, prefer_join = 0,
B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,
B convert AVG = 0, alias table FUPD = 0,
B escape_as_literal = 1, ignore_maxmarkercnt = 0,
B select * =0x0f, character encoding = STD / <none>:-,
B use_hints = abap->1, dbif->0x1, upto->4294967295
M ThrCreateShObjects allocated 37436 bytes at 0000000002FA0050
Y dyWpInit
Y ztta/dynpro_ara 800000
Y ztta/cua_ara 500000
Y ztta/diag_ara 250000
N SsfSapSecin: getenv(SECUDIR)=="D:\usr\sap\PRD\DVEBMGS00/sec"
N
N =================================================
N === SSF INITIALIZATION:
N ===...SSF Security Toolkit name SAPSECULIB .
N ===...SSF library is D:\usr\sap\PRD\DVEBMGS00\exe\sapcrypto.dll .
N ===...SSF default hash algorithm is SHA1 .
N ===...SSF default symmetric encryption algorithm is DES-CBC .
N ===...SECUDIR="D:\usr\sap\PRD\DVEBMGS00/sec"
N ===...loading of Security Toolkit successfully completed.
N === CommonCryptoLib (SAPCRYPTOLIB) Version 8.4.34 pl40 (Feb 11 2015) MT-safe
N =================================================
N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.
N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.
M JrfcVmcRegisterNativesDriver o.k.
W =================================================
W === ipl_Init() called
W ITS Plugin: Path dw_gui
W ITS Plugin: Description ITS Plugin - ITS rendering DLL
W ITS Plugin: sizeof(SAP_UC) 2
W ITS Plugin: Release: 721, [7210.0.402.20020600]
W ITS Plugin: Int.version, [34]
W ITS Plugin: Feature set: [32]
W ===... Calling itsp_Init in external dll ===>
W === ipl_Init() returns 0, ITSPE_OK: OK
W =================================================
N SignInit: Security Session Management cannot be used (ABAP parts are missing, note 1477428)
N SignInit: Not attempted to load Kerberos Library (ABAP parts missing, note 1798979)
E Enqueue Info: enque/use_pfclock2 = FALSE
E Enqueue Info: row condense enabled
E EnqId_Initialize: local EnqId initialization o.k.
M Set restart flag on 1073741824 bytes os heap
M
M Mon Oct 05 16:08:28 2015
M 05.10.2015 08:08:28.492 PID=5528, TID=6688 SapTimer info. v1.119 SynchCount:0 , OwnerPid: 4032, ErrsCount: 0, SapTime-WindowsUtcTime=+1 millisec (max=-1), Nosync=25 sec, SynchsPerDay=0.000000, MaxQpcTimeMinusWindowsTimeMismatch: +0 millisec, TotalTimeCorrection=+0 millisec, QpcTime-WindowsUtcTime=+2 millisec (*)
A UpdateProfile (new settings): off,krn_impl,(no dyn check),(no logging),(no stat err),(local generation),(no commit)
A UpdateProfile (new exceptions): (tmp_err),(home_err),(local_err)
A UpdateProfile (new version): 0
A ***GENER* Trace switched off ***
M SecAudit(rsauinit): WP attached to existing shared memory.
M SecAudit(RsauShmInit): addr of SHM for Audit.. = 0000000002FD0050
M SecAudit(RsauShmInit): addr of RSAUSHM........ = 0000000002FD1050
M SecAudit(RsauShmInit): addr of RSAUSLOTINFO... = 0000000002FD1B10
M SecAudit(RsauShmInit): addr of RSAUSLOTS...... = 0000000002FD1B20
B dbrda: Redirect database access is disabled via rsdb/rda profile parameter setting.
A
A Mon Oct 05 16:08:29 2015
A TH VERBOSE LEVEL FULL
A ** RABAX: level LEV_RX_PXA_RELEASE_MTX entered.
A ** RABAX: level LEV_RX_PXA_RELEASE_MTX completed.
A ** RABAX: level LEV_RX_COVERAGE_ANALYSER entered.
A ** RABAX: level LEV_RX_COVERAGE_ANALYSER completed.
A ** RABAX: level LEV_RX_HOTSPOT_TRACE entered.
A ** RABAX: level LEV_RX_HOTSPOT_TRACE completed.
A ** RABAX: level LEV_RX_SAVE_SHMLOCKS entered.
A ** RABAX: level LEV_RX_SAVE_SHMLOCKS completed.
A ** RABAX: level LEV_RX_RESET_SHMLOCKS entered.
A ** RABAX: level LEV_RX_RESET_SHMLOCKS completed.
A ** RABAX: level LEV_RX_ROLLBACK entered.
A ** RABAX: level LEV_RX_ROLLBACK completed.
A ** RABAX: level LEV_RX_DB_ALIVE entered.
A ** RABAX: level LEV_RX_DB_ALIVE completed.
A ** RABAX: level LEV_RX_HOOKS entered.
A ** RABAX: level LEV_RX_HOOKS completed.
A ** RABAX: level LEV_RX_STANDARD entered.
A ** RABAX: level LEV_RX_STANDARD completed.
A ** RABAX: level LEV_RX_STOR_VALUES entered.
A ** RABAX: level LEV_RX_STOR_VALUES completed.
A ** RABAX: level LEV_RX_C_STACK entered.
A
A Mon Oct 05 16:08:30 2015
A ** RABAX: level LEV_RX_C_STACK completed.
A ** RABAX: level LEV_RX_MEMO_CHECK entered.
A ** RABAX: level LEV_RX_MEMO_CHECK completed.
A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK entered.
A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK completed.
A ** RABAX: level LEV_RX_INTERFACES entered.
A ** RABAX: level LEV_RX_INTERFACES completed.
A ** RABAX: level LEV_RX_GET_MESS entered.
A ** RABAX: level LEV_RX_GET_MESS completed.
A ** RABAX: level LEV_RX_INIT_SNAP entered.
A ** RABAX: level LEV_RX_INIT_SNAP completed.
A ** RABAX: level LEV_RX_WRITE_SYSLOG entered.
A ** RABAX: level LEV_RX_WRITE_SYSLOG completed.
A ** RABAX: level LEV_RX_WRITE_SNAP_BEG entered.
A ** RABAX: level LEV_RX_WRITE_SNAP_BEG completed.
A ** RABAX: level LEV_RX_WRITE_SNAP entered.
A ** RABAX: level LEV_SN_END completed.
A ** RABAX: level LEV_RX_WRITE_SNAP_END entered.
A ** RABAX: level LEV_RX_WRITE_SNAP_END completed.
A ** RABAX: level LEV_RX_RAL_FOR_RABAX entered.
A ** RABAX: level LEV_RX_RAL_FOR_RABAX completed.
A ** RABAX: level LEV_RX_SET_ALERT entered.
A ** RABAX: level LEV_RX_SET_ALERT completed.
A ** RABAX: level LEV_RX_COMMIT entered.
A ** RABAX: level LEV_RX_COMMIT completed.
A ** RABAX: level LEV_RX_SNAP_SYSLOG entered.
A ** RABAX: level LEV_RX_SNAP_SYSLOG completed.
A ** RABAX: level LEV_RX_RESET_PROGS entered.
A ** RABAX: level LEV_RX_RESET_PROGS completed.
A ** RABAX: level LEV_RX_STDERR entered.
A Mon Oct 05 16:08:30 2015
A
A ABAP Program RSORADBA .
A Source RSORADBA Line 278.
A Error Code DATA_LENGTH_0.
A Module $Id: //bas/721_REL/src/krn/runt/abofflen.c#1 $ SAP.
A Function DynamicOffsetLengthAccess Line 405.
A ** RABAX: level LEV_RX_STDERR completed.
A ** RABAX: level LEV_RX_RFC_ERROR entered.
A ** RABAX: level LEV_RX_RFC_ERROR completed.
A ** RABAX: level LEV_RX_RFC_CLOSE entered.
A ** RABAX: level LEV_RX_RFC_CLOSE completed.
A ** RABAX: level LEV_RX_IMC_ERROR entered.
A ** RABAX: level LEV_RX_IMC_ERROR completed.
A ** RABAX: level LEV_RX_DATASET_CLOSE entered.
A ** RABAX: level LEV_RX_DATASET_CLOSE completed.
A ** RABAX: level LEV_RX_ERROR_SAVE entered.
A ** RABAX: level LEV_RX_ERROR_SAVE completed.
A ** RABAX: level LEV_RX_ERROR_TPDA entered.
A ** RABAX: level LEV_RX_ERROR_TPDA completed.
A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.
A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.
A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.
A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.
A ** RABAX: level LEV_RX_END entered.
A ** RABAX: level LEV_RX_END completed.
A ** RABAX: end no http/smtp
A ** RABAX: end RX_BTCHLOG|RX_VBLOG
A Invalid partial field access: Length 0.
A
B
B Mon Oct 05 16:08:51 2015
B dblink[db_reconnect]: { new_reconnect_message=1
C OCIServerVersion(OCI_HTYPE_SERVER) failed with SQL error 3135:
C ORA-03135: connection lost contact
B dbcon[con_ping]: DBSL->ping(0) found a broken connection:
B Reconnect state is entered by connection:
B 00: name=R/3, con_id=000000000, state=INACTIVE , tx=NO , bc=NO , hc=NO , perm=YES, reco=YES, info=NO ,
B timeout=000, con_max=255, con_opt=255, occ=NO , prog=
B RECONNECT: rsdb/reco_trials: 3
B RECONNECT: rsdb/reco_sleep_time: 5
B RECONNECT: rsdb/reco_sync_all_server: OFF
B dbcon[db_con_reconnect]: { reco_trials=3, reco_sleep_time=5
B 00: name=R/3, con_id=000000000, state=INACTIVE , tx=NO , bc=NO , hc=NO , perm=YES, reco=YES, info=NO ,
B timeout=000, con_max=255, con_opt=255, occ=NO , prog=
B dbcon[exec_reconnect]: connection=0
B dbcon[exec_reconnect]: disconnecting from connection 0 ...
C Disconnecting con=0
C OCITransRollback(OCI_DEFAULT) failed with SQL error 3114:
C ORA-03114: not connected to ORACLE
C OCISessionEnd(con=0, svc=03675A08, srv=03676360='PRD'): Close session usr=03685A40, rc=0
C OCIServerDetach(stale1 con=0, svc=03675A08, srv=03676360='PRD') successfully detached
C OCIHandleFree(con=0, svc=03675A08): Server handle srv=03676360 freed
C OCIHandleFree(con=0): Service hdl. svc=03675A08 freed.
B dbcon[exec_reconnect]: disconnected from connection 0
B dbcon[exec_reconnect]: opening connection 0 ...
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [rsecssfs.c 4666]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [rsecssfs.c 4675]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [rsecssfs.c 4685]
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [rsecssfs.c 4666]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [rsecssfs.c 4675]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [rsecssfs.c 4685]
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [rsecssfs.c 4666]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [rsecssfs.c 4675]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [rsecssfs.c 4685]
C Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls 0) ... (dbsl 721 030315, UNICODE[2])
C OCIHandleAlloc(con=0): Service svc=03671688 created, rc=0
C OCIServerAttach(con=0, svc=03671688): New server hdl. srv=03676360 attached to 'PRD'
C OCISessionBegin(con=0, svc=03671688, srv=03676360='PRD'): start session usr=444C7E90='SAPSR3', rc=0
C Now 'SAPSR3/<pwd>@PRD' is connected: con=0, nls=0, session=681, time='2015-10-05 16:08:51'
C DB instance PRD is running on SAP-PRD-POC with ORACLE version 12.1.0.2.0 since OCT 04, 2015, 10:18:16.
C con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8
C # CharacterSet NCharSet envhp errhp er2hp bathp
C 0 UTF16 AL16UTF16 03665370 036719D0 03672AB0 03673B90
B Connection 0 opened (DBSL handle 0)
B dbcon[exec_reconnect]: successfully reconnected to connection 0
B dbcon[db_con_reconnect]: } rc=0
B ***LOG BV4=> reconnect state is set for the work process [dblink 1999]
B ***LOG BYY=> work process left reconnect status [dblink 2000]
B dblink[db_reconnect]: } rc=0
M ThHdlReconnect: reconnect o.k.
A EXCP> Attribute IS_RESUMABLE not found in class CX_ROOT.
B table logging switched off for all clients
B
B Mon Oct 05 16:10:28 2015
B dbsync[db_syexe]: { wait=0, call_no=0, current_ts=20151005161028, last_counter=-2128034589
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128034524, rec_cnt=65, request_cnt=0
S
S Mon Oct 05 16:27:28 2015
S found spool memory service RSPO-ACTIONS at 000000004409A390
B
B Mon Oct 05 16:32:28 2015
B dbsync[db_syexe]: { wait=0, call_no=11, current_ts=20151005163228, last_counter=-2128034503
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128034503, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 16:34:28 2015
B dbsync[db_syexe]: { wait=0, call_no=12, current_ts=20151005163428, last_counter=-2128034503
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128034503, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 16:46:28 2015
B dbsync[db_syexe]: { wait=0, call_no=18, current_ts=20151005164628, last_counter=-2128034503
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128034503, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 16:48:28 2015
B dbsync[db_syexe]: { wait=0, call_no=19, current_ts=20151005164828, last_counter=-2128034503
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128034503, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 16:56:28 2015
B dbsync[db_syexe]: { wait=0, call_no=23, current_ts=20151005165628, last_counter=-2128028962
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128028962, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 16:58:28 2015
B dbsync[db_syexe]: { wait=0, call_no=24, current_ts=20151005165828, last_counter=-2128028962
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128028962, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 17:00:28 2015
B dbsync[db_syexe]: { wait=0, call_no=25, current_ts=20151005170028, last_counter=-2128028962
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128028962, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 17:16:28 2015
B dbsync[db_syexe]: { wait=0, call_no=33, current_ts=20151005171628, last_counter=-2128028962
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128028962, rec_cnt=0, request_cnt=0
B
B Mon Oct 05 17:18:28 2015
B dbsync[db_syexe]: { wait=0, call_no=34, current_ts=20151005171828, last_counter=-2128028962
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128028961, rec_cnt=1, request_cnt=0
B
B Mon Oct 05 17:20:28 2015
B dbsync[db_syexe]: { wait=0, call_no=35, current_ts=20151005172028, last_counter=-2128028961
B dbsync[db_syexe]: } rc=0, most_recent_sync=-2128028961, rec_cnt=0, request_cnt=0
M
M Mon Oct 05 17:31:22 2015
M in_ThErrHandle: 1
M ThIErrHandle: new stat of W0 is WP_SHUTDOWN
M ThIErrHandle: I'm during shutdown
M PfStatDisconnect: disconnect statistics
M ThIErrHandle: entering ThSetStatError
C -->DbSlControl(con=0,cmd=57=DBSL_CMD_SQLBREAK)
C -->oci_break(con=0,Acon=-1,cb=NULL): cancel of current SQL
C sc_p=0000000003637558,no=59,idc_p=0000000003651660,con=0,act=0,slen=82,smax=256,#vars=2,stmt=00000000444FC300,table=TSRVGRP
C Dumping stmt. cache (DBSL private attributes):
C sch=03637558, scp=036429A0, ups_sch=NULL, stp=443C3BB8, r_c=0
C prep=2, dbds=0, lit_cnt=0, lob_cnt=0, fae_cnt=0, xop=25, dbcount=0
C IN : col_cnt=2, row_max=1, row_xcnt=0, row_pcnt=0, row_i=0, row_total=0,
C row_upto=0, row_size=44, vda_max=32, bound=1, itp=NULL, vda_arr=444B9180
C lob_anz=0, lob_max=0, lob_pw=0, lobarr=NULL, rows_ret=0
C OUT: col_cnt=3, row_max=970, row_xcnt=0, row_pcnt=0, row_i=0, row_total=0,
C row_upto=0, row_size=128, vda_max=32, bound=1, itp=NULL, vda_arr=444BAB30
C lob_anz=0, lob_max=0, lob_pw=0, lobarr=NULL, rows_ret=0
C SELECT /*+ FIRST_ROWS (1) */ * FROM "TSRVGRP" WHERE "GRPNAME"=:A0 AND ROWNUM <=:A1;
C No OCI call running -> OCIBreak() not called
C <--oci_break() -> Aorc=-24200
C <--DbSlControl(con=0,cmd=57=DBSL_CMD_SQLBREAK), rc=1=DBSL_ERR_ACCESS
B db_sqlbreak() = 1
M ThCallDbBreak: no sql statement active
M ThIErrHandle: don't try rollback again
M ThShutDownServer: shutdown server
M PfWriteIntoFile: shared buffer is empty.
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
B Disconnecting from ALL connections:
B Wp Hdl ConName ConId ConState TX BC HC PRM RCT INF TIM MAX OPT Date Time DBHost Program
B 000 000 R/3 000000000 INACTIVE NO NO NO YES NO NO 000 255 255 20151005 160851 SAP-PRD-POC
B dbcon[db_con_disconnect_all]: disconnecting from connection 0 ...
C Disconnecting con=0
C OCISessionEnd(con=0, svc=03671688, srv=03676360='PRD'): Close session usr=444C7E90, rc=0
C OCIServerDetach(stale1 con=0, svc=03671688, srv=03676360='PRD') successfully detached
C OCIHandleFree(con=0, svc=03671688): Server handle srv=03676360 freed
C OCIHandleFree(con=0): Service hdl. svc=03671688 freed.
B dbcon[db_con_disconnect_all]: disconnected from connection 0
B statistics db_con_commit (com_total=156, com_tx=65)
B statistics db_con_rollback (roll_total=2, roll_tx=2)
M ***LOG Q02=> wp_halt, WPStop (Workp. 0 5528) [dpnttool.c 339]
Hi james,
ORA-03135: connection lost contact
B dbcon[con_ping]: DBSL->ping(0) found a broken connection:
Is there any antivirus or firewall active on the system ? Try to disable if active & check again.For more please consider SAP KBA 2064591 - work processes reconnect to Oracle database with error ORA-03135& SAP KBA 1902517 - ORA-03135 general trouble shooting steps
Regards,
Hi Gaurav,
I have checked the firewall it was off then i try to close listener using lsnrctl stop then i get this
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PRD.WORLD))
TNS-01190: The user is not authorized to execute the requested listener command
maybe it is connected to the error?
Thanks
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
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.