Symantec Data Loss Prevention version 15.1 (downloaded starting on 21 September 2018) and newer, uses the
SERVICE_NAME parameter to connect to the Oracle database.
This support applies to new installations and upgrades to Symantec Data Loss Prevention 15.1 and newer.
When you install the Enforce Server, you define a
SERVICE_NAME for the Oracle database. You no longer use a
System Identification Number (SID).
If you upgrade to Symantec Data Loss Prevention 15.1, you need to switch from
SID to the
SERVICE_NAME parameter before you begin the migration process.
Enforce Server fields or parameters used to define the
SERVICE_NAMEin the 'Service Name' field on the Oracle Database panel of the installation wizard.
ORACLE_SERVICE_NAMEparameter during the Silent Mode installation
Linux (Red Hat)
SERVICE_NAMEat the 'Enter Service Name' line in the Enforce Server Configuration Utility
Before you upgrade to Symantec Data Loss Prevention 15.1, you must switch the Oracle
SERVICE_NAME. You cannot complete the migration process if you do not switch to the
Windows and Linux (Red Hat)
To switch from
SERVICE_NAME, you update the
tnsnames.ora file to point to the
SERVICE_NAME, and then register the service name change on the database.
lsnrctland continue on to the next step
SERVICE_NAMEfor the protect value, where protect is your current
PROTECT = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = protect) ) )
Registering the service name:
If on Linux, export data for the SID by running the following command:
su - oracle
conn sys/protect as sysdba
alter system set service_names= 'protect' scope=both;
alter system register;
SERVICE_NAMEparameter that connects to the Oracle Database. The
SERVICE_NAMEvalue protect displays in the command prompt.