You are upgrading the DLP Enforce Server to 15.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 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.
You have not installed the Administrator version of the client
You have installed the x86 version of the Oracle client instead of the x64 version
EZ connect is not possible if NAMES.DIRECTORY_PATH parameter is used in SQLNet.ora file
If you have installed the non-Administrator version or have installed the incorrect processor architecture version, follow the steps below:
Uninstall the Oracle Client on the Enforce server
Reboot the server
Install the Oracle Client provided by Symantec for the version of Oracle you are running (either 11.2.04 or 12.2.01)
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:
Navigate to <InstallPath>\product\12.2.0\client_1\network\admin\
Edit the sqlnet.ora file
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)
Save the file and retry the installation
Subscribing will provide email updates when this Article is updated. Login is required.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
Subscribed to the Article.
Unable to subscribe
Thanks for your additional feedback !!!
Enterprise Support Virtual Agent
Rate Me :
Tell us more:
Welcome! My name is Sami, the Enterprise Support Virtual Agent answering technical support questions.