2EETW169 no connect possible: "DBMS = ORACLE

[jorge_velasquez]

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

[Former Member · Accepted solution]

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

[former_member204080 · Accepted solution]

Hi,

What is the kernel version you are on

Could you please paste the env variables set for SIDADM

Regards,

Murali

[jorge_velasquez · Accepted solution]

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