Error: ORA-01017: invalid username/password; logon denied

Products

• Information Centric Analytics

Issue/Introduction

The Run Staging Procedures step (4) of the nightly RiskFabric Processing job and the RiskFabric Intraday Processing job fails and logs the following error message:

Error Msg: Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "RISKFABRIC_DLP_RISKFABRIC_<Oracle-database-server-hostname>".

An attempt at directly connecting to the Symantec DLP database server using the credentials of the linked server returns the following error message:

Error: ORA-01017: invalid username/password; logon denied

Resolution

Update the data source credentials of the Symantec DLP data source connection by following this procedure:

1. Navigate in the Risk Fabric console to Admin > Integration > Data Sources > Choose Data Source | Symantec Data Loss Prevention
2. Click the edit icon to edit the settings of the affected server
   The Edit Connection Settings window opens
3. Click the Next button to navigate to the Database Settings page
4. Under the Symantec Data Loss Prevention Credentials heading, update the Username and/or Password
5. Click the Next button to navigate to the end of the connection settings wizard and save the updated credentials