Skip to Content
0
Former Member
Dec 02, 2009 at 12:35 PM

Setting DIR_CLIENT_ORAHOME is not set as environ ment variable,

450 Views

Hi,

After oracle upgrade from 9i to 10g. when starting the sap getting error in r3trans.

Please find the error ..

C:\Documents and Settings\devadm>r3trans -x

This is r3trans version 6.13 (release 640 - 26.05.09 - 10:25:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'DEV'"

r3trans finished (0012).

C:\Documents and Settings\devadm>more tarns.log

Cannot access file C:\Documents and Settings\devadm\tarns.log

C:\Documents and Settings\devadm>more trans.log

4 ETW000 r3trans version 6.13 (release 640 - 26.05.09 - 10:25:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 02.12.2009 - 17:17:41

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -x

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

4 ETW000 [dev trc ,00000] Wed Dec 02 17:17:41 2009

12919 0.012919

4 ETW000 [dev trc ,00000] db_con_init called

36 0.012955

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

5694 0.018649

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ...

55 0.018704

4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"),

hdl 0, addr 0000000010000000

4 ETW000

51387 0.070091

4 ETW000 [dev trc ,00000] using "K:\usr\sap\DEV\SYS\exe\uc\NtIa64\dbor

aslib.dll"

4 ETW000

43 0.070134

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded

32 0.070166

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dborasl

ib.dll

4 ETW000

2786 0.072952

4 ETW000 [dev trc ,00000] Wed Dec 02 17:17:42 2009

19948 0.092900

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlev

el (0.276)

4 ETW000

42 0.092942

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboras

lib.dll

4 ETW000

9780 0.102722

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbora

slib.dll

4 ETW000

57 0.102779

4 ETW000 [dev trc ,00000] New connection 0 created

47 0.102826

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DI

SCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_

max = 255, con_opt = 255, occ = NO

4 ETW000

88 0.102914

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

38 0.102952

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection

for reuse:

4 ETW000

43 0.102995

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DIS

CONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_

max = 255, con_opt = 255, occ = NO

4 ETW000

79 0.103074

4 ETW000 [dev trc ,00000] Setting DIR_CLIENT_ORAHOME is not set as environ

ment variable,

4 ETW000 assuming using instant client with unspecified l

ocation.

4 ETW000

9532 0.112606

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0)

4376 0.116982

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from enviro

nment

4 ETW000

51 0.117033

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=16384)'

failed: rc = -1

4 ETW000

503326 0.620359

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1

42 0.620401

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIErrorGet' failed: rc =

-2

4 ETW000

143 0.620544

4 ETW000 [dblink ,00430] ***LOG BY2=>sql error -1 performing CON [dbl

ink#6 @ 430]

4 ETW000

27555 0.648099

4 ETW000 [dblink ,00430] ***LOG BY0=>Cannot get Oracle error text. [dblin

k#6 @ 430]

4 ETW000

48 0.648147

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

*********************************

INSTANCE PROFILE contents are

SAPSYSTEMNAME=DEV

INSTANCE_NAME=DVEBMGS00

SAPSYSTEM=00

rdisp/wp_no_dia=2

rdisp/wp_no_btc=2

rdisp/wp_no_vb=1

rdisp/wp_no_vb2=1

rdisp/wp_no_enq=1

rdisp/wp_no_spo=1

SAPGLOBALHOST=ECCDEV

PHYS_MEMSIZE=9817

DIR_TRANS=K:\usr\sap\trans

icm/server_port_0=PROT=HTTP,PORT=8000

DIR_CT_RUN=K:\usr\sap\DEV\SYS\exe\uc\NtIa64

DIR_ORAHOME=E:\ORACLE\DEV\102

DIR_CLIENT_ORAHOME=K:\usr\sap\DEV\SYS\exe\uc\NtIa64

regards,