Disp+work process not coming up

[Former Member]

Hi

, After System reboot Disp+work process ended with return code 000256

here i am pasting the error details, please help me out , i follwed the sap notes 903904 , but no use

Here the log

-

---

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

-

---

*

• ThInit: running on host ecc6

M

M Sat Oct 02 01:55:12 2010

M calling db_connect ...

C Prepending E:\usr\sap\ECC\DVEBMGS04\exe to Path.

C Oracle Client Version: '10.2.0.1.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05E476E8 05E4CC84 05E4C50C

C Attaching to DB Server C11 (con_hdl=0,svchp=05E4C458,srvhp=05E5BE24)

C

C Sat Oct 02 01:55:40 2010

C Starting user session (con_hdl=0,svchp=05E4C458,srvhp=05E5BE24,usrhp=05EA8A28)

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

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=05E4C458,srvhp=05E5BE24)

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

[dbsloci.c 11042]

C Try to connect with default password

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05E476E8 05E4CC84 05E4C50C

C Attaching to DB Server C11 (con_hdl=0,svchp=05E4C458,srvhp=05E5BE24)

C Starting user session (con_hdl=0,svchp=05E4C458,srvhp=05E5BE24,usrhp=05EA8A28)

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

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=05E4C458,srvhp=05E5BE24)

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

[dbsloci.c 11042]

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

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

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

please help me as soon as possible

thanks

venkat

[Former Member]

Hi Guys,

some kernel files got damaged, now server is up and running, thanks everyone to help slove the issue.

Thanks

venkat

[Former Member]

Dear venkat,

connect to sql and execute this command, this will unlock and re-set the password of sapsr3 to default password that is 'SAP'

SQL>ALTER USER SAPSR3 IDENTIFIED BY SAP;

ALTER USER SAPSR3 ACCOUNT UNLOCK;

And check with env settings, if OS is windows set the user variable PATH=E:\oracle\product\10.2.0\db_1\bin;D:\usr\sap\SID\SYS\exe\uc\NTAMD64

and re-start the application server.

Regards

JUDE

[Former Member]

Hi,

Make sure that the oracle services are up and running.

-Varadhu...

[Former Member]

Hi

oracle services are up and running,in trans log no critical errors found.please help me on this issue.

Thanks

venkat

[Former Member]

Hi,

Is ur DB up and running ? Can u please shutdown the DB and start that once ? Let us know if u face any issues in restarting the DB.

Hope this will resolve ur issue.

Regards,

Varadharajan M

[Former Member]

Hi

oracle, and oracle services are up and running,when i start to R3 disp coming ended, return code ora-1033

please help me the issue

thanks

venkat

[Former Member]

Hi,

As mentioned in my earlier reply, try to bounce/restart the DB once and let us know if u have any difficulties while bringing up the DB. Execute R3trans -x at the OS level with the user <SID>ADM and post us the trans.log. This will help us guide u.

Also have a look at this [SAP Note 655240 - Composite SAP note: ORA-01033|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=655240]

Regards,

Varadharajan M

[former_member709110]

Hi,

ORA-01033: ORACLE initialization or shutdown in progress

Check if your database is up or not; and whether you are able to connect to it.

Regards,

Neel

[Former Member]

HI

i am able to connect to database ,but i am not able to connect to R3

i am getting error R3trans -d DBIF return code 12,please help me out in this

Thanks

Venkat

[former_member709110]

plz paste the trans.log

Regards,

Neel