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:
Steps to test the connection to the DLP database using SQLPlus using the connection elements found in the jdbc.properties file.
Note: However, that this test does not prove that JDBC is able to connect to the database.
Finally, using tnsping does not mean that you can connect to the database. It merely means that you can connect to the listener for the database.
A tnsname.ora entry can be modified to become a jdbc.properties entry, like so:
Take a tnsnames.ora entry:
PROTECT2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.66.193.149)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = protect)
)
)
Remove the alias line:
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.66.193.149)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = protect)
)
)
Remove all (ALL) spaces:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.66.193.149)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=protect)))
Put an "@" in front of it and it's ready for jdbc.properties.