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

  1. Open Computer Proprieties

  2. Go to Advanced system settings

  3. Open Environment Variables

  4. In System Variables edit/add TNS_ADMIN with value: C:\instantclient_12_2

  5. In Path tab add C:\instantclient_12_2

  6. Install Microsoft Visual C++ 2013 X86 Redistributable 12.0.40660

  7. 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)

    ​ )

    ​ )

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

  9. Setup as shown below

11

12

13

14

15