Purview unable to connect to Oracle DB - Metadata Ingestion Failed

Question

I am trying to scan and catalog an Oracle DB using Purview Oracle connector.

We went through all the steps, setting the SHIR, granting the permissions in the DB, testing the connection (it went through), but when we ran the scan, the Metadata Ingestion step Failed without error message, so I have no clue how to even troubleshoot.

The scan itself does not fail, instead it keeps running indefinitely (one of the attempts I left running for over 3 days before canceling it).

Does anyone have any clue what might be the issue? Thanks!

Answer 1

@Danrlei Alves

Thanks for reaching out to Microsoft Q&A.

Here are a few steps you can take to troubleshoot the issue:

1. Check Permissions: Ensure that the Oracle user has the necessary permissions. The user should have read access to system tables and the SELECT_CATALOG_ROLE role assigned.
2. Verify SHIR Configuration: Make sure the Self-Hosted Integration Runtime (SHIR) is correctly configured and running. Check the SHIR logs for any errors.
3. JDBC Driver: Confirm that the Oracle JDBC driver is correctly installed and accessible by the SHIR. The driver should be in a location that the SHIR service account can access.
4. Event Viewer Logs: Look at the Windows Event Viewer logs on the machine where SHIR is installed. This can provide more detailed error messages that might not be visible in the Purview portal.
5. Network Issues: Ensure there are no network issues or firewall rules blocking the connection between Purview and the Oracle database.
6. Review Documentation: Go through the Microsoft Purview documentation for any additional prerequisites or steps that might have been missed.

I hope the above steps will resolve the issue, please do let us know if issue persists. Thank you