• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 64 subscribers
  • Views 806 views
  • Users 0 members are here
Options
Related

Synchronization Service - Oracle Connections

Gégé
over 2 years ago 
Hello all,

I am trying to configure Synchronization Service with a connection with an Oracle database in order to update user attributes from the Oracle database.

So I added the "Oracle Database Connector" in Synchronization Service.

I have the following error message:
The specified SQL Server instance cannot be contacted.
Details: ORA-12154: TNS: Could not resolve specified connection identifier
ORA-12154: TNS: Unable to resolve specified connection identifier

I read in the documentation, that it is necessary to install:
Oracle Client.
Oracle Net Services
Oracle Data Provider for .NET

Could someone who has set up the Oracle connector tell me where to find the prerequisites, and how to install them?
I can't find any information ...

Thank you in advance for your help.
Gégé
  • 0 over 1 year ago

    Has this issue been resolved? i have the same issue with version 7.6.1

  • 0 over 1 year ago

    The Oracle client requires a "profile" (conceptually similar to a Windows user desktop profile) for the Synchronization Service account.

    Easiest thing to do is to log in as your Sync Service account when you install the oracle client.

    Within the client configuration (i.e. the profile mentioned above), there is a configuration file where you define things like the server name / IP, database name etc.

    The file containing the configuration data is TNSNames.ORA.

    The location of the Oracle configuration file must be specified in an environment variable called TNS_ADMIN that is setup / visible to the user profile of all users logging into the host equipped with the Oracle client.

    A sample TNSNames.ORA file is shown below:

    <Your application Name> =

    (DESCRIPTION =

        (ADDRESS= (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = <port number)  (CONNECT_DATA =

          (SERVER = DEDICATED)

          (SERVICE_NAME = <database / catalog name>)

       )

    )