Test the Oracle database connection string used by DLP Enforce
Last Updated February 07, 2019
Need steps to test the Oracle database connection string found in the the jdbc.properties file on the Symantec Data Loss Prevention (DLP) Enforce server to ensure the elements within the connection string are correct.
Connecting to Oracle:
Various ways to use sqlplus:
sqlplus /nolog - provides access to utilize sqlplus. The "/nolog" parameter means "start sqlplus, but do not log into a database"
sqlplus bleep/blop@blorp - means start sqlplus, log into database as defined in tnsnames.ora under alias "blorp", using database account "bleep" and password "blop"
sqlplus bleep/blop - means start sqlplus and log into database as defined either by default (the case of when the database is local) or using environment variables and defaults. The environment variable ORACLE_SID provides the database name, the host is the local machine and the port is, by default, 1521.
sqlplus bleep - means start sqlplus and connect to default database using account "bleep". Then prompt for password. The advantage here is that the password is not displayed as typed.
Steps to test the connect to the DLP database using sqlplus and the connection elements found in the jdbc.properties file.
Go to Vontu/Protect/config.
Open Jdbc.properties in a text editor such as notepad and look for the parameter "jdbc.dbalias.oracle-thin". This is what DLP uses to connect to the Oracle db.
Copy the string from this parameter starting with "@", all the way to the end of the line.