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
:
Windows
SERVICE_NAME
in the 'Service Name' field on the Oracle Database panel of the installation wizard.ORACLE_SERVICE_NAME
parameter during the Silent Mode installationLinux (Red Hat)
SERVICE_NAME
at the 'Enter Service Name' line in the Enforce Server Configuration UtilityWindows and Linux (Red Hat)
Before you upgrade to Symantec Data Loss Prevention 15.1, you must switch the Oracle SID
to SERVICE_NAME
. You cannot complete the migration process if you do not switch to the SERVICE_NAME
parameter.
To switch from SID
to SERVICE_NAME
, you update the tnsnames.ora
file to point to the SERVICE_NAME
, and then register the service name change on the database.
Switching from SID
to SERVICE_NAME
:
tnsnames.ora
file$ORACLE_HOME/network/admin/tnsnames.ora
$ORACLE_HOME\network\admin
tnsnames.ora
filelsnrctl
and continue on to the next steptnsnames.ora
fileSID
to SERVICE_NAME
for the protect value, where protect is your current SID
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
vi ~/.bash_profile
export ORACLE_SID=protect
sqlplus /nolog
conn sys/protect as sysdba
alter system set service_names= 'protect' scope=both;
SERVICE_NAME
alter system register;
SERVICE_NAME
parameter that connects to the Oracle Database. The SERVICE_NAME
value protect displays in the command prompt.