URT fails Unable to establish db connection for user protect - invalid connection identifier.

Products

• Data Loss Prevention

Issue/Introduction

URT fails Unable to establish db connection for user protect - invalid connection identifier.

Cause

tnsnames.ora has a preample record overriding the service identifier. 

TNS_ADMIN environment variable not set and multiple instances of the oracle client exist. 

Resolution

Review the environment variables.

Oracle client default tnsnames.ora location: C:\app\client\product\19.0.0\client_1\network\admin

Look for the ORACLE_HOME location verify that the tnsnames.ora is formatted correctly:

PROTECT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = protect)
    )
  )

In this case PROTECT= is the identifier you would use to connect using URT. In some cases admins may choose to change this to something else like:

PROTECT_My_custom_identifier =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = protect)
    )
  )

In this case you would enter PROTECT_My_custom_identifier for the database service name.

Case 2:

If there is multiple installs of the oracle client you will need to set the TNS_ADMIN system variable to your active location for the tnsnames.ora. Otherwise oracle will use the default location which may not be the same one your actively using.