ABAP Database is not available via R3trans ?

[Former Member]

hi experts,

when i startup sap app server, startsap_.log contain one error:

Checking BID Database

-

---

ABAP Database is not available via R3trans

R3trans -d :

This is R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

R3trans finished (0000).

trans.log:

ETW000 [dev trc ,00000] DELETE FROM "PATCHHIST" WHERE "EXECUTABLE" = :A0 AND "SAPRELEASE" = :A1 AND "HOSTNAME"

= :A2 AND "PLATFORM" = :A3 AND "DBV

4 ETW000 103 0.422172

4 ETW000 [dev trc ,00000] ENDOR" = :A4 AND "TIMESTAMP" = :A5

4 ETW000 62 0.422234

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 633 0.422867

4 ETW690 COMMIT "0" "0"

4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)

4 ETW000 546 0.423413

4 ETW000 trace to file pointer closed

4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 06.11.2008 - 17:04:51

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 940 0.000940

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 78 0.001018

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x80000001010c1018,usrhp=0x80000001010b11c8)

4 ETW000 298 0.001316

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x80000001010c1018,srvhp=0x80000001010c3310)

4 ETW000 578 0.001894

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 294 0.002188

4 ETW000 [dev trc ,00000] Disconnected from connection 0 39 0.002227

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000 55 0.002282

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 54 0.002336

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000)

-

---

thanks in advance.

[Former Member]

Hi,

Make sure after the Kernel update all of the below locations are of same Patch Level.

LOCATION 1: /sapmnt/<SID>/exe

LOCATION 2: /usr/sap/<SID>/<Instance>/exe

You would have replaced the kernel at LOCATION 1, but the kernel at LOCATION 2 will still remain at old level which will prevent the access to database. So replace the kernel at LOCATION 2, and then try start SAP it should work.

Thanks,

Kamesh

[Former Member]

Hi Kamesh,

I have faced the same issue after kernel upgrade

your solution worked for me, Thanks for the same

Regards,

Sandeep K

[Former Member]

Hi, I´m confussed here, as long as I know if R3trans -d finishes with 0000 then it is connecting, if it is 0012 or something else then there is a problem.

Please provide OS/DB information, also dev_w0 trace file