Update Readiness Tool Error: "Unable to establish db connection for user protect - invalid connection identifier."

book

Article ID: 170676

calendar_today

Updated On:

Products

Data Loss Prevention Enforce Data Loss Prevention

Issue/Introduction

The Data Loss Prevention (DLP) Update Readiness Tool(URT) is failing after performing the following steps to prepare the tool.
  1. Grant permissions to "Protect" user see How to Verify or Grant Oracle Database Permissions to Protect User
  2. Create an additional update readiness user
  3. Use the create_user.sql script - see Symantec Data Loss Prevention Upgrade Guide for Linux, Version 15.8 or Symantec Data Loss Prevention Upgrade Guide for Windows, Version 15.8
  4. Transfer the URT zip file to the Enforce server
  5. Unzip the URT contents
  6. Verify connections to Oracle Database for both the protect user and new update readiness user (see step 2), and correct any incorrect usernames and passwords.

Error: unable to establish db connection for user protect - invalid connection identifier.

Cause

The service name used with URT does not resolve to the service_name parameter in the Oracle database.

 

Resolution

Confirm the service_name using one of the following methods

Review the tnsnames.ora file for the service_name. In Oracle the file can be found here: \oracle\product\oracle_version\db_1\NETWORK\ADMIN\tnsnames.ora

Example:

                 

Review the jdbc.properties file on Enforce. The file can be found here: \Protect\config\jdbc.properties

  Example:

                 

Review oracle parameters for the configured service_name via sqlplus.

  1. Open cmd or terminal
  2. run the following command: sqlplus /nolog
  3. Connect to oracle: connect sys as sysdba
  4. Run this query to confirm the service_name parameter: select value from v$parameter where name='service_name';

Example: