SAP Knowledge Base Article - Preview

2105664 - SMP 3.0 SP4. Oracle 11 custom database. Large amount of database connections. Why ?

Symptom

  • Installed SMP 3.0 SP4
    Using Oracle as a custom Persistence Database.
  • Everything works as expected, but large amount of database connections are being made to this remote custom ( Oracle11 ) database.
  • These connections seem to do nothing but as they occur more than once every second the amount is huge.
  • See below for an example of the logfile.
  • Please note that the OS user SMPServiceUser is created manually before the installation of SMP using the Sybase instructions in the install docs ( or help pages ).
  • What can be done about this ?
  • Example of the logfile :

Thu Nov 06 15:02:48 2014
06-NOV-2014 15:02:48 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)
(HOST=__jdbc__)(USER=smpServiceUser))(SERVICE_NAME=T1SM)(CID=
(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=smpServiceUser))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.6.xx)(PORT=58288)) * establish *
T1SM * 0

06-NOV-2014 15:02:48 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)
(HOST=__jdbc__)(USER=smpServiceUser))(SERVICE_NAME=T1SM)(CID=
(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=smpServiceUser))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.6.xx)(PORT=58289)) * establish *
T1SM * 0

06-NOV-2014 15:02:49 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)
(HOST=__jdbc__)(USER=smpServiceUser))(SERVICE_NAME=T1SM)(CID=
(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=smpServiceUser))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.6.xx)(PORT=58294)) * establish *
T1SM * 0


Read more...

Environment

  • SMP 3.0 SP4, SAP Mobile Platform
  • Oracle 11

Product

SAP Mobile Platform 3.0

Keywords

SMP, SAP Mobile Platform, Oracle, connection, cluster, sync , KBA , MOB-SUP-RT , SUP Runtime , MOB-SUP-MBO , Sybase MBO Development , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.