cancel
Showing results for 
Search instead for 
Did you mean: 

Error: Shared Memory - SAP Unexpected Shutdown & Unable to start

former_member215439
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member182657
Active Contributor
0 Kudos

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,

former_member215439
Participant
0 Kudos

Hi Sir Gaurav,

     Thanks. but still i cant start the system in SAPMMC

former_member182657
Active Contributor
0 Kudos

Hi James,

Have your issues resolved for which i suggested some SAP KBA's & Notes ? Is your listener started or not.Kindly share previous results or steps which you performed at your end.

Regards,

former_member215439
Participant
0 Kudos

Hi Sir Gaurav,

     Not yet resolved, SAP KBA's & Notes that you refer did not work. yes my listener started. I have just started the listener using services.msc

Thanks

former_member182657
Active Contributor
0 Kudos

Hi James,

Could you re share updated  dev_w0 log file from the system ?

Regards,

former_member215439
Participant
0 Kudos

Hi Sir Gaurav,

     dev_w0 did not update it is the same dev_w0 above.

     Since I destroy the DR server yesterday it became like this, it is possible thats the reason why i get that error?

     I appreciate your support. Thank You!

former_member182657
Active Contributor
0 Kudos

Hi James,


  Since I destroy the DR server yesterday it became like this, it is possible thats the reason why i get that error?

Sorry 'm not able to get you.Kindly share more details to support you.

Regards,

former_member215439
Participant
0 Kudos

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!

Sriram2009
Active Contributor
0 Kudos

Hi James

1. Your DR & Prod server kernel & DBSL patch levels are same?

2. Have you enable the firewall or UAC  at Windows OS level? or Your system behind the firewall?

3. If possible do the full restart and then check..

Regards

SS

former_member215439
Participant
0 Kudos

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!

Sriram2009
Active Contributor
0 Kudos

Hi James

Kindly attach the latest log files - dev_disp, dev_ms

Regards

SS

former_member215439
Participant
0 Kudos

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]

former_member215439
Participant
0 Kudos

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]

isaias_freitas
Advisor
Advisor
0 Kudos

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.

Sriram2009
Active Contributor
0 Kudos

Hi James

1. Could you share your Windows system details?

2. I think you have to check the DNS resolution or host enters in SAP CI & DI physical systems because from the log db reconnecting having issue.

Regards

SS

Answers (5)

Answers (5)

former_member182657
Active Contributor
0 Kudos

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,

former_member215439
Participant
0 Kudos

Hi Sir Gaurav,

         Please check the attachment. Thanks . I tried to reinstall SAP SYSTEM again. i will follow up you again.

Thanks for your usual support

former_member182657
Active Contributor
0 Kudos

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,

former_member215439
Participant
0 Kudos

Hi Sir,

     My firewall are all disable and I tried the kba you gave again. still the error persist.

Former Member
0 Kudos

Hello James,

Are you resolved you problem?

My configuration: Windows 2012R2 + Oracle 12c and I have installed second(QUA) SAP Netweaver 7.42 system on this server. My first system works well.

former_member215439
Participant
0 Kudos

Hi Dmitry,

     Yes

Former Member
0 Kudos

Could you tell me, how you resolve this problem?

former_member215439
Participant
0 Kudos

Hi Dmitry,

Cause: I have modified the profile parameter with incorrect procedures then normally after parameter changes you need to restart the instance and after that I get the error

Solution: Restore/recover profile parameters

former_member182657
Active Contributor
0 Kudos

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,

former_member215439
Participant
0 Kudos

Hi Sir Gaurav,

     How can i revert the previous profile name? i cant open rz10

thanks

former_member182657
Active Contributor
0 Kudos

Hi James,

Profile exists at location /usr/sap/<SID>/SYS/profile on your system.From there you can reactivate the previous one.

Regards,

former_member215439
Participant
0 Kudos

Hi Sir,

     I have already try that and restart the computer but still i cant open the instance

former_member182657
Active Contributor
0 Kudos

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,

former_member215439
Participant
0 Kudos

Hi Sir Gaurav,

     Yes sir i do get the same error. same from the previous error.

     Hardware Details:

     2.3TB for HDD

     128ram

     64bit OS, x64

     intel xeon

former_member215439
Participant
0 Kudos

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.

isaias_freitas
Advisor
Advisor
0 Kudos

Hello James,

Did you use the same instance number?

Anyway, if the issue is solved, that's good .

former_member215439
Participant
0 Kudos

Hello Freitas,

Yes, I used the same instance number. After the re-installation i am able to start the instance using SAPMMC.

Thanks

former_member215439
Participant
0 Kudos

HI ALL,

          i have found out the reason of this error and I cannot use the solution i have used before because the reason was when I add parameters in Tx rz10 and activated the profile after the restart of instance i get this error again.

          please help again.

former_member182657
Active Contributor
0 Kudos

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,

former_member215439
Participant
0 Kudos

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

former_member182657
Active Contributor
0 Kudos

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

former_member215439
Participant
0 Kudos

Hi Gaurav,

     I appreciate your help however I think it was not the solution to the error we encountered.

     When we starting the system using SAP MMC the SAP-PRD-POC 0 is not starting

    

Thanks

former_member182657
Active Contributor
0 Kudos

Hi James,

If possible could you share dev_w0 for the SAP-PRD-POC 0 along with alert_<SID>.log .

Regards,

former_member215439
Participant
0 Kudos

Hi Gaurav,

Where can I find the dev_w0?

0 Kudos

It is located in your work directory.

If you have installed a central instance (instance number 01) with SID PRD then it would be under: <drive>:\usr\sap\PRD\DVEBMGS01\work

Alternatively you can view it via logging onto the system via sapgui and running transaction ST11.

former_member215439
Participant
0 Kudos

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 Mon Oct 05 16:08:09 2015

M  ThStart: taskhandler started

M  ThTHPInit: thp initialized

M  ThInit: initializing DIA work process W0

M Mon Oct 05 16:08:10 2015

M  ThInit: running on host SAP-PRD-POC

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 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  ---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  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  === 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 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 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 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  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.

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 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 Mon Oct 05 16:27:28 2015

S  found spool memory service RSPO-ACTIONS at 000000004409A390

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 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 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 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 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 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 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 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 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 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 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]

former_member182657
Active Contributor
0 Kudos

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,

former_member215439
Participant
0 Kudos

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