Disp+work not starting after kernal upgrade

[former_member209809]

Dear Experts,

I have updated my kernal from 701 to 720 after which Disp+work process is not starting.

System Config:

Solman 7.o EHP1 on Oracle 11i

OS: windows server 2003 R2

I have checked workprocess logs which says

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

C     ORA-01034: ORACLE not available

C  ORA-27101: shared memory realm does not exist

C  Detaching from DB Server (con=0,svchp=0000000007A2AC58,srvhp=000000000FC9DE78)

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

[dbsloci.c    11299]

C  SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034.

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

B  ***LOG BY2=> sql error 1034 performing CON [dblink#4 @ 433] [dblink  0433 ]

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

ORA-27101: shared memory realm does not exist [dblink#4 @ 433] [dblink  0433 ]

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

M  in_ThErrHandle: 1

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

I am attaching some log files. I have already tried restarting services. Kindly help me with this issue.

Regards,

Sumit

listener.ora.txt.zip

dev_w0.txt.zip

dev_dispatcher.txt.zip

[Former Member · Accepted solution]

Hi Sumit,

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

>> ORA-27101: shared memory realm does not exist [dblink#4 @ 433] [dblink  0433 ]

It seems that Oracle has not been started. Try to start the database, manually;

Best regards,

Orkun Gedik

[former_member209809 · Accepted solution]

Hi Orkun,

Thanks for you reply.

I am very new in Basis and Oracle so can you tell me how to start Oracle Manually.

Regards,

Sumit

[Former Member · Accepted solution]

Execute the command at the OS level, below;

sqlplus "/ as sysdba"

On the "SQL>" prompt, type "startup"

After that try to start the SAP

Best regards,

Orkun Gedik

[S0007586158 · Accepted solution]

Hi,

As <sidadm> user from the os level, startsap all command will start both db & application.

Regards,

Sam

[former_member209809]

Hi All,

I have updated TP and R3trans and issue got resolved.

Thanks all for your support.

[former_member209809]

Hi,

tp logs

Import phase 'CHECK_REQUIREMENTS' (05.09.2012, 14:42:28)
Error during executing the tp command 'tp CONNECT SOL   ...'
tp return code: '0249' , tp message: 'connect failed due to DbSL load lib failure' , tp output:
  This is tp version 376.01.14 (release 701, unicode enabled)
  Warning: Parameter DBLIBPATH is no longer used.
  ERROR: No connect due to DbSl Load Lib Failure
  ERROR: Possible reasons are:
  ERROR: - The value set for dbms_type ('ora') is invalid.
  ERROR: - Cannot find the DLL dboraslib.dll in path
  ERROR: - problems when loading DB-dependent DLLs
  ERROR: Connect to SOL failed (20120905144228).

Regards,

Sumit Jha

[former_member189725]

I suggest you update the kernel .

Also try rebooting the OS.

Regards

Ratnajit

[former_member209809]

Hi Ratnajit,

I have already updated kernal from 701 to 720.

Still issue persist.

[former_member189725]

Can you boot the Windows OS ?

Regards

Ratnajit

[Former Member]

Hi Sumit,

>> ERROR: - Cannot find the DLL dboraslib.dll in path

The problem is caused by the dboraslib.dll is not accessible. Check the note, below;

Note 175627 - tp: Test import does not work (load lib)

Best regards,

Orkun Gedik

[former_member209809]

Hi Orkun,

I am now able to start DISP_Work but it is still yellow and saying dispatcher connected but can not get dialog queue info. And also after login i am trying to apply patch but i am getting an error in Check Requirement Phase: TP CONNECT ERROR

Any sugessions?

[Former Member]

>> I am now able to start DISP_Work but it is still yellow and saying dispatcher connected but can not get dialog queue info

Could you paste the dev_w0 here, please? What about the ABAP workprocesses? Did they started successfully?

>> And also after login i am trying to apply patch but i am getting an error in Check Requirement Phase: TP CONNECT ERROR

Wher do you get this error?

[former_member209809]

When I am applying Addon in SAINT.

error: TP_CANNOT_CONEECT_SYSTEM

Return Code: 0249

[former_member189725]

Go to tcode STMS

Overview -->systems

Select the system you are logged on.

SAP system --> check --> transport tool.

Check the error you get.

Regards

Ratnajit