sap server open then problem dispatcher

[former_member279000]

i am open sap 4.7server then start process list some time after dispatcher status stopped and wp table status ended

WP TABLE

---------------------------------------------------

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

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, M

*

B 

B Tue Jan 10 17:23:55 2012

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        2844

M 

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

I  MtxInit: -2 0 0

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 Tue Jan 10 17:24:06 2012

M  calling db_connect ...

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

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=06E68A28,svrhp=06E68834)

C 

C Tue Jan 10 17:24:13 2012

C  Starting user session (con_hdl=0,svchp=06E68A28,srvhp=06E68834,usrhp=06EAA71C)

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

[dboci.c      3718]

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

[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=06E68A28,srvhp=06E68834,usrhp=06EAA71C)

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

[dboci.c      3718]

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

[dboci.c      9536]

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   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 mmsys_ERP_00 on host mmsys (wp 0)

M  *  ERROR tskh_init: db_connect

M  *

M  *  TIME Tue Jan 10 17:24:13 2012

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 2844) [dpnttool.c 345]

[former_member182657]

Hi,

B  ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress

Issue is related with the DB intialization,suggest you to re-verify the successful startup of DB first and refer SAP Note  655240 - Composite SAP note: ORA-01033

Hope this will help you.

Regards,

[Former Member]

hi Ajit,

The issue is with you DB is not completely up or in Shutdown phase. Can be seen in your log as below:-

C  *** ERROR => CONNECT failed with sql error '1033'
[dboci.c      9536]
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

So check your DB and get its status to Started and open mode to READ write.

This can be checked  by below command:-

Select open_mode from v$database,

Select STATUS from v$instance;

After which try to start the SAP system.

Regards,

Ram

[Former Member]

Hi,

It seems oracle is not up and not connecting to SAP. check R3trans -d & r3trans -x.

start DB and Restart SAP , It will work...

Also Refer to Note 655240

[Mofizur]

Hi,

ORA-01033 stands out when database connect attempt is made while oracle is starting up or shutting down.

May be Your database is not yet completely started.

Please execute

sqlplus / as sysdba

select * from v$instance

What's the output of the select command?Try to shutdown the Database and startup using below commands

shutdown immediate

startup

Thanks,

Mofizur

[former_member279000]

hi

i am new in sap that part i am no understand which type sole the problem please cleary which type i have go db i am not under stand

[Mofizur]

Login to to your DB Host where Oracle is installed as ora<sid>

Execute below commands

1) sqlplus "/ as sysdba"
2) select STATUS from v$instance

See what is the current status of you DB.

[former_member279000]

which type go login to yu db host where orcle please explain