Results 1 to 2 of 2

Thread: Attunity Error in SSIS - "OCI Error Encouneterd"

  1. #1
    SQLDev198155 is offline Junior Member
    Join Date
    Mar 2013
    Posts
    1
    Rep Power
    0

    Attunity Error in SSIS - "OCI Error Encouneterd"

    I have SSIS BIDS (SQL Server 2008) (32 bit), and am using Attunity connector to connect to an Oracle DB. A while back we had our systems upgraded to windows 7 64 bit.
    I have installed Oracle 11g client on my machine, added TNS entries for the above Oracle server that Iam trying to connect to, and also pointed this path (path for TNSNames.ORA) in the "PATH" windows environment variable as well as "TNS_ADMIN" (which I created) environment variable.
    Even after doing all this, I get the following error when validating the Attunity Oracle source connector, the error is as follows:
    "OCI Error Encouneterd. ORA-12154: TNS could not resolve the connect identifier specified, Test connection failed".
    I also researched that this might be due to paranthesis in the path for devenv.exe (BIDS).... So I went through the following post, installed JUNCTION, and created a junction pointing to the actual directory for devenv.exe.
    http://danieladeniji.wordpress.com/2011/08/03/microsoft-sql-server-integration-services-attunity-error-oci-error-encountered-ora-12154-tnscould-not-resolve-the-connect-identifier-specified/
    This too has not resolved the problem....
    Any help appreciated!!

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi,

    BIDS runs in 32-bit mode, therefore you need to define the TNS name also in the 32-bit Oracle client environmnet.

    As alternative, you can specify the Oracle connection string in the following format: host[:port][/service name] instead of the TNS name.


    Regards,


    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •