r/3 work process will not start

[Former Member]

hi!

i have 4.7e and oracle 8i in my machine. and i was used past 5 months.

now when i start sap server, the work process will show 'ended'. why?

and following error message will created.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Thu Apr 12 13:42:56 2007

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\ABC\SYS\exe\run\dboraslib.dll' ...

B

B Thu Apr 12 13:43:02 2007

B Library 'C:\usr\sap\ABC\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\ABC\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)

B New connection 0 created

M

M Thu Apr 12 13:43:03 2007

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 674

M intno 20020600

M pid 2372

M

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

I MtxInit: -2 0 0

M

M Thu Apr 12 13:43:05 2007

M DpShMCreate: sizeof(wp_adm) 9776 (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: 001E0040, size: 1974816)

M DpShMCreate: allocated sys_adm at 001E0040

M DpShMCreate: allocated wp_adm at 001E0560

M DpShMCreate: allocated tm_adm_list at 001E2B90

M DpShMCreate: allocated tm_adm at 001E2BB8

M DpShMCreate: allocated wp_ca_adm at 0037F878

M DpShMCreate: allocated appc_ca_adm at 00383EC8

M DpShMCreate: allocated comm_adm_list at 00385638

M DpShMCreate: allocated comm_adm at 00385650

M DpShMCreate: allocated ca_info at 003B4450

M DpShMCreate: allocated wall_adm at 003B4458

X

X Thu Apr 12 13:43:08 2007

X EmInit: MmSetImplementation( 2 ).

X

X Thu Apr 12 13:43:23 2007

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M calling db_connect ...

C

C Thu Apr 12 13:43:34 2007

C Got ORACLE_HOME=D:\oracle\ora92 from environment

C

C Thu Apr 12 13:47:05 2007

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C

C Thu Apr 12 13:47:07 2007

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

C Connecting as /@ABC on connection 0 ...

C Attaching to DB Server ABC (con_hdl=0,svchp=0401CE1C,svrhp=06D74A54)

C

C Thu Apr 12 13:47:52 2007

C Starting user session (con_hdl=0,svchp=0401CE1C,srvhp=06D74A54,usrhp=06D7D22C)

C

C Thu Apr 12 13:47:55 2007

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 SAPABC/<pwd>@ABC on connection 0 ...

C Starting user session (con_hdl=0,svchp=0401CE1C,srvhp=06D74A54,usrhp=06D7D22C)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c 3718]

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

[dboci.c 9601]

B

B Thu Apr 12 13:47:56 2007

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

M Info for wp 0

M

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 *

M * LOCATION SAP-Server abc_ABC_00 on host abc (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Thu Apr 12 13:47:56 2007

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

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

M Thu Apr 12 13:47:57 2007

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2372) [dpnttool.c 346]

kindly give me solution.

thanks and regards

raghubalan

[Former Member · Accepted solution]

Raghu,

ORA-01033: ORACLE initialization or shutdown in progress ???

check your database status .in services or sqlplus !!!

Why Ur using oracle 8i???

Vinod

[Former Member · Accepted solution]

hi Vinod!

thanks for your reply.

when i check the services, Oracle Agent, Data Getheror, TNS lister services are running.

And when i use 4.7ee, oracle 9i will support or not?

regards

raghu

[Former Member]

hi Raghu,

follow the steps:

1.stop all the services - make sure that no services running

2.start the listener

3.open your alert<SID>log.ora file to see the ongoing changes to file

4.logon with user who has oracle/dba credentials

5.start the database in parts .....

6.at SQL>startup nomount .. then

7.SQL>alter database mount ... see what is writing to logfile

8.SQL>alter database open.... see the alertlogfile for errors - FIX yourself or send it to forum if u need help.

9.If you are able to make database up& running then your sap should start without issues.

Regards

Manohar

[former_member204746]

your ORacle DB takes too much time to start and SAP tries to start too fast.

so, start ORacle, make sure it is available and usable and then start SAP.

[Former Member]

hi Eric!

when i start db at OS level, it will not start. why?

regards

raghu

[Former Member]

UR db is not starting why any errors ???

Look in Alert<sid>.log

[former_member204746]

when you try to start, are you getting error messages or is it just hanging... also supply alert_SID.log as Vinod asked you.

[Former Member]

Hi,

Please check if Oracle is up and running and your oracle listner services are running OK.

If above things look good, please check R3trans -d.

[Former Member]

hi sairam!

problem is oracle is not up whether in OS or windows level.

services are running properly.

when i use R3trans -d, it shows ' failed to connect db'.

reply me

regards

raghu