Hello together,
after an upgrade from 9.2.0.6 to 10.2.0.4 I get an error while execitung r3trans -x
4 ETW000 r3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 20.03.2009 - 14:25:15
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] Fri Mar 20 14:25:18 2009 8310 0.008310
4 ETW000 [dev trc ,00000] db_con_init called 51 0.008361
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 81 0.008442
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 56 0.008498
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 70448 0.078946
4 ETW000 [dev trc ,00000] using "U:\usr\sap\XIT\SYS\exe\run\dboraslib.dll"
4 ETW000 62 0.079008
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 22 0.079030
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 36 0.079066
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.220)
4 ETW000 29561 0.108627
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 37 0.108664
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 48 0.108712
4 ETW000 [dev trc ,00000] New connection 0 created 33 0.108745
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 42 0.108787
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 27 0.108814
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 30 0.108844
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 39 0.108883
4 ETW000 [dev trc ,00000] Setting DIR_CLIENT_ORAHOME is not set as environment variable,
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 7523 0.116406
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 1647 0.118053
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment
4 ETW000 76 0.118129
4 ETW000 [dev trc ,00000] Fri Mar 20 14:25:19 2009 1083348 1.201477
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=16384)' failed: rc = -1
4 ETW000 50 1.201527
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 6007 1.207534
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2
4 ETW000 50 1.207584
4 ETW000 [dblink ,00428] ***LOG BY2=>sql error -1 performing CON [dblink#3 @ 428]
4 ETW000 52618 1.260202
4 ETW000 [dblink ,00428] ***LOG BY0=>Cannot get Oracle error text. [dblink#3 @ 428]
4 ETW000 113 1.260315
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'XIT'"
With SQL*Net I can log on as normal and can read data with select statements.
What's tehe problem............please help me.
Thanks
Christian
PS: I have checked the env. variables and listener/tnsnames.ora!!!