Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

R3trans -d produces "no connect possible" error after Oracle upgrade

Hi,

I spend all day and night upgrading my rdbms from 9.2.0.7 to 10.2.0.2 on HP-UX 11.11. One of the final steps is to test that R3trans can connect to the database from <sid>adm using R3trans -d but it errors out. Please help!!!!

This is R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

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

R3trans finished (0012).

Things I've tried already:

Changed the SAPR3 user password with brconnect

unset ORA_NLS33

Environment variables:

ORA_NLS33=/oracle/DL2/102_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

dbms_type=ORA

ORACLE_PSRV=DL2

ORACLE_SID=DL2

ORACLE_HOME=/oracle/DL2/102_64

ORA_NLS33=/oracle/DL2/102_64/ocommon/nls/admin/data

Here is my trans.log:

4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

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

4 ETW000

4 ETW000 date&time : 18.10.2008 - 06:14:11

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] Sat Oct 18 06:14:11 2008 526 0.000526

4 ETW000 [dev trc ,00000] db_con_init called 29 0.000555

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

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

4 ETW000 95 0.000828

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

4 ETW000 42532 0.043360

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

4 ETW000 35 0.043395

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

4 ETW000 53 0.043448

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

4 ETW000 245 0.043693

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

4 ETW000 42 0.043735

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

4 ETW000 84 0.043819

4 ETW000 [dev trc ,00000] New connection 0 created 33 0.043852

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 291 0.044143

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

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

4 ETW000 32 0.044342

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 37 0.044379

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

4 ETW000 578 0.044957

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 65 0.045022

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 31 0.045053

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 4002 0.049055

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 48 0.049103

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

4 ETW000 50 0.049153

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

4 ETW000 43 0.049196

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 8000000100b07bb0 8000000100b0f3f0 8000000

100b0ed88

4 ETW000 37 0.049233

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

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

4 ETW000 [dev trc ,00000] Attaching to DB Server DL2 (con_hdl=0,svchp=8000000100b0ecb8,srvhp=8000000100b0fab8)

4 ETW000 80 0.049422

4 ETW000 [dev trc ,00000] Assigning server context 8000000100b0fab8 to service context 8000000100b0ecb8

4 ETW000 99835 0.149257

4 ETW000 [dev trc ,00000] Allocating user session handle 98 0.149355

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100b0ecb8,srvhp=8000000100b0fab8,usrhp=8000000100b19d08)

4 ETW000 51 0.149406

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

4 ETW000 5229 0.154635

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

4 ETW000 36 0.154671

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100b0ecb8,srvhp=8000000100b0fab8)

4 ETW000 34 0.154705

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

4 ETW000 873 0.155578

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

4 ETW000 119 0.155697

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 36 0.155733

4 ETW000 [dev trc ,00000] Try to connect with default password 39 0.155772

4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@DL2 on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 44 0.155816

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

4 ETW000 37 0.155853

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 8000000100b07bb0 8000000100b0f3f0 8000000

100b0ed88

4 ETW000 37 0.155890

4 ETW000 [dev trc ,00000] Allocating server context handle 25 0.155915

4 ETW000 [dev trc ,00000] Attaching to DB Server DL2 (con_hdl=0,svchp=8000000100b0ecb8,srvhp=8000000100b0fab8)

4 ETW000 52 0.155967

4 ETW000 [dev trc ,00000] Assigning server context 8000000100b0fab8 to service context 8000000100b0ecb8

4 ETW000 82313 0.238280

4 ETW000 [dev trc ,00000] Assigning username to user session 8000000100b19d08

4 ETW000 43 0.238323

4 ETW000 [dev trc ,00000] Assigning password to user session 8000000100b19d08

4 ETW000 65 0.238388

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100b0ecb8,srvhp=8000000100b0fab8,usrhp=8000000100b19d08)

4 ETW000 36 0.238424

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

4 ETW000 8639 0.247063

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

4 ETW000 34 0.247097

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100b0ecb8,srvhp=8000000100b0fab8)

4 ETW000 34 0.247131

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

4 ETW000 355 0.247486

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

4 ETW000 48 0.247534

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12705 24 0.247558

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 12705 performing CON [dblink#3 @ 428]

4 ETW000 442 0.248000

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

4 ETW000 37 0.248037

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

replied

Hi. Try to check, after you upgrade to 10g add the ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data variable for your SIDADM user environment,and ORA_NLS10=$ORACLE_HOME/nls/data to your ORASID .

Regards.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question