Customer Support Language
 
HomeKnowledge BaseCampaign CSiOracle configuration settings for Campaign Report Tool
Information
Article ID181
Created On2/1/2010
Modified2/1/2010
Share With Others
Oracle configuration settings for Campaign Report Tool
On some systems that are accessing Oracle via the TNSNAMES.ORA configuration files (used by Campaign CSi software v4) and via the EZCONNECT method (used by Campaign Report Tool), users may need to set configuration in SQLNET.ORA as follows:

NAMES.DIRETORY_PATH = (TNSNAMES, EZCONNECT)

If this setting is not made, the Campaign Report Tool may give the following error:

ORA-12154: Could not resolve the connect identifier

This is unexpected because the EZCONNECT method is documented by Oracle as requiring no registry entries or configuration files.  Indeed, the Campaign Report Tool is able to connect successfully on machines that do not have the Campaign CSi software installed.  It appears the addition of the older Oracle drivers to a machine causes the SQLNET.ORA file to be read even when using EZCONNECT.  In this case, the NAMES.DIRETORY_PATH must contain the EZCONNECT entry or the connection fails.