SAP Jobsuche bei DV-Treff
Azrael
  • Azrael
  • SAP Forum - User Thema Starter
vor 15 Jahre

Guten Morgen,

ich habe kürzlich IDES 4.7 auf 2 Rechnern installiert. Beim ersten Rechner gab es keine Probleme, alles lief einwandfrei. Beim zweiten Rechner hab ich das Problem, dass der Dispatcher immer wieder nach wenigen Sekunden stoppt, sobald ich SAP über die SAP Management Konsole starte. Der Message Server läuft allerdings. Firewall hab ich keine laufen, die den Dispatcher blockieren könnte. Ich hab mal sämtliche Datenbank- und SAP-Files beider Rechner verglichen (inkl. Konfigurationsdateien), mir ist aber nichts aufgefallen, was für mich erklären könnte, warum es beim ersten läuft, beim zweiten nicht.

Ich gebe hier kurz die Inhalte der wichtigsten Trace-Files an (dev_disp, dev_ms, dev_w0), vielleicht könnt ihr mir einen Tipp geben. Der Rechner heißt "powerbook", die Datenbank "ORCL" und das SAP-System "DRS":

dev_disp

---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "620"
---------------------------------------------------

Wed May 27 05:25:07 2020
kernel runs with dp version 3(ext=1) (@(#) DPLIB-INT-VERSION-3)
length of sys_adm_ext is 304 bytes

Wed May 27 05:25:08 2020
systemid   560 (PC with Windows NT)
relno      6200
patchlevel 0
patchno    674
intno      20020600
pid        3552

***LOG Q00=> DpSapEnvInit, DPStart (00 3552) [dpxxdisp.c   978]

Wed May 27 05:25:09 2020
 shared lib "dw_xml.dll" version 674 successfully loaded
 shared lib "dw_xtc.dll" version 674 successfully loaded
 shared lib "dw_stl.dll" version 674 successfully loaded

Wed May 27 05:25:13 2020
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  3212]
MtxInit: -2 0 0
DpShMCreate: sizeof(wp_adm)  12784 (752)
DpShMCreate: sizeof(tm_adm)  1690816 (8412)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
DpShMCreate: sizeof(comm_adm) 192000 (384)

Wed May 27 05:25:14 2020
DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
DpShMCreate: SHM_DP_ADM_KEY  (addr: 03330040, size: 1977824)
DpShMCreate: allocated sys_adm at 03330040
DpShMCreate: allocated wp_adm at 03330560
DpShMCreate: allocated tm_adm_list at 03333750
DpShMCreate: allocated tm_adm at 03333778
DpShMCreate: allocated wp_ca_adm at 034D0438
DpShMCreate: allocated appc_ca_adm at 034D4A88
DpShMCreate: allocated comm_adm_list at 034D61F8
DpShMCreate: allocated comm_adm at 034D6210
DpShMCreate: allocated ca_info at 03505010
DpShMCreate: allocated wall_adm at 03505018
MBUF state OFF

Wed May 27 05:25:15 2020
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation std
<EsNT> Memory Reset enabled as NT default
<EsNT> EsIUnamFileMapInit: Initialize the memory 1838 MB
<ES> 1837 blocks reserved for free list.
ES initialized.

Wed May 27 05:25:27 2020
*** ERROR => MsIAttach: NiBufConnect to powerbook/sapmsDRS failed (rc=NIECONN_PENDING) [msxxi.c      545]
***LOG Q0L=> DpLoopInit, nomscon () [dpxxdisp.c   1451]

Wed May 27 05:25:30 2020
CCMS: start to initalize 3.X shared alert area (first segment).

Wed May 27 05:26:07 2020
***LOG Q0K=> DpMsAttach, mscon ( powerbook) [dpxxdisp.c   9115]
*** ERROR => W0 (pid 3340) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W0
*** ERROR => W1 (pid 3348) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W1
*** ERROR => W2 (pid 3356) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W2
*** ERROR => W3 (pid 3388) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W3
*** ERROR => W4 (pid 3408) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W4
*** ERROR => W5 (pid 3396) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W5
*** ERROR => W6 (pid 792) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W6
*** ERROR => W7 (pid 3436) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W7
*** ERROR => W8 (pid 3428) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W8
*** ERROR => W9 (pid 3512) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W9
*** ERROR => W10 (pid 3384) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W10
*** ERROR => W11 (pid 3368) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W11
*** ERROR => W12 (pid 3564) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W12
*** ERROR => W13 (pid 3600) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W13
*** ERROR => W14 (pid 3248) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W14
*** ERROR => W15 (pid 3696) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W15
*** ERROR => W16 (pid 3708) died [dpxxdisp.c   11523]
force unlock of wp_adm mutex W16
my types changed after wp death/restart 0xbf --> 0x80
*** DP_FATAL_ERROR => DpEnvCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
DpModState: change server state from STARTING to SHUTDOWN

Wed May 27 05:26:16 2020
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c   9341]
***LOG Q05=> DpHalt, DPStop ( 3552) [dpxxdisp.c   7883]

dev_ms

---------------------------------------------------
trc file: "dev_ms", trc level: 1, release: "620"
---------------------------------------------------

[Thr 3548] Wed May 27 05:24:53 2020
[Thr 3548] MsSSetTrcLog: trc logging not active
[Thr 3548] relno      6200
[Thr 3548] patchlevel 0
[Thr 3548] patchno    665
[Thr 3548] intno      20020600
[Thr 3548] pid        3544
[Thr 3548] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3544) [msxxserv.c   1524]

[Thr 3548] Wed May 27 05:24:54 2020
[Thr 3548] MsHttpPortInsert: set HTTP state to LISTEN
[Thr 3548] *** I listen to port sapmsDRS (3600) ***
[Thr 3548] *** HTTP LISTEN ***
[Thr 3548] *** I listen to HTTP port 8100 ***
[Thr 3548] CUSTOMER KEY: >A0792340809<

[Thr 3548] Wed May 27 05:25:28 2020
[Thr 3548] ***LOG Q0I=> NiPRead: recv (10054: WSAECONNRESET: Connection reset by peer) [ninti.c 1094]
[Thr 3548] *** ERROR => MsSRead: NiBufReceive (rc=NIECONN_BROKEN) [msxxserv.c   8523]
[Thr 3548] *** ERROR => MsSClientHandle: MsSRead C1 (192.168.12.1), MSEINTERN [msxxserv.c   3662]

[Thr 3548] Wed May 27 05:26:16 2020
[Thr 3548] *** ERROR => MsSClientHandle: no server provides service ENQ  (4), requested from powerbook_DRS_00 [msxxserv.c   3982]
[Thr 3548] ***LOG Q0I=> NiPRead: recv (10054: WSAECONNRESET: Connection reset by peer) [ninti.c 1094]
[Thr 3548] *** ERROR => MsSRead: NiBufReceive (rc=NIECONN_BROKEN) [msxxserv.c   8523]
[Thr 3548] *** ERROR => MsSClientHandle: MsSRead C1 (powerbook_DRS_00), MSEINTERN [msxxserv.c   3662]

dev_w0

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "620"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, M
*

B Wed May 27 05:25:35 2020
B  create_con (con_name=R/3)
B  Loading DB library 'G:\usr\sap\DRS\SYS\exe\run\dboraslib.dll' ...
B  Library 'G:\usr\sap\DRS\SYS\exe\run\dboraslib.dll' loaded
B  Version of 'G:\usr\sap\DRS\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)
B  New connection 0 created
M  systemid   560 (PC with Windows NT)
M  relno      6200
M  patchlevel 0
M  patchno    674
M  intno      20020600
M  pid        3340

M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3340) [dpxxdisp.c   1028]
I  MtxInit: -2 0 0

M Wed May 27 05:25:36 2020
M  DpShMCreate: sizeof(wp_adm)  12784 (752)
M  DpShMCreate: sizeof(tm_adm)  1690816 (8412)
M  DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M  DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M  DpShMCreate: sizeof(comm_adm) 192000 (384)
M  DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M  DpShMCreate: SHM_DP_ADM_KEY  (addr: 03330040, size: 1977824)
M  DpShMCreate: allocated sys_adm at 03330040
M  DpShMCreate: allocated wp_adm at 03330560
M  DpShMCreate: allocated tm_adm_list at 03333750
M  DpShMCreate: allocated tm_adm at 03333778
M  DpShMCreate: allocated wp_ca_adm at 034D0438
M  DpShMCreate: allocated appc_ca_adm at 034D4A88
M  DpShMCreate: allocated comm_adm_list at 034D61F8
M  DpShMCreate: allocated comm_adm at 034D6210
M  DpShMCreate: allocated ca_info at 03505010
M  DpShMCreate: allocated wall_adm at 03505018
X  EmInit: MmSetImplementation( 2 ).
X  <ES> client 0 initializing ....
X  Using implementation std
M  <EsNT> Memory Reset enabled as NT default
X  ES initialized.

M Wed May 27 05:25:38 2020
M  calling db_connect ...
C  Got ORACLE_HOME=G:\database\ora92 from environment

C Wed May 27 05:25:39 2020
C  Client NLS settings: AMERICAN_AMERICA.WE8DEC
C  Logon as OPS$-user to get SAPDRS's password
C  Connecting as /@DRS on connection 0 ...
C  Attaching to DB Server DRS (con_hdl=0,svchp=062F143C,svrhp=062F36A4)

C Wed May 27 05:25:40 2020
C  Starting user session (con_hdl=0,svchp=062F143C,srvhp=062F36A4,usrhp=062FBE7C)
C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
 [dboci.c      3718]
C  *** ERROR => CONNECT failed with sql error '1033'
 [dboci.c      9601]
C  Try to connect with default password
C  Connecting as SAPDRS/<pwd>@DRS on connection 0 ...
C  Starting user session (con_hdl=0,svchp=062F143C,srvhp=062F36A4,usrhp=062FBE7C)
C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
 [dboci.c      3718]
C  *** ERROR => CONNECT failed with sql error '1033'
 [dboci.c      9601]
B  ***LOG BV3=> severe db error 1033      ; work process is stopped [dbsh#2 @ 957] [dbsh    0957 ]
B  ***LOG BY2=> sql error 1033   performing CON [dblink#1 @ 419] [dblink  0419 ]
B  ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419] [dblink  0419 ]
M  ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c   1102]
M  in_ThErrHandle: 1
M  *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   8437]

M  Info for wp 0

M    stat = 4
M    reqtype = 1
M    act_reqtype = -1
M    tid = -1
M    mode = 255
M    len = -1
M    rq_id = -1
M    rq_source = 255
M    last_tid = 0
M    last_mode = 0
M    rfc_req = 0
M    report = >                                        <
M    action = 0
M    tab_name = >                              <

M  *****************************************************************************
M  *
M  *  LOCATION    SAP-Server powerbook_DRS_00 on host powerbook (wp 0)
M  *  ERROR       tskh_init: db_connect
M  *
M  *  TIME        Wed May 27 05:25:40 2020
M  *  RELEASE     620
M  *  COMPONENT   Taskhandler
M  *  VERSION     1
M  *  RC          13
M  *  MODULE      thxxhead.c
M  *  LINE        8569
M  *  COUNTER     1
M  *
M  *****************************************************************************

M  Entering TH_CALLHOOKS
M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   672]
M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  237]
M  Entering ThSetStatError
M  Entering ThReadDetachMode
M  call ThrShutDown (1)...
M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 3340) [dpnttool.c   346]

Kennt jemand das Problem? Hat jemand eine Idee, warum der Dispatcher nicht hochkommt?

Viele Grüße,

Azrael

OldSAPGuru
vor 15 Jahre
Azrael schrieb:

Wed May 27 05:25:27 2020

*** ERROR => MsIAttach: NiBufConnect to powerbook/sapmsDRS failed (rc=NIECONN_PENDING) [msxxi.c      545]
***LOG Q0L=> DpLoopInit, nomscon () [dpxxdisp.c   1451]

Die erforderlichen Einträge in der SERVICES sind drin?
Service sapmsDRS 36**/tcp muß da sein!
Ist der Port evtl. durch ein anderes Programm belegt?

sowie:

Azrael schrieb:

B  ***LOG BV3=> severe db error 1033      ; work process is stopped [dbsh#2 @ 957] [dbsh    0957 ]
B  ***LOG BY2=> sql error 1033   performing CON [dblink#1 @ 419] [dblink  0419 ]
B  ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419] [dblink  0419 ]

Evtl. ist die DB noch nicht komplett gestartet (= SAP R/3 zu schnell)?

Ciao, OldSAPGuru


.: Technical Consultant for SAP System R/3, Release 4.x:|: Technology Consultant for SAP NW'04 - OS/DB Migration for SAP systems :|: Microsoft Certified Professional :.

.: SAP BC/NetWeaver [ Installation :|: Releasewechsel :|: Systemkopien :|: Systemmanagement ] :.

.: Betriebssysteme [ LiNUX :|: UNiX :|: WiNDOWS ] :.

.: Datenbanken [ DB2 :|: MaxDB :|: Oracle ] :.

Azrael
  • Azrael
  • SAP Forum - User Thema Starter
vor 15 Jahre

Hallo Guru,

ja, die Einträge sind in der Services drin. Der Port ist nicht durch ein anderes Programm belegt. Hab extra nochmal geprüft, ob der Loopback-Adapter mit Port 3600 anspricht - sieht gut aus. Aber nach ein paar Sekunden, in denen der Dispatcher läuft, bricht er wieder ab. Manchmal kommt er auch überhaupt nicht hoch. Zuerst kommt die Meldung "Running but not connected to Message Server", anschließend wird daraus "Running but Dialog Queue standstill" und dann "Stopped". Schön langsam verzweifle ich :-(

Hast du noch einen Tipp? Du scheinst echt fit zu sein.

Viele Grüße,

Azrael

OldSAPGuru
vor 15 Jahre
Oracle läuft?
Oracle Listener ebenfalls? Konfig des Listeners ist auch OK (listener.ora, tsnnames etc.)
Was sagt (als <sid>adm) ein:

> r3trans -d

Erfolgt der Connect auf die Datenbank? (einfach mal im trans.log nachsehen...wird vom ^^ r3trans -d erzeugt)

Geht ein als <sid>adm

> tnsping DRS

In der HOSTS sind auch alle erforderlichen Einträge drin?

Ciao, OldSAPGuru
.: Technical Consultant for SAP System R/3, Release 4.x:|: Technology Consultant for SAP NW'04 - OS/DB Migration for SAP systems :|: Microsoft Certified Professional :.

.: SAP BC/NetWeaver [ Installation :|: Releasewechsel :|: Systemkopien :|: Systemmanagement ] :.

.: Betriebssysteme [ LiNUX :|: UNiX :|: WiNDOWS ] :.

.: Datenbanken [ DB2 :|: MaxDB :|: Oracle ] :.

Azrael
  • Azrael
  • SAP Forum - User Thema Starter
vor 15 Jahre

Hallo SAPGuru,

Oracle läuft (habs testweise herunter- und nochmal hochgefahren), da gibts keine Probleme. Der Listener läuft ebenfalls. Die Konfiguration des Listeners sieht wie folgt aus:

tnsnames.ora

# TNSNAMES.ORA Network Configuration File: G:\database\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = powerbook)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = powerbook)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

DRS.WORLD =
  (DESCRIPTION =
    (SDU = 32768)
    (ADDRESS_LIST =
      (ADDRESS =
        (COMMUNITY = SAP.WORLD)
        (PROTOCOL = TCP)
        (HOST = powerbook)
        (PORT = 1527)
      )
    )
    (CONNECT_DATA =
      (SID = DRS)
      (GLOBAL_NAME = DRS.WORLD)
    )
  )

listener.ora

# LISTENER.ORA Network Configuration File: G:\database\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = powerbook)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (ADDRESS =
        (PROTOCOL = IPC)
        (KEY = DRS.WORLD)
      )
    )
    (DESCRIPTION =
      (ADDRESS =
        (PROTOCOL = IPC)
        (KEY = DRS)
      )
    )
    (DESCRIPTION =
      (ADDRESS =
        (COMMUNITY = SAP.WORLD)
        (PROTOCOL = TCP)
        (HOST = powerbook)
        (PORT = 1527)
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = G:\database\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = G:\database\ora92)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (SDU = 32768)
      (SID_NAME = DRS)
      (ORACLE_HOME = G:\database\ora92)
    )
  )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

Mir ist aufgefallen, dass bei tnsnames,ora und listener.ora Port 1527 eingestellt ist. Kann das stimmen? r3trans -d liefert folgendes Ergebnis:

c:\>r3trans -d
This is r3trans version 6.08 (release 620 - 04.02.03 - 14:54:00).
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'DRS'"
r3trans finished (0012).

Die trans.log enthält folgende Daten:

4 ETW000 r3trans version 6.08 (release 620 - 04.02.03 - 14:54:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time   : 29.05.2009 - 06:12:37
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -d
4 ETW000  trace at level 2 opened for a given file pointer
4 ETW000  [dev trc     ,00000]  Fri May 29 06:12:40 2009             0.000000
4 ETW000  [dev trc     ,00000]  db_con_init called                   0.000000
4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)            0.000000
4 ETW000  [dev trc     ,00000]  Loading DB library 'dboraslib.dll' ...
4 ETW000                                                             0.000000
4 ETW000  [dev trc     ,00000]  load shared library (dboraslib.dll), hdl 0
4 ETW000                                                      61272  0.061272
4 ETW000  [dev trc     ,00000]      using "G:\usr\sap\DRS\SYS\exe\run\dboraslib.dll"
4 ETW000                                                        104  0.061376
4 ETW000  [dev trc     ,00000]  Library 'dboraslib.dll' loaded
4 ETW000                                                         86  0.061462
4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000                                                         97  0.061559
4 ETW000  [dev trc     ,00000]  Version of 'dboraslib.dll' is "620.02", patchlevel (0.549)
4 ETW000                                                        354  0.061913
4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dboraslib.dll
4 ETW000                                                         95  0.062008
4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000                                                        145  0.062153
4 ETW000  [dev trc     ,00000]  New connection 0 created        103  0.062256
4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO
4 ETW000                                                        103  0.062359
4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)
4 ETW000                                                         84  0.062443
4 ETW000  [dev trc     ,00000]  find_con found the following connection for reuse:
4 ETW000                                                         86  0.062529
4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO
4 ETW000                                                         94  0.062623
4 ETW000  [dev trc     ,00000]  Got ORACLE_HOME=G:\database\ora92 from environment
4 ETW000                                                        730  0.063353
4 ETW000  [dev trc     ,00000]  -->oci_initialize                74  0.063427
4 ETW000  [dev trc     ,00000]  Client NLS settings: AMERICAN_AMERICA.WE8DEC
4 ETW000                                                     114555  0.177982
4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPDRS's password
4 ETW000                                                        329  0.178311
4 ETW000  [dev trc     ,00000]  Connecting as /@DRS on connection 0 ...
4 ETW000                                                         89  0.178400
4 ETW000  [dev trc     ,00000]  Allocating service context handle
4 ETW000                                                        118  0.178518
4 ETW000  [dev trc     ,00000]  Allocating server context handle
4 ETW000                                                        121  0.178639
4 ETW000  [dev trc     ,00000]  Attaching to DB Server DRS (con_hdl=0,svchp=0022D4D4,svrhp=01783DB4)
4 ETW000                                                        187  0.178826
4 ETW000  [dev trc     ,00000]  Assigning server context 01783DB4 to service context 0022D4D4
4 ETW000                                                     375426  0.554252
4 ETW000  [dev trc     ,00000]  Allocating user session handle
4 ETW000                                                       4584  0.558836
4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=0022D4D4,srvhp=01783DB4,usrhp=0178C54C)
4 ETW000                                                        322  0.559158
4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
4 ETW000                                                      39662  0.598820
4 ETW000  [dboci.c     ,00000]  *** ERROR => CONNECT failed with sql error '1033'
4 ETW000                                                         62  0.598882
4 ETW000  [dev trc     ,00000]  Try to connect with default password
4 ETW000                                                         73  0.598955
4 ETW000  [dev trc     ,00000]  Connecting as SAPDRS/<pwd>@DRS on connection 0 ...
4 ETW000                                                         51  0.599006
4 ETW000  [dev trc     ,00000]  Assigning username to user session 0178C54C
4 ETW000                                                         48  0.599054
4 ETW000  [dev trc     ,00000]  Assigning password to user session 0178C54C
4 ETW000                                                         73  0.599127
4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=0022D4D4,srvhp=01783DB4,usrhp=0178C54C)
4 ETW000                                                         53  0.599180
4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
4 ETW000                                                      13787  0.612967
4 ETW000  [dboci.c     ,00000]  *** ERROR => CONNECT failed with sql error '1033'
4 ETW000                                                         63  0.613030
4 ETW000  [dblink      ,00419]  ***LOG BY2=>sql error 1033   performing CON [dblink#1 @ 419]
4 ETW000                                                        154  0.613184
4 ETW000  [dblink      ,00419]  ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419]
4 ETW000                                                         55  0.613239
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'DRS'"

tnsping DRS liefert folgendes Ergebnis:

c:\>tnsping DRS

TNS Ping Utility for 32-bit Windows: Version 9.2.0.2.0 - Production on 29-MAY-20
09 06:25:08

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
G:\database\ora92\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (C
OMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = powerbook) (PORT = 1527))) (CONNE
CT_DATA = (SID = DRS) (GLOBAL_NAME = DRS.WORLD)))
OK (10 msec)

In der Hosts sind m.E. alle erforderlichen Einträge enthalten:

127.0.0.1       localhost
192.168.12.1 powerbook

Kannst du dir aufgrund der oben gezeigten Files einen Reim auf den Fehler machen?

Liebe Grüße,

Azrael

OldSAPGuru
vor 15 Jahre
Kein Connect des SAP-Appl-Servers auf die DB möglich:

Zitat:

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033
4 ETW000                                                      39662  0.598820
4 ETW000  [dboci.c     ,00000]  *** ERROR => CONNECT failed with sql error '1033'



Der Port 1527 ist schon OK...den nutzt SAP als Standard ;)
Kannst du dich per

> connect /

an der DB anmelden? Wie sieht's mit der Möglichkeit die DB zu stoppen/zu starten per SQL aus? Geht das?

Ciao, OldSAPGuru

.: Technical Consultant for SAP System R/3, Release 4.x:|: Technology Consultant for SAP NW'04 - OS/DB Migration for SAP systems :|: Microsoft Certified Professional :.

.: SAP BC/NetWeaver [ Installation :|: Releasewechsel :|: Systemkopien :|: Systemmanagement ] :.

.: Betriebssysteme [ LiNUX :|: UNiX :|: WiNDOWS ] :.

.: Datenbanken [ DB2 :|: MaxDB :|: Oracle ] :.

Azrael
  • Azrael
  • SAP Forum - User Thema Starter
vor 15 Jahre

Hallo Guru,

vielen Dank für diesen weiteren Hinweis!

Ich habe mittlerweile bemerkt, dass eine der Installations-CDs fehlerhaft war und die Daten nicht richtig kopiert wurden. Vermutlich liegt dort der Hund begraben. Ich werde heute einen 4. Installationsversuch mit einem anderen Leselaufwerk versuchen, mit dem es funktionieren sollte. Wäre schön, wenn es nun klappt. Ich werde alles genauso machen und einstellen, wie ich es bisher gemacht habe. Je nachdem, wie und ob es klappt, melde ich mich wieder.

Viele Grüße,

Azrael

OldSAPGuru
vor 15 Jahre
^^ Yup - mach das! Am besten die CDs/DVDs vorher auf Platte kopieren ;)

Ciao, OldSAPGuru
.: Technical Consultant for SAP System R/3, Release 4.x:|: Technology Consultant for SAP NW'04 - OS/DB Migration for SAP systems :|: Microsoft Certified Professional :.

.: SAP BC/NetWeaver [ Installation :|: Releasewechsel :|: Systemkopien :|: Systemmanagement ] :.

.: Betriebssysteme [ LiNUX :|: UNiX :|: WiNDOWS ] :.

.: Datenbanken [ DB2 :|: MaxDB :|: Oracle ] :.

Azrael
  • Azrael
  • SAP Forum - User Thema Starter
vor 15 Jahre

Es hat geklappt, ich fasse es nicht  

Nun startet der Dispatcher einwandfrei, keine Abbrüche mehr. Sieht so aus, als hat es wirklich an einem Lesefehler gelegen, wodurch irgendetwas nicht richtig oder unvollständig installiert wurde. Der Zugriff auf SAP funktioniert einwandfrei, ich konnte mich problemlos anmelden und alles einrichten.

An dieser Stelle vielen Dank für deine Tipps und Hinweise, OldSAPGuru!!!

Viele Grüße,

Azrael

OldSAPGuru
vor 15 Jahre
Prima! Manchmal sind's eben nur "Kleinigkeiten"...auf jeden Fall hast du für das nächste Mal nun eine gute Grundlage zum Überprüfen, woran es evtl. liegen könnte ;)

Ciao, OldSAPGuru
.: Technical Consultant for SAP System R/3, Release 4.x:|: Technology Consultant for SAP NW'04 - OS/DB Migration for SAP systems :|: Microsoft Certified Professional :.

.: SAP BC/NetWeaver [ Installation :|: Releasewechsel :|: Systemkopien :|: Systemmanagement ] :.

.: Betriebssysteme [ LiNUX :|: UNiX :|: WiNDOWS ] :.

.: Datenbanken [ DB2 :|: MaxDB :|: Oracle ] :.