Symantec Data Loss Prevention version 15.1 (downloaded starting on 21 September 2018) 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. 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.