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'"