ERROR => Couldn't initialize Oracle client, please check installation!

[former_member229542]

Hi Guys

After Upgrading and migrating a NW 7.31 System to NW 7.4 SP based in HANA, Im getting the following message regarding an external Oracle Database.

App Server is still Windows, so all kernel archives are for Windows.

Environment Variables all are OK,

Mind that this Database connection was working before System Upgrade

I thought it was related to lib_dbsl files, so I downloaded latest Oracle lib_dbsl for Windows X64 Platform, but still failing

Is if possible that Kernel 7.42 or NW 7.4 SP 12 is not compatible with Oracle 11.2.0.4 Client?

Best

Martin

B Thu Nov 26 17:55:36 2015

B  Loading DB library 'K:\usr\sap\BWX\DVEBMGS00\exe\dboraslib.dll' ...

B  Library 'K:\usr\sap\BWX\DVEBMGS00\exe\dboraslib.dll' loaded

B  Version of 'K:\usr\sap\BWX\DVEBMGS00\exe\dboraslib.dll' is "742.06", patchlevel (0.310)

B  Connect to QAS_DBCONN as bw_sapsgf with UYCLS86

C  dbs/ora/array_buf_size = 130000

C  dbs/ora/stmt_cache_size = 250

C  Register application info.

C  *** ERROR => Couldn't initialize Oracle client, please check installation!

[dbsloci.c    2272]

C  {root-id=005056A66C961EE5A58F26A81D940B67}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYI=> connect failed for connection QAS_DBCONN [dbds         981]

B  ***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds       1985]

[Former Member · Accepted solution]

Hi Martin,

I know you said you've checked the environment variables. Could you humour me nonetheless and post the output of SET from a command window. The path to your Oracle Client should be present.

Cheers,

Amerjit

[former_member229542 · Accepted solution]

HI Amerjit, see below Environment Variables.

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\

;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\

;C:\Program Files\Microsoft SQLServer\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\

;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\

;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\

;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;K:\usr\sap\BWX\DVEBMGS00\exe

;K:\usr\sap\BWX\SYS\exe\uc\NTAMD64;K:\usr\sap\BWX\hdbclient

;K:\oracle\client\instantclient

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

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 62 Stepping 4, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=3e04

ProgramData=C:\ProgramData

ProgramFiles=C:\Program Files

ProgramFiles(x86)=C:\Program Files (x86)

ProgramW6432=C:\Program Files

PROMPT=$P$G

PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\

PUBLIC=C:\Users\Public

SAPEXE=K:\usr\sap\BWX\DVEBMGS00\exe

SAPLOCALHOST=UYCLSxxx

SAPSYSTEMNAME=BWX

SAP_DIR_PERF=K:\usr\sap\PRFCLOG

SESSIONNAME=RDP-Tcp#0

SystemDrive=C:

SystemRoot=C:\Windows

TEMP=K:\usr\sap\BWX\tmp\2

TMP=K:\usr\sap\BWX\tmp\2

TNS_ADMIN=K:\usr\sap\BWX\SYS\profile\Oracle

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

USERDNSDOMAIN=MDP.LOCAL

USERDOMAIN=MDP

USERNAME=bwxadm

USERPROFILE=C:\Users\bwxadm

VSEDEFLOGDIR=C:\ProgramData\McAfee\DesktopProtection

windir=C:\Windows

windows_tracing_flags=3

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

C:\Users\bwxadm>

[Reagan · Accepted solution]

Put the Oracle Instant Client files in the DIR_CT_RUN location and restart the SAP system.

[former_member229542 · Accepted solution]

Hi Benjamin

Should I put the entire K:\oracle\client\instantclient folder in K:\usr\sap\BWX\SYS\exe\uc\NTAMD64?

Best

Martin

[former_member229542 · Accepted solution]

Awesome!

Is there any SAP note stating about this change?

Best

Martin

[Former Member · Accepted solution]

Hello Martin,

The note that will help you with that is:

998004 - Update the Oracle Instant Client on Windows

It's not a "change" specific to a migration to another DB.

KR,

Amerjit