Interesting Problem with R3trans -d

141 Views

Guys!

I am facing a strange and a interesting problem with R3trans -d

I hav DB and CI installed in two different boxes.

From CI, if i do a R3trans -d, I get RC=12. BUT if I start SAP it runs fine without any issues.

Log files shows that its not able to connect with OPS$ user, Log below.

basically it fails in the step conn /@PRE

if i go to command prompt of CI and try that, as expected it fails even there too...

but i am able to connect with system, sys, etc from CI and run all select queries.

Now, If i go to DB Server...and there if i run 'conn /@PRE' it works!

Why is it not workin from CI?

All env variables are set.

R3trans Log:

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDAT's password 44 0.181828

4 ETW000 [dev trc ,00000] Connecting as /@PRE on connection 0 (nls_hdl 0) ... (dbsl 640 310306)

4 ETW000 46 0.181874

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 47 0.181921

4 ETW000 [dev trc ,00000] 0 UTF8 1 00000000002D4000 00000000002F0A38 00000000002F03E8

4 ETW000 127 0.182048

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 11146 0.193194

4 ETW000 [dev trc ,00000] Allocating server context handle 33 0.193227

4 ETW000 [dev trc ,00000] Attaching to DB Server PRE (con_hdl=0,svchp=00000000002F02B8,svrhp=00000000002F2788)

4 ETW000 65 0.193292

4 ETW000 [dev trc ,00000] Assigning server context 00000000002F2788 to service context 00000000002F02B8

4 ETW000 98809 0.292101

4 ETW000 [dev trc ,00000] Allocating user session handle 51 0.292152

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=00000000002F02B8,srvhp=00000000002F2788,usrhp=00000000002FC488)

4 ETW000 52 0.292204

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

4 ETW000 17264 0.309468

4 ETW000 [dev trc ,00000] Wed Jul 11 06:39:37 2007 7434 0.316902

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'