Skip to Content
avatar image
Former Member

2EETW169 no connect possible: "DBMS = ORACLE

Hi Experts,

I have an error testing R3trans -d

4 ETW000  [     dev trc,00000]  Substitution of aliases T_nn (n=0...9) in SQL hints enabled.              60  0.017741

4 ETW000  [     dev trc,00000]  DIR_CLIENT_ORAHOME is not set as profile nor env. parameter.             160  0.017901

4 ETW000  [     dev trc,00000]  Register application info.                                                61  0.017962

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => Couldn't initialize Oracle client, please check installation!

4 ETW000                                                                                                 274  0.018236

4 ETW000  [     dev trc,00000]     DbSlConnect(con=-1) -> orc=0, rc=18=DBSL_ERR_CONNECT                   24  0.018260

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        23  0.018283

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        18  0.018301

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                     18  0.018319

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                    25  0.018344

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  19  0.018363

4 ETW000  [     dev trc,00000]                 -> 'OCI_11201_SHARE, '                                     18  0.018381

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

Notwithstanding ERP System is up and working properly.

OS SAP: Windows

OS ORACLE: LINUX

Any clue?

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 24, 2014 at 02:08 AM

    Hi,

    First I think you should have a look at sap note 998004.

    998004 - Update the Oracle Instant Client on Windows

    Please check if the client setting/installation is correct on Windows server.

    Best regards,

    Daniel

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member murali reddy

      Hi,

      I have last kernel 742 patch 32.

      As I explained SAP is up and running. I need this to be fine for SUM tool to update our ERP. R3trans shows 0012.

      ERP (DEV and QAS) are configured in the same way.

      C:\Users\PRDadm>SET | more

      ALLUSERSPROFILE=C:\ProgramData

      APPDATA=C:\Users\PRDadm\AppData\Roaming

      CLIENTNAME=(HOSTNAME)

      CommonProgramFiles=C:\Program Files\Common Files

      CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

      CommonProgramW6432=C:\Program Files\Common Files

      COMPUTERNAME=(HOSTNAME)

      ComSpec=C:\Windows\system32\cmd.exe

      DBMS_TYPE=ora

      dbs_ora_schema=SAPPRD

      dbs_ora_tnsname=PRD

      DEFLOGDIR=C:\ProgramData\McAfee\DesktopProtection

      FP_NO_HOST_CHECK=NO

      HOMEDRIVE=C:

      HOMEPATH=\Users\prdadm

      NLS_LANG=AMERICAN_AMERICA.UTF8

      NUMBER_OF_PROCESSORS=4

      ORACLE_SID=PRD

      OS=Windows_NT

      Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32

      \WindowsPowerShell\v1.0\;E:\usr\sap\PRD\SYS\exe\uc\NTAMD64

      PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

      rsdb_ssfs_connect=1

      RSEC_SSFS_DATAPATH=\\hostname\sapmnt\PRD\SYS\global\security\rsecssfs\data

      RSEC_SSFS_KEYPATH=\\hostname\sapmnt\PRD\SYS\global\security\rsecssfs\key

      SAPEXE=E:\usr\sap\PRD\SYS\exe\uc\NTAMD64

      SAPLOCALHOST=hostname

      SAPSYSTEMNAME=PRD

      SAP_DIR_PERF=C:\usr\sap\PRFCLOG

      SESSIONNAME=RDP-Tcp#0

      SystemDrive=C:

      SystemRoot=C:\Windows

      TEMP=E:\usr\sap\PRD\tmp\2

      TMP=E:\usr\sap\PRD\tmp\2

      TNS_ADMIN=\\hostname\sapmnt\PRD\SYS\profile\oracle

      UATDATA=C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77

      USERDNSDOMAIN=domain.com

      USERDOMAIN=domain

      USERNAME=PRDadm

      USPRDROFILE=C:\Users\PRDadm

      VSEDEFLOGDIR=C:\ProgramData\McAfee\DesktopProtection

      windir=C:\Windows

      windows_tracing_flags=3

      windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log

      Windows: SAP

      Linux: Oracle RAC

      This is tnsnames.ora


      PRD.WORLD =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS =

              (COMMUNITY = SAP.WORLD)

              (PROTOCOL = TCP)

              (HOST = hostname)

              (PORT = 1521)

            )

          )

          (CONNECT_DATA =

            (SERVICE_NAME = PRD)

            (GLOBAL_NAME = PRD.WORLD)

          )

        )

      PRD001.WORLD =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS =

              (COMMUNITY = SAP.WORLD)

              (PROTOCOL = TCP)

              (HOST = hostname)

              (PORT = 1521)

            )

          )

          (CONNECT_DATA =

            (SID = PRD001)

            (GLOBAL_NAME = PRD001.WORLD)

          )

        )

      PRD002.WORLD =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS =

              (COMMUNITY = SAP.WORLD)

              (PROTOCOL = TCP)

              (HOST = hostname)

              (PORT = 1521)

            )

          )

          (CONNECT_DATA =

            (SID = PRD002)

            (GLOBAL_NAME = PRD002.WORLD)

          )

        )

      PRD003.WORLD =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS =

              (COMMUNITY = SAP.WORLD)

              (PROTOCOL = TCP)

              (HOST = hostname)

              (PORT = 1521)

            )

          )

          (CONNECT_DATA =

            (SID = PRD003)

            (GLOBAL_NAME = PRD003.WORLD)

          )

        )

      Regards