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 issue after Oracle upgrade

Former Member

on ‎03-18-2009 3:48 AM

0 Kudos

Hello all,

We have recently upgraded our database from oracle 9207 to 10202. However, when we change the environment variable for <sid>adm user R3trans -d does not work and it fails with error and we cannot start sap and database. So reverted the environment parameters for <sid>adm to old 9207 parameters where R3trans works fine and connects to the database.

Since our SAP is 4.6D kernel ( APO 3.1) we are still using old client 9207.

Below are the logs for R3trans connecting in both environments. Please look into this and suggest.

R3trans error in 10264 home_

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 -xv

4 ETW000 date&time : 17.03.2009 - 07:41:04

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

4 ETW000 [developertra,00000] Tue Mar 17 07:41:04 2009 1974 0.001974

4 ETW000 [developertra,00000] db_con_init called 67 0.002041

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

4 ETW000 [developertra,00000] Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.sl' ...

4 ETW000 210 0.002319

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

4 ETW000 217525 0.219844

4 ETW000 [developertra,00000] Library '/usr/sap/SID/SYS/exe/run/dboraslib.sl' loaded

4 ETW000 247 0.220091

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

4 ETW000 142 0.220233

4 ETW000 [developertra,00000] Version of library '/usr/sap/SID/SYS/exe/run/dboraslib.sl' is "46D.00", patchlevel (0.2186)

4 ETW000 28000 0.248233

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

4 ETW000 109 0.248342

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

4 ETW000 2514 0.250856

4 ETW000 [developertra,00000] New connection 0 created 6097 0.256953

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 487 0.257440

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

4 ETW000 77 0.257517

4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/SID/102_64 from environment

4 ETW000 14003 0.271520

4 ETW000 [developertra,00000] -->oci_initialize 1141 0.272661

4 ETW000 [developertra,00000] Got ORACLE_SID=SID from environment 1269 0.273930

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

4 ETW000 1124 0.275054

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

4 ETW000 [developertra,00000] Connecting as /@SID on connection 0 ... 161 0.275270

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='SID') 104 0.275374

*4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1019 7412 0.282786*

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

4 ETW000 133 0.282919

4 ETW000 [developertra,00000] Try to connect with default password 57 0.282976

4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@SID on connection 0 ...

4 ETW000 81 0.283057

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='SID')

4 ETW000 76 0.283133

4 ETW000 [developertra,00000] Tue Mar 17 07:41:05 2009 332708 0.615841

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

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

4 ETW000 108 0.616097

4 ETW000 [developertra,00000] Got ORACLE_SID=SID from environment 309 0.616406

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

4 ETW000 99 0.616505

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

4 ETW000 [developertra,00000] Connecting as /@SID on connection 0 ... 59 0.616621

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='SID') 61 0.616682

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

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

4 ETW000 216 0.913338

4 ETW000 [developertra,00000] Try to connect with default password 72 0.913410

4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@SID on connection 0 ...

4 ETW000 96 0.913506

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='SID')

4 ETW000 89 0.913595

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

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

4 ETW000 214 1.216416

4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 12705 performing CON 369 1.216785

4 ETW000 [dblink ,00627] ***LOG BY0=> 68 1.216853

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

R3trans Log in 92064 oracle home_

4 ETW000 R3trans was called as follows: R3trans -xv

4 ETW000 date&time : 17.03.2009 - 07:44:00

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

4 ETW000 [developertra,00000] Tue Mar 17 07:44:00 2009 2018 0.002018

4 ETW000 [developertra,00000] db_con_init called 71 0.002089

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

4 ETW000 [developertra,00000] Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.sl' ...

4 ETW000 194 0.002343

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

4 ETW000 76692 0.079035

4 ETW000 [developertra,00000] Library '/usr/sap/SID/SYS/exe/run/dboraslib.sl' loaded

4 ETW000 208 0.079243

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

4 ETW000 131 0.079374

4 ETW000 [developertra,00000] Version of library '/usr/sap/SID/SYS/exe/run/dboraslib.sl' is "46D.00", patchlevel (0.2186)

4 ETW000 697 0.080071

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

4 ETW000 92 0.080163

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

4 ETW000 134 0.080297

4 ETW000 [developertra,00000] New connection 0 created 76 0.080373

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 450 0.080823

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

4 ETW000 73 0.080896

4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/SID/920_64 from environment

4 ETW000 1648 0.082544

4 ETW000 [developertra,00000] -->oci_initialize 81 0.082625

4 ETW000 [developertra,00000] Got ORACLE_SID=SID from environment 124 0.082749

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

4 ETW000 123 0.082872

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

4 ETW000 [developertra,00000] Connecting as /@SID on connection 0 ... 197 0.083117

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='SID') 92 0.083209

4 ETW000 [developertra,00000] Tue Mar 17 07:44:01 2009 339042 0.422251

4 ETW000 [developertra,00000] Now I'm connected to ORACLE using OCI_7 API 114 0.422365

4 ETW000 [developertra,00000] Got SAPR3's password from table SAPUSER 41472 0.463837

4 ETW000 [developertra,00000] Disconnecting from connection 0 ... 92 0.463929

4 ETW000 [developertra,00000] -->oci_logoff(con_hdl=0) 53 0.463982

4 ETW000 [developertra,00000] Now I'm disconnected from ORACLE 4099 0.468081

4 ETW000 [developertra,00000] Try to connect with the password I got from OPS$-user

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎03-18-2009 4:10 AM
0 Kudos

Hello Sandeep,

The SQL error 1019 and 12705 typically comes for environmental variable ORA_NLS33. What is the value of this variable in your system? This value should be /oracle/<ocl_rel>/ocommon/nls/admin/data for <sidadm> user.

Please refer OSS note # 180430 for more details.

Thanks

Gautam

Show replies
Show replies
Former Member
‎03-18-2009 5:23 AM
0 Kudos

Hi Gautam,

Thanks for your suggestion. WE just solved the problem. It was issue with 9207 client and the parameter 9207 client we reinstalled and gave the value for ORA_NLS33 as /oracle/client/92x_64/ocommon/nls/admin/data which resolved the issue.

Regards,

Sandeep.

Ask a Question