cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work.exe Stops for 1 SAP System

Former Member
0 Kudos

I have built an ERP 6.0 EHP4 server with 2 systems. The first system is no longer working correctly as when it is first started, the disp+work.exe turns green, but after about 2 minutes it stops. I have tried restarting, and rebooting the server and I get the same issue. This is strange because the other system still works fine. I have not made any changes to the IP Address or the DNS server.

When looking at the "dev_w0" log I see the following error:

M calling db_connect ...

B create_con (con_name=R/3)

B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

[dbcon.c 4537]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 008192) [thxxhead.c 1449]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]

M

M Info for wp 0

M

M pid = 2128

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 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 *****************************************************************************

M *

M * LOCATION SAP-Server PGNetherlands_N20_00 on host PGNetherlands (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Wed Jun 16 15:15:54 2010

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10783

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 723]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]

M 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 (Workproc 0 2128) [dpnttool.c 334]

Accepted Solutions (0)

Answers (3)

Answers (3)

markus_doehr2
Active Contributor
0 Kudos

> B create_con (con_name=R/3)

> B *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

> [dbcon.c 4537]

> M ***LOG R19=> ThInit, db_connect ( DB-Connect 008192) [thxxhead.c 1449]

There's no dbms_type defined for SAPService<SID>. and/or the entry in the instance profile is wrong.

Markus

former_member204746
Active Contributor
0 Kudos

set DBMS_TYPE properly, then tun ntenv2reg.exe

good luck.

Former Member
0 Kudos

Thank you for your help. I will see if I can figure out how to do that. This issue occurred pretty much right after I finished building the new SAP system (N21) on that server. Perhaps I did not do something correctly when building the new system.

I installed Oracle again in a different location for the new system, and then I built the new system using SAPinst as a central system. The new system was built with the same parameters as the first system, just with a different SID and database ID. Is there something else I needed to do to keep this issue from occurring?

Former Member
0 Kudos

I have figured out what is causing the issue, but I still have not completely solved it.

The issue has been with the Oracle listener. When I installed the systems they each had their own Oracle Listner and they were both running on the same port. So I noticed when looking at the services that my N20 Listener was not running, and could not run because they were on the same port. When I stopped the N21 Listener and started the N20 Listener, I could then run N20.

I tried changing the Listener port via the "listener.ora" file and this allowed me to run both listener services, however the system with the different port has the "disp+work" fail as before.

What am I missing? What do I need to change with the listener port to allow both systems to work concurrently? Thank you very much for your help.

Former Member
0 Kudos

Invalid profile or undefined profile parameter dbms/type

Could you go through the following SAP Note:

-


SAP Note 556232 - Environment settings for R/3/Oracle on Windows

-


cheers !

PRADi

Former Member
0 Kudos

This note refers to R/3 systems. These systems are ERP 6 EHP4 running on Windows Server 2008 64 bit.

Former Member
0 Kudos

Affected Releases

Release-Independent

-


Well, the affected releases doesn't restrict for any SAP Version. The note doesn't show obsolete or any pointer to an updated(for latest SAP release) note nor I could find a env recom other than this in notes database. I see no harm in cross checking if the SAP recommendations in this note are adhered or not be it R/3, EHPx. This should clear your doubt if its env thats posing issue..

cheers !

PRADi

Former Member
0 Kudos

I'm seeing something interesting with the environment variables. The 2 systems I have are called "N20" and "N21". see the following environment variable:

Variable: PERL5LIB

Value: C:\oracle\N21\102\perl\5.8.3\lib\MSWin32-x64;

C:\oracle\N21\102\perl\5.8.3\lib;

C:\oracle\N21\102\perl\5.8.3\lib\MSWin32-x64;

C:\oracle\N21\102\perl\site\5.8.3;

C:\oracle\N21\102\perl\site\5.8.3\lib;

C:\oracle\N21\102\sysman\admin\scripts;

C:\oracle\N21\102\perl\5.8.3\lib\MSWin32-x64;

C:\oracle\N21\102\perl\5.8.3\lib;

C:\oracle\N21\102\perl\5.8.3\lib\MSWin32-x64;

C:\oracle\N21\102\perl\site\5.8.3;

C:\oracle\N21\102\perl\site\5.8.3\lib;

C:\oracle\N21\102\sysman\admin\scripts

I don't have an item like this for my "N20" system, and that's the system with this issue. Could this be the issue?