on 09-09-2017 5:04 PM
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
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.