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_NAME in the 'Service Name' field on the Oracle Database panel of the installation wizard.
ORACLE_SERVICE_NAME parameter during the Silent Mode installation
Linux (Red Hat)
SERVICE_NAME at the 'Enter Service Name' line in the Enforce Server Configuration Utility
Windows and Linux (Red Hat)
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
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.
lsnrctl and continue on to the next step
SERVICE_NAME for 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_NAME parameter that connects to the Oracle Database. The
SERVICE_NAME value protect displays in the command prompt.