Help Center
News
Help Center
News
Popular
Architecture and High-level Information
Scans
Agents
How to Use Dashboards
How to Use Data Asset Inventory
How to Install\Uninstall and Set Up Spirion Sensitive Data Platform
How to Use Logs
How to Manage Users and Roles
Settings and Resources
Additional Resources
Reports
Reporting API
Customer Support Articles
How to Follow Data Through the Search PipelineEndpoint for Windows Configuration Reference GuideEndpoint Software Command Line InterfaceBasic Troubleshooting Steps (Enterprise Console)Endpoints or Results Fail to be Displayed in the ConsoleMongoDB and TLS 1.3SQL Client SQL Exception ErrorHow to Troubleshoot Spirion Client Search Failures and How to WhitelistCustomer Notice – Spirion Agent Update & Security Assessment for PostgreSQLHow to Enable Verbose/Debug Logging for the Endpoint ServiceHow can I monitor the status of a queue job?Can I monitor the job queue status automatically?Troubleshooting: "Unable to find job queue: search_queue"How to Verify the Discovery Agent's StatusHow to check if port 6433 is open on your networkWhat is the SDM Translator Service?How to Create a Single Tenant App for OneDrive and Exchange Online SearchesHow to Configure Spirion for Sybase DiscoveryHow to Use Certificates to Authenticate with SharePoint OnlineHow to Quarantine to a Remote Location Using Spirion Sensitive Data PlatformA Server Error has Occurred: How to use the Chrome Developer ToolsWhy doesn't my Oracle 19c Database scan?How to Enable Full Disk Access on a Mac AgentWhy is My Scan Node Running Out of Disk Space?What to do about Message Processing and Delays, also known as 'Lag,' in SpirionDetails About the Box API used by Spirion to Search Box AccountsHow to Build a Mac Package (PKG)How to Sanitize AgentsHow to Set User and Role AccessHow to Enable SSL Communication between Linux Agents and the Spirion ConsoleHow to Enable HTTPS for the Spirion ConsoleHow to Search BoxFAQ: How do I avoid being prompted to re-login to the Spirion console?Spirion Sensitive Data Platform Scan PerformanceHow to Authenticate to SharePoint On-PremiseHow to Configure Spirion Sensitive Data Platform to Connect to an Oracle DatabaseFAQ: Linux 12.5 Client Package Build WorkaroundTroubleshoot Exchange Online Using Microsoft Graph ExplorerFAQ: What to do when an agent will not start the discovery team scan?Required SQL Server PermissionsHow to Scan Microsoft Teams with Spirion Sensitive Data PlatformField Input Using Linux Machines Anti-virus Alerts Received during Spirion SearchVersion 13.6 MSI Installation Issues - Exe file not signedWhat are common firewall rules needed for distributed scans?
Release Notes

How to Configure Spirion Sensitive Data Platform to Connect to an Oracle Database

Prepare Windows server to scan Oracle databases using the Spirion Sensitive Data Platform.

Overview

This article provides a step-by-step guide on how to prepare Windows server to scan Oracle databases using Spirion Sensitive Data Platform.

  • Windows Server should be installed and configured as per Spirion’s Best Practice. 
  • The first part of the document is to install the Oracle Instant Client onto the server.
  • The second part is installing the Spirion agent if it has not been done already.
  • Note: they do not have to be installed in any particular order. The third and last part of the document will describe the connection process.
  • For a sample Oracle Connection String see the documentation.

In This Article

  • Installing Oracle on a Spirion Discovery Server
  • Configuring Spirion to Scan Oracle Databases

How to Install Oracle on a Spirion Discovery Server

Procedure:

  1. Download the appropriate Instant Client 64-bit packages for your platform.
  3. Unzip the packages into a single directory such as: C:\oracle\instantclient_19_3
  4. Add this directory to the PATH environment variable.
    1. If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path.
    2. Restart any terminal windows or otherwise make sure the new PATH is used by your applications.
  6. Click the Windows Start menu and search for Advanced system settings. Click the option that appears as shown below.
  7. In the dialogue that appears, select Environment Variables.
  8. Click on Path -> Edit…
  9. Click New -> Browse
  10. Browse down to the folder InstantClient_##_## under the Oracle directory.
  11. Click OK on all open windows thereafter to save your settings.                              
  12. Download and install the correct Visual Studio Redistributable from Microsoft. Instant Client 19 requires the Visual Studio 2017 redistributable.
  13. Restart any terminal windows or otherwise make sure the new PATH is used by your applications.

How to Download and Install the Latest Spirion Agent

Download the latest Spirion Agent from the Spirion Sensitive Data Platform console:

  1. Open Spirion Sensitive Data Platform.
  2. Select Agents from the left menu.
  3. Select Installation.
  4. Download the latest Spirion MSI package.
  5. Install the Agent onto the Windows server by double-clicking the MSI just downloaded.
  6. Click Next.
  7. Click Next.
  8. Click Typical unless you require the installation files to be on another drive letter then select Custom.
  9. Click Install
  10. Wait for the installation to complete.
  11. Then click Finish.
  12. Close the agent after opening it as this interferes with any scans initiated by SDP.

How to Configure Spirion to Scan Oracle Databases

We now cover the process of configuring Spirion to scan the Oracle Database.

  • During the process, you may need your license key if the agent is being installed for the first time.
  • You will require either the Oracle Connection information from the DBA or have the DBA present during the configuration. 
  • Required information can be found in step 7.

Procedure:

  1. Open the Spirion Agent by clicking on the Spirion App icon.
  2. Enter the password.
    1. If no password has been created:
      1. Create a password unique to this agent
      2. Else, continue as a guest
      3. Note: If you continue as a guest none of the settings will be saved to the agent and will have to be readded if needed.
  4. Select Location->Databases->Enable Database Search.
  5. Select Location->Databases->Customize Database Settings.
  6. Ensure that the database type selected is Oracle, otherwise click the drop-down menu and select the Database Type from the list.

  7. Once the Database Type is selected click Configure.

  8. Enter in the Database connection information as per the Oracle DBA.

  9. Click the Test Connection button to ensure that the settings are correct.
    1. If this fails, troubleshoot the issue with your database administrator.

  11. Click OK.
  12. Click and highlight the newly created connection string.

  13. The full connection string now appears above.
  14. Highlight and copy the string of text as shown in the image.
    1. This information will be entered into the Spirion Sensitive Data Platform Console to search the Oracle Database.
  16. Open the Spirion Sensitive Data Platform console and select Data Asset Inventory.
  17. Then select Data Assets and Targets.
  18. Now select Targets.
  19. Then select Add Target.
  20. Enter a Target name that makes sense to your organization.
  21. Then select Database.
  22. Now select the Oracle button. 

  23. Paste the connection string we generated in the Spirion Agent in step 10 and then click Save.

  24. The Oracle Database Server is now configured to be scanned by Spirion.


Was this article helpful?

Powered by Product Fruits