how to use same 'SAPSR3' user for 2 (multiple )sap systems installed in single Oracle DB 11.2 ?

[Former Member]

Hi Friends,

I am facing this issue where I have 2 SAP systems E06 ( ECC 6.0 ehp6) and WW1 ( SCM 7.1) installed in single Oracle database.

Now when I am running SAP MMC , only WW1 system is getting connected to DB where as for E06 I am getting the below error ( Earlier E06 used to work fine). But after this new installation of WW1 it stopped working and Dispatcher stopped working.

As per SAP NOTE :400241 - Problems with ops$ or sapr3 connect to Oracle I checked the values for :

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER'; system is giving only the owner as WW1ADM for only WW1 sid( see below).

E06ADM user :

WW1ADM user:

Please suggest anyway to use the same user SAPSR3 for both the SAP systems or any other alternative. I need to run both the systems simultaneously.

DEV_W0 log of E06 :

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "720"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ
*
M sysno      01
M sid        E06
M systemid   562 (PC with Windows NT)
M relno      7200
M patchlevel 0
M patchno    100
M intno      20020600
M make       multithreaded, Unicode, 64 bit, optimized
M profile    \\SAPERP6\sapmnt\E06\SYS\profile\E06_DVEBMGS01_SAPERP6
M pid        4584
M 
M  kernel runs with dp version 131000(ext=118000) (@(#) DPLIB-INT-VERSION-131000-UC)
M  length of sys_adm_ext is 588 bytes
M  ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 4584) [dpxxdisp.c   1349]
I  MtxInit: 30000 0 0
M  DpSysAdmExtCreate: ABAP is active
M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M  
M Sat Sep 09 18:15:21 2017
M  DpIPCInit2: read dp-profile-values from sys_adm_ext
M  DpShMCreate: sizeof(wp_adm)43024(2264)
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/584064/584080
M  DpShMCreate: sizeof(comm_adm)584080(1144)
M  DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M  DpShMCreate: sizeof(slock_adm)0(104)
M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M  DpShMCreate: sizeof(file_adm)0(80)
M  DpShMCreate: sizeof(vmc_adm)0(2152)
M  DpShMCreate: sizeof(wall_adm)(41664/36752/64/192)
M  DpShMCreate: sizeof(gw_adm)48
M  DpShMCreate: sizeof(j2ee_adm)3952
M  DpShMCreate: SHM_DP_ADM_KEY(addr: 00000000100A0050, size: 6368736)
M  DpShMCreate: allocated sys_adm at 00000000100A0060
M  DpShMCreate: allocated wp_adm_list at 00000000100A3040
M  DpShMCreate: allocated wp_adm at 00000000100A3230
M  DpShMCreate: allocated tm_adm_list at 00000000100ADA50
M  DpShMCreate: allocated tm_adm at 00000000100ADAA0
M  DpShMCreate: allocated wp_ca_adm at 00000000105F09B0
M  DpShMCreate: allocated appc_ca_adm at 00000000106003C0
M  DpShMCreate: allocated comm_adm at 000000001060FDD0
M  DpShMCreate: system runs without slock table
M  DpShMCreate: system runs without file table
M  DpShMCreate: allocated vmc_adm_list at 000000001069E770
M  DpShMCreate: system runs without vmc_adm
M  DpShMCreate: allocated gw_adm at 000000001069E820
M  DpShMCreate: allocated j2ee_adm at 000000001069E860
M  DpShMCreate: allocated ca_info at 000000001069F7E0
M  DpShMCreate: allocated wall_adm at 000000001069F870
M  DpCommAttachTable: attached comm table (header=000000001060FDD0/ft=000000001060FDE0)
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  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 96 MB
M  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE
M  
M Sat Sep 09 18:15:22 2017
M  ThStart: taskhandler started
M  
M Sat Sep 09 18:15:23 2017
M  ThInit: initializing DIA work process W0
M  
M Sat Sep 09 18:15:27 2017
M  ThInit: running on host SAPERP6
M  
M Sat Sep 09 18:15:28 2017
M  calling db_connect ...
B  Loading DB library 'E:\usr\sap\E06\DVEBMGS01\exe\dboraslib.dll' ...
B  Library 'E:\usr\sap\E06\DVEBMGS01\exe\dboraslib.dll' loaded
B  Version of 'E:\usr\sap\E06\DVEBMGS01\exe\dboraslib.dll' is "720.00", patchlevel (0.98)
C  Prepending E:\usr\sap\E06\DVEBMGS01\exe to Path.
C  Register application info.
C  Oracle client version: 11.2.0.3.0, (dbsl 720 200711, UNICODE[2])
C  Detailed Oracle client (patch) info not available.
C  
C Sat Sep 09 18:15:29 2017
C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
C  Logon as OPS$-user to get SAPSR3's password
C  Connecting as /@D01 on connection 0 (nls 0) ... (dbsl 720 200711, UNICODE[2])
C  Attaching to database server D01 (con=0, svchp=07A0CD40, srvhp=1526AEC0)
C  Starting user session: OCISessionBegin(con=0, usr='/', svc=07A0CD40, srv=1526AEC0, usr=15277D80)
C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
C     ORA-01017: invalid username/password; logon denied                                                                        
C  *** ERROR => CONNECT failed with sql error '1017'
 [dbsloci.c    14709]
C  Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
C  Connecting as SAPSR3/<pwd>@D01 on connection 0 (nls 0) ... (dbsl 720 200711, UNICODE[2])
C  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=07A0CD40, srv=1526AEC0, usr=15277D80)
C  
C Sat Sep 09 18:16:30 2017
C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 3113:
C     ORA-03113: end-of-file on communication channel                                                                          
C  Server handle (con=0,svchp=07A0CD40,srvhp=1526AEC0) detached
C  *** ERROR => CONNECT failed with sql error '3113'
 [dbsloci.c    14709]
B  ***LOG BV3=> severe db error 3113      ; work process is stopped [dbsh         1241]
B  ***LOG BY2=> sql error 3113   performing CON [dblink       540]
B  ***LOG BY0=> ORA-03113: end-of-file on communication channel [dblink       540]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1487]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11295]
M  
M  Info for wp 0
M  
M    pid = 4584
M    severity = 0
M    status = 0
M    stat = WP_NEW
M    waiting_for = NO_WAITING
M    reqtype = DP_RQ_DIAWP
M    act_reqtype = NO_REQTYPE
M    req.req_info = 
M    req.tid = -1
M    req.uid = 4294967295
M    req.mode = 255
M    req.len = 0
M    req.rq_id = 65535
M    req.rq_source = 
M    last_tid = 0
M    last_uid = 0
M    last_mode = 0
M    act_cs_count = 0
M    csTrack = 0
M    csTrackRwExcl = 0
M    csTrackRwShrd = 0
M    mode_cleaned_counter = 0
M    control_flag = 0
M    int_checked_resource(RFC) = 0
M    ext_checked_resource(RFC) = 0
M    int_checked_resource(HTTP) = 0
M    ext_checked_resource(HTTP) = 0
M    report = >                                        <
M    action = 0
M    tab_name = >                              <
M    attachedVm = no VM
M  
M  ThIErrHandle: current request:
M  
M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1
M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -    
M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1
M  
M  *****************************************************************************
M  *
M  *  LOCATION    SAP-Server SAPERP6_E06_01 on host SAPERP6 (wp 0)
M  *  ERROR       ThInit: db_connect
M  *
M  *  TIME        Sat Sep 09 18:16:30 2017
M  *  RELEASE     720
M  *  COMPONENT   Taskhandler
M  *  VERSION     1
M  *  RC          13
M  *  MODULE      thxxhead.c
M  *  LINE        11572
M  *  COUNTER     1
M  *
M  *****************************************************************************
M  
M  PfStatDisconnect: disconnect statistics
M  Entering TH_CALLHOOKS
M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP
M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.
M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   779]
M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  303]
M  ThIErrHandle: entering ThSetStatError
M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M  Entering ThReadDetachMode
M  call ThrShutDown (1)...
M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 4584) [dpnttool.c   339]

Please suggest!

Regards,

Yogi