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

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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

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
Cause

The error indicates a misconfiguration in the ODBC Proxy.
Résolution
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

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 9/25/2015
Dernière mise à jour le : 3/7/2024

Titre