Smart Data Access oracle - segmentation Fault

[Former Member]

Hello everyone,

For a solution in my company I want to use "Smart Data Access" as the replication tool of Oracle DB tables in SAP HANA DB. When i am trying to configure smart data access i am getting error segmentation fault, connection reset and index server crashes - restarts with out of memory dump.

Here is how i configured our landscape.

1. Oracle Database on windows 2012 server with database created.

2. installed unixodbc 2.3.4 on hana box.

3. HANA is SPS10 - even upgraded it to SP12 as it is a sandbox to check if it can solve the issue with no luck.

4. installed oracle 12c related client and odbc drivers on hana box

5. configured TNS_ADMIN path

5. configured .customer.sh in sidadm of hana box.

6. configured .odbc.ini in SIDADM of hana box.

Here is how my .odbc.ini entry for oracle looks link

[ORCL]

Driver=/usr/oracle/product/12.1.0/client_1/lib/libsqora.so.12.1

ServerName=ORCL

This is how my .customer.sh looks like

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib64/

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib64/

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/SAPDEPOT/unixODBC-2.3.2/unixODBC-2.3.2

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/oracle/product/12.1.0/client_1/lib

export TNS_ADMIN=/etc/oracle

export ODBCINI=$HOME/.odbc.ini

This is how my tnsnames.ora looks like

# tnsnames.ora Network Configuration File: F:\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = fully qualified host name )(PORT = 1522))

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = fully qualified host name)(PORT = 1522))

    (CONNECT_DATA =

(SERVER = DEDICATED)

      (SERVICE_NAME = orcl.domain.net)

    )

  )

When i try to create connection in smart data access in hana studio, connection wil lget created and immediately failes to fetch data and we get the following error and index server crashes with out of memory issue.

Data receive failed[connection receive failed]

when i do isql -v ORCL

I get the following error.

isql -v ORCL

Segmentation fault

Can some one help me to let me know what i am missing.

[JamesZ]

Hi Hemanth,

I think you can get further help from hana scn group， because so far this error has nothing to do with oracle. We as oracle resource have no idea how this works.

Or can you get some oracle error code? ORA-XXXXX?

Best regards,
James

[Former Member]

Hi, Can some one share if you have any solution for the problem posted by me? Any known solution from your end?

[former_member195792]

Hi Hemanth,

Did you ever solve this issue?
I'm getting the error Segmentation fault on our Linux HANA system, trying to test the SDA connection to an Oracle database  (isql -v DSN)

Best regards,

Menno