Purview cannot connect to Oracle 11

John Broomfield 5 Reputation points
2023-06-15T04:53:40.7+00:00

We followed the instructions to connect to scan an Oracle 11c database in Purview and we are getting the following error:

User's image

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,389 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,541 Reputation points
    2023-06-15T13:25:49.0433333+00:00

    @John Broomfield - Thanks for the question and using MS Q&A platform.

    The error message "Oracle 11 Error code: (27001) The remote server returned an error 403 Forbidden" typically indicates that the user or application attempting to access the Oracle database does not have the necessary permissions to perform the requested operation.

    To resolve this issue, you should check the following:

    1. Verify that the user or application has the necessary permissions to access the Oracle database. This may involve checking the user's roles and privileges in the database, as well as any firewall or network settings that may be blocking access.
    2. Check the Oracle database logs for any additional information about the error. The logs may provide more details about the specific operation that is failing and the reason for the 403 Forbidden error.
    3. Ensure that the Oracle database is configured to allow remote connections. This may involve configuring the database listener and network settings to allow connections from the IP address or hostname of the machine running the application.

    For more details, refer to Connect to and manage Oracle in Microsoft Purview - Required permissions for scan.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.