cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Go to solution
Former Member

on ‎10-18-2008 11:25 AM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎10-18-2008 6:36 PM
0 Kudos

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.

Show replies
Show replies
fidel_vales
Employee
Employee
‎10-18-2008 9:48 PM
0 Kudos

Review your oracle client installation.

You have kernel 640.

After installing oracle RDBMS 10g you must install physically on all your application servers (including central instance) the oracle client 9.2.0.7 or 9.2.0.8

You must also correct your environment variables so this client is used (ORA_NLS33)

Answers (2)

Answers (2)

Former Member
‎10-18-2008 10:35 PM
0 Kudos

I changed the ORA_NLS33 variable to the old Oracle (/oracle/client/92x_64/ocommon/nls/admin/data) and then retried "R3trans -d". It failed again but when I checked trans.log this time it complained about the SAPR3 password so I used brconnect to change it. This time it worked! SAP was then able to start up which made me very happy. Thanks to all of you that provided input to help resolve my issue.

Show replies
Show replies
former_member227600
Contributor
‎10-18-2008 12:09 PM
0 Kudos

Hi,

ORA-12705: Cannot access NLS data files or invalid environment specified

Please go through the following note,It may help you

note-592657

[https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=592657]

karan

Show replies
Show replies
Ask a Question