R3trans -x Failure

[Former Member]

Recently i have installed Oracle 10g software with all required patches. Then did a Oracle DB copy and was able to bring up the database successfully on the target machine. While trying to test the DB connectivity i am receiving following errors. Could not figure out what it is exactly looking for : client library. I have verified system variables and also looked at SAP note: 556232. Still could n't figure out.. Any help would be appreicated..

-

---

4 ETW000 R3trans version 6.05 (release 46D - 27.03.05 - 14:30:00).

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

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 date&time : 13.04.2007 - 12:17:48

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [developertra,00000] Fri Apr 13 12:17:51 2007 0.000000

4 ETW000 [developertra,00000] db_con_init called 0.000000

4 ETW000 [developertra,00000] create_con (con_name=R/3) 0.000000

4 ETW000 [developertra,00000] Loading DB library 'dboraslib.dll' ... 0.000000

4 ETW000 [developertra,00000] load shared library (dboraslib.dll), hdl 0 7525 0.007525

4 ETW000 [developertra,00000] Library 'dboraslib.dll' loaded 22 0.007547

4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 23 0.007570

4 ETW000 [developertra,00000] Version of library 'dboraslib.dll' is "46D.00", patchlevel (0.2238)

4 ETW000 159 0.007729

4 ETW000 [developertra,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 21 0.007750

4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 27 0.007777

4 ETW000 [developertra,00000] New connection 0 created 23 0.007800

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 23 0.007823

4 ETW000 [developertra,00000] find_con found the following connection for reuse:

4 ETW000 20 0.007843

4 ETW000 [developertra,00000] -->oci_initialize 231 0.008074

4 ETW000 [developertra,00000] Got TNS_ADMIN=E:\oracle\IED\102\NETWORK\admin from environment

4 ETW000 63 0.008137

4 ETW000 [developertra,00000] Got ORACLE_SID=IED from environment 16 0.008153

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 24 0.008177

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 13 0.008190

4 ETW000 [developertra,00000] Connecting as /@IED on connection 0 ... 15 0.008205

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='IED') 20 0.008225

4 ETW000 [dbsloci. ,00000] *** ERROR => Couldn't initialize Oracle Client Library

4 ETW000 please check your installation 546 0.008771

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

-

---

[Former Member · Accepted solution]

Hi Vittal,

I had exactly the same situation.

Take a look in note 976457, for me it functioned.

Hop this can help you.

Best regards.

Arnaldo.

[Former Member]

There are two things you need to check for Oracle 10g;

1) Check the Environment Variable ORA_NLS33 set correctly

2) Use the latest Kernel Version for R3trans.

These two will fix your R3trans Error.

Thanks & Regards

Prabakaran.S

[Former Member]

this is Windowsw, and therefore ORA_NLS must not be set as environment variabel!

[Former Member]

therefore all statements concerning Oracle9 Client software are wrong.

Did you follow the SAP Oracle10 Upgrade Guide?

In this one you where asked to unpack the Oracle10.2.0.2.5 Instant Client into DIR_CT_RUN (SAP Profile Parameter, see se38 report RSPARAM for more details) and to update sapcpe to the newest verson on SMP.

After the second start of your SAP System (Dialog Instances) the Client is distributed to all app-servers and the right Oracle Client is used.

Peter

[Former Member]

Hi Vittal,

Make sure that you have the client in right path, on unix ideally... /oracle/client/<version> under which you must have links to bineries jdbc and lib, ideally on unix /oracle/<SID>/<verions>/jdbc and /oracle/<SID>/<verions>/lib. Then try to relink client to do this go to path $ORACLE_HOME/bin then use command relink client.

I hope this must fix your problem.

Regards

Manohar Boga

[Former Member]

Hello,

Based on R3trans log, you are on SAP R3 46c and might be using 46D kernels.

Please know that for Oracle 10G DB you still need to use 92x client and if you want to run DBATOOLS 7.0 you can unpack and place the 10x client.

You can check these and resolve:

1) check oracle client and install latest 9.2.0.8 client

2) check env parameters and point out NLS33 to 92x client lib

3) Also check lsnrctl files and change them according to 10.2.0.2

Hope this helps,

Thanks,

Hari

[Former Member]

Thank u for the reply. But would like few clarifications:

1. Where do I need to install the Oracle client 9.2.0.8? I meean under what directory? On unix we normallu do it under: /oracle/client/92x_64

How about on NT? ANy specific directories do I need to create?

2. What exactly to check in the listener files. I was able to do tnsping and also able to connect using sqlnet connection.