Skip to content

How to configure ODBC client to collect from Oracle DB instances

To collect log events from a Oracle database audit table, the following prerequisits must be met:

1) Download instantclient-basic-nt-12.2.0.1.0.zip and instantclient-odbc-nt-12.2.0.1.0.zip

2) Extract both archives to C:\instantclient_12_2

3) Open CMD Command Prompt as Administrator

4) Run odbc_install.exe

5) Open Computer Proprieties

6) Go to Advanced system settings

7) Open Environment Variables

8) In System Variables edit/add TNS_ADMIN with value: C:\instantclient_12_2

9) In Path tab add C:\instantclient_12_2

10) Install Microsoft Visual C++ 2013 X86 Redistributable 12.0.40660

11) Create file tnsnames.ora in folder C:\instantclient_12_2 and edit it with TNS Instance setting

  dbInstance=

  (description=

    (address_list=

  ​         (address = (protocol = TCP) (host=)(port=))

  ​         )

  ​         (connect_data=

  ​         (service_name= dbInstance)

  ​         )

  ​         )

12) Navigate to C:\Windows\SysWOW64 and run odbcad32.exe

13) Setup as shown below

11

12 13

14 15