Initialization DB-Connect Failed, Return Code 000256

[Former Member]

Hi All,

In Sm21 i found lot of logs with same error shown below

02:07:12 DIA 000 R1 9 Initialization DB-Connect Failed, Return Code 000256

02:07:12 DIA 000 Q0 2 Stop Workproc 0, PID 3352

02:07:56 DIA 001 000 SAPSYS R4 7 Delete session 001 after error 050

02:11:50 WRK 000 Q0 Q Start Workproc 0, Pid 3520

02:11:51 DIA 000 R1 9 Initialization DB-Connect Failed, Return Code 000256

02:11:51 DIA 000 Q0 2 Stop Workproc 0, PID 3520

02:16:33 WRK 000 Q0 Q Start Workproc 0, Pid 1492

02:16:34 DIA 000 R1 9 Initialization DB-Connect Failed, Return Code 000256

02:16:34 DIA 000 Q0 2 Stop Workproc 0, PID 1492

02:21:33 WRK 000 Q0 Q Start Workproc 0, Pid 3952

02:21:34 DIA 000 R1 9 Initialization DB-Connect Failed, Return Code 000256

02:21:34 DIA 000 Q0 2 Stop Workproc 0, PID 3952

02:26:36 WRK 000 Q0 Q Start Workproc 0, Pid 3984

02:26:37 DIA 000 R1 9 Initialization DB-Connect Failed, Return Code 000256

02:26:37 DIA 000 Q0 2 Stop Workproc 0, PID 3984

02:31:39 WRK 000 Q0 Q Start Workproc 0, Pid 3512

02:31:40 DIA 000 R1 9 Initialization DB-Connect Failed, Return Code 000256

i runned r3trans -d

log shows

4 ETW000 R3trans version 6.14 (release 700 - 20.07.06 - 17:34:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 04.06.2010 - 10:38:48

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] Fri Jun 04 10:38:51 2010 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000 0.000000

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

Now sap is working. Can any one please tell me what is the problem

Thanks

Shashi

[Frank-Martin]

HI,

SAP processes use the environment variable dbms_type to determine which database interface library to load.

For example if

dbms_type=db6

SAP processes will load library dbdb6slib.* . The variable should be contained in the login scrpits of your sapsid user.

Regards

Frank