Skip to Content
avatar image
Former Member

R3trans error after oracle upgrade

Hi,

Hi,

We are doing a database upgrade as a part of NW04s upgrade.Our source

Oracle release was 9.2.0.6 and now we have upgraded it to 10.2.0.2.The

database upgrade was successfull and the database is up and running.When we execute R3trans -d it fails with the return code 12,the detailed error is as follows

.....4 ETW000 [dev trc ,00000] Assigning user session 110c26278 to service context 110c1b1d8

4 ETW000 20252 0.284724

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 94 0.284818

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 127 0.284945

4 ETW000 [dev trc ,00000] Now '/@BIG' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 2112 0.287057

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 57 0.287114

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 859 0.287973

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER

4 ETW000 2276 0.290249

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 113 0.290362

4 ETW000 [dev trc ,00000] Rolling back transaction ... 136 0.290498

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=110c1b1d8,usrhp=110c26278)

4 ETW000 377 0.290875

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1563 0.292438

4 ETW000 [dev trc ,00000] Try to connect with default password 28 0.292466

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

4 ETW000 39 0.292505

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

4 ETW000 43 0.292548

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 110c12820 110c1ba58 110c1b388

4 ETW000 40 0.292588

4 ETW000 [dev trc ,00000] Assigning username to user session 110c26278 85 0.292673

4 ETW000 [dev trc ,00000] Assigning password to user session 110c26278 78 0.292751

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110c1b1d8,srvhp=110c1d838,usrhp=110c26278)

4 ETW000 41 0.292792

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

4 ETW000 27471 0.320263

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

4 ETW000 39 0.320302

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]

4 ETW000 133 0.320435

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#2 @ 419]

4 ETW000 37 0.320472

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

what could be the reason?

Regards,

Cherry

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    Dec 01, 2006 at 06:19 AM

    Hi

    Have a look on note 403004.This will help you.

    Regards

    Vinod

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      This is hat I have dor the listerner & tnsnames.

      more listener.ora

      1. LISTENER.ORA Network Configuration File: /oracle/DWT/102_64/network/admin/list

      ener.ora

      1. Generated by Oracle configuration tools.

      LISTENER =

      (DESCRIPTION_LIST =

      (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = DWT.WORLD))

      )

      (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = DWT))

      )

      (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = sdr3bw4)(PORT = 1553))

      )

      )

      SID_LIST_LISTENER =

      (SID_LIST =

      (SID_DESC =

      (SDU = 32768)

      (SID_NAME = DWT)

      (ORACLE_HOME = /oracle/DWT/102_64)

      )

      )

      LOGGING_LISTENER = OFF

      ################

      1. Filename......: listener.ora

      2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

      3. Name..........:

      4. Date..........:

  • avatar image
    Former Member
    Dec 04, 2006 at 03:57 PM

    Hello!

    I am also getting an R3trans -d error after upgrading Oracle from 9.2.0.6 to 10.2.0.2 on UNIX.

    Ehrn I run R3trans -d I get this:

    This is R3trans version 6.13 (release 640 - 12.12.05 - 14:24:42).

    unicode enabled version

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

    R3trans finished (0012).

    The R3trans -x log has this error:

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

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

    4 ETW000 55 0.039848

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

    4 ETW000 3158 0.043006

    4 ETW000 [dblink ,00419] ***LOG BY2=>sql error -1 performing CON [dblink#2 @ 419]

    4 ETW000 426 0.043432

    4 ETW000 [dblink ,00419] ***LOG BY0=>'OCI_ERROR' [dblink#2 @ 419] 45 0.043477

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

    I looked at SP notes 403004, 602843 & 400241 and every thing looks okay.

    Any advice would be appreciated!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I have one doubt ...did u follow the upgrade guide for oracle 10g..I hope this problem is with tnsnames.ora..check it

      Regards

      Umesh k

  • avatar image
    Former Member
    Dec 05, 2006 at 05:37 PM

    Check tnsping for the listener. Maybe the listener environment still has Oracle 9 entries. You might have to stop the listener, change to 10g and start back the listener.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Change you TNSNAMES.ORA

      the parameters (SERVER = DEDICATED) is not support by Oracle 10 and Sap

      modify you TNSNAMES.ORA and delete this entry

      example ...you new TNSNAMES.ORA

      DWT.WORLD =

      (DESCRIPTION =

      (ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = sdr3bw4)(Port = 1553))

      (CONNECT_DATA =

      (SID = DWT)

      (GLOBAL_NAME = DWT.world)

      )

      )

      LISTENER_DWT.WORLD =

      (ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = sdr3bw4)(Port = 1553))

      Regards,

      Eva Belén Garcia

  • avatar image
    Former Member
    Dec 06, 2006 at 07:16 PM

    This error seems to be related to environement variables.

    Did you take out the NLS variables related to 9i that the upgrade guide talks about and put the ones for 10g in?

    Pleasae make sure these variables are permanently set in the the user env.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You may want to use one of these lines for the ORA_NLS33 value:

      setenv ORA_NLS33 /oracle/client/9207/ocommon/nls/admin/data

      or setenv ORA_NLS33 /oracle/client/920_64/ocommon/nls/admin/data

      or setenv ORA_NLS33 /oracle/<SID>/920_64/ocommon/nls/admin/data

      This is only if you are using 10g with kernel 640.

  • avatar image
    Former Member
    Jan 06, 2007 at 07:44 AM

    To make my 10g to work correctly with 640 kernel

    i had to set NLS33

    Also i had to use client 9207 as 10g was not working perfectly well with 10 client ( TMS and Support pack apllication were termating)

    Refer note 953388 and 886783

    Thanks

    Naushad

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2007 at 12:21 PM

    Hi Cherry

    Login from your ADM user and run r3trans -d and other commands with proper syntax.It will not show any such error

    Regards

    Varun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 29, 2007 at 10:41 AM

    After setting the environment variable ORA_NLS33 /oracle/<SID>/920_64/ocommon/nls/admin/data

    The problem was solved and the SAP is running fine.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2007 at 08:06 AM

    Change you TNSNAMES.ORA

    the parameters (SERVER = DEDICATED) is not support by Oracle 10 and Sap

    modify you TNSNAMES.ORA and delete this entry

    example ...you new TNSNAMES.ORA

    DWT.WORLD =

    (DESCRIPTION =

    (ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = sdr3bw4)(Port = 1553))

    (CONNECT_DATA =

    (SID = DWT)

    (GLOBAL_NAME = DWT.world)

    )

    )

    LISTENER_DWT.WORLD =

    (ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = sdr3bw4)(Port = 1553))

    Regards,

    Eva Belén Garcia

    Add comment
    10|10000 characters needed characters exceeded