Error calling OCIServerAttach for database on upgrading Enforce server

Products

• Data Loss Prevention
• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

You are upgrading the DLP Enforce Server to 15.x/16.x from a prior version. You are able to connect to the Oracle DB using SQLPlus, but when you run the Symantec Data Loss Prevention 15.x/16.x Enforce Server set up MSI, you receive the error: 

 

Error calling OCIServerAttach for database <//IPADDRESS:PORT/ServiceName>: ORA-12154: TNS:could not resolve the connect identifier specified.
Note that the values in the angle brackets will reflect those of your environment. 

 

Cause

Multiple: 

1. You have not installed the Administrator version of the client
2. You have installed the x86 version of the Oracle client instead of the x64 version
3. EZ connect is not possible if NAMES.DIRECTORY_PATH parameter is used in SQLNet.ora file

Resolution

 

If you have installed the non-Administrator version or have installed the incorrect processor architecture version, follow the steps below: 

1. Uninstall the Oracle Client on the Enforce server

2. Reboot the server

3. Install the Oracle Client provided by Symantec for the version of Oracle you are running

4. On the Select Installation Type, be sure to select the ‘Administrator’ button during the installation 

 

 

If you have installed the Administrator Oracle client and the correct processor architecture version and are still receiving the error, follow the steps below: 

1. Navigate to <InstallPath>\product\<version>\client_1\network\admin\  - (The path will differ based upon your version.)
2. Edit the sqlnet.ora file
3. Comment out the NAMES.DIRECTORY_PATH line as shown below (# denotes a comment)

# This file is actually generated by netca. But if customers choose to

# install "Software Only", this file wont exist and without the native

# authentication, they will not be able to connect to the database on NT.

 

SQLNET.AUTHENTICATION_SERVICES = (NTS)

# NAMES.DIRECTORY_PATH= (TNSNAMES)

4. Save the file and retry the installation