Skip to Content
avatar image
Former Member

SAP server startup problem

I have SAP server in Windows2003 , Database and Cetral Instance are installed on two different host

When I am stating up SAP from MMC console

it

Disp+work shows following status

Running but message server unreachable

Running but not connected to mesage srever

Running but dailog queue standstill

However msg_server and igswd processes are showing green

I checked database on other machine it is running fine

-


trc file: "dev_w0", trc level: 1, release: "700"

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Mon May 05 09:21:20 2008

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\BID\DVEBMGS22\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\BID\DVEBMGS22\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\BID\DVEBMGS22\exe\dboraslib.dll' is "700.08", patchlevel (0.115)

B New connection 0 created

M sysno 22

M sid BID

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 141

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 4848

M

M kernel runs with dp version 232000(ext=109000) (@(#) DPLIB-INT-VERSION-232000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 4848) [dpxxdisp.c 1305]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 19248 (1480)

M DpShMCreate: sizeof(tm_adm) 5652128 (28120)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

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 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000EDD0050, size: 6342672)

M DpShMCreate: allocated sys_adm at 000000000EDD0050

M DpShMCreate: allocated wp_adm at 000000000EDD2150

M DpShMCreate: allocated tm_adm_list at 000000000EDD6C80

M DpShMCreate: allocated tm_adm at 000000000EDD6CE0

M DpShMCreate: allocated wp_ca_adm at 000000000F33AB80

M DpShMCreate: allocated appc_ca_adm at 000000000F340940

M DpShMCreate: allocated comm_adm at 000000000F342880

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000F3C9510

M DpShMCreate: allocated gw_adm at 000000000F3C9590

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000F3C95C0

M DpShMCreate: allocated wall_adm at 000000000F3C95D0

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X

X Mon May 05 09:21:21 2008

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host DLcSapAppG01

M

M Mon May 05 09:21:22 2008

M calling db_connect ...

C Prepending D:\usr\sap\BID\DVEBMGS22\exe to Path.

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@BID on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 000000001539C0C0 00000000153A42F0 00000000153C0B18

C Attaching to DB Server BID (con_hdl=0,svchp=00000000153C09D8,srvhp=00000000153C2E08)

C Starting user session (con_hdl=0,svchp=00000000153C09D8,srvhp=00000000153C2E08,usrhp=00000000153A4B08)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=00000000153C09D8,srvhp=00000000153C2E08)

C *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c 11044]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@BID on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 000000001539C0C0 00000000153A42F0 00000000153C0B18

C Attaching to DB Server BID (con_hdl=0,svchp=00000000153C09D8,srvhp=00000000153C2E08)

C Starting user session (con_hdl=0,svchp=00000000153C09D8,srvhp=00000000153C2E08,usrhp=00000000153A4B08)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=00000000153C09D8,srvhp=00000000153C2E08)

C *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c 11044]

B ***LOG BV3=> severe db error 1034 ; work process is stopped [dbsh#2 @ 1199] [dbsh 1199 ]

B ***LOG BY2=> sql error 1034 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist [dblink#5 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

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 DLcSapAppG01_BID_22 on host DLcSapAppG01 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Mon May 05 09:21:22 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10688

M * COUNTER 1

M *

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

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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 4848) [dpnttool.c 327]

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    May 05, 2008 at 04:40 PM

    Hi

    Check the folllowing

    1. whether the listener is running for oracle database

    2. whether u r able to login to Database from Back end

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 05, 2008 at 05:02 PM

    Yes ,Listener is running and I am able to coonect database with sys

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 05, 2008 at 05:19 PM

    Hi,

    The error message is oracle 1034

    Read below

    Oracle error 1034

    "ORACLE not available"

    *// Cause: Oracle was not started up. Possible causes include the following:

    - The SGA requires more space than was allocated for it.

    - The operating-system variable pointing to the instance is improperly defined.

    *// Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 05, 2008 at 08:26 PM

    problem reolved

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 05, 2008 at 08:26 PM

    I resolved the problem,databse needs clean startup

    Add comment
    10|10000 characters needed characters exceeded