on 06-16-2010 8:25 PM
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]
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.