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,