"SQLAllocHandle on SQL_HANDLE_ENV fail" when attempting to gather Oracle Standard Audit trail with an ODBC Proxy (4314745)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

"SQLAllocHandle on SQL_HANDLE_ENV fail" when attempting to gather Oracle Standard Audit trail with an ODBC Proxy
Beschreibung

When attempting to gather Oracle Standard Audit trail with an ODBC Proxy, an error similar to the following is recorded in the failed gathering session:

Errors encountered at data collection. ADC Error: Failed to collect from network object. (Internal error: Failed to enumerate event logs. (Cannot connect to specified database.[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV fail
Ursache

The error indicates a misconfiguration in the ODBC Proxy.
Lösung
Verify the following:
1. Ensure the 32 bit Microsoft ODBC driver for Oracle is installed on the server used as an ODBC Proxy (cannot be the 64-bit driver)
2. The tnsnames.ora file is configured as expected using a format similar to the format shown in the following guide:
InTrust 11.4.2 - Preparing for Auditing Oracle (quest.com)
1. The Connection string in the datasource used on the InTrust server references the TnsName in the tnsnames.ora file
2. Verify that the Oracle_Home Bin directory path is in the Windows Environment variable Path on the server used as an ODBC Proxy
3. On the ODBC Proxy server, verify that Authenticated Users have Read and write permissions on the Oracle_Home Bin directory

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel