Skip to Content
0
Former Member
Sep 06, 2007 at 03:32 AM

ERROR => OCI-call 'OCISessionBegin'

321 Views

I am donying an upgrade from Oracle 9.2.0.7 to 10.0.2.0. It's SAP Solution Manger 3.6 . Now I have done mos steps of upgrading. When I try the $ R3trans -d, I got failed messages. Here is the trans.log file, can any one help me???

k5701:[/oracle/PSM/102_64/dbs]%cat trans.log

4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

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

4 ETW000

4 ETW000 date&time : 06.09.2007 - 10:11:44

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] Thu Sep 6 10:11:44 2007 2413 0.002413

4 ETW000 [dev trc ,00000] db_con_init called 125 0.002538

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PSM/SYS/exe/run/dboraslib.sl' ...

4 ETW000 490 0.003273

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PSM/SYS/exe/run/dboraslib.sl), hdl 0

4 ETW000 187518 0.190791

4 ETW000 [dev trc ,00000] Library '/usr/sap/PSM/SYS/exe/run/dboraslib.sl' loaded

4 ETW000 428 0.191219

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PSM/SYS/exe/run/dboraslib.sl

4 ETW000 317 0.191536

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PSM/SYS/exe/run/dboraslib.sl' is "640.00", patchlevel (0.32)

4 ETW000 994 0.192530

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PSM/SYS/exe/run/dboraslib.sl

4 ETW000 410 0.192940

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PSM/SYS/exe/run/dboraslib.sl

4 ETW000 385 0.193325

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

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 207 0.193717

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

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

4 ETW000 159 0.194961

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 176 0.195137

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/PSM/102_64 from environment

4 ETW000 3377 0.198514

4 ETW000 [dev trc ,00000] -->oci_initialize 357 0.198871

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 19078 0.217949

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPXSM's password 307 0.218256

4 ETW000 [dev trc ,00000] Connecting as /@PSM on connection 0 ... 118 0.218374

4 ETW000 [dev trc ,00000] Allocating service context handle 398 0.218772

4 ETW000 [dev trc ,00000] Allocating server context handle 176 0.218948

4 ETW000 [dev trc ,00000] Attaching to DB Server PSM (con_hdl=0,svchp=8000000100808960,svrhp=8000000100809760)

4 ETW000 440 0.219388

4 ETW000 [dev trc ,00000] Assigning server context 8000000100809760 to service context 8000000100808960

4 ETW000 498313 0.717701

4 ETW000 [dev trc ,00000] Allocating user session handle 473 0.718174

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100808960,srvhp=8000000100809760,usrhp=80000001008131b8)

4 ETW000 227 0.718401

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

4 ETW000 28687 0.747088

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=8000000100809760)

4 ETW000 176 0.747264

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100808960,srvhp=8000000100809760)

4 ETW000 155 0.747419

4 ETW000 [dev trc ,00000] Deallocating server context handle 8000000100809760

4 ETW000 9499 0.756918

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

4 ETW000 537 0.757455

4 ETW000 [dev trc ,00000] Try to connect with default password 244 0.757699

4 ETW000 [dev trc ,00000] Connecting as SAPXSM/<pwd>@PSM on connection 0 ...

4 ETW000 230 0.757929

4 ETW000 [dev trc ,00000] Allocating server context handle 133 0.758062

4 ETW000 [dev trc ,00000] Attaching to DB Server PSM (con_hdl=0,svchp=8000000100808960,svrhp=8000000100809760)

4 ETW000 393 0.758455

4 ETW000 [dev trc ,00000] Thu Sep 6 10:11:45 2007 421267 1.179722

4 ETW000 [dev trc ,00000] Assigning server context 8000000100809760 to service context 8000000100808960

4 ETW000 231 1.179953

4 ETW000 [dev trc ,00000] Assigning username to user session 80000001008131b8

4 ETW000 189 1.180142

4 ETW000 [dev trc ,00000] Assigning password to user session 80000001008131b8

4 ETW000 297 1.180439

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100808960,srvhp=8000000100809760,usrhp=80000001008131b8)

4 ETW000 168 1.180607

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

4 ETW000 44126 1.224733

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=8000000100809760)

4 ETW000 432 1.225165

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100808960,srvhp=8000000100809760)

4 ETW000 154 1.225319

4 ETW000 [dev trc ,00000] Deallocating server context handle 8000000100809760

4 ETW000 1612 1.226931

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

4 ETW000 213 1.227144

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CON [dblink#1 @ 419]

4 ETW000 2139 1.229283

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: Cannot access NLS data files or invalid environment specified [dblink#1 @ 419]

4 ETW000 170 1.229453

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PSM'"