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

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

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

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
原因

The error indicates a misconfiguration in the ODBC Proxy.
解决办法
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

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

标题