Disp+work stopped sap server could not start

[Former Member]

HI,

Please help me to solve below error, when i install 4.7 version after instalation rebooted my machine then mmc console disp+work stoped could not stat and error log

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Mon Dec 17 19:53:30 2007

B create_con (con_name=R/3)

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

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

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

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 3788

M

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

I MtxInit: -2 0 0

X

X Mon Dec 17 19:53:31 2007

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

M Mon Dec 17 19:53:40 2007

M calling db_connect ...

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

C

C Mon Dec 17 19:53:41 2007

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server ERP (con_hdl=0,svchp=0612A9D8,svrhp=0612A7E4)

C

C Mon Dec 17 19:54:31 2007

C Starting user session (con_hdl=0,svchp=0612A9D8,srvhp=0612A7E4,usrhp=06171FDC)

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

[dboci.c 3718]

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

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPERP/<pwd>@ERP on connection 0 ...

C Starting user session (con_hdl=0,svchp=0612A9D8,srvhp=0612A7E4,usrhp=06171FDC)

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

[dboci.c 3718]

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

[dboci.c 9536]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

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 jagadesh_ERP_00 on host jagadesh (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Mon Dec 17 19:54:31 2007

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

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

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

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 235]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Regards

JACK

[ulrich_henkenjohann]

Hi,

if your running ORACLE 10g, it can happen that the account in the database is locked due to several wrong connection retries with a wrong password. Check the database account for your SAP User:

sqlplus

connect / as sysdba

select username, account_status , lock_date from dba_users;

If the account is locked, you can unlock it:

alter <user> account unlock;

Regards Ulrich

[Former Member]

Hi !

Check weather database is in mounted state...!!

If it is in mounted statate then follow below steps

1 Login to the SID ADM user

2 Command level : SAPDBA/BR Tools

3Check database is showndown or Mounted

4 If mounted then showndown it and

5 Now start the data base..

6 if any error then check oraarch directory ,and filesystem space.

Regards

Prabhakar P

Edited by: Prabhakar P on Dec 26, 2007 1:28 PM

[Former Member]

Hi Jack

It seems the database schema user sapr3 password is not standard.

So you can reset to standard (if there is no pwd specific rule convention for u).

Chk note # 50088 for OPS$ user creation and also the sapr3 user password change.

change the pwd of sapr3 to SAP (default).

connect to sqlplus and execute the follwoing statement.

alter user sapr3 identified by sap;

or use brtools to change this.

Then try start the sap.

Thanks

Sukrut s

[Former Member]

Check the following note

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Thanks

Prince Jose

[Former Member]

Hi

Need to check some thing at database side.

Quick question

have you changed you Oracle default password ? Is it correctly delivered.

Maybe your system couldn't connect and he is trying by default password?

Please refer to the SAP note # 400241

Thanks

Sukrut S

Edited by: sukrut sardeshpande on Dec 18, 2007 3:53 AM

[Former Member]

Hi Thanks for your reply, i did not change any oracle default password.

Regards

Jack