Point Enforce console to a new or moved Oracle server

book

Article ID: 159535

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

How to change the database connection information when the database has moved.

How to point Enforce console to a new or moved Oracle server.

Resolution

Relevant version:  All

The database connection information is stored in the jdbc.properties file. The jdbc.properties file can be found in the <drive>:\Vontu\Protect\config\ OR <drive>:\SymantecDLP\Protect\config\ directory.

The following lines should be updated to reflect the new hostname.  No other changes are necessary from the Symantec DLP application perspective.

[email protected](description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(connect_data=(sid=protect)))

[email protected](description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(connect_data=(sid=protect)))

This assumes the username and password has not changed. 

Note:  As of 7.0 and above:

  • You cannot directly edit the jdbc.dbalias.oracle attributes
  • Only the Oracle-Thin attribute noted above needs to be changed